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