public bool DeleteShopping_Product(DBO.Shopping shopping, DBO.Product product)
{
DBO.Shopping_Product exists = GetShopping_ProductForShoppingAndProduct(shopping, product);
if (exists == null)
{
return(false);
}
DBO.DatabaseContext.getInstance().Shopping_Product.Remove(exists);
return(true);
}
public bool DeleteProductFromId(Guid id)
{
DBO.Product exists = GetProductFromId(id);
if (exists == null)
{
return(false);
}
DBO.DatabaseContext.getInstance().Products.Remove(exists);
DBO.DatabaseContext.getInstance().SaveChanges();
return(true);
}
public void CreateShopping_Product(DBO.Product product, DBO.Shopping shopping, int number)
{
DBO.Shopping_Product Shopping_Product = new DBO.Shopping_Product
{
id_shopping = shopping.id,
id_product = product.id,
number = number,
Product = product,
Shopping = shopping
};
DBO.DatabaseContext.getInstance().Shopping_Product.Add(Shopping_Product);
DBO.DatabaseContext.getInstance().SaveChanges();
}
public DBO.Product CreateProduct(String name, String description, float cost_without_margin, float cost_with_margin)
{
DBO.Product exists = GetProductFromName(name);
if (exists != null)
{
return(exists);
}
DBO.Product product = new DBO.Product
{
id = Guid.NewGuid(),
name = name,
description = description,
cost_without_margin = cost_without_margin,
cost_with_margin = cost_with_margin
};
DBO.DatabaseContext.getInstance().Products.Add(product);
DBO.DatabaseContext.getInstance().SaveChanges();
return(GetProductFromName(name));
}
public DBO.Shopping_Product GetShopping_ProductForShoppingAndProduct(DBO.Shopping shopping, DBO.Product product)
{
return(DBO.DatabaseContext.getInstance().Shopping_Product.FirstOrDefault(sp => shopping.id == sp.id_shopping && sp.id_product == product.id));
}
public DBO.Shopping_Product GetShopping_ProductForShoppingAndProduct(DBO.Shopping shopping, DBO.Product product)
{
return(shopping_product.GetShopping_ProductForShoppingAndProduct(shopping, product));
}
public bool DeleteShopping_Product(DBO.Shopping shopping, DBO.Product product)
{
return(shopping_product.DeleteShopping_Product(shopping, product));
}
public void CreateShopping_Product(DBO.Product product, DBO.Shopping shopping, int number)
{
shopping_product.CreateShopping_Product(product, shopping, number);
}
