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