public void CreatedCategory(Category category)
{
using (var db = new NorthwindConnect())
{
db.Categories.Add(category);
db.SaveChanges();
}
}
public Category CreateCategory(string v1, string v2)
{
using (var db = new NorthwindConnect())
{
var category = new Category(v1, v2);
db.Categories.Add(category);
db.SaveChanges();
return(db.Categories.Last());
}
}
static void Main(string[] args)
{
Console.WriteLine("check ");
using (var db = new NorthwindConnect())
{
var service = new DataService();
// var category = service.CreateCategory("Test", "CreateCategory_ValidData_CreteCategoryAndRetunsNewObject");
service.CreatedCategory(new Category("we", "sfs"));
Console.WriteLine("check ");
}
}
/*Product methods*/
public Product GetProduct(int productId)
{
using (var db = new NorthwindConnect())
{
var product = db.Products.Find(productId);
if (product == null)
{
return(null);
}
return(product);
}
}
/*category methods*/
/*
* @int v id-number of categary
* @return Category with the id number given.
*/
public Category GetCategory(int categoryId)
{
using (var db = new NorthwindConnect())
{
var category = db.Categories.Find(categoryId);
if (category == null)
{
return(null);
}
return(category);
}
}
public List <Product> GetProductByCategory(int categoryId)
{
using (var db = new NorthwindConnect())
{
IEnumerable <Product> products = db.Products.Where(s => s.CategoryId == categoryId)
.Select(s => new Product
{
Name = s.Name
});
return(products.ToList());
}
}
public List <Product> GetProductByName(string productName)
{
using (var db = new NorthwindConnect())
{
IEnumerable <Product> products = db.Products.Where(s => s.Name.Contains(productName))
.Select(s => new Product
{
Name = s.Name
});
return(products.ToList());
}
}
/*public void DeleteCategory(object id)
* {
* using (var db = new NorthwindConnect())
* {
* db.Categories.Remove(db.Categories.Find(id));
* db.SaveChanges();
* }
* }*/
public bool DeleteCategory(int id)
{
using (var db = new NorthwindConnect())
{
var category = db.Categories.Find(id);
if (category == null)
{
return(false);
}
db.Categories.Remove(db.Categories.Find(id));
db.SaveChanges();
return(true);
}
}
public bool UpdateCategory(int id, string name, string description)
{
using (var db = new NorthwindConnect())
{
var category = db.Categories.Find(id);
if (category == null)
{
return(false);
}
category.Id = id;
category.Name = name;
category.Description = description;
db.SaveChanges();
return(true);
}
}
public List <Category> GetCategories()
{
var db = new NorthwindConnect();
return(db.Categories.ToList());
}