public ActionResult Detaje(int id) { var db = new ProveDbContex(); var br = db.Brands.Where(temp => temp.BrandID == id).FirstOrDefault(); return(View(br)); }
public ActionResult Ndrysho(int id) { var db = new ProveDbContex(); var ct = db.Categories.Where(tmp => tmp.CategoryID == id).FirstOrDefault(); return(View(ct)); }
public ActionResult Ndrysho(int id) { var db = new ProveDbContex(); var b = db.Brands.Where(tmp => tmp.BrandID == id).FirstOrDefault(); return(View(b)); }
public ActionResult Delete(long id) { ProveDbContex db = new ProveDbContex(); Product existingProduct = db.Products.Where(temp => temp.ProductID == id).FirstOrDefault(); return(View(existingProduct)); }
public ActionResult Details(long id) { ProveDbContex db = new ProveDbContex(); Product p = db.Products.Where(temp => temp.ProductID == id).FirstOrDefault(); return(View(p)); }
public ActionResult Krijo(Category cat) { var db = new ProveDbContex(); db.Categories.Add(cat); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create() { ProveDbContex db = new ProveDbContex(); ViewBag.Categories = db.Categories.ToList(); ViewBag.Brands = db.Brands.ToList(); return(View()); }
public ActionResult Krijo(Brand b) { var db = new ProveDbContex(); db.Brands.Add(b); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete(long id, Product p) { ProveDbContex db = new ProveDbContex(); Product existingProduct = db.Products.Where(temp => temp.ProductID == id).FirstOrDefault(); db.Products.Remove(existingProduct); db.SaveChanges(); return(RedirectToAction("Index", "Products")); }
public ActionResult Edit(long id) { ProveDbContex db = new ProveDbContex(); Product existingProduct = db.Products.Where(temp => temp.ProductID == id).FirstOrDefault(); ViewBag.Categories = db.Categories.ToList(); ViewBag.Brands = db.Brands.ToList(); return(View(existingProduct)); }
public ActionResult Ndrysho(Category cat) { var db = new ProveDbContex(); Category ct = db.Categories.Where(tmp => tmp.CategoryID == cat.CategoryID).FirstOrDefault(); ct.CategoryName = cat.CategoryName; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Fshi(Brand br) { var db = new ProveDbContex(); Brand br1 = db.Brands.Where(tmp => tmp.BrandID == br.BrandID).FirstOrDefault(); db.Brands.Remove(br1); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Ndrysho(Brand br) { var db = new ProveDbContex(); Brand br1 = db.Brands.Where(tmp => tmp.BrandID == br.BrandID).FirstOrDefault(); br1.BrandName = br.BrandName; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(Product p) { ProveDbContex db = new ProveDbContex(); Product existingProduct = db.Products.Where(temp => temp.ProductID == p.ProductID).FirstOrDefault(); existingProduct.ProductName = p.ProductName; existingProduct.Price = p.Price; existingProduct.DateOfPurchase = p.DateOfPurchase; existingProduct.CategoryID = p.CategoryID; existingProduct.BrandID = p.BrandID; existingProduct.AvailabilityStatus = p.AvailabilityStatus; existingProduct.Active = p.Active; db.SaveChanges(); return(RedirectToAction("Index", "Products")); }
// GET: Categories/Index public ActionResult Index(string search = "", string sortcolumn = "CategoryName", string iconclass = "fa-sort-asc", int pg = 1) { var db = new ProveDbContex(); ViewBag.search = search; List <Category> categories = db.Categories.Where(tmp => tmp.CategoryName.Contains(search)).ToList(); //sortig ViewBag.sortcolumn = sortcolumn; ViewBag.iconclass = iconclass; if (ViewBag.sortcolumn == "CategoryID") { if (ViewBag.iconclass == "fa-sort-asc") { categories = categories.OrderBy(temp => temp.CategoryID).ToList(); } else { categories = categories.OrderByDescending(temp => temp.CategoryID).ToList(); } } if (ViewBag.sortcolumn == "CategoryName") { if (ViewBag.iconclass == "fa-sort-asc") { categories = categories.OrderBy(temp => temp.CategoryName).ToList(); } else { categories = categories.OrderByDescending(temp => temp.CategoryName).ToList(); } } //paging int NoOfRecordsPerPage = 5; int NoOfPages = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(categories.Count) / Convert.ToDouble(NoOfRecordsPerPage))); int NoOfRecordsToSkip = (pg - 1) * NoOfRecordsPerPage; ViewBag.PageNo = pg; ViewBag.NoOfPages = NoOfPages; categories = categories.Skip(NoOfRecordsToSkip).Take(NoOfRecordsPerPage).ToList(); return(View(categories)); }
public ActionResult Create(Product p) { ProveDbContex db = new ProveDbContex(); if (Request.Files.Count >= 1) { var file = Request.Files[0]; var imgBytes = new Byte[file.ContentLength]; file.InputStream.Read(imgBytes, 0, file.ContentLength); var base64String = Convert.ToBase64String(imgBytes, 0, imgBytes.Length); p.Photo = base64String; } db.Products.Add(p); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: Products/Index public ActionResult Index(string search = "", string SortColumn = "ProductName", string IconClass = "fa-sort-asc", int PageNo = 1) { ProveDbContex db = new ProveDbContex(); ViewBag.search = search; 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 = products.OrderBy(temp => temp.ProductID).ToList(); } else { products = products.OrderByDescending(temp => temp.ProductID).ToList(); } } else if (ViewBag.SortColumn == "ProductName") { if (ViewBag.IconClass == "fa-sort-asc") { products = products.OrderBy(temp => temp.ProductName).ToList(); } else { products = products.OrderByDescending(temp => temp.ProductName).ToList(); } } else if (ViewBag.SortColumn == "Price") { if (ViewBag.IconClass == "fa-sort-asc") { products = products.OrderBy(temp => temp.Price).ToList(); } else { products = products.OrderByDescending(temp => temp.Price).ToList(); } } else if (ViewBag.SortColumn == "DateOfPurchase") { if (ViewBag.IconClass == "fa-sort-asc") { products = products.OrderBy(temp => temp.DateOfPurchase).ToList(); } else { products = products.OrderByDescending(temp => temp.DateOfPurchase).ToList(); } } else if (ViewBag.SortColumn == "AvailabilityStatus") { if (ViewBag.IconClass == "fa-sort-asc") { products = products.OrderBy(temp => temp.AvailabilityStatus).ToList(); } else { products = products.OrderByDescending(temp => temp.AvailabilityStatus).ToList(); } } else if (ViewBag.SortColumn == "CategoryID") { if (ViewBag.IconClass == "fa-sort-asc") { products = products.OrderBy(temp => temp.Category.CategoryName).ToList(); } else { products = products.OrderByDescending(temp => temp.Category.CategoryName).ToList(); } } else if (ViewBag.SortColumn == "BrandID") { if (ViewBag.IconClass == "fa-sort-asc") { products = products.OrderBy(temp => temp.Brand.BrandName).ToList(); } else { products = products.OrderByDescending(temp => temp.Brand.BrandName).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)); }