public void Add(Order ord, List <OrderDetail> lstOrdD) { using (SellerEntities ent = new SellerEntities()) { Order tempOrd = new Order { IsFixed = ord.IsFixed, DateOfIssue = ord.DateOfIssue, Payment = ord.Payment, Remainder = ord.Remainder, Total = ord.Total, CusId = ord.CusId, }; ent.Orders.Add(tempOrd); ent.SaveChanges(); foreach (OrderDetail ordD in lstOrdD) { OrderDetail tempOrdD = new OrderDetail { OrderId = tempOrd.Id, Price = ordD.Price, ProId = ordD.ProId, Quantity = ordD.Quantity, Amount = ordD.Amount }; ent.OrderDetails.Add(tempOrdD); Product proc = ent.Products.Where(c => c.Id == tempOrdD.ProId).FirstOrDefault(); proc.Quantity -= tempOrdD.Quantity; GeneralSale sale = new GeneralSale { ProId = ordD.ProId, Amount = ordD.Amount, Quantity = ordD.Quantity, Month = DateTime.Now.Month, Year = DateTime.Now.Year }; new GeneralSaleDAO().Add(sale); ent.SaveChanges(); } PaymentDetail paym = new PaymentDetail { OrderId = tempOrd.Id, PayDate = tempOrd.DateOfIssue.Value, Paid = tempOrd.Payment, Remainder = tempOrd.Remainder }; ent.PaymentDetails.Add(paym); ent.SaveChanges(); } }
public void Add(GeneralSale sale) { using (SellerEntities ent = new SellerEntities()) { var curSale = ent.GeneralSales.Where(c => c.ProId == sale.ProId && c.Year == sale.Year && c.Month == sale.Month).First(); if (curSale != null) { curSale.Quantity += sale.Quantity; curSale.Amount += sale.Amount.Value; } else { ent.GeneralSales.Add(sale); } ent.SaveChanges(); } }