internal static void SaveClientAdditionalInformation(ClientAdditionalInformation additionalInfo, string fileID)
{
try
{
string query = string.Format(Constants.INSERT_CLIENT_EMPLOYER_DETAILS_QUERY, fileID, additionalInfo.Occupation, additionalInfo.Employer, additionalInfo.Address, additionalInfo.City, additionalInfo.State);
int result = DBHelper.ExecuteNonQuery(query);
query = string.Format(Constants.INSERT_CLIENT_SPOUSE_DETAILS_QUERY, fileID, additionalInfo.SpouseInfo.FirstName, additionalInfo.SpouseInfo.LastName, additionalInfo.SpouseInfo.Occupation, additionalInfo.SpouseInfo.Employer, additionalInfo.SpouseInfo.Address, additionalInfo.SpouseInfo.City, additionalInfo.SpouseInfo.State);
result = DBHelper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}
internal static void UpdateClientAdditionalInformation(ClientAdditionalInformation additionalInfo, string fileID)
{
try
{
string query = string.Format(Constants.EXISTS_CLIENT_EMPLOYER_DETAILS_QUERY, fileID);
object isPresent = DBHelper.GetScalarValue(query);
int result = 0;
if (isPresent == null)
{
query = string.Format(Constants.INSERT_CLIENT_EMPLOYER_DETAILS_QUERY, fileID, additionalInfo.Occupation, additionalInfo.Employer, additionalInfo.Address, additionalInfo.City, additionalInfo.State);
result = DBHelper.ExecuteNonQuery(query);
}
else
{
query = string.Format(Constants.UPDATE_CLIENT_EMPLOYER_DETAILS_QUERY, fileID, additionalInfo.Occupation, additionalInfo.Employer, additionalInfo.Address, additionalInfo.City, additionalInfo.State);
result = DBHelper.ExecuteNonQuery(query);
}
query = string.Format(Constants.EXISTS_CLIENT_SPOUSE_DETAILS_QUERY, fileID);
isPresent = DBHelper.GetScalarValue(query);
if (isPresent == null)
{
query = string.Format(Constants.INSERT_CLIENT_SPOUSE_DETAILS_QUERY, fileID, additionalInfo.SpouseInfo.FirstName, additionalInfo.SpouseInfo.LastName, additionalInfo.SpouseInfo.Occupation, additionalInfo.SpouseInfo.Employer, additionalInfo.SpouseInfo.Address, additionalInfo.SpouseInfo.City, additionalInfo.SpouseInfo.State);
result = DBHelper.ExecuteNonQuery(query);
}
else
{
query = string.Format(Constants.UPDATE_CLIENT_SPOUSE_DETAILS_QUERY, fileID, additionalInfo.SpouseInfo.FirstName, additionalInfo.SpouseInfo.LastName, additionalInfo.SpouseInfo.Occupation, additionalInfo.SpouseInfo.Employer, additionalInfo.SpouseInfo.Address, additionalInfo.SpouseInfo.City, additionalInfo.SpouseInfo.State);
result = DBHelper.ExecuteNonQuery(query);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void updateAdditionalClientInformation()
{
try
{
if (string.IsNullOrEmpty(txtClientOccupation.Text) &&
string.IsNullOrEmpty(txtEmployer.Text) &&
string.IsNullOrEmpty(txtClientEmployerAddress.Text) &&
string.IsNullOrEmpty(txtClientEmployerCity.Text) &&
string.IsNullOrEmpty(txtClientEmployerState.Text) &&
string.IsNullOrEmpty(txtClientSpousLastName.Text) &&
string.IsNullOrEmpty(txtClientSpousFirstName.Text) &&
string.IsNullOrEmpty(txtClientSpousOccupation.Text) &&
string.IsNullOrEmpty(txtSpouseEmployer.Text) &&
string.IsNullOrEmpty(txtClientSpouseEmployerAddress.Text) &&
string.IsNullOrEmpty(txtClientSpouseEmployerCity.Text) &&
string.IsNullOrEmpty(txtClientSpouseEmployerState.Text))
{
return;
}
ClientAdditionalInformation additionalInfo = new ClientAdditionalInformation();
additionalInfo.Occupation = txtClientOccupation.Text;
additionalInfo.Employer = txtEmployer.Text;
additionalInfo.Address = txtClientEmployerAddress.Text;
additionalInfo.City = txtClientEmployerCity.Text;
additionalInfo.State = txtClientEmployerState.Text;
additionalInfo.SpouseInfo = new SpouseInformation();
additionalInfo.SpouseInfo.LastName = txtClientSpousLastName.Text;
additionalInfo.SpouseInfo.FirstName = txtClientSpousFirstName.Text;
additionalInfo.SpouseInfo.Occupation = txtClientSpousOccupation.Text;
additionalInfo.SpouseInfo.Employer = txtSpouseEmployer.Text;
additionalInfo.SpouseInfo.Address = txtClientSpouseEmployerAddress.Text;
additionalInfo.SpouseInfo.City = txtClientSpouseEmployerCity.Text;
additionalInfo.SpouseInfo.State = txtClientSpouseEmployerState.Text;
BusinessLogic.UpdateClientAdditionalInformation(additionalInfo, txtFileNo.Text);
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
