public PlaceModel getPlacebyPid(int pid)
{
MySqlConnection conn = GetConn.getConn();
PlaceModel pModel = new PlaceModel();
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("select * from `tb_place` where `pid`=@pid", conn);
cmd.Parameters.AddWithValue("@pid", pid);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
pModel.Pid = int.Parse(reader["pid"].ToString());
pModel.Pname = (string)reader["pname"];
}
conn.Close();
return pModel;
}
catch (Exception)
{
conn.Close();
return null;
}
}
public CourseInfo(CourseModel cModel, TeacherModel tModel, PlaceModel pModel, String precName)
{
this.cModel = cModel;
this.tModel = tModel;
this.pModel = pModel;
this.precourseName = precName;
updateCourseInfo();
}
public List<CourseInfo> getTimetable(int sid)
{
int startyear = int.Parse(new StudentBusiness().getStuBySid(sid).Startyear.ToString());
int year = DateTime.Now.Year;
int month = DateTime.Now.Month;
int semester = (month >= 1 && month <= 6) ? 2 * (year - startyear) : 2 * (year - startyear) + 1;
courseModelList = new CourseService().getAllCourseBySid(sid, semester);
if (courseModelList != null)
{
foreach (CourseModel cModel in courseModelList)
{
tModel = new TeacherService().getTeacherByTid(cModel.Tid);
pModel = new PlaceService().getPlacebyPid(cModel.Pid);
precName = (new CourseService().getCoursebyCid(cModel.Precourse)).Cname;
courseInfo = new CourseInfo(cModel, tModel, pModel, precName);
courseInfoList.Add(courseInfo);
}
}
return courseInfoList;
}