public frmSelectGuestForAppointment(AppointmentGuestViewModel agvm, IAppointmentManager apptMrg)
{
_agvm = agvm;
_apptMrg = apptMrg;
try
{
_guestViewModels = _apptMrg.RetrieveGuestList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
InitializeComponent();
}
/// <summary>
/// Wes Richardson
/// Created: 2019/03/07
///
/// Retrieves a list of guestsID,
/// </summary>
public List <AppointmentGuestViewModel> SelectGuestList()
{
List <AppointmentGuestViewModel> appointmentGuestViewModelList = null;
var conn = DBConnection.GetDbConnection();
var cmdText = @"sp_select_appointment_guest_view_list";
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
appointmentGuestViewModelList = new List <AppointmentGuestViewModel>();
while (reader.Read())
{
var agvm = new AppointmentGuestViewModel()
{
GuestID = reader.GetInt32(0),
FirstName = reader.GetString(1),
LastName = reader.GetString(2),
Email = reader.GetString(3)
};
appointmentGuestViewModelList.Add(agvm);
}
}
else
{
throw new ApplicationException("Guest List data not found");
}
}
catch (Exception ex)
{
throw new ApplicationException("Database access error", ex);
}
finally
{
conn.Close();
}
return(appointmentGuestViewModelList);
}
public frmAddEditViewAppointment()
{
_appMgr = new AppointmentManager();
_guest = new AppointmentGuestViewModel()
{
GuestID = 0,
FirstName = "",
LastName = "",
Email = ""
};
_appointmentTypes = _appMgr.RetrieveAppointmentTypes();
_appointmentTypeIDs = new List <string>();
getAppointmentTypeIDs();
_appointment = new Appointment();
_mode = EditMode.Add;
InitializeComponent();
}
private void BuildGuestList()
{
AppointmentGuestViewModel apgm1 = new AppointmentGuestViewModel()
{
GuestID = 100000,
FirstName = "John",
LastName = "Doe",
Email = "*****@*****.**"
};
_testGuestViewModels.Add(apgm1);
AppointmentGuestViewModel apgm2 = new AppointmentGuestViewModel()
{
GuestID = 100001,
FirstName = "Jane",
LastName = "Doe",
Email = "*****@*****.**"
};
_testGuestViewModels.Add(apgm2);
}
