Files
MedAP/MedAP_data/APModel.Context.cs
Samuele E. Locatelli c79dba45dd bozza libro giornale
2018-01-24 12:36:36 +01:00

542 lines
26 KiB
C#

//------------------------------------------------------------------------------
// <auto-generated>
// 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.
// </auto-generated>
//------------------------------------------------------------------------------
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> Documenti { get; set; }
public virtual DbSet<DocTemplate> DocTemplate { get; set; }
public virtual DbSet<RigheDoc> RigheDoc { get; set; }
public virtual DbSet<Clienti> Clienti { get; set; }
public virtual DbSet<RowTemplate> RowTemplate { get; set; }
public virtual DbSet<ResocontoIvaFatt> ResocontoIvaFatt { get; set; }
public virtual DbSet<VAT> VAT { get; set; }
public virtual DbSet<KVPlist> KVPlist { get; set; }
public virtual DbSet<ResGiorn> ResGiorn { get; set; }
public virtual DbSet<ResMens> ResMens { get; set; }
public virtual int stp_docRows_deleteQuery(Nullable<int> 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<int> original_id, string descrizione, string um, Nullable<decimal> prezzoUm, Nullable<float> qta, Nullable<float> sconto, Nullable<int> 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<RigheDoc> stp_docRows_getByIdxDoc(Nullable<int> idxDoc)
{
var idxDocParameter = idxDoc.HasValue ?
new ObjectParameter("idxDoc", idxDoc) :
new ObjectParameter("idxDoc", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<RigheDoc>("stp_docRows_getByIdxDoc", idxDocParameter);
}
public virtual ObjectResult<RigheDoc> stp_docRows_getByIdxDoc(Nullable<int> idxDoc, MergeOption mergeOption)
{
var idxDocParameter = idxDoc.HasValue ?
new ObjectParameter("idxDoc", idxDoc) :
new ObjectParameter("idxDoc", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<RigheDoc>("stp_docRows_getByIdxDoc", mergeOption, idxDocParameter);
}
public virtual int stp_clienti_delete(Nullable<int> 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<System.DateTime> 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<int> original_idxCli, string ragSoc, string sesso, string pOBirth, Nullable<System.DateTime> 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<int> 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<int> 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_Result> stp_docs_getByKey(Nullable<int> idxDoc)
{
var idxDocParameter = idxDoc.HasValue ?
new ObjectParameter("idxDoc", idxDoc) :
new ObjectParameter("idxDoc", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<stp_docs_getByKey_Result>("stp_docs_getByKey", idxDocParameter);
}
public virtual ObjectResult<stp_docs_getFilt_Result> stp_docs_getFilt(Nullable<int> anno, Nullable<int> idxCli, string tipo, string gruppo, string ragSoc, Nullable<System.DateTime> inizio, Nullable<System.DateTime> fine, Nullable<int> 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_Result>("stp_docs_getFilt", annoParameter, idxCliParameter, tipoParameter, gruppoParameter, ragSocParameter, inizioParameter, fineParameter, apertaParameter, searchParameter);
}
public virtual int stp_docs_insert(Nullable<int> anno, Nullable<int> num, Nullable<int> idxCli, string tipo, Nullable<System.DateTime> emesso, Nullable<double> 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<int> original_idxDoc, Nullable<int> anno, Nullable<int> num, Nullable<int> idxCli, string tipo, Nullable<System.DateTime> emesso, Nullable<double> 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<int> idxDoc, string descrizione, string um, Nullable<decimal> prezzoUm, Nullable<float> qta, Nullable<int> 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<int> idxDoc, Nullable<int> 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<int> idxFatt, Nullable<int> 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<int> 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<int> original_C_iva, Nullable<double> iva, string descrizione, Nullable<bool> enabled, Nullable<bool> 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<KVPlist> 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<KVPlist>("stp_listValues_getValidValuesTrad", tableNameParameter, fieldNameParameter, linguaParameter);
}
public virtual ObjectResult<KVPlist> 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<KVPlist>("stp_listValues_getValidValuesTrad", mergeOption, tableNameParameter, fieldNameParameter, linguaParameter);
}
public virtual ObjectResult<ResGiorn> stp_ResGiornFilt(Nullable<System.DateTime> inizio, Nullable<System.DateTime> 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<ResGiorn>("stp_ResGiornFilt", inizioParameter, fineParameter);
}
public virtual ObjectResult<ResGiorn> stp_ResGiornFilt(Nullable<System.DateTime> inizio, Nullable<System.DateTime> 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<ResGiorn>("stp_ResGiornFilt", mergeOption, inizioParameter, fineParameter);
}
public virtual ObjectResult<ResMens> stp_ResMensFilt(Nullable<System.DateTime> inizio, Nullable<System.DateTime> 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<ResMens>("stp_ResMensFilt", inizioParameter, fineParameter);
}
public virtual ObjectResult<ResMens> stp_ResMensFilt(Nullable<System.DateTime> inizio, Nullable<System.DateTime> 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<ResMens>("stp_ResMensFilt", mergeOption, inizioParameter, fineParameter);
}
}
}