public BookingDetails GetBookingDetails(int bookId)
{
aConnection.Open();
string query = string.Format("SELECT * FROM t_booking_details WHERE id = {0}", bookId);
SqlCommand aCommand = new SqlCommand(query, aConnection);
SqlDataReader aReader = aCommand.ExecuteReader();
BookingDetails bookingDetails = new BookingDetails();
if (aReader.HasRows)
{
while (aReader.Read())
{
bookingDetails.Id = (int)aReader[0];
bookingDetails.Destination = aReader[1].ToString();
bookingDetails.Distance = Convert.ToDouble(aReader[2].ToString());
bookingDetails.Date = aReader[3].ToString();
bookingDetails.Time = aReader[4].ToString();
bookingDetails.VehicleId= Convert.ToInt32(aReader[5].ToString());
}
}
aConnection.Close();
return bookingDetails;
}
public BookingDetails GetBookingInformation(int regId, string date)
{
aConnection.Open();
string query = string.Format("SELECT * FROM t_booking_details WHERE vehicle_id = {0} AND date = '{1}'", regId, date);
SqlCommand aCommand = new SqlCommand(query, aConnection);
SqlDataReader aReader = aCommand.ExecuteReader();
aBookingDetails = new BookingDetails();
if (aReader.HasRows)
{
while (aReader.Read())
{
aBookingDetails.Destination = aReader[1].ToString();
aBookingDetails.Distance = Convert.ToDouble(aReader[2].ToString());
aBookingDetails.Date = aReader[3].ToString();
aBookingDetails.Time = aReader[4].ToString();
aBookingDetails.VehicleId = Convert.ToInt32(aReader[5].ToString());
}
}
aConnection.Close();
return aBookingDetails;
}