private void selectCat() { for (int i = 0; i < cat.Count; i++) { if (Manager_cat_list.SelectedItem!=null) if (Manager_cat_list.SelectedItem.ToString() == cat[i].cat) { Selected_cat = cat[i]; } } }
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(); } }