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