public string CreateMenu_Food(int menuid, DataTable idfood)
{
string result = "0";
try
{
foreach (DataRow dataRow in idfood.Rows)
{
var menufood = new Menus_Foods() { IDFood = Convert.ToInt32(dataRow["ID"]), IDMenu = menuid };
aDatabaseDA.Menus_Foods.Add(menufood);
aDatabaseDA.SaveChanges();
result = "Tạo menu thành công";
}
}
catch (Exception ex)
{
result = "Lỗi hệ thống";
}
return result;
}
//hiennv
public void UpdateMenus(MenusEN aMenusEN)
{
try
{
Menus_FoodsBO aMenus_FoodsBO = new Menus_FoodsBO();
MenusBO aMenusBO = new MenusBO();
Menus aMenus = aMenusBO.Select_ByID(aMenusEN.ID);
aMenus.Name = aMenusEN.Name;
aMenus.Info = aMenusEN.Info;
aMenus.IDBookingHall = aMenusEN.IDBookingHall;
aMenus.IDSystemUser = aMenusEN.IDSystemUser;
aMenusBO.Update(aMenus);
aMenus_FoodsBO.Delete_ByIDMenu(aMenusEN.ID);
foreach (Foods item in aMenusEN.aListFoods)
{
Menus_Foods aMenus_Foods = new Menus_Foods();
aMenus_Foods.IDMenu = aMenusEN.ID;
aMenus_Foods.IDFood = item.ID;
aMenus_FoodsBO.Insert(aMenus_Foods);
}
}
catch (Exception ex)
{
throw new Exception(string.Format("ReceptionTaskBO.UpdateMenus:" + ex.Message));
}
}
//hiennv
public void CreateMenus(MenusEN aMenusEN)
{
try
{
MenusBO aMenusBO = new MenusBO();
Menus aMenus = new Menus();
aMenus.Name = aMenusEN.Name;
aMenus.Issue = aMenusEN.Issue;
aMenus.Info = aMenusEN.Info;
aMenus.Type = aMenusEN.Type;
aMenus.Status = aMenusEN.Status;
aMenus.Disable = aMenusEN.Disable;
aMenus.IDBookingHall = aMenusEN.IDBookingHall;
aMenus.IDSystemUser = aMenusEN.IDSystemUser;
int IDMenu = aMenusBO.Insert(aMenus);
if (IDMenu > 0)
{
foreach (Foods item in aMenusEN.aListFoods)
{
Menus_FoodsBO aMenus_FoodsBO = new Menus_FoodsBO();
Menus_Foods aMenus_Foods = new Menus_Foods();
aMenus_Foods.IDMenu = IDMenu;
aMenus_Foods.IDFood = item.ID;
aMenus_FoodsBO.Insert(aMenus_Foods);
}
}
}
catch (Exception ex)
{
throw new Exception(string.Format("ReceptionTaskBO.CreateMenus:" + ex.Message));
}
}
//=======================================================
//Author: Hiennv
//Function : Insert
//=======================================================
public int Insert(Menus_Foods aMenus_Foods)
{
try
{
aDatabaseDA.Menus_Foods.Add(aMenus_Foods);
return aDatabaseDA.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(string.Format("Menus_FoodsBO.Insert :" + ex.Message));
}
}