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); }