public bool Save_MenuItems_tables(menuItem model) { using (RMSDBEntities db = new RMSDBEntities()) { if (model.id == 0) { db.menuItems.Add(model); db.SaveChanges(); return(true); } else if (model.id > 0) { menuItem RowinDb = db.menuItems.Where(d => d.id == model.id).SingleOrDefault(); RowinDb.itemName = model.itemName; RowinDb.color = model.color; RowinDb.Price = model.Price; RowinDb.discountpercnt = model.discountpercnt; RowinDb.status = model.status; RowinDb.cat_id = model.cat_id; RowinDb.section_id = model.section_id; db.SaveChanges(); return(true); } return(false); } }
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 SaveUser(UserTable model, int checkupdate) { using (RMSDBEntities db = new RMSDBEntities()) { if (checkupdate == 0) { db.UserTables.Add(model); db.SaveChanges(); return(true); } else { UserTable RowinDb = db.UserTables.Where(d => d.UserName == model.UserName).SingleOrDefault(); RowinDb.FullName = model.FullName; RowinDb.Password = model.Password; RowinDb.ConfirmPassword = model.ConfirmPassword; RowinDb.IsAdmin = model.IsAdmin; db.SaveChanges(); return(true); } } }
public bool SaveCounter(section model) { using (RMSDBEntities db = new RMSDBEntities()) { if (model.id == 0) { db.sections.Add(model); db.SaveChanges(); return(true); } else if (model.id > 0) { section RowinDb = db.sections.Where(d => d.id == model.id).SingleOrDefault(); RowinDb.sectionname = model.sectionname; db.SaveChanges(); return(true); } return(false); } }
public bool Save_MenuCatogery_tables(menuCategory model) { using (RMSDBEntities db = new RMSDBEntities()) { if (model.id == 0) { db.menuCategories.Add(model); db.SaveChanges(); return(true); } else if (model.id > 0) { menuCategory RowinDb = db.menuCategories.Where(d => d.id == model.id).SingleOrDefault(); RowinDb.name = model.name; RowinDb.color = model.color; db.SaveChanges(); return(true); } return(false); } }
public bool Save_DayStartTime(CashierTable model) { using (RMSDBEntities db = new RMSDBEntities()) { if (model.id == 0) { db.CashierTables.Add(model); db.SaveChanges(); return(true); } else if (model.id > 0) { CashierTable RowinDb = db.CashierTables.Where(d => d.CashierId == model.CashierId && d.id == model.id).SingleOrDefault(); RowinDb.EndTime = model.EndTime; RowinDb.TotalHour = model.TotalHour; db.SaveChanges(); return(true); } return(false); } }
public bool Save_R_tables(R_Tables model) { using (RMSDBEntities db = new RMSDBEntities()) { if (model.id == 0) { db.R_Tables.Add(model); db.SaveChanges(); return(true); } else if (model.id > 0) { R_Tables RowinDb = db.R_Tables.Where(d => d.id == model.id).SingleOrDefault(); RowinDb.Name = model.Name; RowinDb.capacity = model.capacity; RowinDb.status = model.status; db.SaveChanges(); return(true); } return(false); } }
public bool remove_filled(string rid, int filled) { using (RMSDBEntities db = new RMSDBEntities()) { R_Tables RowinDb = db.R_Tables.Where(d => d.Name == rid).SingleOrDefault(); { RowinDb.filled = Convert.ToInt32(RowinDb.filled) - (filled); db.SaveChanges(); return(true); } } }
public bool Delete_SaleRowFromSale(string s) { using (RMSDBEntities db = new RMSDBEntities()) { Sale RowinDb = db.Sales.Where(d => d.TicketNo == s).SingleOrDefault(); { RowinDb.IsDeleted = 1; RowinDb.IsBillPending = 0; db.SaveChanges(); return(true); } } }
public bool SaveSale(Sale model, int checkupdate) { using (RMSDBEntities db = new RMSDBEntities()) { // Sale RowinDb = db.Sales.Where(d => d.TicketNo == model.TicketNo).SingleOrDefault(); if (checkupdate == 0) { db.Sales.Add(model); db.SaveChanges(); return(true); } else { Sale RowinDb = db.Sales.Where(d => d.TicketNo == model.TicketNo).SingleOrDefault(); RowinDb.TicketNo = model.TicketNo; RowinDb.TableName = model.TableName; RowinDb.CustomerName = model.CustomerName; RowinDb.OrderType = model.OrderType; RowinDb.Balance = model.Balance; RowinDb.TicketNote = model.TicketNote; RowinDb.IsDeleted = model.IsDeleted; RowinDb.PhoneNumber = model.PhoneNumber; RowinDb.DeliveryAddress = model.DeliveryAddress; RowinDb.IsBillPending = model.IsBillPending; RowinDb.NumberOfPerson = model.NumberOfPerson; RowinDb.ReceivedAmount = model.ReceivedAmount; RowinDb.RemainingBalance = model.RemainingBalance; RowinDb.cashier_id = model.cashier_id; RowinDb.Cahier_Name = model.Cahier_Name; RowinDb.IsRefund = model.IsRefund; db.SaveChanges(); return(true); } } }
public bool SaveSaleReceivedBalanceGen(string tn, double Received, double balance) { using (RMSDBEntities db = new RMSDBEntities()) { { Sale RowinDb = db.Sales.Where(d => d.TicketNo == tn).SingleOrDefault(); RowinDb.ReceivedAmount = Received; RowinDb.RemainingBalance = balance; db.SaveChanges(); return(true); } } }
public bool Delete_MenuCatogery_tables(int id) { using (RMSDBEntities db = new RMSDBEntities()) { if (id > 0) { menuCategory RowinDb = db.menuCategories.Where(d => d.id == id).SingleOrDefault(); if (RowinDb != null) { db.menuCategories.Remove(RowinDb); db.SaveChanges(); } } } return(true); }
public bool DeleteCounter(int id) { using (RMSDBEntities db = new RMSDBEntities()) { if (id > 0) { section RowinDb = db.sections.Where(d => d.id == id).SingleOrDefault(); if (RowinDb != null) { db.sections.Remove(RowinDb); db.SaveChanges(); return(true); } return(false); } return(false); } }
public bool Delete_R_tables(int id) { using (RMSDBEntities db = new RMSDBEntities()) { if (id > 0) { R_Tables RowinDb = db.R_Tables.Where(d => d.id == id).SingleOrDefault(); if (RowinDb != null) { db.R_Tables.Remove(RowinDb); db.SaveChanges(); return(true); } return(false); } return(false); } }
public bool SaveSaleReceivedBalance(string tn, double Received, double balance, int person, string tablename) { using (RMSDBEntities db = new RMSDBEntities()) { { Sale RowinDb = db.Sales.Where(d => d.TicketNo == tn).SingleOrDefault(); RowinDb.IsBillPending = 0; RowinDb.ReceivedAmount = Received; RowinDb.RemainingBalance = balance; R_Tables RowinDb1 = db.R_Tables.Where(d => d.Name == tablename).SingleOrDefault(); RowinDb1.filled = Convert.ToInt32(RowinDb1.filled) - person; 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); } } }