public ActionResult SaveComments(int RS_HDRID, string Instructions, string AssignTo, string RMSJobStatus)
{
if (RS_HDRID > 0 && Instructions != "")
{
RMS_SharedReq_HDR Obj = unitOfwork.RMS_SharedReq_HDR.GetByID(RS_HDRID);
Obj.RMS_SharedReqNotes = new List <RMS_SharedReqNotes>();
RMS_SharedReqNotes newobj = new RMS_SharedReqNotes()
{
RS_Notes = Instructions,
RS_CreatedBy = User.Identity.Name,
RS_CreatedDt = SystemClock.US_Date
};
Obj.RMS_SharedReqNotes.Add(newobj);
unitOfwork.Save();
}
return(RedirectToAction("Index"));
}
public ActionResult Assign(int RS_HDRID, string Instructions, string AssignTo, string RMSJobStatus)
{
if (AssignTo != "" && RS_HDRID > 0)
{
//Check if already assigned. Or RMSJobStatus is not set to Close.
if (unitOfwork.RMS_AssignSharedReq.Get().Where(e => e.RA_AssignedTo == AssignTo && e.RA_SharedReqHDRID == RS_HDRID).Count() == 0 && RMSJobStatus != "CLOSE")
{
unitOfwork.RMS_AssignSharedReq.Insert(new RMS_AssignSharedReq
{
RA_SharedReqHDRID = RS_HDRID,
RA_AssignedTo = AssignTo,
RA_AssignedBy = User.Identity.Name,
RA_AssignedDt = SystemClock.US_Date
});
unitOfwork.Save();
}
}
if (RS_HDRID > 0 && RMSJobStatus != "")
{
unitOfwork.RMS_SharedReq_HDR.GetByID(RS_HDRID).RS_RMSJobStatus = RMSJobStatus;
unitOfwork.Save();
if (RMSJobStatus == "CLOSE")
{
string error;
string MailBody = @"<!DOCTYPE html>
<html lang='en'>
<head><meta charset='UTF-8'>
<title>Notification</title><style>body{font-family: arial, sans-serif;font-size:16px;}#div{padding:1%;background: white;display: block;margin: 0 auto;margin-bottom: 0.5cm;box-shadow: 0 0 0.5cm rgba(0,0,0,0.5);}table {font-family: arial, sans-serif;border-collapse: collapse;width: 100%;}td, th {border: 1px solid #dddddd;text-align: left;padding: 8px;}tr:nth-child(odd){background-color: #dddddd;}</style>
</head>
<body><div id='div'><p >Hi,</p><div style='padding:1%;'><p>Job as been closed in RMS shared requirement.</p><table><tr><th>Job ID</th><th>JD Ref</th><th>Title</th><th>Company</th><th>Requester</th><th>MaxSub</th></tr><tr><td><a href='https://www1.jobdiva.com/employers/myjobs/vieweditjobform.jsp?jobid=@JobID'>@JobID</a></td><td>@JDRef</td><td>@Title</td><td>@Company</td><td>@Requester</td><td>@MaxSub</td></tr></table></div><br><p>Please do not reply to this mail.<p></div></body></html>
" ;
var JobData = unitOfwork.RMS_SharedReq_HDR.GetByID(RS_HDRID);
MailBody = MailBody.Replace("@JobID", JobData.RS_JobID.ToString());
MailBody = MailBody.Replace("@JDRef", JobData.RS_JobDivaRef);
MailBody = MailBody.Replace("@Title", JobData.RMS_SharedReq_Dtl.First().RS_JobTitle);
MailBody = MailBody.Replace("@Company", JobData.RMS_SharedReq_Dtl.First().RS_Company);
MailBody = MailBody.Replace("@Requester", unitOfwork.User.GetByEmpID(User.Identity.Name).RE_Jobdiva_User_Name);
MailBody = MailBody.Replace("@MaxSub", JobData.RMS_SharedReq_Dtl.First().RS_MaxSubAllowed.ToString());
Email.SendMail(ConfigurationManager.AppSettings["SharedReq_Email"].Split(';'), "Job CLOSED In RMS", MailBody, out error);
}
}
if (RS_HDRID > 0 && Instructions != "")
{
RMS_SharedReq_HDR Obj = unitOfwork.RMS_SharedReq_HDR.GetByID(RS_HDRID);
Obj.RMS_SharedReqNotes = new List <RMS_SharedReqNotes>();
RMS_SharedReqNotes newobj = new RMS_SharedReqNotes()
{
RS_Notes = Instructions,
RS_CreatedBy = User.Identity.Name,
RS_CreatedDt = SystemClock.US_Date
};
Obj.RMS_SharedReqNotes.Add(newobj);
unitOfwork.Save();
}
return(RedirectToAction("Index"));
}
public ActionResult SavetoRMS(SharedReqVM SharedReqVM)
{
if (SharedReqVM.ListSharedReq != null && SharedReqVM.ListSharedReq.Count >= 1)
{
if ((from sharedReq_Hdr in unitOfwork.RMS_SharedReq_HDR.Get()
where sharedReq_Hdr.RS_JobDivaRef == SharedReqVM.ListSharedReq[0].JobDivaRef
select new
{
sharedReq_Hdr.RS_JobDivaRef
}).Count() > 0)
{
SharedReqVM.Message = "This requirement already exists in RMS Database.";
return(View("Index", SharedReqVM));
}
List <RMS_SharedReq_Dtl> RMS_SharedReq_Dtl = new List <RMS_SharedReq_Dtl>();
foreach (SharedReq sharedReq in SharedReqVM.ListSharedReq)
{
RMS_SharedReq_Dtl SharedReq_Dtl = new RMS_SharedReq_Dtl()
{
RS_JobTitle = sharedReq.JobTitle,
RS_JobIssueDate = sharedReq.JobIssueDate,
RS_Company = sharedReq.Company,
RS_WorkLocation = sharedReq.WorkLocation,
RS_ClientID = sharedReq.ClientID,
RS_Division = sharedReq.Division,
RS_Priority = sharedReq.Priority,
RS_Category = sharedReq.Category,
RS_State = sharedReq.State,
RS_City = sharedReq.City,
RS_BillRate = sharedReq.BillRate,
RS_PayRate = sharedReq.PayRate,
RS_PrimaryAssigment = sharedReq.PrimaryAssigment != null?String.Join(",", sharedReq.PrimaryAssigment) : null,
RS_MaxSubAllowed = sharedReq.MaxSubAllowed,
RS_InternalSub = sharedReq.InternalSub,
RS_ExternalSub = sharedReq.ExternalSub,
// RS_Instructions = sharedReq.Instructions,
//
SearchJobApi_id = sharedReq.SearchJobApi_id,
SearchJobApi_contact_id = sharedReq.SearchJobApi_contact_id,
SearchJobApi_company_id = sharedReq.SearchJobApi_company_id,
SearchJobApi_company = sharedReq.SearchJobApi_company,
SearchJobApi_reference = sharedReq.SearchJobApi_reference,
SearchJobApi_optional_reference = sharedReq.SearchJobApi_optional_reference,
SearchJobApi_job_title = sharedReq.SearchJobApi_job_title,
SearchJobApi_address1 = sharedReq.SearchJobApi_address1,
SearchJobApi_address2 = sharedReq.SearchJobApi_address2,
SearchJobApi_city = sharedReq.SearchJobApi_city,
SearchJobApi_state = sharedReq.SearchJobApi_state,
SearchJobApi_country = sharedReq.SearchJobApi_country,
SearchJobApi_zipcode = sharedReq.SearchJobApi_zipcode,
SearchJobApi_first_name = sharedReq.SearchJobApi_first_name,
SearchJobApi_last_name = sharedReq.SearchJobApi_last_name,
SearchJobApi_department = sharedReq.SearchJobApi_department,
SearchJobApi_job_status = sharedReq.SearchJobApi_job_status,
SearchJobApi_job_type = sharedReq.SearchJobApi_job_type,
SearchJobApi_issue_date = sharedReq.SearchJobApi_issue_date,
SearchJobApi_start_date = sharedReq.SearchJobApi_start_date,
SearchJobApi_end_date = sharedReq.SearchJobApi_end_date,
SearchJobApi_minimum_rate = sharedReq.SearchJobApi_minimum_rate,
SearchJobApi_maximum_rate = sharedReq.SearchJobApi_maximum_rate,
SearchJobApi_minimum_bill_rate = sharedReq.SearchJobApi_minimum_bill_rate,
SearchJobApi_maximum_bill_rate = sharedReq.SearchJobApi_maximum_bill_rate,
GetBIDataApi_JobDetails_ID = sharedReq.GetBIDataApi_JobDetails_ID,
GetBIDataApi_JobDetails_DATEISSUED = sharedReq.GetBIDataApi_JobDetails_DATEISSUED,
GetBIDataApi_JobDetails_DATEUPDATED = sharedReq.GetBIDataApi_JobDetails_DATEUPDATED,
GetBIDataApi_JobDetails_DATEUSERFIELDUPDATED = sharedReq.GetBIDataApi_JobDetails_DATEUSERFIELDUPDATED,
GetBIDataApi_JobDetails_JOBSTATUS = sharedReq.GetBIDataApi_JobDetails_JOBSTATUS,
GetBIDataApi_JobDetails_CUSTOMERID = sharedReq.GetBIDataApi_JobDetails_CUSTOMERID,
GetBIDataApi_JobDetails_COMPANYID = sharedReq.GetBIDataApi_JobDetails_COMPANYID,
GetBIDataApi_JobDetails_ADDRESS1 = sharedReq.GetBIDataApi_JobDetails_ADDRESS1,
GetBIDataApi_JobDetails_ADDRESS2 = sharedReq.GetBIDataApi_JobDetails_ADDRESS2,
GetBIDataApi_JobDetails_CITY = sharedReq.GetBIDataApi_JobDetails_CITY,
GetBIDataApi_JobDetails_STATE = sharedReq.GetBIDataApi_JobDetails_STATE,
GetBIDataApi_JobDetails_ZIPCODE = sharedReq.GetBIDataApi_JobDetails_ZIPCODE,
GetBIDataApi_JobDetails_PRIORITY = sharedReq.GetBIDataApi_JobDetails_PRIORITY,
GetBIDataApi_JobDetails_DIVISION = sharedReq.GetBIDataApi_JobDetails_DIVISION,
GetBIDataApi_JobDetails_REFNO = sharedReq.GetBIDataApi_JobDetails_REFNO,
GetBIDataApi_JobDetails_JOBDIVANO = sharedReq.GetBIDataApi_JobDetails_JOBDIVANO,
GetBIDataApi_JobDetails_STARTDATE = sharedReq.GetBIDataApi_JobDetails_STARTDATE,
GetBIDataApi_JobDetails_ENDDATE = sharedReq.GetBIDataApi_JobDetails_ENDDATE,
GetBIDataApi_JobDetails_POSITIONS = sharedReq.GetBIDataApi_JobDetails_POSITIONS,
GetBIDataApi_JobDetails_FILLS = sharedReq.GetBIDataApi_JobDetails_FILLS,
GetBIDataApi_JobDetails_MAXALLOWEDSUBMITTALS = sharedReq.GetBIDataApi_JobDetails_MAXALLOWEDSUBMITTALS,
GetBIDataApi_JobDetails_BILLRATEMIN = sharedReq.GetBIDataApi_JobDetails_BILLRATEMIN,
GetBIDataApi_JobDetails_BILLRATEMAX = sharedReq.GetBIDataApi_JobDetails_BILLRATEMAX,
GetBIDataApi_JobDetails_BILLRATEPER = sharedReq.GetBIDataApi_JobDetails_BILLRATEPER,
GetBIDataApi_JobDetails_AYRATEMIN = sharedReq.GetBIDataApi_JobDetails_AYRATEMIN,
GetBIDataApi_JobDetails_PAYRATEMAX = sharedReq.GetBIDataApi_JobDetails_PAYRATEMAX,
GetBIDataApi_JobDetails_AYRATEPER = sharedReq.GetBIDataApi_JobDetails_AYRATEPER,
GetBIDataApi_JobDetails_POSITIONTYPE = sharedReq.GetBIDataApi_JobDetails_POSITIONTYPE,
GetBIDataApi_JobDetails_SKILLS = sharedReq.GetBIDataApi_JobDetails_SKILLS,
GetBIDataApi_JobDetails_JOBTITLE = sharedReq.GetBIDataApi_JobDetails_JOBTITLE,
GetBIDataApi_JobDetails_JOBDESCRIPTION = sharedReq.GetBIDataApi_JobDetails_JOBDESCRIPTION,
GetBIDataApi_JobDetails_REMARKS = sharedReq.GetBIDataApi_JobDetails_REMARKS,
GetBIDataApi_JobDetails_SUBMITTALINSTRUCTION = sharedReq.GetBIDataApi_JobDetails_SUBMITTALINSTRUCTION,
GetBIDataApi_JobDetails_POSTTOPORTAL = sharedReq.GetBIDataApi_JobDetails_POSTTOPORTAL,
GetBIDataApi_JobDetails_POSTING_TITLE = sharedReq.GetBIDataApi_JobDetails_POSTING_TITLE,
GetBIDataApi_JobDetails_POSTING_DATE = sharedReq.GetBIDataApi_JobDetails_POSTING_DATE,
GetBIDataApi_JobDetails_POSTINGDESCRIPTION = sharedReq.GetBIDataApi_JobDetails_POSTINGDESCRIPTION,
GetBIDataApi_JobDetails_CRITERIA_DEGREE = sharedReq.GetBIDataApi_JobDetails_CRITERIA_DEGREE,
GetBIDataApi_JobDetails_JOBCATALOGID = sharedReq.GetBIDataApi_JobDetails_JOBCATALOGID,
GetBIDataApi_JobDetails_CATALOGCOMPANYID = sharedReq.GetBIDataApi_JobDetails_CATALOGCOMPANYID,
GetBIDataApi_JobDetails_CATALOGTITLE = sharedReq.GetBIDataApi_JobDetails_CATALOGTITLE,
GetBIDataApi_JobDetails_CATALOGREFNO = sharedReq.GetBIDataApi_JobDetails_CATALOGREFNO,
GetBIDataApi_JobDetails_CATALOGNAME = sharedReq.GetBIDataApi_JobDetails_CATALOGNAME,
GetBIDataApi_JobDetails_CATALOGACTIVE = sharedReq.GetBIDataApi_JobDetails_CATALOGACTIVE,
GetBIDataApi_JobDetails_CATALOGEFFECTIVEDATE = sharedReq.GetBIDataApi_JobDetails_CATALOGEFFECTIVEDATE,
GetBIDataApi_JobDetails_CATALOGEXPIRATIONDATE = sharedReq.GetBIDataApi_JobDetails_CATALOGEXPIRATIONDATE,
GetBIDataApi_JobDetails_CATALOGCATEGORY = sharedReq.GetBIDataApi_JobDetails_CATALOGCATEGORY,
GetBIDataApi_JobDetails_CATALOGBILLRATELOW = sharedReq.GetBIDataApi_JobDetails_CATALOGBILLRATELOW,
GetBIDataApi_JobDetails_CATALOGBILLRATEHIGH = sharedReq.GetBIDataApi_JobDetails_CATALOGBILLRATEHIGH,
GetBIDataApi_JobDetails_CATALOGBILLRATEPER = sharedReq.GetBIDataApi_JobDetails_CATALOGBILLRATEPER,
GetBIDataApi_JobDetails_CATALOGPAYRATELOW = sharedReq.GetBIDataApi_JobDetails_CATALOGPAYRATELOW,
GetBIDataApi_JobDetails_CATALOGPAYRATEHIGH = sharedReq.GetBIDataApi_JobDetails_CATALOGPAYRATEHIGH,
GetBIDataApi_JobDetails_CATALOGPAYRATEPER = sharedReq.GetBIDataApi_JobDetails_CATALOGPAYRATEPER,
GetBIDataApi_JobDetails_POSITIONREFNO = sharedReq.GetBIDataApi_JobDetails_POSITIONREFNO,
GetBIDataApi_JobDetails_PREVENTLOWERPAY = sharedReq.GetBIDataApi_JobDetails_PREVENTLOWERPAY,
GetBIDataApi_JobDetails_PREVENTHIGHERBILL = sharedReq.GetBIDataApi_JobDetails_PREVENTHIGHERBILL,
GetBIDataApi_JobDetails_CATALOGNOTES = sharedReq.GetBIDataApi_JobDetails_CATALOGNOTES,
//
};
if (sharedReq.File != null)
{
SharedReq_Dtl.RS_FileName = sharedReq.JobDivaRef + Path.GetExtension(sharedReq.File.FileName);
SharedReq_Dtl.RS_FileType = sharedReq.File.ContentType;
using (Stream fs = sharedReq.File.InputStream)
{
using (BinaryReader br = new BinaryReader(fs))
{
SharedReq_Dtl.RS_FileData = br.ReadBytes((Int32)fs.Length);
}
}
}
RMS_SharedReq_Dtl.Add(SharedReq_Dtl);
List <RMS_SharedReqNotes> RMS_SharedReqNotes = new List <RMS_SharedReqNotes>();
RMS_SharedReqNotes SharedReqNotes = new RMS_SharedReqNotes()
{
RS_Notes = sharedReq.Instructions,
RS_CreatedBy = User.Identity.Name,
RS_CreatedDt = SystemClock.US_Date
};
RMS_SharedReqNotes.Add(SharedReqNotes);
RMS_SharedReq_HDR Shared_HDR = new RMS_SharedReq_HDR()
{
RS_JobID = sharedReq.JobId,
RS_JobDivaRef = sharedReq.JobDivaRef,
RS_CreatedDt = SystemClock.US_Date,
RS_Req = "Shared",
RS_CreatedBy = User.Identity.Name,
RS_RMSJobStatus = "OPEN",
RS_JobDivaStatus = sharedReq.JobDivaStatus,
RMS_SharedReq_Dtl = RMS_SharedReq_Dtl,
RMS_SharedReqNotes = RMS_SharedReqNotes
};
unitOfwork.RMS_SharedReq_HDR.Insert(Shared_HDR);
unitOfwork.Save();
// Send mail..
string error;
string MailBody = @"<!DOCTYPE html>
<html lang='en'>
<head><meta charset='UTF-8'>
<title>Notification</title><style>body{font-family: arial, sans-serif;font-size:16px;}#div{padding:1%;background: white;display: block;margin: 0 auto;margin-bottom: 0.5cm;box-shadow: 0 0 0.5cm rgba(0,0,0,0.5);}table {font-family: arial, sans-serif;border-collapse: collapse;width: 100%;}td, th {border: 1px solid #dddddd;text-align: left;padding: 8px;}tr:nth-child(odd){background-color: #dddddd;}</style>
</head>
<body><div id='div'><p >Hi,</p><div style='padding:1%;'><p> New job as been added to RMS shared requirement.</p><table><tr><th>Job ID</th><th>JD Ref</th><th>Title</th><th>Company</th><th>Requester</th><th>MaxSub</th></tr><tr><td><a href='https://www1.jobdiva.com/employers/myjobs/vieweditjobform.jsp?jobid=@JobID'>@JobID</a></td><td>@JDRef</td><td>@Title</td><td>@Company</td><td>@Requester</td><td>@MaxSub</td></tr></table></div><br><p>Please do not reply to this mail.<p></div></body></html>
" ;
MailBody = MailBody.Replace("@JobID", sharedReq.JobId.ToString());
MailBody = MailBody.Replace("@JDRef", sharedReq.JobDivaRef);
MailBody = MailBody.Replace("@Title", sharedReq.JobTitle);
MailBody = MailBody.Replace("@Company", sharedReq.Company);
MailBody = MailBody.Replace("@Requester", unitOfwork.User.GetByEmpID(User.Identity.Name).RE_Jobdiva_User_Name);
MailBody = MailBody.Replace("@MaxSub", sharedReq.MaxSubAllowed.ToString());
//Email.SendMail(ConfigurationManager.AppSettings["SharedReq_Email"].Split(';'), "New Job Added To RMS", MailBody, out error);
}
// if (string.IsNullOrEmpty(error))
//return Content(("<script language='javascript' type='text/javascript'> alert('Password reset link sent to your registered email ');window.location = '" + Url.Action("Login") + "';</script>"));
// else
// return Content(("<script language='javascript' type='text/javascript'> alert('" + error + "');window.location = '" + Request.UrlReferrer.ToString() + "';</script>"));
//
}
SharedReqVM.Message = "Sucessfully saved to RMS Database.";
return(View("Index", SharedReqVM));
}
