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