public TechnicalFailure(int serialNum, DateTime openDT, ActivityRoom roomId, Employee employeeId, string description)
{
this.serialNum = serialNum;
this.openDT = openDT;
this.roomId = roomId;
this.employeeId = employeeId;
this.description = description;
}
public EmbedActivityToActivityRoom(int embededId, ActivityRoom roomId, Activity activityId)
{
this.embededId = embededId;
this.roomId = roomId;
this.activityId = activityId;
Program.EmbedActivitiesToActivityRooms.Add(this);
}
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_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);
}
}