public void DataBaseChangeGrade(ChangeGradeProcedure grade)
{
if (grade.GradeStatus == "o")
{
command = new MySqlCommand($"call odrzuc_reklamacje({grade.StudentID}, {grade.GroupID}, {grade.currentUser});", this.conection);
}
else if (grade.GradeStatus == "p")
{
command = new MySqlCommand($"call popraw_ocene('{grade.NewGrade}' ,{grade.StudentID}, {grade.GroupID}, {grade.currentUser});", this.conection);
}
adapter.InsertCommand = command;
adapter.InsertCommand.ExecuteNonQuery();
command.Dispose();
}
private void ChangeGrade()
{
string errorMessage = "";
if (!DataValidation.DataValidation.ValidLecturerGradeStatus(tableRowContentList[5].Text, out errorMessage))
{
AlertWindow alertWindow = new AlertWindow(errorMessage);
alertWindow.ShowDialog();
return;
}
if (tableRowContentList[5].Text == "w")
{
AlertWindow alertWindow = new AlertWindow("Student ma już wprowadzoną ocenę. Możesz więc ją zmienić tylko używając statusu 'o' lub 'p'.");
alertWindow.ShowDialog();
return;
}
if (!DataValidation.DataValidation.ValidGrade(tableRowContentList[4].Text, out errorMessage))
{
AlertWindow alertWindow = new AlertWindow(errorMessage);
alertWindow.ShowDialog();
return;
}
ChangeGradeProcedure grade = new ChangeGradeProcedure();
grade.StudentID = int.Parse(tableRowContentList[0].Text);
grade.GroupID = int.Parse(tableRowContentList[2].Text);
grade.NewGrade = tableRowContentList[4].Text;
grade.GradeStatus = tableRowContentList[5].Text;
grade.currentUser = signInUser.UserID;
DbService.DataBaseChangeGrade(grade);
AlertWindow alertWindow2 = new AlertWindow("Zmiana oceny przebiegła pomyślnie.");
alertWindow2.ShowDialog();
CreateOcenianie();
}
