public void ConfirmReservTables(int restId, int schemaId, List <int> tablesIds, DateTime date, ApplicationUser user, string name, string phone) { using (GoodTasteContext context = new GoodTasteContext()) { ApplicationUser u = null; if (user != null) { u = context.Users.Find(user.Id); } foreach (var tableId in tablesIds) { Table table = context.Tables.Find(tableId); TableReservation reserv = new TableReservation(); reserv.Table = table; reserv.User = u; reserv.ReservedAndConfirmed = true; reserv.ConfirmedByAdministration = true; reserv.Reserved = false; reserv.Date = date; reserv.ContactInfoName = name.Trim(); reserv.ContactInfoPhone = phone.Trim(); context.TableReservations.Add(reserv); } context.SaveChanges(); } }
public EventSearchViewModel GetListEventSearch() { using (GoodTasteContext context = new GoodTasteContext()) { try { List <RestaurantEvent> EventList = context.RestaurantEvent.Include(t => t.Restaurant) .Include(t => t.EventTypes).ToList(); List <EventType> EventTypes = context.EventTypes.Include(t => t.RestaurantEvents).OrderBy(t => t.Name).ToList(); List <SearchCategory <EventType> > EventTypesInfo = new List <SearchCategory <EventType> >(); for (int i = 0; i < EventTypes.Count; i++) { EventTypesInfo.Add(new SearchCategory <EventType>() { Category = EventTypes[i], IsSelected = false, Count = GetEventCountByType(EventTypes[i].Id) }); } EventSearchViewModel result = new Models.EventSearchViewModel(); result.Events = EventList; result.Types = EventTypesInfo; result.IsSelectedAnyCategory = false; return(result); } catch { throw new Exception("Events not found"); } } }
public double GetRestaurantRank(int?restId) { using (GoodTasteContext context = new GoodTasteContext()) { List <RestaurantReview> reviews = (from x in context.RestaurantReviews where x.Restaurant.Id == restId select x).ToList(); double rank = 0; int count = 0; for (int i = 0; i < reviews.Count; i++) { rank += reviews[i].Rank; if (reviews[i].Rank > 0) { count++; } } if (count == 0) { return(0); } return(Math.Round(rank / count, 1)); } }
public ApplicationUser GetUser(string id) { using (GoodTasteContext context = new GoodTasteContext()) { return((from x in context.Users where x.Id == id select x).FirstOrDefault()); } }
public void SignUp(ApplicationUser user) { try { string message; using (GoodTasteContext context = new GoodTasteContext()) { if (IsUserExist(context, user)) { message = "Such user is already exist!"; throw new Exception(message); } if (!IsInputDataCorrect(user)) { message = "User data isn't correct!"; throw new Exception(message); } else { context.Users.Add(user); context.SaveChanges(); } } } catch (Exception) { } }
public List <int> GetRestaurantsIDByCuisines(List <int> idEl) { using (GoodTasteContext context = new GoodTasteContext()) { try { List <int> id = new List <int>(); var rest = context.Cuisines.Include(t => t.Restaurants) .Where(x => idEl.Contains(x.Id)).Select(t => t.Restaurants).ToList(); for (int i = 0; i < rest.Count(); i++) { List <int> temp = new List <int>(); for (int j = 0; j < rest[i].ToList().Count(); j++) { temp.Add(rest[i].ToList()[j].Id); } if (id.Count > 0) { id = id.Intersect(temp).ToList(); } else { id = temp; } } return(id); } catch { throw new Exception("Restaurants not found"); } } }
public ApplicationUser LogIn(string email, string password) { try { string message; using (GoodTasteContext context = new GoodTasteContext()) { if (!IsUserExist(context, email, password)) { message = "Your email or password isn't correct!"; throw new Exception(message); } else { var user = context.Users.Where(u => u.Email == email) .SingleOrDefault(); return(user); } } } catch (Exception) { throw new Exception(); } }
public Restaurant GetRestaurant(int?id) { using (GoodTasteContext context = new GoodTasteContext()) { try { Restaurant result = context.Restaurants.Include(r => r.City).Include(r => r.Cuisines). Include(r => r.Likes).Include(r => r.Map).Include(r => r.Menu). Include(r => r.RestaurantEvent).Include(r => r.RestaurantFeatures).Include(r => r.RestaurantGroup). Include(r => r.RestaurantSchemas).Include(r => r.Reviews).Include(r => r.SpecialWorkHours). Include(r => r.WorkHours).Where(r => r.Id == id).FirstOrDefault(); result.City = context.Cities.Where(t => t.Id == result.City.Id).FirstOrDefault(); result.City.Country = context.Countries.Where(t => t.Id == result.City.Country.Id).FirstOrDefault(); result.Reviews = context.RestaurantReviews.Include(t => t.User).ToList(); result.RestaurantEvent = context.RestaurantEvent.Include(t => t.EventTypes).ToList(); result.Menu = context.Menus.Include(t => t.MealGroups.Select(m => m.Meals.Select(c => c.Currency))).ToList(); result.RestaurantSchemas = context.RestaurantSchemas.Include(t => t.Tables.Select(r => r.TableReservation.Select(u => u.User))).ToList(); result.Map = context.Maps.Where(x => x.id == result.Map.id).SingleOrDefault(); return(result); } catch (Exception ex) { throw new Exception(""); } } }
public void RemoveReserv(int?reservId) { using (GoodTasteContext context = new GoodTasteContext()) { context.TableReservations.Remove(context.TableReservations.Find(reservId)); context.SaveChanges(); } }
public int GetEventCountByType(int id) { using (GoodTasteContext context = new GoodTasteContext()) { var temp = context.RestaurantEvent.Include(t => t.EventTypes).Where(e => e.EventTypes.Select(x => x.Id).ToList().Contains(id)).ToList(); return(temp.Count >= 0 ? temp.Count : 0); } }
public List <RestaurantEvent> SearchEvents(string searchText, string CheckEl) { using (GoodTasteContext context = new GoodTasteContext()) { try { List <RestaurantEvent> result; if (CheckEl != null) { string[] el = CheckEl.Split(','); List <int> idEl = new List <int>(); for (int i = 0; i < el.Count(); i++) { idEl.Add(int.Parse(el[i].Trim())); } var re = GetEventTypes(idEl).Select(t => t.RestaurantEvents).ToList(); List <int> id = new List <int>(); for (int i = 0; i < re.Count(); i++) { for (int j = 0; j < re[i].ToList().Count(); j++) { id.Add(re[i].ToList()[j].Id); } } id = id.Distinct().ToList(); if (searchText == null) { result = context.RestaurantEvent.Include(t => t.Restaurant) .Include(t => t.EventTypes).Where(t => id.Contains(t.Id)).ToList(); } else { result = context.RestaurantEvent.Include(t => t.Restaurant) .Include(t => t.EventTypes).Where(t => id.Contains(t.Id)) .Where(t => t.Name.Contains(searchText)).ToList(); } } else if (searchText.Length > 0) { result = context.RestaurantEvent.Include(t => t.Restaurant) .Include(t => t.EventTypes).Where(t => t.Name.Contains(searchText)).ToList(); } else { result = context.RestaurantEvent.Include(t => t.Restaurant) .Include(t => t.EventTypes).ToList(); } return(result); } catch { throw new Exception("Events not found"); } } }
private List <RestaurantEvent> GetEventsByDate(DateTime from, DateTime to, GoodTasteContext context) { List <RestaurantEvent> EventList = context.RestaurantEvent.Include(t => t.Restaurant) .Include(t => t.EventTypes) .Where(t => t.StartDate >= from && t.StartDate <= to) .ToList(); return(EventList); }
private List <RestaurantEvent> GetEventsByName(string searchText, GoodTasteContext context) { List <RestaurantEvent> EventList = context.RestaurantEvent.Include(t => t.Restaurant) .Include(t => t.EventTypes) .Where(t => t.Name.Contains(searchText)) .ToList(); return(EventList); }
public string GetCurrectUserId() { using (GoodTasteContext context = new GoodTasteContext()) { //ApplicationUser currentUser = context.Users.FirstOrDefault(x => x.Id == HttpContext.Current.User.Identity.GetUserId()); ApplicationUser user = context.Users.FirstOrDefault(); return(user.Id); } }
public JsonResult GetSearchData(string term) { List <string> restaurantNames; using (GoodTasteContext context = new GoodTasteContext()) { restaurantNames = context.Restaurants.Where(r => r.Name.Contains(term)).Select(r => r.Name).ToList(); } return(Json(restaurantNames, JsonRequestBehavior.AllowGet)); }
public void RemoveReserv(List <TableReservation> reservs) { using (GoodTasteContext context = new GoodTasteContext()) { foreach (var item in reservs) { TableReservation remove = context.TableReservations.Find(item.Id); context.TableReservations.Remove(remove); } context.SaveChanges(); } }
public List <EventType> GetEventTypes(List <int> idEl) { using (GoodTasteContext context = new GoodTasteContext()) { List <EventType> EventTypes = new List <EventType>(); EventTypes = context.EventTypes.Include(t => t.RestaurantEvents) .Where(x => idEl.Contains(x.Id)).OrderBy(x => x.Name).ToList(); return(EventTypes); } }
private bool IsUserExist(GoodTasteContext context, ApplicationUser currentUser) { var usersQuery = context.Users; foreach (var user in usersQuery) { if (user.Email == currentUser.Email) { return(true); } } return(false); }
public void ConfirmReservByAdministration(int reservId) { using (GoodTasteContext context = new GoodTasteContext()) { var reserv = context.TableReservations.Find(reservId); if (reserv == null) { throw new ArgumentNullException(); } reserv.ConfirmedByAdministration = true; reserv.ReservedAndConfirmed = true; reserv.Reserved = false; context.SaveChanges(); } }
public List <int> GetRestaurantsIDByName(string name) { using (GoodTasteContext context = new GoodTasteContext()) { try { List <int> result = context.Restaurants.Where(r => r.Name.Contains(name)).Select(t => t.Id).ToList(); return(result); } catch { throw new Exception("Restaurants not found"); } } }
public List <Cuisine> GetAllCuisines() { using (GoodTasteContext context = new GoodTasteContext()) { try { List <Cuisine> result = context.Cuisines.OrderBy(x => x.Name).ToList(); return(result); } catch { throw new Exception("Cuisines not found"); } } }
public List <Neighborhood> GetAllNeighborhoods() { using (GoodTasteContext context = new GoodTasteContext()) { try { List <Neighborhood> result = context.Neighborhoods.Where(n => n.City.Id == 1).OrderBy(x => x.Name).ToList(); return(result); } catch { throw new Exception("Neighborhood features not found"); } } }
public List <MealGroup> GetAllMealGroups() { using (GoodTasteContext context = new GoodTasteContext()) { try { List <MealGroup> result = context.MealGroups.OrderBy(x => x.Name).ToList(); return(result); } catch { throw new Exception("Restaurant features not found"); } } }
public OrderFood GetOrderFood(int Id, int value) { using (GoodTasteContext context = new GoodTasteContext()) { try { OrderFood OF = new Models.OrderFood(); return(OF); } catch { throw new Exception("Order food not found"); } } }
public List <Table> GetListTables(List <int> ids) { using (GoodTasteContext context = new GoodTasteContext()) { try { List <Table> Tables = context.Tables.Where(t => ids.Contains(t.Id)).ToList(); return(Tables); } catch { throw new Exception("Tables not found"); } } }
private bool IsUserExist(GoodTasteContext context, string email, string password) { var usersQuery = context.Users; foreach (var user in usersQuery) { if (user.Email == email && user.PasswordHash == password) { return(true); } } return(false); }
public Menu GetRestMenu(int id) { using (GoodTasteContext context = new GoodTasteContext()) { try { Menu menu = context.Menus.Include(t => t.MealGroups.Select(m => m.Meals.Select(c => c.Currency))).Where(t => t.Restaurant.Id == id).FirstOrDefault(); return(menu); } catch { throw new Exception("Menu not found"); } } }
public ApplicationUser GetUserById(string id) { try { using (GoodTasteContext context = new GoodTasteContext()) { ApplicationUser user = context.Users.Where(d => d.Id == id).SingleOrDefault(); return(user); } } catch (Exception) { return(null); } }
public RestaurantShemaViewModel GetRestaurantViewModelSchema(int?id) { using (GoodTasteContext context = new GoodTasteContext()) { try { Restaurant Rest = context.Restaurants.Find(id); RestaurantSchema Schema = Rest.RestaurantSchemas.FirstOrDefault(); Schema = context.RestaurantSchemas.Include(t => t.Restaurant).FirstOrDefault(t => t.Id == id); Schema = context.RestaurantSchemas.Include(t => t.Tables).FirstOrDefault(); RestaurantShemaViewModel vmSchema = new RestaurantShemaViewModel(); vmSchema.Id = Schema.Id; vmSchema.Name = Schema.Name; vmSchema.RestaurantId = Convert.ToInt32(id); List <TableViewModel> vmTables = new List <TableViewModel>(); foreach (var table in Schema.Tables) { TableViewModel vmTable = new TableViewModel { Id = table.Id, X = table.X, Y = table.Y, Seats = table.Seats, ReservedAndConfirmed = false, Reserved = false }; foreach (var reserv in table.TableReservation) { if (reserv.Date.Date == DateTime.Now.Date && reserv.ReservedAndConfirmed == true) { vmTable.ReservedAndConfirmed = true; break; } else if (reserv.Date.Date == DateTime.Now.Date && reserv.Reserved == true) { vmTable.Reserved = true; break; } } vmTables.Add(vmTable); } vmSchema.Tables = vmTables; vmSchema.XLength = Schema.XLength; vmSchema.YLength = Schema.YLength; return(vmSchema); } catch { throw new Exception("Restaurant not found"); } } }
public List <RestaurantEvent> GetListRestaurantEvents() { using (GoodTasteContext context = new GoodTasteContext()) { try { List <RestaurantEvent> result = context.RestaurantEvent.Include(t => t.Restaurant) .Include(t => t.EventTypes).ToList(); return(result); } catch { throw new Exception("Events not found"); } } }