public ErrorMessage addPic(PicDetail pic, int id) { ErrorMessage error = new ErrorMessage(); error.IsSuccess = true; //using (var data = item.Database.BeginTransaction()) //{ // try // { // pic.ProductID = id; // item.PicDetails.Add(pic); // item.SaveChanges(); // data.Commit(); // } // catch (Exception ex) // { // error.Message = ex.Message; // error.IsSuccess = false; // data.Rollback(); // return error; // } //} return(error); }
public ActionResult Create(JsonProductDetail product) { PrductServices services = new PrductServices(); Product p = ChangeIt(product); p.ProductID = product.ProductID; JsonURL u = new JsonURL(); u.Url1 = product.PicUrl1; u.Url2 = product.PicUrl2; u.Url3 = product.PicUrl3; JavaScriptSerializer js = new JavaScriptSerializer(); string jsonData = js.Serialize(u);//序列化 PicDetail pd = new PicDetail(); pd.PicUrl = jsonData; services.addProduct(p, pd); //services.addProduct(); return(RedirectToAction("Index")); }
//public Product GetProduct( string ProductName, String CategoryName, string ProductDescription, int UnitsInStock,int ProductPrice) //{ // Product product = new Product() { CategoryName = ProductName, ProductDescription = CategoryName, ProductName = ProductName, UnitsInStock = UnitsInStock, ProductPrice= ProductPrice }; // return product; //} //public PicDetail GetPicDetail(string PicUrl ) //{ // PicDetail PicDetail = new PicDetail() { PicUrl= PicUrl }; // return PicDetail; //} //public Category GetCategory(string CategoryName,string CategoryPic,string CategoryDescription) //{ // Category Category = new Category() { CategoryDescription=CategoryDescription, CategoryName=CategoryName, CategoryPic=CategoryPic }; // return Category; //} public ErrorMessage addProduct(Product product, PicDetail pic) { ErrorMessage error = new ErrorMessage(); error.IsSuccess = true; item.Products.Add(product); item.SaveChanges(); item.Database.ExecuteSqlCommand($"insert into PicDetails values({product.ProductID},'{pic.PicUrl}')"); //using (var data = item.Database.BeginTransaction()) //{ // try // { // data.Commit(); // } // catch (Exception ex) // { // error.Message = ex.Message; // error.IsSuccess = false; // data.Rollback(); // return error; // } //} return(error); }
public XmlElement ToXMLString(XmlDocument xmlDoc) { XmlElement picItem = xmlDoc.CreateElement("PictureItem"); picItem.SetAttribute("ID", ID.ToString()); picItem.SetAttribute("Pic1Url", Pic1Url); picItem.SetAttribute("Pic2Url", Pic2Url); picItem.SetAttribute("PicDetail", PicDetail.ToString()); picItem.SetAttribute("pic1LocalName", Pic1LocalName); picItem.SetAttribute("pic2LocalName", Pic2LocalName); return(picItem); }
public bool CreateProduct(Product product, PicDetail pic) { try { _ProductNew.Crate(product); _PicNew.Crate(pic); _ProductNew.SaveChange(); } catch (Exception ex) { return(false); } return(true); }
public bool DeleteProduct(int id) { try { string sql = "select * from product where id=" + id; Product product = _ProductNew.GetData(sql).FirstOrDefault(); sql = "select * from PicDetail where id=" + id; PicDetail pic = _PicNew.GetData(sql).FirstOrDefault(); _ProductNew.Delete(product); _PicNew.Delete(pic); _ProductNew.SaveChange(); } catch (Exception ex) { return(false); } return(true); }
public ErrorMessage EditProduct(Product product, PicDetail pic) { ErrorMessage error = new ErrorMessage(); error.IsSuccess = true; try { item.Entry(product).State = EntityState.Modified; item.Entry(pic).State = EntityState.Modified; item.SaveChanges(); } catch (Exception ex) { error.IsSuccess = false; error.Message = ex.Message; return(error); } return(error); }
public string ProductQuickView(int id) { Product product = item.Products.Find(id); var categoryname = (from c in item.Categories where c.CategoryID == product.CategoryID select c.CategoryName).FirstOrDefault(); PicDetail picDetail = item.PicDetails.Find(id); var currentitem = new ProductList { ProductID = product.ProductID, CategoryName = categoryname, ProductName = product.ProductName, ProductDescription = product.ProductDescription, UnitsInStock = product.UnitsInStock, ProductPrice = product.ProductPrice, Url = picDetail.PicUrl }; return(JsonConvert.SerializeObject(currentitem)); }
public ActionResult Create(Product product, PicDetail pic) { return(View()); }
public ActionResult ProductList(Product product, Category category, PicDetail picDetail, HttpPostedFileBase file) { return(View()); }
public ActionResult ProductIndex(string cat, int id) { var isWish = "false"; HttpCookie rqstCookie = HttpContext.Request.Cookies.Get("myaccount"); if (rqstCookie != null) { var memberDataObj = FormsAuthentication.Decrypt(rqstCookie.Value); var memberData = JsonConvert.DeserializeObject <Member>(memberDataObj.UserData); var wishproducts = (from p in item.Products join w in item.WishLists on p.ProductID equals w.ProductID where memberData.MemberID == w.MemberID select p.ProductID).ToList(); if (wishproducts.Contains(id)) { isWish = "true"; } } ViewBag.isWish = isWish; //沒有傳入id(小嫚暫時拿掉) //if (id == null) //{ // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); //} using (ItemContext item = new ItemContext()) { Product product = item.Products.Find(id); PicDetail picDetail = item.PicDetails.Find(id); //傳入的id找不到商品 if (product == null) { return(HttpNotFound()); } //ViewBag.MemberID = memberData.MemberID;(小嫚暫時拿掉) //預設為1 ViewBag.CartID = 1; ViewBag.ProductID = id; ViewBag.ProductDescription = product.ProductDescription; ViewBag.ProductName = product.ProductName; ViewBag.ProductPrice = product.ProductPrice; ViewBag.ProductUrl = picDetail.PicUrl; //ViewBag.ProductUrl = JsonConvert.SerializeObject(picDetail.PicUrl); var parentstring = FindCategoryParents(product.CategoryID); var parents = FindCategoryParents(product.CategoryID).Replace(@"""", "").Replace(@"\\", "").Replace(@"[", "").Replace(@"]", "").Split(','); ViewBag.parents = parents.Reverse(); List <ProductList> products = (from p in item.Products join c in item.Categories on p.CategoryID equals c.CategoryID join pic in item.PicDetails on p.ProductID equals pic.ProductID where p.CategoryID == product.CategoryID select new ProductList { ProductID = p.ProductID, CategoryName = c.CategoryName, ProductName = p.ProductName, ProductDescription = p.ProductDescription, UnitsInStock = p.UnitsInStock, ProductPrice = p.ProductPrice, Url = pic.PicUrl }).ToList(); return(View(products)); } }