public static void insert(tbl_FoodItem fooditem)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_FoodItem.Add(fooditem);
db.SaveChanges();
}
public List <menuItem> SearchSelectedMenuItems(int s)
{
using (RMSDBEntities db = new RMSDBEntities())
{
return(db.menuItems.Where(t => t.cat_id == s).ToList());
}
}
public static void insert(tbl_DeliveryQueue dq)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_DeliveryQueue.Add(dq);
db.SaveChanges();
}
public List <Stock_Tbl> GetAllStock( )
{
using (RMSDBEntities db = new RMSDBEntities())
{
return(db.Stock_Tbl.ToList());
}
}
public List <menuCategory> GetSelectedMenuCatogery(string s)
{
using (RMSDBEntities db = new RMSDBEntities())
{
return(db.menuCategories.Where(a => a.name == s).ToList());
}
}
public static void delete(tbl_DepositHead customer)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_DepositHead.Remove(customer);
db.SaveChanges();
}
public static void delete(tbl_FoodItemCategory categroy)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_FoodItemCategory.Remove(categroy);
db.SaveChanges();
}
public List <UserTable> GetAllUser()
{
using (RMSDBEntities db = new RMSDBEntities())
{
return(db.UserTables.ToList());
}
}
public static void insert(tbl_DetuctInventory di)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_DetuctInventory.Add(di);
db.SaveChanges();
}
public List <Subcription_Tbl> getallkeys()
{
using (RMSDBEntities db = new RMSDBEntities())
{
return(db.Subcription_Tbl.ToList());
}
}
public static void insert(tbl_ExpenceHead eh)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_ExpenceHead.Add(eh);
db.SaveChanges();
}
private void DevelopersControl_Load(object sender, EventArgs e)
{
try
{
using (RMSDBEntities db = new RMSDBEntities())
{
var TempObj = db.POS_Tbl.Where(d => d.Id == 1).SingleOrDefault();
if (TempObj != null)
{
RName.Text = TempObj.Name;
RPhoneNumber.Text = TempObj.PhoneNumber;
RAddress.Text = TempObj.Address;
pictureBox1.Image = ConvertBinaryToImage(TempObj.Pic);
buttonSave.Text = "Update";
}
else
{
MessageBox.Show("Bad Request Try Again latter");
}
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, "Error In Loading Data for updation");
}
}
public List <Subcription_Tbl> KeyMatch(string n)
{
using (RMSDBEntities db = new RMSDBEntities())
{
return(db.Subcription_Tbl.Where(a => a.SubcriptionKey == n).ToList());
}
}
public static void delete(tbl_FoodItem fooditem)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_FoodItem.Remove(fooditem);
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_DetuctInventory di)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_DetuctInventory.Remove(di);
db.SaveChanges();
}
public static void insert(tbl_DepositHead customer)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_DepositHead.Add(customer);
db.SaveChanges();
}
public static void insert(tbl_Staff staff)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_Staff.Add(staff);
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_Staff staff)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_Staff.Remove(staff);
db.SaveChanges();
}
public List <UserTable> GetAllCahier()
{
using (RMSDBEntities db = new RMSDBEntities())
{
return(db.UserTables.Where(a => a.IsAdmin == 0).ToList());
}
}
public static void insert(tbl_PurchaseOrder po)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_PurchaseOrder.Add(po);
db.SaveChanges();
}
public List <menuCategory> GetAllMenuCatogery()
{
using (RMSDBEntities db = new RMSDBEntities())
{
return(db.menuCategories.ToList());
}
}
public static void delete(tbl_PurchaseOrder po)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_PurchaseOrder.Remove(po);
db.SaveChanges();
}
public List <menuItem> GetAllMenuItems()
{
using (RMSDBEntities db = new RMSDBEntities())
{
return(db.menuItems.ToList());
}
}
public static void insert(tbl_KitchenInventory ki)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_KitchenInventory.Add(ki);
db.SaveChanges();
}
public List <Login_Tbl> record()
{
using (RMSDBEntities db = new RMSDBEntities())
{
return(db.Login_Tbl.ToList());
}
}
public static void delete(tbl_KitchenInventory ki)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_KitchenInventory.Remove(ki);
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_FinanceChart fc)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_FinanceChart.Add(fc);
db.SaveChanges();
}
