public override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
_loader = Activity as MainActivity.ILoadingToolbarShower;
_viewModel = ServiceLocator.GetService <ClassScheduleViewModel>();
_viewModel.PropertyChanged += ViewModelOnPropertyChanged;
_viewModel.ExceptionOccured += ViewModelExceptionOccured;
}
public JsonResult GetClassSchedulByDepartmentId(Department department)
{
var getCourseByDeptId = (from course in db.Courses
join semester in
db.Semesters on course.SemesterId equals semester.Id
where course.DepartmentId == department.Id
select new
{
Id = course.Id,
Code = course.Code,
Name = course.Name,
SemesterNo = semester.SemesterNo
}).ToList();
List <ClassScheduleViewModel> aClassScheduleViewModels = new List <ClassScheduleViewModel>();
foreach (var data in getCourseByDeptId)
{
//CourseStaticsViewModel aCourseStaticsViewModel = new CourseStaticsViewModel();
ClassScheduleViewModel aClassScheduleViewModel = new ClassScheduleViewModel();
aClassScheduleViewModel.Code = data.Code;
aClassScheduleViewModel.Name = data.Name;
int courseId = data.Id;
var getScheduleInfo = (from allocatedRoom in db.RoomAllocations
join room in db.RoomInfos on allocatedRoom.RoomId equals room.Id
join day in db.Days on allocatedRoom.DayId equals day.Id
where allocatedRoom.CourseId == courseId &&
allocatedRoom.IsUnAllocated == false
select new
{
RoomNo = room.RoomNo,
DayName = day.DayName,
StarTime = allocatedRoom.StarTime,
EndTime = allocatedRoom.EndTime
}).ToList();
List <string> scheduleList = new List <string>();
if (getScheduleInfo.Count > 0)
{
foreach (var schedule in getScheduleInfo)
{
string ganerateSchedule = " R. No : " + schedule.RoomNo + "," + " Day : " +
schedule.DayName + ", " + schedule.StarTime.ToString("h:mm tt") + " - " + schedule.EndTime.ToString("h:mm tt") + ";" + "<br/>";
scheduleList.Add(ganerateSchedule);
}
}
else
{
string ganerateSchedule = "Not Scheduled Yet";
scheduleList.Add(ganerateSchedule);
}
aClassScheduleViewModel.Schedule = scheduleList;
aClassScheduleViewModels.Add(aClassScheduleViewModel);
}
return(Json(aClassScheduleViewModels));
}
// GET: Schedule
public ActionResult Index(string unitCode)
{
unitCode = "SIT321";
ClassScheduleViewModel classScheduleViewModel = new ClassScheduleViewModel();
List <Lecture> classLecture = db.Lectures.Where(e => e.UnitCode == unitCode).ToList();
classScheduleViewModel.classLecture = classLecture;
classScheduleViewModel.unitCode = unitCode;
ViewData.Model = classScheduleViewModel;
return(View());
}
public async Task <IHttpActionResult> PostScheduleClass(ClassScheduleViewModel model)
{
if (ModelState.IsValid)
{
try
{
await _classes.ScheduleClass(model.ClassId, model.ScheduleId);
return(Ok());
}
catch (Exception)
{
//
}
}
return(BadRequest(ModelState));
}
public List <ClassScheduleViewModel> GetAllCoursesByDepartment(DepartmentModel depertmnet)
{
connection.ConnectionString = connectionString;
string query = @"SELECT AllocateRoom.DepartmnetId as dId, AllocateRoom.CourseId as cId, Course.CourseCode as cCode, Course.CourseName as cName, [ClassRoom.Day].DayName+' '+ ClassRoom.RoomNo+' '+ AllocateRoom.FromTime+'-'+ AllocateRoom.ToTime as ScheduleInfo
FROM AllocateRoom INNER JOIN
Course ON AllocateRoom.CourseId = Course.CourseId INNER JOIN
ClassRoom ON AllocateRoom.ClassRoomId = ClassRoom.RoomId INNER JOIN
[ClassRoom.Day] ON AllocateRoom.DayId = [ClassRoom.Day].DayId
WHERE (DepartmentId='" + depertmnet.DepartmentId + "')";
SqlCommand command = new SqlCommand(query, connection);
List <ClassScheduleViewModel> coursesCheduleList = new List <ClassScheduleViewModel>();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ClassScheduleViewModel classSchedule = new ClassScheduleViewModel();
classSchedule.DepartmentId = Convert.ToInt32(reader["dId"].ToString());
classSchedule.CourseId = Convert.ToInt32(reader["cId"].ToString());
classSchedule.CourseCode = reader["cCode"].ToString();
classSchedule.CourseName = reader["cName"].ToString();
classSchedule.ScheduleInfo = reader["ScheduleInfo"].ToString();
//classSchedule.CourseCode = reader["CourseCode"].ToString();
//classSchedule.CourseName = reader["CourseName"].ToString();
//classSchedule.RoomNo = reader["RoomNo"].ToString();
//classSchedule.DayName = reader["DayName"].ToString();
//classSchedule.Totime = reader["ToTime"].ToString();
//classSchedule.FromTime = reader["FromTime"].ToString();
coursesCheduleList.Add(classSchedule);
}
}
reader.Close();
connection.Close();
return(coursesCheduleList);
}
public IEnumerable <ClassScheduleViewModel> GetClassSchedule(int departmentId)
{
connection = new SqlConnection(connectionString);
string query = "select Code,name, COALESCE(NameValues,'Not Schedule Yet')as schedule from ClassSchedule where DepartmentId='" + departmentId + "'";
command = new SqlCommand(query, connection);
List <ClassScheduleViewModel> courses = new List <ClassScheduleViewModel>();
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
ClassScheduleViewModel course = new ClassScheduleViewModel();
{
//course.Id = Convert.ToInt32(reader["Id"].ToString());
course.Code = (string)reader["Code"];
course.Name = (string)reader["name"];
course.Schedule = (string)reader["schedule"];
}
courses.Add(course);
}
reader.Close();
return(courses);
}
public List <ClassScheduleViewModel> GetAllClassSheduleIntoList()
{
connection.ConnectionString = connectionString;
List <ClassScheduleViewModel> sheduleIntoList = new List <ClassScheduleViewModel>();
string query = "SELECT * FROM ClassSchedule";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader Reader = command.ExecuteReader();
while (Reader.Read())
{
ClassScheduleViewModel classSheduleIntoModel = new ClassScheduleViewModel();
classSheduleIntoModel.DepartmentId = Convert.ToInt32(Reader["DepartmentId"].ToString());
classSheduleIntoModel.CourseId = Convert.ToInt32(Reader["Id"].ToString());
classSheduleIntoModel.CourseCode = Reader["Code"].ToString();
classSheduleIntoModel.CourseName = Reader["Name"].ToString();
classSheduleIntoModel.ScheduleInfo = Reader["ScheduleInfo"].ToString();
sheduleIntoList.Add(classSheduleIntoModel);
}
Reader.Close();
connection.Close();
return(sheduleIntoList);
}
