/// <summary>
/// Get All Products.
/// </summary>
public List <ProductModel> GetAllProducts()
{
List <ProductModel> collection = new List <ProductModel>();
using (var context = new WOW_Assignment_ProductDBEntities1())
{
collection.AddRange((context.Products.ToList().Select(a => ProductModel.Convert(a))));
}
return(collection);
}
/// <summary>
/// Get Product Count .
/// </summary>
public int ProductCount()
{
int count = 0;
using (var context = new WOW_Assignment_ProductDBEntities1())
{
count = context.Products.Count();
}
return(count);
}
/// <summary>
/// Get Product.
/// </summary>
/// <param name="id"></param>
public ProductModel GetProduct(int id)
{
ProductModel product = null;
using (var context = new WOW_Assignment_ProductDBEntities1())
{
var entity = context.Products.Where(a => a.ProductID == id).ToList().FirstOrDefault();
product = ProductModel.Convert(entity);
}
return(product);
}
/// <summary>
/// Add Product.
/// </summary>
/// <param name="model"></param>
public bool AddProduct(ProductModel model)
{
outcome = false;
using (var context = new WOW_Assignment_ProductDBEntities1())
{
var entity = ProductModel.Convert(model);
context.Products.Add(entity);
outcome = context.SaveChanges() == 1;
}
return(outcome);
}
/// <summary>
/// Remove Product.
/// </summary>
/// <param name="model"></param>
public bool RemoveProduct(ProductModel model)
{
outcome = false;
using (var context = new WOW_Assignment_ProductDBEntities1())
{
if (model != null)
{
var entity = ProductModel.Convert(model);
context.Products.Attach(entity);
context.Products.Remove(entity);
outcome = context.SaveChanges() == 1;
}
}
return(outcome);
}
/// <summary>
/// Update Product.
/// </summary>
/// <param name="model"></param>
public bool UpdateProduct(ProductModel model)
{
outcome = false;
using (var context = new WOW_Assignment_ProductDBEntities1())
{
if (model != null)
{
var entity = ProductModel.Convert(model);
context.Products.Attach(entity);
var entry = context.Entry(entity);
entry.Property(p => p.Title).IsModified = true;
entry.Property(p => p.Description).IsModified = true;
entry.Property(p => p.ImageURL).IsModified = true;
outcome = context.SaveChanges() == 1;
}
}
return(outcome);
}
