public IActionResult UserHome()
{
var user = authProvider.GetCurrentUser();
ReservationUserViewModel vm = new ReservationUserViewModel();
vm.User = userDAL.GetUser(user.Username);
vm.Pets = petDAO.GetAllPets(user.Id);
vm.Accepted = reservationDAO.GetAllAcceptedReservations(user.Id);
vm.Pending = reservationDAO.GetAllPendingReservations(user.Id);
vm.Declined = reservationDAO.GetAllDeclinedReservations(user.Id);
return(View(vm));
}
public IActionResult PendingReservation(int id)
{
ReservationUserViewModel vm = new ReservationUserViewModel();
var user = authProvider.GetCurrentUser();
vm.User = userDAL.GetUserById(user.Id);
// got to figure out the reservationid to pass over
vm.User = userDAL.GetUser(user.Username);
vm.Pets = petDAO.GetAllPets(user.Id);
vm.Reservation = reservationDAO.GetPendingReservation(user.Id, id);
return(View(vm));
}
public IActionResult Reservation()
{
if (!authProvider.IsLoggedIn)
{
return(RedirectToAction("Login", "Account"));
}
var user = authProvider.GetCurrentUser();
ReservationUserViewModel vm = new ReservationUserViewModel();
vm.User = userDAL.GetUser(user.Username);
vm.Reservations = reservationDAO.GetAllReservationsForUser(user.Id);
vm.Pets = petDAO.GetAllPets(user.Id);
return(View(vm));
}
public IActionResult Reservation(ReservationUserViewModel vm)
{
if (vm.InvitedUser.Username == null)
{
return(RedirectToAction("Reservation", "Reservation"));
}
var user = authProvider.GetCurrentUser();
vm.User = userDAL.GetUserById(user.Id);
vm.InvitedUser = userDAL.GetUser(vm.InvitedUser.Username);
vm.Reservation.StartTime = vm.Reservation.StartTime.AddHours(vm.StartHour);
vm.Reservation.StartTime = vm.Reservation.StartTime.AddMinutes(vm.StartMinute);
vm.Reservation.EndTime = vm.Reservation.EndTime.AddHours(vm.EndHour);
vm.Reservation.EndTime = vm.Reservation.EndTime.AddMinutes(vm.EndMinute);
reservationDAO.AddReservation(vm);
return(RedirectToAction("UserHome", "Account"));
}
public int AddReservation(ReservationUserViewModel reservation)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
string sql = @"
begin tran;
Declare @resId int;
Insert Into Reservations Values (@address, @startTime, @endTime, @petName, @description);
Select @resId = @@Identity;
Insert into users_reservations(userId, reservationId, status) values(@userId, @resId, 2);
Insert into users_reservations(userId, reservationId, status) values(@invitedUserId, @resId, 1);
commit tran;
Select @resId;
";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@address", reservation.Reservation.Address);
cmd.Parameters.AddWithValue("@startTime", reservation.Reservation.StartTime);
cmd.Parameters.AddWithValue("@endTime", reservation.Reservation.EndTime);
cmd.Parameters.AddWithValue("@petName", reservation.Reservation.PetName);
cmd.Parameters.AddWithValue("@userId", reservation.User.Id);
cmd.Parameters.AddWithValue("@description", reservation.Reservation.Description);
cmd.Parameters.AddWithValue("@invitedUserId", reservation.InvitedUser.Id);
int Id = Convert.ToInt32(cmd.ExecuteScalar());
return(Id);
}
}
catch (SqlException ex)
{
throw ex;
}
}