private List<CandidateAdapter> GetCanList()
{
CandidateAdapter dataCan = new CandidateAdapter();
dataCan.SearchCommand();
dataCan.CreateList();
return dataCan.GetList();
}
private int Search(string name, string surname, string city, string sex, string pesel)
{
CandidateAdapter can = new CandidateAdapter();
can.SearchCommand(name, surname, city, sex, pesel);
can.CreateList();
dataGrid1.ItemsSource = can.GetList();
return can.GetList().Count;
}
public void CreateList()
{
list = new List<CandidateAdapter>();
MySqlCommand command = DBConnection.Instance.Conn.CreateCommand();
MySqlDataReader Reader;
command.CommandText = searchCommand;
DBConnection.Instance.Conn.Open();
Reader = command.ExecuteReader();
while (Reader.Read())
{
CandidateAdapter can = new CandidateAdapter();
can.ID = Reader.GetInt32(0);
can.Name = Reader.GetString(1);
can.Surname = Reader.GetString(2);
can.City = Reader.GetString(3);
can.Pesel = Reader.GetDecimal(4);
can.Sex = Reader.GetString(5);
list.Add(can);
}
DBConnection.Instance.Conn.Close();
}
