public bool SaveSaleDetailItems(SaleDetail model, int checkupdate)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (checkupdate == 0)
{
db.SaleDetails.Add(model);
db.SaveChanges();
return(true);
}
else
{
SaleDetail RowinDb = db.SaleDetails.Where(d => d.TicketNo == model.TicketNo && d.ItemId == model.ItemId).SingleOrDefault();
RowinDb.ItemId = model.ItemId;
RowinDb.itemName = model.itemName;
RowinDb.Price = model.Price;
RowinDb.Discount = model.Discount;
RowinDb.Quantity = model.Quantity;
RowinDb.Total = model.Total;
RowinDb.TicketNo = model.TicketNo;
RowinDb.RecordID = model.RecordID;
RowinDb.Aed_Vat = model.Aed_Vat;
RowinDb.Aed_Vat_Amount = model.Aed_Vat_Amount;
RowinDb.Date = model.Date;
db.SaveChanges();
return(true);
}
}
}
public bool Delete_SaleItemFromSaleDetail(int id)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (id != 0)
{
SaleDetail RowinDb = db.SaleDetails.Where(d => d.RecordID == id).SingleOrDefault();
{
db.SaleDetails.Remove(RowinDb);
db.SaveChanges();
return(true);
}
}
else
{
return(false);
}
}
}