// 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 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));
}
// 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));
}
//GET: ShoppingHome
public ActionResult Index()
{
//登入的會員資訊
CMember member = (CMember)Session[CMemberSession.Session_Login_User];
//防止未登入者進入
if (member == null)
{
return(RedirectToAction("../Member/Login"));
}
//未下架的商品(含商品封面圖片)
List <CProductPicture> lsproduct = CProductPictureFactory.fn商品圖片查詢().Where(p => p.fTheRemovedDate == null).DistinctBy(p => p.fProductId).OrderBy(p => p.fProductId).ToList();
//裝多個CShoppingHomeVM的容器
List <CShoppingHomeVM> lsshoppinghomeVM = new List <CShoppingHomeVM>();
foreach (var product in lsproduct)
{
//撈出該商品的賣家資訊
CMember memberseller = CMemberFactory.fn會員查詢().FirstOrDefault(m => m.fMemberId == product.fMemberSellerId);
//撈出該商品的類別
List <CProductCompare> category = CProductCompareFactory.fn商品類別對照查詢().Where(c => c.fProductId == product.fProductId).ToList();
//CShoppingHomeVM內的變數給值
CShoppingHomeVM shoppinghomeVM = new CShoppingHomeVM()
{
member = memberseller,
lsproductcategory = category,
productpicture = product,
};
lsshoppinghomeVM.Add(shoppinghomeVM);
}
return(View("Index", lsshoppinghomeVM));
}
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"));
}
// GET: AllProduct
public ActionResult Index(string sortOrder, string currentFilter, string searchString, int?page)
{
//登入的會員資訊
CMember member = (CMember)Session[CMemberSession.Session_Login_User];
//防止未登入者進入
if (member == null)
{
return(RedirectToAction("../Member/Login"));
}
//排序條件(日期/價格/下載量/讚數)
ViewBag.CurrentSort = sortOrder;
ViewBag.DateSortParm = String.IsNullOrEmpty(sortOrder) ? "Date" : "";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
//記錄每頁商品數及目前頁數
int pageSize = 8;
int pageNumber = (page ?? 1);
//未下架的商品(含商品封面圖片)
List <CProductPicture> lsproduct = CProductPictureFactory.fn商品圖片查詢().Where(p => p.fTheRemovedDate == null).DistinctBy(p => p.fProductId).OrderBy(p => p.fProductId).ToList();
//篩選商品(類別/名稱/描述)
switch (searchString)
{
case "Education":
List <CProductCompare> lscategory = CProductCompareFactory.fn商品類別對照查詢().Where(c => c.fCategoryName == "程式").ToList();
List <CProductPicture> lsproducttag1 = new List <CProductPicture>();
foreach (var item in lscategory)
{
CProductPicture producttag1 = new CProductPicture();
producttag1 = lsproduct.Where(p => p.fProductId == item.fProductId && p.fTheRemovedDate == null).FirstOrDefault();
if (producttag1 != null)
{
lsproducttag1.Add(producttag1);
}
}
lsproduct = lsproducttag1;
break;
case null:
searchString = currentFilter;
break;
default:
lsproduct = lsproduct.Where(p => p.fName.Contains(searchString) ||
p.fDescription.Contains(searchString)).ToList();
break;
}
switch (sortOrder)
{
case "New":
lsproduct = lsproduct.Where(p => DateTime.UtcNow.AddHours(08).AddMonths(-1).Month < p.fLaunchDate.Month && p.fLaunchDate.Month <= DateTime.UtcNow.AddHours(08).Month).OrderByDescending(p => p.fLaunchDate).ToList();
break;
case "Date":
lsproduct = lsproduct.OrderBy(p => p.fLaunchDate).ToList();
break;
case "Price":
lsproduct = lsproduct.OrderBy(p => p.fPrice).ToList();
break;
case "Price_desc":
lsproduct = lsproduct.OrderByDescending(p => p.fPrice).ToList();
break;
case "DownLoad_desc":
lsproduct = lsproduct.OrderByDescending(p => p.fDownloadTimes).ToList();
break;
case "Like_desc":
lsproduct = lsproduct.OrderByDescending(p => p.fLikeCount).ToList();
break;
case "Free":
lsproduct = lsproduct.Where(p => p.fPrice == 0).ToList();
break;
default:
lsproduct = lsproduct.OrderByDescending(p => p.fLaunchDate).ToList();
break;
}
//裝多個CShoppingHomeVM的容器
List <CShoppingHomeVM> lsshoppinghomeVM = new List <CShoppingHomeVM>();
foreach (var product in lsproduct)
{
//撈出該商品的賣家資訊
CMember memberseller = CMemberFactory.fn會員查詢().FirstOrDefault(m => m.fMemberId == product.fMemberSellerId);
//撈出該商品的類別
List <CProductCompare> category = CProductCompareFactory.fn商品類別對照查詢().Where(c => c.fProductId == product.fProductId).ToList();
//CShoppingHomeVM內的變數給值
CShoppingHomeVM shoppinghomeVM = new CShoppingHomeVM()
{
member = memberseller,
lsproductcategory = category,
productpicture = product,
};
lsshoppinghomeVM.Add(shoppinghomeVM);
}
IPagedList <CShoppingHomeVM> pagedlist = lsshoppinghomeVM.ToPagedList(pageNumber, pageSize);
return(View("Index", pagedlist));
}
