public JsonResult byVariant(string vr) { if (vr != null || vr != "null") { List <int> s = JsonConvert.DeserializeObject <List <int> >(vr); //list var product = new List <product_tbl>(); foreach (var v in s) { //get varint type data var p = db.product_variant_value.Where(a => a.variant_unit_id == v).GroupBy(a => a.product_id).Select(g => new { product_id = g.Key }).ToList(); //var p = db.product_variant_value.Where(a => a.variant_unit_id == v).ToList(); foreach (var o in p) { //var k = IGrouping<int>g => new { p_name = g.Key } //get product var p1 = db.product_tbl.Find(o.product_id); var ps = new product_tbl(); ps.product_id = p1.product_id; ps.p_name = p1.p_name; ps.price = p1.price; ps.points = p1.points; ps.quantity = p1.quantity; ps.main_image = p1.main_image; product.Add(ps); } } return(Json(new { list = product }, JsonRequestBehavior.AllowGet)); } return(Json(JsonRequestBehavior.AllowGet)); }
public IHttpActionResult Postproduct_tbl(product_tbl product_tbl) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.product_tbl.Add(product_tbl); try { db.SaveChanges(); } catch (DbUpdateException) { if (product_tblExists(product_tbl.Id)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = product_tbl.Id }, product_tbl)); }
public IHttpActionResult Putproduct_tbl(int id, product_tbl product_tbl) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != product_tbl.Id) { return(BadRequest()); } db.Entry(product_tbl).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!product_tblExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Getproduct_tbl(int id) { product_tbl product_tbl = db.product_tbl.Find(id); if (product_tbl == null) { return(NotFound()); } return(Ok(product_tbl)); }
public IHttpActionResult Deleteproduct_tbl(int id) { product_tbl product_tbl = db.product_tbl.Find(id); if (product_tbl == null) { return(NotFound()); } db.product_tbl.Remove(product_tbl); db.SaveChanges(); return(Ok(product_tbl)); }
public ActionResult Add(MvcProductModel product) { if (ModelState.IsValid) { product_tbl obj = new product_tbl(); obj.Id = product.Id; obj.Name = product.Name; obj.Category = product.Category; obj.Price = product.Price; string fileName = Path.GetFileNameWithoutExtension(product.ImageFile.FileName); string fileExtension = Path.GetExtension(product.ImageFile.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + fileExtension; product.smallImage = "~/SImages/" + fileName; fileName = Path.Combine(Server.MapPath("~/SImages/"), fileName); product.ImageFile.SaveAs(fileName); string fileName1 = Path.GetFileNameWithoutExtension(product.ImageFile1.FileName); string fileExtension1 = Path.GetExtension(product.ImageFile1.FileName); fileName1 = fileName1 + DateTime.Now.ToString("yymmssfff") + fileExtension1; product.longImage = "~/LImages/" + fileName1; fileName1 = Path.Combine(Server.MapPath("~/LImages/"), fileName1); product.ImageFile1.SaveAs(fileName1); obj.smallImage = product.smallImage; obj.longImage = product.longImage; obj.shortDescription = product.shortDescription; obj.longDescription = product.longDescription; obj.Quantity = product.Quantity; if (product.Id == 0) { HttpResponseMessage responses = MvcGlobalVariables.webapiclient.PostAsJsonAsync("product", obj).Result; TempData["success"] = product.Name.ToString() + " Added Successfully."; } else { HttpResponseMessage responses = MvcGlobalVariables.webapiclient.PutAsJsonAsync("product/" + product.Id, obj).Result; TempData["success"] = product.Name.ToString() + " Updated Successfully"; } return(RedirectToAction("ProductList")); } return(View()); }
public JsonResult filterProduct(int max, int min, string pvv, int cid) { if (pvv != "") { List <int> s = JsonConvert.DeserializeObject <List <int> >(pvv); //list var product = new List <product_tbl>(); foreach (var v in s) { //get varint type data var pro = db.product_variant_value.Where(a => a.variant_unit_id == v).GroupBy(a => a.product_id).Select(g => new { product_id = g.Key }).ToList(); //var p = db.product_variant_value.Where(a => a.variant_unit_id == v).ToList(); foreach (var o in pro) { //var k = IGrouping<int>g => new { p_name = g.Key } //get product var p1 = db.product_tbl.Find(o.product_id); var ps = new product_tbl(); ps.product_id = p1.product_id; ps.p_name = p1.p_name; ps.price = p1.price; ps.points = p1.points; ps.quantity = p1.quantity; ps.main_image = p1.main_image; product.Add(ps); } } var p = product.Where(a => a.price >= min && a.price <= max).ToList(); return(Json(new { list = p }, JsonRequestBehavior.AllowGet)); } else { var p = db.prcFilter(max, min, cid).ToList(); return(Json(new { list = p }, JsonRequestBehavior.AllowGet)); } }
// GET: product public ActionResult detail(int?id) { var cates = new List <category_tbl>(); var Product = new product(); if (id != null) { var pro = new List <product_tbl>(); var p = db.product_tbl.Find(id); var g = db.product_image_tbl.Where(a => a.product_id == p.product_id).ToList(); Product.discription = p.discription; Product.main_image = p.main_image; Product.meta_description = p.meta_description; Product.meta_keyword = p.meta_keyword; Product.meta_title = p.meta_title; Product.price = p.price; Product.product_id = p.product_id; Product.quantity = p.quantity; Product.videoLink = p.VideoLink; //get discount price var date = DateTime.Today; var d = db.product_discount_tbl.OrderBy(a => a.priority).Where(a => a.date_start <= date && a.date_end >= date && a.quantity != 0 && a.product_id == id).FirstOrDefault(); if (d != null) { Product.discountPrice = Convert.ToDecimal(Product.price - d.price); } Product.p_name = p.p_name; ViewBag.imgPath = ConfigurationManager.AppSettings["productimgPath"].ToString(); ViewBag.Variant = cc.variant(p.product_id); //add gallery img Product.gallery = g; var r = db.product_related_tbl.Where(a => a.product_ID == p.product_id).ToList(); foreach (var rel in r) { var pr = db.product_tbl.OrderByDescending(a => a.product_id).Where(a => a.product_id == rel.releted_product_ID).ToList(); foreach (var p1 in pr) { var ps = new product_tbl(); ps.product_id = p1.product_id; ps.p_name = p1.p_name; ps.price = p1.price; ps.points = p1.points; ps.quantity = p1.quantity; ps.main_image = p1.main_image; pro.Add(ps); } } //this section ic common var home = new HomeController(); string sessionID = Session.SessionID.ToString(); ViewBag.showMenu = home.menu(); ViewBag.footer = home.footerSocial(); ViewBag.cartPanal = home.cartPanl(sessionID); ViewBag.simpalCart = home.simpalCart(sessionID); Product.relatedProduct = pro; ViewBag.bycategory = bycategory(id); return(View(Product)); } else { return(HttpNotFound()); } }