public void AddItem(AddItemViewModel newProduct)
{
Product pr = new Product();
pr.Name = newProduct.Name;
pr.Description = newProduct.Description;
pr.Price = newProduct.Price;
try
{
db.Product.InsertOnSubmit(pr);
db.SubmitChanges();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
Product_in_Category pic = new Product_in_Category()
{
Product_id = pr.id,
Category_id = (from c in db.Category
where c.Name == newProduct.Category
select c.id).First()
};
try
{
db.ProductInCategory.InsertOnSubmit(pic);
db.SubmitChanges();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
public void SaveChanges(SellerPanelViewModel product)
{
try
{
Product productToChange = (from p in db.Product where product.id == p.id select p).First();
productToChange.Name = product.Name;
productToChange.Description = product.Description;
productToChange.Price = product.Price;
db.SubmitChanges();
Product_in_Category changecat = (from c in db.ProductInCategory
where product.id == c.Product_id
select c).First();
changecat.Category_id = (from cat in db.Category
where product.Category == cat.Name
select cat.id).First();
db.SubmitChanges();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
