public static List <ModelFreelancerApplicant> GetRecruitedList(ModelApplicantSearchBar sw)
{
double listNo = (sw.numberLimit != 0 ? sw.numberLimit : 10);
string command = "SELECT coalesce((SELECT count(projekt_id) FROM projekt_jelolt_kapcs_kulsos WHERE projekt_jelolt_kapcs_kulsos.jelolt_id = jeloltek.id),0) as project_db, " +
"jeloltek.id,jeloltek.nev,szuldatum,reg_date,jeloltek.email,kategoria,bekuldo,lakhely,freelancer_list.name as freelancername " +
"FROM jeloltek " +
"LEFT JOIN projekt_jelolt_kapcs_kulsos ON jeloltek.id = projekt_jelolt_kapcs_kulsos.jelolt_id " +
"LEFT JOIN freelancer_list ON jeloltek.bekuldo = freelancer_list.id " +
"WHERE jeloltek.id LIKE '%%' AND kategoria = 2 AND ervenyes = 0";
if (sw.nev != "")
{
command += " AND jeloltek.nev LIKE '%" + sw.nev + "%' ";
}
if (sw.lakhely != "")
{
command += " AND jeloltek.lakhely LIKE '%" + sw.lakhely + "%' ";
}
if (sw.bekuldo != 0)
{
command += " AND jeloltek.bekuldo = " + sw.bekuldo + " ";
}
if (sw.regdate != "")
{
command += " AND jeloltek.reg_date LIKE '%" + sw.regdate + "%' ";
}
command += " GROUP BY jeloltek.id ";
switch (sw.HeaderSelected)
{
case "1":
command += " ORDER BY jeloltek.nev" + sw.sorrend;
break;
case "2":
command += " ORDER BY jeloltek.reg_date" + sw.sorrend;
break;
default:
command += " ORDER BY jeloltek.reg_date DESC";
break;
}
command += " LIMIT " + listNo + " OFFSET " + Session.ApplicantSearchPage * listNo + "";
return(ModelFreelancerApplicant.GetModelFreelancerApplicantList(command));
}
