public static void create_ParentFeedbak_In_DB(ParentsFeedBack pf)
{
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.SP_create_ParentFeedbak @ID, @StudentId, @DT, @Description ";
c.Parameters.AddWithValue("@ID", pf.getId());
c.Parameters.AddWithValue("@StudentId", pf.getCreator().getId());
c.Parameters.AddWithValue("@DT", pf.getDateTime());
c.Parameters.AddWithValue("@Description", pf.getDescription());
SQL_CON SC = new SQL_CON();
SC.execute_non_query(c);
}
public static void init_ParentFeedback()
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_ParentFeedback";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
parentsFeedback = new List <ParentsFeedBack>();
while (rdr.Read())
{
ParentsFeedBack pf = new ParentsFeedBack(int.Parse(rdr.GetValue(0).ToString()), getStudentObject(rdr.GetValue(1).ToString()), DateTime.Parse((rdr.GetValue(2).ToString())),
rdr.GetValue(3).ToString());
parentsFeedback.Add(pf);
init_Grades(pf.getId());
}
}