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();
}
}
