protected void BuildCollection() { PTCData db = null; try { db = new PTCData(); DataCollection = db.Products.ToList(); if (DataCollection != null && DataCollection.Count > 0) { if (!string.IsNullOrEmpty(SearchEntity.ProductName)) { //DataCollection = DataCollection.FindAll( // p => p.ProductName. // StartsWith(SearchEntity.ProductName, // StringComparison.InvariantCultureIgnoreCase)); DataCollection = DataCollection.FindAll( p => p.ProductName.IndexOf( SearchEntity.ProductName, StringComparison.OrdinalIgnoreCase) >= 0); } } } catch (Exception ex) { Publish(ex, "Error while loading products."); } }
public void Search() { PTCData db = null; ResetException(); try { db = new PTCData(); // Perform Search Products = db.Products.Where(p => (SearchEntity.CategoryId == 0 ? true : p.Category.CategoryId == SearchEntity.CategoryId) && (string.IsNullOrEmpty(SearchEntity.ProductName) ? true : p.ProductName.StartsWith(SearchEntity.ProductName))). OrderBy(p => p.ProductName).ToList(); SetUIState(PDSAPageModeEnum.List); } catch (Exception ex) { LastException = ex; Message = "ERROR Searching for Products"; } }
public void Save() { PTCData db = null; Messages.Clear(); ResetException(); try { db = new PTCData(); // Ensure the correct category is set if (Entity.CategoryId == null) { Entity.Category = db.Categories.Find(Entity.Category.CategoryId); } else { Entity.Category = db.Categories.Find(Entity.CategoryId); } Entity.CategoryId = Entity.Category.CategoryId; // Either Update or Insert product if (PageMode == PDSAPageModeEnum.Edit) { db.Entry(Entity).State = EntityState.Modified; db.SaveChanges(); } else if (PageMode == PDSAPageModeEnum.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); } catch (Exception ex) { LastException = ex; Message = "ERROR Saving Product"; } }
public void LoadCategories() { PTCData db = null; ResetException(); try { db = new PTCData(); // Load categories Categories.AddRange(db.Categories); } catch (Exception ex) { LastException = ex; Message = "ERROR Loading Categories"; } }
public Product Get(int productId) { PTCData db = null; ResetException(); try { db = new PTCData(); Entity = db.Products.Find(productId); } catch (Exception ex) { LastException = ex; Message = "ERROR Getting Product with ID: " + productId.ToString(); } return(Entity); }
public void Get() { PTCData db = null; ResetException(); try { db = new PTCData(); Products = db.Products.OrderBy(p => p.ProductName).ToList(); SetUIState(PDSAPageModeEnum.List); } catch (Exception ex) { LastException = ex; Message = "ERROR Loading Products"; } }
protected virtual void GetEntity() { PTCData db = null; try { db = new PTCData(); // Get the entity if (!string.IsNullOrEmpty(EventArgument)) { Entity = db.Products.Find(Convert.ToInt32(EventArgument)); } } catch (Exception ex) { Publish(ex, "Error Retrieving Product With ID=" + EventArgument); } }
public virtual void Delete() { PTCData db = null; try { db = new PTCData(); if (!string.IsNullOrEmpty(EventArgument)) { Entity = db.Products.Find(Convert.ToInt32(EventArgument)); db.Products.Remove(Entity); db.SaveChanges(); PageMode = PDSAPageModeEnum.List; } } catch (Exception ex) { Publish(ex, "Error Deleting Product With ID=" + Entity.ProductName); } }
public void Delete(int productId) { PTCData db = null; ResetException(); try { db = new PTCData(); Product product = db.Products.Find(productId); // Attempt to delete db.Products.Remove(product); db.SaveChanges(); // Reload all Products Get(); } catch (Exception ex) { LastException = ex; Message = "ERROR Deleting Product with ID: " + productId.ToString(); } }
protected void Update() { PTCData db = null; try { db = new PTCData(); // Do editing here db.Entry(Entity).State = EntityState.Modified; db.SaveChanges(); PageMode = PDSAPageModeEnum.List; } catch (DbEntityValidationException ex) { IsValid = false; ValidationErrorsToMessages(ex); } catch (Exception ex) { Publish(ex, "Error Updating Product With ID=" + Entity.ProductId.ToString()); } }
protected void Insert() { PTCData db = null; try { db = new PTCData(); // Do editing here db.Products.Add(Entity); db.SaveChanges(); PageMode = PDSAPageModeEnum.List; } catch (DbEntityValidationException ex) { IsValid = false; ValidationErrorsToMessages(ex); } catch (Exception ex) { Publish(ex, "Error Inserting New Product: '" + Entity.ProductName + "'"); } }