public static TrimesterCommentModel Read(int trimester, StudentViewModel student)
{
TrimesterCommentModel TrimesterComment = null;
using (SqlConnection connection = new SqlConnection(Settings.Default.SQLConnection))
{
connection.Open();
using (SqlCommand command = new SqlCommand($"SELECT * FROM [TrimesterComment] WHERE IdStudent = '{student.Id}' AND Trimester = {trimester} AND [Year] = {student.Year}", connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
TrimesterComment = new TrimesterCommentModel()
{
Id = (int)reader["Id"],
DivisionPrefectComment = (string)reader["DivisionPrefectComment"],
MainTeacherComment = (string)reader["MainTeacherComment"],
IdStudent = student.Id,
Trimester = trimester,
Year = student.Year,
};
}
}
}
}
return(TrimesterComment);
}
public static void Save(TrimesterCommentModel trimesterComment)
{
using (SqlConnection connection = new SqlConnection(Settings.Default.SQLConnection))
{
connection.Open();
string query = "";
if (trimesterComment.Id == 0)
{
query = "INSERT INTO [TrimesterComment]([Year], MainTeacherComment, DivisionPrefectComment, Trimester, IdStudent)"
+ $" VALUES({trimesterComment.Year}, '{trimesterComment.MainTeacherComment.Replace("'", "''")}', '{trimesterComment.DivisionPrefectComment.Replace("'", "''")}',"
+ $" {trimesterComment.Trimester}, {trimesterComment.IdStudent})";
}
else
{
query = $"UPDATE [TrimesterComment] SET MainTeacherComment = '{trimesterComment.MainTeacherComment.Replace("'", "''")}', DivisionPrefectComment = '{trimesterComment.DivisionPrefectComment.Replace("'", "''")}',"
+ $" Trimester = {trimesterComment.Trimester}, IdStudent = {trimesterComment.IdStudent} WHERE Id = {trimesterComment.Id} AND [Year] = {trimesterComment.Year}";
}
using (SqlCommand command = new SqlCommand(query, connection))
{
command.ExecuteNonQuery();
}
}
}