public Candidatura(Candidatura candidatura) { CandidaturaId = candidatura.CandidaturaId; InterviewId = candidatura.InterviewId; ProgramId = candidatura.ProgramId; StartDate = candidatura.StartDate; LastDate = candidatura.LastDate; CandidaturaState = candidatura.CandidaturaState; UserId = candidatura.UserId; }
public ObservableCollection <Candidatura> GetCandidaturas() { ObservableCollection <Candidatura> candidaturas = new ObservableCollection <Candidatura>(); SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; string sql = "select * from Candidatura"; cmd.CommandText = sql; try { con.Open(); SqlDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { Candidatura candidatura = new Candidatura(); candidatura.CandidaturaId = (int)dr["CandidaturaId"]; candidatura.InterviewId = (int)dr["InterviewId"]; candidatura.ProgramId = (int)dr["ProgramId"]; candidatura.UserId = (string)dr["UserId"]; candidatura.StartDate = (DateTime)dr["StartDate"]; candidatura.LastDate = (DateTime)dr["LastStateDate"]; candidatura.CandidaturaState = (CandidaturaState)dr["State"]; candidaturas.Add(candidatura); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } return(candidaturas); }