private void button_back_Click(object sender, EventArgs e)
        {
            this.Hide();
            A_TeachingAssistant back = new A_TeachingAssistant(ta);

            back.ShowDialog();
        }
Ejemplo n.º 2
0
 private void A_TeachingAssistant_Load(object sender, EventArgs e)
 {
     cureentA_TeachingAssistant = this;
 }
        private void button_SUBMIT_Click(object sender, EventArgs e)
        {
            bool alreadySigned = false;

            if (String.IsNullOrEmpty(textBox_hoursAmount.Text))
            {
                MessageBox.Show("You dont enter your work hours amount");
                this.Hide();
                A_Insert_work_hours_for_TA.currentA_Insert_work_hours_for_TA.Show(); //form = new A_Insert_work_hours_for_TA(ta);
                // form.ShowDialog();
            }

            SqlConnection cn = new SqlConnection("Data Source=p17server.database.windows.net;Initial Catalog=P17DATABASE;Persist Security Info=True;User ID=P17;Password=Hadas@2017");

            cn.Open();
            SqlCommand cmd0 = new SqlCommand("SELECT MAX (Num) FROM staffHours", cn);

            dr = cmd0.ExecuteReader();
            while (dr.Read())
            {
                //getting the last Num in table - in order to know to set next primary key

                followNum = dr[0].ToString();

                index     = Int32.Parse(followNum) + 1;
                nextIndex = index; //in order to get the number outside the loop
            }
            dr.Close();

            List <String> dept = new List <string>();

            SqlCommand cmd1 = new SqlCommand("SELECT * FROM UsersDepartment", cn);

            dr = cmd1.ExecuteReader();
            while (dr.Read())
            {
                if (dr["ID"].ToString() == ta.getID().ToString())
                {
                    dept.Add(dr["IDdepartment"].ToString());
                }
            }

            dr.Close();


            if (dept.Count() == 0)
            {
                MessageBox.Show("You'r not associated with a department \n You'r not allowed to insert work hours");
                textBox_hoursAmount.Clear();
            }
            else
            {
                SqlCommand cmd2 = new SqlCommand("SELECT * FROM staffHours", cn);
                dr = cmd2.ExecuteReader();
                while (dr.Read())
                {
                    if (dr["ID"].ToString() == ta.getID().ToString())
                    {
                        if (Int32.Parse(dr["month"].ToString()) == numericUpDown_month.Value)
                        {
                            if (Int32.Parse(dr["year"].ToString()) == numericUpDown_year.Value)
                            {
                                alreadySigned = true;
                                break;
                            }
                        }
                    }
                }
                dr.Close();

                if (!alreadySigned)
                {
                    cmd = new SqlCommand("INSERT INTO staffHours(Num,ID,name,Type,IDdepartment,month,year,hoursAmount) VALUES (@Num,@ID,@name,@Type,@IDdepartment,@month,@year,@hoursAmount)", cn);
                    cmd.Parameters.AddWithValue("@Num", nextIndex);
                    cmd.Parameters.AddWithValue("@ID", ta.getID().ToString());
                    cmd.Parameters.AddWithValue("@name", ta.getFirstName().ToString() + " " + ta.getLastName().ToString());
                    cmd.Parameters.AddWithValue("@Type", 3);
                    cmd.Parameters.AddWithValue("@IDdepartment", dept[0]);
                    cmd.Parameters.AddWithValue("@month", numericUpDown_month.Value);
                    cmd.Parameters.AddWithValue("@year", numericUpDown_year.Value);
                    cmd.Parameters.AddWithValue("@hoursAmount", textBox_hoursAmount.Text);

                    cmd.ExecuteNonQuery();
                    cmd.Parameters.Clear();


                    MessageBox.Show("Your work hours added succesfully!");
                    this.Close();
                    A_TeachingAssistant back = new A_TeachingAssistant(ta);
                    this.Hide();
                    back.ShowDialog();
                }



                else
                {
                    if (alreadySigned)
                    {
                        MessageBox.Show("You have already enterd your hours for: " + numericUpDown_month.Value + " - " + numericUpDown_year.Value);
                    }
                    textBox_hoursAmount.Clear();
                    MessageBox.Show(" *** PAY ATTENTION: insertion work hours FAILED! ***");
                }
            }



            cn.Close();
        }
