//====================================================================
//團購商品新增(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"));
}
