public ActionResult Details(int id) { ElectronicDBEntities db = new ElectronicDBEntities(); Product product = db.Products.Where(temp => temp.ProductID == id).FirstOrDefault(); return(View(product)); }
public ActionResult Delete(long id) { ElectronicDBEntities db = new ElectronicDBEntities(); Product p = db.Products.Where(temp => temp.ProductID == id).FirstOrDefault(); return(View(p)); }
// GET: Categories public ActionResult Index() { ElectronicDBEntities db = new ElectronicDBEntities(); List <Category> categories = db.Categories.ToList(); return(View(categories)); }
// GET: Brands public ActionResult Index() { ElectronicDBEntities db = new ElectronicDBEntities(); List <Brand> brands = db.Brands.ToList(); return(View(brands)); }
public ActionResult Create() { ElectronicDBEntities db = new ElectronicDBEntities(); ViewBag.Category = db.Categories.ToList(); ViewBag.Brand = db.Brands.ToList(); return(View()); }
public ActionResult Delete(long id, string x) { ElectronicDBEntities db = new ElectronicDBEntities(); Product p = db.Products.Where(temp => temp.ProductID == id).FirstOrDefault(); db.Products.Remove(p); db.SaveChanges(); return(RedirectToAction("Index", "Products")); }
public ActionResult Edit(long id) { ElectronicDBEntities db = new ElectronicDBEntities(); Product existingProduct = db.Products.Where(temp => temp.ProductID == id).FirstOrDefault(); ViewBag.Category = db.Categories.ToList(); ViewBag.Brand = db.Brands.ToList(); return(View(existingProduct)); }
public ActionResult Edit(Product newProduct) { ElectronicDBEntities db = new ElectronicDBEntities(); Product existingProduct = db.Products.Where(temp => temp.ProductID == newProduct.ProductID).FirstOrDefault(); existingProduct.ProductName = newProduct.ProductName; existingProduct.Price = newProduct.Price; existingProduct.DateOfPurchase = newProduct.DateOfPurchase; existingProduct.AvailabilityStatus = newProduct.AvailabilityStatus; existingProduct.CategoryID = newProduct.CategoryID; existingProduct.BrandID = newProduct.BrandID; existingProduct.Active = newProduct.Active; db.SaveChanges(); return(RedirectToAction("Index", "Products")); }
public ActionResult Create(Product product) { ElectronicDBEntities db = new ElectronicDBEntities(); if (Request.Files.Count >= 1) { var file = Request.Files[0]; var imgBytes = new Byte[file.ContentLength - 1]; file.InputStream.Read(imgBytes, 0, file.ContentLength); var base64String = Convert.ToBase64String(imgBytes, 0, imgBytes.Length); product.Photo = base64String; } db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index", "Products")); }
// GET: Products public ActionResult Index(string search = "", string SortColumn = "ProductName", string IconClass = "fa-sort-desc", int PageNo = 1) { ViewBag.Search = search; ElectronicDBEntities db = new ElectronicDBEntities(); List <Product> products = db.Products.Where(temp => temp.ProductName.Contains(search)).ToList(); //Sorting ViewBag.SortColumn = SortColumn; ViewBag.IconClass = IconClass; if (ViewBag.SortColumn == "ProductID") { if (ViewBag.IconClass == "fa-sort-asc") { products = db.Products.OrderBy(temp => temp.ProductID).ToList(); } else { products = db.Products.OrderByDescending(temp => temp.ProductID).ToList(); } } else if (ViewBag.SortColumn == "ProductName") { if (ViewBag.IconClass == "fa-sort-asc") { products = db.Products.OrderBy(temp => temp.ProductID).ToList(); } else { products = db.Products.OrderByDescending(temp => temp.ProductID).ToList(); } } else if (ViewBag.SortColumn == "Price") { if (ViewBag.IconClass == "fa-sort-asc") { products = db.Products.OrderBy(temp => temp.ProductID).ToList(); } else { products = db.Products.OrderByDescending(temp => temp.ProductID).ToList(); } } else if (ViewBag.SortColumn == "DateOfPurchase") { if (ViewBag.IconClass == "fa-sort-asc") { products = db.Products.OrderBy(temp => temp.ProductID).ToList(); } else { products = db.Products.OrderByDescending(temp => temp.ProductID).ToList(); } } else if (ViewBag.SortColumn == "AvailabilityStatus") { if (ViewBag.IconClass == "fa-sort-asc") { products = db.Products.OrderBy(temp => temp.ProductID).ToList(); } else { products = db.Products.OrderByDescending(temp => temp.ProductID).ToList(); } } else if (ViewBag.SortColumn == "CategoryID") { if (ViewBag.IconClass == "fa-sort-asc") { products = db.Products.OrderBy(temp => temp.ProductID).ToList(); } else { products = db.Products.OrderByDescending(temp => temp.ProductID).ToList(); } } else if (ViewBag.SortColumn == "BrandID") { if (ViewBag.IconClass == "fa-sort-asc") { products = db.Products.OrderBy(temp => temp.ProductID).ToList(); } else { products = db.Products.OrderByDescending(temp => temp.ProductID).ToList(); } } //Paging int NoOfRecordsPerPage = 5; int NoOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(products.Count) / Convert.ToDouble(NoOfRecordsPerPage))); int NoOfRecordsToSkip = (PageNo - 1) * NoOfRecordsPerPage; ViewBag.PageNo = PageNo; ViewBag.NoOfPages = NoOfPages; products = products.Skip(NoOfRecordsToSkip).Take(NoOfRecordsPerPage).ToList(); return(View(products)); }