Ejemplo n.º 4
0
        private void Login_button_Click(object sender, EventArgs e)
        {
            if (ID_Box.TextLength != 9)
            {
                MessageBox.Show("ooops Wrong ID please try again");
                ID_Box.Text       = "";
                Password_box.Text = "";
            }
            SqlConnection connect = new SqlConnection(Return_Connection_String_Class.Return_Connection_String());

            try
            {
                connect.Open();
            }
            catch (Exception ex)
            {
                // output the error to see what's going on
                MessageBox.Show(ex.Message);
            }

            if (connect.State == System.Data.ConnectionState.Open)
            {
                string        command = "select * from Users where ID = '" + ID_Box.Text + "' and Password = '******'";
                SqlCommand    cmd     = new SqlCommand(command, connect);
                SqlDataReader dataRead;
                dataRead = cmd.ExecuteReader();
                int    type = 0;
                string Messenge1 = "", Messenge2 = "";

                while (dataRead.Read())
                {
                    type = Convert.ToInt32(dataRead["Type"]);
                    int    id   = Convert.ToInt32(dataRead["ID"]);
                    string ln   = (dataRead["LastName"].ToString());
                    string fn   = (dataRead["FirstName"].ToString());
                    string depa = (dataRead["Departments"].ToString());
                    if (type == 1)
                    {
                        // 317509073/

                        //int id = Convert.ToInt32(dataRead["ID"]);
                        //string ln = (dataRead["LastName"].ToString());
                        //string fn = (dataRead["FirstName"].ToString());
                        string year = (dataRead["Year"].ToString());
                        //string depa = (dataRead["Departments"].ToString());
                        int semester = Convert.ToInt32(dataRead["Semester"]);
                        S1 = new StudentClass(id, fn, ln, type, year, semester, depa);
                        string        readMassange       = "select * from Messege_Box where ID = '" + S1.getID().ToString() + "'";
                        SqlCommand    ReadMessageCommand = new SqlCommand(readMassange, connect);
                        SqlDataReader messangeRead;
                        messangeRead = ReadMessageCommand.ExecuteReader();
                        while (messangeRead.Read())
                        {
                            Messenge1 = (messangeRead["S_Messege"].ToString());
                            Messenge2 = (messangeRead["L_Messege"].ToString());
                        }
                    }

                    if (type == 2) // to create the object Lecturer
                    {
                        int    pid   = Convert.ToInt32(dataRead["ID"]);
                        string pln   = (dataRead["LastName"].ToString());
                        string pfn   = (dataRead["FirstName"].ToString());
                        string pdepa = (dataRead["Departments"].ToString());
                        P1 = new ProfessorClass(pid, pln, pfn, type, pdepa);
                        string        readMassange       = "select * from Messege_Box where ID = '" + P1.getID().ToString() + "'";
                        SqlCommand    ReadMessageCommand = new SqlCommand(readMassange, connect);
                        SqlDataReader messangeRead;
                        messangeRead = ReadMessageCommand.ExecuteReader();
                        while (messangeRead.Read())
                        {
                            Messenge1 = (messangeRead["S_Messege"].ToString());
                            Messenge2 = (messangeRead["L_Messege"].ToString());
                        }
                        lec = new Lecturer();
                        this.lec.setLastName(ln);
                        this.lec.setFirstName(fn);
                        this.lec.setID(id);
                        this.lec.setdeparName(depa);
                    }


                    if (type == 3)     // to create the object TeachingAssitant
                    {
                        ta = new TeachingAssitant();
                        this.ta.setLastName(ln);
                        this.ta.setFirstName(fn);
                        this.ta.setID(id);
                        this.ta.setdeparName(depa);
                    }

                    if (type == 4) // to create the object HeadDepartmrent
                    {
                        hd = new HeadDepartment();
                        this.hd.setLastName(ln);
                        this.hd.setFirstName(fn);
                        this.hd.setID(id);
                        this.hd.setdeparName(depa);
                    }

                    if (type == 5)
                    {
                        sec = new Secretary();
                        this.sec.setLastName(ln);
                        this.sec.setFirstName(fn);
                        this.sec.setID(id);
                        this.sec.setdeparName(depa);
                    }
                    if (type == 7)
                    {
                        sec = new Secretary();
                        this.sec.setLastName(ln);
                        this.sec.setFirstName(fn);
                        this.sec.setID(id);
                        this.sec.setdeparName(depa);
                    }
                }
                if (save_id.Checked)
                {
                    Properties.Settings.Default.IDREMEMBER = ID_Box.Text.ToString();
                    Properties.Settings.Default.Save();
                }
                if (!save_id.Checked)
                {
                    Properties.Settings.Default.IDREMEMBER = "";
                    Properties.Settings.Default.Save();
                }

                if (type == 1)
                {
                    MessageBox.Show("wellcome " + S1.getFirstName() + " to student menu your ID " + S1.getID() + "");
                    this.Hide();
                    Student_Menu_B student = new Student_Menu_B();
                    if (Messenge1 != "" || Messenge2 != "")
                    {
                        student.Massange = true;
                    }
                    connect.Close();
                    student.passValue = S1;
                    dataRead.Close();
                    student.Show();
                }
                else if (type == 2)
                {
                    MessageBox.Show("wellcome " + P1.getFirstName() + " to Lecturer Menu your ID " + P1.getID() + "");
                    this.Hide();
                    //Proffesor_Menu_B professor = new Proffesor_Menu_B();
                    A_LecturerMenu lecMenu = new A_LecturerMenu(lec);
                    lecMenu.passValue = P1;
                    connect.Close();
                    dataRead.Close();
                    lecMenu.ShowDialog();

                    /*
                     * this.Hide();
                     * A_LecturerMenu lecMenu = new A_LecturerMenu(lec);
                     * lecMenu.ShowDialog();
                     */
                    //MessageBox.Show("Connceted Professor");
                    //this.Hide();
                    //Proffesor_Menu_B professor = new Proffesor_Menu_B();
                    //professor.Show();
                    // קבוצה B שימו לב !!!!!!!!
                    // אתם צריכים לשנות את הסוג של פרופסור אצלכם ל-2 ולשנות את זה בכל מקום! גם בקוד וגם בדטהבייס
                    // ואז לשלוח אותו לפורם הבא: A_lecturerMenu  אחרי שתאחדו את הדרישות שלכם בפורם הזה
                }

                else if (type == 3)
                {
                    this.Hide();
                    MessageBox.Show("wellcome " + ta.getFirstName() + " to Teaching Assistant Menu your ID " + ta.getID() + "");
                    A_TeachingAssistant taMenu = new A_TeachingAssistant(ta);
                    taMenu.passValue = ta;
                    connect.Close();
                    dataRead.Close();
                    taMenu.ShowDialog();



                    //change branch B ---  type of proffesor to type 2
                    //MessageBox.Show("Connceted Professor");
                    //this.Hide();
                    //Proffesor_Menu_B professor = new Proffesor_Menu_B();
                    //professor.Show();
                }
                else if (type == 4)
                {
                    this.Hide();
                    //HeadDepartment hd = new HeadDepartment();
                    A_DepartmentHead hdMenu = new A_DepartmentHead();
                    hdMenu.passValue = hd;
                    connect.Close();
                    dataRead.Close();
                    hdMenu.ShowDialog();
                }
                else if (type == 5)
                {
                    MessageBox.Show("wellcome " + sec.getFirstName() + " to Secretary Menu your ID " + sec.getID() + "");
                    this.Hide();
                    Secretary_Menu_B secretary = new Secretary_Menu_B();
                    secretary.passsec = sec;
                    secretary.Show();
                }
                else if (type == 6)
                {
                    MessageBox.Show("Connceted TECH");
                    this.Hide();
                    support__manager supp = new support__manager();
                    supp.Show();
                }
                else if (type == 7)
                {
                    this.Hide();

                    MessageBox.Show("wellcome " + sec.getFirstName() + " to Secretary Menu your ID " + sec.getID() + "");
                    A_menuForSecretary secMenu = new A_menuForSecretary();
                    // secMenu.passValue = sec;
                    //connect.Close();
                    //dataRead.Close();
                    secMenu.Show();
                }
                else
                {
                    MessageBox.Show("Wrong password");
                    Password_box.Text = "";
                }
            }
        }
