public static List <ModelInterview> Data_InterviewById() //javított
{
string command = "SELECT interview.id,megnevezes_projekt,jeloltek.nev,interview.projekt_id,interview.jelolt_id,jeloltek.email,interview.hr_id,felvitel_datum,date_start,interju_cim,interju_leiras,helyszin, sent, time_end ,time_start FROM interview" +
" INNER JOIN projektek ON interview.projekt_id = projektek.id" +
" INNER JOIN jeloltek ON interview.jelolt_id = jeloltek.id" +
" WHERE interview.id = " + Session.InterViewID + "" +
" ORDER BY felvitel_datum";
List <ModelInterview> list = ModelInterview.GetModelInterview(command);
return(list);
}
public List <ModelInterview> Data_MyPastInterviews() //javított
{
string command = "SELECT interview.id,megnevezes_projekt,jeloltek.nev,interview.projekt_id,interview.jelolt_id,jeloltek.email,interview.hr_id,felvitel_datum,date_start,interju_cim,interju_leiras,helyszin, sent, time_end,time_start FROM interview " +
"INNER JOIN projektek ON interview.projekt_id = projektek.id " +
"INNER JOIN jeloltek ON interview.jelolt_id = jeloltek.id " +
"LEFT JOIN interju_resztvevo_kapcs ON interview.id = interju_resztvevo_kapcs.interju_id " +
"WHERE interju_resztvevo_kapcs.user_id = " + Session.UserData.id + " AND date_start < '" + date.Year + "." + Utilities.DateCorrect(date.Month) + "." + Utilities.DateCorrect(date.Day) + ".' ORDER BY date_start DESC";
List <ModelInterview> list = ModelInterview.GetModelInterview(command);
return(list);
}
