| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328 |
- // <auto-generated />
- using System;
- using Gateway.POS;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Infrastructure;
- using Microsoft.EntityFrameworkCore.Migrations;
- using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
- namespace Gateway.POS.Migrations
- {
- [DbContext(typeof(PosAppDbContext))]
- [Migration("20210418014800_FuelItemUseDouble")]
- partial class FuelItemUseDouble
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
- #pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "5.0.5");
- modelBuilder.Entity("Gateway.POS.Models.AppliedDiscount", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
- b.Property<int>("DiscountId")
- .HasColumnType("INTEGER");
- b.Property<decimal>("DiscountedAmount")
- .HasColumnType("TEXT");
- b.Property<int?>("TransactionId")
- .HasColumnType("INTEGER");
- b.HasKey("Id");
- b.HasIndex("DiscountId");
- b.HasIndex("TransactionId");
- b.ToTable("AppliedDiscount");
- });
- modelBuilder.Entity("Gateway.POS.Models.Discount", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
- b.Property<string>("Command")
- .HasColumnType("TEXT");
- b.Property<DateTime>("CreatedTime")
- .HasColumnType("TEXT");
- b.Property<string>("Description")
- .HasColumnType("TEXT");
- b.Property<int>("DiscountType")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("EndTime")
- .HasColumnType("TEXT");
- b.Property<bool>("IsMarkedAsDeletion")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("ModifiedTime")
- .HasColumnType("TEXT");
- b.Property<string>("Name")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("StartTime")
- .HasColumnType("TEXT");
- b.Property<string>("TargetFuelProductCode")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("Discounts");
- });
- modelBuilder.Entity("Gateway.POS.Models.FuelItem", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
- b.Property<double>("Amount")
- .HasColumnType("REAL");
- b.Property<string>("FuelProductCode")
- .HasColumnType("TEXT");
- b.Property<string>("FuelProductName")
- .HasColumnType("TEXT");
- b.Property<string>("FuelTrxSequenceNumber")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("FuelingEndTime")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("FuelingStartTime")
- .HasColumnType("TEXT");
- b.Property<int>("NozzleLogicalId")
- .HasColumnType("INTEGER");
- b.Property<double>("Price")
- .HasColumnType("REAL");
- b.Property<int>("PumpId")
- .HasColumnType("INTEGER");
- b.Property<double>("Qualtity")
- .HasColumnType("REAL");
- b.Property<int?>("SiteLevelNozzleId")
- .HasColumnType("INTEGER");
- b.Property<double?>("TotalVolume")
- .HasColumnType("REAL");
- b.Property<int>("TransactionId")
- .HasColumnType("INTEGER");
- b.HasKey("Id");
- b.HasIndex("Amount");
- b.HasIndex("FuelProductCode");
- b.HasIndex("SiteLevelNozzleId");
- b.HasIndex("TransactionId");
- b.HasIndex("PumpId", "NozzleLogicalId");
- b.ToTable("FuelItems");
- });
- modelBuilder.Entity("Gateway.POS.Models.Operator", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
- b.Property<DateTime>("CreatedTimestamp")
- .HasColumnType("TEXT");
- b.Property<string>("Description")
- .HasColumnType("TEXT");
- b.Property<string>("Name")
- .HasColumnType("TEXT");
- b.Property<string>("Password")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.HasIndex("Name")
- .IsUnique();
- b.ToTable("Operators");
- });
- modelBuilder.Entity("Gateway.POS.Models.Payment", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
- b.Property<string>("AuthCode")
- .HasColumnType("TEXT");
- b.Property<string>("BillNumber")
- .HasColumnType("TEXT");
- b.Property<string>("Comment")
- .HasColumnType("TEXT");
- b.Property<decimal>("ExpectAmount")
- .HasColumnType("TEXT");
- b.Property<int>("Method")
- .HasColumnType("INTEGER");
- b.Property<decimal>("PaidAmount")
- .HasColumnType("TEXT");
- b.Property<int>("TradeStatus")
- .HasColumnType("INTEGER");
- b.Property<int>("TransactionId")
- .HasColumnType("INTEGER");
- b.HasKey("Id");
- b.HasIndex("TransactionId");
- b.ToTable("Payment");
- });
- modelBuilder.Entity("Gateway.POS.Models.Transaction", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("ClientSideTimestamp")
- .HasColumnType("TEXT");
- b.Property<string>("Comment")
- .HasColumnType("TEXT");
- b.Property<decimal?>("NetAmount")
- .HasColumnType("TEXT");
- b.Property<int>("OperatorId")
- .HasColumnType("INTEGER");
- b.Property<string>("ReceiptId")
- .HasColumnType("TEXT");
- b.Property<DateTime>("ServerSideTimestamp")
- .HasColumnType("TEXT");
- b.Property<string>("ShiftId")
- .HasColumnType("TEXT");
- b.Property<string>("SiteId")
- .HasColumnType("TEXT");
- b.Property<string>("TerminalId")
- .HasColumnType("TEXT");
- b.Property<decimal?>("TotalAmount")
- .HasColumnType("TEXT");
- b.Property<int>("TransactionType")
- .HasColumnType("INTEGER");
- b.HasKey("Id");
- b.HasIndex("Id")
- .IsUnique();
- b.HasIndex("NetAmount");
- b.HasIndex("OperatorId");
- b.HasIndex("ReceiptId")
- .IsUnique();
- b.HasIndex("ServerSideTimestamp");
- b.HasIndex("ShiftId");
- b.HasIndex("TotalAmount");
- b.ToTable("Transactions");
- });
- modelBuilder.Entity("Gateway.POS.Models.AppliedDiscount", b =>
- {
- b.HasOne("Gateway.POS.Models.Discount", "Discount")
- .WithMany()
- .HasForeignKey("DiscountId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.HasOne("Gateway.POS.Models.Transaction", null)
- .WithMany("AppliedDiscounts")
- .HasForeignKey("TransactionId");
- b.Navigation("Discount");
- });
- modelBuilder.Entity("Gateway.POS.Models.FuelItem", b =>
- {
- b.HasOne("Gateway.POS.Models.Transaction", "Transaction")
- .WithMany("FuelItems")
- .HasForeignKey("TransactionId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.Navigation("Transaction");
- });
- modelBuilder.Entity("Gateway.POS.Models.Payment", b =>
- {
- b.HasOne("Gateway.POS.Models.Transaction", "Transaction")
- .WithMany("Payments")
- .HasForeignKey("TransactionId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.Navigation("Transaction");
- });
- modelBuilder.Entity("Gateway.POS.Models.Transaction", b =>
- {
- b.HasOne("Gateway.POS.Models.Operator", "Operator")
- .WithMany()
- .HasForeignKey("OperatorId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.Navigation("Operator");
- });
- modelBuilder.Entity("Gateway.POS.Models.Transaction", b =>
- {
- b.Navigation("AppliedDiscounts");
- b.Navigation("FuelItems");
- b.Navigation("Payments");
- });
- #pragma warning restore 612, 618
- }
- }
- }
|