private void Set_Lecturer(Lecturer lec) { lecturer = lec; lecDB = new LecturersDB(); lecturers_lst = new List <Lecturer>(); lbl_Update.Text = "עדכון מרצה"; }
private void button1_Click(object sender, EventArgs e) { pnl_Update_Main.Visible = false; pnl_User_Select.Visible = false; lecturer = null; tutor = null; student = null; lecDB = null; tutDB = null; stuDB = null; }
public Requests_Lecturers2(string userName, String password) { InitializeComponent(); //this.Show(); users_db = new UsersDB(); user = new User(); users_db.FindUser(userName, password, ref user, "Lecturers"); //MessageBox.Show(user.GetType() + user.GetUserType()); string id = ""; id = user.Get_ID(); lecturers_db = new LecturersDB(); lecturers_db.Get_Lecturer_Courses(this.cbo_Courses, id); }
private void Load_Secretary_List() { int size = 0; lecDB = null; tutDB = null; stuDB = null; secDB = new SecretarysDB(); secreatarys_lst = secDB.Get_All_Secretary(); size = secreatarys_lst.Count(); for (int i = 0; i < size; i++) { cbo_User_Select_ID.Items.Add(secreatarys_lst[i].getID()); } }
private void Load_Tutor_List() { int size = 0; lecDB = null; stuDB = null; secDB = null; tutDB = new TutorsDB(); tutors_lst = tutDB.Get_All_Tutors(); size = tutors_lst.Count(); for (int i = 0; i < size; i++) { cbo_User_Select_ID.Items.Add(tutors_lst[i].getID()); } }
private void Load_Lecturer_List() { int size = 0; tutDB = null; stuDB = null; secDB = null; lecDB = new LecturersDB(); lecturers_lst = lecDB.Get_All_Lecturers(); size = lecturers_lst.Count(); for (int i = 0; i < size; i++) { cbo_User_Select_ID.Items.Add(lecturers_lst[i].getID()); } }
public List <Lecturer> Get_Lecturers_For_Grades(List <StudentGrade> grades, List <int> coursesID) { List <Lecturer> lecturers = new List <Lecturer>(); LecturersDB lecDB = new LecturersDB(); List <string> lecNames = new List <string>(); try { con.OpenCon(); int size = grades.Count(); for (int i = 0; i < size; i++) { com = new SqlCommand("SELECT * FROM ActiveCourses WHERE IDActiveCourse = '" + grades[i].Get_Course_ID() + "' AND type = 'Lecture'", con.GetCon()); SqlDataReader rdr = com.ExecuteReader(); while (rdr.Read()) { lecNames.Add(rdr["nameOfLecOrTut"].ToString()); coursesID.Add(Convert.ToInt32(rdr["IDActiveCourse"].ToString())); } rdr.Close(); } size = lecNames.Count(); for (int i = 0; i < size; i++) { lecturers.Add(lecDB.Get_Lecturer_By_Full_Name(lecNames[i])); } } catch (Exception ex) { MessageBox.Show(ex.Message); } con.CloseCon(); return(lecturers); }
private void btn_Lecturer_Main_Back_Click(object sender, EventArgs e) { if (lecturer != null) { lecturer = null; lecDB = null; } else if (tutor != null) { tutor = null; tutDB = null; } else if (student != null) { student = null; stuDB = null; } else if (secretary != null && admin == false) { secretary = null; secDB = null; } if (admin) { pnl_User_Select.Visible = true; txtB_User_Select_LName.Clear(); txtB_User_Select_LName.ResetText(); txtB_User_Select_PName.Clear(); txtB_User_Select_PName.ResetText(); cbo_User_Select_ID.ResetText(); cbo_User_Select_ID.Items.Clear(); Load_Users(); } }