private RabNamesList getNamesForExport()
{
RabNamesList result = new RabNamesList();
foreach (ListViewItem lvi in lvNames.Items)
{
result.Add(lvi.Tag as RabName);
}
return(result);
}
protected EPasportForm()
{
InitializeComponent();
Client c = new Client(int.MaxValue, "ферма", "Here");
_rabExport = new RabExporter(c, Engine.get().GetDBGuid());
_breeds = Engine.db().GetBreeds();
_names = Engine.db().GetNames();
lvAscendants.ListViewItemSorter =
lvNames.ListViewItemSorter =
lvBreeds.ListViewItemSorter = new LVSorter();
}
public static RabNamesList GetNames(MySqlConnection sql)
{
RabNamesList result = new RabNamesList();
MySqlCommand cmd = new MySqlCommand("SELECT n_id, n_sex, n_name, n_surname, n_use, n_block_date FROM names ORDER BY n_name;", sql);
MySqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
result.Add(fillName(rd));
}
rd.Close();
return(result);
}
