コード例 #1
0
ファイル: Main.cs プロジェクト: RoieErez/SchoolSchedule
        private void pictureBox2_Click(object sender, EventArgs e)
        {
            String         connect = @"Server=tcp:project-1.database.windows.net,1433;Initial Catalog=Data;Persist Security Info=False;User ID=Admin1;Password=Ad123456;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
            SqlConnection  con     = new SqlConnection(connect);
            String         query   = "Select * from Login where id = '" + textBox1.Text.Trim() + "' and password = '******'";
            SqlDataAdapter sda     = new SqlDataAdapter(query, con);
            DataTable      dt      = new DataTable();

            sda.Fill(dt);
            if (dt.Rows.Count == 1)
            {
                if (dt.Rows[0][3].Equals("Student"))
                {
                    SqlDataAdapter sda2 = new SqlDataAdapter("select * from Students where ID = '" + dt.Rows[0][0] + "'", con);
                    DataTable      dt2  = new DataTable();
                    sda2.Fill(dt2);

                    Student student = new Student(dt2.Rows[0][1].ToString(), dt2.Rows[0][0].ToString(), dt.Rows[0][2].ToString(), dt2.Rows[0][2].ToString(), dt2.Rows[0][3].ToString(), (bool)dt2.Rows[0][4]);

                    //first entrance of the student
                    //need to change his initial password
                    if (dt.Rows[0][0].Equals(dt.Rows[0][2]))//initial password equals ID
                    {
                        InitPassChange FM = new InitPassChange();
                        FM.RefToLastForm = this;
                        this.Visible     = false;
                        FM.Show();
                    }
                    //not the first entrence of the student
                    else
                    {
                        if (!student.getStatus())
                        {
                            MessageBox.Show("Your student's status is NOT active,\nplease go to 'Student's Accounts'");
                        }
                        else
                        {
                            StudentMenu HA = new StudentMenu(student);
                            HA.RefToMainMenu = this;
                            this.Visible     = false;
                            HA.Show();
                        }
                    }
                }
                else if (dt.Rows[0][3].Equals("Secretary"))
                {
                    SqlDataAdapter sda2 = new SqlDataAdapter("select * from Secretary;", con);
                    DataTable      dt2  = new DataTable();
                    sda2.Fill(dt2);

                    Secretary     secretery = new Secretary(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dt2.Rows[0][2].ToString());
                    SecretaryMenu HA        = new SecretaryMenu(secretery);
                    HA.RefToMainMenu = this;
                    this.Visible     = false;
                    HA.Show();
                }
                else if (dt.Rows[0][3].Equals("President"))
                {
                    President     president = new President(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString());
                    PresidentMenu HA        = new PresidentMenu(president);
                    HA.RefToMainMenu = this;
                    this.Visible     = false;
                    HA.Show();
                }
                else if (dt.Rows[0][3].Equals("HK"))
                {
                    HouseKeeper     houseKeeper = new HouseKeeper(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString());
                    HouseKeeperMenu HA          = new HouseKeeperMenu(houseKeeper);
                    HA.RefToMainMenu = this;
                    this.Visible     = false;
                    HA.Show();
                }
                else
                {
                    MessageBox.Show("Unknown Permission");
                }
            }
            else
            {
                MessageBox.Show("Please check your username and password");
            }
            con.Close();
        }
