public static List<Category> GetAll()
{
using (NorthwindEntities context = new NorthwindEntities())
{
try
{
return context.Categories.ToList();
}
catch (EntityException entityExcp)
{
Logger.Write(entityExcp);
return null;
}
}
}
public static Product GetById(int id)
{
using (var context = new NorthwindEntities())
{
try
{
return context.Products.Where(x => x.ProductID == id).FirstOrDefault();
}
catch (EntityException entityExcp)
{
Logger.Write(entityExcp);
return null;
}
}
}
public static List<Product> GetAll()
{
using (var context = new NorthwindEntities())
{
try
{
return context.Products.ToList();
}
catch (EntityException entityExcp)
{
Logger.Write(entityExcp);
return null;
}
}
}
public static Category GetByID(int id)
{
using (NorthwindEntities context = new NorthwindEntities())
{
try
{
return context.Categories.Where(x => x.CategoryID == id).FirstOrDefault();
}
catch (EntityException entityExcp)
{
Logger.Write(entityExcp);
return null;
}
}
}
public static void UpdateProduct(Product product)
{
using (var context = new NorthwindEntities())
{
try
{
context.Entry(product).State = EntityState.Modified;
context.SaveChanges();
}
catch (EntityException entityExcp)
{
Logger.Write(entityExcp);
return;
}
}
}
public Repository()
{
_context = new NorthwindEntities();
}
