public void InsertCategory(Category NewCategory)
{
using (var db = new Sana())
{
db.Categories.Add(NewCategory);
db.SaveChanges();
}
}
public void Delete(int IdCategory)
{
using (var db = new Sana())
{
Category query = (from x in db.Categories
where x.CategoryId == IdCategory
select x).FirstOrDefault <Category>();
if (query != null)
{
db.Categories.Remove(query);
db.SaveChanges();
}
}
}
public void Edit(Category Editedclass)
{
var x = Editedclass;
try
{
using (var db = new Sana())
{
var pac = (from p in db.Categories where p.CategoryId == Editedclass.CategoryId select p).FirstOrDefault();
db.Categories.Attach(pac);
db.Entry(pac).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
}
}
