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); } }