public string jobStaus(int selectedVal, long jobID) { jobDetail oInterViewerComment = new jobDetail(); oInterViewerComment = db.jobDetails.Where(e => e.jobID == jobID).FirstOrDefault(); oInterViewerComment.jobStatusID = selectedVal; oInterViewerComment.requiredSkills = "closed"; try { db.Entry(oInterViewerComment).State = EntityState.Modified; db.SaveChanges(); } catch (DbEntityValidationException ex) { // Retrieve the error messages as a list of strings. var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); BaseUtil.CaptureErrorValues(ex); } return("OK"); }
public ActionResult review(jobDetail ojobDetail) { ojobDetail = db.jobDetails.Where(m => m.jobID == ojobDetail.jobID).FirstOrDefault(); if (ojobDetail == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ojobDetail.isActive = true; ojobDetail.compeletPosted = true; ojobDetail.jobStatusID = 1; db.Entry(ojobDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Confirm")); }
public ActionResult review() { Int32 jobID = Convert.ToInt32(Session["JobId"]); if (jobID == 0) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } jobDetail ojobDetail = new jobDetail(); ojobDetail = db.jobDetails.Where(m => m.jobID == jobID).FirstOrDefault(); if (ojobDetail == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } return(View(ojobDetail)); }
public ActionResult JobDelete(int?jobID) { try { if (jobID != null) { jobDetail ojobDetail = new jobDetail(); ojobDetail = db.jobDetails.Find(jobID); ojobDetail.jobStatusID = 3; ojobDetail.modifiedBy = Convert.ToInt32(BaseUtil.GetSessionValue(AdminInfo.UserID.ToString())); ojobDetail.dataIsUpdated = BaseUtil.GetCurrentDateTime(); db.Entry(ojobDetail).State = EntityState.Modified; db.SaveChanges(); return(View()); } } catch (Exception e) { BaseUtil.CaptureErrorValues(e); } return(View()); }
public ActionResult NewJob(jobDetail jobDetailsModel, HttpPostedFileBase files) { try { jobDetailsModel.city = jobDetailsModel.city; //newjobDetailModel.EducationReq = "Not Available"; jobDetailsModel.dataIsCreated = DateTime.Now; jobDetailsModel.dataIsUpdated = DateTime.Now; jobDetailsModel.unit = "Monthly"; jobDetailsModel.isActive = true; jobDetailsModel.isDelete = false; jobDetailsModel.createdBy = Convert.ToInt32(BaseUtil.GetSessionValue(AdminInfo.employerID.ToString())); jobDetailsModel.jobStatusID = 1; jobDetailsModel.responsesEmailID = jobDetailsModel.jobContactPersonEmail; var path = string.Empty; if (files != null) { var fileName = Guid.NewGuid() + "_" + Path.GetFileName(files.FileName); path = Path.Combine(Server.MapPath("~/Logo"), fileName); files.SaveAs(path); jobDetailsModel.CompanyLogo = "https://spotaneedle.com/Logo/" + fileName; } var roleID = BaseUtil.RoleID(); string emailID = string.Empty; string conName = string.Empty; conName = jobDetailsModel.CompanyName; if (roleID == "2" || roleID == "3" || roleID == "6") { jobDetailsModel.companyID = Convert.ToInt32(BaseUtil.GetSessionValue(AdminInfo.companyID.ToString())); emailID = BaseUtil.GetSessionValue(AdminInfo.LoginID.ToString()); } else { jobDetailsModel.companyID = Convert.ToInt64(jobDetailsModel.CompanyName); var comapnyName = db.companyDetails.Where(e => e.companyID == jobDetailsModel.companyID).Select(e => new { e.companyName }).FirstOrDefault(); jobDetailsModel.CompanyName = comapnyName.companyName.ToString(); emailID = jobDetailsModel.jobContactPersonEmail; conName = jobDetailsModel.jobContactPersonName; } if (jobDetailsModel.jobID == 0) { db.jobDetails.Add(jobDetailsModel); db.SaveChanges(); jobDetailsModel.jobURL = "https://spotaneedle.com/jobDetails/Apply?jobID=" + jobDetailsModel.jobID; var url = jobDetailsModel.jobURL; db.Entry(jobDetailsModel).State = EntityState.Modified; db.SaveChanges(); } else { db.Entry(jobDetailsModel).State = EntityState.Modified; db.SaveChanges(); } ViewBag.jobid = jobDetailsModel.jobID; BaseUtil.Skills(jobDetailsModel.requiredSkills, jobDetailsModel.jobID); StreamReader sr = new StreamReader(Server.MapPath("/Emailer/toEmployerAfterjobPost.html")); string HTML_Body = sr.ReadToEnd(); string final_Html_Body_Link = ""; string final_Html_Body = HTML_Body.Replace("#name", conName); if (jobDetailsModel.jobURL != null) { final_Html_Body_Link = final_Html_Body.Replace("#Link", jobDetailsModel.jobURL); } sr.Close(); string To = emailID; string mail_Subject = "Job Posted Successfully "; string result = BaseUtil.sendEmailer(To, mail_Subject, final_Html_Body_Link, ""); TempData["refID"] = jobDetailsModel.advertisementRefID; var i = Request.Form["jobPOstType"].ToString(); if (i == "3") { TempData["jobURL"] = jobDetailsModel.jobURL; } return(RedirectToAction("ThankYou")); } catch (DbEntityValidationException ex) { BaseUtil.CaptureErrorValues(ex); // Retrieve the error messages as a list of strings. var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); } ViewBag.gender = db.genderLists; ViewBag.EmploymentTypeID = db.EmploymentTypes.Where(e => e.isActive == true); ViewBag.industryID = db.industries.Where(e => e.isActive == true); ViewBag.currency = db.currencies.Where(e => e.isActive == true); ViewBag.EducationReq = db.Educations; ViewBag.ComapnyDetails = db.companyDetails.Where(e => e.isActive == true).Select(e => new { e.companyID, e.companyName }); return(View(jobDetailsModel)); }
public ActionResult NewJob(Int64?jobID, Int64?refID, int?islink) { jobDetail jobDetailsModel = new jobDetail(); try { if (jobID == 0 || jobID == null) { long employerID = Convert.ToInt64(BaseUtil.GetSessionValue(AdminInfo.employerID.ToString())); if (refID != null) { jobDetailsModel.advertisementRefID = refID; //====================================================================== //postStatus 0 -> for leave after upload advt image // 1 -> post advt job by self // 2 -> post advt job by operator //========================================================================= advertisementList oadvertisementList = new advertisementList(); oadvertisementList = db.advertisementLists.Where(e => e.advertisementRefID == refID).FirstOrDefault(); if (oadvertisementList.empID == employerID) { oadvertisementList.postStatus = 1; db.Entry(oadvertisementList).State = EntityState.Modified; db.SaveChanges(); } } long companyID = Convert.ToInt64(BaseUtil.GetSessionValue(AdminInfo.companyID.ToString())); var comany = db.companyDetails.Find(companyID); var employer = db.EmployerDetails.Find(employerID); jobDetailsModel.CompanyName = comany.companyName; jobDetailsModel.CompanyDescription = comany.companyDescription; jobDetailsModel.CompanyWebsite = comany.website; jobDetailsModel.jobContactPersonName = employer.Name; jobDetailsModel.responsesEmailID = employer.Email; jobDetailsModel.jobContactPersonEmail = employer.Email; jobDetailsModel.jobContactPersonMobile = employer.Mobile; jobDetailsModel.CompanyLogo = comany.logo; } else { jobDetailsModel = db.jobDetails.Where(e => e.jobID == jobID).FirstOrDefault(); jobDetailsModel.requiredSkills = BaseUtil.JOb_skillSet(jobDetailsModel.jobID); } ViewBag.gender = db.genderLists; ViewBag.EmploymentTypeID = db.EmploymentTypes.Where(e => e.isActive == true); ViewBag.industryID = db.industries.Where(e => e.isActive == true); ViewBag.currency = db.currencies.Where(e => e.isActive == true); ViewBag.EducationReq = db.Educations; ViewBag.ComapnyDetails = db.companyDetails.Where(e => e.isActive == true).Select(e => new { e.companyID, e.companyName }); ViewBag.isLink = ""; if (islink == 1) { ViewBag.isLink = "3"; } } catch (Exception e) { BaseUtil.CaptureErrorValues(e); } return(View(jobDetailsModel)); }