示例#1
0
 internal static void SaveClientInjury(ClientInjury injury, string fileID)
 {
     try
     {
         string query = string.Format(Constants.INSERT_CLIENT_INJURY_NOTE_QUERY, fileID, injury.Note, injury.CreatedDate.ToString(), injury.CreatedDate.ToString(), injury.Description);
         int result = DBHelper.ExecuteNonQuery(query);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        private void btnSaveClientMedicalInsuranceNote_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(actionClientMedicalInsuranceNote))
                {
                    btnSaveClientMedicalInsuranceNote.IsEnabled = false;
                    txtClientMedicalInsuranceNoteName.IsReadOnly = true;
                    txtClientMedicalInsuranceNoteDescription.IsReadOnly = true;
                    btnEditClientMedicalInsuranceNote.IsEnabled = true;
                    btnAddNewClientMedicalInsuranceNote.IsEnabled = true;
                    btnDeleteClientMedicalInsuranceNote.IsEnabled = true;
                    return;
                }
                string query = string.Empty;

                if (actionClientMedicalInsuranceNote == "Add")
                {
                    ClientInjury injury = new ClientInjury();
                    injury.Note = txtClientMedicalInsuranceNoteName.Text;
                    injury.CreatedDate = dtClientMedicalNoteDate.SelectedDate.Value.ToShortDateString();
                    injury.Description = txtClientMedicalInsuranceNoteDescription.Text;
                    BusinessLogic.SaveClientInjury(injury, txtFileNo.Text);
                }
                else if (actionClientMedicalInsuranceNote == "Edit")
                {
                    ClientInjury selectedValue = dgClientMedicalInsuranceNotes.SelectedValue as ClientInjury;
                    query = string.Format(Constants.UPDATE_CLIENT_INJURY_NOTE_QUERY, txtClientMedicalInsuranceNoteName.Text, selectedValue.CreatedDate, dtClientMedicalNoteDate.SelectedDate.Value.ToShortDateString(), txtClientMedicalInsuranceNoteDescription.Text,
                        selectedValue.FileID, selectedValue.Note, selectedValue.CreatedDate, selectedValue.LastModifiedDate, selectedValue.Description);
                    BusinessLogic.UpdateClientInjury(query);
                }

                FillClientInjuryList(txtFileNo.Text);

                btnSaveClientMedicalInsuranceNote.IsEnabled = false;
                btnAddNewClientMedicalInsuranceNote.IsEnabled = true;
                btnDeleteClientMedicalInsuranceNote.IsEnabled = true;
                btnEditClientMedicalInsuranceNote.IsEnabled = true;
            }
            catch (Exception ex)
            {
                Helper.LogException(ex);
            }
        }