public IList <StudentRank> FillStuRank(IList <StudentRank> list)
{
SqlFuns sf = new SqlFuns();
foreach (StudentRank tmp in list)
{
tmp.StrRank = sf.SearchRank(tmp.Rank).Name;
}
return(list);
}
public IList <Requirement> FillRequirement(IList <Requirement> list)
{
SqlFuns sf = new SqlFuns();
foreach (Requirement tmp in list)
{
tmp.StrCourse = sf.SearchCourseID(tmp.Course).Name;
}
return(list);
}
public IList <Attendance> FillAttendance(IList <Attendance> list)
{
SqlFuns sf = new SqlFuns();
foreach (Attendance tmp in list)
{
tmp.StrStudent = sf.SearchStudent(tmp.Student).Name;
tmp.StrCourse = sf.SearchCourseID(tmp.Course).Name;
}
return(list);
}
public IList <Timetable> FillTimetable(IList <Timetable> list)
{
SqlFuns sf = new SqlFuns();
foreach (Timetable tmp in list)
{
tmp.StrCourseName = sf.SearchCourseID(tmp.Course).Name;
tmp.StrCourseTime = tmp.Starttime / 60 + ":" + tmp.Starttime % 60 + " - " + tmp.Endtime / 60 + ":" + tmp.Endtime % 60;
}
return(list);
}
public IList <Payment> FillPayment(IList <Payment> list)
{
SqlFuns sf = new SqlFuns();
foreach (Payment tmp in list)
{
tmp.StrStuName = sf.SearchStudent(tmp.Stnum).Name;
tmp.StrPayFor = sf.SearchPayFor(tmp.Payfor).Description;
}
return(list);
}
public Member UsrInfo(string us)
{
try
{
SqlFuns sf = new SqlFuns();
return(sf.SearchMemberUSR(us));
}
catch
{
return(null);
}
}
/// <summary>
/// Login the System
/// </summary>
/// <param name="us">User's Information, must include username and password</param>
/// <returns>username</returns>
public Member UserLogin(string us, string pwd)
{
try
{
SqlFuns sf = new SqlFuns();
Member tmp = sf.SearchMemberUSR(us);
if (tmp.Pwd == pwd)
{
tmp.Pwd = "";
return(tmp);
}
else
{
return(null);
}
}
catch
{
return(null);
}
}