public IEnumerable <SellerPanelViewModel> GetItems() { try { List <SellerPanelViewModel> products = new List <SellerPanelViewModel>(); IEnumerable <Product> pr = (from p in db.Product select p); foreach (Product p in pr) { SellerPanelViewModel sp = new SellerPanelViewModel() { id = p.id, Name = p.Name, Description = p.Description, Price = p.Price, Category = (from c in db.Category where (from pic in db.ProductInCategory where pic.Product_id == p.id select pic.Category_id).First() == c.id select c.Name).First() }; products.Add(sp); } return(products.AsEnumerable()); } catch (Exception ex) { logger.Error(ex.Message); return(null); } }
public SellerPanelViewModel GetItemById(int id) { try { Product product = (from p in db.Product where p.id == id select p).First(); SellerPanelViewModel pr = new SellerPanelViewModel() { id = product.id, Name = product.Name, Description = product.Description, Price = product.Price, Category = (from c in db.Category where (from pin in db.ProductInCategory where pin.Product_id == product.id select pin.Category_id).First() == c.id select c.Name).First() }; return(pr); } catch (Exception ex) { logger.Error(ex.Message); return(null); } }
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); } }