private static IOrderedQueryable <ProductViewModel> AllProducts(ProductsCatalogEntities db)
{
//var products = from p in db.Products.Include(p => p.Category)
// select new ProductViewModel
// {
// Id = p.Id,
// Name = p.Name,
// Description = p.Description,
// Image = p.Image,
// CategoryName = p.Category.Name
// };
//return products.AsEnumerable();
var productsModel = db.Products
.Select(product =>
new ProductViewModel()
{
Id = product.Id,
Name = product.Name,
Description = product.Description,
Image = product.Image,
CategoryName = product.Category.Name
}
);
return(productsModel.OrderBy(pm => pm.Name));
}
public void Add(Product item)
{
using (var pce = new ProductsCatalogEntities())
{
var t = pce.usp_ProductInsert(item.Name, item.Code, item.Description, item.Price, item.Amount, item.CategoryId.ToString());
}
}
public IEnumerable <Category> GetAll()
{
List <Category> categories = new List <Category>();
using (var pce = new ProductsCatalogEntities())
{
categories = pce.Database.SqlQuery <Category>("exec usp_CategorySelect").ToList <Category>();
}
return(categories.Count > 0 ? categories : null);
}
public bool Update(Product item)
{
using (var pce = new ProductsCatalogEntities())
{
var category = pce.Products.FirstOrDefault(x => x.Code == item.Code);
if (category != null)
{
var t = pce.usp_ProductUpdate(item.Name, item.Code, item.Description, item.Price, item.Amount, category.CategoryId);
}
}
return(true);
}
private static IOrderedQueryable <CategoryViewModel> AllCategories(ProductsCatalogEntities db)
{
var categoriesModel = db.Categories
.Select(category =>
new CategoryViewModel()
{
Id = category.Id,
Name = category.Name,
Description = category.Description
}
);
return(categoriesModel.OrderBy(c => c.Name));
}
public IEnumerable <Product> GetAll()
{
List <Product> products = new List <Product>();
using (var pce = new ProductsCatalogEntities())
{
var categories = pce.Database.SqlQuery <Category>("exec usp_CategorySelect").ToList <Category>();
products = pce.Database.SqlQuery <Product>("exec usp_ProductSelect").ToList <Product>();
foreach (var product in products)
{
var category = categories.FirstOrDefault(x => x.Id == product.CategoryId);
product.Category = new Category
{
Id = (int)product.CategoryId,
Name = category != null ? category.Name : "no category"
};
}
}
return(products.Count > 0 ? products : null);
}
