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