public void AddTradingLot(TradingLot tradingLot)
 {
     try
     {
         dbSet.Add(tradingLot);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public void DeleteTradingLotById(int id)
 {
     try
     {
         TradingLot tradingLot = dbSet.Find(id);
         DeleteTradingLot(tradingLot);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public void UpdateTradingLot(TradingLot tradingLot)
 {
     try
     {
         dbSet.Attach(tradingLot);
         Database.Entry(tradingLot).State = EntityState.Modified;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        public void DeleteTradingLot(TradingLot tradingLot)
        {
            try
            {
                if (Database.Entry(tradingLot).State == EntityState.Detached)
                {
                    dbSet.Attach(tradingLot);
                }

                dbSet.Remove(tradingLot);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }