public AsistantAddCandidate()
{
InitializeComponent();
dict_departments = new Dictionary<int, string>();
canData = new AsistantCandidateData();
GetDepartmentList();
gridCanData.Children.Add(canData);
}
private void DisplayCandidate()
{
canData = new AsistantCandidateData();
//pobrac ID kandydata, wykonac operacje na bazie, poinformowac o rezultacie
try
{
CandidateAdapter obj = (CandidateAdapter)handle.dataGrid1.SelectedItem;
canData.ID = obj.GetID();
MySqlCommand command = DBConnection.Instance.Conn.CreateCommand();
command.CommandText = "SELECT name, surname, city, pesel, sex, education, skills, experience, courses FROM candidates WHERE id ='" + canData.ID + "'";
DBConnection.Instance.Conn.Open();
MySqlDataReader Reader = command.ExecuteReader();
while (Reader.Read())
{
canData.Name = Reader.GetString(0);
canData.Surname = Reader.GetString(1);
canData.City = Reader.GetString(2);
canData.Pesel = Reader.GetString(3);
canData.Sex = Reader.GetChar(4);
canData.Education = Reader.GetString(5);
canData.Skills = Reader.GetString(6);
canData.Experience = Reader.GetString(7);
canData.Courses = Reader.GetString(8);
canDataBeforModification = new Candidate(canData);
}
}
catch (MySqlException e)
{
ResultInfo(e.ToString());
}
catch (NullReferenceException e)
{
ResultInfo("Nie wybrano kandydata do modyfikacji.");
}
finally
{
DBConnection.Instance.Conn.Close();
}
mainPanel.Children.Add(canData);
AddModifyButton();
}
public Candidate(AsistantCandidateData canData)
{
Name = canData.Name;
Surname = canData.Surname;
Pesel = canData.Pesel;
City = canData.City;
Sex = canData.Sex;
Education = canData.Education;
Skills = canData.Skills;
Experience = canData.Experience;
Courses = canData.Courses;
}
