public static int AddGuestUser(Client u)
{
using (IceCreamEntities db = new IceCreamEntities())
{
return(AddUser(u));
}
}
public static Client ValidateUser(string email, string password)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var user = from u in db.Clients where u.email == email && u.password == password select u;
return(user.FirstOrDefault());
}
}
public static Client GetUser(int id)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var user = from u in db.Clients where u.clientId == id && u.password != "guestUser" select u;
return(user.FirstOrDefault());
}
}
public static List <OrderToProductTopping> GetOrderToProductToppings(int orderToProductId)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var toppings = db.GetToppingsForProductInOrderFun(orderToProductId);
return(toppings.ToList <OrderToProductTopping>());
}
}
public static List <Size> GetSizes(int catgId)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var sizes = db.GetSizesByCatgIdFun(catgId);
return(sizes.ToList <Size>());
}
}
public static List <Order> GetOrdersForUser(int userId)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var orders = db.GetOrdersForUserFun(userId);
return(orders.ToList <Order>());
}
}
public static List <DeliveriesType> GetDeliveryTypes()
{
using (IceCreamEntities db = new IceCreamEntities())
{
var types = db.GetDeliveryTypesFun();//stored Procedure
return(types.ToList <DeliveriesType>());
}
}
public static List <Category> GetCatgsToppingsForCatgProduct(int catgProductId)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var categories = db.GetCatgsToppingsForCatgProductFun(catgProductId);//storedProcedure
return(categories.ToList <Category>());
}
}
public static List <OrderToProduct> GetProductsInOrder(int orderId)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var products = db.GetProductsInOrderFun(orderId);
return(products.ToList <OrderToProduct>());
}
}
public static Category GetCategory(int id)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var category = db.GetCategoryFun(id);
return(category.FirstOrDefault());
}
}
public static Product GetProduct(int id)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var product = db.GetProductByIdFun(id);
return(product.FirstOrDefault());
}
}
public static List <Category> GetProductsCategories()
{
using (IceCreamEntities db = new IceCreamEntities())
{
var categories = db.GetProductsCategoriesFun();//stored Procedure
return(categories.ToList <Category>());
}
}
public static List <Product> GetProducts(int catgId)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var products = db.GetProductsByCatgIdFun(catgId);
return(products.ToList <Product>());
}
}
public static List <Topping> GetToppingsById(int catgId)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var toppings = db.GetToppingsByIdFun(catgId);
return(toppings.ToList <Topping>());
}
}
public static int AddUser(Client user)
{
using (IceCreamEntities db = new IceCreamEntities())
{
db.Clients.Add(user);
db.SaveChanges();
return(user.clientId);
}
}
public static bool addOrder(Order o)
{
using (IceCreamEntities db = new IceCreamEntities())
{
db.Orders.Add(o);
db.SaveChanges();
return(true);
}
return(false);
}
public static bool addOrderItem(OrderToProduct op)
{
using (IceCreamEntities db = new IceCreamEntities())
{
db.OrderToProducts.Add(op);
db.SaveChanges();
return(true);
}
return(false);
}
public static bool addToppingsToProductInOrder(OrderToProductTopping topping)
{
using (IceCreamEntities db = new IceCreamEntities())
{
db.OrderToProductToppings.Add(topping);
db.SaveChanges();
return(true);
}
return(false);
}
public static int Register(Client u)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var userForEmailCheck = (from c in db.Clients where c.email == u.email select c).FirstOrDefault <Client>();
if (userForEmailCheck == null)
{
return(AddUser(u));
}
}
return(0);
}
public static string GetPasswordByemail(string email)
{
using (IceCreamEntities db = new IceCreamEntities())
{
var user = from u in db.Clients where u.email == email && u.password != "guestUser" select u;
if (user.FirstOrDefault() != null)
{
return(user.FirstOrDefault().password);
}
else
{
return(null);
}
}
}
