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