private void btnSaveClientAutoInfo_Click(object sender, RoutedEventArgs e) { try { if (string.IsNullOrEmpty(txtClientAutoInsuranceCompany.Text) && string.IsNullOrEmpty(txtClientAutoAddress.Text) && string.IsNullOrEmpty(txtClientAutoCity.Text) && string.IsNullOrEmpty(txtClientAutoState.Text) && string.IsNullOrEmpty(txtClientAutoZip.Text) && string.IsNullOrEmpty(txtClientAutoPhoneNumber.Text) && string.IsNullOrEmpty(txtPolicyNumber.Text) && dtEffectiveStartDate.SelectedDate == null && dtEffectiveEndtDate.SelectedDate == null && string.IsNullOrEmpty(txtMedPayAvailable.Text) && string.IsNullOrEmpty(txtAmount.Text) && string.IsNullOrEmpty(txtLiabilityMinimumCoverage.Text) && string.IsNullOrEmpty(txtLiabilityMaximumCoverage.Text) && string.IsNullOrEmpty(txtUMIMinimum.Text) && string.IsNullOrEmpty(txtUMIMaximum.Text) && string.IsNullOrEmpty(txtReimbursable.Text) && string.IsNullOrEmpty(txtClientAutoInfoNotes.Text)) { return; } ClientAutoInformation autoInfo = new ClientAutoInformation(); autoInfo.InsuranceCompany = txtClientAutoInsuranceCompany.Text; autoInfo.Address = txtClientAutoAddress.Text; autoInfo.City = txtClientAutoCity.Text; autoInfo.State = txtClientAutoState.Text; autoInfo.Zip = txtClientAutoZip.Text; autoInfo.PhoneNumber = txtClientAutoPhoneNumber.Text; autoInfo.Adjuster = txtClientAutoAdjuster.Text; autoInfo.PolicyNumber = txtPolicyNumber.Text; if (dtEffectiveStartDate.SelectedDate != null) { autoInfo.EffectiveStartDate = DateTime.Parse(dtEffectiveStartDate.SelectedDate.Value.ToShortDateString()); } if (dtEffectiveEndtDate.SelectedDate != null) { autoInfo.EffectiveEndDate = DateTime.Parse(dtEffectiveEndtDate.SelectedDate.Value.ToShortDateString()); } autoInfo.MedPayAvailable = txtMedPayAvailable.Text; autoInfo.Amout = txtAmount.Text; autoInfo.LiabilityMinimumCoverage = txtLiabilityMinimumCoverage.Text; autoInfo.LiabilityMaximumCoverage = txtLiabilityMaximumCoverage.Text; autoInfo.UMIMinimum = txtUMIMinimum.Text; autoInfo.UMIMaximum = txtUMIMaximum.Text; autoInfo.Reimbursable = txtReimbursable.Text; autoInfo.Notes = txtClientAutoInfoNotes.Text; BusinessLogic.UpdateClientAutoInformation(autoInfo, txtFileNo.Text); Helper.ShowInformationMessageBox("Client Auto Information Saved."); btnCancelClientAutoInfo.IsEnabled = false; btnSaveClientAutoInfo.IsEnabled = false; btnEditClientAutoInfo.IsEnabled = true; UpdateStatusClientAutoInfo(true); } catch (Exception ex) { Helper.LogException(ex); } }
internal static void UpdateClientAutoInformation(ClientAutoInformation autoInfo, string fileID) { string query = string.Format(Constants.EXISTS_CLIENT_AUTO_DETAILS_QUERY, fileID); object isPresent = DBHelper.GetScalarValue(query); int result = 0; if (isPresent == null) { query = string.Format(Constants.INSERT_CLIENT_AUTO_DETAILS_QUERY, fileID, autoInfo.InsuranceCompany, autoInfo.Address, autoInfo.City, autoInfo.State, autoInfo.Zip, autoInfo.PhoneNumber, autoInfo.Adjuster); result = DBHelper.ExecuteNonQuery(query); } else { query = string.Format(Constants.UPDATE_CLIENT_AUTO_DETAILS_QUERY, fileID, autoInfo.InsuranceCompany, autoInfo.Address, autoInfo.City, autoInfo.State, autoInfo.Zip, autoInfo.PhoneNumber, autoInfo.Adjuster); result = DBHelper.ExecuteNonQuery(query); } query = string.Format(Constants.EXISTS_CLIENT_POLICY_DETAILS_QUERY, fileID); isPresent = DBHelper.GetScalarValue(query); if (isPresent == null) { query = string.Format(Constants.INSERT_CLIENT_POLICY_DETAILS_QUERY, fileID, autoInfo.PolicyNumber, autoInfo.EffectiveStartDate.ToString(), GetNonNullIntValue(autoInfo.Amout), autoInfo.EffectiveEndDate.ToString(), GetNonNullIntValue(autoInfo.LiabilityMinimumCoverage), GetNonNullIntValue(autoInfo.LiabilityMaximumCoverage), GetNonNullIntValue(autoInfo.UMIMinimum), GetNonNullIntValue(autoInfo.UMIMaximum), autoInfo.Notes, autoInfo.MedPayAvailable, autoInfo.Reimbursable); result = DBHelper.ExecuteNonQuery(query); } { query = string.Format(Constants.UPDATE_CLIENT_POLICY_DETAILS_QUERY, fileID, autoInfo.PolicyNumber, autoInfo.EffectiveStartDate.ToString(), GetNonNullIntValue(autoInfo.Amout), autoInfo.EffectiveEndDate.ToString(), GetNonNullIntValue(autoInfo.LiabilityMinimumCoverage), GetNonNullIntValue(autoInfo.LiabilityMaximumCoverage), GetNonNullIntValue(autoInfo.UMIMinimum), GetNonNullIntValue(autoInfo.UMIMaximum), autoInfo.Notes, autoInfo.MedPayAvailable, autoInfo.Reimbursable); result = DBHelper.ExecuteNonQuery(query); } }
private void SaveClientAutoInformation() { try { if (string.IsNullOrEmpty(txtClientAutoInsuranceCompany.Text) && string.IsNullOrEmpty(txtClientAutoAddress.Text) && string.IsNullOrEmpty(txtClientAutoCity.Text) && string.IsNullOrEmpty(txtClientAutoState.Text) && string.IsNullOrEmpty(txtClientAutoZip.Text) && string.IsNullOrEmpty(txtClientAutoPhoneNumber.Text) && string.IsNullOrEmpty(txtPolicyNumber.Text) && dtEffectiveStartDate.SelectedDate == null && dtEffectiveEndtDate.SelectedDate == null && string.IsNullOrEmpty(txtMedPayAvailable.Text) && string.IsNullOrEmpty(txtAmount.Text) && string.IsNullOrEmpty(txtLiabilityMinimumCoverage.Text) && string.IsNullOrEmpty(txtLiabilityMaximumCoverage.Text) && string.IsNullOrEmpty(txtUMIMinimum.Text) && string.IsNullOrEmpty(txtUMIMaximum.Text) && string.IsNullOrEmpty(txtReimbursable.Text) && string.IsNullOrEmpty(txtClientAutoInfoNotes.Text)) { return; } ClientAutoInformation autoInfo = new ClientAutoInformation(); autoInfo.InsuranceCompany = txtClientAutoInsuranceCompany.Text; autoInfo.Address = txtClientAutoAddress.Text; autoInfo.City = txtClientAutoCity.Text; autoInfo.State = txtClientAutoState.Text; autoInfo.Zip = txtClientAutoZip.Text; autoInfo.PhoneNumber = txtClientAutoPhoneNumber.Text; autoInfo.Adjuster = txtClientAutoAdjuster.Text; autoInfo.PolicyNumber = txtPolicyNumber.Text; autoInfo.EffectiveStartDate = DateTime.Parse(dtEffectiveStartDate.SelectedDate.Value.ToShortDateString()); autoInfo.EffectiveEndDate = DateTime.Parse(dtEffectiveEndtDate.SelectedDate.Value.ToShortDateString()); autoInfo.MedPayAvailable = txtMedPayAvailable.Text; autoInfo.Amout = txtAmount.Text; autoInfo.LiabilityMinimumCoverage = txtLiabilityMinimumCoverage.Text; autoInfo.LiabilityMaximumCoverage = txtLiabilityMaximumCoverage.Text; autoInfo.UMIMinimum = txtUMIMinimum.Text; autoInfo.UMIMaximum = txtUMIMaximum.Text; autoInfo.Reimbursable = txtReimbursable.Text; autoInfo.Notes = txtClientAutoInfoNotes.Text; BusinessLogic.SaveClientAutoInformation(autoInfo, txtFileNo.Text); } catch (Exception ex) { Helper.LogException(ex); } }