public int InsertBooking(Booking_Model booking)
{
Connection();
int count = 0;
SqlCommand cmd = new SqlCommand("uspInsertIntoBooking", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", booking.Email);
cmd.Parameters.AddWithValue("@RoomName", booking.RoomName);
cmd.Parameters.AddWithValue("@ArrivalDate", booking.ArrivalDate);
cmd.Parameters.AddWithValue("@DepartureDate", booking.DepartureDate);
cmd.Parameters.AddWithValue("@CardHolderName", booking.CardHolderName);
cmd.Parameters.AddWithValue("@CardType", booking.CardType);
cmd.Parameters.AddWithValue("@CardNumber", booking.CreditCardNumber);
cmd.Parameters.AddWithValue("@CardExpiry", booking.ExpiryDate);
cmd.Parameters.AddWithValue("@SecurityNumber", booking.SecurityNumber);
try
{
con.Open();
count = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
message = ex.Message;
}
finally
{
con.Close();
}
return(count);
}
public List <Booking_Model> ShowAll()//changed
{
Connection();
SqlDataReader reader;
List <Booking_Model> bookingList = new List <Booking_Model>();
SqlCommand cmd = new SqlCommand("uspShowAllBookings", con);
cmd.CommandType = CommandType.StoredProcedure;
try
{
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
Booking_Model booking = new Booking_Model();
booking.BookingId = int.Parse(reader["BookingID"].ToString());
booking.Email = reader["Email"].ToString();
booking.RoomName = reader["RoomName"].ToString();
booking.ArrivalDate = DateTime.Parse(reader["ArrivalDate"].ToString());
booking.DepartureDate = DateTime.Parse(reader["DepartureDate"].ToString());
booking.CardHolderName = reader["CardHolderName"].ToString();
booking.CardType = reader["CardType"].ToString();
booking.CreditCardNumber = reader["CardNumber"].ToString();
booking.ExpiryDate = DateTime.Parse(reader["CardExpiry"].ToString());
booking.SecurityNumber = int.Parse(reader["SecurityNumber"].ToString());
bookingList.Add(booking);
}
}
catch (Exception ex)
{
message = "Error " + ex.Message;
}
finally
{
con.Close();
}
return(bookingList);
}
