public List <Industry_Type> GetJobCountByIndustry()
{
string spName = "[FetchindustryCount]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
List <Industry_Type> jobData = CommonDal.ExecuteProcedure <Industry_Type>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public List <State> GetJobCountByState()
{
string spName = "[FetchLocationCount]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
List <State> jobData = CommonDal.ExecuteProcedure <State>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public List <Category> GetJobCountByCategory()
{
string spName = "[FetchCategoryCount]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
List <Category> jobData = CommonDal.ExecuteProcedure <Category>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public List <Company> GetCompany()
{
string spName = "[FetchCompany]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
List <Company> jobData = CommonDal.ExecuteProcedure <Company>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public List <JobPost> GetJobPost()
{
string spName = "[FetchJobPost]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
List <JobPost> jobData = CommonDal.ExecuteProcedure <JobPost>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public List <Category> GetCategory(int id)
{
string spName = "[FetchCategories]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
IList <Category> roleList = CommonDal.ExecuteProcedure <Category>(spName, sqlParameters.ToArray());
return(roleList.ToList());
}
public List <JobPost> GetAppliedJob_byId(int id)
{
string spName = "[FetchAppliedJob]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("u_id", SqlDbType.VarChar, Convert.ToInt32(id)));
List <JobPost> jobData = CommonDal.ExecuteProcedure <JobPost>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public List <JobPost> GetJobBy_LocationId(int id)
{
string spName = "[FetchJobByLocationId]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("s_id", SqlDbType.Int, id));
List <JobPost> jobData = CommonDal.ExecuteProcedure <JobPost>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public List <Language> GetLanguages(int id)
{
string spName = "[GetLanguage]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.VarChar, Convert.ToInt32(id)));
List <Language> jobData = CommonDal.ExecuteProcedure <Language>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public List <Education> FetchEducation(int id)
{
string spName = "[GetEducation]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
List <Education> jobData = CommonDal.ExecuteProcedure <Education>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
