Samuele Locatelli
801 lines
29 KiB
C#
801 lines
29 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Microsoft.EntityFrameworkCore.Metadata;
|
|
using Microsoft.Extensions.Configuration;
|
|
using NLog;
|
|
using SHERPA.Data.DbModels;
|
|
|
|
// <Auto-Generated>
|
|
// This is here so CodeMaid doesn't reorganize this document
|
|
// </Auto-Generated>
|
|
namespace SHERPA.Data
|
|
{
|
|
public partial class SHERPAFattContext : DbContext
|
|
{
|
|
private static Logger Log = LogManager.GetCurrentClassLogger();
|
|
|
|
private IConfiguration? _configuration;
|
|
|
|
/// <summary>
|
|
/// Indispensabile x prima generazione migrations EFCore
|
|
/// </summary>
|
|
|
|
[Obsolete("This constructor should never be used directly, and is only needed to generate entityframework stuff. Connection string can be adapted as pleased.")]
|
|
public SHERPAFattContext()
|
|
{
|
|
}
|
|
|
|
public SHERPAFattContext(DbContextOptions<SHERPAFattContext> options) : base(options)
|
|
{
|
|
}
|
|
|
|
public SHERPAFattContext(IConfiguration configuration)
|
|
{
|
|
_configuration = configuration;
|
|
}
|
|
|
|
public virtual DbSet<AnagPagamModel> DbSetAnagPagam { get; set; } = null!;
|
|
public virtual DbSet<VatModel> DbSetVat { get; set; } = null!;
|
|
public virtual DbSet<CustomerModel> DbSetCustomers { get; set; } = null!;
|
|
public virtual DbSet<ConfigModel> DbSetConfig { get; set; } = null!;
|
|
public virtual DbSet<ContributiModel> DbSetContributi { get; set; } = null!;
|
|
public virtual DbSet<ContributiScontiModel> DbSetContributiSconti { get; set; } = null!;
|
|
public virtual DbSet<CostiAssorbitiModel> DbSetCostiAssorbiti { get; set; } = null!;
|
|
public virtual DbSet<Fatt2DipQuotaModel> DbSetFatt2DipQuotUm { get; set; } = null!;
|
|
public virtual DbSet<Fatt2FasiModel> DbSetFatt2Fasi { get; set; } = null!;
|
|
public virtual DbSet<AccoDocModel> DbSetAccoDocs { get; set; } = null!;
|
|
public virtual DbSet<GruppiModel> DbSetGruppi { get; set; } = null!;
|
|
public virtual DbSet<LingueModel> DbSetLingue { get; set; } = null!;
|
|
public virtual DbSet<ListValueModel> DbSetListValue { get; set; } = null!;
|
|
public virtual DbSet<OhAllocModel> DbSetOhAlloc { get; set; } = null!;
|
|
public virtual DbSet<OhStdCostModel> DbSetOhStdCost { get; set; } = null!;
|
|
public virtual DbSet<PagamentiModel> DbSetPagamenti { get; set; } = null!;
|
|
public virtual DbSet<PermessiModel> DbSetPermessi { get; set; } = null!;
|
|
public virtual DbSet<Permessi2FunzioneModel> DbSetPermessi2Funzione { get; set; } = null!;
|
|
public virtual DbSet<RigheFattModel> DbSetRigheFatt { get; set; } = null!;
|
|
public virtual DbSet<RinnoviModel> DbSetRinnovi { get; set; } = null!;
|
|
public virtual DbSet<ScadenzeModel> DbSetScadenze { get; set; } = null!;
|
|
public virtual DbSet<VocabolarioModel> DbSetVocabolario { get; set; } = null!;
|
|
public virtual DbSet<AnagTipoDocModel> DbSetTipoDoc { get; set; } = null!;
|
|
|
|
public virtual DbSet<vDocsExplModel> DbSetDocExpl { get; set; } = null!;
|
|
public virtual DbSet<vSelCliModel> DbSetSelCli { get; set; } = null!;
|
|
public virtual DbSet<vSelGruppiModel> DbSetSelGruppi { get; set; } = null!;
|
|
public virtual DbSet<vFattAperteModel> DbSetFattAperte { get; set; } = null!;
|
|
|
|
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
|
|
{
|
|
if (!optionsBuilder.IsConfigured)
|
|
{
|
|
string connString = _configuration.GetConnectionString("Sherpa.Fatt");
|
|
if (!string.IsNullOrEmpty(connString))
|
|
{
|
|
optionsBuilder.UseSqlServer(connString);
|
|
}
|
|
else
|
|
{
|
|
optionsBuilder.UseSqlServer("Server=W2019-SQL-STEAM;Database=SHERPA.Fatt;Trusted_Connection=True;");
|
|
}
|
|
}
|
|
}
|
|
|
|
protected override void OnModelCreating(ModelBuilder modelBuilder)
|
|
{
|
|
modelBuilder.Entity<AnagPagamModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.Pagamento);
|
|
|
|
entity.ToTable("AnagPagam");
|
|
|
|
entity.Property(e => e.Pagamento)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("pagamento");
|
|
|
|
entity.Property(e => e.DescrPag)
|
|
.HasMaxLength(250)
|
|
.HasDefaultValueSql("('')");
|
|
|
|
entity.Property(e => e.Dffm).HasColumnName("DFFM");
|
|
|
|
entity.Property(e => e.NumGg).HasColumnName("NumGG");
|
|
});
|
|
|
|
modelBuilder.Entity<VatModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.IdxVat)
|
|
.HasName("aaaaaC_iva_PK")
|
|
.IsClustered(false);
|
|
|
|
entity.ToTable("C_iva");
|
|
|
|
entity.Property(e => e.IdxVat).HasColumnName("C_iva");
|
|
|
|
entity.Property(e => e.Descrizione)
|
|
.HasMaxLength(250)
|
|
.HasColumnName("descrizione");
|
|
|
|
entity.Property(e => e.Enabled).HasColumnName("enabled");
|
|
|
|
entity.Property(e => e.Iva)
|
|
.HasColumnName("iva")
|
|
.HasDefaultValueSql("((0))");
|
|
|
|
entity.Property(e => e.SplitPay).HasColumnName("splitPay");
|
|
|
|
});
|
|
|
|
modelBuilder.Entity<CustomerModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.IdxCli)
|
|
.HasName("aaaaaclienti_PK")
|
|
.IsClustered(false);
|
|
|
|
entity.ToTable("clienti");
|
|
|
|
entity.HasIndex(e => e.IdxGruppo, "Gruppiclienti");
|
|
|
|
entity.HasIndex(e => e.CodiceCliente, "codice cliente");
|
|
|
|
entity.HasIndex(e => e.IdxGruppo, "idxGruppo");
|
|
|
|
entity.Property(e => e.IdxCli).HasColumnName("idxCli");
|
|
|
|
entity.Property(e => e.Attivo)
|
|
.IsRequired()
|
|
.HasColumnName("attivo")
|
|
.HasDefaultValueSql("((1))");
|
|
|
|
entity.Property(e => e.CFisc)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("C_Fisc");
|
|
|
|
entity.Property(e => e.Cap)
|
|
.HasMaxLength(5)
|
|
.HasColumnName("cap")
|
|
.HasDefaultValueSql("('00000')");
|
|
|
|
entity.Property(e => e.CodUnivoco)
|
|
.HasMaxLength(500)
|
|
.HasColumnName("codUnivoco")
|
|
.HasDefaultValueSql("('')");
|
|
|
|
entity.Property(e => e.CodiceCliente)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("codiceCliente");
|
|
|
|
entity.Property(e => e.IdExt)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("id_ext")
|
|
.HasDefaultValueSql("('')")
|
|
.HasComment("ID esterno");
|
|
|
|
entity.Property(e => e.IdxGruppo)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("idxGruppo")
|
|
.HasDefaultValueSql("('Spot')");
|
|
|
|
entity.Property(e => e.Localita)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("località")
|
|
.HasDefaultValueSql("('')");
|
|
|
|
entity.Property(e => e.Note)
|
|
.HasColumnType("ntext")
|
|
.HasColumnName("note");
|
|
|
|
entity.Property(e => e.PIva)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("P_iva");
|
|
|
|
entity.Property(e => e.Pagamento)
|
|
.HasMaxLength(250)
|
|
.HasColumnName("pagamento");
|
|
|
|
entity.Property(e => e.Pec)
|
|
.HasMaxLength(500)
|
|
.HasColumnName("pec")
|
|
.HasDefaultValueSql("('-')");
|
|
|
|
entity.Property(e => e.Provincia)
|
|
.HasMaxLength(4)
|
|
.HasColumnName("provincia")
|
|
.HasDefaultValueSql("('')");
|
|
|
|
entity.Property(e => e.RagSoc).HasMaxLength(250);
|
|
|
|
entity.Property(e => e.Valuta)
|
|
.HasMaxLength(255)
|
|
.HasColumnName("valuta")
|
|
.HasDefaultValueSql("('€')");
|
|
|
|
entity.Property(e => e.Via)
|
|
.HasMaxLength(250)
|
|
.HasColumnName("via")
|
|
.HasDefaultValueSql("('')");
|
|
|
|
entity.HasOne(d => d.IdxGruppoNavigation)
|
|
.WithMany(p => p.ClientiNav)
|
|
.HasForeignKey(d => d.IdxGruppo)
|
|
.HasConstraintName("FK_clienti_Gruppi");
|
|
});
|
|
|
|
modelBuilder.Entity<ConfigModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.Chiave);
|
|
|
|
entity.ToTable("Config");
|
|
|
|
entity.Property(e => e.Chiave)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("chiave");
|
|
|
|
entity.Property(e => e.Note).HasColumnName("note");
|
|
|
|
entity.Property(e => e.Valore).HasColumnName("valore");
|
|
|
|
entity.Property(e => e.ValoreStd).HasColumnName("valoreStd");
|
|
});
|
|
|
|
modelBuilder.Entity<ContributiModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.Id)
|
|
.HasName("aaaaacontributi_PK")
|
|
.IsClustered(false);
|
|
|
|
entity.ToTable("contributi");
|
|
|
|
entity.HasIndex(e => e.Id, "id");
|
|
|
|
entity.Property(e => e.Descrizione)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("descrizione");
|
|
|
|
entity.Property(e => e.Imponibile).HasColumnName("imponibile");
|
|
|
|
entity.Property(e => e.Percentuale)
|
|
.HasColumnName("percentuale")
|
|
.HasDefaultValueSql("((0))");
|
|
|
|
entity.Property(e => e.Ritenuta).HasColumnName("ritenuta");
|
|
|
|
entity.Property(e => e.UpsizeTs)
|
|
.IsRowVersion()
|
|
.IsConcurrencyToken()
|
|
.HasColumnName("upsize_ts");
|
|
});
|
|
|
|
modelBuilder.Entity<ContributiScontiModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.IdRiga)
|
|
.HasName("aaaaacontributi_sconti_PK")
|
|
.IsClustered(false);
|
|
|
|
entity.ToTable("contributi_sconti");
|
|
|
|
entity.HasIndex(e => e.IdFatt, "id_fatt");
|
|
|
|
entity.HasIndex(e => e.IdRiga, "id_riga");
|
|
|
|
entity.Property(e => e.IdRiga)
|
|
.ValueGeneratedNever()
|
|
.HasColumnName("id_riga");
|
|
|
|
entity.Property(e => e.IdFatt)
|
|
.HasColumnName("id_fatt")
|
|
.HasDefaultValueSql("((0))");
|
|
});
|
|
|
|
modelBuilder.Entity<CostiAssorbitiModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.IdxFatt)
|
|
.HasName("PK_CostiAssorbiti_1");
|
|
|
|
entity.ToTable("CostiAssorbiti");
|
|
|
|
entity.Property(e => e.IdxFatt).ValueGeneratedNever();
|
|
|
|
entity.Property(e => e.Netto)
|
|
.HasColumnType("money")
|
|
.HasColumnName("netto");
|
|
|
|
entity.Property(e => e.Note)
|
|
.HasMaxLength(2500)
|
|
.HasColumnName("note")
|
|
.HasDefaultValueSql("('')");
|
|
|
|
entity.HasOne(d => d.FattureNav)
|
|
.WithOne(p => p.CostiAssorbiti)
|
|
.HasForeignKey<CostiAssorbitiModel>(d => d.IdxFatt)
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|
.HasConstraintName("FK_CostiAssorbiti_Fatture");
|
|
});
|
|
|
|
modelBuilder.Entity<Fatt2DipQuotaModel>(entity =>
|
|
{
|
|
entity.HasKey(e => new { e.IdFatt, e.IdxDipendente })
|
|
.HasName("PK_Fatt2DipQuote");
|
|
|
|
entity.Property(e => e.IdFatt).HasColumnName("Id_fatt");
|
|
|
|
entity.Property(e => e.IdxDipendente).HasColumnName("idxDipendente");
|
|
|
|
entity.HasOne(d => d.FattureNav)
|
|
.WithMany(p => p.Fatt2DipQuotaNav)
|
|
.HasForeignKey(d => d.IdFatt)
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|
.HasConstraintName("FK_Fatt2DipQuota_Fatture");
|
|
});
|
|
|
|
modelBuilder.Entity<Fatt2FasiModel>(entity =>
|
|
{
|
|
entity.HasKey(e => new { e.IdFatt, e.IdxFase });
|
|
|
|
entity.ToTable("Fatt2Fasi");
|
|
|
|
entity.Property(e => e.IdFatt).HasColumnName("Id_fatt");
|
|
|
|
entity.Property(e => e.IdxFase).HasColumnName("idxFase");
|
|
|
|
entity.HasOne(d => d.IdFattNavigation)
|
|
.WithMany(p => p.Fatt2FasiNav)
|
|
.HasForeignKey(d => d.IdFatt)
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|
.HasConstraintName("FK_Fatt2Fasi_Fatture");
|
|
});
|
|
|
|
modelBuilder.Entity<AccoDocModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.IdxFatt)
|
|
.HasName("aaaaaFatture_PK")
|
|
.IsClustered(false);
|
|
|
|
entity.ToTable("Fatture");
|
|
|
|
entity.HasIndex(e => e.Anno, "Id");
|
|
|
|
entity.HasIndex(e => e.IdxFatt, "Id1");
|
|
|
|
entity.HasIndex(e => e.IdxCli, "clientiFatture");
|
|
|
|
entity.HasIndex(e => e.Num, "num");
|
|
|
|
entity.Property(e => e.Anno)
|
|
.HasColumnName("anno")
|
|
.HasDefaultValueSql("((0))");
|
|
|
|
entity.Property(e => e.Changed)
|
|
.HasColumnName("changed")
|
|
.HasComment("Indica se invariato oppure cambiato testata (1), righe (2), tutto (3)");
|
|
|
|
entity.Property(e => e.DataPagam)
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("dataPagam");
|
|
|
|
entity.Property(e => e.DtEvent)
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("dtEvent")
|
|
.HasDefaultValueSql("(getdate())")
|
|
.HasComment("DataOra ultima variazione");
|
|
|
|
entity.Property(e => e.Emesso)
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("emesso")
|
|
.HasDefaultValueSql("(CONVERT([date],sysdatetime(),(0)))");
|
|
|
|
entity.Property(e => e.IdxCli)
|
|
.HasColumnName("idxCli")
|
|
.HasDefaultValueSql("((0))");
|
|
|
|
entity.Property(e => e.NewId)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("new_id")
|
|
.HasDefaultValueSql("('')")
|
|
.HasComment("ID esterno");
|
|
|
|
entity.Property(e => e.Num)
|
|
.HasColumnName("num")
|
|
.HasDefaultValueSql("((0))");
|
|
|
|
entity.Property(e => e.Ritenuta).HasColumnName("ritenuta");
|
|
|
|
entity.Property(e => e.Scadenza)
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("scadenza")
|
|
.HasComputedColumnSql("([dbo].[f_getScadenzaCli]([emesso],[idxCli]))", false);
|
|
|
|
entity.Property(e => e.Scelta).HasColumnName("scelta");
|
|
|
|
//entity.Property(e => e.Tipo)
|
|
// .HasMaxLength(50)
|
|
// .HasColumnName("tipo");
|
|
|
|
entity.Property(e => e.Token)
|
|
.HasMaxLength(250)
|
|
.HasColumnName("token")
|
|
.HasDefaultValueSql("('')")
|
|
.HasComment("Token - Identificativo permanente del documento ");
|
|
|
|
entity.HasOne(d => d.CustomerNav)
|
|
.WithMany(p => p.FattureNav)
|
|
.HasForeignKey(d => d.IdxCli)
|
|
.HasConstraintName("FK_Fatture_clienti");
|
|
|
|
entity.HasMany(d => d.ContributiNav)
|
|
.WithMany(p => p.FatturaNav)
|
|
.UsingEntity<Dictionary<string, object>>(
|
|
"ContributiFatture",
|
|
l => l.HasOne<ContributiModel>().WithMany().HasForeignKey("IdContributo").OnDelete(DeleteBehavior.ClientSetNull).HasConstraintName("FK_contributi<->fatture_contributi"),
|
|
r => r.HasOne<AccoDocModel>().WithMany().HasForeignKey("IdFattura").OnDelete(DeleteBehavior.ClientSetNull).HasConstraintName("FK_contributi<->fatture_Fatture"),
|
|
j =>
|
|
{
|
|
j.HasKey("IdFattura", "IdContributo").HasName("aaaaacontributi<->fatture_PK").IsClustered(false);
|
|
|
|
j.ToTable("contributi<->fatture");
|
|
|
|
j.HasIndex(new[] { "IdFattura" }, "Fatturecontributi<->fatture");
|
|
|
|
j.HasIndex(new[] { "IdContributo" }, "IdContributo");
|
|
|
|
j.HasIndex(new[] { "IdFattura" }, "IdFattura");
|
|
|
|
j.HasIndex(new[] { "IdContributo" }, "contributicontributi<->fatture");
|
|
});
|
|
});
|
|
|
|
modelBuilder.Entity<GruppiModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.IdxGruppo)
|
|
.HasName("aaaaaGruppi_PK")
|
|
.IsClustered(false);
|
|
|
|
entity.ToTable("Gruppi");
|
|
|
|
entity.HasIndex(e => e.IdxGruppo, "IdxGruppo");
|
|
|
|
entity.Property(e => e.IdxGruppo).HasMaxLength(50);
|
|
|
|
entity.Property(e => e.Descr).HasMaxLength(50);
|
|
});
|
|
|
|
modelBuilder.Entity<LingueModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.Lingua);
|
|
|
|
entity.ToTable("Lingue");
|
|
|
|
entity.Property(e => e.Lingua).HasMaxLength(3);
|
|
|
|
entity.Property(e => e.DescrizioneLingua).HasMaxLength(50);
|
|
});
|
|
|
|
modelBuilder.Entity<ListValueModel>(entity =>
|
|
{
|
|
entity.HasKey(e => new { e.TableName, e.FieldName, e.Value });
|
|
|
|
entity.Property(e => e.TableName).HasMaxLength(50);
|
|
|
|
entity.Property(e => e.FieldName).HasMaxLength(50);
|
|
|
|
entity.Property(e => e.Value)
|
|
.HasMaxLength(10)
|
|
.HasColumnName("value");
|
|
|
|
entity.Property(e => e.Label)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("label");
|
|
|
|
entity.Property(e => e.Ordinal).HasColumnName("ordinal");
|
|
});
|
|
|
|
modelBuilder.Entity<OhAllocModel>(entity =>
|
|
{
|
|
entity.HasKey(e => new { e.AnnoRif, e.Oh })
|
|
.HasName("PK_ImpiegoOH");
|
|
|
|
entity.ToTable("OH_Alloc");
|
|
|
|
entity.Property(e => e.AnnoRif).HasDefaultValueSql("(datepart(year,getdate()))");
|
|
|
|
entity.Property(e => e.Oh)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("OH")
|
|
.HasDefaultValueSql("(N'ND')");
|
|
|
|
entity.Property(e => e.Note)
|
|
.HasMaxLength(500)
|
|
.HasDefaultValueSql("('-')");
|
|
|
|
entity.Property(e => e.Qta).HasDefaultValueSql("((1))");
|
|
});
|
|
|
|
modelBuilder.Entity<OhStdCostModel>(entity =>
|
|
{
|
|
entity.HasKey(e => new { e.AnnoRif, e.Oh })
|
|
.HasName("PK_OHC_1");
|
|
|
|
entity.ToTable("OH_StdCosts");
|
|
|
|
entity.Property(e => e.AnnoRif).HasDefaultValueSql("(datepart(year,getdate()))");
|
|
|
|
entity.Property(e => e.Oh)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("OH")
|
|
.HasDefaultValueSql("(N'ND')");
|
|
|
|
entity.Property(e => e.Note).HasMaxLength(500);
|
|
|
|
entity.Property(e => e.Unit)
|
|
.HasMaxLength(50)
|
|
.HasDefaultValueSql("(N'gg')");
|
|
|
|
entity.Property(e => e.UnitCost)
|
|
.HasColumnType("money")
|
|
.HasDefaultValueSql("((1))");
|
|
});
|
|
|
|
modelBuilder.Entity<PagamentiModel>(entity =>
|
|
{
|
|
entity.HasKey(e => new { e.IdFatt, e.Data });
|
|
|
|
entity.ToTable("Pagamenti");
|
|
|
|
entity.Property(e => e.IdFatt).HasColumnName("Id_fatt");
|
|
|
|
entity.Property(e => e.Data)
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("data");
|
|
|
|
entity.Property(e => e.Importo)
|
|
.HasColumnType("money")
|
|
.HasColumnName("importo");
|
|
|
|
entity.Property(e => e.Netto)
|
|
.HasColumnType("money")
|
|
.HasColumnName("netto");
|
|
|
|
entity.Property(e => e.Note)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("note");
|
|
|
|
entity.HasOne(d => d.FattureNav)
|
|
.WithMany(p => p.PagamentiNav)
|
|
.HasForeignKey(d => d.IdFatt)
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|
.HasConstraintName("FK_Pagamenti_Fatture");
|
|
});
|
|
|
|
modelBuilder.Entity<PermessiModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.CodPermesso);
|
|
|
|
entity.ToTable("Permessi");
|
|
|
|
entity.Property(e => e.CodPermesso)
|
|
.HasMaxLength(50)
|
|
.IsUnicode(false)
|
|
.HasColumnName("COD_PERMESSO")
|
|
.UseCollation("Latin1_General_CI_AS");
|
|
|
|
entity.Property(e => e.Descrizione)
|
|
.HasMaxLength(50)
|
|
.IsUnicode(false)
|
|
.HasColumnName("DESCRIZIONE")
|
|
.UseCollation("Latin1_General_CI_AS");
|
|
|
|
entity.Property(e => e.Gruppo).HasColumnName("GRUPPO");
|
|
|
|
entity.Property(e => e.Nome)
|
|
.HasMaxLength(50)
|
|
.IsUnicode(false)
|
|
.HasColumnName("NOME")
|
|
.UseCollation("Latin1_General_CI_AS");
|
|
|
|
entity.Property(e => e.Numero).HasColumnName("NUMERO");
|
|
|
|
entity.Property(e => e.Url)
|
|
.HasMaxLength(250)
|
|
.IsUnicode(false)
|
|
.HasColumnName("URL")
|
|
.UseCollation("Latin1_General_CI_AS");
|
|
});
|
|
|
|
modelBuilder.Entity<Permessi2FunzioneModel>(entity =>
|
|
{
|
|
entity.HasKey(e => new { e.CodPermesso, e.CodFunzione });
|
|
|
|
entity.ToTable("Permessi2Funzione");
|
|
|
|
entity.Property(e => e.CodPermesso)
|
|
.HasMaxLength(50)
|
|
.IsUnicode(false)
|
|
.HasColumnName("COD_PERMESSO")
|
|
.UseCollation("Latin1_General_CI_AS");
|
|
|
|
entity.Property(e => e.CodFunzione)
|
|
.HasMaxLength(31)
|
|
.HasColumnName("COD_FUNZIONE")
|
|
.UseCollation("Latin1_General_CI_AS");
|
|
|
|
entity.Property(e => e.Readwrite)
|
|
.HasMaxLength(1)
|
|
.IsUnicode(false)
|
|
.HasColumnName("READWRITE")
|
|
.IsFixedLength()
|
|
.UseCollation("Latin1_General_CI_AS");
|
|
|
|
entity.HasOne(d => d.PermessiNav)
|
|
.WithMany(p => p.Permessi2FunzioneNav)
|
|
.HasForeignKey(d => d.CodPermesso)
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|
.HasConstraintName("FK_Permessi2Funzione_Permessi");
|
|
});
|
|
|
|
modelBuilder.Entity<RigheFattModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.Id)
|
|
.HasName("aaaaaRighe_fatt_PK")
|
|
.IsClustered(false);
|
|
|
|
entity.ToTable("Righe_fatt");
|
|
|
|
entity.HasIndex(e => e.CIva, "C_ivaRighe_fatt");
|
|
|
|
entity.HasIndex(e => e.IdxDoc, "FattureRighe_fatt");
|
|
|
|
entity.HasIndex(e => e.Id, "Id");
|
|
|
|
entity.Property(e => e.CIva)
|
|
.HasColumnName("c_iva")
|
|
.HasDefaultValueSql("((0))");
|
|
|
|
entity.Property(e => e.CodExt)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("codExt")
|
|
.HasDefaultValueSql("('')");
|
|
|
|
entity.Property(e => e.Descrizione).HasMaxLength(1500);
|
|
|
|
entity.Property(e => e.IdFatt)
|
|
.HasColumnName("Id_fatt")
|
|
.HasComputedColumnSql("([idxDoc])", false);
|
|
|
|
entity.Property(e => e.IdxDoc)
|
|
.HasColumnName("idxDoc")
|
|
.HasDefaultValueSql("((0))");
|
|
|
|
entity.Property(e => e.NoRitenuta).HasColumnName("no_ritenuta");
|
|
|
|
entity.Property(e => e.PrezzoUm)
|
|
.HasColumnType("money")
|
|
.HasColumnName("prezzo/um");
|
|
|
|
entity.Property(e => e.Qta).HasColumnName("qta");
|
|
|
|
entity.Property(e => e.QuotaProj).HasColumnName("quotaProj");
|
|
|
|
entity.Property(e => e.Sconto).HasColumnName("sconto");
|
|
|
|
entity.Property(e => e.Um)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("um")
|
|
.HasDefaultValueSql("('nr')");
|
|
|
|
entity.Property(e => e.Valuta)
|
|
.HasMaxLength(255)
|
|
.HasColumnName("valuta")
|
|
.HasDefaultValueSql("('')");
|
|
|
|
entity.HasOne(d => d.VatNav)
|
|
.WithMany(p => p.RigheFattNav)
|
|
.HasForeignKey(d => d.CIva)
|
|
.HasConstraintName("FK_Righe_fatt_C_iva");
|
|
|
|
entity.HasOne(d => d.FattureNav)
|
|
.WithMany(p => p.RigheFattNav)
|
|
.HasForeignKey(d => d.IdxDoc)
|
|
.HasConstraintName("FK_Righe_fatt_Fatture");
|
|
});
|
|
|
|
modelBuilder.Entity<RinnoviModel>(entity =>
|
|
{
|
|
entity.HasKey(e => e.IdxFatt);
|
|
|
|
entity.ToTable("Rinnovi");
|
|
|
|
entity.Property(e => e.IdxFatt)
|
|
.ValueGeneratedNever()
|
|
.HasColumnName("idxFatt");
|
|
|
|
entity.Property(e => e.Cadenza)
|
|
.HasColumnName("cadenza")
|
|
.HasDefaultValueSql("((1))");
|
|
|
|
entity.Property(e => e.CodFrequenza)
|
|
.HasMaxLength(2)
|
|
.HasColumnName("codFrequenza")
|
|
.HasDefaultValueSql("('yy')")
|
|
.IsFixedLength();
|
|
|
|
entity.Property(e => e.Descrizione)
|
|
.HasColumnName("descrizione")
|
|
.HasDefaultValueSql("('-')");
|
|
|
|
entity.Property(e => e.Fine)
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("fine")
|
|
.HasDefaultValueSql("('20990101')");
|
|
|
|
entity.Property(e => e.Inizio)
|
|
.HasColumnType("smalldatetime")
|
|
.HasColumnName("inizio")
|
|
.HasDefaultValueSql("(CONVERT([date],sysdatetime(),(0)))");
|
|
|
|
entity.Property(e => e.ProxScadenza)
|
|
.HasColumnType("smalldatetime")
|
|
.HasColumnName("proxScadenza")
|
|
.HasDefaultValueSql("(dateadd(year,(1),CONVERT([date],sysdatetime(),(0))))");
|
|
|
|
entity.HasOne(d => d.FattureNav)
|
|
.WithOne(p => p.Rinnovi)
|
|
.HasForeignKey<RinnoviModel>(d => d.IdxFatt)
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|
.HasConstraintName("FK_Rinnovi_Fatture");
|
|
});
|
|
|
|
modelBuilder.Entity<ScadenzeModel>(entity =>
|
|
{
|
|
entity.HasKey(e => new { e.IdFatt, e.Data });
|
|
|
|
entity.ToTable("Scadenze");
|
|
|
|
entity.Property(e => e.IdFatt).HasColumnName("Id_fatt");
|
|
|
|
entity.Property(e => e.Data)
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("data");
|
|
|
|
entity.Property(e => e.Importo)
|
|
.HasColumnType("money")
|
|
.HasColumnName("importo");
|
|
|
|
entity.Property(e => e.Netto)
|
|
.HasColumnType("money")
|
|
.HasColumnName("netto");
|
|
|
|
entity.Property(e => e.Note)
|
|
.HasMaxLength(50)
|
|
.HasColumnName("note");
|
|
|
|
entity.HasOne(d => d.FattureNav)
|
|
.WithMany(p => p.ScadenzeNav)
|
|
.HasForeignKey(d => d.IdFatt)
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|
.HasConstraintName("FK_Scadenze_Fatture");
|
|
});
|
|
|
|
modelBuilder.Entity<VocabolarioModel>(entity =>
|
|
{
|
|
entity.HasKey(e => new { e.Lingua, e.Lemma });
|
|
|
|
entity.ToTable("Vocabolario");
|
|
|
|
entity.Property(e => e.Lingua).HasMaxLength(3);
|
|
|
|
entity.Property(e => e.Lemma).HasMaxLength(50);
|
|
|
|
entity.Property(e => e.Traduzione).HasMaxLength(500);
|
|
});
|
|
|
|
modelBuilder.Entity<vDocsExplModel>().ToView("v_docsExpl");
|
|
//modelBuilder.Entity<vFattAperteModel>().ToView("v_fattureAperte");
|
|
modelBuilder.Entity<vSelCliModel>().ToView("vSelCli");
|
|
modelBuilder.Entity<vSelGruppiModel>().ToView("vSelGruppi");
|
|
|
|
OnModelCreatingPartial(modelBuilder);
|
|
}
|
|
|
|
partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
|
|
}
|
|
}
|