/// <summary>
/// This function retuns a job board list fr the given filters
/// </summary>
/// <param name="jBoardFilter"></param>
/// <returns></returns>
public IEnumerable<JobBoard> GetJobBoards(JobBoardFilter jBoardFilter)
{
var jobBoards = new List<JobBoard>();
// setup the parameters
SqlParameter[] parameters = {
new SqlParameter("@IsActive", jBoardFilter.IsActive),
new SqlParameter("@IsTopJobBoards", jBoardFilter.IsTopJobBoards),
new SqlParameter("@Keyword", jBoardFilter.keyword),
new SqlParameter("@SectorIds", string.IsNullOrEmpty( jBoardFilter.SectorIds) ? "" : jBoardFilter.SectorIds.Trim().TrimEnd(',')),
new SqlParameter("@JobId", jBoardFilter.JobId)
};
// setup the connection
var conn = new Sql_DataAccess(_connString);
var ds = conn.GetDataSetFromSP("RetrieveJobBoards", parameters);
// iterate and return clients
if (ds != null && ds.Tables.Count > 0)
{
jobBoards = (from DataRow dr in ds.Tables[0].Rows
select new JobBoard
{
JobBoardId = (int)dr["JobBoardId"],
Title = (dr["Title"] ?? "").ToString(),
CreditsPerJob = (int)dr["CreditsPerJob"],
IsTopJobBoard = (bool)dr["IsTopJobBoard"],
TotalCredits = (int)dr["TotalCredits"],
PricePerJob = (double)dr["PricePerJob"],
JobBoardUrl = (dr["JobBoardUrl"] ?? "").ToString(),
IsSelected = (int)dr["IsSelected"] > 0,
}).ToList();
}
//return job board list
return jobBoards;
}
public IEnumerable<JobBoard> GetJobBoards(JobBoardFilter filters)
{
return new JobBoards().GetJobBoards(filters);
}
