public ActionResult Edit(int?id, int?page)
{
//記錄目前頁數,若是空值就給1
TempData["savepage"] = page ?? 1;
var av = db.Activities.Find(id ?? 1);
ActivityEditViewModel aevm = new ActivityEditViewModel();
List <ActivityProdViewModel> apList = new List <ActivityProdViewModel>();
aevm.ActivityID = av.ActivityID;
aevm.ActivityName = av.ActivityName;
aevm.BeginDate = av.BeginDate;
aevm.EndDate = av.EndDate;
aevm.DiscountID = av.DiscountID;
aevm.DiscountName = db.DiscountMethods.Find(av.DiscountID).DiscountName;
aevm.CreateDate = av.CreateDate;
aevm.PhotoID = av.PhotoID;
var ap = db.ActivityProducts.Where(x => x.ActivityID == id);
List <Product> prod = db.Products.ToList();
List <VW_EW_CategorySM> cateMS = db.VW_EW_CategorySM.ToList();
List <Supplier> suppliers = db.Suppliers.ToList();
List <ProductPhoto> prodPhoto = db.ProductPhotoes.ToList();
foreach (var item in ap)
{
ActivityProdViewModel apvm = new ActivityProdViewModel();
apvm.ActivityID = item.ActivityID;
apvm.ProductID = item.ProductID;
var pd = prod.Where(x => x.ProductID == item.ProductID).FirstOrDefault();
apvm.ProductName = pd.ProductName;
apvm.CategoryMSName = cateMS.Where(x => x.CategorySID == pd.CategorySID).FirstOrDefault().CategoryName;
apvm.SupplierName = suppliers.Where(x => x.SupplierID == pd.SupplierID).FirstOrDefault().SupplierName;
if (prodPhoto.Any(x => x.ProductID == item.ProductID && ((x.PhotoID == null ? 0 : x.PhotoID) > 0)))
{
apvm.PhotoID = (int)prodPhoto.Where(x => x.ProductID == item.ProductID).FirstOrDefault().PhotoID;
}
//aevm.producstList
apList.Add(apvm);
}
aevm.producstList = apList;
ViewBag.datas = db.DiscountMethods;
return(View(aevm));
}
public ActionResult Edit(int id)
{
//活動內容更改 View
ActivityEditModel _AEM = new ActivityEditModel();
var _av = db.Activities.Find(id);
_AEM.ActivityID = _av.ActivityID;
_AEM.ActivityName = _av.ActivityName;
_AEM.BeginDate = _av.BeginDate;
_AEM.EndDate = _av.EndDate;
_AEM.DiscountID = _av.DiscountID;
_AEM.DiscountName = db.DiscountMethods.Find(_av.DiscountID).DiscountName;
_AEM.CreateDate = _av.CreateDate;
//活動商品明細 View
List <ActivityProdViewModel> _Listapvm = new List <ActivityProdViewModel>();
var _ap = db.ActivityProducts.Where(W => W.ActivityID == id);
List <Product> prod = db.Products.ToList();
List <VW_EW_CategorySM> cateMS = db.VW_EW_CategorySM.ToList();
List <Supplier> suppliers = db.Suppliers.ToList();
List <ProductPhoto> prodPhoto = db.ProductPhotoes.ToList();
foreach (var _data in _ap)
{
ActivityProdViewModel _apvm = new ActivityProdViewModel();
_apvm.ActivityID = _data.ActivityID;
_apvm.ProductID = _data.ProductID;
var _pd = db.Products.Where(W => W.ProductID == _data.ProductID).FirstOrDefault();
_apvm.ProductName = _pd.ProductName;
_apvm.CategoryMSName = cateMS.Where(x => x.CategorySID == _pd.CategorySID).FirstOrDefault().CategoryName;
_apvm.SupplierName = suppliers.Where(x => x.SupplierID == _pd.SupplierID).FirstOrDefault().SupplierName;
if (prodPhoto.Any(x => x.ProductID == _data.ProductID && ((x.PhotoID == null ? 0 : x.PhotoID) > 0)))
{
_apvm.PhotoID = (int)prodPhoto.Where(x => x.ProductID == _data.ProductID).FirstOrDefault().PhotoID;
}
//aevm.producstList
_Listapvm.Add(_apvm);
}
_AEM.ProdList = _Listapvm;
ViewBag.temp = db.DiscountMethods;
return(View(_AEM));
}
