public void Update_Grade_After_Appeal_Confirmation(int grade, Appeals_Student appeal) { try { con.OpenCon(); com = new SqlCommand("UPDATE StudentGrades SET Grade = '" + grade + "' WHERE studentID = '" + appeal.Get_Student_ID() + "' AND courseName = '" + appeal.Get_Course_Name() + "'", con.GetCon()); com.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } con.CloseCon(); }
public void Update_After_Lecturer_Review(int ConfirmDeny, Appeals_Student appeal) { try { con.OpenCon(); com = new SqlCommand("UPDATE Student_Appeals SET Status = '" + ConfirmDeny + "' WHERE Student_ID = '" + appeal.Get_Student_ID() + "' AND ActiveCourse_ID = '" + appeal.Get_Course_ID() + "' AND Lecturer_ID = '" + appeal.Get_Lecturer_ID() + "'", con.GetCon()); SqlDataReader rdr = com.ExecuteReader(); while (rdr.Read()) { } rdr.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } con.CloseCon(); }