public int AddNewTable(TableDetails td) { tbl_table tt = new tbl_table(); tt.TableNumber = td.TableNumber; tt.AddedDate = td.AddedDate; _db.tbl_table.Add(tt); return(_db.SaveChanges()); }
public int AddNewCategory(CategoryDetails cd) { tbl_category tc = new tbl_category(); tc.CategoryName = cd.CategoryName; tc.AddedDate = cd.AddedDate; _db.tbl_category.Add(tc); return(_db.SaveChanges()); }
public int AddNewWaiter(WaiterDetails wd) { tbl_waiter tw = new tbl_waiter(); tw.WaiterName = wd.WaiterName; tw.WaiterContact = wd.WaiterContact; tw.WaiterAddress = wd.WaiterAddress; _db.tbl_waiter.Add(tw); return(_db.SaveChanges()); }
public static void delete(int dealId) { RMSDBEntities db = DBContext.getInstance(); tbl_Deal d = getById(dealId); db.tbl_Deal.Remove(d); db.SaveChanges(); List <tbl_DealFoodItem> list = db.tbl_DealFoodItem.Where(a => a.Deal_Id == dealId).ToList(); db.tbl_DealFoodItem.RemoveRange(list); db.SaveChanges(); }
public int AddOrderedItem(ItemDetails cd) { tbl_orderedfooditem tc = new tbl_orderedfooditem(); //tc.CId = cd.CId; tc.OrderNo = cd.OrderNo; tc.FoodId = cd.FoodId; tc.Qty = cd.Qty; tc.Total = cd.Total; _db.tbl_orderedfooditem.Add(tc); return(_db.SaveChanges()); }
public int AddNewUser(UserDetails ud) { Userdetail td = new Userdetail(); td.FirstName = ud.FirstName; td.LastName = ud.LastName; td.Email = ud.Email; td.Username = ud.Username; td.Password = ud.Password; td.Usertype = ud.Usertype; _db.Userdetails.Add(td); return(_db.SaveChanges()); }
public int AddNewFoodItem(FoodItemDetails fd) { tbl_fooditems tf = new tbl_fooditems(); tf.CategoryName = fd.CategoryName; tf.Price = fd.Price; tf.Status = Convert.ToByte(fd.Status); tf.IsSpecial = Convert.ToByte(fd.IsSpecial); tf.Discount = fd.Discount; tf.Image = fd.Image; tf.FoodName = fd.FoodName; _db.tbl_fooditems.Add(tf); return(_db.SaveChanges()); }
public int AddCustomer(CustomerDetails cd) { tbl_customer tc = new tbl_customer(); tc.OrderNo = cd.OrderNo; tc.CustomerName = cd.CustomerName; tc.CustomerType = cd.CustomerType; tc.WaiterId = cd.WaiterId; tc.TableId = cd.TableId; tc.Completed = Convert.ToBoolean(cd.Completed); tc.Total = cd.Total; tc.OrderDate = cd.OrderDate; _db.tbl_customer.Add(tc); return(_db.SaveChanges()); }
public static void insert(tbl_FoodItem fooditem) { RMSDBEntities db = DBContext.getInstance(); db.tbl_FoodItem.Add(fooditem); db.SaveChanges(); }
public static void insert(tbl_PurchaseOrder po) { RMSDBEntities db = DBContext.getInstance(); db.tbl_PurchaseOrder.Add(po); db.SaveChanges(); }
public static void delete(tbl_Staff staff) { RMSDBEntities db = DBContext.getInstance(); db.tbl_Staff.Remove(staff); db.SaveChanges(); }
public static void insert(tbl_Staff staff) { RMSDBEntities db = DBContext.getInstance(); db.tbl_Staff.Add(staff); db.SaveChanges(); }
public static void delete(tbl_DetuctInventory di) { RMSDBEntities db = DBContext.getInstance(); db.tbl_DetuctInventory.Remove(di); db.SaveChanges(); }
public static void delete(tbl_KitchenInventory ki) { RMSDBEntities db = DBContext.getInstance(); db.tbl_KitchenInventory.Remove(ki); db.SaveChanges(); }
public static void insert(tbl_ExpenceHead eh) { RMSDBEntities db = DBContext.getInstance(); db.tbl_ExpenceHead.Add(eh); db.SaveChanges(); }
public static void delete(tbl_FoodItem fooditem) { RMSDBEntities db = DBContext.getInstance(); db.tbl_FoodItem.Remove(fooditem); db.SaveChanges(); }
public static void insert(tbl_KitchenInventory ki) { RMSDBEntities db = DBContext.getInstance(); db.tbl_KitchenInventory.Add(ki); db.SaveChanges(); }
public static void insert(tbl_DetuctInventory di) { RMSDBEntities db = DBContext.getInstance(); db.tbl_DetuctInventory.Add(di); db.SaveChanges(); }
public static void insert(tbl_SaleItem saleItem) { RMSDBEntities db = DBContext.getInstance(); db.tbl_SaleItem.Add(saleItem); db.SaveChanges(); }
public static void delete(tbl_PurchaseOrder po) { RMSDBEntities db = DBContext.getInstance(); db.tbl_PurchaseOrder.Remove(po); db.SaveChanges(); }
public static void deleteById(int id) { RMSDBEntities db = DBContext.getInstance(); db.tbl_DeliveryQueue.Remove(db.tbl_DeliveryQueue.Find(id)); db.SaveChanges(); }
public static void insert(tbl_DeliveryQueue dq) { RMSDBEntities db = DBContext.getInstance(); db.tbl_DeliveryQueue.Add(dq); db.SaveChanges(); }
public static void insert(tbl_FinanceChart fc) { RMSDBEntities db = DBContext.getInstance(); db.tbl_FinanceChart.Add(fc); db.SaveChanges(); }
public static void delete(tbl_FoodItemCategory categroy) { RMSDBEntities db = DBContext.getInstance(); db.tbl_FoodItemCategory.Remove(categroy); db.SaveChanges(); }
public static void insert(tbl_FoodItemCategory category) { RMSDBEntities db = DBContext.getInstance(); db.tbl_FoodItemCategory.Add(category); db.SaveChanges(); }
public static void delete(tbl_DepositHead customer) { RMSDBEntities db = DBContext.getInstance(); db.tbl_DepositHead.Remove(customer); db.SaveChanges(); }
public static void insert(tbl_DepositHead customer) { RMSDBEntities db = DBContext.getInstance(); db.tbl_DepositHead.Add(customer); db.SaveChanges(); }
public static void delete(tbl_ExpenceSubHead esh) { RMSDBEntities db = DBContext.getInstance(); Expence.deleteBySubExpenceHeadId(esh.Id); db.tbl_ExpenceSubHead.Remove(esh); db.SaveChanges(); }
public static void deleteByExpenceHeadId(int expenceHeadId) { RMSDBEntities db = DBContext.getInstance(); List <tbl_ExpenceSubHead> list = db.tbl_ExpenceSubHead.Where(a => a.ExpenseHead_Id == expenceHeadId).ToList(); db.tbl_ExpenceSubHead.RemoveRange(list); db.SaveChanges(); }
public static void deleteSaleItemsBySaleId(int saleId) { RMSDBEntities db = DBContext.getInstance(); List <tbl_SaleItem> list = db.tbl_SaleItem.Where(a => a.Sale_id == saleId).ToList(); db.tbl_SaleItem.RemoveRange(list); db.SaveChanges(); }