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