public static void init_Materials() { SqlCommand c = new SqlCommand(); c.CommandText = "EXECUTE dbo.Get_all_materials"; SQL_CON SC = new SQL_CON(); SqlDataReader rdr = SC.execute_query(c); Materials = new List<Material>(); while (rdr.Read()) { Material m = new ActivityRoom(int.Parse(rdr.GetValue(0).ToString()), rdr.GetValue(1).ToString()); Materials.Add(m); } }
public static void init_Activities() { SqlCommand c = new SqlCommand(); c.CommandText = "EXECUTE dbo.Get_all_activities"; SQL_CON SC = new SQL_CON(); SqlDataReader rdr = SC.execute_query(c); Activities = new List<Activity>(); while (rdr.Read()) { Activity a = new ActivityRoom(int.Parse(rdr.GetValue(0).ToString()), rdr.GetValue(1).ToString(), int.Parse(rdr.GetValue(2).ToString()), int.Parse(rdr.GetValue(3).ToString()), rdr.GetValue(4).ToString()); Activities.Add(a); } }
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()) { Employee e = new Employee(rdr.GetValue(0).ToString(), rdr.GetValue(1).ToString(), rdr.GetValue(2).ToString(), rdr.GetValue(3).ToString(), rdr.GetValue(4).ToString(), int.Parse(rdr.GetValue(5).ToString())); Employees.Add(e); } }
public static void init_TechnicalFailures() { SqlCommand c = new SqlCommand(); c.CommandText = "EXECUTE dbo.Get_all_technicalFailure"; SQL_CON SC = new SQL_CON(); SqlDataReader rdr = SC.execute_query(c); TechnicalFailures = new List<TechnicalFailure>(); while (rdr.Read()) { TechnicalFailure tf = new ActivityRoom(int.Parse(rdr.GetValue(0).ToString()), DateTime.Parse((rdr.GetValue(1).ToString())), DateTime.Parse((rdr.GetValue(2).ToString())), int.Parse(rdr.GetValue(3).ToString()); TechnicalFailures.Add(tf); } }
public static void init_EmbedEmployeesToActivities() { SqlCommand c = new SqlCommand(); c.CommandText = "EXECUTE dbo.Get_all_embedEmployeesToActivities"; SQL_CON SC = new SQL_CON(); SqlDataReader rdr = SC.execute_query(c); EmbedEmployeesToActivities = new List<EmbedEmployeeToActivity>(); while (rdr.Read()) { EmbedEmployeeToActivity eetar = new ActivityRoom(int.Parse(rdr.GetValue(0).ToString()), DateTime.Parse((rdr.GetValue(1).ToString())), DateTime.Parse((rdr.GetValue(2).ToString())), int.Parse(rdr.GetValue(3).ToString()), int.Parse(rdr.GetValue(4).ToString())); EmbedEmployeesToActivities.Add(eetar); } }