public void InsertUserInformation(UserInformation info) { CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); db.UserInformations.Add(info); db.SaveChanges(); }
public UserInformation GetUserInformation(String guId) { CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); UserInformation info = (from x in db.UserInformations where x.GUID == guId select x).FirstOrDefault(); return(info); }
public string InsertProduct(Product product) { try{ CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); db.Products.Add(product); db.SaveChanges(); return product.Name + " was succesfully inserted"; }catch (Exception e){ return "Error: " + e; } }
public string InsertProduct(Product product) { try{ CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); db.Products.Add(product); db.SaveChanges(); return(product.Name + " was succesfully inserted"); }catch (Exception e) { return("Error: " + e); } }
public Product GetProduct(int id) { try { using (CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1()) { Product product = db.Products.Find(id); return(product); } } catch (Exception e) { return(null); } }
public Product GetProduct(int id) { try { using (CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1()) { Product product = db.Products.Find(id); return product; } } catch (Exception e) { return null; } }
public string DeleteProduct(int id) { try{ CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); Product product = db.Products.Find(id); db.Products.Attach(product); db.Products.Remove(product); db.SaveChanges(); return product.Name + " was succesfully deleted"; }catch (Exception e){ return "Error: " + e; } }
public string InsertCart(Cart cart) { try { CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); db.Carts.Add(cart); db.SaveChanges(); return cart.DatePurchased + " was succesfully inserted"; } catch (Exception e) { return "Error: " + e; } }
public string DeleteProduct(int id) { try{ CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); Product product = db.Products.Find(id); db.Products.Attach(product); db.Products.Remove(product); db.SaveChanges(); return(product.Name + " was succesfully deleted"); }catch (Exception e) { return("Error: " + e); } }
public string InsertCart(Cart cart) { try { CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); db.Carts.Add(cart); db.SaveChanges(); return(cart.DatePurchased + " was succesfully inserted"); } catch (Exception e) { return("Error: " + e); } }
public List <Product> GetAllProducts() { try { using (CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1()) { List <Product> products = (from x in db.Products select x).ToList(); return(products); } } catch (Exception e) { return(null); } }
public List<Product> GetAllProducts() { try { using (CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1()) { List<Product> products = (from x in db.Products select x).ToList(); return products; } } catch (Exception e) { return null; } }
public List <Product> GetProductByType(int typeId) { try { using (CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1()) { List <Product> products = (from x in db.Products where x.TypeId == typeId select x).ToList(); return(products); } } catch (Exception e) { return(null); } }
public List<Product> GetProductByType(int typeId) { try { using (CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1()) { List<Product> products = (from x in db.Products where x.TypeId == typeId select x).ToList(); return products; } } catch (Exception e) { return null; } }
public string DeleteCart(int id) { try { CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); Cart cart = db.Carts.Find(id); db.Carts.Attach(cart); db.Carts.Remove(cart); db.SaveChanges(); return cart.DatePurchased + " was succesfully deleted"; } catch (Exception e) { return "Error: " + e; } }
public string DeleteCart(int id) { try { CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); Cart cart = db.Carts.Find(id); db.Carts.Attach(cart); db.Carts.Remove(cart); db.SaveChanges(); return(cart.DatePurchased + " was succesfully deleted"); } catch (Exception e) { return("Error: " + e); } }
public string UpdateProductType(int id, ProductType productType) { try { CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); ProductType p = db.ProductTypes.Find(id); p.Name = productType.Name; db.SaveChanges(); return productType.Name + " was succesfully updated"; } catch (Exception e) { return "Error: " + e; } }
public string UpdateProduct(int id, Product product) { try{ CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); Product p = db.Products.Find(id); p.Name = product.Name; p.Price = product.Price; p.TypeId = product.TypeId; p.Description = product.Description; p.Image = product.Image; db.SaveChanges(); return(product.Name + " was succesfully updated"); }catch (Exception e) { return("Error: " + e); } }
public string UpdateProductType(int id, ProductType productType) { try { CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); ProductType p = db.ProductTypes.Find(id); p.Name = productType.Name; db.SaveChanges(); return(productType.Name + " was succesfully updated"); } catch (Exception e) { return("Error: " + e); } }
public string UpdateCart(int id, Cart cart) { try { CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); Cart p = db.Carts.Find(id); p.DatePurchased = cart.DatePurchased; p.ClientID = cart.ClientID; p.Amount = cart.Amount; p.IsInCart = cart.IsInCart; p.ProductID = cart.ProductID; db.SaveChanges(); return cart.DatePurchased + " was succesfully updated"; } catch (Exception e) { return "Error: " + e; } }
public string UpdateCart(int id, Cart cart) { try { CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); Cart p = db.Carts.Find(id); p.DatePurchased = cart.DatePurchased; p.ClientID = cart.ClientID; p.Amount = cart.Amount; p.IsInCart = cart.IsInCart; p.ProductID = cart.ProductID; db.SaveChanges(); return(cart.DatePurchased + " was succesfully updated"); } catch (Exception e) { return("Error: " + e); } }
public string UpdateProduct(int id, Product product) { try{ CANDZOILPDBEntities1 db = new CANDZOILPDBEntities1(); Product p = db.Products.Find(id); p.Name = product.Name; p.Price = product.Price; p.TypeId = product.TypeId; p.Description = product.Description; p.Image = product.Image; db.SaveChanges(); return product.Name + " was succesfully updated"; }catch (Exception e){ return "Error: " + e; } }