public List <PopulerSearchesViewModel> CityJobVacancies()
{
DataTable dt = _homeRepositories.CityJobVacancies();
List <PopulerSearchesViewModel> lstCity = new List <PopulerSearchesViewModel>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
PopulerSearchesViewModel city = new PopulerSearchesViewModel
{
CityCode = Convert.ToString(dt.Rows[i]["CityCode"]),
City = Convert.ToString(dt.Rows[i]["City"]),
TotalCount = Convert.ToString(dt.Rows[i]["Count"]),
};
lstCity.Add(city);
}
}
return(lstCity);
}
public List <PopulerSearchesViewModel> CompanyJobVacancies()
{
DataTable dt = _homeRepositories.CompanyJobVacancies();
List <PopulerSearchesViewModel> lstCompany = new List <PopulerSearchesViewModel>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
PopulerSearchesViewModel company = new PopulerSearchesViewModel
{
UserId = Convert.ToInt32(dt.Rows[i]["UserId"]),
CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]),
TotalCount = Convert.ToString(dt.Rows[i]["Count"]),
};
lstCompany.Add(company);
}
}
return(lstCompany);
}
public List <PopulerSearchesViewModel> CategoryJobVacancies()
{
DataTable dt = _homeRepositories.CategoryJobVacancies();
List <PopulerSearchesViewModel> lstCategory = new List <PopulerSearchesViewModel>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
PopulerSearchesViewModel category = new PopulerSearchesViewModel
{
JobIndustryAreaId = Convert.ToInt32(dt.Rows[i]["JobIndustryAreaId"]),
JobIndustryAreaName = Convert.ToString(dt.Rows[i]["JobIndustry"]),
TotalCount = Convert.ToString(dt.Rows[i]["Count"]),
};
lstCategory.Add(category);
}
}
return(lstCategory);
}
