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; }
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охранить"; } }
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(); } }