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