public bool DeleteCategory(int id)
{
try
{
using (var db = new NorthwindContex())
{
var delCat = new Category()
{
Id = id
};
db.Categories.Attach(delCat);
db.Categories.Remove(delCat);
db.SaveChanges();
if (delCat != null)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception) { } return(false);
}
public bool UpdateCategory(int categoryId, String name, String description)
{
using (var db = new NorthwindContex())
{
var category = db.Categories.FirstOrDefault(x => x.Id == categoryId);
if (category != null)
{
category.Name = name;
category.Description = description;
db.SaveChanges();
return(true);
}
return(false);
}
}
public Category CreateCategory(string name, string description)
{
using (var db = new NorthwindContex())
{
var count = GetCategories();
var newCat = new Category()
{
Id = count.Count() + 1,
Name = name,
Description = description
};
db.Categories.Add(newCat);
db.SaveChanges();
return(newCat);
}
}
public bool DeleteCategory(int id)
{
using (var db = new NorthwindContex())
{
var category = db.Categories.FirstOrDefault(x => x.Id == id);
if (category != null)
{
db.Categories.Remove(category);
db.SaveChanges();
return(true);
}
return(false);
}
}
