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