Ejemplo n.º 5
0
        private void buttonLogin_Click(object sender, EventArgs e)
        {
            bool          login = false;
            SqlConnection cn    = new SqlConnection("Data Source=p17server.database.windows.net;Initial Catalog=P17DATABASE;Persist Security Info=True;User ID=P17;Password=Hadas@2017");

            cn.Open();
            SqlCommand    cmd = new SqlCommand("select * from Users where ID ='" + this.id_text.Text + "' and Password = '******'", cn);
            SqlDataReader dr;

            dr = cmd.ExecuteReader();

            string headDepartment;
            string userType, user_name;
            int    result = 0;

            while (dr.Read())
            {
                login = true;

                userType = dr["Type"].ToString();

                //We dont have Student - therefor we doesnt need to know his type

                if (userType == "2")//for Lecturer Type
                {
                    result = 2;
                    lec    = new Lecturer();
                    lec.setID(int.Parse(dr["ID"].ToString()));
                    lec.setdeparName(dr["Departments"].ToString());
                    lec.setFirstName(dr["FirstName"].ToString());
                    lec.setLastName(dr["LastName"].ToString());
                }

                if (userType == "3")//for Teaching Assitant Type
                {
                    result = 3;
                    ta     = new TeachingAssitant();
                    ta.setID(int.Parse(dr["ID"].ToString()));
                    ta.setdeparName(dr["Departments"].ToString());
                    ta.setFirstName(dr["FirstName"].ToString());
                    ta.setLastName(dr["LastName"].ToString());
                }

                if (userType == "4")//for Head Department Type
                {
                    result         = 4;
                    dh             = new HeadDepartment();
                    headDepartment = dr["ID"].ToString();
                    dh.setID(int.Parse(headDepartment));
                    dh.setdeparName(dr["Departments"].ToString());
                    dh.setFirstName(dr["FirstName"].ToString());
                    dh.setLastName(dr["LastName"].ToString());
                }

                if (userType == "5")//for Secretary Type
                {
                    result = 5;
                }
            }
            dr.Close();
            cn.Close();

            if (login)
            {
                //MessageBox.Show("Connect SUCCESSFULY");

                if (result == 2)// in case user is Lecturer
                {
                    this.Hide();
                    A_LecturerMenu lec = new A_LecturerMenu(this.lec);

                    lec.ShowDialog();
                }

                if (result == 3)//in case user is Teaching Assitant
                {
                    this.Hide();
                    A_TeachingAssistant ta = new A_TeachingAssistant(this.ta);
                    ta.ShowDialog();
                }

                if (result == 4)// in case the user is Department Head
                {
                    this.Hide();
                    //A_DepartmentHead depHead = new A_DepartmentHead();
                    A_DepartmentHead depHead = new A_DepartmentHead(this.dh);
                    depHead.ShowDialog();
                }

                if (result == 5)// in case the user is secretary
                {
                    this.Hide();
                    A_menuForSecretary sec = new A_menuForSecretary();
                    sec.ShowDialog();
                }
            }
            else
            {
                MessageBox.Show("Login FAILED !!! Invalid ID/Password");
            }

            this.id_text.Clear();
            this.password_text.Clear();
        }