public Product Update(Product product)
{
using (Data.ECommerceContext eCommerceContext = new Data.ECommerceContext())
{
eCommerceContext.Products.Update(product);
}
return(product);
}
public IActionResult Update(int id)
{
Data.Models.Product product;
using (Data.ECommerceContext eCommerceContext = new Data.ECommerceContext())
{
product = eCommerceContext.Products.SingleOrDefault(a => a.Id == id);
}
return(View(product));
}
public T Update <T>(T model) where T : class
{
using (Data.ECommerceContext eCommerceContext = new Data.ECommerceContext())
{
eCommerceContext.Set <T>().Update(model);
eCommerceContext.SaveChanges();
}
return(model);
}
public void Delete(int productId)
{
using (Data.ECommerceContext eCommerceContext = new Data.ECommerceContext())
{
Product product = Find(productId);
eCommerceContext.Products.Remove(product);
eCommerceContext.SaveChanges();
}
}
public Product Insert(Product product)
{
using (Data.ECommerceContext eCommerceContext = new Data.ECommerceContext())
{
eCommerceContext.Products.Add(product);
eCommerceContext.SaveChanges();
}
return(product);
}
public IQueryable <T> Get <T>() where T : class
{
IQueryable <T> models;
using (Data.ECommerceContext eCommerceContext = new Data.ECommerceContext())
{
models = eCommerceContext.Set <T>();
}
return(models);
}
public T Find <T>(int id) where T : class
{
T contact;
using (Data.ECommerceContext eCommerceContext = new Data.ECommerceContext())
{
contact = eCommerceContext.Set <T>().Find(id);
}
return(contact);
}
public void Delete <T>(int id) where T : class
{
T model = Find <T>(id);
using (Data.ECommerceContext eCommerceContext = new Data.ECommerceContext())
{
eCommerceContext.Set <T>().Remove(model);
eCommerceContext.SaveChanges();
}
}
public Product Find(int productId)
{
Product product;
using (Data.ECommerceContext eCommerceContext = new Data.ECommerceContext())
{
product = eCommerceContext.Products.Find(productId);
}
return(product);
}
public IActionResult Index(int id)
{
Category category = new Category();
using (Data.ECommerceContext eCommerce = new Data.ECommerceContext())
{
category = eCommerce.Categories.SingleOrDefault(a => a.Id == id);
//select * from Categories where Id == 3
}
ViewData["Title"] = category.Name;
return(View(category));
}
public IQueryable <T> Get <T>() where T : class
{
//IQueryable<T> models;
//using(ECommerceContext eCommerceContext = new ECommerceContext())
//{
// models = eCommerceContext.Set<T>();
//}
//return models;
Data.ECommerceContext eCommerceContext = new Data.ECommerceContext();
return(eCommerceContext.Set <T>());
}
public void ProductUpdate(string json)
{
DTO.ProductUpdateDto productUpdate = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO.ProductUpdateDto>(json);
using (Data.ECommerceContext eCommerceContext = new Data.ECommerceContext())
{
Data.Models.Product product = eCommerceContext.Products.SingleOrDefault(a => a.Id == productUpdate.ProductId);
product.Description = productUpdate.ProductDescription;
product.Name = productUpdate.ProductName;
eCommerceContext.Products.Update(product);
eCommerceContext.SaveChanges();
}
}
