FCC/Applications/ClassicCpuCardPayment/ClassicCpuCardApp/AppDbContext.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Text;

namespace ClassicCpuCardApp
{
    class AppDbContext : DbContext
    {
        private DbContextOptions options;
        public AppDbContext() : base()
        {
        }
        //public AppDbContext(DbContextOptions options) : base(options) { this.options = options; }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlite("Data Source=Gateway_Pos_App_database.db");
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            //modelBuilder.Entity<Transaction>().HasIndex(p => new { p.Id }).IsUnique(true);
            //modelBuilder.Entity<Transaction>().HasIndex(p => new { p.ReceiptId }).IsUnique(true);
            //modelBuilder.Entity<Transaction>().HasIndex(p => new { p.ShiftId }).IsUnique(false);
            //modelBuilder.Entity<Transaction>().HasIndex(p => new { p.ServerSideTimestamp }).IsUnique(false);
            //modelBuilder.Entity<Transaction>().HasIndex(p => new { p.TotalAmount }).IsUnique(false);
            //modelBuilder.Entity<Transaction>().HasIndex(p => new { p.NetAmount }).IsUnique(false);

            //modelBuilder.Entity<FuelItem>().HasIndex(p => new { p.Amount }).IsUnique(false);
            //modelBuilder.Entity<FuelItem>().HasIndex(p => new { p.FuelProductCode }).IsUnique(false);
            //modelBuilder.Entity<FuelItem>().HasIndex(p => new { p.SiteLevelNozzleId }).IsUnique(false);
            //modelBuilder.Entity<FuelItem>().HasIndex(p => new { p.PumpId, p.NozzleLogicalId }).IsUnique(false);

            //modelBuilder.Entity<Operator>().HasIndex(p => new { p.Name }).IsUnique(true);

            //#region otherwise, sqlite does not support Sum on decimal columns, so here underlying use double.

            //modelBuilder.Entity<Transaction>().Property(e => e.TotalAmount).HasConversion<double>();
            //modelBuilder.Entity<Transaction>().Property(e => e.NetAmount).HasConversion<double>();

            //modelBuilder.Entity<Gateway.POS.Models.Payment>().Property(e => e.ExpectAmount).HasConversion<double>();
            //modelBuilder.Entity<Gateway.POS.Models.Payment>().Property(e => e.PaidAmount).HasConversion<double>();

            //modelBuilder.Entity<FuelItem>().Property(e => e.Qualtity).HasConversion<double>();
            //modelBuilder.Entity<FuelItem>().Property(e => e.Amount).HasConversion<double>();
            //modelBuilder.Entity<FuelItem>().Property(e => e.Price).HasConversion<double>();
            //modelBuilder.Entity<FuelItem>().Property(e => e.TotalVolume).HasConversion<double>();

            //#endregion

        }

        //public DbSet<Transaction> Transactions { get; set; }
        //public DbSet<Discount> Discounts { get; set; }

        //public DbSet<FuelItem> FuelItems { get; set; }
        //public DbSet<Models.Payment> Payments { get; set; }
        //public DbSet<Operator> Operators { get; set; }
    }
}