public ProductModel Get(int productID)
{
using (var context = new ProductDataContext())
{
var model = context.Products.Where(c => c.ProductID == productID).FirstOrDefault();
return(model);
}
}
public int Update(int ProductId, ProductModel model)
{
using (var context = new ProductDataContext())
{
context.Entry(model).State = EntityState.Modified;
var rowsAffected = context.SaveChanges();
return(rowsAffected);
}
}
public int Add(ProductModel model)
{
using (var context = new ProductDataContext())
{
context.Products.Add(model);
var rowsAffected = context.SaveChanges();
return(rowsAffected);
}
}
public int Delete(int productID)
{
using (var context = new ProductDataContext())
{
var product = context.Products.Find(productID);
context.Products.Remove(product);
var rowsAffected = context.SaveChanges();
return(rowsAffected);
}
}
public IEnumerable <ProductModel> GetAll(string searchBy, string search, int?page)
{
using (var context = new ProductDataContext())
{
dynamic model;
if (searchBy == "Category")
{
model = context.Products.Include(x => x.Category).Include(y => y.Currency).Include(z => z.Units).
Where(p => p.Category.CategoryName.StartsWith(search) || search == null).ToList().ToPagedList(page ?? 1, 5);
}
else
{
model = context.Products.Include(x => x.Category).Include(y => y.Currency).Include(z => z.Units).
Where(p => p.ProductName.StartsWith(search) || search == null).ToList().ToPagedList(page ?? 1, 5);;
}
return(model);
}
}