コード例 #2
0
ファイル: CUser.cs プロジェクト: RoieErez/SchoolSchedule
        public static Form LogIn(String id, String pass)
        {/*login to system*/
            DataTable t, dt = Program.get_dt("Select * from Login where Id='" + id + "' and Password='******'");

            if (dt.Rows.Count != 0)
            {
                if (dt.Rows[0][3].Equals("HOD"))
                {
                    HeadOfDepart_Main HA = new HeadOfDepart_Main(new CHeadOfDepartment(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dt.Rows[0][4].ToString(), dt.Rows[0][3].ToString()));
                    return(HA);
                }
                if (dt.Rows[0][3].Equals("TS"))
                {
                    t = Program.get_dt("Select * from Teaching_Staff where Id='" + id + "'");
                    TeachingStaffMenu Ts = new TeachingStaffMenu(new CTeachingStaff(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dt.Rows[0][4].ToString(), dt.Rows[0][3].ToString(), t.Rows[0][1].ToString(), t.Rows[0][2].ToString()));
                    return(Ts);
                }
                if (dt.Rows[0][3].Equals("SEC"))
                {
                    SecretaryFolder.Secretary_Menu Sec = new SecretaryFolder.Secretary_Menu(new CSecretary(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dt.Rows[0][4].ToString(), dt.Rows[0][3].ToString()));
                    return(Sec);
                }
                if (dt.Rows[0][3].Equals("ADS"))
                {
                    Administration.Administration_main Es = new Administration.Administration_main(new CAdministration(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dt.Rows[0][4].ToString(), dt.Rows[0][3].ToString()));
                    return(Es);
                }

                //Branch B///
                if (dt.Rows[0][3].Equals("Student"))
                {
                    String         conect = @"Server=tcp:project-1.database.windows.net,1433;Initial Catalog=Data;Persist Security Info=False;User ID=Admin1;Password=Ad123456;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
                    SqlConnection  con    = new SqlConnection(conect);
                    SqlDataAdapter sda2   = new SqlDataAdapter("select * from Students where ID = '" + dt.Rows[0][0] + "'", con);
                    DataTable      dt2    = new DataTable();
                    sda2.Fill(dt2);

                    Student student = new Student(dt2.Rows[0][1].ToString(), dt2.Rows[0][0].ToString(), dt.Rows[0][2].ToString(), dt2.Rows[0][2].ToString(), dt2.Rows[0][3].ToString(), (bool)dt2.Rows[0][4]);

                    //first entrance of the student
                    //need to change his initial password
                    if (dt.Rows[0][0].Equals(dt.Rows[0][2]))//initial password equals ID
                    {
                        InitPassChange FM = new InitPassChange();
                        FM.RefToLastForm = new Login();

                        return(FM);
                    }
                    //not the first entrence of the student
                    else
                    {
                        if (!student.getStatus())
                        {
                            MessageBox.Show("Your student's status is NOT active,\nplease go to 'Student's Accounts'");
                        }
                        else
                        {
                            StudentMenu HA = new StudentMenu(student);
                            HA.RefToMainMenu = new Login();
                            return(HA);
                        }
                    }
                }
                if (dt.Rows[0][3].Equals("Secretary"))
                {
                    String         conect = @"Server=tcp:project-1.database.windows.net,1433;Initial Catalog=Data;Persist Security Info=False;User ID=Admin1;Password=Ad123456;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
                    SqlConnection  con    = new SqlConnection(conect);
                    SqlDataAdapter sda2   = new SqlDataAdapter("select * from Secretary;", con);
                    DataTable      dt2    = new DataTable();
                    sda2.Fill(dt2);

                    Secretary     secretery = new Secretary(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dt2.Rows[0][2].ToString());
                    SecretaryMenu HA        = new SecretaryMenu(secretery);
                    HA.RefToMainMenu = new Login();

                    return(HA);
                }
                if (dt.Rows[0][3].Equals("President"))
                {
                    President     president = new President(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString());
                    PresidentMenu HA        = new PresidentMenu(president);
                    HA.RefToMainMenu = new Login();

                    return(HA);
                }
                if (dt.Rows[0][3].Equals("HK"))
                {
                    HouseKeeper     houseKeeper = new HouseKeeper(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString());
                    HouseKeeperMenu HA          = new HouseKeeperMenu(houseKeeper);
                    HA.RefToMainMenu = new Login();

                    return(HA);
                }
            }

            return(new Login());
        }