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