public List <ClassScheduleFinal> GetFinalClassScheduleByDeptId(int deptId)
{
List <ClassRoutineView> classRoutineViews = GenerateTemporaryClassScheduleByDeptId(deptId);
List <ClassScheduleFinal> classScheduleFinals = new List <ClassScheduleFinal>();
if (classRoutineViews.Count == 0)
{
return(classScheduleFinals);
}
string info = "";
string code = classRoutineViews[0].CourseCode;
string name = classRoutineViews[0].CourseName;
info += GetFullInformation(classRoutineViews[0]);
var temp = code;
for (int i = 1; i < classRoutineViews.Count; i++)
{
ClassRoutineView aClassScheduleTemp = classRoutineViews[i];
if (aClassScheduleTemp.CourseCode != temp)
{
ClassScheduleFinal aClassScheduleFinal = new ClassScheduleFinal();
aClassScheduleFinal.CourseCode = code;
aClassScheduleFinal.CourseName = name;
if (info == "")
{
aClassScheduleFinal.Info = "not scheduled yet";
}
else
{
aClassScheduleFinal.Info = info;
}
classScheduleFinals.Add(aClassScheduleFinal);
code = aClassScheduleTemp.CourseCode;
name = aClassScheduleTemp.CourseName;
info = "";
}
info += GetFullInformation(aClassScheduleTemp);
temp = aClassScheduleTemp.CourseCode;
}
ClassScheduleFinal aClassScheduleFinal2 = new ClassScheduleFinal();
aClassScheduleFinal2.CourseCode = code;
aClassScheduleFinal2.CourseName = name;
if (info == "")
{
aClassScheduleFinal2.Info = "not scheduled yet";
}
else
{
aClassScheduleFinal2.Info = info;
}
classScheduleFinals.Add(aClassScheduleFinal2);
return(classScheduleFinals);
}
public string GetFullInformation(ClassRoutineView classRoutineView)
{
string information = String.Empty;
if (classRoutineView.Flag != "1")
{
return(information);
}
information += "Room No.: " + classRoutineView.RoomNo + ", Day : " + classRoutineView.Day + ", ";
information += " Time : " + ConvertTime(classRoutineView.From);
information += " - " + ConvertTime(classRoutineView.To);
information += ";<br/><br/>";
return(information);
}
public List <ClassRoutineView> GenerateTemporaryClassScheduleByDeptId(int deptId)
{
List <ClassRoutineView> classRoutineViews = new List <ClassRoutineView>();
Query = "Select * From ClassRoutineView Where DeptId = '" + deptId + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
ClassRoutineView classRoutineView = new ClassRoutineView
{
CourseCode = Reader["CourseCode"].ToString(),
CourseName = Reader["CourseName"].ToString(),
Day = Reader["Day"].ToString(),
RoomNo = Reader["RoomNo"].ToString()
};
if (!(Reader["FromTime"] is DBNull))
{
classRoutineView.From = Convert.ToInt32(Reader["FromTime"]);
}
if (!(Reader["ToTime"] is DBNull))
{
classRoutineView.To = Convert.ToInt32(Reader["ToTime"]);
}
classRoutineView.Flag = Reader["Flag"].ToString();
classRoutineViews.Add(classRoutineView);
}
Reader.Close();
Connection.Close();
return(classRoutineViews);
}
