public static int GetUserIdByAuthId(int idAuth) { var context = new TableReadyContext(); var user = context.Users.Include(p => p.Authentication).SingleOrDefault(p => p.AuthenticationId == idAuth); return(user.UserId); }
public static int GetUserIdByOwnerId(int Id) { var context = new TableReadyContext(); var own = context.Owners.SingleOrDefault(ow => ow.OwnerId == Id); return(own.UserId); }
public static void CreateOwner(Owners owner) { var context = new TableReadyContext(); context.Owners.Add(owner); context.SaveChanges(); }
public static List <ReservationEntry> GetCheckinTodayReservationsByRestaurantID(int restId) { var context = new TableReadyContext(); var reservations = context.ReservationEntry.Include(r => r.Restaurant).Where(p => p.RestaurantId == restId && p.ReservationStatus == "confirmed" && p.ReservationDateTime.Date == DateTime.Today.Date && p.CheckinDateTime != null).ToList(); return(reservations); }
public static List <WaitlistEntry> GetWaitlistByRestaurantID(int restId) { var context = new TableReadyContext(); var waitlist = context.WaitlistEntry.Include(r => r.Restaurant).Where(p => p.RestaurantId == restId && (p.WaitlistStatus == "active")).ToList(); return(waitlist); }
public static RestaurantEmployees RestaurantByEmployeeId(int restId, int empId) { var context = new TableReadyContext(); var restaurant = context.RestaurantEmployees.Include(r => r.Restaurant).SingleOrDefault(p => p.EmployeeId == empId && p.RestaurantId == restId); return(restaurant); }
public static List <RestaurantOwners> GetRestauranOwnersByID(int restId) { var context = new TableReadyContext(); var restaurantOwners = context.RestaurantOwners.Include(j => j.Owner).Where(p => p.RestaurantId == restId).ToList(); return(restaurantOwners); }
public static void CreateUser(Users user) { var context = new TableReadyContext(); context.Users.Add(user); context.SaveChanges(); }
public static List <Users> GetAll() { var context = new TableReadyContext(); var users = context.Users.Include(p => p.Authentication).Include(p => p.Authentication.AuthenticationMatrix).ToList(); return(users); }
public static int GetAuthIdByUserId(int userId) { var context = new TableReadyContext(); var user = context.Users.SingleOrDefault(p => p.UserId == userId); return(user.AuthenticationId); }
public static int CreateAuthentication(Authentication auth) { var context = new TableReadyContext(); var authGroup = context.Authentication; var existAuth = authGroup.SingleOrDefault(p => p.Username == auth.Username); if (existAuth == null) { var maxAuthBefore = authGroup.SingleOrDefault(p => p.Id == authGroup.Max(k => k.Id)); context.Authentication.Add(auth); context.SaveChanges(); var maxAuthAfter = authGroup.SingleOrDefault(p => p.Id == authGroup.Max(k => k.Id)); if (maxAuthAfter.Id == maxAuthBefore.Id + 1) { return(maxAuthAfter.Id); } else { return(0); } } else { return(0); } }
public static AuthenticationMatrix GetAuthenticationMatrixByIDs(int restId, int authId) { var context = new TableReadyContext(); var authRestaurant = context.AuthenticationMatrix.SingleOrDefault(p => p.AuthenticationId == authId && p.RestaurantId == restId); return(authRestaurant); }
public static void AddEmployeeToAutheticationMatrix(AuthenticationMatrix authMatrix) { var context = new TableReadyContext(); context.AuthenticationMatrix.Add(authMatrix); context.SaveChanges(); }
public static Users GetUserByUserId(int userId) { var context = new TableReadyContext(); var user = context.Users.Include(p => p.Authentication).SingleOrDefault(p => p.UserId == userId); return(user); }
public static RestaurantOwners RestaurantByOwnerId(int restId, int ownId) { var context = new TableReadyContext(); var restaurant = context.RestaurantOwners.Include(r => r.Restaurant).Include(o => o.Owner).SingleOrDefault(p => p.OwnerId == ownId && p.RestaurantId == restId); return(restaurant); }
public static List <ReservationEntry> GetReservations(int restaurantId) { var context = new TableReadyContext(); var reservations = context.ReservationEntry.Where(p => p.RestaurantId == restaurantId).ToList(); return(reservations); }
public static List <RestaurantEmployees> RestaurantsByEmployeeId(int empId) { var context = new TableReadyContext(); var restaurants = context.RestaurantEmployees.Include(r => r.Restaurant).Include(e => e.Employee).Where(p => p.EmployeeId == empId).ToList(); return(restaurants); }
public static WaitlistEntry GetWaitlistById(int Id) { var context = new TableReadyContext(); var waitlist = context.WaitlistEntry.Include(r => r.Restaurant).SingleOrDefault(p => p.WaitlistEntryId == Id); return(waitlist); }
public static Restaurants GetRestauranByID(int restId) { var context = new TableReadyContext(); var restaurant = context.Restaurants.Include(r => r.RestaurantOwners).Include(p => p.RestaurantEmployees).SingleOrDefault(p => p.RestaurantId == restId); return(restaurant); }
public static ReservationEntry GetReservationById(int Id) { var context = new TableReadyContext(); var reservation = context.ReservationEntry.Include(r => r.Restaurant).SingleOrDefault(p => p.ReservationId == Id); return(reservation); }
public static List <RestaurantEmployees> GetRestauranEmployeesByID(int restId) { var context = new TableReadyContext(); var restaurantEmployees = context.RestaurantEmployees.Include(j => j.Employee).Where(p => p.RestaurantId == restId).ToList(); return(restaurantEmployees); }
public static void CreateWaitlist(WaitlistEntry waitlist) { var context = new TableReadyContext(); context.WaitlistEntry.Add(waitlist); context.SaveChanges(); }
public static List <ReservationEntry> GetReservationsByCustomerID(int custId) { var context = new TableReadyContext(); var reservations = context.ReservationEntry.Include(r => r.Restaurant).Where(p => p.CustomerId == custId).ToList(); return(reservations); }
public static void CreateReservation(ReservationEntry reservation) { var context = new TableReadyContext(); context.ReservationEntry.Add(reservation); context.SaveChanges(); }
public static List <ReservationEntry> GetManageReservations(int restId) { var context = new TableReadyContext(); var reservations = context.ReservationEntry.Include(r => r.Restaurant).Where(p => p.RestaurantId == restId && (p.ReservationStatus == "confirmed" || p.ReservationStatus == "on Hold")).ToList(); return(reservations); }
public static void AddOwnerToRestaurant(RestaurantOwners restaurantOwner) { var context = new TableReadyContext(); context.RestaurantOwners.Add(restaurantOwner); context.SaveChanges(); }
public static List <RestaurantOwners> GetAllRestaurantsByOwnerID(int ownId) { var context = new TableReadyContext(); var restaurants = context.RestaurantOwners.Include(r => r.Restaurant).Include(j => j.Owner).Where(p => p.OwnerId == ownId).ToList(); return(restaurants); }
public static void AddEmployeeToRestaurant(RestaurantEmployees restaurantEmployee) { var context = new TableReadyContext(); context.RestaurantEmployees.Add(restaurantEmployee); context.SaveChanges(); }
public static Owners GetOwnerByID(int ownerId) { var context = new TableReadyContext(); var owner = context.Owners.Include(p => p.User).Include(ro => ro.RestaurantOwners).SingleOrDefault(o => o.OwnerId == ownerId); return(owner); }
public static void CreateEmployee(Employees employee) { var context = new TableReadyContext(); context.Employees.Add(employee); context.SaveChanges(); }