public static void SaveProductCategories(List <ProductCategory> productCategories) { try { using (var context = new WebshopEntities()) { context.ProductCategory.AddRange(productCategories); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static int Save(Product product) { try { using (var context = new WebshopEntities()) { context.Product.Add(product); context.SaveChanges(); return(product.Id); } } catch (Exception ex) { throw ex; } }
public static void DeleteProductCategoriesByProductId(int productId) { try { using (var context = new WebshopEntities()) { var productCategories = context.ProductCategory.Where(p => p.ProductId == productId).ToList(); context.ProductCategory.RemoveRange(productCategories); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static Product GetProductById(int id) { try { Product product; using (var context = new WebshopEntities()) { product = context.Product.Where(p => p.Id == id).FirstOrDefault(); } return(product); } catch (Exception ex) { throw ex; } }
public static List <Product> GetProducts() { try { List <Product> products; using (var context = new WebshopEntities()) { products = context.Product.ToList(); } return(products); } catch (Exception ex) { throw ex; } }
public static List <ProductCategory> GetCategoriesByProductId(int productId) { try { List <ProductCategory> productCategories; using (var context = new WebshopEntities()) { productCategories = context.ProductCategory.Where(p => p.ProductId == productId).ToList(); } return(productCategories); } catch (Exception ex) { throw ex; } }
public static List <Category> GetCategories() { try { List <Category> categories; using (var context = new WebshopEntities()) { categories = context.Category.ToList(); } return(categories); } catch (Exception ex) { throw ex; } }
public static void Delete(int id) { try { using (var context = new WebshopEntities()) { var dataProduct = context.Product.Where(p => p.Id == id).FirstOrDefault(); if (dataProduct != null) { context.Product.Remove(dataProduct); context.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static void Update(int id, Product product) { try { using (var context = new WebshopEntities()) { var dataProduct = context.Product.Where(p => p.Id == id).FirstOrDefault(); if (dataProduct != null) { dataProduct.Description = product.Description; dataProduct.Name = product.Name; dataProduct.UnitPrice = product.UnitPrice; dataProduct.UpdateDateTime = DateTime.Now; context.SaveChanges(); } } } catch (Exception ex) { throw ex; } }