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); }