public bool ContainsIt(object value)
{
try
{
ClientFileInformation currentRow = value as ClientFileInformation;
if (dgClientFileList.Columns.Count > 1)
{
//There is more than 1 column in DataGrid
//FileInformation currentRow = value as FileInformation;
if (currentRow != null)
{
if (currentRow.FirstName.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.LastName.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.FileID.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()))
{
return(true);
}
}
}
else
{
if (currentRow.FirstName.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.LastName.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.FileID.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()))
{
return(true);
}
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
return(false);
}
private void dgClientFileList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
ClientFileInformation selectedClient = dgClientFileList.SelectedItem as ClientFileInformation;
if (selectedClient == null)
{
return;
}
ShowClientGeneralInformation(selectedClient);
ShowClientTransactionInformation(selectedClient);
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void btnDeleteClient_Click(object sender, RoutedEventArgs e)
{
try
{
ClientFileInformation selectedClient = dgClientFileList.SelectedItem as ClientFileInformation;
if (selectedClient == null)
{
return;
}
bool result = BusinessLogic.DeleteClient(selectedClient.FileID);
Helper.ShowInformationMessageBox("Selected Client Deleted");
RefreshClientFileList();
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowClientTransactionInformation(ClientFileInformation selectedClient)
{
try
{
var result = BusinessLogic.GetAllTransactionDetails(string.Format(Constants.CLIENT_TRANSACTION_DETAILS_QUERY, selectedClient.FileID));
dgTransactionDetails.ItemsSource = result;
m_TransactionListForSearch = new ListCollectionView(result);
if (dgTransactionDetails.Items.Count > 0)
{
dgTransactionDetails.SelectedIndex = 0;
}
else
{
ClearControlValues();
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
try
{
cmbActivityFilter.SelectedIndex = 0;
FillClientFileList(Constants.ACTIVE_CLIENT_NAME_FILE_ID_QUERY);
if (dgClientFileList.Items.Count > 0)
{
if (string.IsNullOrEmpty(SelectedFileNumber))
{
dgClientFileList.SelectedIndex = 0;
}
else
{
ClientFileInformation item = null;
bool isFileIDFound = false;
int index = 0;
for (index = 0; index < dgClientFileList.Items.Count; index++)
{
item = dgClientFileList.Items[index] as ClientFileInformation;
if (item.FileID.Equals(SelectedFileNumber))
{
isFileIDFound = true;
break;
}
}
dgClientFileList.SelectedIndex = isFileIDFound ? index : 0;
}
}
UpdateStatusGeneralSection(true);
UpdatestatusTransactionDetail(true);
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowClientTransactionInformation(ClientFileInformation selectedClient)
{
try
{
var result = BusinessLogic.GetAllTransactionDetails(string.Format(Constants.CLIENT_TRANSACTION_DETAILS_QUERY, selectedClient.FileID));
dgTransactionDetails.ItemsSource = result;
m_TransactionListForSearch = new ListCollectionView(result);
if (dgTransactionDetails.Items.Count > 0)
{
dgTransactionDetails.SelectedIndex = 0;
}
else
{
ClearControlValues();
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowClientGeneralInformation(ClientFileInformation selectedClient)
{
try
{
var result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_BASIC_DETAILS_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
return;
}
else
{
txtFileNo.Text = selectedClient.FileID;
txtLastName.Text = selectedClient.LastName;
txtFirstName.Text = selectedClient.FirstName;
cmbCaseType.ItemsSource = null;
//cmbCaseType.Items.Clear();
//cmbCaseType.Items.Add(result.Tables[0].Rows[0][Constants.CASE_TYPE_COLUMN].ToString());
DataTable table = new DataTable();
table.Columns.Add("CaseType");
table.Rows.Add(result.Tables[0].Rows[0][Constants.CASE_TYPE_COLUMN].ToString());
cmbCaseType.DisplayMemberPath = "CaseType";
cmbCaseType.SelectedValuePath = "CaseType";
cmbCaseType.ItemsSource = table.DefaultView;
cmbCaseType.SelectedIndex = 0;
cmbCaseStatus.ItemsSource = null;
DataTable caseStatusTable = new DataTable();
caseStatusTable.Columns.Add("CaseStatus");
caseStatusTable.Rows.Add(result.Tables[0].Rows[0][Constants.CASE_STATUS_COLUMN].ToString());
cmbCaseStatus.DisplayMemberPath = "CaseStatus";
cmbCaseStatus.SelectedValuePath = "CaseStatus";
cmbCaseStatus.ItemsSource = caseStatusTable.DefaultView;
cmbCaseStatus.SelectedIndex = 0;
dtAccidentDate.SelectedDate = DateTime.Parse(result.Tables[0].Rows[0][Constants.ACCIDENT_DATE_COLUMN].ToString());
}
//Client General Address information
result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_BASIC_ADDRESS_DETAILS_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtAddress.Text = string.Empty;
txtCity.Text = string.Empty;
txtState.Text = string.Empty;
txtHomePhone.Text = string.Empty;
txtCellPhone.Text = string.Empty;
txtDrivingLicense.Text = string.Empty;
dtDateOfBirth.SelectedDate = DateTime.Now;
txtSSN.Text = string.Empty;
}
else
{
txtAddress.Text = result.Tables[0].Rows[0][Constants.CLIENT_ADDRESS_COLUMN].ToString();
txtCity.Text = result.Tables[0].Rows[0][Constants.CLIENT_CITY_COLUMN].ToString();
txtState.Text = result.Tables[0].Rows[0][Constants.CLIENT_STATE_COLUMN].ToString();
txtHomePhone.Text = result.Tables[0].Rows[0][Constants.CLIENT_HOMEPHONE_COLUMN].ToString();
txtCellPhone.Text = result.Tables[0].Rows[0][Constants.CLIENT_CELLPHONE_COLUMN].ToString();
txtDrivingLicense.Text = result.Tables[0].Rows[0][Constants.CLIENT_LICENSENUMBER_COLUMN].ToString();
dtDateOfBirth.SelectedDate = DateTime.Parse(result.Tables[0].Rows[0][Constants.CLIENT_DATEOFBIRTH_COLUMN].ToString());
txtSSN.Text = result.Tables[0].Rows[0][Constants.CLIENT_SSN_COLUMN].ToString();
}
//Client General Case Information
result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_BASIC_INSURANCE_DETAILS_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
//TODO: check what to do here
txtInitialCaseInformation.Text = string.Empty;
txtDefendantName.Text = string.Empty;
txtOriginatingAttorney.Text = string.Empty;
txtAssignedAttorney.Text = string.Empty;
txtRefferal.Text = string.Empty;
}
else
{
txtInitialCaseInformation.Text = result.Tables[0].Rows[0][Constants.CLIENT_INITIALINFORMATION_COLUMN].ToString();
txtDefendantName.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANTNAME_COLUMN].ToString();
txtOriginatingAttorney.Text = result.Tables[0].Rows[0][Constants.CLIENT_ORIGINATINGATTORNY_COLUMN].ToString();
txtAssignedAttorney.Text = result.Tables[0].Rows[0][Constants.CLIENT_ASSIGNEDATTORNY_COLUMN].ToString();
txtRefferal.Text = result.Tables[0].Rows[0][Constants.CLIENT_REFERRAL_COLUMN].ToString();
}
//Client General Case Evidence Information
result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_BASIC_EVIDENCE_DETAILS_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtEvidence1.Text = string.Empty;
txtEvidence2.Text = string.Empty;
}
else
{
if (result.Tables[0].Rows.Count == 1)
{
txtEvidence1.Text = result.Tables[0].Rows[0][Constants.CLIENT_EVIDENCE_COLUMN].ToString();
txtEvidence2.Text = string.Empty;
}
else if (result.Tables[0].Rows.Count >= 2)
{
txtEvidence1.Text = result.Tables[0].Rows[0][Constants.CLIENT_EVIDENCE_COLUMN].ToString();
txtEvidence2.Text = result.Tables[0].Rows[1][Constants.CLIENT_EVIDENCE_COLUMN].ToString();
}
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowClientGeneralInformation(ClientFileInformation selectedClient)
{
try
{
var result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_BASIC_DETAILS_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
return;
}
else
{
txtFileNo.Text = selectedClient.FileID;
txtLastName.Text = selectedClient.LastName;
txtFirstName.Text = selectedClient.FirstName;
cmbCaseType.ItemsSource = null;
//cmbCaseType.Items.Clear();
//cmbCaseType.Items.Add(result.Tables[0].Rows[0][Constants.CASE_TYPE_COLUMN].ToString());
DataTable table = new DataTable();
table.Columns.Add("CaseType");
table.Rows.Add(result.Tables[0].Rows[0][Constants.CASE_TYPE_COLUMN].ToString());
cmbCaseType.DisplayMemberPath = "CaseType";
cmbCaseType.SelectedValuePath = "CaseType";
cmbCaseType.ItemsSource = table.DefaultView;
cmbCaseType.SelectedIndex = 0;
cmbCaseStatus.ItemsSource = null;
DataTable caseStatusTable = new DataTable();
caseStatusTable.Columns.Add("CaseStatus");
caseStatusTable.Rows.Add(result.Tables[0].Rows[0][Constants.CASE_STATUS_COLUMN].ToString());
cmbCaseStatus.DisplayMemberPath = "CaseStatus";
cmbCaseStatus.SelectedValuePath = "CaseStatus";
cmbCaseStatus.ItemsSource = caseStatusTable.DefaultView;
cmbCaseStatus.SelectedIndex = 0;
dtAccidentDate.SelectedDate = DateTime.Parse(result.Tables[0].Rows[0][Constants.ACCIDENT_DATE_COLUMN].ToString());
}
//Client General Address information
result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_BASIC_ADDRESS_DETAILS_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtAddress.Text = string.Empty;
txtCity.Text = string.Empty;
txtState.Text = string.Empty;
txtHomePhone.Text = string.Empty;
txtCellPhone.Text = string.Empty;
txtDrivingLicense.Text = string.Empty;
dtDateOfBirth.SelectedDate = DateTime.Now;
txtSSN.Text = string.Empty;
}
else
{
txtAddress.Text = result.Tables[0].Rows[0][Constants.CLIENT_ADDRESS_COLUMN].ToString();
txtCity.Text = result.Tables[0].Rows[0][Constants.CLIENT_CITY_COLUMN].ToString();
txtState.Text = result.Tables[0].Rows[0][Constants.CLIENT_STATE_COLUMN].ToString();
txtHomePhone.Text = result.Tables[0].Rows[0][Constants.CLIENT_HOMEPHONE_COLUMN].ToString();
txtCellPhone.Text = result.Tables[0].Rows[0][Constants.CLIENT_CELLPHONE_COLUMN].ToString();
txtDrivingLicense.Text = result.Tables[0].Rows[0][Constants.CLIENT_LICENSENUMBER_COLUMN].ToString();
dtDateOfBirth.SelectedDate = DateTime.Parse(result.Tables[0].Rows[0][Constants.CLIENT_DATEOFBIRTH_COLUMN].ToString());
txtSSN.Text = result.Tables[0].Rows[0][Constants.CLIENT_SSN_COLUMN].ToString();
}
//Client General Case Information
result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_BASIC_INSURANCE_DETAILS_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
//TODO: check what to do here
txtInitialCaseInformation.Text = string.Empty;
txtDefendantName.Text = string.Empty;
txtOriginatingAttorney.Text = string.Empty;
txtAssignedAttorney.Text = string.Empty;
txtRefferal.Text = string.Empty;
}
else
{
txtInitialCaseInformation.Text = result.Tables[0].Rows[0][Constants.CLIENT_INITIALINFORMATION_COLUMN].ToString();
txtDefendantName.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANTNAME_COLUMN].ToString();
txtOriginatingAttorney.Text = result.Tables[0].Rows[0][Constants.CLIENT_ORIGINATINGATTORNY_COLUMN].ToString();
txtAssignedAttorney.Text = result.Tables[0].Rows[0][Constants.CLIENT_ASSIGNEDATTORNY_COLUMN].ToString();
txtRefferal.Text = result.Tables[0].Rows[0][Constants.CLIENT_REFERRAL_COLUMN].ToString();
}
//Client General Case Evidence Information
result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_BASIC_EVIDENCE_DETAILS_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtEvidence1.Text = string.Empty;
txtEvidence2.Text = string.Empty;
}
else
{
if (result.Tables[0].Rows.Count == 1)
{
txtEvidence1.Text = result.Tables[0].Rows[0][Constants.CLIENT_EVIDENCE_COLUMN].ToString();
txtEvidence2.Text = string.Empty;
}
else if (result.Tables[0].Rows.Count >= 2)
{
txtEvidence1.Text = result.Tables[0].Rows[0][Constants.CLIENT_EVIDENCE_COLUMN].ToString();
txtEvidence2.Text = result.Tables[0].Rows[1][Constants.CLIENT_EVIDENCE_COLUMN].ToString();
}
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void DisplaySelectedClientInformation(ClientFileInformation selectedClient)
{
ShowClientGeneralInformation(selectedClient);
ShowClientAdditionalInformation(selectedClient);
ShowClientAutoInformation(selectedClient);
ShowClientMedicalInsuranceInformation(selectedClient);
ShowClientDefendantDetailsInformation(selectedClient);
ShowDefendantInsuranceInformation(selectedClient);
ShowStatuteInformation(selectedClient);
ShowClientCourtInformation(selectedClient);
ShowClientMiscNotes(selectedClient);
}
private void ShowDefendantInsuranceInformation(ClientFileInformation selectedClient)
{
try
{
//Client Defendant Insurance information
var result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_DEFENDANT_INSURANCE_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtDefendantInsuranceNameOfInsured.Text = string.Empty;
txtDefendantInsuranceCompany.Text = string.Empty;
txtDefendantInsuranceAddress.Text = string.Empty;
txtDefendantInsuranceCity.Text = string.Empty;
txtDefendantInsuranceState.Text = string.Empty;
txtDefendantInsuranceZip.Text = string.Empty;
txtDefendantInsurancePhone.Text = string.Empty;
txtDefendantInsuranceAdjuster.Text = string.Empty;
txtDefendantInsuranceClaimNumber.Text = string.Empty;
txtDefendantInsurancePolicyLimits.Text = string.Empty;
}
else
{
txtDefendantInsuranceNameOfInsured.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_INSURANCE_NAME_INSURED_COLUMN].ToString();
txtDefendantInsuranceCompany.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_INSURANCE_INSURANCE_COMPANY_COLUMN].ToString();
txtDefendantInsuranceAddress.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_INSURANCE_ADDRESS_COLUMN].ToString();
txtDefendantInsuranceCity.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_INSURANCE_CITY_COLUMN].ToString();
txtDefendantInsuranceState.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_INSURANCE_STATE_COLUMN].ToString();
txtDefendantInsuranceZip.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_INSURANCE_ZIP_COLUMN].ToString();
txtDefendantInsurancePhone.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_INSURANCE_PHONE_NUMBER_COLUMN].ToString();
txtDefendantInsuranceAdjuster.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_INSURANCE_ADJUSTER_COLUMN].ToString();
txtDefendantInsuranceClaimNumber.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_INSURANCE_CLAIM_NUMBER_COLUMN].ToString();
txtDefendantInsurancePolicyLimits.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_INSURANCE_POLOCY_LIMIT_COLUMN].ToString();
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowClientMiscNotes(ClientFileInformation selectedClient)
{
FillClientMiscList(selectedClient.FileID);
}
private void ShowClientMedicalInsuranceInformation(ClientFileInformation selectedClient)
{
try
{
//Client Medical Insurance information
var result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_MEDICAL_INSURANCE_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtNamedInsured.Text = string.Empty;
txtInsuranceCompany.Text = string.Empty;
txtClientMedicalAddress.Text = string.Empty;
txtClientMedicalCity.Text = string.Empty;
txtClientMedicalState.Text = string.Empty;
txtClientMedicalZip.Text = string.Empty;
txtClientMedicalPhoneNumber.Text = string.Empty;
txtClientMedicalPolicyNumber.Text = string.Empty;
txtClientMedicalMedCalNumber.Text = string.Empty;
txtClientMedicalMedCareNumber.Text = string.Empty;
txtClaimNumber.Text = string.Empty;
}
else
{
txtNamedInsured.Text = result.Tables[0].Rows[0][Constants.CLIENT_MEDICAL_NAMEDINSURED_COLUMN].ToString();
txtInsuranceCompany.Text = result.Tables[0].Rows[0][Constants.CLIENT_MEDICAL_INSURANCE_COMPANY_COLUMN].ToString();
txtClientMedicalAddress.Text = result.Tables[0].Rows[0][Constants.CLIENT_MEDICAL_ADDRESS_COLUMN].ToString();
txtClientMedicalCity.Text = result.Tables[0].Rows[0][Constants.CLIENT_MEDICAL_CITY_COLUMN].ToString();
txtClientMedicalState.Text = result.Tables[0].Rows[0][Constants.CLIENT_MEDICAL_STATE_COLUMN].ToString();
txtClientMedicalZip.Text = result.Tables[0].Rows[0][Constants.CLIENT_MEDICAL_ZIP_COLUMN].ToString();
txtClientMedicalPhoneNumber.Text = result.Tables[0].Rows[0][Constants.CLIENT_MEDICAL_PHONE_NUMBER_COLUMN].ToString();
txtClientMedicalPolicyNumber.Text = result.Tables[0].Rows[0][Constants.CLIENT_MEDICAL_POLICY_NUMBER_COLUMN].ToString();
txtClientMedicalMedCalNumber.Text = result.Tables[0].Rows[0][Constants.CLIENT_MEDICAL_MEDICAL_NUMBER_COLUMN].ToString();
txtClientMedicalMedCareNumber.Text = result.Tables[0].Rows[0][Constants.CLIENT_MEDICAL_MEDICARE_COLUMN].ToString();
txtClaimNumber.Text = result.Tables[0].Rows[0][Constants.CLIENT_CLAIM_NUMBER_COLUMN].ToString();
}
//Client Injuries Inromation
FillClientInjuryList(selectedClient.FileID);
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowClientDefendantDetailsInformation(ClientFileInformation selectedClient)
{
try
{
//Client Defendant Details information
var result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_DEFENDANT_INFORMATION_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtDefendantLastName.Text = string.Empty;
txtDefendantFirstName.Text = string.Empty;
txtDefendantAddress.Text = string.Empty;
txtDefendantCity.Text = string.Empty;
txtDefendantState.Text = string.Empty;
txtDefendantZip.Text = string.Empty;
txtDefendantHomePhone.Text = string.Empty;
txtDefendantBusinessPhone.Text = string.Empty;
dtDefendantDateOfBirth.Text = string.Empty;
txtDefendantDrivingLicense.Text = string.Empty;
}
else
{
txtDefendantLastName.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_LAST_NAME_COLUMN].ToString();
txtDefendantFirstName.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_FIRST_NAME_COLUMN].ToString();
txtDefendantAddress.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_ADDRESS_COLUMN].ToString();
txtDefendantCity.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_CITY_COLUMN].ToString();
txtDefendantState.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_STATE_COLUMN].ToString();
txtDefendantZip.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_ZIP_COLUMN].ToString();
txtDefendantHomePhone.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_HOME_PHONE_COLUMN].ToString();
txtDefendantBusinessPhone.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_BUSINESS_PHONE_COLUMN].ToString();
dtDefendantDateOfBirth.SelectedDate = DateTime.Parse(result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_DATE_OF_BIRTH_COLUMN].ToString());
txtDefendantDrivingLicense.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_lICENSE_NUMBER_COLUMN].ToString();
}
//Client Defendant Attorney Inromation
result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_DEFENDANT_ATTORNEY_DETAILS_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtDefendantAttorneyFirm.Text = string.Empty;
txtDefendantAttorneyName.Text = string.Empty;
txtDefendantAttorneyAddress.Text = string.Empty;
txtDefendantAttorneyCity.Text = string.Empty;
txtDefendantAttorneyState.Text = string.Empty;
txtDefendantAttorneyZip.Text = string.Empty;
txtDefendantAttorneyPhone.Text = string.Empty;
}
else
{
txtDefendantAttorneyFirm.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_ATTORNEY_FIRM_COLUMN].ToString();
txtDefendantAttorneyName.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_ATTORNEY_COLUMN].ToString();
txtDefendantAttorneyAddress.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_ATTORNEY_ADDRESS_COLUMN].ToString();
txtDefendantAttorneyCity.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_ATTORNEY_CITY_COLUMN].ToString();
txtDefendantAttorneyState.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_ATTORNEY_STATE_COLUMN].ToString();
txtDefendantAttorneyZip.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_ATTORNEY_ZIP_COLUMN].ToString();
txtDefendantAttorneyPhone.Text = result.Tables[0].Rows[0][Constants.CLIENT_DEFENDANT_ATTORNEY_PHONE_NUMBER_COLUMN].ToString();
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowClientCourtInformation(ClientFileInformation selectedClient)
{
try
{
//Client Court Insurance information
var result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_COURT_DETAILS_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtCourtInfoCaseNumber.Text = string.Empty;
txtCourtInfoCourt.Text = string.Empty;
txtCourtInfoAddress.Text = string.Empty;
txtCourtInfoCity.Text = string.Empty;
txtCourtInfoState.Text = string.Empty;
txtCourtInfoZip.Text = string.Empty;
}
else
{
txtCourtInfoCaseNumber.Text = result.Tables[0].Rows[0][Constants.CLIENT_COURT_CASE_NUMBER_COLUMN].ToString();
txtCourtInfoCourt.Text = result.Tables[0].Rows[0][Constants.CLIENT_COURT_COURT_COLUMN].ToString();
txtCourtInfoAddress.Text = result.Tables[0].Rows[0][Constants.CLIENT_COURT_ADDRESS_COLUMN].ToString();
txtCourtInfoCity.Text = result.Tables[0].Rows[0][Constants.CLIENT_COURT_CITY_COLUMN].ToString();
txtCourtInfoState.Text = result.Tables[0].Rows[0][Constants.CLIENT_COURT_STATE_COLUMN].ToString();
txtCourtInfoZip.Text = result.Tables[0].Rows[0][Constants.CLIENT_COURT_ZIP_COLUMN].ToString();
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowClientAutoInformation(ClientFileInformation selectedClient)
{
try
{
//Client General Addtional information
var result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_AUTO_INFO_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtClientAutoInsuranceCompany.Text = string.Empty;
txtClientAutoAddress.Text = string.Empty;
txtClientAutoCity.Text = string.Empty;
txtClientAutoState.Text = string.Empty;
txtClientAutoZip.Text = string.Empty;
txtClientAutoPhoneNumber.Text = string.Empty;
txtClientAutoAdjuster.Text = string.Empty;
}
else
{
txtClientAutoInsuranceCompany.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_INSURANCE_COMPANY_COLUMN].ToString();
txtClientAutoAddress.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_ADDRESS_COLUMN].ToString();
txtClientAutoCity.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_CITY_COLUMN].ToString();
txtClientAutoState.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_PHONE_NUMBER_COLUMN].ToString();
txtClientAutoZip.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_ADJUSTER_COLUMN].ToString();
txtClientAutoPhoneNumber.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_STATE_COLUMN].ToString();
txtClientAutoAdjuster.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_ZIP_COLUMN].ToString();
}
//Client Additional Spouse information
result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_AUTO_POLICY_INFO_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtPolicyNumber.Text = string.Empty;
dtEffectiveStartDate.Text = string.Empty;
dtEffectiveEndtDate.Text = string.Empty;
txtMedPayAvailable.Text = string.Empty;
txtAmount.Text = string.Empty;
txtLiabilityMinimumCoverage.Text = string.Empty;
txtLiabilityMaximumCoverage.Text = string.Empty;
txtUMIMinimum.Text = string.Empty;
txtUMIMaximum.Text = string.Empty;
txtReimbursable.Text = string.Empty;
txtClientAutoInfoNotes.Text = string.Empty;
}
else
{
txtPolicyNumber.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_POLICY_NUMBER_COLUMN].ToString();
dtEffectiveStartDate.SelectedDate = DateTime.Parse(result.Tables[0].Rows[0][Constants.CLIENT_AUTO_EFFECTIVE_START_DATE_COLUMN].ToString());
dtEffectiveEndtDate.SelectedDate = DateTime.Parse(result.Tables[0].Rows[0][Constants.CLIENT_AUTO_EFFECTIVE_END_DATE_COLUMN].ToString());
txtMedPayAvailable.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_MED_PAY_AVAILABLE_COLUMN].ToString();
txtAmount.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_AMOUNT_COLUMN].ToString();
txtLiabilityMinimumCoverage.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_LIABILITY_MIN_COVERAGE_COLUMN].ToString();
txtLiabilityMaximumCoverage.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_LIABILITY_MAX_COVERAGE_COLUMN].ToString();
txtUMIMinimum.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_UMIMIN_VALUE_COLUMN].ToString();
txtUMIMaximum.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_UMIMAX_VALUE_COLUMN].ToString();
txtReimbursable.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_REIMBURSABLE_COLUMN].ToString();
txtClientAutoInfoNotes.Text = result.Tables[0].Rows[0][Constants.CLIENT_AUTO_NOTES_COLUMN].ToString();
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowClientAdditionalInformation(ClientFileInformation selectedClient)
{
try
{
//Client General Addtional information
var result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_ADDITIONAL_INFO_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtClientOccupation.Text = string.Empty;
txtEmployer.Text = string.Empty;
txtClientEmployerAddress.Text = string.Empty;
txtClientEmployerCity.Text = string.Empty;
txtClientEmployerState.Text = string.Empty;
}
else
{
txtClientOccupation.Text = result.Tables[0].Rows[0][Constants.CLIENT_OCCUPATION_COLUMN].ToString();
txtEmployer.Text = result.Tables[0].Rows[0][Constants.CLIENT_EMPLOYER_COLUMN].ToString();
txtClientEmployerAddress.Text = result.Tables[0].Rows[0][Constants.CLIENT_ADDITIONAL_ADDRESS_COLUMN].ToString();
txtClientEmployerCity.Text = result.Tables[0].Rows[0][Constants.CLIENT_ADDITIONAL_CITY_COLUMN].ToString();
txtClientEmployerState.Text = result.Tables[0].Rows[0][Constants.CLIENT_ADDITIONAL_STATE_COLUMN].ToString();
}
//Client Additional Spouse information
result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_ADDITIONAL_SPOUSE_QUERY, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
txtClientSpousLastName.Text = string.Empty;
txtClientSpousFirstName.Text = string.Empty;
txtClientSpousOccupation.Text = string.Empty;
txtSpouseEmployer.Text = string.Empty;
txtClientSpouseEmployerAddress.Text = string.Empty;
txtClientSpouseEmployerCity.Text = string.Empty;
txtClientSpouseEmployerState.Text = string.Empty;
}
else
{
txtClientSpousLastName.Text = result.Tables[0].Rows[0][Constants.CLIENT_SPOUSE_LAST_NAME_COLUMN].ToString();
txtClientSpousFirstName.Text = result.Tables[0].Rows[0][Constants.CLIENT_SPOUSE_FIRST_NAME_COLUMN].ToString();
txtClientSpousOccupation.Text = result.Tables[0].Rows[0][Constants.CLIENT_SPOUSE_OCCUPATION_COLUMN].ToString();
txtSpouseEmployer.Text = result.Tables[0].Rows[0][Constants.CLIENT_SPOUSE_EMPLOYER_COLUMN].ToString();
txtClientSpouseEmployerAddress.Text = result.Tables[0].Rows[0][Constants.CLIENT_SPOUSE_ADDRESS_COLUMN].ToString(); ;
txtClientSpouseEmployerCity.Text = result.Tables[0].Rows[0][Constants.CLIENT_SPOUSE_CITY_COLUMN].ToString();
txtClientSpouseEmployerState.Text = result.Tables[0].Rows[0][Constants.CLIENT_SPOUSE_STATE_COLUMN].ToString();
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowStatuteInformation(ClientFileInformation selectedClient)
{
try
{
var result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_STATUTE_INFORMATION, selectedClient.FileID));
if (result == null || result.Tables[0].Rows.Count == 0)
{
}
else
{
dtStatuteComplaintFiledDate.SelectedDate = DateTime.Parse(result.Tables[0].Rows[0][Constants.STATUTE_COMPLAINTFILE_DATE].ToString());
cbIsItAGovernmentClaim.IsChecked = Boolean.Parse(result.Tables[0].Rows[0][Constants.STATUTE_IS_GOVT_CLAIM].ToString());
string tempValue = result.Tables[0].Rows[0][Constants.STATUTE_CITY_DENIED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtCityDeniedDate.SelectedDate = DateTime.Parse(tempValue);
}
else
{
tempValue = string.Empty;
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_CITY_CLAIM_DUE_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtCityFileDate.SelectedDate = DateTime.Parse(tempValue);
}
else
{
tempValue = string.Empty;
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_COUNTY_DENIED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtCountyDeniedDate.SelectedDate = DateTime.Parse(tempValue);
}
else
{
tempValue = string.Empty;
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_COUNTY_FILED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtCountyFileDate.SelectedDate = DateTime.Parse(tempValue);
}
else
{
tempValue = string.Empty;
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_STATE_DENIED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtStateDeniedDate.SelectedDate = DateTime.Parse(tempValue);
}
else
{
tempValue = string.Empty;
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_STATE_FILED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtStateFileDate.SelectedDate = DateTime.Parse(tempValue);
}
else
{
tempValue = string.Empty;
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_OTHER_DENIED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtOtherDeniedDate.SelectedDate = DateTime.Parse(tempValue);
}
else
{
tempValue = string.Empty;
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_OTHER_FILED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtOtherFileDate.SelectedDate = DateTime.Parse(tempValue);
}
else
{
tempValue = string.Empty;
}
}
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void ShowStatuteInformation(ClientFileInformation selectedClient)
{
try
{
var result = BusinessLogic.GetStatuteInformationSummary(selectedClient.FileID);
if (result == null || result.Tables[0].Rows.Count == 0)
{
return;
}
else
{
dtStatuteComplaintFiledDate.SelectedDate = DateTime.Parse(result.Tables[0].Rows[0][Constants.STATUTE_COMPLAINTFILE_DATE].ToString());
cbIsItAGovernmentClaim.IsChecked = Boolean.Parse(result.Tables[0].Rows[0][Constants.STATUTE_IS_GOVT_CLAIM].ToString());
string tempValue = result.Tables[0].Rows[0][Constants.STATUTE_DA6MONTHSLATER].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dt6MonthsStatute.SelectedDate = DateTime.Parse(tempValue);
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_CITYFILEDDATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtCityStatuteDate.SelectedDate = DateTime.Parse(tempValue);
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_CITY_DENIED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtCityStatuteRejDate.SelectedDate = DateTime.Parse(tempValue);
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_COUNTY_FILED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtCountyStatuteDate.SelectedDate = DateTime.Parse(tempValue);
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_COUNTY_DENIED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtCountyStatuteRejDate.SelectedDate = DateTime.Parse(tempValue);
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_STATE_FILED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtStateStatuteDate.SelectedDate = DateTime.Parse(tempValue);
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_STATE_DENIED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtStateStatuteRejDate.SelectedDate = DateTime.Parse(tempValue);
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_OTHER_FILED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtOtherStatuteDate.SelectedDate = DateTime.Parse(tempValue);
}
tempValue = result.Tables[0].Rows[0][Constants.STATUTE_OTHER_DENIED_DATE].ToString();
if (!string.IsNullOrEmpty(tempValue))
{
dtOtherStatuteRejDate.SelectedDate = DateTime.Parse(tempValue);
}
}
#region Old Code
//var result = DBHelper.GetSelectDataSet(string.Format(Constants.CLIENT_STATUTE_INFORMATION, selectedClient.FileID));
//if (result == null || result.Tables[0].Rows.Count == 0)
//{
//}
//else
//{
// dtStatuteComplaintFiledDate.SelectedDate = DateTime.Parse(result.Tables[0].Rows[0][Constants.STATUTE_COMPLAINTFILE_DATE].ToString());
// cbIsItAGovernmentClaim.IsChecked = Boolean.Parse(result.Tables[0].Rows[0][Constants.STATUTE_IS_GOVT_CLAIM].ToString());
// string tempValue = result.Tables[0].Rows[0][Constants.STATUTE_CITY_DENIED_DATE].ToString();
// if (!string.IsNullOrEmpty(tempValue))
// {
// dtCityStatuteDate.SelectedDate = DateTime.Parse(tempValue);
// }
// else
// {
// tempValue = string.Empty;
// }
// tempValue = result.Tables[0].Rows[0][Constants.STATUTE_CITY_CLAIM_DUE_DATE].ToString();
// if (!string.IsNullOrEmpty(tempValue))
// {
// dtCityStatuteDate.SelectedDate = DateTime.Parse(tempValue);
// }
// else
// {
// tempValue = string.Empty;
// }
// tempValue = result.Tables[0].Rows[0][Constants.STATUTE_COUNTY_DENIED_DATE].ToString();
// if (!string.IsNullOrEmpty(tempValue))
// {
// dtCountyStatuteDate.SelectedDate = DateTime.Parse(tempValue);
// }
// else
// {
// tempValue = string.Empty;
// }
// tempValue = result.Tables[0].Rows[0][Constants.STATUTE_COUNTY_FILED_DATE].ToString();
// if (!string.IsNullOrEmpty(tempValue))
// {
// dtCountyStatuteDate.SelectedDate = DateTime.Parse(tempValue);
// }
// else
// {
// tempValue = string.Empty;
// }
// tempValue = result.Tables[0].Rows[0][Constants.STATUTE_STATE_DENIED_DATE].ToString();
// if (!string.IsNullOrEmpty(tempValue))
// {
// dtStateStatuteRejDate.SelectedDate = DateTime.Parse(tempValue);
// }
// else
// {
// tempValue = string.Empty;
// }
// tempValue = result.Tables[0].Rows[0][Constants.STATUTE_STATE_FILED_DATE].ToString();
// if (!string.IsNullOrEmpty(tempValue))
// {
// dtStateStatuteDate.SelectedDate = DateTime.Parse(tempValue);
// }
// else
// {
// tempValue = string.Empty;
// }
// tempValue = result.Tables[0].Rows[0][Constants.STATUTE_OTHER_DENIED_DATE].ToString();
// if (!string.IsNullOrEmpty(tempValue))
// {
// dtOtherStatuteDate.SelectedDate = DateTime.Parse(tempValue);
// }
// else
// {
// tempValue = string.Empty;
// }
// tempValue = result.Tables[0].Rows[0][Constants.STATUTE_OTHER_FILED_DATE].ToString();
// if (!string.IsNullOrEmpty(tempValue))
// {
// dtOtherStatuteDate.SelectedDate = DateTime.Parse(tempValue);
// }
// else
// {
// tempValue = string.Empty;
// }
//}
#endregion
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
