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"));
}
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"));
}
