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