internal static void UpdateClientMedicationInformation(ClientMedicalInformation mediInfo, string fileID) { string query = string.Format(Constants.EXISTS_CLIENT_MEDICAL_INFORMATION_QUERY, fileID); object isPresent = DBHelper.GetScalarValue(query); int result = 0; if (isPresent == null) { query = string.Format(Constants.INSERT_CLIENT_MEDICAL_INFORMATION_QUERY, fileID, mediInfo.NamedInsured, mediInfo.InsuranceCompany, mediInfo.Address, mediInfo.City, mediInfo.State, mediInfo.Zip, mediInfo.PhoneNumber, mediInfo.PolicyNumber, mediInfo.MediCalNumber, mediInfo.MediCareNumber, mediInfo.ClaimNumber); result = DBHelper.ExecuteNonQuery(query); } else { query = string.Format(Constants.UPDATE_CLIENT_MEDICAL_INFORMATION_QUERY, fileID, mediInfo.NamedInsured, mediInfo.InsuranceCompany, mediInfo.Address, mediInfo.City, mediInfo.State, mediInfo.Zip, mediInfo.PhoneNumber, mediInfo.PolicyNumber, mediInfo.MediCalNumber, mediInfo.MediCareNumber, mediInfo.ClaimNumber); result = DBHelper.ExecuteNonQuery(query); } }
private void btnSaveClientMedicalInsurance_Click(object sender, RoutedEventArgs e) { try { if (string.IsNullOrEmpty(txtNamedInsured.Text) && string.IsNullOrEmpty(txtInsuranceCompany.Text) && string.IsNullOrEmpty(txtClientMedicalAddress.Text) && string.IsNullOrEmpty(txtClientMedicalCity.Text) && string.IsNullOrEmpty(txtClientMedicalState.Text) && string.IsNullOrEmpty(txtClientMedicalZip.Text) && string.IsNullOrEmpty(txtClientMedicalPhoneNumber.Text) && string.IsNullOrEmpty(txtClaimNumber.Text) && string.IsNullOrEmpty(txtClientMedicalPolicyNumber.Text) && string.IsNullOrEmpty(txtClientMedicalMedCalNumber.Text) && string.IsNullOrEmpty(txtClientMedicalMedCareNumber.Text)) { return; } ClientMedicalInformation mediInfo = new ClientMedicalInformation(); mediInfo.NamedInsured = txtNamedInsured.Text; mediInfo.InsuranceCompany = txtInsuranceCompany.Text; mediInfo.Address = txtClientMedicalAddress.Text; mediInfo.City = txtClientMedicalCity.Text; mediInfo.State = txtClientMedicalState.Text; mediInfo.Zip = txtClientMedicalZip.Text; mediInfo.PhoneNumber = txtClientMedicalPhoneNumber.Text; mediInfo.PolicyNumber = txtClientMedicalPolicyNumber.Text; mediInfo.MediCalNumber = txtClientMedicalMedCalNumber.Text; mediInfo.MediCareNumber = txtClientMedicalMedCareNumber.Text; mediInfo.ClaimNumber = txtClaimNumber.Text; BusinessLogic.UpdateClientMedicationInformation(mediInfo, txtFileNo.Text); Helper.ShowInformationMessageBox("Client Medical Information Saved."); btnSaveClientMedicalInsurance.IsEnabled = false; btnCancelClientMedicalInsurance.IsEnabled = false; btnEditClientMedicalInsurance.IsEnabled = true; UpdateClientMedicalInfo(true); UpdateClientInjuryInfo(true); } catch (Exception ex) { Helper.LogException(ex); } }
internal static void SaveClientMedicationInformation(ClientMedicalInformation mediInfo, string fileID) { string query = string.Format(Constants.INSERT_CLIENT_MEDICAL_INFORMATION_QUERY, fileID, mediInfo.NamedInsured, mediInfo.InsuranceCompany, mediInfo.Address, mediInfo.City, mediInfo.State, mediInfo.Zip, mediInfo.PhoneNumber, mediInfo.PolicyNumber, mediInfo.MediCalNumber, mediInfo.MediCareNumber, mediInfo.ClaimNumber); int result = DBHelper.ExecuteNonQuery(query); }
private void SaveClientMedicalInformation() { try { if (string.IsNullOrEmpty(txtNamedInsured.Text) && string.IsNullOrEmpty(txtInsuranceCompany.Text) && string.IsNullOrEmpty(txtClientMedicalAddress.Text) && string.IsNullOrEmpty(txtClientMedicalCity.Text) && string.IsNullOrEmpty(txtClientMedicalState.Text) && string.IsNullOrEmpty(txtClientMedicalZip.Text) && string.IsNullOrEmpty(txtClientMedicalPhoneNumber.Text) && string.IsNullOrEmpty(txtClientMedicalPolicyNumber.Text) && string.IsNullOrEmpty(txtClientMedicalMedCalNumber.Text) && string.IsNullOrEmpty(txtClaimNumber.Text) && string.IsNullOrEmpty(txtClientMedicalMedCareNumber.Text)) { return; } ClientMedicalInformation mediInfo = new ClientMedicalInformation(); mediInfo.NamedInsured = txtNamedInsured.Text; mediInfo.InsuranceCompany = txtInsuranceCompany.Text; mediInfo.Address = txtClientMedicalAddress.Text; mediInfo.City = txtClientMedicalCity.Text; mediInfo.State = txtClientMedicalState.Text; mediInfo.Zip = txtClientMedicalZip.Text; mediInfo.PhoneNumber = txtClientMedicalPhoneNumber.Text; mediInfo.PolicyNumber = txtClientMedicalPolicyNumber.Text; mediInfo.MediCalNumber = txtClientMedicalMedCalNumber.Text; mediInfo.MediCareNumber = txtClientMedicalMedCareNumber.Text; mediInfo.ClaimNumber = txtClaimNumber.Text; BusinessLogic.SaveClientMedicationInformation(mediInfo, txtFileNo.Text); } catch (Exception ex) { Helper.LogException(ex); } }