//------------------------------------------------------------------------------ // // Codice generato da un modello. // // Le modifiche manuali a questo file potrebbero causare un comportamento imprevisto dell'applicazione. // Se il codice viene rigenerato, le modifiche manuali al file verranno sovrascritte. // //------------------------------------------------------------------------------ namespace MedAP_data { using System; using System.Data.Entity; using System.Data.Entity.Infrastructure; using System.Data.Entity.Core.Objects; using System.Linq; public partial class MAPEntities : DbContext { public MAPEntities() : base("name=MAPEntities") { } protected override void OnModelCreating(DbModelBuilder modelBuilder) { throw new UnintentionalCodeFirstException(); } public virtual DbSet Documenti { get; set; } public virtual DbSet DocTemplate { get; set; } public virtual DbSet RigheDoc { get; set; } public virtual DbSet Clienti { get; set; } public virtual DbSet RowTemplate { get; set; } public virtual DbSet ResocontoIvaFatt { get; set; } public virtual DbSet VAT { get; set; } public virtual DbSet KVPlist { get; set; } public virtual DbSet ResGiorn { get; set; } public virtual DbSet ResMens { get; set; } public virtual int stp_docRows_deleteQuery(Nullable original_id) { var original_idParameter = original_id.HasValue ? new ObjectParameter("Original_id", original_id) : new ObjectParameter("Original_id", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docRows_deleteQuery", original_idParameter); } public virtual int stp_docRows_updateQuery(Nullable original_id, string descrizione, string um, Nullable prezzoUm, Nullable qta, Nullable sconto, Nullable c_iva) { var original_idParameter = original_id.HasValue ? new ObjectParameter("Original_id", original_id) : new ObjectParameter("Original_id", typeof(int)); var descrizioneParameter = descrizione != null ? new ObjectParameter("Descrizione", descrizione) : new ObjectParameter("Descrizione", typeof(string)); var umParameter = um != null ? new ObjectParameter("um", um) : new ObjectParameter("um", typeof(string)); var prezzoUmParameter = prezzoUm.HasValue ? new ObjectParameter("prezzoUm", prezzoUm) : new ObjectParameter("prezzoUm", typeof(decimal)); var qtaParameter = qta.HasValue ? new ObjectParameter("qta", qta) : new ObjectParameter("qta", typeof(float)); var scontoParameter = sconto.HasValue ? new ObjectParameter("sconto", sconto) : new ObjectParameter("sconto", typeof(float)); var c_ivaParameter = c_iva.HasValue ? new ObjectParameter("c_iva", c_iva) : new ObjectParameter("c_iva", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docRows_updateQuery", original_idParameter, descrizioneParameter, umParameter, prezzoUmParameter, qtaParameter, scontoParameter, c_ivaParameter); } public virtual ObjectResult stp_docRows_getByIdxDoc(Nullable idxDoc) { var idxDocParameter = idxDoc.HasValue ? new ObjectParameter("idxDoc", idxDoc) : new ObjectParameter("idxDoc", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docRows_getByIdxDoc", idxDocParameter); } public virtual ObjectResult stp_docRows_getByIdxDoc(Nullable idxDoc, MergeOption mergeOption) { var idxDocParameter = idxDoc.HasValue ? new ObjectParameter("idxDoc", idxDoc) : new ObjectParameter("idxDoc", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docRows_getByIdxDoc", mergeOption, idxDocParameter); } public virtual int stp_clienti_delete(Nullable original_idxCli) { var original_idxCliParameter = original_idxCli.HasValue ? new ObjectParameter("Original_idxCli", original_idxCli) : new ObjectParameter("Original_idxCli", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_clienti_delete", original_idxCliParameter); } public virtual int stp_clienti_insert(string ragSoc, string sesso, string pOBirth, Nullable dOBirth, string p_iva, string c_Fisc, string via, string localita, string cap, string provincia, string pagamento, string note, string idxGruppo) { var ragSocParameter = ragSoc != null ? new ObjectParameter("RagSoc", ragSoc) : new ObjectParameter("RagSoc", typeof(string)); var sessoParameter = sesso != null ? new ObjectParameter("Sesso", sesso) : new ObjectParameter("Sesso", typeof(string)); var pOBirthParameter = pOBirth != null ? new ObjectParameter("POBirth", pOBirth) : new ObjectParameter("POBirth", typeof(string)); var dOBirthParameter = dOBirth.HasValue ? new ObjectParameter("DOBirth", dOBirth) : new ObjectParameter("DOBirth", typeof(System.DateTime)); var p_ivaParameter = p_iva != null ? new ObjectParameter("P_iva", p_iva) : new ObjectParameter("P_iva", typeof(string)); var c_FiscParameter = c_Fisc != null ? new ObjectParameter("C_Fisc", c_Fisc) : new ObjectParameter("C_Fisc", typeof(string)); var viaParameter = via != null ? new ObjectParameter("Via", via) : new ObjectParameter("Via", typeof(string)); var localitaParameter = localita != null ? new ObjectParameter("Localita", localita) : new ObjectParameter("Localita", typeof(string)); var capParameter = cap != null ? new ObjectParameter("Cap", cap) : new ObjectParameter("Cap", typeof(string)); var provinciaParameter = provincia != null ? new ObjectParameter("Provincia", provincia) : new ObjectParameter("Provincia", typeof(string)); var pagamentoParameter = pagamento != null ? new ObjectParameter("Pagamento", pagamento) : new ObjectParameter("Pagamento", typeof(string)); var noteParameter = note != null ? new ObjectParameter("Note", note) : new ObjectParameter("Note", typeof(string)); var idxGruppoParameter = idxGruppo != null ? new ObjectParameter("idxGruppo", idxGruppo) : new ObjectParameter("idxGruppo", typeof(string)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_clienti_insert", ragSocParameter, sessoParameter, pOBirthParameter, dOBirthParameter, p_ivaParameter, c_FiscParameter, viaParameter, localitaParameter, capParameter, provinciaParameter, pagamentoParameter, noteParameter, idxGruppoParameter); } public virtual int stp_clienti_update(Nullable original_idxCli, string ragSoc, string sesso, string pOBirth, Nullable dOBirth, string p_iva, string c_Fisc, string via, string localita, string cap, string provincia, string pagamento, string email, string tel, string note, string idxGruppo) { var original_idxCliParameter = original_idxCli.HasValue ? new ObjectParameter("Original_idxCli", original_idxCli) : new ObjectParameter("Original_idxCli", typeof(int)); var ragSocParameter = ragSoc != null ? new ObjectParameter("RagSoc", ragSoc) : new ObjectParameter("RagSoc", typeof(string)); var sessoParameter = sesso != null ? new ObjectParameter("Sesso", sesso) : new ObjectParameter("Sesso", typeof(string)); var pOBirthParameter = pOBirth != null ? new ObjectParameter("POBirth", pOBirth) : new ObjectParameter("POBirth", typeof(string)); var dOBirthParameter = dOBirth.HasValue ? new ObjectParameter("DOBirth", dOBirth) : new ObjectParameter("DOBirth", typeof(System.DateTime)); var p_ivaParameter = p_iva != null ? new ObjectParameter("P_iva", p_iva) : new ObjectParameter("P_iva", typeof(string)); var c_FiscParameter = c_Fisc != null ? new ObjectParameter("C_Fisc", c_Fisc) : new ObjectParameter("C_Fisc", typeof(string)); var viaParameter = via != null ? new ObjectParameter("Via", via) : new ObjectParameter("Via", typeof(string)); var localitaParameter = localita != null ? new ObjectParameter("Localita", localita) : new ObjectParameter("Localita", typeof(string)); var capParameter = cap != null ? new ObjectParameter("Cap", cap) : new ObjectParameter("Cap", typeof(string)); var provinciaParameter = provincia != null ? new ObjectParameter("Provincia", provincia) : new ObjectParameter("Provincia", typeof(string)); var pagamentoParameter = pagamento != null ? new ObjectParameter("Pagamento", pagamento) : new ObjectParameter("Pagamento", typeof(string)); var emailParameter = email != null ? new ObjectParameter("email", email) : new ObjectParameter("email", typeof(string)); var telParameter = tel != null ? new ObjectParameter("tel", tel) : new ObjectParameter("tel", typeof(string)); var noteParameter = note != null ? new ObjectParameter("Note", note) : new ObjectParameter("Note", typeof(string)); var idxGruppoParameter = idxGruppo != null ? new ObjectParameter("idxGruppo", idxGruppo) : new ObjectParameter("idxGruppo", typeof(string)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_clienti_update", original_idxCliParameter, ragSocParameter, sessoParameter, pOBirthParameter, dOBirthParameter, p_ivaParameter, c_FiscParameter, viaParameter, localitaParameter, capParameter, provinciaParameter, pagamentoParameter, emailParameter, telParameter, noteParameter, idxGruppoParameter); } public virtual int stp_docs_clone(Nullable idxFatt) { var idxFattParameter = idxFatt.HasValue ? new ObjectParameter("IdxFatt", idxFatt) : new ObjectParameter("IdxFatt", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_clone", idxFattParameter); } public virtual int stp_docs_delete(Nullable original_idxDoc) { var original_idxDocParameter = original_idxDoc.HasValue ? new ObjectParameter("Original_idxDoc", original_idxDoc) : new ObjectParameter("Original_idxDoc", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_delete", original_idxDocParameter); } public virtual ObjectResult stp_docs_getByKey(Nullable idxDoc) { var idxDocParameter = idxDoc.HasValue ? new ObjectParameter("idxDoc", idxDoc) : new ObjectParameter("idxDoc", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_getByKey", idxDocParameter); } public virtual ObjectResult stp_docs_getFilt(Nullable anno, Nullable idxCli, string tipo, string gruppo, string ragSoc, Nullable inizio, Nullable fine, Nullable aperta, string search) { var annoParameter = anno.HasValue ? new ObjectParameter("anno", anno) : new ObjectParameter("anno", typeof(int)); var idxCliParameter = idxCli.HasValue ? new ObjectParameter("idxCli", idxCli) : new ObjectParameter("idxCli", typeof(int)); var tipoParameter = tipo != null ? new ObjectParameter("tipo", tipo) : new ObjectParameter("tipo", typeof(string)); var gruppoParameter = gruppo != null ? new ObjectParameter("gruppo", gruppo) : new ObjectParameter("gruppo", typeof(string)); var ragSocParameter = ragSoc != null ? new ObjectParameter("ragSoc", ragSoc) : new ObjectParameter("ragSoc", typeof(string)); var inizioParameter = inizio.HasValue ? new ObjectParameter("inizio", inizio) : new ObjectParameter("inizio", typeof(System.DateTime)); var fineParameter = fine.HasValue ? new ObjectParameter("fine", fine) : new ObjectParameter("fine", typeof(System.DateTime)); var apertaParameter = aperta.HasValue ? new ObjectParameter("aperta", aperta) : new ObjectParameter("aperta", typeof(int)); var searchParameter = search != null ? new ObjectParameter("search", search) : new ObjectParameter("search", typeof(string)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_getFilt", annoParameter, idxCliParameter, tipoParameter, gruppoParameter, ragSocParameter, inizioParameter, fineParameter, apertaParameter, searchParameter); } public virtual int stp_docs_insert(Nullable anno, Nullable num, Nullable idxCli, string tipo, Nullable emesso, Nullable ritenuta) { var annoParameter = anno.HasValue ? new ObjectParameter("anno", anno) : new ObjectParameter("anno", typeof(int)); var numParameter = num.HasValue ? new ObjectParameter("num", num) : new ObjectParameter("num", typeof(int)); var idxCliParameter = idxCli.HasValue ? new ObjectParameter("idxCli", idxCli) : new ObjectParameter("idxCli", typeof(int)); var tipoParameter = tipo != null ? new ObjectParameter("tipo", tipo) : new ObjectParameter("tipo", typeof(string)); var emessoParameter = emesso.HasValue ? new ObjectParameter("emesso", emesso) : new ObjectParameter("emesso", typeof(System.DateTime)); var ritenutaParameter = ritenuta.HasValue ? new ObjectParameter("ritenuta", ritenuta) : new ObjectParameter("ritenuta", typeof(double)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_insert", annoParameter, numParameter, idxCliParameter, tipoParameter, emessoParameter, ritenutaParameter); } public virtual int stp_docs_update(Nullable original_idxDoc, Nullable anno, Nullable num, Nullable idxCli, string tipo, Nullable emesso, Nullable ritenuta) { var original_idxDocParameter = original_idxDoc.HasValue ? new ObjectParameter("Original_idxDoc", original_idxDoc) : new ObjectParameter("Original_idxDoc", typeof(int)); var annoParameter = anno.HasValue ? new ObjectParameter("anno", anno) : new ObjectParameter("anno", typeof(int)); var numParameter = num.HasValue ? new ObjectParameter("num", num) : new ObjectParameter("num", typeof(int)); var idxCliParameter = idxCli.HasValue ? new ObjectParameter("idxCli", idxCli) : new ObjectParameter("idxCli", typeof(int)); var tipoParameter = tipo != null ? new ObjectParameter("tipo", tipo) : new ObjectParameter("tipo", typeof(string)); var emessoParameter = emesso.HasValue ? new ObjectParameter("emesso", emesso) : new ObjectParameter("emesso", typeof(System.DateTime)); var ritenutaParameter = ritenuta.HasValue ? new ObjectParameter("ritenuta", ritenuta) : new ObjectParameter("ritenuta", typeof(double)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_update", original_idxDocParameter, annoParameter, numParameter, idxCliParameter, tipoParameter, emessoParameter, ritenutaParameter); } public virtual int stp_docRows_addNew(Nullable idxDoc, string descrizione, string um, Nullable prezzoUm, Nullable qta, Nullable cIva) { var idxDocParameter = idxDoc.HasValue ? new ObjectParameter("idxDoc", idxDoc) : new ObjectParameter("idxDoc", typeof(int)); var descrizioneParameter = descrizione != null ? new ObjectParameter("Descrizione", descrizione) : new ObjectParameter("Descrizione", typeof(string)); var umParameter = um != null ? new ObjectParameter("um", um) : new ObjectParameter("um", typeof(string)); var prezzoUmParameter = prezzoUm.HasValue ? new ObjectParameter("prezzoUm", prezzoUm) : new ObjectParameter("prezzoUm", typeof(decimal)); var qtaParameter = qta.HasValue ? new ObjectParameter("qta", qta) : new ObjectParameter("qta", typeof(float)); var cIvaParameter = cIva.HasValue ? new ObjectParameter("cIva", cIva) : new ObjectParameter("cIva", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docRows_addNew", idxDocParameter, descrizioneParameter, umParameter, prezzoUmParameter, qtaParameter, cIvaParameter); } public virtual int stp_docRows_copy2doc(Nullable idxDoc, Nullable idxRow) { var idxDocParameter = idxDoc.HasValue ? new ObjectParameter("idxDoc", idxDoc) : new ObjectParameter("idxDoc", typeof(int)); var idxRowParameter = idxRow.HasValue ? new ObjectParameter("idxRow", idxRow) : new ObjectParameter("idxRow", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docRows_copy2doc", idxDocParameter, idxRowParameter); } public virtual int stp_docs_cloneTemplate(Nullable idxFatt, Nullable idxCli) { var idxFattParameter = idxFatt.HasValue ? new ObjectParameter("IdxFatt", idxFatt) : new ObjectParameter("IdxFatt", typeof(int)); var idxCliParameter = idxCli.HasValue ? new ObjectParameter("idxCli", idxCli) : new ObjectParameter("idxCli", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_docs_cloneTemplate", idxFattParameter, idxCliParameter); } public virtual int stp_VAT_deleteQuery(Nullable original_C_iva) { var original_C_ivaParameter = original_C_iva.HasValue ? new ObjectParameter("Original_C_iva", original_C_iva) : new ObjectParameter("Original_C_iva", typeof(int)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_VAT_deleteQuery", original_C_ivaParameter); } public virtual int stp_VAT_updateQuery(Nullable original_C_iva, Nullable iva, string descrizione, Nullable enabled, Nullable splitPay) { var original_C_ivaParameter = original_C_iva.HasValue ? new ObjectParameter("Original_C_iva", original_C_iva) : new ObjectParameter("Original_C_iva", typeof(int)); var ivaParameter = iva.HasValue ? new ObjectParameter("iva", iva) : new ObjectParameter("iva", typeof(double)); var descrizioneParameter = descrizione != null ? new ObjectParameter("descrizione", descrizione) : new ObjectParameter("descrizione", typeof(string)); var enabledParameter = enabled.HasValue ? new ObjectParameter("enabled", enabled) : new ObjectParameter("enabled", typeof(bool)); var splitPayParameter = splitPay.HasValue ? new ObjectParameter("splitPay", splitPay) : new ObjectParameter("splitPay", typeof(bool)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_VAT_updateQuery", original_C_ivaParameter, ivaParameter, descrizioneParameter, enabledParameter, splitPayParameter); } public virtual ObjectResult stp_listValues_getValidValuesTrad(string tableName, string fieldName, string lingua) { var tableNameParameter = tableName != null ? new ObjectParameter("TableName", tableName) : new ObjectParameter("TableName", typeof(string)); var fieldNameParameter = fieldName != null ? new ObjectParameter("FieldName", fieldName) : new ObjectParameter("FieldName", typeof(string)); var linguaParameter = lingua != null ? new ObjectParameter("Lingua", lingua) : new ObjectParameter("Lingua", typeof(string)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_listValues_getValidValuesTrad", tableNameParameter, fieldNameParameter, linguaParameter); } public virtual ObjectResult stp_listValues_getValidValuesTrad(string tableName, string fieldName, string lingua, MergeOption mergeOption) { var tableNameParameter = tableName != null ? new ObjectParameter("TableName", tableName) : new ObjectParameter("TableName", typeof(string)); var fieldNameParameter = fieldName != null ? new ObjectParameter("FieldName", fieldName) : new ObjectParameter("FieldName", typeof(string)); var linguaParameter = lingua != null ? new ObjectParameter("Lingua", lingua) : new ObjectParameter("Lingua", typeof(string)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_listValues_getValidValuesTrad", mergeOption, tableNameParameter, fieldNameParameter, linguaParameter); } public virtual ObjectResult stp_ResGiornFilt(Nullable inizio, Nullable fine) { var inizioParameter = inizio.HasValue ? new ObjectParameter("inizio", inizio) : new ObjectParameter("inizio", typeof(System.DateTime)); var fineParameter = fine.HasValue ? new ObjectParameter("fine", fine) : new ObjectParameter("fine", typeof(System.DateTime)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_ResGiornFilt", inizioParameter, fineParameter); } public virtual ObjectResult stp_ResGiornFilt(Nullable inizio, Nullable fine, MergeOption mergeOption) { var inizioParameter = inizio.HasValue ? new ObjectParameter("inizio", inizio) : new ObjectParameter("inizio", typeof(System.DateTime)); var fineParameter = fine.HasValue ? new ObjectParameter("fine", fine) : new ObjectParameter("fine", typeof(System.DateTime)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_ResGiornFilt", mergeOption, inizioParameter, fineParameter); } public virtual ObjectResult stp_ResMensFilt(Nullable inizio, Nullable fine) { var inizioParameter = inizio.HasValue ? new ObjectParameter("inizio", inizio) : new ObjectParameter("inizio", typeof(System.DateTime)); var fineParameter = fine.HasValue ? new ObjectParameter("fine", fine) : new ObjectParameter("fine", typeof(System.DateTime)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_ResMensFilt", inizioParameter, fineParameter); } public virtual ObjectResult stp_ResMensFilt(Nullable inizio, Nullable fine, MergeOption mergeOption) { var inizioParameter = inizio.HasValue ? new ObjectParameter("inizio", inizio) : new ObjectParameter("inizio", typeof(System.DateTime)); var fineParameter = fine.HasValue ? new ObjectParameter("fine", fine) : new ObjectParameter("fine", typeof(System.DateTime)); return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("stp_ResMensFilt", mergeOption, inizioParameter, fineParameter); } } }