public void LoadDatas()
 {
     var dao = new DaoJobs();
     DataTable dataTable = dao.GetJobsByAdmin();
     if (dataTable == null || dataTable.Rows.Count <= 0) return;
     BindRepeater(rptAccounts, dataTable);
 }
 public bool DeleteAJobByRecuiter(int jobId)
 {
     var dt = new DaoJobs();
     if (dt.DeleteAJobByRecuiter(jobId) > 0)
     {
         return true;
     }
     return false;
 }
 private bool SaveJobInfoUpdate()
 {
     var dao = new DaoJobs();
     var temp = dao.UpdateAJobInfo(JobTitle, Convert.ToInt32(Certificate.CertificateId),
         Convert.ToInt32(JobSalaryLevel.JobSalaryLevelId),
         Convert.ToInt32(Province.Id), Convert.ToInt32(JobIndustries.JobIndutriesId), ContentDetail, Description,
         ExpiredDate, Convert.ToInt32(JobPosition.JobPositionId), Convert.ToInt32(ExperienceLevel.ExperianceLevelId),
         Convert.ToInt32(WorkType.WorkTypeId), Convert.ToInt32(Recruitor.RecruitorId), Convert.ToInt32(NumsApplicant), Convert.ToInt32(JobId));
     if (temp > 0)
     {
         return true;
     }
     return false;
 }
        public void SetFullJobInfo()
        {
            var dao = new DaoJobs();
            DataTable infoTable = dao.GetFullJobInforById(Convert.ToInt32(JobId));

            ContentDetail = infoTable.Rows[0]["ContentDetail"].ToString();
            Description = infoTable.Rows[0]["Description"].ToString();
            JobTitle = infoTable.Rows[0]["FullTitle"].ToString();
            NumsApplicant = infoTable.Rows[0]["NumsApplicant"].ToString();
            ExpiredDate = Convert.ToDateTime(infoTable.Rows[0]["ExpiredDate"]);
            JobSalaryLevel = new JobSalaryLevel(infoTable.Rows[0]["SalaryLevelID"].ToString(), infoTable.Rows[0]["SalaryLevel"].ToString());
            JobIndustries = new JobIndustries(infoTable.Rows[0]["JobIndustryID"].ToString(), infoTable.Rows[0]["JobIndustryName"].ToString());
            Province = new Province(infoTable.Rows[0]["ProvinceID"].ToString(), infoTable.Rows[0]["ProvinceName"].ToString());
            JobPosition = new JobPosition(infoTable.Rows[0]["JobPositionID"].ToString(), infoTable.Rows[0]["JobPositionName"].ToString());
            JobIndustries = new JobIndustries(infoTable.Rows[0]["JobIndustryID"].ToString(), infoTable.Rows[0]["JobIndustryName"].ToString());
            WorkType = new WorkType(infoTable.Rows[0]["WorkTypeID"].ToString(), infoTable.Rows[0]["WorkTypeName"].ToString());
            Certificate = new Certificate(infoTable.Rows[0]["CertificateID"].ToString(), infoTable.Rows[0]["CertificateName"].ToString());
            ExperienceLevel = new ExperienceLevel(infoTable.Rows[0]["ExperienceLevelID"].ToString(), infoTable.Rows[0]["ExperienceLevelName"].ToString());
            RewriteUrl = infoTable.Rows[0]["RewriteUrl"].ToString();
            var companySize = new CompanySize(infoTable.Rows[0]["CompanySizeID"].ToString(), infoTable.Rows[0]["CompanySize"].ToString());
            Recruitor = new Recruitor(infoTable.Rows[0]["CompanyFullName"].ToString(), infoTable.Rows[0]["RecruitorName"].ToString(), companySize, infoTable.Rows[0]["Address"].ToString());
        }
        public List<Jobs> JobRanking( int userId)
        {
            try
            {
                var dao = new DaoJobs();
                DataTable tableData = dao.GetAllJobs(userId);
                var listRankJobs = new List<Jobs>();
                if (tableData != null && tableData.Rows.Count > 0)
                {

                    foreach (DataRow dataRow in tableData.Rows)
                    {
                        int rank = 1;
                        rank += Province.Id == dataRow["ProvinceID"].ToString() ? 3 : 0;
                        rank += JobPosition.JobPositionId == dataRow["JobPositionID"].ToString() ? 1 : 0;
                        rank += JobSalaryLevel.JobSalaryLevelId == dataRow["SalaryLevelID"].ToString() ? 1 : 0;
                        rank += WorkType.WorkTypeId == dataRow["WorkTypeID"].ToString() ? 1 : 0;
                        rank += JobIndustries.JobIndutriesId == dataRow["JobIndustryID"].ToString() ? 1 : 0;
                        rank += ExperienceLevel.ExperianceLevelId == dataRow["ExperienceLevelID"].ToString() ? 1 : 0;
                        rank += Certificate.CertificateId == dataRow["CertificateID"].ToString() ? 1 : 0;
                        switch (LangSkill.SillId)
                        {

                            case "1":
                            case "2":
                                rank += 0;
                                break;
                            case "3":
                                rank += 1;
                                break;
                            case "4":
                            case "7":
                            case "8":
                            case "9":
                            case "10":
                                rank += 2;
                                break;
                            case "5":
                            case "6":
                                rank += 3;
                                break;
                            case "11":
                                rank -= 2;
                                break;
                            default: break;
                        }
                        var job = new Jobs(dataRow["JobID"].ToString(),rank);
                        job.SetFullJobInfo();
                        listRankJobs.Add(job);
                    }
                }
                return listRankJobs;
            }
            catch (Exception exception)
            {
                Console.Write(exception);
                return null;
            }
        }
 protected DataTable GetAllAppliedJobs(int userId)
 {
     var dao = new DaoJobs();
     return dao.GetAllAppliedJobs(userId);
 }
 protected bool DeleteJobsByAdmin(int jobId)
 {
     var dt = new DaoJobs();
     return dt.DeleteJobsByAdmin(jobId) > 0;
 }
 protected bool ApplyJobs(int userId, int jobId, int resumeId)
 {
     var dao = new DaoJobs();
     return dao.SetJobAppliedByUser(userId, jobId, resumeId) > 0;
 }
 public bool DeleteASavedJob(int jobId)
 {
     var dt = new DaoJobs();
     return dt.DeleteASavedJob(jobId) > 0;
 }
 protected bool UpdateJobsUnHotByAdmin(int jobId)
 {
     var dt = new DaoJobs();
     return dt.UpdateJobsUnHotByAdmin(jobId) > 0;
 }
 protected bool SaveJobs(int userId, int jobId)
 {
     var dao = new DaoJobs();
     return dao.SetJobSavedByUser(userId, jobId) > 0;
 }
 protected DataTable GetJobs(string certificateId, string jobSalaryLevelId, string provinceId, string jobIndutriesId, string jobPositionId, string experienceLevelId, string workTypeId, string recruiterId)
 {
     var dao = new DaoJobs();
     return dao.FilterJobs(certificateId, jobSalaryLevelId, provinceId, jobIndutriesId, jobPositionId, experienceLevelId, workTypeId, recruiterId);
 }
 protected DataTable GetAllJobsByRecruiter(string recruiterId)
 {
     var dao = new DaoJobs();
     return dao.GetAllJobsByRecruiter(Convert.ToInt32(recruiterId));
 }
 public DataTable GetFullJobInforById(int jobid)
 {
     var dao = new DaoJobs();
     return dao.GetFullJobInforById(jobid);
 }