public List <timeSlotList> getTimeSlot(int id)
{
bl = new ClassBl();
bo = new ClassBo();
dt = new DataTable();
dt = da.getTimeSlot(id);
List <timeSlotList> list = new List <timeSlotList>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
timeSlotList itlist = new timeSlotList();
itlist.id = dr[bo.id].ToString();
itlist.lecturerToCoursesdId = dr[bo.lecturerToCoursesdId].ToString();
itlist.day = dr[bo.day].ToString();
itlist.timeFrom = dr[bo.timeFrom].ToString();
itlist.timeTo = dr[bo.timeTo].ToString();
itlist.room = dr[bo.room].ToString();
itlist.coursesID = dr[bo.coursesID].ToString();
itlist.coursesName = dr[bo.name].ToString();
itlist.commonName = dr[bo.commonName].ToString();
itlist.status = dr[bo.status].ToString() == "I" ? "Inactive" : "Active";
switch (dr[bo.day].ToString())
{
case "1":
itlist.dayName = "Monday";
break;
case "2":
itlist.dayName = "Tuesday";
break;
case "3":
itlist.dayName = "Wednesday";
break;
case "4":
itlist.dayName = "Thursday";
break;
case "5":
itlist.dayName = "Friday";
break;
default:
break;
}
list.Add(itlist);
}
}
return(list);
}
public int saveTimeSlot(timeSlotList list)
{
bl = new ClassBl();
da = new ClassDa();
dt = new DataTable();
dt = da.checkTimeSlot(list);
if (dt.Rows.Count > 0)
{
return(2);
}
else
{
return(da.saveTimeSlot(list));
}
}
public int saveCourses(coursesList list)
{
bl = new ClassBl();
return(bl.saveCourses(list));
}
public int deleteCourses(int id)
{
bl = new ClassBl();
return(bl.deleteCourses(id));
}
public List <coursesList> getCourse(int id)
{
bl = new ClassBl();
return(bl.getCourse(id, DBNull.Value.ToString()));
}
public List <lecturerList> selectLecturer()
{
bl = new ClassBl();
return(bl.selectLecturer());
}
public int savePerson(personList list)
{
bl = new ClassBl();
return(bl.savePerson(list));
}
public List <personList> getPerson(int id)
{
bl = new ClassBl();
return(bl.getPerson(id, null));
}
public int deletePerson(int id)
{
bl = new ClassBl();
return(bl.deletePerson(id));
}
public int saveLecturer(lecturerList list)
{
bl = new ClassBl();
return(bl.saveLecturer(list));
}
public List <lecturerList> getLecturer(int id)
{
bl = new ClassBl();
return(bl.getLecturer(id));
}
public int deleteLecturer(int id)
{
bl = new ClassBl();
return(bl.deleteLecturer(id));
}
public string getHour(int id, int day)
{
bl = new ClassBl();
return(bl.getHour(id, day));
}
public List <coursesList> selectedCourse(int id)
{
bl = new ClassBl();
return(bl.selectedCourse(id));
}
public List <coursesList> selectCourse()
{
bl = new ClassBl();
return(bl.selectCourse());
}
