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();
}
}
