/// <summary>
/// NAME: Austin Gee
/// DATE: 2/6/2020
/// CHECKED BY: Mohamed Elamin, 02/07/2020
///
/// This event handler is fired when a dgCustomer data grid selection is double clicked. It then loads
/// up the chosen customers profile window
/// </summary>
/// <remarks>
/// UPDATED BY: NA
/// UPDATE DATE: NA
/// WHAT WAS CHANGED: NA
///
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgCustomers_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
_adoptionCustomerVM = (AdoptionCustomerVM)dgCustomers.SelectedItem;
showCustomerProfile();
populateTextFields();
}
/// <summary>
/// NAME: Austin Gee
/// DATE: 2/6/2020
/// CHECKED BY: Mohamed Elamin, 02/07/2020
///
/// This method retrieves a list of AdoptionCustomerVMs from the database and returns it.
/// </summary>
/// <remarks>
/// UPDATED BY: NA
/// UPDATE DATE: NA
/// WHAT WAS CHANGED: NA
///
/// </remarks>
/// <param name="active"></param>
/// <returns></returns>
public List <AdoptionCustomerVM> SelectAdoptionCustomersByActive(bool active)
{
List <AdoptionCustomerVM> adoptionCustomers = new List <AdoptionCustomerVM>();
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_select_adoption_customers_by_active", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Active", active);
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
AdoptionCustomerVM adoptionCustomer = new AdoptionCustomerVM();
//adoptionCustomer.PUUserID = reader.GetInt32(0);
adoptionCustomer.FirstName = reader.GetString(0);
adoptionCustomer.LastName = reader.GetString(1);
adoptionCustomer.PhoneNumber = reader.IsDBNull(2) ? null : reader.GetString(2);
adoptionCustomer.Email = reader.GetString(3);
adoptionCustomer.Active = reader.GetBoolean(4);
adoptionCustomer.AddressLineOne = reader.GetString(5);
adoptionCustomer.AddressLineTwo = reader.IsDBNull(6) ? null : reader.GetString(6);
adoptionCustomer.City = reader.GetString(7);
adoptionCustomer.State = reader.GetString(8);
adoptionCustomer.ZipCode = reader.GetString(9);
//adoptionCustomer.CustomerID = reader.GetInt32(9);
//adoptionCustomer.AnimalID = reader.GetInt32(10);
//adoptionCustomer.CustomerAdoptionStatus = reader.GetString(11);
//adoptionCustomer.AdoptionApplicationRecievedDate = reader.GetDateTime(12);
//adoptionCustomer.AnimalName = reader.GetString(13);
//adoptionCustomer.AnimalBreed = reader.GetString(14);
//adoptionCustomer.AnimalArrivalDate = reader.GetDateTime(15);
//adoptionCustomer.CurrentlyHoused = reader.GetBoolean(16);
//adoptionCustomer.Adoptable = reader.GetBoolean(17);
//adoptionCustomer.AnimalActive = reader.GetBoolean(18);
//adoptionCustomer.AdoptionApplicationID = reader.GetInt32(19);
//adoptionCustomer.AnimalSpecies = reader.GetString(20);
adoptionCustomers.Add(adoptionCustomer);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(adoptionCustomers);
}
/// <summary>
/// NAME: Austin Gee
/// DATE: 5/1/2020
/// CHECKED BY: Michael Thompson
///
/// Chooses a customer
/// </summary>
/// <remarks>
/// UPDATED BY: NA
/// UPDATE DATE: NA
/// WHAT WAS CHANGED: NA
///
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnView_Click(object sender, RoutedEventArgs e)
{
if (null != dgCustomers.SelectedItem)
{
_adoptionCustomerVM = (AdoptionCustomerVM)dgCustomers.SelectedItem;
showCustomerProfile();
populateTextFields();
}
else
{
WPFErrorHandler.ErrorMessage("Please make a customer selection.");
}
}
/// <summary>
/// NAME: Austin Gee
/// DATE: 3/18/2020
/// CHECKED BY: Mohamed Elamin, 02/07/2020
///
/// This method retrieves an AdoptionCustomerVM from the database and returns it.
/// </summary>
/// <remarks>
/// UPDATED BY: NA
/// UPDATE DATE: NA
/// WHAT WAS CHANGED: NA
///
/// </remarks>
/// <param name="email"></param>
/// <returns></returns>
public AdoptionCustomerVM SelectAdoptionCustomerByEmail(string email)
{
var adoptionCustomer = new AdoptionCustomerVM();
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_select_customer_by_email", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", email);
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.Read())
{
adoptionCustomer.FirstName = reader.GetString(0);
adoptionCustomer.LastName = reader.GetString(1);
adoptionCustomer.PhoneNumber = reader.IsDBNull(2) ? null : reader.GetString(2);
adoptionCustomer.Email = reader.GetString(3);
adoptionCustomer.Active = reader.GetBoolean(4);
adoptionCustomer.AddressLineOne = reader.GetString(5);
adoptionCustomer.AddressLineTwo = reader.IsDBNull(6) ? null : reader.GetString(6);
adoptionCustomer.City = reader.GetString(7);
adoptionCustomer.State = reader.GetString(8);
adoptionCustomer.ZipCode = reader.GetString(9);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(adoptionCustomer);
}
/// <summary>
/// NAME: Austin Gee
/// DATE: 3/18/2020
/// CHECKED BY: Michael Thompson
///
/// allows user to schedule a new appointment
/// </summary>
/// <remarks>
/// UPDATED BY: NA
/// UPDATE DATE: NA
/// WHAT WAS CHANGED: NA
///
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnScheduleAppointment_Click(object sender, RoutedEventArgs e)
{
if (dgCustomers.SelectedItem != null)
{
AdoptionCustomerVM adoptionCustomer = (AdoptionCustomerVM)dgCustomers.SelectedItem;
_adoptionCustomerVM = _adoptionCustomerManager.RetrieveAdoptionCustomerByEmail(adoptionCustomer.Email);
lblFirstName.Content = _adoptionCustomerVM.FirstName;
lblLastName.Content = _adoptionCustomerVM.LastName;
lblEmail.Content = _adoptionCustomerVM.Email;
txtAppointmentTime.Text = "00h: 00m am/pm";
showAppointmentScheduling();
//dgLocations.Visibility = Visibility.Visible;
grdChooseLocation.Visibility = Visibility.Visible;
btnAddLocation.Visibility = Visibility.Visible;
btnLocationSearch.Visibility = Visibility.Visible;
btnSaveLocation.Visibility = Visibility.Hidden;
txtLocationSearch.Visibility = Visibility.Visible;
}
else
{
WPFErrorHandler.ErrorMessage("Please choose a customer from the list");
}
}
