//==================================================================== //團購商品新增(ok) public ActionResult Create(int id) { SingleApartmentEntities db = new SingleApartmentEntities(); Product prod = new Product(); Activity AV = db.Activity.Where(p => p.ActivityID == id).FirstOrDefault(); prod.ActivityID = AV.ActivityID; prod.Stock = AV.PeopleCount; //===================================================================== //下拉式選單 var PROsubNamelist = (from p in db.ProductSubCategory select p.ProductSubCategoryName).ToList(); SelectList SUBNamelist = new SelectList(PROsubNamelist, "Name"); ViewBag.SUBNAME = SUBNamelist; //===================================================================== CProductViewModel cprod = new CProductViewModel() { entity = prod }; //抓一筆資料 return(View(cprod)); }
public IActionResult Create() { var data = from p in (new 擺腹BuyFoodContext()).TProductCategories //假設從資料庫撈出資料。 select p; List <SelectListItem> mySelectItemList = new List <SelectListItem>(); foreach (var item in data) { mySelectItemList.Add(new SelectListItem() { Text = item.CCategoryName, Value = item.CProductCategoryId.ToString(), Selected = false }); } var data1 = from p in (new 擺腹BuyFoodContext()).TEatPeriods //假設從資料庫撈出資料。 select p; List <SelectListItem> mySelectItemList1 = new List <SelectListItem>(); foreach (var item in data1) { mySelectItemList1.Add(new SelectListItem() { Text = item.CEatPeriodName, Value = item.CEatPeriodId.ToString(), Selected = false }); } var data2 = from p in (new 擺腹BuyFoodContext()).TIsOnSales //假設從資料庫撈出資料。 select p; List <SelectListItem> mySelectItemList2 = new List <SelectListItem>(); foreach (var item in data2) { mySelectItemList2.Add(new SelectListItem() { Text = item.CStatusName, Value = item.CIsOnSaleId.ToString(), Selected = false }); } CProductViewModel model = new CProductViewModel() //上面的 Model { CcategoryComBox = mySelectItemList, CEatTimeIdComBox = mySelectItemList1, CIsOnSaleIdComBox = mySelectItemList2 }; return(View(model)); }
public IActionResult Edit(CProductViewModel p_產品修改) { TProduct l_product被修改 = db.TProducts.FirstOrDefault(n => n.CProductId == p_產品修改.CProductId); if (l_product被修改 != null) { string p_產品照片相對路徑 = Url.Content(l_product被修改.CPicture); if (!string.IsNullOrEmpty(p_產品照片相對路徑) && p_產品修改.Image != null) { string p產品實體路徑 = iv_host.WebRootPath + p_產品照片相對路徑; System.IO.File.Delete(p產品實體路徑); } string photoName = Guid.NewGuid().ToString() + ".jpg"; string p_照片最後路徑 = null; if (p_產品修改.Image != null) { using (var phtot = new FileStream(iv_host.WebRootPath + @"\images\" + photoName, FileMode.Create)) { p_產品修改.Image.CopyTo(phtot); p_照片最後路徑 = "~/images/" + photoName; } } else { p_照片最後路徑 = p_產品照片相對路徑; } p_產品修改.CPicture = p_照片最後路徑; l_product被修改.CProductName = p_產品修改.CProductName; l_product被修改.CQuantity = p_產品修改.CQuantity; l_product被修改.CQuantityControl = p_產品修改.CQuantityControl; l_product被修改.CPrice = p_產品修改.CPrice; l_product被修改.CDescription = p_產品修改.CDescription; l_product被修改.CProductTagId = p_產品修改.CProductTagId; l_product被修改.CPicture = p_產品修改.CPicture; l_product被修改.CCategoryId = p_產品修改.CCategoryId; l_product被修改.CIsOnSaleId = p_產品修改.CIsOnSaleId; l_product被修改.CEatTimeId = p_產品修改.CEatTimeId; l_product被修改.CFinishedTime = p_產品修改.CFinishedTime; l_product被修改.CFinishedTime = p_產品修改.CFinishedTime; l_product被修改.CIsBreakFast = p_產品修改.CIsBreakFast; l_product被修改.CIsLunch = p_產品修改.CIsLunch; l_product被修改.CIsDinner = p_產品修改.CIsDinner; db.SaveChanges(); } return(RedirectToAction("List")); }
public IActionResult Create(CProductViewModel p_產品新增) { string photoName = Guid.NewGuid().ToString() + ".jpg"; if (p_產品新增.Image != null) { using (var phtot = new FileStream(iv_host.ContentRootPath + @"\wwwroot\Images\" + photoName, FileMode.Create)) { p_產品新增.Image.CopyTo(phtot); } } p_產品新增.CPicture = "~/Images/" + photoName; if (!string.IsNullOrEmpty(p_產品新增.CProductName)) { db.TProducts.Add(p_產品新增.allProduct); db.SaveChanges(); } return(RedirectToAction("List")); }