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