public ActionResult Create()
{
var lstJoin = (from pro in DA_Product.Instance.GetAll()
join type in DA_ProductType.Instance.GetAll() on pro.ProductTypeID equals type.ProductTypeID
orderby pro.ProductName
select new { pro.ProductID, pro.ProductName, type.ProductTypeName }).ToList();
IList <Product_MenuProduct_Ext> lstProductExt = new List <Product_MenuProduct_Ext>();
foreach (var item in lstJoin)
{
Product_MenuProduct_Ext ext = new Product_MenuProduct_Ext
{
ProductID = item.ProductID,
ProductName = item.ProductName,
ProductTypeName = item.ProductTypeName
};
lstProductExt.Add(ext);
}
ViewBag.ListProduct = lstProductExt;
ViewBag.ListShift = DA_Shift.Instance.GetAll();
ViewBag.ListMenuDay = DA_MenuProduct.Instance.GetListMenuDay();
return(View());
}
public IList <Product_MenuProduct_Ext> GetScheduleProduct()
{
IList <Product_MenuProduct_Ext> lstSchedule_Menu_Product = new List <Product_MenuProduct_Ext>();
using (var context = (HRM_ROHTOEntities)Activator.CreateInstance(typeof(HRM_ROHTOEntities), _connectionStr))
{
var lst = from menu in context.TBL_SCHEDULE_MENU
join menu_pro in context.TBL_SCHEDULE_MENU_PRODUCT on menu.ScheduleMenuID equals menu_pro.ScheduleMenuID
join menu_shi in context.TBL_SCHEDULE_MENU_SHIFT on menu.ScheduleMenuID equals menu_shi.ScheduleMenuID
join pro in context.TBL_PRODUCT on menu_pro.ProductID equals pro.ProductID
select new { pro.ProductName, menu.MealDate, menu_shi.ShiftID, pro.ProductTypeID };
foreach (var item in lst)
{
Product_MenuProduct_Ext ext = new Product_MenuProduct_Ext
{
ProductName = item.ProductName,
MealDate = item.MealDate,
ShiftID = item.ShiftID,
ProductTypeID = item.ProductTypeID
};
lstSchedule_Menu_Product.Add(ext);
}
}
return(lstSchedule_Menu_Product);
}
public ActionResult Edit(int menuID)
{
ViewBag.ListMenuDay = DA_MenuProduct.Instance.GetListMenuDay();
var ListMenuProDuct = from a in DA_MenuProduct.Instance.GetAll()
join b in DA_Product.Instance.GetAll() on a.ProductID equals b.ProductID
join c in DA_ProductType.Instance.GetAll() on b.ProductTypeID equals c.ProductTypeID
where a.MenuID == menuID
select new { b.ProductID, b.ProductName, a.MenuID, c.ProductTypeName };
//var ListMenuProDuct = DA_Product.Instance.GetAll().Join(DA_MenuProduct.Instance.GetAll(), x => x.ProductID, y => y.ProductID, (x, y) => new { ProductID = x.ProductID, ProductName = x.ProductName, MenuID = y.MenuID }).Where(x => x.MenuID == menuID).OrderBy(x => x.ProductName).ToList();
List <Product_MenuProduct_Ext> LstProduct_MenuProduct = new List <Product_MenuProduct_Ext>();
foreach (var item in ListMenuProDuct)
{
Product_MenuProduct_Ext ext = new Product_MenuProduct_Ext
{
MenuID = menuID,
ProductID = item.ProductID,
ProductName = item.ProductName,
ProductTypeName = item.ProductTypeName
};
LstProduct_MenuProduct.Add(ext);
}
ViewBag.LstMenuProduct = LstProduct_MenuProduct.OrderBy(x => x.MenuID);
List <ProductExt> lstProExt = new List <ProductExt>();
foreach (var pro in DA_Product.Instance.GetAll().OrderBy(x => x.ProductName).Join(DA_ProductType.Instance.GetAll(), x => x.ProductTypeID, y => y.ProductTypeID, (x, y) => new { x.ProductID, x.ProductName, y.ProductTypeName }))
{
if (ListMenuProDuct.FirstOrDefault(x => x.ProductID == pro.ProductID) == null)
{
ProductExt ext = new ProductExt
{
ProductID = pro.ProductID,
ProductName = pro.ProductName,
ProductTypeName = pro.ProductTypeName
};
lstProExt.Add(ext);
}
}
ViewBag.LstProduct = lstProExt;
//
var ListMenuShift = DA_Shift.Instance.GetAll().Join(DA_MenuShift.Instance.GetAll(), x => x.ShiftID, y => y.ShiftID, (x, y) => new { ShiftID = x.ShiftID, ShiftName = x.ShiftName, MenuID = y.MenuID }).Where(x => x.MenuID == menuID).ToList();
List <Menu_Shift_Ext> LstMenu_Shift = new List <Menu_Shift_Ext>();
foreach (var item in ListMenuShift)
{
Menu_Shift_Ext ext = new Menu_Shift_Ext
{
MenuID = menuID,
ShiftID = item.ShiftID,
ShiftName = item.ShiftName,
};
LstMenu_Shift.Add(ext);
}
ViewBag.LstShift = DA_Shift.Instance.GetAll();
ViewBag.LstMenuShift = LstMenu_Shift;
return(View(DA_Menu.Instance.GetById(menuID)));
}
