public bool InsertProductImage(b2bProductImage productImages) { productImages.IsDelete = false; productImages.RowVersion = 1; productImages.CreatedDate = DateTimeNow; productImages.ModifiedDate = DateTimeNow; productImages.CreatedBy = "sa"; productImages.ModifiedBy = "sa"; qDB.b2bProductImages.InsertOnSubmit(productImages); IsResult = true; SaveData <b2bProductImage>(productImages, "ProductImageID"); return(IsResult); }
public ActionResult PrepareEditByID(int ID, string GenCode) { var svProduct = new ProductService(); var svCategory = new CategoryService(); var svProductGroup = new ProductGroupService(); var svProductImage = new ProductImageService(); CommonService svCommon = new CommonService(); #region FindCateAll //var sqlwherein = ""; //switch (res.Common.lblWebsite) //{ // case "B2BThai": sqlwherein = " AND CategoryType IN (1,2)"; break; // case "AntCart": sqlwherein = " AND CategoryType IN (3)"; break; // case "myOtopThai": sqlwherein = " AND CategoryType IN (5)"; break; // case "AppstoreThai": sqlwherein = " AND CategoryType IN (6)"; break; // default: sqlwherein = ""; break; //} var sqlSelect = "CategoryID,CategoryName"; var sqlWhere = "CategoryLevel=1 AND RowFlag > 0 AND IsDelete=0"; var data1 = svCategory.GetCategoryByLevel(1); //var data2 = svCategory.GetCategoryByLevel(2); //var data3 = svCategory.GetCategoryByLevel(3); ViewBag.SelectCateLV1 = data1; //ViewBag.SelectCateLV2 = data2; //ViewBag.SelectCateLV3 = data3; #endregion ViewBag.QtyUnits = svCommon.SelectEnum(CommonService.EnumType.QtyUnits); #region Set Product Group var ProductGroups = svProductGroup.GetProductGroup(LogonCompID); if (ProductGroups.Count() > 0) { ViewBag.ProductGroups = ProductGroups; } else { ViewBag.ProductGroups = null; } #endregion var Product = svProduct.SelectData <b2bProduct>(" * ", "ProductID=" + ID + " And IsDelete=0", null, 1, 1).First(); ViewBag.Product = Product; sqlSelect = "ProductID,ProductImageID,ImgPath,ListNo"; sqlWhere = svProductImage.CreateWhereCause(ID); var Images = svProductImage.SelectData <b2bProductImage>(sqlSelect, sqlWhere, " ListNo ASC"); var countImg = 0; if (svProductImage.TotalRow > 0) { countImg = Images.Where(m => m.ImgPath == Product.ProductImgPath).Count(); } if (countImg == 0) { var img = new b2bProductImage(); img.ProductID = Product.ProductID; img.ListNo = 1; img.ImgPath = Product.ProductImgPath; img.ImgDetail = Product.ProductName; svProductImage.InsertProductImage(img); Images = svProductImage.SelectData <b2bProductImage>(sqlSelect, sqlWhere, " ListNo DESC"); } ViewBag.ProductImg = Images; ViewBag.ImgCount = Images.Count(); var data2 = new List <b2bCategory>(); var data3 = new List <b2bCategory>(); data2 = svCategory.LoadSubCategory(DataManager.ConvertToInteger(Product.CateLV1), 500, 2); data3 = svCategory.LoadSubCategory(DataManager.ConvertToInteger(Product.CateLV2), 500, 3); ViewBag.SelectCateLV2 = data2; ViewBag.SelectCateLV3 = data3; var a = svCategory.SearchCategoryByID((int)Product.CateLV3); //var a = svCategory.SelectData<b2bCategory>("*", "CategoryID = " + (int)Product.CateLV3, null, 1, 1,); ViewBag.Catename = a; ViewBag.ProductCode = GenCode; return(PartialView("UC/EditProduct")); }
public ActionResult AddProduct ( #region Param string ProductName, int?ProductGroup, string ProductCode, string Price, string Price_One, string Keyword, string QuickDetail, string FullDetail, string Qty, string QtyUnit, string Catecode, string CateLV3, List <string> ProductImgPath, int Ispromotion, string PromotionPrice #endregion ) { var svProduct = new ProductService(); var svProductImage = new ProductImageService(); b2bProduct model = new b2bProduct(); try { #region Set Product Model model.ProductName = ProductName; model.ProductGroupID = (ProductGroup > 0) ? ProductGroup : 0; model.ProductCode = ProductCode; model.Price = DataManager.ConvertToDecimal(Price); model.Price_One = DataManager.ConvertToDecimal(Price_One); model.ProductKeyword = Keyword; model.ShortDescription = QuickDetail; model.ProductDetail = FullDetail; model.Qty = DataManager.ConvertToDecimal(Qty); //model.QtyUnit = QtyUnit; model.ProductImgPath = ProductImgPath[0]; model.IsPromotion = DataManager.ConvertToBool(Ispromotion); model.PromotionPrice = DataManager.ConvertToDecimal(PromotionPrice); model.CompID = LogonCompID; model.CateLV1 = Convert.ToInt32(Catecode.Substring(9, 4)); model.CateLV2 = Convert.ToInt32(Catecode.Substring(14, 4)); model.CateLV3 = Convert.ToInt32(CateLV3); model.IsShow = true; model.IsJunk = false; model.Complevel = DataManager.ConvertToShort(LogonCompLevel); if (QtyUnit == "0") { model.QtyUnit = "รายการ"; } else { model.QtyUnit = QtyUnit; } #region Check ว่าเป็น OutSource Add หรือ User Add if (LogonServiceType >= 9) { model.RowFlag = (short)2; model.CompCode = LogonCompCode; } else { model.RowFlag = (short)6; } #endregion model.ContactCount = 0; model.ListNo = 0; model.ViewCount = 0; model.QuotationCount = 0; model.TelCount = 0; model.CreatedDate = DateTime.Now; model.ModifiedDate = DateTime.Now; model.CreatedBy = LogonCompCode; model.ModifiedBy = LogonCompCode; #endregion #region Set ProductImage Model int i = 1; var ProductImgs = new List <b2bProductImage>(); foreach (var imgname in ProductImgPath) { var modelImg = new b2bProductImage(); modelImg.ImgDetail = imgname.Substring(0, 15); modelImg.ListNo = i; modelImg.ImgPath = imgname; modelImg.RowVersion = 1; modelImg.RowFlag = 1; modelImg.CreatedDate = DateTime.Now; modelImg.ModifiedDate = DateTime.Now; modelImg.CreatedBy = "sa"; modelImg.ModifiedBy = "sa"; ProductImgs.Add(modelImg); i++; } #endregion #region Insert Product And ProductImage svProduct.InsertProduct(model, ProductImgs, LogonCompID, LogonCompLevel); svProduct.UpdateProductCountInCategories(Convert.ToInt32(Catecode.Substring(9, 4)), Convert.ToInt32(Catecode.Substring(14, 4)), Convert.ToInt32(CateLV3)); svProduct.UpdateProductCountInCompany(LogonCompID); #endregion #region Save Image Files imgManager = new FileHelper(); imgManager.DirPath = "Product/" + LogonCompID + "/" + model.ProductID; if (Request.Cookies["AddProduct"] != null) { imgManager.DirTempPath = Request.Cookies["AddProduct"]["UnRegis"]; HttpCookie myCookie = new HttpCookie("AddProduct"); myCookie.Expires = DateTime.Now.AddDays(-1d); Response.Cookies.Add(myCookie); } else { imgManager.DirTempPath = "Temp/Product/" + LogonCompID; } SaveFileImage( imgManager.DirTempPath, imgManager.DirPath, ProductImgPath, 150, 450); #endregion //var mgKeyword = new KeywordMongo(); //var isresult = mgKeyword.UpdateMongoProduct(model.ProductID); } catch (Exception ex) { CreateLogFiles(ex); } return(Json(new { IsResult = svProduct.IsResult, MsgError = GenerateMsgError(svProduct.MsgError), ID = model.ProductID })); }
/// <summary> /// /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateProduct(b2bProduct model, List <int> ImgID, List <string> ImgName) { var data = qDB.b2bProducts.Single(q => q.ProductID == model.ProductID); #region Set Model // set ค่า model data.ProductName = model.ProductName; data.ProductGroupID = model.ProductGroupID; data.ProductCode = model.ProductCode; data.Price = model.Price; data.Price_One = model.Price_One; data.ProductKeyword = model.ProductKeyword; data.ShortDescription = model.ShortDescription; data.ProductDetail = model.ProductDetail; data.Qty = model.Qty; data.QtyUnit = model.QtyUnit; if (model.CateLV1 != null) { data.CateLV1 = model.CateLV1; } if (model.CateLV2 != null) { data.CateLV2 = model.CateLV2; } if (model.CateLV3 != null) { data.CateLV3 = model.CateLV3; } data.ProductImgPath = model.ProductImgPath; data.RowFlag = model.RowFlag; data.CompCode = model.CompCode; // default data.RowVersion++; data.ModifiedBy = model.ModifiedBy; data.ModifiedDate = DateTimeNow; #endregion #region Save using (var trans = new TransactionScope()) { qDB.SubmitChanges();// บันทึกค่า Product var OldImgs = SelectData <b2bProductImage>(" * ", " IsDelete = 0 AND ProductID =" + model.ProductID); OldFiles = new List <string>(); NewFiles = new List <string>(); OldID = new List <int>(); foreach (var it in OldImgs) { OldID.Add((int)it.ProductImageID); OldFiles.Add(it.ImgPath); } for (var i = 0; i < ImgName.Count; i++) { if (ImgID[i] > 0) { if (OldID.Exists(m => m.Equals(ImgID[i]))) { OldID.Remove(ImgID[i]); } UpdateByCondition <b2bProductImage>(@" ImgPath = N'" + ImgName[i] + "' , ListNo = " + i + ", " + " ImgDetail = N'" + model.ProductName + "' ", " ProductImageID = " + ImgID[i]); } else { #region กรณีเป็นรูป ใหม่ ให้ insert ข้อมูล var it = new b2bProductImage(); it.ProductID = model.ProductID; it.ImgPath = ImgName[i]; it.ImgDetail = model.ProductName; it.ListNo = i; it.IsShow = true; it.IsDelete = false; it.CreatedDate = DateTimeNow; it.ModifiedDate = DateTimeNow; it.CreatedBy = "sa"; it.ModifiedBy = "sa"; qDB.b2bProductImages.InsertOnSubmit(it); qDB.SubmitChanges(); #endregion } } foreach (var it in OldID) { UpdateByCondition <b2bProductImage>("IsDelete = 1 ", " ProductImageID = " + it); } trans.Complete(); IsResult = true; } #endregion return(IsResult); }