//12 public bool UpdateCategory(int id, string name, string description) { using (var db = new NordWindContext()) { var update = new Category { Id = id, Name = name, Description = description }; try { db.Categories.Update(update); db.SaveChanges(); Console.WriteLine("The category has been updated"); return(true); } catch (Exception e) { Console.WriteLine("The category cannot be updated"); return(false); } } }
//11 public Category CreateCategory(string name, string description) { using (var db = new NordWindContext()) { var category = new Category { Name = name, Description = description }; db.Categories.Add(category); db.SaveChanges(); return(category); } }
//11 public Category CreateCategory(string name, string description) { using (var db = new NordWindContext()) { var category = new Category { Name = name, Description = description }; db.Categories.Add(category); db.SaveChanges(); Console.WriteLine("The category has been added"); return(category); } }
static void Main(string[] args) { DataService d = new DataService(); /* This is all the test calls of my functions, just ignore them, or use them as you make yours*/ var order = d.GetOrder(10248); //var shippingOrder = d.getOrderFromShippingName("The Big Cheese"); //var orders = d.GetOrders(); //var orders = d.GetOrderDetailsByOrderId(10248); //var orders = d.GetOrderDetailsByProductId(11); //var products = d.GetProduct(1); //var products = d.GetProductByName("ant"); //var products = d.GetProductByCategory(1); //var categorys = d.GetCategory(-1); //var categories = d.getCategories(); //d.CreateCategory("Test", "Nope"); //d.deleteCategory(13); //d.updateCategory(12, "Nope", "Nope"); using (var db = new NordWindContext()) { var category = db.Categories.FirstOrDefault(x => x.Id == 11); if (category != null) { category.Name = "2017 Testing"; } db.SaveChanges(); } }
//13 public bool DeleteCategory(int id) { using (var db = new NordWindContext()) { var delete = new Category { Id = id }; try { db.Categories.Remove(delete); db.SaveChanges(); Console.WriteLine("The category has been deleted"); return(true); } catch (Exception e) { Console.WriteLine("The category cannot be deleted"); return(false); } } }
//13 public bool DeleteCategory(int id) { using (var db = new NordWindContext()) { var delete = new Category { Id = id }; try { db.Categories.Remove(delete); db.SaveChanges(); Console.WriteLine("Sucess!"); return(true); } catch (Exception e) { Console.WriteLine("Can't delete"); return(false); } } }