public ActionResult Save(Item objItem, HttpPostedFileBase file) { ViewBag.IsSaved = false; db = new krennovaEntities(); if (ModelState.IsValid) { try { var fileName = ""; if (file.ContentLength > 0) { fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/Content/Images"), fileName); string[] file_name = fileName.Split('.'); file.SaveAs(path); } objItm.ItemName = objItem.ItemName; objItm.Price = objItem.Price; objItm.Category = objItem.Category; objItm.Image = "Content/Images/" + fileName; objItm.Description = objItem.Description; db.Items.Add(objItm); db.SaveChanges(); ModelState.Clear(); ViewBag.IsSaved = true; } catch (Exception) { } } //objItm.itemList = db.Items.ToList(); ViewBag.Category = new SelectList(db.Categories, "Id", "CatName", objItm.Category); return(View("AddItem")); }
public ActionResult Update(Item objItem, int id, HttpPostedFileBase file) { try { db = new krennovaEntities(); Item objItm = db.Items.Find(id); var fileName = ""; if (file != null) { if (file.ContentLength > 0) { fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/Content/Images"), fileName); string[] file_name = fileName.Split('.'); file.SaveAs(path); objItm.Image = "Content/Images/" + fileName; } } else { objItm.Image = objItm.Image; } objItm.ItemName = objItem.ItemName; objItm.Price = objItem.Price; objItm.Category = objItem.Category; objItm.Description = objItem.Description; db.Entry(objItm); db.SaveChanges(); } catch { } objItm.itemList = db.Items.ToList(); return(View("Index", objItm.itemList)); }
public ActionResult Index() { db = new krennovaEntities(); objItm.itemList = db.Items.ToList(); return(View(objItm.itemList)); }
public ActionResult ViewItem(int Id) { db = new krennovaEntities(); Item objItm = db.Items.Find(Id); return(View(objItm)); }
public ActionResult Items(int?page) { int pageSize = 6; int pageNumber = (page ?? 1); db = new krennovaEntities(); objItm.itemList = db.Items.OrderBy(i => i.Id).ToPagedList(pageNumber, pageSize); return(View(objItm.itemList)); }
public ActionResult EditItem(Item objItem, int id) { db = new krennovaEntities(); Item itm = db.Items.Find(id); ViewBag.Category = new SelectList(db.Categories, "Id", "CatName", itm.Category); return(View(itm)); }
public ActionResult Carpet(int?page) { int pageSize = 6; int pageNumber = (page ?? 1); db = new krennovaEntities(); //objItm.itemList = db.Items.Where(i => i.Category == 1).ToList(); // objeventGallery.NewsList = newsList.OrderByDescending(i => i.Date).ToPagedList(pageNumber, pageSize); objItm.itemList = db.Items.Where(i => i.Category == 1).OrderBy(i => i.Id).ToPagedList(pageNumber, pageSize); return(View(objItm.itemList)); }
public ActionResult Delete(int id) { db = new krennovaEntities(); try { if (!string.IsNullOrWhiteSpace(Convert.ToString(id))) { Item objItm = db.Items.Find(id); db.Items.Remove(objItm); db.SaveChanges(); } } catch { } objItm.itemList = db.Items.ToList(); return(View("Index", objItm.itemList)); }
public ActionResult ViewItem(int Id) { if (!string.IsNullOrEmpty(Id.ToString())) { List <ItemCategoryWrap> model = new List <ItemCategoryWrap>(); try { db = new krennovaEntities(); //Item itm = db.Items.Find(Id); var data = (from i in db.Items join c in db.Categories on i.Category equals c.Id where i.Id == Id select new { i.Id, c.CatName, i.ItemName, i.Price, i.Image, i.Description }); //retrieve each item and assign to model foreach (var item in data) { model.Add(new ItemCategoryWrap() { ItemId = item.Id, ItemName = item.ItemName, Category = item.CatName, Image = item.Image, Price = item.Price, Description = item.Description }); } } catch { } return(View(model)); } else { return(Redirect(ControllerContext.HttpContext.Request.UrlReferrer.ToString())); } }
public ActionResult AddItem() { db = new krennovaEntities(); ViewBag.Category = new SelectList(db.Categories, "Id", "CatName", objItm.Category); return(View()); }