/// <summary>
/// Creator: Timothy Lickteig
/// Created: 04/27/2020
/// Approver: Zoey McDonald
///
/// Update appointment constructor
/// </summary>
/// <remarks>
/// Updater: N/A
/// Updated: N/A
/// Update: N/A
/// </remarks>
public frmScheduleFosterAppointment(FosterAppointmentVM appointment)
{
InitializeComponent();
populateVolunteerComboBox();
toEdit = appointment;
cboVolunteerList.SelectedItem = appointment.FirstName + " " + appointment.LastName;
txtStartTime.Text = appointment.StartTime.ToShortTimeString();
txtEndTime.Text = appointment.EndTime.ToShortTimeString();
txtDescription.Text = appointment.Description;
}
/// <summary>
/// Creator: Timothy Lickteig
/// Created: 04/27/2020
/// Approver: Zoey McDonald
///
/// method for selecting all foster appointments
/// </summary>
/// <remarks>
/// Updater: N/A
/// Updated: N/A
/// Update: N/A
/// </remarks>
/// <returns>The list of appointment records</returns>
public List <FosterAppointmentVM> SelectAllFosterAppointments()
{
//Declare variables
List <FosterAppointmentVM> appointments = new List <FosterAppointmentVM>();
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_select_foster_appointments");
//Setup cmd object
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
//Try to execute the query
try
{
conn.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
FosterAppointmentVM appt = new FosterAppointmentVM();
appt.VolunteerID = reader.GetInt32(0);
appt.FosterAppointmentID = reader.GetInt32(1);
TimeSpan startTime = reader.GetTimeSpan(2);
TimeSpan endTime = reader.GetTimeSpan(3);
appt.StartTime = new DateTime(2000, 1, 1, startTime.Hours, startTime.Minutes, startTime.Seconds);
appt.EndTime = new DateTime(2000, 1, 1, endTime.Hours, endTime.Minutes, endTime.Seconds);
appt.Description = reader.GetString(4);
appt.FirstName = reader.GetString(5);
appt.LastName = reader.GetString(6);
appointments.Add(appt);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(appointments);
}
