public static void init_Students()
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_Students";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
students = new List <Student>();
while (rdr.Read())
{
Classes cl = (Classes)Enum.Parse(typeof(Classes), rdr.GetValue(10).ToString());
Student s = new Student(rdr.GetValue(0).ToString(), rdr.GetValue(1).ToString(), rdr.GetValue(2).ToString(), rdr.GetValue(3).ToString(), DateTime.Parse((rdr.GetValue(4).ToString())),
rdr.GetValue(5).ToString(), rdr.GetValue(6).ToString(), rdr.GetValue(7).ToString(), rdr.GetValue(8).ToString(), rdr.GetValue(9).ToString(), cl, int.Parse(rdr.GetValue(11).ToString()), rdr.GetValue(13).ToString());
students.Add(s);
foreach (StudentGroup sg in studentGroups)
{
if (sg.getId().ToString() == rdr.GetValue(12).ToString())
{
s.setStudentGroup(sg);
sg.addStudent(s);
}
}
}
}
public static void init_Brother()
{
foreach (Student s in students)
{
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_Brothers " + s.getId().ToString();
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
while (rdr.Read())
{
s.setBrother(getStudentObject(rdr.GetValue(0).ToString()));
}
}
}
public static void init_contain(int edId)
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_Contain " + edId;
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
while (rdr.Read())
{
contain con = new contain(getEquipmentDemandObject(edId), getProductObject(rdr.GetValue(0).ToString()),
int.Parse(rdr.GetValue(2).ToString()), rdr.GetValue(3).ToString());
getEquipmentDemandObject(edId).addContain(con);
}
}
public static void init_Grades(int pfId)
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_Grades " + pfId;
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
while (rdr.Read())
{
Grade g = new Grade(getQuestionObject(int.Parse(rdr.GetValue(1).ToString())), int.Parse(rdr.GetValue(2).ToString()));
getParentsFeedbackObject(pfId).addGrade(g);
g.setParentFeedback(getParentsFeedbackObject(pfId));
}
}
public static void init_Products()
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_Products";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
products = new List <Product>();
while (rdr.Read())
{
Product p = new Product(rdr.GetValue(0).ToString(), rdr.GetValue(1).ToString());
products.Add(p);
}
}
public static void init_Questions()
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_Questions";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
pfQuestions = new List <Question>();
while (rdr.Read())
{
Question quest = new Question(int.Parse(rdr.GetValue(0).ToString()), rdr.GetValue(1).ToString(), Boolean.Parse((rdr.GetValue(2).ToString())));
pfQuestions.Add(quest);
}
}
public static void init_Note()
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_Note";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
notes = new List <Note>();
while (rdr.Read())
{
Note note = new Note(int.Parse(rdr.GetValue(0).ToString()), DateTime.Parse((rdr.GetValue(1).ToString())),
DateTime.Parse((rdr.GetValue(2).ToString())), rdr.GetValue(3).ToString(), rdr.GetValue(4).ToString(), getEmployeeObject(rdr.GetValue(5).ToString()));
notes.Add(note);
}
}
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 static void init_ActivityFeedback()
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_ActivityFeedbacks";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
activityFeedback = new List <ActivityFeedback>();
while (rdr.Read())
{
ActivityFeedback af = new ActivityFeedback(int.Parse(rdr.GetValue(0).ToString()), DateTime.Parse((rdr.GetValue(1).ToString())),
rdr.GetValue(2).ToString(), getEmployeeObject(rdr.GetValue(3).ToString()), getEmployeeObject(rdr.GetValue(4).ToString()), getStudentObject(rdr.GetValue(5).ToString()));
activityFeedback.Add(af);
getEmployeeObject(rdr.GetValue(3).ToString()).addCreatedActivityFeedback(af);
}
}
public static void init_Employees()
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_Employees";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
employees = new List <Employee>();
while (rdr.Read())
{
EmployeeTypes T = (EmployeeTypes)Enum.Parse(typeof(EmployeeTypes), rdr.GetValue(10).ToString());
Employee e = new Employee(rdr.GetValue(0).ToString(), rdr.GetValue(1).ToString(), rdr.GetValue(2).ToString(), rdr.GetValue(3).ToString(), DateTime.Parse((rdr.GetValue(4).ToString())),
rdr.GetValue(5).ToString(), rdr.GetValue(6).ToString(), DateTime.Parse((rdr.GetValue(7).ToString())), rdr.GetValue(8).ToString(), Boolean.Parse((rdr.GetValue(12).ToString())), T, rdr.GetValue(13).ToString());
employees.Add(e);
Console.WriteLine(e.getId());
}
}
public static void init_StudentGroups()
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_StudentGroups";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
studentGroups = new List <StudentGroup>();
while (rdr.Read())
{
Classes cl = (Classes)Enum.Parse(typeof(Classes), rdr.GetValue(2).ToString());
StudentGroup sg = new StudentGroup(int.Parse(rdr.GetValue(0).ToString()), rdr.GetValue(1).ToString(), cl, int.Parse(rdr.GetValue(3).ToString()),
getEmployeeObject(rdr.GetValue(4).ToString()));
sg.updateMentorGroup();
studentGroups.Add(sg);
getEmployeeObject(rdr.GetValue(4).ToString()).setStudentGroup(sg);
}
}
public static void init_EquipmentDemands()
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_EquipmentDemands";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
equipmentDemands = new List <EquipmentDemand>();
while (rdr.Read())
{
EquipmentDemand ed = new EquipmentDemand(int.Parse(rdr.GetValue(0).ToString()), getEmployeeObject(rdr.GetValue(1).ToString()), DateTime.Parse((rdr.GetValue(5).ToString())), rdr.GetValue(2).ToString());
equipmentDemands.Add(ed);
init_contain(ed.getId());
ed.setStatus(rdr.GetValue(3).ToString());
ed.addApprovalNote(rdr.GetValue(4).ToString());
ed.getCreator().addEquipmentDemand(ed);
}
}
