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