Exemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            this.Hide();
            Main_M menu = new Main_M();

            menu.employee = this.textbo;
            menu.ShowDialog();
        }
Exemplo n.º 2
0
        private void button2Back_Click(object sender, EventArgs e)
        {
            this.Hide();
            Main_M menu = new Main_M();

            menu.employee = this.textbo;
            menu.flag_    = flag_;
            if (flag_ == 1)
            {
                menu.button1Applic.Enabled = false;
                menu.button6Report.Enabled = false;
            }
            menu.ShowDialog();
        }
Exemplo n.º 3
0
        private void button2Ok_Click(object sender, EventArgs e)
        {
            if (adminCheckBox1.Checked == true)
            {
                this.Hide();
                Main_M mm = new Main_M();
                mm.flag_ = 1;
                mm.ShowDialog();
            }
            else
            {
                if ((loginTextBox.Text != "") && (passwordTextBox1.Text != ""))
                {
                    int insp = new Employees().inspection(loginTextBox.Text, passwordTextBox1.Text);
                    if (insp == 1)
                    {
                        this.Hide();
                        Main_M    mm   = new Main_M();
                        Employees empl = new Employees();

                        ConnectionStringSettings conString;
                        conString = ConfigurationManager.ConnectionStrings["MySQLConStr"];
                        using (MySqlConnection con = new MySqlConnection(conString.ConnectionString))
                        {
                            con.Open();
                            string          sql    = @"select * from employees where " + "(" + "login="******"'" + loginTextBox.Text + "'" + " and " + " password="******"'" + passwordTextBox1.Text + "'" + ")";
                            MySqlCommand    cmd    = new MySqlCommand(sql, con);
                            MySqlDataReader result = cmd.ExecuteReader();

                            if (result.HasRows)
                            {
                                result.Read();
                                foreach (var prop in empl.GetType().GetProperties())
                                {
                                    if (prop.Name == "tableName")
                                    {
                                        continue;
                                    }
                                    PropertyInfo propertyInfo = empl.GetType().GetProperty(prop.Name);
                                    string       NameResult;

                                    if (propertyInfo.PropertyType.Name == "Int32")
                                    {
                                        NameResult = propertyInfo.Name;
                                        propertyInfo.SetValue(empl, Convert.ChangeType(result.GetInt32(NameResult), propertyInfo.PropertyType), null);
                                    }
                                    else
                                    {
                                        if (propertyInfo.PropertyType.Name == "String")
                                        {
                                            NameResult = propertyInfo.Name;

                                            if (NameResult != "tableName_")
                                            {
                                                propertyInfo.SetValue(empl, Convert.ChangeType(result.GetString(NameResult), propertyInfo.PropertyType), null);
                                            }
                                        }
                                    }
                                }
                            }
                        }
                        mm.employee = empl;

                        if (empl.technician == 1)
                        {
                            mm.flag_ = 3;
                        }
                        if (empl.financier == 1)
                        {
                            mm.flag_ = 2;
                        }
                        mm.ShowDialog();
                    }
                    else
                    {
                        MessageBox.Show("Неверно введены логин и пароль. Попробуйте еще раз.", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        DialogResult = DialogResult.None;
                    }
                }
                else
                {
                    MessageBox.Show("Введите логин и пароль.", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    DialogResult = DialogResult.None;
                }
            }
        }