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")); }
// GET: ProductDetail public ActionResult ProductDetail(int ProductId) { //登入的會員資訊 CMember member = (CMember)Session[CMemberSession.Session_Login_User]; //防止未登入者進入 if (member == null) { return(RedirectToAction("../Member/Login")); } //所有會員資訊 List <CMember> lsMember = CMemberFactory.fn會員查詢().ToList(); List <CMember> Isbanned = CMemberFactory.fn會員查詢().Where(n => n.fMemberId == member.fMemberId).ToList(); //所選到的商品 CProduct product = CProductFactory.fn商品查詢().FirstOrDefault(p => p.fProductId == ProductId); //該商品的賣家資訊 CMember memberseller = CMemberFactory.fn會員查詢().FirstOrDefault(m => m.fMemberId == product.fMemberSellerId); //該商品的圖片(多個) List <CProductPicture> lsProductPicture = CProductPictureFactory.fn商品圖片查詢().Where(p => p.fProductId == ProductId).ToList(); //該商品的類別(多個) List <CProductCompare> lsCategory = CProductCompareFactory.fn商品類別對照查詢().Where(c => c.fProductId == ProductId).ToList(); //該商品的留言(多個) List <CComment> lsProductComment = CCommentFactory.fn留言查詢().Where(c => c.fProductId == ProductId).ToList(); List <CProductRank> lsProductRank = CProductRankFactory.fn評價查詢(ProductId).ToList(); //新增瀏覽紀錄 CProductBrowse productBrowse = new CProductBrowse() { fBrowseDataTime = DateTime.UtcNow.AddHours(08), fProductId = ProductId }; CProductBrowseFactory.fn商品瀏覽紀錄新增(product, productBrowse); List <CProductDetailVM> lsProductDetail = new List <CProductDetailVM>(); CProductDetailVM productDetailVM = new CProductDetailVM() { lsMember = lsMember, MemberSeller = memberseller, Product = product, lsProductPicture = lsProductPicture, lsProductCategory = lsCategory, lsProductComment = lsProductComment, lsProductRank = lsProductRank, Isbanned = Isbanned }; return(View(productDetailVM)); }
public ActionResult DeleteProduct(int?fProductId) { //更新下架時間不再出現於商品展示區 CProduct myProduct = CProductFactory.fn商品查詢().FirstOrDefault(p => p.fProductId == fProductId); myProduct.fTheRemovedDate = DateTime.UtcNow.AddHours(08); CProductFactory.fn商品更新(myProduct); return(RedirectToAction("Index")); }
public int DislikeProduct(int ProductId) { CProduct product = CProductFactory.fn商品查詢().FirstOrDefault(p => p.fProductId == ProductId); product.fLikeCount -= 1; CProductFactory.fn商品更新(product); int result = product.fLikeCount; return(result); }
//修改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 PurchaseList(int fMemberId) { //登入的會員資訊 CMember Member = (CMember)Session[CMemberSession.Session_Login_User]; //防止未登入者進入 if (Member == null) { return(RedirectToAction("../Member/Login")); } List <COrder> lsorder = COrderFactory.fn訂單查詢(Member).ToList(); List <CMemberOrderSelectVM> lsdetailorder = CMemberFactory.fn會員訂單個人查詢(Member).ToList(); List <CMember> lsmemberseller = new List <CMember>(); foreach (var item in lsdetailorder) { CProduct product = new CProduct(); product = CProductFactory.fn商品查詢().FirstOrDefault(p => p.fTheRemovedDate == null && p.fProductId == item.fProductId); if (product == null) { break; } CMember memberseller = new CMember(); memberseller = CMemberFactory.fn會員查詢().FirstOrDefault(m => m.fMemberId == product.fMemberSellerId); lsmemberseller.Add(memberseller); } //未下架的商品(含商品封面圖片) List <CProductPicture> lsproductpic = CProductPictureFactory.fn商品圖片查詢().Where(p => p.fTheRemovedDate == null).DistinctBy(p => p.fProductId).OrderBy(p => p.fProductId).ToList(); CPurchaseListVM PurchaseListVM = new CPurchaseListVM() { lsMemberSeller = lsmemberseller, lsProductPicture = lsproductpic, lsOrder = lsorder, lsOrderDetail = lsdetailorder }; return(PartialView("_PurchaseList", PurchaseListVM)); }
// GET: ManagerSystem public ActionResult HomePage(CMember c) { CAdmin admin = Session[CAdminSession.Session_Login_User] as CAdmin; if (admin == null) { return(RedirectToAction("../Member/AdminLogin")); } //資安 未登入時會跳回登入頁面 int membercount = CMemberFactory.fn會員查詢().Count(); //統計會員數量 int memberbrowse = CMemberBrowseFactory.fn會員瀏覽紀錄查詢().Count(); //統計總瀏覽量 int totalprice = COrderFactory.fn訂單總金額(); //統計金額交易量 int totalorder = COrderFactory.fn訂單商品累積量(); //總訂單數量 ViewBag.totalprice = totalprice.ToString("c0"); ViewBag.browse = memberbrowse.ToString(); ViewBag.membercount = membercount.ToString(); ViewBag.totalorder = totalorder; List <CProduct> lsproduct = CProductFactory.fn商品查詢().ToList();//撈出產品列表 List <CProductAndProductCompareViewModel> lsProductAndProductCompareVM = new List <CProductAndProductCompareViewModel>(); //產品與他的產品分類空列表 List <CProductCompare> lsproductcategory = new List <CProductCompare>();//產品分類空列表 foreach (var p in lsproduct) { List <CProductCompare> vlsProductcategory = CProductCompareFactory.fn商品類別對照查詢() .Where(m => m.fProductId == p.fProductId) .ToList();//抓出某產品所有產品分類 lsProductAndProductCompareVM.Add(new CProductAndProductCompareViewModel() { product = p, //單一產品 lsProductCompare = vlsProductcategory //上述單一產品的多項標籤 }); } CShoppingDataViewModel sd = new CShoppingDataViewModel() { lsMember = CMemberFactory.fn會員查詢().ToList(), ls產品與產品分類 = lsProductAndProductCompareVM };//將資訊加入列表 return(View("HomePage", "_LayoutAdmin", sd)); }
public ActionResult AddToCart(int ProductId) { //登入的會員資訊 CMember member = (CMember)Session[CMemberSession.Session_Login_User]; //目前購物車Session的項目 CCartVM currentCart = CCartVM.GetCurrentCart(member); //商品資訊,給fn購物車商品新增()使用 CProduct product = CProductFactory.fn商品查詢().FirstOrDefault(p => p.fProductId == ProductId); //判斷商品是否已在Cart內 if (currentCart.lscartprooduct.Any(p => p.fProductId == product.fProductId)) { return(View("Index", "ShoppingHome")); } else { //不存在購物車內,則新增一筆 CCartProductFactory.fn購物車商品新增(product, currentCart.mycart); } return(PartialView("_CartPartial")); }
//GET:下次再買 public ActionResult PurchaseNextTime(int CartProductId) { CMember member = (CMember)Session[CMemberSession.Session_Login_User]; CCartVM currentCart = CCartVM.GetCurrentCart(member); CCartProduct CartProduct = currentCart.lscartprooduct.FirstOrDefault(p => p.fCartProductId == CartProductId); //新增購物車 CCart cart = new CCart() { fMemberId = member.fMemberId, fSubmitTime = null }; CCart mycart = CCartFactory.fn購物車新增(member, cart); //新增下次再買的商品到新的購物車 CProduct product = CProductFactory.fn商品查詢().FirstOrDefault(p => p.fProductId == CartProduct.fProductId); CCartProductFactory.fn購物車商品新增(product, mycart); //刪除現在購物車裡的商品 CCartProductFactory.fn購物車商品刪除(CartProduct); return(RedirectToAction("CartView")); }