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);
}
}
