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