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