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));
}
