public List <Category> GetCategories()
{
using (var db = new NorthwindContex())
{
return(db.Categories.ToList());
}
}
public Category GetCategory(int inputCatId)
{
using (var db = new NorthwindContex())
{
return(db.Categories.Find(inputCatId));
}
}
public Product GetProduct(int inputProductId)
{
using (var db = new NorthwindContex())
{
Product tempProduct = db.Products.Find(inputProductId);
tempProduct.Category = db.Categories.Find(tempProduct.CategoryId);
return(tempProduct);
}
}
public List <Product> GetProductByCategory(int inputCategoryId)
{
using (var db = new NorthwindContex())
{
var listByCategory = db.Products.Where(p => p.CategoryId == inputCategoryId);
foreach (Product prod in listByCategory)
{
prod.Category = db.Categories.Find(prod.CategoryId);
}
var outputListByCategory = listByCategory.ToList();
return(outputListByCategory);
}
}
public bool DeleteCategory(int inputCatId)
{
using (var db = new NorthwindContex())
{
var record = db.Categories.FirstOrDefault(r => r.Id == inputCatId);
if (record != null)
{
var cat = db.Categories.First(c => c.Id == inputCatId);
db.Categories.Remove(cat);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public Category CreateCategory(string categoryName, string catDescription)
{
using (var db = new NorthwindContex())
{
/*
* int newId = Convert.ToInt32(from cat in db.Categories
* orderby cat.Id descending
* select cat.Id);
*/
Category newCat;
db.Categories.Add(newCat = new Category()
{
//ÆNDRE! Det må ikke være hardcoded
Id = db.Categories.Max(x => x.Id) + 1,
Name = categoryName,
Description = catDescription
});
db.SaveChanges();
return(newCat);
}
}
public bool UpdateCategory(int inputCatId, string updateName, string updateDesc)
{
using (var db = new NorthwindContex()) {
var record = db.Categories.FirstOrDefault(r => r.Id == inputCatId);
if (record != null)
{
var chosenCategory = from cat in db.Categories
where cat.Id == inputCatId
select cat;
foreach (Category cat in chosenCategory)
{
cat.Name = updateName;
cat.Description = updateDesc;
}
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
