public ActionResult ShowAllProducts()
{
using (var db = new Models.CategoryDb())
{
return(View(db));
}
}
public ActionResult CategoryEdit(int id)
{
using (var db = new Models.CategoryDb())
{
var cat = db.Categories.FirstOrDefault(p => p.CategoryId == id);
var model = new ViewModels.CategoryEditViewModel
{
CategoryId = cat.CategoryId,
Name = cat.Name
};
return(View(model));
}
}
public ActionResult ProductView(int id)
{
using (var db = new Models.CategoryDb())
{
var p = db.Products.FirstOrDefault(r => r.ProductId == id);
var model = new ViewModels.ProductViewViewModel
{
Name = p.Name,
Description = p.Description,
Price = p.Price
};
return(View(model));
}
}
public ActionResult ProductEdit(int id)
{
using (var db = new Models.CategoryDb())
{
var prod = db.Products.FirstOrDefault(p => p.ProductId == id);
var model = new ViewModels.ProductEditViewModel
{
ProductId = prod.ProductId,
Name = prod.Name,
Description = prod.Description,
Price = prod.Price,
};
return(View(model));
}
}
public ActionResult Index()
{
var model = new ViewModels.CategoryIndexViewModel();
using (var db = new Models.CategoryDb())
{
model.Categories.AddRange(db.Categories.Select(c => new ViewModels.CategoryIndexViewModel.CategoryListViewModel
{
Name = c.Name,
CategoryId = c.CategoryId
}));
}
return(View(model));
}
public ActionResult CategoryCreate(ViewModels.CategoryIndexViewModel.CategoryListViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new Models.CategoryDb())
{
var m = new Models.Category
{
Name = model.Name,
};
db.Categories.Add(m);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult CategoryEdit(ViewModels.CategoryEditViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new Models.CategoryDb())
{
var cat = db.Categories.FirstOrDefault(r => r.CategoryId == model.CategoryId);
cat.CategoryId = model.CategoryId;
cat.Name = model.Name;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
//SetUpAvailableCategories För EDIT
void SetupAvailableCatagories(ViewModels.ProductCreateViewModel model)
{
model.AvailableCategory = new List <SelectListItem>
{
new SelectListItem {
Value = null, Text = "Choose A Category"
},
};
using (var db = new Models.CategoryDb())
{
foreach (var cat in db.Categories)
{
model.AvailableCategory.Add(new SelectListItem {
Value = cat.CategoryId.ToString(), Text = cat.Name
});
}
}
}
public ActionResult Search(string SearchProduct)
{
using (var db = new Models.CategoryDb())
{
var model = new ViewModels.ProductIndexViewModel
{
SearchProduct = SearchProduct
};
model.Products.AddRange(db.Products.ToList().Select(r => new ViewModels.ProductIndexViewModel.ProductListViewModel
{
ProductId = r.ProductId,
Name = r.Name,
Price = r.Price,
Description = r.Description,
}).ToList().Where(c => c.Name.ToLower().Contains(model.SearchProduct.ToLower()) || c.Description.ToLower().Contains(model.SearchProduct.ToLower())
));
return(View("Search", model));
}
}
public ActionResult ProductEdit(ViewModels.ProductEditViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new Models.CategoryDb())
{
var p = db.Products.FirstOrDefault(r => r.ProductId == model.ProductId);
p.ProductId = model.ProductId;
p.Name = model.Name;
p.Description = model.Description;
p.Price = model.Price;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult ProductCreate(ViewModels.ProductCreateViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new Models.CategoryDb())
{
var pro = new Models.Product
{
Name = model.Name,
Description = model.Description,
Price = model.Price,
Category = db.Categories.First(c => c.CategoryId == model.CategoryId)
};
db.Products.Add(pro);
db.SaveChanges();
}
return(RedirectToAction("Index", new { id = model.CategoryId }));
}
public ActionResult CategoryView(int id, string sort)
{
var model = new ViewModels.ProductIndexViewModel();
using (var db = new Models.CategoryDb())
{
model.Products.AddRange(db.Products.Select(p => new ViewModels.ProductIndexViewModel.ProductListViewModel
{
Name = p.Name,
ProductId = p.ProductId,
Description = p.Description,
CategoryId = p.Category.CategoryId,
Price = p.Price
}).Where(p => p.CategoryId == id));
if (sort == "NamnAsc")
{
model.Products = model.Products.OrderBy(r => r.Name).ToList();
}
else if (sort == "NamnDesc")
{
model.Products = model.Products.OrderByDescending(r => r.Name).ToList();
}
if (sort == "PriceAsc")
{
model.Products = model.Products.OrderBy(r => r.Price).ToList();
}
else if (sort == "PriceDesc")
{
model.Products = model.Products.OrderByDescending(r => r.Price).ToList();
}
model.CurrentSort = sort;
return(View(model));
}
}
public ActionResult CurrentSort(string sort)
{
var model = new ViewModels.ProductIndexViewModel();
using (var db = new Models.CategoryDb())
{
model.Products.AddRange(db.Products.Select(r => new ViewModels.ProductIndexViewModel.ProductListViewModel
{
ProductId = r.ProductId,
Name = r.Name
}));
if (sort == "NamnAsc")
{
model.Products = model.Products.OrderBy(r => r.Name).ToList();
}
else if (sort == "NamnDesc")
{
model.Products = model.Products.OrderByDescending(r => r.Name).ToList();
}
if (sort == "PriceAsc")
{
model.Products = model.Products.OrderBy(r => r.Price).ToList();
}
else if (sort == "PriceDesc")
{
model.Products = model.Products.OrderByDescending(r => r.Price).ToList();
}
model.CurrentSort = sort;
return(View(model));
}
}
