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); }