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 ParentsFeedBack getParentsFeedbackObject(int id)
{
ParentsFeedBack pfRes = null;
foreach (ParentsFeedBack pf in parentsFeedback)
{
if (pf.getId() == id)
{
pfRes = pf;
}
}
return(pfRes);
}
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());
}
}
public void setParentFeedback(ParentsFeedBack pf)
{
this.parentFeedback = pf;
}
private void Submit_parentFeedback_Click(object sender, EventArgs e)
{
questionnaire.Refresh();
List <Grade> collectGrades = new List <Grade>();
for (int rows = 0; rows < questionnaire.Rows.Count; rows++)
{
int questionId = int.Parse(questionnaire.Rows[rows].Cells[0].Value.ToString());
int count = 0;
int grade = 0;
questionnaire.UpdateCellValue(rows, 2);
if (questionnaire.Rows[rows].Cells[2].Value != null)
{
count = count + 1;
grade = 1;
}
if (questionnaire.Rows[rows].Cells[3].Value != null)
{
count = count + 1;
grade = 2;
}
if (questionnaire.Rows[rows].Cells[4].Value != null)
{
count = count + 1;
grade = 3;
}
if (questionnaire.Rows[rows].Cells[5].Value != null)
{
count = count + 1;
grade = 4;
}
if (questionnaire.Rows[rows].Cells[6].Value != null)
{
count = count + 1;
grade = 5;
}
if (count > 1 || count < 1)
{
MessageBox.Show("Please make sure you are answering all questions", "Message", MessageBoxButtons.OK);
init();
break;
}
else
{
Grade g = new Grade(Program.getQuestionObject(questionId), grade);
collectGrades.Add(g);
}
}
if (collectGrades.Count == questionnaire.Rows.Count)
{
ParentsFeedBack pf = new ParentsFeedBack(Program.parentsFeedback.Count + 1, Program.studUser, DateTime.Now, pfdescription.Text);
Program.parentsFeedback.Add(pf);
Program.create_ParentFeedbak_In_DB(pf);
pf.addGrades(collectGrades);
foreach (Grade gr in collectGrades)
{
gr.setParentFeedback(pf);
Program.create_Grade_In_DB(gr);
}
}
}
public void addStudentParentFeedback(ParentsFeedBack p)
{
parentFeedbacks.Add(p);
}