private void submitEvaluation()
        {
            CaselyUserData caselyUserData = new CaselyUserData()
            {
                CaseNumber = cmbCaseNumber.SelectedValue.ToString(), Service = cmbService.Text, Evaluation = cmbSelfEvaluation.Text, EvaluationComment = txtSelfEvalComments.Text
            };

            // Save the evaluation and other data for the case, essentially completing it.
            SqliteDataAcces.UpdateCompletedCase(caselyUserData);
            // Update in-memory list of caselyUserDatas, that way do not have to go back to the database again to load.
            foreach (var pc in listAllCaselyUserData)
            {
                if (pc.CaseNumber == caselyUserData.CaseNumber)
                {
                    pc.Evaluation        = caselyUserData.Evaluation;
                    pc.EvaluationComment = caselyUserData.EvaluationComment;
                    pc.Service           = caselyUserData.Service;
                }
            }
            cmbSelfEvaluation.Text = "";
            var indx = cmbCaseNumber.SelectedIndex;

            // cmbService.Focus();
            ApplyFiltersToCaseListAndRefresh();
        }
 private void btnAddCase_Click(object sender, RoutedEventArgs e)
 {
     if (txtCaseNumber.Text.Trim() == "" || txtCaseNumber.Text == SqliteDataAcces.CaseNumberPrefix)
     {
         MessageBox.Show("Please enter a case number");
     }
     else if (cmbService.Text == "")
     {
         MessageBox.Show("Please choose a service");
     }
     else if (cmbAuthor.Text == "")
     {
         MessageBox.Show("Please choose an author");
     }
     else
     {
         CaselyUserData pc = new CaselyUserData();
         pc.CaseNumber = txtCaseNumber.Text;
         pc.Service    = cmbService.Text;
         CaseEntry ce          = new CaseEntry();
         DateTime  currentTime = DateTime.Now;
         ce.AuthorID           = cmbAuthor.Text;
         ce.CaseNumber         = txtCaseNumber.Text;
         ce.Interpretation     = txtInterpretation.Text;
         ce.Result             = txtResultEntry.Text;
         ce.Comment            = txtComment.Text;
         ce.TumorSynoptic      = txtTumorSynoptic.Text;
         ce.DateModifiedString = dtCreated.Value.GetValueOrDefault().ToString("yyyy-MM-dd");
         ce.TimeModifiedString = dtCreated.Value.GetValueOrDefault().ToString("HH:mm:ss");
         SqliteDataAcces.InsertNewCaseEntry(ce, pc);
         txtInterpretation.Text = "";
         txtComment.Text        = "";
         txtResultEntry.Text    = "";
         txtTumorSynoptic.Text  = "";
         txtCaseNumber.Text     = SqliteDataAcces.CaseNumberPrefix;
         MessageBox.Show("Case Added");
         dtCreated.Value = DateTime.Now;
     }
 }