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