public category GetById(int id)
{
using (var db = new MVCDemoEntities())
{
return(db.categories.Where(s => s.id == id).FirstOrDefault());
}
}
public product GetById(int id)
{
using (var db = new MVCDemoEntities())
{
return(db.products.Where(s => s.id == id).FirstOrDefault());
}
}
public List <category> GetAll()
{
using (var db = new MVCDemoEntities())
{
return(db.categories.ToList());
}
}
public List <product> GetAll()
{
using (var db = new MVCDemoEntities())
{
return(db.products.OrderByDescending(s => s.id).ToList());
}
}
public void Update(product product)
{
using (var db = new MVCDemoEntities())
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
}
}
private List <vDeptEmp> GetDepEmp()
{
List <vDeptEmp> deptEmps = new List <vDeptEmp>();
using (MVCDemoEntities db = new MVCDemoEntities())
{
deptEmps = db.vDeptEmp.ToList();
}
return(deptEmps);
}
public void Add(product product)
{
product.created_date = DateTime.Now;
product.created_by = "web";
using (var db = new MVCDemoEntities())
{
db.products.Add(product);
db.SaveChanges();
}
}
public void Delete(int id)
{
using (var db = new MVCDemoEntities())
{
var product = db.products.Where(s => s.id == id).FirstOrDefault();
if (product != null)
{
db.products.Remove(product);
db.SaveChanges();
}
}
//using (var db = new MVCDemoEntities())
//{
// db.USP_PRODUCTS_DELETE(id);
//}
}
