public static void CreateEmployee(Employees employee)
{
var context = new TableReadyContext();
context.Employees.Add(employee);
context.SaveChanges();
}
public static void AddEmployeeToAutheticationMatrix(AuthenticationMatrix authMatrix)
{
var context = new TableReadyContext();
context.AuthenticationMatrix.Add(authMatrix);
context.SaveChanges();
}
public static void CreateCustomer(Customers customer)
{
var context = new TableReadyContext();
context.Customers.Add(customer);
context.SaveChanges();
}
public static void CreateWaitlist(WaitlistEntry waitlist)
{
var context = new TableReadyContext();
context.WaitlistEntry.Add(waitlist);
context.SaveChanges();
}
public static void CreateOwner(Owners owner)
{
var context = new TableReadyContext();
context.Owners.Add(owner);
context.SaveChanges();
}
public static void AddEmployeeToRestaurant(RestaurantEmployees restaurantEmployee)
{
var context = new TableReadyContext();
context.RestaurantEmployees.Add(restaurantEmployee);
context.SaveChanges();
}
public static void AddOwnerToRestaurant(RestaurantOwners restaurantOwner)
{
var context = new TableReadyContext();
context.RestaurantOwners.Add(restaurantOwner);
context.SaveChanges();
}
public static void CreateUser(Users user)
{
var context = new TableReadyContext();
context.Users.Add(user);
context.SaveChanges();
}
public static void CreateReservation(ReservationEntry reservation)
{
var context = new TableReadyContext();
context.ReservationEntry.Add(reservation);
context.SaveChanges();
}
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 void EditRestaurant(Restaurants restaurant)
{
var context = new TableReadyContext();
var originalRestaurant = context.Restaurants.SingleOrDefault(p => p.RestaurantId == restaurant.RestaurantId);
originalRestaurant.RestaurantName = restaurant.RestaurantName;
context.SaveChanges();
}
public static void CancelReservation(int id)
{
var context = new TableReadyContext();
var originalReservation = context.ReservationEntry.SingleOrDefault(p => p.ReservationId == id);
originalReservation.ReservationStatus = "cancelled";
context.SaveChanges();
}
public static void CancelPartySizeWaitlist(int id)
{
var context = new TableReadyContext();
var originalWaitlist = context.WaitlistEntry.SingleOrDefault(p => p.WaitlistEntryId == id);
originalWaitlist.WaitlistStatus = "cancelled";
context.SaveChanges();
}
public static void UpdatePartySizeWaitlist(WaitlistEntry waitlist)
{
var context = new TableReadyContext();
var originalWaitlist = context.WaitlistEntry.SingleOrDefault(p => p.WaitlistEntryId == waitlist.WaitlistEntryId);
originalWaitlist.PartySize = waitlist.PartySize;
context.SaveChanges();
}
public static void DeleteAuthMatrixByIds(int restId, int authId)
{
var context = new TableReadyContext();
var authorizationMatrix = context.AuthenticationMatrix.SingleOrDefault(p => p.AuthenticationId == authId && p.RestaurantId == restId);
context.AuthenticationMatrix.Remove(authorizationMatrix);
context.SaveChanges();
}
public static void UpdateAuthenticationMatrixByIDs(AuthenticationMatrix restAuth)
{
var context = new TableReadyContext();
var originalAuthRestaurant = context.AuthenticationMatrix.SingleOrDefault(p => p.AuthenticationId == restAuth.AuthenticationId && p.RestaurantId == restAuth.RestaurantId);
originalAuthRestaurant.Role = restAuth.Role;
context.SaveChanges();
}
public static void UpdateReservation(ReservationEntry reservation)
{
var context = new TableReadyContext();
var originalReservation = context.ReservationEntry.SingleOrDefault(re => re.ReservationId == reservation.ReservationId);
originalReservation.EntryOrigin = reservation.EntryOrigin;
originalReservation.PartySize = reservation.PartySize;
originalReservation.ReservationStatus = reservation.ReservationStatus;
context.SaveChanges();
}
public static void UpdateWaitlist(WaitlistEntry waitlist)
{
var context = new TableReadyContext();
var originalWaitlist = context.WaitlistEntry.SingleOrDefault(we => we.WaitlistEntryId == waitlist.WaitlistEntryId);
originalWaitlist.EntryOrigin = waitlist.EntryOrigin;
originalWaitlist.PartySize = waitlist.PartySize;
originalWaitlist.WaitlistStatus = waitlist.WaitlistStatus;
context.SaveChanges();
}
public static void UpdateWaitlist(WaitlistEntry waitEntry)
{
var context = new TableReadyContext();
var originalWailisttEntry = context.WaitlistEntry.SingleOrDefault(p => p.WaitlistEntryId == waitEntry.WaitlistEntryId);
originalWailisttEntry.PartySize = waitEntry.PartySize;
originalWailisttEntry.WaitlistStatus = waitEntry.WaitlistStatus;
originalWailisttEntry.EntryOrigin = waitEntry.EntryOrigin;
originalWailisttEntry.CheckinDate = waitEntry.CheckinDate;
context.SaveChanges();
}
public static void UpdateReservation(ReservationEntry reservation)
{
var context = new TableReadyContext();
var originalReservation = context.ReservationEntry.SingleOrDefault(p => p.ReservationId == reservation.ReservationId);
originalReservation.PartySize = reservation.PartySize;
originalReservation.ReservationDateTime = reservation.ReservationDateTime;
originalReservation.ReservationStatus = reservation.ReservationStatus;
originalReservation.CheckinDateTime = reservation.CheckinDateTime;
originalReservation.CustomerMessage = reservation.CustomerMessage;
context.SaveChanges();
}
public static void UpdateRestaurantEmployee(RestaurantEmployees restaurantEmployee)
{
var context = new TableReadyContext();
var originalRestaurantEmployee = context.RestaurantEmployees.SingleOrDefault(p => p.RestaurantId == restaurantEmployee.RestaurantId && p.EmployeeId == restaurantEmployee.EmployeeId);
originalRestaurantEmployee.NewRequestFlag = restaurantEmployee.NewRequestFlag;
originalRestaurantEmployee.RequestStatus = restaurantEmployee.RequestStatus;
originalRestaurantEmployee.StartDate = restaurantEmployee.StartDate;
originalRestaurantEmployee.EndDate = restaurantEmployee.EndDate;
originalRestaurantEmployee.Active = restaurantEmployee.Active;
originalRestaurantEmployee.Status = restaurantEmployee.Status;
context.SaveChanges();
}
public static void UpdateRestaurantOwner(RestaurantOwners restaurantOwner)
{
var context = new TableReadyContext();
var originalRestaurantOwner = context.RestaurantOwners.SingleOrDefault(p => p.RestaurantId == restaurantOwner.RestaurantId && p.OwnerId == restaurantOwner.OwnerId);
originalRestaurantOwner.Request = restaurantOwner.Request;
originalRestaurantOwner.RequestStatus = restaurantOwner.RequestStatus;
originalRestaurantOwner.StartDate = restaurantOwner.StartDate;
originalRestaurantOwner.EndDate = restaurantOwner.EndDate;
originalRestaurantOwner.Active = restaurantOwner.Active;
originalRestaurantOwner.Status = restaurantOwner.Status;
context.SaveChanges();
}
public static void UpdateUser(Users user)
{
var context = new TableReadyContext();
var originalUser = context.Users.SingleOrDefault(p => p.UserId == user.UserId);
originalUser.LastName = user.LastName;
originalUser.FirstName = user.FirstName;
originalUser.Email = user.Email;
originalUser.Country = user.Country;
originalUser.City = user.City;
originalUser.Province = user.Province;
originalUser.Phone = user.Phone;
originalUser.Address = user.Address;
context.SaveChanges();
}
public static bool UpdateAuthentication(Authentication auth)
{
var context = new TableReadyContext();
var authGroup = context.Authentication;
var existAuth = authGroup.SingleOrDefault(p => p.Username == auth.Username);
if (existAuth == null || existAuth.Id == auth.Id)
{
var originalAuth = authGroup.SingleOrDefault(p => p.Id == auth.Id);
originalAuth.Password = auth.Password;
originalAuth.Username = auth.Username;
context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public static int CreateRestaurant(Restaurants restaurant)
{
var context = new TableReadyContext();
var restGroup = context.Restaurants;
var maxRestBefore = restGroup.SingleOrDefault(p => p.RestaurantId == restGroup.Max(k => k.RestaurantId));
context.Restaurants.Add(restaurant);
context.SaveChanges();
var maxRestAfter = restGroup.SingleOrDefault(p => p.RestaurantId == restGroup.Max(k => k.RestaurantId));
if (maxRestAfter.RestaurantId == maxRestBefore.RestaurantId + 1)
{
return(maxRestAfter.RestaurantId);
}
else
{
return(0);
}
}