public void delete(int id) { using (inventoryEntities db = new inventoryEntities()) { ProductViewModel product = new ProductViewModel(); var response = db.products.FirstOrDefault(r => r.IDProduct == id); db.products.Remove(response); db.SaveChanges(); } }
public IEnumerable <ListProductViewModels> GetListDate(System.DateTime dateInit, System.DateTime dateFinish) { using (inventoryEntities db = new inventoryEntities()) { IEnumerable <ListProductViewModels> lst = db.products.Where(n => n.Modified_date >= dateInit && n.Modified_date <= dateFinish).Select (n => new ListProductViewModels { IDProduct = n.IDProduct, Product = n.Product, Quantity = n.Quantity, Modified_date = n.Modified_date }).ToList(); return(lst); } }
public IEnumerable <ListProductViewModels> GetListQuantity(int quantity) { using (inventoryEntities db = new inventoryEntities()) { IEnumerable <ListProductViewModels> lst = db.products.Where(n => n.Quantity == quantity).Select (n => new ListProductViewModels { IDProduct = n.IDProduct, Product = n.Product, Quantity = n.Quantity, Modified_date = n.Modified_date }).ToList(); return(lst); } }
public IEnumerable <ListProductViewModels> GetListAll() { using (inventoryEntities db = new inventoryEntities()) { IEnumerable <ListProductViewModels> lst = (from d in db.products select new ListProductViewModels { IDProduct = d.IDProduct, Product = d.Product, Quantity = d.Quantity, Modified_date = d.Modified_date }).ToList(); return(lst); } }
public ProductViewModel update(int id) { using (inventoryEntities db = new inventoryEntities()) { ProductViewModel product = new ProductViewModel(); var response = db.products.FirstOrDefault(r => r.IDProduct == id); Console.WriteLine(id + ""); product.IDTable = response.IDTable; product.IDProduct = response.IDProduct; product.Product = response.Product; product.Quantity = response.Quantity; product.Modified_date = response.Modified_date; return(product); } }
private void NewProduct(ProductViewModel model) { ValidationContext context = new ValidationContext(model, null, null); IList <ValidationResult> errors = new List <ValidationResult>(); try { if (!Validator.TryValidateObject(model, context, errors, true)) { foreach (ValidationResult result in errors) { Console.WriteLine(result.ErrorMessage); } // MessageBox.Show(result.ErrorMessage); } else { using (inventoryEntities db = new inventoryEntities()) { products product = new products(); product.IDProduct = model.IDProduct; product.Product = model.Product; product.Quantity = model.Quantity; product.Modified_date = model.Modified_date; db.products.Add(product); db.SaveChanges(); } Console.WriteLine("guardado"); //MessageBox.Show("Validated"); } } catch (Exception ex) { Console.WriteLine(ex); } }
private void updateProduct(ProductViewModel model) { ValidationContext context = new ValidationContext(model, null, null); IList <ValidationResult> errors = new List <ValidationResult>(); try { if (!Validator.TryValidateObject(model, context, errors, true)) { foreach (ValidationResult result in errors) { Console.WriteLine(result.ErrorMessage); } // MessageBox.Show(result.ErrorMessage); } else { using (inventoryEntities db = new inventoryEntities()) { var product = db.products.FirstOrDefault(r => r.IDProduct == model.IDTable); product.IDProduct = model.IDProduct; product.Product = model.Product; product.Quantity = model.Quantity; product.Modified_date = model.Modified_date; db.Entry(product).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } Console.WriteLine("guardado"); //MessageBox.Show("Validated"); } } catch (Exception ex) { Console.WriteLine(ex); } }