public UserInformation GetUserInformation(string guId) { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); UserInformation info = (from x in db.UserInformations where x.GUID == guId select x).FirstOrDefault(); return(info); }
public void InsertUserInformation(UserInformation info) { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); db.UserInformations.Add(info); db.SaveChanges(); }
public string InsertTypesOfProductType(TypesOfProductType typesOfProductType) { try { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); db.TypesOfProductTypes.Add(typesOfProductType); db.SaveChanges(); return(typesOfProductType.Name + " uspješno je umetnuto"); } catch (Exception e) { return("Error" + e); } }
public string InsertProduct(Product product) { try { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); db.Products.Add(product); db.SaveChanges(); return(product.Name + " uspješno je umetnuto"); } catch (Exception e) { return("Error" + e); } }
public string InsertBasket(Basket basket) { try { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); db.Baskets.Add(basket); db.SaveChanges(); return(basket.DatePurchased + " uspješno je umetnuta"); } catch (Exception e) { return("Error" + e); } }
public Product GetProduct(int id) { try { using (Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities()) { Product product = db.Products.Find(id); return(product); } } catch { return(null); } }
public List <Product> GetAllProducts() { try { using (Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities()) { List <Product> products = (from x in db.Products select x).ToList(); return(products); } } catch { return(null); } }
public string UpdateTypesOfProductType(int id, TypesOfProductType typesOfProductType) { try { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); TypesOfProductType p = db.TypesOfProductTypes.Find(id); p.Name = typesOfProductType.Name; p.TypeID = typesOfProductType.TypeID; db.SaveChanges(); return(typesOfProductType.Name + "uspješno je ažurirano"); } catch (Exception e) { return("Error" + e); } }
public List <Product> GetAllProductsByType(int typeid) { try { using (Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities()) { List <Product> products = (from x in db.Products where x.Type2Id == typeid select x).ToList(); return(products); } } catch { return(null); } }
public string DeleteTypesOfProductType(int id) { try { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); TypesOfProductType typesOfProductType = db.TypesOfProductTypes.Find(id); db.TypesOfProductTypes.Attach(typesOfProductType); db.TypesOfProductTypes.Remove(typesOfProductType); db.SaveChanges(); return(typesOfProductType.Name + "uspješno je obrisano"); } catch (Exception e) { return("Error" + e); } }
public string DeleteProduct(int id) { try { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); Product product = db.Products.Find(id); db.Products.Attach(product); db.Products.Remove(product); db.SaveChanges(); return(product.Name + " uspješno je obrisano"); } catch (Exception e) { return("Error" + e); } }
public string DeleteBasket(int id) { try { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); Basket basket = db.Baskets.Find(id); db.Baskets.Attach(basket); db.Baskets.Remove(basket); db.SaveChanges(); return(basket.DatePurchased + "uspješno je obrisano"); } catch (Exception e) { return("Error" + e); } }
public string UpdateProduct(int id, Product product) { try { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); Product p = db.Products.Find(id); p.Name = product.Name; p.Image = product.Image; p.Price = product.Price; p.Type2Id = product.Type2Id; p.Description = product.Description; db.SaveChanges(); return(product.Name + " uspješno je ažurirano"); } catch (Exception e) { return("Error" + e); } }
public string UpdateBasket(int id, Basket basket) { try { Ukrainian_delicacyEntities db = new Ukrainian_delicacyEntities(); Basket p = db.Baskets.Find(id); p.DatePurchased = basket.DatePurchased; p.Amount = basket.Amount; p.ClientID = basket.ClientID; p.ProductID = basket.ProductID; p.IsInBasket = basket.IsInBasket; db.SaveChanges(); return(basket.DatePurchased + "uspješno je ažurirano"); } catch (Exception e) { return("Error" + e); } }