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); }