public void Get() { PTCEntities db = new PTCEntities(); Products = db.Products.OrderBy(p => p.ProductName).ToList(); SetUIState(PageConstants.LIST); }
public Product Get(int productId) { PTCEntities db = new PTCEntities(); Entity = db.Products.Find(productId); return(Entity); }
public void LoadCategories() { PTCEntities db = new PTCEntities(); // Load categories Categories.AddRange(db.Categories); }
public void Delete(int productId) { PTCEntities db = new PTCEntities(); Product product = db.Products.Find(productId); db.Products.Remove(product); db.SaveChanges(); Get(); }
public void Search() { PTCEntities db = new PTCEntities(); // Perform Search Products = db.Products.Where(p => (SearchEntity.CategoryId == 0 ? true : p.Category.CategoryId == SearchEntity.CategoryId) && (string.IsNullOrEmpty(SearchEntity.ProductName) ? true : p.ProductName.Contains(SearchEntity.ProductName))). OrderBy(p => p.ProductName).ToList(); SetUIState(PageConstants.LIST); }
public void SearchPrice() { PTCEntities db = new PTCEntities(); ProductsMaxPrice = db.Products.Where(p => (SearchEntity.MaxPrice) >= (p.Price)) .OrderBy(p => p.Price).ToList(); ProductsMinPrice = db.Products.Where(p => (SearchEntity.MinPrice) <= (p.Price)) .OrderBy(p => p.Price).ToList(); SetUIState(PageConstants.LIST); }
public void LoadSearchCategories() { PTCEntities db = new PTCEntities(); if (Categories.Count == 0) { SearchCategories.AddRange(db.Categories); } else { SearchCategories.AddRange(Categories); } Category entity = new Category(); entity.CategoryId = 0; entity.CategoryName = "--- Search All Categories ---"; SearchCategories.AddRange(Categories); SearchCategories.Insert(0, entity); }
public void Save() { Messages.Clear(); PTCEntities db = new PTCEntities(); // Ensure the correct category is set Entity.Category = db.Categories.Find(Entity.Category.CategoryId); try { // Either Update or Insert product if (PageMode == PageConstants.EDIT) { db.Entry(Entity).State = EntityState.Modified; db.SaveChanges(); } else if (PageMode == PageConstants.ADD) { db.Products.Add(Entity); db.SaveChanges(); } // Get all the data again in case anything changed Get(); } catch (DbEntityValidationException ex) { IsValid = false; // Validation errors foreach (var errors in ex.EntityValidationErrors) { foreach (var item in errors.ValidationErrors) { Messages.AddModelError(item.PropertyName, item.ErrorMessage); } } // Set page state SetUIState(PageMode); } }
public void LoadSearchCategories() { PTCEntities db = new PTCEntities(); if (Categories.Count == 0) { // Load categories SearchCategories.AddRange(db.Categories); } else { SearchCategories.AddRange(Categories); } // Add category for 'Search All' Category entity = new Category(); entity.CategoryId = 0; entity.CategoryName = "-- Search All Categories --"; SearchCategories.AddRange(Categories); // Insert "Search" at the top SearchCategories.Insert(0, entity); }
public void Save() { Messages.Clear(); PTCEntities db = new PTCEntities(); Entity.Category = db.Categories.Find(Entity.Category.CategoryId); try { if (PageMode == PageConstants.EDIT) { db.Entry(Entity).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else if (PageMode == PageConstants.ADD) { db.Products.Add(Entity); db.SaveChanges(); } Get(); } catch (DbEntityValidationException ex) { IsValid = false; foreach (var errors in ex.EntityValidationErrors) { foreach (var item in errors.ValidationErrors) { Messages.AddModelError(item.PropertyName, item.ErrorMessage); } } SetUIState(PageMode); } }