public DataSet Applytitlefilter(string titles) { var _qry = @"SELECT distinct idjobs,stitle,sshortdescription,sfreetext, sdescription,dtentereddate,ssalarytext,sminsal,employeeid, smaxsal, applicationvolume from aggregatedmulti where match(sfreetext) against('" + titles + "') limit 1000;"; var __dls = new DlSearchfilters(); return __dls.QuerySearch(_qry); }
/// <summary> /// move get jobssingle in here /// </summary> /// <param name="addedcrit"></param> public DataSet Applycriteriafilter(string addedcrit) { var _qry = @"SELECT distinct idjobs,stitle,sshortdescription,sfreetext, sdescription,dtentereddate,ssalarytext,sminsal,employeeid, smaxsal, applicationvolume from aggregatedmulti where " + addedcrit + " limit 1000;"; var __dls = new DlSearchfilters(); return __dls.QuerySearch(_qry); }