Exemple #1
0
        private void Manager_del_Click(object sender, EventArgs e)
        {
            del = true;
            SQL sql = new SQL();

            if (!isLastAdmin())
            {
                sql.ExecuteNonQuery("DELETE FROM PERSONAL WHERE " + "USER_LOGIN = '******'");
                for (int i = 0; i < pers.Count; i++)
                {
                    if (pers[i].login == personal.login)
                    {
                        pers.RemoveAt(i);
                        Manager_personal_list.Items.RemoveAt(i);
                        refreshPers();
                        Manager_personal_list.SetSelected(0, true);
                        select();
                    }
                }
            }
            del = false;
        }
Exemple #2
0
        private void Manager_addpersonal_Click(object sender, EventArgs e)
        {
            Personal p = new Personal();

            if (isadd)
            {
                if (isLoginOk())
                {
                    isadd = false;
                    Manager_addpersonal.Text = "Добавить";
                    SQL sql = new SQL();
                    int add_int;
                    int change_int;
                    int dl_int;
                    int create_int;
                    int admin_int;
                    if (Manger_chk_add.Checked)
                    {
                        add_int = 1;
                    }
                    else
                    {
                        add_int = 0;
                    }
                    if (Manger_chk_change.Checked)
                    {
                        change_int = 1;
                    }
                    else
                    {
                        change_int = 0;
                    }
                    if (Manger_chk_download.Checked)
                    {
                        dl_int = 1;
                    }
                    else
                    {
                        dl_int = 0;
                    }
                    if (Manger_chk_createPDF.Checked)
                    {
                        create_int = 1;
                    }
                    else
                    {
                        create_int = 0;
                    }
                    if (Manger_chk_admin.Checked)
                    {
                        admin_int = 1;
                    }
                    else
                    {
                        admin_int = 0;
                    }

                    sql.ExecuteNonQuery("INSERT INTO PERSONAL (USER_LOGIN,PASS,ADD_COIN,CREATE_PDF,CHANGE,DOWNLOAD,ADMIN_RULE,NAME,LAST_NAME,TITLE) VALUES('" + Manager_login_txt.Text + "','" + Manager_pass_txt.Text + "'," + add_int + "," + create_int + "," + change_int + "," + dl_int + "," + admin_int + ",'" + Manager_name_txt.Text + "','" + Manage_lastname_txt.Text + "','" + Manager_title_txt.Text + "')");
                    p            = pers[pers.Count - 1];
                    p.login      = Manager_login_txt.Text;
                    p.pass       = Manager_pass_txt.Text;
                    p.add        = Manger_chk_add.Checked;
                    p.change     = Manger_chk_change.Checked;
                    p.download   = Manger_chk_download.Checked;
                    p.create_pdf = Manger_chk_createPDF.Checked;
                    p.admin      = Manger_chk_admin.Checked;
                    p.Name       = Manager_name_txt.Text;
                    p.scndName   = Manage_lastname_txt.Text;
                    p.title      = Manager_title_txt.Text;
                    refreshPers();
                    Manager_personal_list.SetSelected(Manager_personal_list.Items.Count - 1, true);
                    select();
                }
                else
                {
                    MessageBox.Show("Два пользователя с одним логином");
                }
            }
            else
            {
                isadd = true;

                Manager_personal_list.Items.Add("Пользователь");
                Manager_personal_list.SetSelected(Manager_personal_list.Items.Count - 1, true);
                p.login = "******";
                // p.scndName = "Пользователь ";
                pers.Add(p);
                select();
                Manager_addpersonal.Text = "Cохранить";
            }
        }
Exemple #3
0
        private void Manager_Load(object sender, EventArgs e)
        {
            SQL          sql    = new SQL();
            FbDataReader reader = sql.StartQuery("SELECT * FROM PERSONAL");

            try
            {
                while (reader.Read())
                {
                    Personal p = new Personal();
                    p.login = reader.GetString(1);
                    p.pass  = reader.GetString(2);
                    if (reader.GetInt32(3) == 1)
                    {
                        p.add = true;
                    }
                    else
                    {
                        p.add = false;
                    }
                    if (reader.GetInt32(4) == 1)
                    {
                        p.create_pdf = true;
                    }
                    else
                    {
                        p.create_pdf = false;
                    }
                    if (reader.GetInt32(5) == 1)
                    {
                        p.change = true;
                    }
                    else
                    {
                        p.change = false;
                    }

                    if (reader.GetInt32(6) == 1)
                    {
                        p.download = true;
                    }
                    else
                    {
                        p.download = false;
                    }
                    if (reader.GetInt32(7) == 1)
                    {
                        p.admin = true;
                    }
                    else
                    {
                        p.admin = false;
                    }
                    if (!reader.IsDBNull(8))
                    {
                        p.Name = reader.GetString(8);
                    }
                    if (!reader.IsDBNull(9))
                    {
                        p.scndName = reader.GetString(9);
                    }
                    if (!reader.IsDBNull(10))
                    {
                        p.title = reader.GetString(10);
                    }

                    pers.Add(p);
                }
            }
            finally
            {
                sql.EndQuery();
                refreshPers();
                Manager_personal_list.SetSelected(0, true);
                select();
            }


            sql    = new SQL();
            reader = sql.StartQuery("SELECT * FROM CAT");

            try
            {
                while (reader.Read())
                {
                    Cat c = new Cat();
                    c.cat = reader.GetString(1);
                    c.id  = reader.GetInt32(0);
                    cat.Add(c);
                }
            }
            finally
            {
                sql.EndQuery();
                refreshCat();
            }
        }