public List <MENU> Show()
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
return(db.MENUs.ToList());
}
}
public void InsertResource(FOOD_RESOURCE fOOD_RESOURCE)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
db.FOOD_RESOURCEs.InsertOnSubmit(fOOD_RESOURCE);
db.SubmitChanges();
}
}
public void UpdateTable(TABLE table)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext()) {
TABLE tb = (from t in db.TABLEs where t.ID == table.ID select t).FirstOrDefault();
tb.STATUS = table.STATUS;
tb.TABLE_NAME = table.TABLE_NAME;
db.SubmitChanges();
}
}
public TABLE getCurrentTable(int tableID)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
TABLE table = new TABLE();
table = (from tb in db.TABLEs where tb.ID == tableID select tb).FirstOrDefault();
return(table);
}
}
public void DeleteTable(TABLE table)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
TABLE tb = (from t in db.TABLEs where t.ID == table.ID select t).FirstOrDefault();
db.TABLEs.DeleteOnSubmit(tb);
db.SubmitChanges();
}
}
public List <TABLE> GetTableAvailable()
{
List <TABLE> list = new List <TABLE>();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
list = db.TABLEs.Where(t => t.STATUS == 0).ToList();
}
return(list);
}
public bool updateStatusTableNotAvailable(int idTable)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
TABLE tb = db.TABLEs.Single(p => p.ID == idTable);
tb.STATUS = 1;
db.SubmitChanges();
return(true);
}
}
public List <FOOD_RESOURCE> ShowFoodResource()
{
List <FOOD_RESOURCE> lstFoodResource = new List <FOOD_RESOURCE>();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
lstFoodResource = db.FOOD_RESOURCEs.ToList();
}
return(lstFoodResource);
}
public USER CheckRememberUser(string UserName)
{
USER user = null;
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
user = (USER)(from u in db.USERs where u.USER_NAME == UserName.Trim() && u.REMEMBER == 1 select u).FirstOrDefault();
return(user);
}
}
public List <PERMISSION> ShowPermission()
{
List <PERMISSION> pers = new List <PERMISSION>();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
pers = db.PERMISSIONs.ToList();
}
return(pers);
}
public USER SignIn(string UserName, string PassWord)
{
USER RegistedUser = null;
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
RegistedUser = (USER)(from u in db.USERs where u.USER_NAME == UserName.Trim() && u.PASSWORD == PassWord.Trim() select u).FirstOrDefault();
}
return(RegistedUser);
}
public List <TABLE> GetListTables()
{
List <TABLE> tables = new List <TABLE>();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
tables = (from t in db.TABLEs orderby t.TABLE_NAME select t).ToList();
}
return(tables);
}
public TABLE GetTableByName(int tableName)
{
TABLE tb = null;
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
tb = (from t in db.TABLEs where t.TABLE_NAME == tableName select t).FirstOrDefault();
return(tb);
}
}
public List <DETAIL_ORDER> OrderListDetail(int idOrder)
{
List <DETAIL_ORDER> list = new List <DETAIL_ORDER>();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
list = db.DETAIL_ORDERs.Where(o => o.ID_ORDER == idOrder).ToList();
}
return(list);
}
public List <DRINK> ListDrinks()
{
List <DRINK> list = new List <DRINK>();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
list = db.DRINKs.ToList();
}
return(list);
}
public List <FOOD> FoodMenu()
{
List <FOOD> lstResource = new List <FOOD>();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
lstResource = db.FOODs.ToList();
}
return(lstResource);
}
public List <DETAIL_ORDER> getListDetailOrderByTableID(int tableID)
{
List <DETAIL_ORDER> listOrder = new List <DETAIL_ORDER>();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
listOrder = (from o in db.ORDERs join dt in db.DETAIL_ORDERs on o.ID equals dt.ID_ORDER where o.ID_TABLE == tableID && o.PAY == 0 select dt).ToList();
return(listOrder);
}
}
public bool DeleteOrderDetail(int id)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
DETAIL_ORDER dt = db.DETAIL_ORDERs.Single(i => i.ID == id);
db.DETAIL_ORDERs.DeleteOnSubmit(dt);
db.SubmitChanges();
return(true);
}
}
public bool DeleteEmployee(int id)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
USER us = db.USERs.Single(u => u.ID == id);
db.USERs.DeleteOnSubmit(us);
db.SubmitChanges();
return(true);
}
}
public List <FOOD> Show()
{
List <FOOD> dishes = new List <FOOD>();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
dishes = db.FOODs.Select(p => p).ToList();
}
return(dishes);
}
public List <FOOD> ListFoods()
{
List <FOOD> list = new List <FOOD>();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
list = db.FOODs.ToList();
}
return(list);
}
public List <FOOD> Get_Food(int food_id)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
var result1 = from f in db.FOODs
join fm in db.MENU_FOODs on f.ID equals fm.ID_Food
where f.ID == food_id
select f;
return(result1.ToList());
}
}
public void RememberSignIn(string UserName, string PassWord, Boolean Remember)
{
USER RegistedUser;
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
RegistedUser = (USER)(from u in db.USERs where u.USER_NAME.Trim() == UserName && u.PASSWORD == PassWord.Trim() select u).FirstOrDefault();
// var RegistedUser = (from u in db.USERs select u).FirstOrDefault();
RegistedUser.REMEMBER = Remember == true ? 1 : 0;
db.SubmitChanges();
}
}
public void AddNewTable(int tableName)
{
TABLE tb = new TABLE();
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
tb.TABLE_NAME = tableName;
tb.STATUS = 0;
db.TABLEs.InsertOnSubmit(tb);
db.SubmitChanges();
}
}
public void PayMent(int tableID)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
ORDER order = new ORDER();
TABLE table = new TABLE();
order = (from o in db.ORDERs where o.ID_TABLE == tableID && o.PAY == 0 select o).FirstOrDefault();
order.PAY = 1;
table = (from tb in db.TABLEs where tb.ID == tableID select tb).FirstOrDefault();
table.STATUS = 0;
db.SubmitChanges();
}
}
public void AddOrder(int idUser, int idTable)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
ORDER order = new ORDER();
order.ID_USER = idUser;
order.ID_TABLE = idTable;
order.TOTAL_MONEY = 0;
order.PAY = 0;
db.ORDERs.InsertOnSubmit(order);
db.SubmitChanges();
}
}
public void Insert_Menu_Food(List <FOOD> fOODs, int id)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
List <MENU_FOOD> foodMenu = new List <MENU_FOOD>();
foreach (FOOD fOOD_ in fOODs)
{
MENU_FOOD menuFood = new MENU_FOOD();
menuFood.ID_Menu = id;
menuFood.ID_Food = fOOD_.ID;
foodMenu.Add(menuFood);
}
db.MENU_FOODs.InsertAllOnSubmit(foodMenu);
db.SubmitChanges();
}
}
public bool UpdateEmployee(int id, string fullName, string gender, string address, int role, string password)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
USER us = db.USERs.Single(u => u.ID == id);
us.FULL_NAME = fullName;
us.GENDER = gender;
us.ADDRESS = address;
us.ROLE = role;
us.PASSWORD = password;
db.SubmitChanges();
return(true);
}
}
public void Insert_Resource_Food(List <FOOD_RESOURCE> fOODs, int id)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
List <FOOD_RESOURCE_MATERIAL> foodMaterial = new List <FOOD_RESOURCE_MATERIAL>();
foreach (FOOD_RESOURCE fOOD_ in fOODs)
{
FOOD_RESOURCE_MATERIAL fOOD_RESOURCE_MATERIAL = new FOOD_RESOURCE_MATERIAL();
fOOD_RESOURCE_MATERIAL.ID_FOOD = id;
fOOD_RESOURCE_MATERIAL.ID_RESOURCE = fOOD_.ID;
foodMaterial.Add(fOOD_RESOURCE_MATERIAL);
}
db.FOOD_RESOURCE_MATERIALs.InsertAllOnSubmit(foodMaterial);
db.SubmitChanges();
}
}
public void AddEmployee(string fullName, string gender, string address, int role, string userName, string passWord)
{
using (QuanLyNhaHangDataContext db = new QuanLyNhaHangDataContext())
{
USER user = new USER();
user.FULL_NAME = fullName;
user.GENDER = gender;
user.ADDRESS = address;
user.ROLE = role;
user.USER_NAME = userName;
user.PASSWORD = passWord;
user.REMEMBER = 0;
db.USERs.InsertOnSubmit(user);
db.SubmitChanges();
}
}
