public List <Requests_Lecturers2> Load_Lecturers()
        {
            List <Requests_Lecturers2> requests = new List <Requests_Lecturers2>();
            Requests_Lecturers2        newRequest;
            //int status = -1;
            string courseName     = "";
            string tempCourseName = "";

            try
            {
                con.OpenCon();
                com = new SqlCommand("SELECT * FROM Requests_Lecturers WHERE Status = -1", con.GetCon());
                SqlDataReader rdr = com.ExecuteReader();

                while (rdr.Read())
                {
                    newRequest = new Requests_Lecturers2();
                    newRequest.SetID(rdr["ID"].ToString());
                    newRequest.Set_FName(rdr["FirstName"].ToString());
                    newRequest.Set_LName(rdr["LastName"].ToString());
                    newRequest.Set_Cancell(Convert.ToInt32(rdr["Cancell"].ToString()));
                    newRequest.Set_Classroom(rdr["Classroom"].ToString());

                    courseName     = "";
                    tempCourseName = rdr["course"].ToString();
                    for (int i = 0; i < tempCourseName.Length; i++)
                    {
                        if (!(tempCourseName[i] == ' ' && tempCourseName[i + 1] == ' '))
                        {
                            courseName += tempCourseName[i];
                        }
                        else
                        {
                            break;
                        }
                    }
                    newRequest.Set_CourseName(courseName);

                    newRequest.Set_Day(rdr["day"].ToString());
                    newRequest.Set_Hour(Convert.ToInt32(rdr["hour"].ToString()));
                    newRequest.Set_Status(Convert.ToInt32(rdr["Status"].ToString()));
                    requests.Add(newRequest);
                }
                con.CloseCon();
                rdr.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            return(requests);
        }
        public void Confirm_Deny_Request(Requests_Lecturers2 request, int newStatus)
        {
            try
            {
                con.OpenCon();
                com = new SqlCommand("UPDATE Requests_Lecturers SET Status = @NewStatus WHERE ID = @ID AND day = @day AND hour = @hour AND classroom = @classroom AND Status = @Status IF @@ROWCOUNT = 0 RAISERROR('No rows updated', 16, 1)", con.GetCon());
                com.Parameters.AddWithValue("@ID", request.GetID());
                com.Parameters.AddWithValue("@day", request.Get_Day());
                com.Parameters.AddWithValue("@hour", request.Get_Hour());
                com.Parameters.AddWithValue("@classroom", request.Get_Classroom());
                com.Parameters.AddWithValue("@Status", -1);
                com.Parameters.AddWithValue("@NewStatus", newStatus);
                com.ExecuteNonQuery();

                MessageBox.Show("הפעולה בוצעה בהצלחה");
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message + " הפעולה נכשלה");
            }
            con.CloseCon();
        }