//calls uspRetrieveExistingBooking
public static List <BookingElement> RetrieveExistingBooking(string email, int bookingID)
{
if (String.IsNullOrEmpty(email) || bookingID == 0)
{
List <BookingElement> empty = new List <BookingElement>();
return(empty);
}
else
{
SqlConnection dbConnection = new SqlConnection(connectionString);
SqlCommand cmdRetrieveExistingBooking = new SqlCommand("uspRetrieveExistingBooking", dbConnection);
cmdRetrieveExistingBooking.CommandType = CommandType.StoredProcedure;
SqlParameter pCustomerEmail = new SqlParameter("@CustomerEmail", SqlDbType.VarChar, 50);
SqlParameter pBookingID = new SqlParameter("@BookingID", SqlDbType.Int);
cmdRetrieveExistingBooking.Parameters.Add(pBookingID);
cmdRetrieveExistingBooking.Parameters.Add(pCustomerEmail);
List <BookingElement> existingBooking = new List <BookingElement>();
try
{
dbConnection.Open();
pBookingID.Value = bookingID;
pCustomerEmail.Value = email;
SqlDataReader reader = cmdRetrieveExistingBooking.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
BookingElement b = new BookingElement();
b.ReservationDate = reader.GetDateTime(0);
b.BookingID = reader.GetInt32(1);
b.DateBookingCreated = reader.GetDateTime(2);
b.Paid = reader.GetString(3);
b.RoomID = reader.GetInt32(4);
b.NumberOfGuests = reader.GetInt32(5);
b.RoomRate = reader.GetDecimal(6);
b.BookingNotes = reader.GetString(7);
b.RoomName = reader.GetString(8);
b.CustomerName = reader.GetString(9);
b.CustomerCountry = reader.GetString(10);
b.CustomerEmail = reader.GetString(11);
b.CustomerPhone = reader.GetString(12);
existingBooking.Add(b);
}
}
}
catch (Exception)
{
throw;
}
finally
{
dbConnection.Close();
}
return(existingBooking);
}
}
public static List <BookingElement> CreateBookingElementsForUserSelectedDates(List <DateTime> dates, List <Room> currentRoomData)
{
List <Room> roomData = currentRoomData;
List <BookingElement> bookingElement = new List <BookingElement>();
foreach (Room r in roomData)
{
foreach (DateTime date in dates)
{
BookingElement b = new BookingElement();
b.UserDate = date.Date;
b.RoomID = r.RoomID;
b.MaxCapacity = r.MaxCapacity; //added for gridview drop down
bookingElement.Add(b);
}
}
return(bookingElement);
}