private void deleteButton_Click(object sender, RoutedEventArgs e)
{
using (var context = new Model.DB())
{
var resultId = (int)((dynamic)dataGrid.SelectedItems[0]).ResultId;
var partId = (int)((dynamic)dataGrid.SelectedItems[0]).PartId;
var result = context.StrupPartResults.First(p => p.PartResultId == partId && p.TestResult.ResultId == resultId);
context.StrupPartResults.Remove(result);
var deleteTests = new List<StrupResult>();
foreach (var r in context.StrupTestResults)
{
if (r.Parts.Count == 0)
{
deleteTests.Add(r);
}
}
if (deleteTests.Count != 0)
{
context.StrupTestResults.RemoveRange(deleteTests);
}
context.SaveChanges();
}
UpdateGrid();
}
private void importButton_Click(object sender, RoutedEventArgs e)
{
var app = new Microsoft.Office.Interop.Excel.Application();
var workbook = app.Workbooks.Add();
var worksheet = workbook.Worksheets[1];
worksheet.Cells[1, 1] = "Ім'я";
worksheet.Cells[1, 2] = "Дата і час";
worksheet.Cells[1, 3] = "Кількість помилок";
worksheet.Cells[1, 4] = "Витрачений час";
worksheet.Cells[1, 5] = "Результат";
using (var context = new Model.DB())
{
var results = context.ConfusedLinesTestResults.ToList();
for (int i = 0; i < results.Count(); i++)
{
worksheet.Cells[i + 2, 1] = results[i].Name;
worksheet.Cells[i + 2, 2] = results[i].Date;
worksheet.Cells[i + 2, 3] = results[i].ErrorsCount;
worksheet.Cells[i + 2, 4] = results[i].Time;
worksheet.Cells[i + 2, 5] = results[i].Result;
}
}
app.Visible = true;
}
private void deleteButton_Click(object sender, RoutedEventArgs e)
{
using (var context = new Model.DB())
{
var resultId = (int)((dynamic)dataGrid.SelectedItems[0]).ResultId;
var result = context.NumberSortTestResults.First(r => r.ResultId == resultId);
context.NumberSortTestResults.Remove(result);
context.SaveChanges();
}
UpdateGrid();
}
private void UpdateGrid()
{
using (var context = new Model.DB())
{
var querry = from r in context.NumberSortTestResults
select new
{
ResultId = r.ResultId,
Name = r.Name,
Date = r.Date,
ErrorsCount = r.ErrorCount,
Time = r.Time
};
dataGrid.ItemsSource = querry.ToList();
dataGrid.ColumnWidth = DataGridLength.Auto;
}
}
private void UpdateGrid()
{
using (var context = new Model.DB())
{
var querry = from r in context.StrupTestResults
join p in context.StrupPartResults
on r.ResultId equals p.TestResult.ResultId
select new
{
ResultId = r.ResultId,
PartId = p.PartResultId,
Name = r.Name,
Date = r.Date,
Part = p.Part,
QuestionCount = p.QuestionsCount,
ErrorsCount = p.ErrorsCount,
Time = p.Time
};
dataGrid.ItemsSource = querry.ToList();
dataGrid.ColumnWidth = DataGridLength.Auto;
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
if (startButton.Content.ToString() == "Старт")
{
startButton.Content = "Стоп";
foreach (var item in answers)
{
item.Key.IsEnabled = true;
}
timer.Start();
startTime = DateTime.Now;
resultPanel.Visibility = Visibility.Hidden;
}
else if (startButton.Content.ToString() == "Стоп")
{
startButton.Content = "Завершити тест";
timerBox.Content = "";
timer.Stop();
var answersCount = CheckAnswers(answers);
var finishTime = (DateTime.Now - startTime).TotalSeconds;
resultPanel.Visibility = Visibility.Visible;
errorCountResultLabel.Content = 25 - answersCount;
timeResultLabel.Content = finishTime.ToString("F3");
if (answersCount >= 19)
{
resultResultLabel.Content = "Чудово";
}
else if (answersCount >= 10)
{
resultResultLabel.Content = "Добре";
}
else if (answersCount >= 4)
{
resultResultLabel.Content = "Задовільно";
}
else
{
resultResultLabel.Content = "Незадовільно";
}
using (var db = new Model.DB())
{
var result = new ConfusedLinesTestResult()
{
Date = DateTime.Now,
ErrorsCount = 25 - answersCount,
Name = name,
Time = finishTime,
Result = resultResultLabel.Content.ToString()
};
db.ConfusedLinesTestResults.Add(result);
db.SaveChanges();
}
foreach (var item in answers)
{
item.Key.Text = "";
item.Key.IsEnabled = false;
}
}
else if (startButton.Content.ToString() == "Завершити тест")
{
Close();
}
}
public UsuarioController(Model.DB dbContext)
{
db = dbContext;
}
public AlimentoController(Model.DB dbContext)
{
db = dbContext;
}
private void startButton_Click(object sender, RoutedEventArgs e)
{
if (startButton.Content.ToString() == "Старт")
{
numbers = GetNumbers();
for (int i = 0; i < numbers.Count; i++)
{
buttons[i].Content = numbers[i];
}
ResultPanel.Visibility = Visibility.Hidden;
timer.Start();
startTime = DateTime.Now;
startButton.Content = "Стоп";
}
else if (startButton.Content.ToString() == "Стоп")
{
for (int i = 0; i < numbers.Count; i++)
{
buttons[i].Content = "";
}
CheckResult();
timer.Stop();
timerLabel.Content = "";
ResultPanel.Visibility = Visibility.Visible;
var timeElapsed = (DateTime.Now - startTime).TotalSeconds;
timeResultLabel.Content = timeElapsed.ToString("F3");
errorResultLabel.Content = errors;
using (var db = new Model.DB())
{
var result = new NumberSortResult()
{
Name = name,
ErrorCount = errors,
Time = timeElapsed
};
db.NumberSortTestResults.Add(result);
db.SaveChanges();
}
numbers = null;
answersList = new List<int>();
answeredButtons = new List<Button>();
answer = "";
errors = 0;
startButton.Content = "Завершити тест";
}
else if (startButton.Content.ToString() == "Завершити тест")
{
Close();
}
}
private async void StartButton_Click(object sender, RoutedEventArgs e)
{
if (StartButton.Content.ToString() == "Старт")
{
StartButton.Content = "Стоп";
startTime = DateTime.Now;
errorCount = 0;
currentWord = 0;
timer.Start();
NextQuestion();
Buttons.IsEnabled = true;
resultGrid.Visibility = Visibility.Hidden;
}
else if (StartButton.Content.ToString() == "Стоп")
{
if (currentPart == 3)
{
StartButton.Content = "Завершити тест";
}
else
{
StartButton.Content = "Наступна частина";
}
finishTime = DateTime.Now;
Buttons.IsEnabled = false;
wordsResultCountLabel.Content = wordsCount;
errorsResultCountLabel.Content = errorCount;
timeResultLabel.Content = (finishTime - startTime).TotalSeconds.ToString("F3");
resultGrid.Visibility = Visibility.Visible;
timer.Stop();
timerLabel.Content = "";
result.Parts.Add(new PartResult()
{
ErrorsCount = errorCount,
QuestionsCount = wordsCount,
Part = currentPart,
Time = (finishTime - startTime).TotalSeconds
});
}
else if (StartButton.Content.ToString() == "Наступна частина")
{
currentPart++;
StartPart(currentPart);
StartButton.Content = "Старт";
answer1Button.Content = "";
answer2Button.Content = "";
answer3Button.Content = "";
answer4Button.Content = "";
wordBox.Text = "";
resultGrid.Visibility = Visibility.Hidden;
timerLabel.Content = "00:00";
}
else if (StartButton.Content.ToString() == "Завершити тест")
{
using (var context = new Model.DB())
{
context.StrupTestResults.Add(result);
await context.SaveChangesAsync();
StartButton.IsEnabled = false;
}
Close();
}
}
private void importButton_Click(object sender, RoutedEventArgs e)
{
var app = new Microsoft.Office.Interop.Excel.Application();
var workbook = app.Workbooks.Add();
var worksheet = workbook.Worksheets[1];
worksheet.Cells[1, 1] = "Ім'я";
worksheet.Cells[1, 2] = "Дата і час";
worksheet.Cells[1, 3] = "Номер тесту";
worksheet.Cells[1, 4] = "Кількість запитань";
worksheet.Cells[1, 5] = "Кількість помилок";
worksheet.Cells[1, 6] = "Витрачений час";
using (var context = new Model.DB())
{
var results = (from r in context.StrupTestResults
join p in context.StrupPartResults
on r.ResultId equals p.TestResult.ResultId
select new
{
Name = r.Name,
Date = r.Date,
Part = p.Part,
QuestionCount = p.QuestionsCount,
ErrorsCount = p.ErrorsCount,
Time = p.Time
}).ToList();
for (int i = 0; i < results.Count(); i++)
{
worksheet.Cells[i + 2, 1] = results[i].Name;
worksheet.Cells[i + 2, 2] = results[i].Date;
worksheet.Cells[i + 2, 3] = results[i].Part;
worksheet.Cells[i + 2, 4] = results[i].QuestionCount;
worksheet.Cells[i + 2, 5] = results[i].ErrorsCount;
worksheet.Cells[i + 2, 6] = results[i].Time;
}
}
app.Visible = true;
}
public SaidaController(Model.DB dbContext)
{
db = dbContext;
}
public EstoqueController(Model.DB dbContext)
{
db = dbContext;
}
public EntradaController(Model.DB dbContext)
{
db = dbContext;
}
