public static void AddPhoneOrder(string operatorName, string logoImages, string phoneNumber)
{
PizzaVikiCategoriesEntities pizzaVikiDB = new PizzaVikiCategoriesEntities();
pizzaVikiDB.PhoneOrders.AddObject(new PhoneOrder()
{
OperatorName = operatorName,
LogoImage = logoImages,
PhoneNumber = phoneNumber
});
}
public static CategoryViewStyle GetCategoryViewStyles(string categoryName)
{
PizzaVikiCategoriesEntities pizzaVikiDB = new PizzaVikiCategoriesEntities();
int categoryID = pizzaVikiDB.Categories.Single(x => x.Name.Equals(categoryName)).id;
CategoryViewStyle catViewStyle = pizzaVikiDB.CategoriesViewStyles.Single(x => x.CategoryID == categoryID);
return catViewStyle;
}
public static void AddCategory(string name, string backgroundImagePath, string link, string title)
{
PizzaVikiCategoriesEntities pizzaVikiDB = new PizzaVikiCategoriesEntities();
pizzaVikiDB.Categories.AddObject(new Category()
{
Name = name,
BackgroundImagePath = backgroundImagePath,
Link = link,
Title = title
});
pizzaVikiDB.SaveChanges();
}
public static List<Product> GetProductsByCategory(string categoryName)
{
PizzaVikiCategoriesEntities pizzaVikiDB = new PizzaVikiCategoriesEntities();
int categoryID = pizzaVikiDB.Categories.Single(x => x.Name.Equals(categoryName)).id;
var products =
from product in pizzaVikiDB.Products
where product.CategoryID == categoryID
select product;
return products.ToList();
}
public static void AddProduct(
string categoryName, string productName,
string backgroundImagePath, string ingredients,
string lowestPrice, string averagePrice,
string highestPrice, float? weight)
{
PizzaVikiCategoriesEntities pizzaVikiDB = new PizzaVikiCategoriesEntities();
int categoryID = pizzaVikiDB.Categories.Single(x => x.Name.Equals(categoryName)).id;
pizzaVikiDB.Products.AddObject(new Product()
{
CategoryID = categoryID,
Name = productName,
BackgroundImagePath = backgroundImagePath,
Ingredients = ingredients,
LowestPrice = lowestPrice,
AveragePrice = averagePrice,
HighestPrice = highestPrice,
Weight = weight,
});
pizzaVikiDB.SaveChanges();
}
public static List<Category> GetCategories()
{
PizzaVikiCategoriesEntities pizzaVikiDB = new PizzaVikiCategoriesEntities();
return pizzaVikiDB.Categories.ToList();
}
public static List<SubArea> GetSubAreas()
{
PizzaVikiCategoriesEntities pizzaVikiDB = new PizzaVikiCategoriesEntities();
return pizzaVikiDB.SubAreas.ToList();
}
public static List<PhoneOrder> GetPhoneOrders()
{
PizzaVikiCategoriesEntities pizzaVikiDB = new PizzaVikiCategoriesEntities();
return pizzaVikiDB.PhoneOrders.ToList();
}