// using System; using GWMS.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; namespace GWMS.Data.Migrations { [DbContext(typeof(GWMSContext))] partial class GWMSContextModelSnapshot : ModelSnapshot { protected override void BuildModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("Relational:MaxIdentifierLength", 64) .HasAnnotation("ProductVersion", "5.0.7"); modelBuilder.Entity("GWMS.Data.DatabaseModels.AnKeyValModel", b => { b.Property("KeyName") .HasMaxLength(50) .HasColumnType("varchar(50)"); b.Property("Descript") .HasMaxLength(250) .HasColumnType("varchar(250)") .HasComment("Descrizione dell'item"); b.Property("ValFloat") .HasColumnType("int"); b.Property("ValInt") .HasColumnType("int"); b.Property("ValString") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.HasKey("KeyName"); b.ToTable("AnKeyVal"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.ConfigModel", b => { b.Property("KeyName") .HasMaxLength(50) .HasColumnType("varchar(50)"); b.Property("Note") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.Property("Val") .HasMaxLength(50) .HasColumnType("varchar(50)"); b.Property("ValStd") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("Valore di default/riferimento per la variabile"); b.HasKey("KeyName"); b.ToTable("Config"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.ItemModel", b => { b.Property("ItemId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("ItemCode") .HasMaxLength(100) .HasColumnType("varchar(100)"); b.Property("ItemDesc") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.Property("ItemType") .HasMaxLength(50) .HasColumnType("varchar(50)"); b.Property("UM") .HasMaxLength(50) .HasColumnType("varchar(50)"); b.HasKey("ItemId"); b.ToTable("Items"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.ListValModel", b => { b.Property("TabName") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasColumnName("TabName"); b.Property("FieldName") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasColumnName("FieldName"); b.Property("Val") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasColumnName("Val"); b.Property("Descript") .HasMaxLength(250) .HasColumnType("varchar(250)") .HasColumnName("Descript"); b.Property("Ordinal") .HasColumnType("int") .HasColumnName("Ordinal"); b.HasKey("TabName", "FieldName", "Val"); b.ToTable("ListVal"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.OrderModel", b => { b.Property("OrderId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("DtETA") .HasColumnType("datetime(6)"); b.Property("DtExecEnd") .HasColumnType("datetime(6)"); b.Property("DtExecStart") .HasColumnType("datetime(6)"); b.Property("DtOrder") .HasColumnType("datetime(6)"); b.Property("ExecutionQty") .HasColumnType("double"); b.Property("LevelEnd") .HasColumnType("double"); b.Property("LevelStart") .HasColumnType("double"); b.Property("OrderCode") .HasMaxLength(100) .HasColumnType("varchar(100)"); b.Property("OrderDesc") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.Property("OrderQty") .HasColumnType("double"); b.Property("PlantId") .HasColumnType("int"); b.Property("SupplierId") .HasColumnType("int"); b.Property("TransporterId") .HasColumnType("int"); b.HasKey("OrderId"); b.HasIndex("PlantId"); b.HasIndex("SupplierId"); b.HasIndex("TransporterId"); b.ToTable("Order"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantDetailModel", b => { b.Property("PlantId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("LevelMax") .HasColumnType("double"); b.Property("LevelReorder") .HasColumnType("double"); b.Property("OrderQtyStd") .HasColumnType("double"); b.Property("PlantCode") .HasMaxLength(100) .HasColumnType("varchar(100)"); b.Property("PlantDesc") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.HasKey("PlantId"); b.ToTable("PlantDetail"); b.HasData( new { PlantId = 1, LevelMax = 26000.0, LevelReorder = 15000.0, OrderQtyStd = 18000.0, PlantCode = "PIZ03", PlantDesc = "Collecchio" }, new { PlantId = 2, LevelMax = 28000.0, LevelReorder = 15000.0, OrderQtyStd = 18000.0, PlantCode = "PIZ04", PlantDesc = "Noceto" }, new { PlantId = 3, LevelMax = 24000.0, LevelReorder = 15000.0, OrderQtyStd = 18000.0, PlantCode = "PIZ05", PlantDesc = "Baganzola" }, new { PlantId = 4, LevelMax = 26000.0, LevelReorder = 15000.0, OrderQtyStd = 18000.0, PlantCode = "PIZ08", PlantDesc = "Pilastrello" }); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantLogModel", b => { b.Property("PlantDataId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("DtEvent") .HasColumnType("datetime(6)"); b.Property("FluxType") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.Property("PlantId") .HasColumnType("int"); b.Property("ValNumber") .HasColumnType("double"); b.Property("ValString") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.HasKey("PlantDataId"); b.HasIndex("PlantId"); b.ToTable("PlantLog"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantStatusModel", b => { b.Property("PlantId") .HasColumnType("int"); b.Property("FluxType") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.Property("DtEvent") .HasColumnType("datetime(6)"); b.Property("ValNumber") .HasColumnType("double"); b.Property("ValString") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.HasKey("PlantId", "FluxType"); b.ToTable("PlantStatus"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.RebootLogModel", b => { b.Property("RecordId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("DtEvent") .HasColumnType("datetime(6)"); b.Property("Item") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.Property("Payload") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.HasKey("RecordId"); b.ToTable("RebootLog"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.SupplierModel", b => { b.Property("SupplierId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("SupplierCode") .HasMaxLength(100) .HasColumnType("varchar(100)"); b.Property("SupplierDesc") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.HasKey("SupplierId"); b.ToTable("Supplier"); b.HasData( new { SupplierId = 1, SupplierCode = "LIQUIGAS", SupplierDesc = "Liquigas" }, new { SupplierId = 2, SupplierCode = "VULKANGAS", SupplierDesc = "Vulkangas" }); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.TransporterModel", b => { b.Property("TransporterId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("PositionLatitude") .HasColumnType("double"); b.Property("PositionLongitude") .HasColumnType("double"); b.Property("PositionUpdated") .HasColumnType("datetime(6)"); b.Property("TransporterCode") .HasMaxLength(100) .HasColumnType("varchar(100)"); b.Property("TransporterDesc") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.HasKey("TransporterId"); b.ToTable("Transporter"); b.HasData( new { TransporterId = 1, PositionLatitude = 0.0, PositionLongitude = 0.0, PositionUpdated = new DateTime(2021, 8, 9, 16, 36, 52, 691, DateTimeKind.Local).AddTicks(9092), TransporterCode = "LEVO", TransporterDesc = "Levorato" }, new { TransporterId = 2, PositionLatitude = 0.0, PositionLongitude = 0.0, PositionUpdated = new DateTime(2021, 8, 9, 16, 36, 52, 691, DateTimeKind.Local).AddTicks(9470), TransporterCode = "TRAF", TransporterDesc = "Traffik" }); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.UserModel", b => { b.Property("UserId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("AuthKey") .HasMaxLength(100) .HasColumnType("varchar(100)"); b.Property("Email") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.Property("Firstname") .HasMaxLength(50) .HasColumnType("varchar(50)"); b.Property("IsActive") .HasColumnType("tinyint(1)"); b.Property("Lang") .HasMaxLength(10) .HasColumnType("varchar(10)"); b.Property("Lastname") .HasMaxLength(50) .HasColumnType("varchar(50)"); b.Property("Livello") .HasColumnType("int"); b.Property("MaskPlantId") .HasColumnType("int"); b.Property("MaskSupplierId") .HasColumnType("int"); b.Property("MaskTranspId") .HasColumnType("int"); b.Property("SaltPasswd") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.Property("UserName") .HasMaxLength(50) .HasColumnType("varchar(50)"); b.HasKey("UserId"); b.ToTable("Users"); b.HasData( new { UserId = 1, AuthKey = "th1sIsTh3R1vrOfThNgt98", Email = "samuele@steamware.net", Firstname = "Samuele", IsActive = true, Lang = "IT", Lastname = "Locatelli", Livello = 1, MaskPlantId = 0, MaskSupplierId = 0, MaskTranspId = 0, SaltPasswd = "", UserName = "samuele.locatelli" }, new { UserId = 2, AuthKey = "th1sIsTh3R1vrOfThNgt91", Email = "giancarlo@steamware.net", Firstname = "Giancarlo", IsActive = true, Lang = "IT", Lastname = "Rottoli", Livello = 1, MaskPlantId = 0, MaskSupplierId = 0, MaskTranspId = 0, SaltPasswd = "", UserName = "giancarlo.rottoli" }, new { UserId = 3, AuthKey = "th1sIsTh3R1vrOfThNgt93", Email = "info@steamware.net", Firstname = "Steamware", IsActive = true, Lang = "IT", Lastname = "Admin", Livello = 1, MaskPlantId = 0, MaskSupplierId = 0, MaskTranspId = 0, SaltPasswd = "", UserName = "steamw.admin" }, new { UserId = 4, AuthKey = "th1sIsTh3R1vrOfThNgt97", Email = "a.pizzaferri@pizzaferripetroli.it", Firstname = "Angelo", IsActive = true, Lang = "IT", Lastname = "Pizzaferri", Livello = 2, MaskPlantId = 0, MaskSupplierId = 0, MaskTranspId = 0, SaltPasswd = "", UserName = "angelo.pizzaferri" }, new { UserId = 5, AuthKey = "th1sIsTh3R1vrOfThNgt99", Email = "andrei.valeanu@winnlab.it", Firstname = "Andrei", IsActive = true, Lang = "IT", Lastname = "Valeanu", Livello = 2, MaskPlantId = 0, MaskSupplierId = 0, MaskTranspId = 0, SaltPasswd = "", UserName = "andrei.valeanu" }, new { UserId = 6, AuthKey = "th1sIsTh3R1vrOfThNgt92", Email = "info@steamware.net", Firstname = "User", IsActive = true, Lang = "IT", Lastname = "LIQUIGAS", Livello = 4, MaskPlantId = 0, MaskSupplierId = 1, MaskTranspId = 0, SaltPasswd = "", UserName = "liquigas.user01" }, new { UserId = 7, AuthKey = "th1sIsTh3R1vrOfThNgt94", Email = "info@steamware.net", Firstname = "User", IsActive = true, Lang = "IT", Lastname = "VULKANGAS", Livello = 4, MaskPlantId = 0, MaskSupplierId = 2, MaskTranspId = 0, SaltPasswd = "", UserName = "vulkangas.user01" }, new { UserId = 8, AuthKey = "th1sIsTh3R1vrOfThNgt95", Email = "info@steamware.net", Firstname = "User", IsActive = true, Lang = "IT", Lastname = "LEVORATO", Livello = 4, MaskPlantId = 0, MaskSupplierId = 0, MaskTranspId = 1, SaltPasswd = "", UserName = "levorato.user01" }, new { UserId = 9, AuthKey = "th1sIsTh3R1vrOfThNgt96", Email = "info@steamware.net", Firstname = "User", IsActive = true, Lang = "IT", Lastname = "TRAFFIK", Livello = 4, MaskPlantId = 0, MaskSupplierId = 0, MaskTranspId = 2, SaltPasswd = "", UserName = "traffik.user01" }, new { UserId = 10, AuthKey = "th1sIsTh3R1vrOfThNgt96", Email = "info@steamware.net", Firstname = "Stazione", IsActive = true, Lang = "IT", Lastname = "Collecchio", Livello = 3, MaskPlantId = 1, MaskSupplierId = 0, MaskTranspId = 0, SaltPasswd = "", UserName = "piz03.user01" }, new { UserId = 11, AuthKey = "th1sIsTh3R1vrOfThNgt96", Email = "info@steamware.net", Firstname = "Stazione", IsActive = true, Lang = "IT", Lastname = "Noceto", Livello = 3, MaskPlantId = 2, MaskSupplierId = 0, MaskTranspId = 0, SaltPasswd = "", UserName = "piz04.user01" }, new { UserId = 12, AuthKey = "th1sIsTh3R1vrOfThNgt96", Email = "info@steamware.net", Firstname = "Stazione", IsActive = true, Lang = "IT", Lastname = "Baganzola", Livello = 3, MaskPlantId = 3, MaskSupplierId = 0, MaskTranspId = 0, SaltPasswd = "", UserName = "piz05.user01" }, new { UserId = 13, AuthKey = "th1sIsTh3R1vrOfThNgt96", Email = "info@steamware.net", Firstname = "Stazione", IsActive = true, Lang = "IT", Lastname = "Pilastrello", Livello = 3, MaskPlantId = 4, MaskSupplierId = 0, MaskTranspId = 0, SaltPasswd = "", UserName = "piz08.user01" }); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.WeekPlanModel", b => { b.Property("WeekPlanId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("DayNum") .HasColumnType("int"); b.Property("DeliveryHour") .HasColumnType("int"); b.Property("Note") .HasMaxLength(250) .HasColumnType("varchar(250)"); b.Property("PlantId") .HasColumnType("int"); b.Property("SupplierId") .HasColumnType("int"); b.Property("TransporterId") .HasColumnType("int"); b.HasKey("WeekPlanId"); b.HasIndex("PlantId"); b.HasIndex("SupplierId"); b.HasIndex("TransporterId"); b.ToTable("WeekPlan"); b.HasData( new { WeekPlanId = 1, DayNum = 1, DeliveryHour = 20, Note = "18K", PlantId = 2, SupplierId = 1, TransporterId = 1 }, new { WeekPlanId = 2, DayNum = 2, DeliveryHour = 20, Note = "18K", PlantId = 2, SupplierId = 1, TransporterId = 1 }, new { WeekPlanId = 3, DayNum = 3, DeliveryHour = 20, Note = "18K", PlantId = 2, SupplierId = 1, TransporterId = 2 }, new { WeekPlanId = 4, DayNum = 4, DeliveryHour = 15, Note = "9K", PlantId = 2, SupplierId = 1, TransporterId = 1 }, new { WeekPlanId = 5, DayNum = 4, DeliveryHour = 20, Note = "18K", PlantId = 2, SupplierId = 1, TransporterId = 1 }, new { WeekPlanId = 6, DayNum = 6, DeliveryHour = 20, Note = "18K", PlantId = 2, SupplierId = 1, TransporterId = 1 }, new { WeekPlanId = 7, DayNum = 2, DeliveryHour = 14, Note = "3K", PlantId = 3, SupplierId = 1, TransporterId = 1 }, new { WeekPlanId = 8, DayNum = 2, DeliveryHour = 15, Note = "15K", PlantId = 4, SupplierId = 1, TransporterId = 1 }, new { WeekPlanId = 9, DayNum = 2, DeliveryHour = 17, Note = "18K", PlantId = 1, SupplierId = 2, TransporterId = 2 }); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.OrderModel", b => { b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant") .WithMany() .HasForeignKey("PlantId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("GWMS.Data.DatabaseModels.SupplierModel", "Supplier") .WithMany() .HasForeignKey("SupplierId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("GWMS.Data.DatabaseModels.TransporterModel", "Transporter") .WithMany() .HasForeignKey("TransporterId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("Plant"); b.Navigation("Supplier"); b.Navigation("Transporter"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantLogModel", b => { b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant") .WithMany() .HasForeignKey("PlantId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("Plant"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantStatusModel", b => { b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant") .WithMany() .HasForeignKey("PlantId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("Plant"); }); modelBuilder.Entity("GWMS.Data.DatabaseModels.WeekPlanModel", b => { b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant") .WithMany() .HasForeignKey("PlantId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("GWMS.Data.DatabaseModels.SupplierModel", "Supplier") .WithMany() .HasForeignKey("SupplierId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("GWMS.Data.DatabaseModels.TransporterModel", "Transporter") .WithMany() .HasForeignKey("TransporterId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("Plant"); b.Navigation("Supplier"); b.Navigation("Transporter"); }); #pragma warning restore 612, 618 } } }