public static List <StaffMemeber> GetAllLecturers()
{
List <StaffMemeber> list = new List <StaffMemeber>();
using (SqlConnection sConn = new SqlConnection(Globals.connString))
{
string query = "SELECT * FROM Users";
SqlCommand sqlCmd = new SqlCommand(query, sConn);
try
{
sConn.Open();
SqlDataReader sReader = sqlCmd.ExecuteReader();
while (sReader.Read())
{
StaffMemeber temp = new StaffMemeber();
if (sReader["Type"].ToString() == "Lecturer")
{
temp.Name = sReader["Name"].ToString();
temp.ID = sReader["ID"].ToString();
list.Add(temp);
}
}
}
catch (Exception ex) { throw ex; }
}
return(list);
}
public static List <Course> GetStudentCourses(StaffMemeber staff)
{
List <Course> list = new List <Course>();
using (SqlConnection sConn = new SqlConnection(Globals.connString))
{
string query = "SELECT * FROM Courses";
SqlCommand sqlCmd = new SqlCommand(query, sConn);
try
{
sConn.Open();
SqlDataReader sReader = sqlCmd.ExecuteReader();
while (sReader.Read())
{
if (sReader["Lecturer"].ToString() == staff.ID)
{
Course temp = new Course();
temp.ID = (int)sReader["CourseID"];
temp.Name = sReader["CourseName"].ToString();
temp.Lecturer = new StaffMemeber();
temp.Lecturer.Name = staff.Name;
temp.Must = (Boolean)sReader["Must"];
if ((int)sReader["NumOfPractices"] > 0)
{
temp.haveprac = true;
}
else
{
temp.haveprac = false;
}
if ((int)sReader["NumOfLabs"] > 0)
{
temp.havelab = true;
}
else
{
temp.havelab = false;
}
list.Add(temp);
}
}
}
catch (Exception ex) { throw ex; }
}
return(list);
}
public static List <Event> GetPracts(Course crs)
{
List <Event> practs = new List <Event>();
using (SqlConnection sConn = new SqlConnection(Globals.connString))
{
string query = "SELECT * FROM TeachingExercises " +
" WHERE CourseName LIKE '" + crs.Name + "'" +
" and type like 'Practice'";
SqlCommand sqlCmd = new SqlCommand(query, sConn);
try
{
sConn.Open();
try
{
SqlDataReader sReader = sqlCmd.ExecuteReader();
while (sReader.Read())
{
Event ev = new Event();
ev.EventType = "Practice";
//ev.EventStaffMemeber = sReader["name"];
ev.ParentCourse = crs;
ev.ID = (int)sReader["ID"];
if (GetUser(sReader["Practitioner"].ToString()) != null)
{
StaffMemeber sf = new StaffMemeber(GetUser(sReader["Practitioner"].ToString()));
ev.EventStaffMemeber = sf;
}
ev.StartTime = int.Parse((sReader["StartTime"].ToString().Split(':'))[0]);
ev.EndTime = int.Parse((sReader["EndTime"].ToString().Split(':'))[0]);
ev.Day = int.Parse(sReader["Day"].ToString());
ev.Room = sReader["Class"].ToString();
practs.Add(ev);
}
sReader.Close();
}
catch (Exception ex) { throw ex; }
}
catch (Exception ex) { throw ex; }
}
return(practs);
}
