public ActionResult EditProduct(CShoppingAccountCenterVM NewProduct, int[] fCategoryId, int?fProductId) { //登入的會員資訊 CMember member = (CMember)Session[CMemberSession.Session_Login_User]; //防止未登入者進入 if (member == null) { return(RedirectToAction("../Member/Login")); } CProduct product = CProductFactory.fn商品查詢().FirstOrDefault(p => p.fProductId == fProductId); product.fName = NewProduct.Product.fName; product.fDescription = NewProduct.Product.fDescription; product.fContent = NewProduct.Content; product.fPrice = NewProduct.Product.fPrice; product.fLaunchDate = DateTime.UtcNow.AddHours(08); product.fTheRemovedDate = null; product.fDownloadTimes = 0; product.fLikeCount = 0; product.fMemberSellerId = member.fMemberId; CProductFactory.fn商品更新(product); return(RedirectToAction("Index")); }
public ActionResult MyProduct() { //登入的會員資訊 CMember member = (CMember)Session[CMemberSession.Session_Login_User]; //防止未登入者進入 if (member == null) { return(RedirectToAction("../Member/Login")); } //會員販售的商品 List <CProductPicture> MyProduct = CProductPictureFactory.fn商品圖片查詢().Where(p => p.fTheRemovedDate == null && p.fMemberSellerId == member.fMemberId).DistinctBy(p => p.fProductId).OrderBy(p => p.fProductId).ToList(); //查詢會員所有的筆記資料夾 List <CNoteFolder> lsFolder = CNoteFolderFactory.fn筆記資料夾查詢(member).ToList(); //筆記會員資料夾包含筆記的列表 List <CNoteFolderViewModel> lsNotefolderVM = new List <CNoteFolderViewModel>(); //讀取筆記資料夾內的筆記 foreach (var folder in lsFolder) { List <CNote> myLsNote = CNoteFactory.fn私人筆記查詢(folder).ToList(); lsNotefolderVM.Add(new CNoteFolderViewModel() { fFolderId = folder.fFolderId, fFolderName = folder.fFolderName, fMemberId = folder.fMemberId, lsNote = myLsNote }); } ; //商品類別給後面下拉式選單用 List <CProductCategory> lsProductCategory = CProductCategoryFactory.fn商品類別查詢().ToList(); ViewBag.Categories = new MultiSelectList(lsProductCategory, "fCategoryId", "fCategoryName"); List <CProductCompare> lsproductcategory = CProductCompareFactory.fn商品類別對照查詢().Where(m => m.fMemberSellerId == member.fMemberId).ToList(); CShoppingAccountCenterVM ShoppingAccountCenter = new CShoppingAccountCenterVM() { lsNotefolderVM = lsNotefolderVM, lsCategory = lsProductCategory, lsProductPicture = MyProduct, lsCategoryCompare = lsproductcategory }; return(PartialView("_MyProduct", ShoppingAccountCenter)); }
//修改GET抓取JSON資料 //string myProductContent; public JsonResult EditProduct(int?fProductId) { //登入的會員資訊 CMember member = (CMember)Session[CMemberSession.Session_Login_User]; //防止未登入者進入 CProduct myProduct = CProductFactory.fn商品查詢().FirstOrDefault(p => p.fProductId == fProductId); List <CProductPicture> lsMyProductPicture = CProductPictureFactory.fn商品圖片查詢().Where(p => p.fProductId == fProductId).ToList(); List <CProductCompare> lsProductCategory = CProductCompareFactory.fn商品類別對照查詢().Where(c => c.fProductId == fProductId).ToList(); List <CNoteFolder> lsFolder = CNoteFolderFactory.fn筆記資料夾查詢(member).ToList(); //筆記資料夾包含筆記的列表 List <CNoteFolderViewModel> lsNotefolderVM = new List <CNoteFolderViewModel>(); //讀取筆記資料夾內的筆記 foreach (var folder in lsFolder) { List <CNote> myLsNote = CNoteFactory.fn私人筆記查詢(folder).OrderBy(n => n.fNoteListLevel).Where(n => n.fJsonContent == myProduct.fContent).ToList(); lsNotefolderVM.Add(new CNoteFolderViewModel() { fFolderId = folder.fFolderId, fFolderName = folder.fFolderName, fMemberId = folder.fMemberId, lsNote = myLsNote }); } CNote mynote = CNoteFactory.fn私人筆記全部查詢().FirstOrDefault(n => n.fJsonContent == myProduct.fContent); CShoppingAccountCenterVM ShoppingAccountCenter = new CShoppingAccountCenterVM() { lsCategoryCompare = lsProductCategory, lsProductPicture = lsMyProductPicture, Product = myProduct, lsNotefolderVM = lsNotefolderVM, NoteId = mynote.fNoteId //Content = myProductContent, }; string value = string.Empty; value = JsonConvert.SerializeObject(ShoppingAccountCenter, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(value, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateProduct(CShoppingAccountCenterVM NewProduct, int?[] fCategoryId, string[] ProductPicture) { //登入的會員資訊 CMember member = (CMember)Session[CMemberSession.Session_Login_User]; //防止未登入者進入 if (member == null) { return(RedirectToAction("../Member/Login")); } //商品新增 CProduct product = new CProduct(); product.fName = NewProduct.Product.fName; product.fDescription = NewProduct.Product.fDescription; product.fContent = NewProduct.Content; //抓JSON資料 product.fPrice = NewProduct.Product.fPrice; product.fLaunchDate = DateTime.UtcNow.AddHours(08); product.fTheRemovedDate = null; product.fDownloadTimes = 0; product.fLikeCount = 0; product.fMemberSellerId = member.fMemberId; product = CProductFactory.fn商品新增(member, product); //商品圖片新增 CProductPicture productPicture = new CProductPicture(); //如果沒有選就給預設圖片(封面) if (ProductPicture[0] == "") { productPicture.fPicture = "https://creazilla-store.fra1.digitaloceanspaces.com/emojis/44574/notebook-emoji-clipart-md.png";//預設的圖片 productPicture.fProductId = product.fProductId; CProductPictureFactory.fn商品圖片新增(product, productPicture); } else { foreach (var item in ProductPicture) { if (item != "") { productPicture.fPicture = item; productPicture.fProductId = product.fProductId; CProductPictureFactory.fn商品圖片新增(product, productPicture); } } } //商品類別新增 CProductCompare productCompare = new CProductCompare(); if (fCategoryId == null) { } else { foreach (var item in fCategoryId) { CProductCategory productCategory = CProductCategoryFactory.fn商品類別查詢().Where(c => c.fCategoryId == item).FirstOrDefault(); productCompare.fProductId = product.fProductId; productCompare.fCategoryId = item.Value; CProductCompareFactory.fn商品類別對照新增(product, productCategory); } } return(Redirect("../ShoppingAccountCenter?goto=seller")); }