public List <BookingAppointmentDetailsResponse> bookingAppointmentDetails() { BookingAppointmentResponseModel responseModel = new BookingAppointmentResponseModel(); List <BookingAppointmentDetailsResponse> bookingAppointmentDetails = new List <BookingAppointmentDetailsResponse>(); using (MySqlConnection sqlConnection = new MySqlConnection(connectstring)) { using (MySqlCommand mySqlCommand = sqlConnection.CreateCommand()) { try { mySqlCommand.CommandText = "SELECT *FROM tbl_book_appoinment WHERE fld_confirm=1 AND fld_booked_status=1"; mySqlCommand.CommandType = System.Data.CommandType.Text; mySqlCommand.Connection = sqlConnection; sqlConnection.Open(); using (MySqlDataReader reader = mySqlCommand.ExecuteReader()) { while (reader.Read()) { bookingAppointmentDetails.Add(new BookingAppointmentDetailsResponse { booking_ID = reader.GetString(reader.GetOrdinal("fld_id")), customer_ID = reader.GetString(reader.GetOrdinal("fld_customer_id")), provider_ID = reader.GetString(reader.GetOrdinal("fld_provider_id")), booking_status = reader.GetString(reader.GetOrdinal("fld_booked_status")), call_duration = reader.GetString(reader.GetOrdinal("fld_call_duration")), booking_Datetime = reader.GetString(reader.GetOrdinal("fld_datetime")), custmer_message = reader.GetString(reader.GetOrdinal("fld_customer_message")), appointment_type = reader.GetString(reader.GetOrdinal("fld_appointment_type")), appointment_confirm_status = reader.GetString(reader.GetOrdinal("fld_confirm")), appointment_archive = reader.GetString(reader.GetOrdinal("fld_archive")), provider_archive = reader.GetString(reader.GetOrdinal("fld_provider_archive")), room_in = reader.GetString(reader.GetOrdinal("fld_room_in")), app_time_slot = reader.GetString(reader.GetOrdinal("fld_app_time_slot")), random_id = reader.GetString(reader.GetOrdinal("fld_random_id")), }); } } } catch (Exception e) { responseModel.Messaage = e.Message.ToString(); } } } return(bookingAppointmentDetails); }
public BookingAppointmentResponseModel bookingAppointment() { BookingAppointmentResponseModel responseModel = new BookingAppointmentResponseModel(); List <BookingAppointmentDetailsResponse> bookingAppointmentDetails = new List <BookingAppointmentDetailsResponse>(); BookingRepository bookingRepository = new BookingRepository(); responseModel.bookingAppointmentDetails = bookingRepository.bookingAppointmentDetails(); bookingAppointmentDetails = bookingRepository.bookingAppointmentDetails(); if (bookingAppointmentDetails.Count <= 0) { responseModel.Messaage = "No data found"; responseModel.responseCode = "200"; } else { responseModel.Messaage = "Appointment Details"; responseModel.responseCode = "200"; } return(responseModel); }