Ejemplo n.º 1
0
        private void select()
        {
            for (int i = 0; i < pers.Count; i++)
            {   if(Manager_personal_list.SelectedItem.ToString()==pers[i].login){
                personal = pers[i];
                Manager_login_txt.Text = pers[i].login;
                Manager_pass_txt.Text = pers[i].pass;
                Manager_name_txt.Text = pers[i].Name;
                Manage_lastname_txt.Text = pers[i].scndName;
                Manager_title_txt.Text = pers[i].title;
                if (pers[i].add)
                {
                    Manger_chk_add.Checked = true;

                }
                else {

                    Manger_chk_add.Checked = false;
                }
                if (pers[i].create_pdf)
                {
                    Manger_chk_createPDF.Checked = true;

                }
                else
                {

                    Manger_chk_createPDF.Checked = false;
                }
                if (pers[i].change)
                {
                    Manger_chk_change.Checked = true;

                }
                else
                {

                    Manger_chk_change.Checked = false;
                }
                if (pers[i].download)
                {
                    Manger_chk_download.Checked = true;

                }
                else
                {

                    Manger_chk_download.Checked = false;
                }
                if (pers[i].admin)
                {
                    Manger_chk_admin.Checked = true;

                }
                else
                {

                    Manger_chk_admin.Checked = false;
                }
            }
            }
        }
Ejemplo n.º 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охранить";

            }
        }
Ejemplo n.º 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();

            }
        }