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