public CancellationResponse CancelBooking(CancellationRequest request)
{
var response = new CancellationResponse();
try
{
using (var context = new SpartanHotelsEntities())
{
var userReservations =
context.Reservations.Where(
rs =>
(rs.ConfirmationNum.ToString() == request.ConfirmationNumber &&
rs.BookStatusID == (int)BookingStatus.Confirmed));
if (userReservations.Any())
{
foreach (var reservation in userReservations)
{
reservation.BookStatusID = (int)BookingStatus.Cancelled;
}
context.SaveChanges();
}
else
{
//return.. invalid input, confirmation doesnt exists
}
}
}
catch (Exception)
{
throw;
}
return(response);
}
public bool DeleteQueue(BookingRequest request)
{
using (var context = new SpartanHotelsEntities())
{
var queue = context.Queues.FirstOrDefault(q => (q.ReservationID == request.BookingId));
if (queue != null)
{
context.Queues.Remove(queue);
context.SaveChanges();
}
else
{
return(false);
//return.. invalid input, queue doesnt exists
}
}
return(true);
}
public bool AddQueue(BookingRequest request)
{
using (var context = new SpartanHotelsEntities())
{
if (!context.Queues.Any(q => (q.ReservationID == request.BookingId)))
{
var queue = new Queue {
ReservationID = request.BookingId, request = new byte[0], status = false
};
context.Queues.Add(queue);
context.SaveChanges();
}
else
{
return(false);
//return.. already exists
}
}
return(true);
}
private static Customer AddCustomer(string firstName, string lastName, string emailId)
{
var response = new Customer();
try
{
using (var context = new SpartanHotelsEntities())
{
var customer = context.Customers.FirstOrDefault(c => (c.Email == emailId));
if (customer == null)
{
var eCustomer = new Customer
{
FirstName = firstName,
LastName = lastName,
Email = emailId
};
context.Customers.Add(eCustomer);
context.SaveChanges();
customer = context.Customers.FirstOrDefault(c => (c.Email == emailId));
}
response.CustomerID = customer.CustomerID;
response.FirstName = customer.FirstName;
response.LastName = customer.LastName;
response.Email = customer.Email;
}
}
catch (Exception)
{
throw;
}
return(response);
}
private static Customer AddCustomer(string firstName, string lastName, string emailId)
{
var response = new Customer();
try
{
using (var context = new SpartanHotelsEntities())
{
var customer = context.Customers.FirstOrDefault(c => (c.Email == emailId));
if (customer == null)
{
var eCustomer = new Customer
{
FirstName = firstName,
LastName = lastName,
Email = emailId
};
context.Customers.Add(eCustomer);
context.SaveChanges();
customer = context.Customers.FirstOrDefault(c => (c.Email == emailId));
}
response.CustomerID = customer.CustomerID;
response.FirstName = customer.FirstName;
response.LastName = customer.LastName;
response.Email = customer.Email;
}
}
catch (Exception)
{
throw;
}
return response;
}
public bool DeleteQueue(BookingRequest request)
{
using (var context = new SpartanHotelsEntities())
{
var queue = context.Queues.FirstOrDefault(q => (q.ReservationID == request.BookingId));
if (queue != null)
{
context.Queues.Remove(queue);
context.SaveChanges();
}
else
{
return false;
//return.. invalid input, queue doesnt exists
}
}
return true;
}
public CancellationResponse CancelBooking(CancellationRequest request)
{
var response = new CancellationResponse();
try
{
using (var context = new SpartanHotelsEntities())
{
var userReservations =
context.Reservations.Where(
rs =>
(rs.ConfirmationNum.ToString() == request.ConfirmationNumber &&
rs.BookStatusID == (int) BookingStatus.Confirmed));
if (userReservations.Any())
{
foreach (var reservation in userReservations)
reservation.BookStatusID = (int) BookingStatus.Cancelled;
context.SaveChanges();
}
else
{
//return.. invalid input, confirmation doesnt exists
}
}
}
catch (Exception)
{
throw;
}
return response;
}
public BookingResponse AddBooking(BookingRequest request)
{
var response = new BookingResponse();
try
{
using (var context = new SpartanHotelsEntities())
{
var eHotel = (from hr in context.HotelRooms
join ht in context.Hotels on hr.HotelID equals ht.HotelID
where hr.HotelRoomID.ToString() == request.TravelDetails.HotelID
select new
{
hr.HotelID,
hr.HotelRoomID,
ht.HotelName,
ht.Locality,
ht.City
}).FirstOrDefault();
if (eHotel != null)
{
var availabilityResponse = GetAvailableRoomList(
new AvailabilityRequest
{
City = eHotel.City,
FromDate = request.TravelDetails.FromDate,
ToDate = request.TravelDetails.ToDate,
RequestedRoomCount = request.RequestedRooms.Count()
});
var available = false;
foreach (var rr in request.RequestedRooms)
{
if (
availabilityResponse.Rooms.FirstOrDefault(
ar => ar.Room.Title == rr.RequestedRoom.Title && ar.AvailableCount >= rr.RoomCount) !=
null)
{
available = true;
}
else
{
available = false;
break;
}
}
if (available)
{
var eCustomer = AddCustomer(request.Guest.FirstName, request.Guest.LastName,
request.Guest.EMailAddress);
var eReservation = new Reservation
{
BookingNum = request.BookingId,
HotelRoomID = Convert.ToInt32(request.TravelDetails.HotelID),
FromDate = request.TravelDetails.FromDate,
ToDate = request.TravelDetails.ToDate,
ConfirmationNum = context.Reservations.Max(c => c.ConfirmationNum) + 1,
CreatedBy = "",
CreatedDate = DateTime.Now,
ModifiedBy = "",
ModifiedDate = DateTime.Now,
CustomerID = eCustomer.CustomerID,
BookStatusID = (int) BookingStatus.Confirmed,
Remarks = ""
};
foreach (var rm in request.RequestedRooms)
{
eReservation.HotelRoomID = Convert.ToInt32(rm.RequestedRoom.Id);
context.Reservations.Add(eReservation);
}
context.SaveChanges();
response.ConfirmationNumber = eReservation.ConfirmationNum.ToString();
response.BookingStatus = (BookingStatus) eReservation.BookStatusID;
response.Guest = new Entities.Customer
{
EMailAddress = eCustomer.Email,
FirstName = eCustomer.FirstName,
LastName = eCustomer.LastName
};
}
}
}
}
catch (Exception)
{
throw;
}
return response;
}
public bool AddQueue(BookingRequest request)
{
using (var context = new SpartanHotelsEntities())
{
if (!context.Queues.Any(q => (q.ReservationID == request.BookingId)))
{
var queue = new Queue {ReservationID = request.BookingId, request = new byte[0], status = false};
context.Queues.Add(queue);
context.SaveChanges();
}
else
{
return false;
//return.. already exists
}
}
return true;
}
public BookingResponse AddBooking(BookingRequest request)
{
var response = new BookingResponse();
try
{
using (var context = new SpartanHotelsEntities())
{
var eHotel = (from hr in context.HotelRooms
join ht in context.Hotels on hr.HotelID equals ht.HotelID
where hr.HotelRoomID.ToString() == request.TravelDetails.HotelID
select new
{
hr.HotelID,
hr.HotelRoomID,
ht.HotelName,
ht.Locality,
ht.City
}).FirstOrDefault();
if (eHotel != null)
{
var availabilityResponse = GetAvailableRoomList(
new AvailabilityRequest
{
City = eHotel.City,
FromDate = request.TravelDetails.FromDate,
ToDate = request.TravelDetails.ToDate,
RequestedRoomCount = request.RequestedRooms.Count()
});
var available = false;
foreach (var rr in request.RequestedRooms)
{
if (
availabilityResponse.Rooms.FirstOrDefault(
ar => ar.Room.Title == rr.RequestedRoom.Title && ar.AvailableCount >= rr.RoomCount) !=
null)
{
available = true;
}
else
{
available = false;
break;
}
}
if (available)
{
var eCustomer = AddCustomer(request.Guest.FirstName, request.Guest.LastName,
request.Guest.EMailAddress);
var eReservation = new Reservation
{
BookingNum = request.BookingId,
HotelRoomID = Convert.ToInt32(request.TravelDetails.HotelID),
FromDate = request.TravelDetails.FromDate,
ToDate = request.TravelDetails.ToDate,
ConfirmationNum = context.Reservations.Max(c => c.ConfirmationNum) + 1,
CreatedBy = "",
CreatedDate = DateTime.Now,
ModifiedBy = "",
ModifiedDate = DateTime.Now,
CustomerID = eCustomer.CustomerID,
BookStatusID = (int)BookingStatus.Confirmed,
Remarks = ""
};
foreach (var rm in request.RequestedRooms)
{
eReservation.HotelRoomID = Convert.ToInt32(rm.RequestedRoom.Id);
context.Reservations.Add(eReservation);
}
context.SaveChanges();
response.ConfirmationNumber = eReservation.ConfirmationNum.ToString();
response.BookingStatus = (BookingStatus)eReservation.BookStatusID;
response.Guest = new Entities.Customer
{
EMailAddress = eCustomer.Email,
FirstName = eCustomer.FirstName,
LastName = eCustomer.LastName
};
}
}
}
}
catch (Exception)
{
throw;
}
return(response);
}
