/// <summary> /// Asynchronously stores test results into a database described by KlokanTestDBContext. /// Results that already exist in the database are rewritten. /// </summary> /// <param name="results">Any enumerable structure of evaluation test results.</param> /// <returns>A void task.</returns> async Task OutputTestResultsDB(IEnumerable <TestResult> testResults) { using (var testDB = new KlokanTestDBContext()) { foreach (var testResult in testResults) { if (testResult.Error == true) { failedSheets++; continue; } var scanQuery = from scan in testDB.Scans where scan.ScanId == testResult.ScanId select scan; var oldComputedAnswersQuery = from answer in testDB.ComputedValues where answer.ScanId == testResult.ScanId select answer; // delete old computed values foreach (var answer in oldComputedAnswersQuery) { testDB.ComputedValues.Remove(answer); } // assign new computed values KlokanTestDBScan correspondingScan = scanQuery.FirstOrDefault(); var computedValuesDbSet = new List <KlokanTestDBComputedAnswer>(); computedValuesDbSet.AddRange(TableArrayHandling.AnswersToDbSet <KlokanTestDBComputedAnswer>(testResult.StudentComputedValues, 0, true)); for (int i = 0; i < 3; i++) { computedValuesDbSet.AddRange(TableArrayHandling.AnswersToDbSet <KlokanTestDBComputedAnswer>(testResult.AnswerComputedValues, i, false)); } correspondingScan.ComputedValues = computedValuesDbSet; correspondingScan.Correctness = testResult.Correctness; await testDB.SaveChangesAsync(progressDialog.GetCancellationToken()); } } }
private void updateButton_Click(object sender, EventArgs e) { var dialogResult = MessageBox.Show(Properties.Resources.PromptTextDatabaseUpdate, Properties.Resources.PromptCaptionDatabaseUpdate, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.No) { return; } updateButton.Enabled = false; // prepare the DbSet of chosen expected answers List <KlokanTestDBExpectedAnswer> expectedAnswers = new List <KlokanTestDBExpectedAnswer>(); expectedAnswers.AddRange(TableArrayHandling.AnswersToDbSet <KlokanTestDBExpectedAnswer>(expectedValuesStudentTable, 0, true)); for (int i = 0; i < 3; i++) { expectedAnswers.AddRange(TableArrayHandling.AnswersToDbSet <KlokanTestDBExpectedAnswer>(expectedValuesAnswerTable, i, false)); } if (addMode) { scanItem.Image = ImageHandling.GetImageBytes(scanFilePath, ImageFormat.Png); } scanItem.ExpectedValues = expectedAnswers; scanItem.Correctness = -1; // correctness will only have a valid value once the evaluation is run using (var testDB = new KlokanTestDBContext()) { // when editing an item we first have to delete the old one if (!addMode) { var oldScanItemQuery = from scan in testDB.Scans where scan.ScanId == scanItem.ScanId select scan; var oldExpectedAnswers = from answer in testDB.ExpectedValues where answer.ScanId == scanItem.ScanId select answer; // delete the old expected answers foreach (var answer in oldExpectedAnswers) { testDB.ExpectedValues.Remove(answer); } // assign new expected answers var oldScanItem = oldScanItemQuery.FirstOrDefault(); oldScanItem.ExpectedValues = scanItem.ExpectedValues; oldScanItem.Correctness = -1; } else { KlokanTestDBScan newScanItem = new KlokanTestDBScan { ExpectedValues = scanItem.ExpectedValues, ComputedValues = scanItem.ComputedValues, Image = scanItem.Image, Correctness = -1 }; testDB.Scans.Add(newScanItem); } try { testDB.SaveChanges(); MessageBox.Show(Properties.Resources.InfoTextDatabaseUpdated, Properties.Resources.InfoCaptionDatabaseUpdated, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) when(ex is DbUpdateException || ex is DbUpdateConcurrencyException) { MessageBox.Show(Properties.Resources.ErrorTextDatabase, Properties.Resources.ErrorCaptionGeneral, MessageBoxButtons.OK, MessageBoxIcon.Error); } } PopulateForm(); }
private void updateDatabaseButton_Click(object sender, EventArgs e) { updateDatabaseButton.Enabled = false; var dialogResult = MessageBox.Show(Properties.Resources.PromptTextDatabaseUpdate, Properties.Resources.PromptCaptionDatabaseUpdate, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.No) { return; } // convert the chosen answers into a DbSet List <KlokanDBChosenAnswer> newChosenAnswers = new List <KlokanDBChosenAnswer>(); for (int i = 0; i < 3; i++) { newChosenAnswers.AddRange(TableArrayHandling.AnswersToDbSet <KlokanDBChosenAnswer>(chosenAnswers, i, false)); } int newPoints = points; using (var db = new KlokanDBContext()) { var query = from sheet in db.AnswerSheets where sheet.AnswerSheetId == answerSheetId select sheet; KlokanDBAnswerSheet answerSheet = query.FirstOrDefault(); if (answerSheet == null) { MessageBox.Show(Properties.Resources.ErrorTextSheetNotFoundInDatabase, Properties.Resources.ErrorCaptionGeneral, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // load the old chosen answers so that EF knows it should delete them when the old answer sheet is deleted List <KlokanDBChosenAnswer> blah = new List <KlokanDBChosenAnswer>(answerSheet.ChosenAnswers); KlokanDBAnswerSheet updatedAnswerSheet = new KlokanDBAnswerSheet { StudentNumber = studentNumber, Points = newPoints, Scan = answerSheet.Scan, InstanceId = answerSheet.InstanceId, Instance = answerSheet.Instance, ChosenAnswers = newChosenAnswers }; db.AnswerSheets.Remove(answerSheet); db.AnswerSheets.Add(updatedAnswerSheet); try { db.SaveChanges(); MessageBox.Show(Properties.Resources.InfoTextDatabaseUpdated, Properties.Resources.InfoCaptionDatabaseUpdated, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) when(ex is DbUpdateException || ex is DbUpdateConcurrencyException) { MessageBox.Show(Properties.Resources.ErrorTextDatabase, Properties.Resources.ErrorCaptionGeneral, MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
/// <summary> /// Asynchronously stores results into a database described by KlokanDBContext. /// Instances that already exist in the database are rewritten. /// </summary> /// <param name="results">Any enumerable structure of evaluation results.</param> /// <returns>A void task.</returns> async Task OutputResultsDB(IEnumerable <Result> results) { using (var db = new KlokanDBContext()) { foreach (var result in results) { if (result.Error == true) { failedSheets++; continue; } // find out if the instance this result belongs to is new or if it already exists var query = from instance in db.Instances where instance.Year == result.Year && instance.Category == result.Category select instance; KlokanDBInstance currentInstance = query.FirstOrDefault(); // if the instance isn't saved in the database if (currentInstance == default(KlokanDBInstance)) { // try to search locally too (maybe the instance was added in the previous loop cycle) var querylocal = from instance in db.Instances.Local where instance.Year == result.Year && instance.Category == result.Category select instance; currentInstance = querylocal.FirstOrDefault(); } else { // remove it completely because the new one will rewrite it // lazy loading is used, so we need to load all the relations of an instance if we want Remove() to remove those as well var blah = currentInstance.AnswerSheets; var blah2 = currentInstance.CorrectAnswers; List <ICollection <KlokanDBChosenAnswer> > blah3 = new List <ICollection <KlokanDBChosenAnswer> >(); foreach (var answerSheetBlah in blah) { blah3.Add(answerSheetBlah.ChosenAnswers); } db.Instances.Remove(currentInstance); await db.SaveChangesAsync(progressDialog.GetCancellationToken()); currentInstance = null; } // if the instance doesn't exist locally either if (currentInstance == default(KlokanDBInstance)) { List <KlokanDBCorrectAnswer> correctAnswers = new List <KlokanDBCorrectAnswer>(); for (int i = 0; i < 3; i++) { correctAnswers.AddRange(TableArrayHandling.AnswersToDbSet <KlokanDBCorrectAnswer>(result.CorrectAnswers, i, false)); } currentInstance = new KlokanDBInstance { Year = result.Year, Category = result.Category, CorrectAnswers = correctAnswers }; db.Instances.Add(currentInstance); } List <KlokanDBChosenAnswer> chosenAnswers = new List <KlokanDBChosenAnswer>(); for (int i = 0; i < 3; i++) { chosenAnswers.AddRange(TableArrayHandling.AnswersToDbSet <KlokanDBChosenAnswer>(result.ChosenAnswers, i, false)); } var answerSheet = new KlokanDBAnswerSheet { StudentNumber = result.StudentNumber, Points = result.Score, ChosenAnswers = chosenAnswers, Scan = ImageHandling.GetImageBytes(result.SheetFilename, ImageFormat.Png) }; currentInstance.AnswerSheets.Add(answerSheet); } await db.SaveChangesAsync(progressDialog.GetCancellationToken()); } }