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