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); } }