public List <AllocateClassSchedule> GetAllClassSchedulesByDeparmentId(int departmentId, int courseId)
{
List <AllocateClassSchedule> scheduleList = new List <AllocateClassSchedule>();
CommandObj.CommandText = "SELECT * FROM ScheduleOfClassView WHERE DepartmentId= @DepartmentId AND CourseId=@CourseId AND AllocationStatus= 1 ";
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("DepartmentId", departmentId);
CommandObj.Parameters.AddWithValue("CourseId", courseId);
ConnectionObj.Open();
SqlDataReader reader = CommandObj.ExecuteReader();
while (reader.Read())
{
AllocateClassSchedule schedule = new AllocateClassSchedule
{
DepartmentId = Convert.ToInt32(reader["DepartmentId"].ToString()),
CourseCode = reader["Code"].ToString(),
CourseName = reader["Name"].ToString(),
RoomName = reader["Room_Name"].ToString(),
DayName = reader["Day_Name"].ToString(),
StartTime = Convert.ToDateTime(reader["StartTime"].ToString()),
EndTime = Convert.ToDateTime(reader["EndTime"].ToString()),
Status = Convert.ToBoolean(reader["AllocationStatus"])
};
scheduleList.Add(schedule);
}
reader.Close();
ConnectionObj.Close();
CommandObj.Dispose();
return(scheduleList);
}
public List <AllocateClassSchedule> GetAllAllocateClassSchedules()
{
List <AllocateClassSchedule> scheduleList = new List <AllocateClassSchedule>();
CommandObj.CommandText = "SELECT * FROM ScheduleOfClassView";
ConnectionObj.Open();
SqlDataReader reader = CommandObj.ExecuteReader();
while (reader.Read())
{
AllocateClassSchedule schedule = new AllocateClassSchedule
{
DepartmentId = Convert.ToInt32(reader["DepartmentId"].ToString()),
CourseCode = reader["Code"].ToString(),
CourseName = reader["Name"].ToString(),
RoomName = reader["Room_Name"].ToString(),
DayName = reader["Day_Name"].ToString(),
StartTime = Convert.ToDateTime(reader["StartTime"].ToString()),
EndTime = Convert.ToDateTime(reader["EndTime"].ToString())
};
scheduleList.Add(schedule);
}
reader.Close();
ConnectionObj.Close();
CommandObj.Dispose();
return(scheduleList);
}
