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