private void ViewJobsInTable()
{
string sTable = "<tbody>";
API.Service jobInfo = new API.Service();
XmlDocument xmldoc = new XmlDocument();
//xmldoc.LoadXml("<XML>" + jobInfo.get_JobView("*****@*****.**", "ferivan", "2", "", "", "", "", "", "", "").InnerXml + "</XML>");
xmldoc.LoadXml("<XML>" + jobInfo.get_Jobs("", Session["Email"].ToString(), Session["P@ss"].ToString(), "", Session["UserID"].ToString(), Session["ClientID"].ToString()).InnerXml + "</XML>");
XmlNodeList Response = xmldoc.SelectNodes("XML/RESPONSE/JOBS ");
sTable = "";
int CountRows = 1;
string _sBackground = "";
for (int intCount = 0; intCount < Response.Count; intCount++)
{
sTable = sTable + "<tr " + _sBackground + ">";
sTable = sTable + "<td>" + CountRows + "</td>";
if (Response[intCount].SelectSingleNode("URGENT").InnerText == "1")
{
sTable = sTable + "<td style=color:red><blink>" + "Urgent" + "</blink> </td> ";
sTable = sTable + "<td style=color:red><a style=color:red href='Client_Job_Details.aspx?jopen=Y&p=JV&jobID=" + Response[intCount].SelectSingleNode("JOB_ALIAS").InnerText + "'>" + Response[intCount].SelectSingleNode("JOB_ALIAS").InnerText + "</td>";
sTable = sTable + "<td style=color:red>" + func.FixString(Server.HtmlDecode(Response[intCount].SelectSingleNode("JOB_TITLE").InnerText)) + "</td> ";
sTable = sTable + "<td style=color:red>" + Response[intCount].SelectSingleNode("JOB_LOCATION").InnerText.Replace(",Canada", "") + " </td> ";
sTable = sTable + "<td style=color:red>" + DateTime.Parse(Response[intCount].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("dd MMM, yyyy") + " </td> ";
sTable = sTable + "<td style=color:red>" + DateTime.Parse(Response[intCount].SelectSingleNode("CONTRACT_END_DATE").InnerText).ToString("dd MMM, yyyy") + " </td> ";
sTable = sTable + "<td style=color:red>" + Response[intCount].SelectSingleNode("NO_OF_OPENINGS").InnerText + " </td> ";
sTable = sTable + "<td style=color:red>" + Response[intCount].SelectSingleNode("HIRED").InnerText + " </td> ";
sTable = sTable + "<td style=color:red>" + Response[intCount].SelectSingleNode("AVAILABLE_JOBS").InnerText + " </td> ";
sTable = sTable + "<td style=color:red>" + Response[intCount].SelectSingleNode("RECENT").InnerText + " day(s)</td> ";
sTable = sTable + "<td style=color:red>" + Response[intCount].SelectSingleNode("USERNAME").InnerText + " </td> ";
sTable = sTable + "</tr>";
}
else
{
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("JOB_STATUS").InnerText + "</td>";
sTable = sTable + "<td><a href='Client_Job_Details.aspx?jopen=Y&p=JV&jobID=" + Response[intCount].SelectSingleNode("JOB_ALIAS").InnerText + "'>" + Response[intCount].SelectSingleNode("JOB_ALIAS").InnerText + "</td>";
sTable = sTable + "<td>" + Server.HtmlDecode(Response[intCount].SelectSingleNode("JOB_TITLE").InnerText) + "</td> ";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("JOB_LOCATION").InnerText.Replace(",Canada", "") + " </td> ";
sTable = sTable + "<td>" + DateTime.Parse(Response[intCount].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("dd MMM, yyyy") + " </td> ";
sTable = sTable + "<td>" + DateTime.Parse(Response[intCount].SelectSingleNode("CONTRACT_END_DATE").InnerText).ToString("dd MMM, yyyy") + " </td> ";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("NO_OF_OPENINGS").InnerText + " </td> ";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("HIRED").InnerText + " </td> ";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("AVAILABLE_JOBS").InnerText + " </td> ";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("RECENT").InnerText + " day(s)</td> ";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("USERNAME").InnerText + " </td> ";
sTable = sTable + "</tr>";
}
CountRows++;
}
sTable = sTable + "</tbody>";
jobInfo.Dispose();
lblTableData.Text = sTable;
}
private void ViewJobsInTable()
{
string sTable = "<tbody>";
API.Service jobInfo = new API.Service();
XmlDocument xmldoc = new XmlDocument();
//xmldoc.LoadXml("<XML>" + jobInfo.get_JobView("*****@*****.**", "ferivan", "2", "", "", "", "", "", "", "").InnerXml + "</XML>");
xmldoc.LoadXml("<XML>" + jobInfo.get_Jobs("", Session["Email"].ToString(), Session["P@ss"].ToString(), "", Session["UserID"].ToString(), Session["ClientID"].ToString()).InnerXml + "</XML>");
XmlNodeList Response = xmldoc.SelectNodes("XML/RESPONSE/JOBS ");
sTable = "";
int CountRows = 1;
string _sBackground = "";
for (int intCount = 0; intCount < Response.Count; intCount++)
{
//wrap text for title
string original_jobtitle = Response[intCount].SelectSingleNode("JOB_TITLE").InnerText;
string job_title = "";
if (original_jobtitle.Length > 10)
{
job_title = original_jobtitle.Substring(0, original_jobtitle.Length);
}
else
{
job_title = original_jobtitle;
}
string urgent_job = Response[intCount].SelectSingleNode("URGENT").InnerText;
if (intCount % 2 >= 1)
{
//enableordisable = "";
_sBackground = "bgcolor='#ECF0F1'";
}
else
{
// enableordisable = "disabled";
_sBackground = "";
}
if (urgent_job == "1")
{
sTable = sTable + "<tr " + _sBackground + ">";
sTable = sTable + "<td style=color:red><blink>" + "Urgent" + "</blink> </td> ";
sTable = sTable + "<td style=color:red><a target='_blank' style=color:red href='Client_Job_Details.aspx?jopen=Y&p=JV&jobID=" + Response[intCount].SelectSingleNode("JOB_ALIAS").InnerText + "'>" + Response[intCount].SelectSingleNode("JOB_ALIAS").InnerText + "</td>";
//sTable = sTable + "<td style=color:red>" + Response[intCount].SelectSingleNode("JOB_TITLE").InnerText.ToString() + "</td> ";
sTable = sTable + "<td style=color:red>" + func.FixString(job_title) + "</td> ";
sTable = sTable + "<td style=color:red>" + Response[intCount].SelectSingleNode("JOB_LOCATION").InnerText.Replace(",Canada", "") + " </td> ";
sTable = sTable + "<td style=color:red>" + Response[intCount].SelectSingleNode("NO_OF_OPENINGS").InnerText + " </td> ";
// sTable = sTable + "<td style=color:red>" + Response[intCount].SelectSingleNode("RECENT").InnerText + " day(s)</td> ";
sTable = sTable + "<td style=color:red>" + DateTime.Parse(Response[intCount].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("dd MMM, yyyy") + " </td> ";
}
else
{
sTable = sTable + "<tr " + _sBackground + ">";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("JOB_STATUS").InnerText + " </td> ";
sTable = sTable + "<td><a target='_blank' href='Job_Details.aspx?jopen=Y&p=JV&jobID=" + Response[intCount].SelectSingleNode("JOB_ALIAS").InnerText + "'>" + Response[intCount].SelectSingleNode("JOB_ALIAS").InnerText + "</td>";
//sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("JOB_TITLE").InnerText.ToString() + "</td> ";
sTable = sTable + "<td>" + func.FixString(job_title) + "</td> ";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("JOB_LOCATION").InnerText.Replace(",Canada", "") + " </td> ";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("NO_OF_OPENINGS").InnerText + " </td> ";
// sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("RECENT").InnerText + " day(s)</td> ";
sTable = sTable + "<td>" + DateTime.Parse(Response[intCount].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("dd MMM, yyyy") + " </td> ";
sTable = sTable + "</tr>";
CountRows++;
}
//closes
sTable = sTable + "</tbody>";
jobInfo.Dispose();
lblTableData.Text = sTable;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Email"] == null)
{
//logout
Session.Abandon();
Response.Redirect("Login.aspx?m=Your+session+has+timed+out");
Response.End();
}
if (!Page.IsPostBack)
{
int jobID = 0;
if (Request.QueryString["jobID"] != "")
{
jobID = Int32.Parse(Request.QueryString["jobID"].Substring(Request.QueryString["jobID"].Length - 5));
}
API.Service jobDetails = new API.Service();
XmlDocument _xjobDetails = new XmlDocument();
_xjobDetails.LoadXml("<XML>" + jobDetails.get_Jobs(Convert.ToString(jobID), Session["Email"].ToString(), Session["P@ss"].ToString(), Session["VendorID"].ToString(), Session["UserID"].ToString(), Session["ClientID"].ToString()).InnerXml + "</XML>");
// _xjobDetails.LoadXml("<XML>" + jobDetails.get_Jobs("2", "*****@*****.**", "ferivan").InnerXml + "</XML>");
string _Error = "";
try
{
_Error = _xjobDetails.SelectSingleNode("XML/RESPONSE/ERROR").InnerText;
//_xUserInfo.SelectNodes("XML/RESPONSE/JOB_NO")
}
catch (Exception ex)
{
_Error = "";
}
XmlNodeList Response2 = _xjobDetails.SelectNodes("XML/RESPONSE/JOBS");
//int CountRows = 1;
string _Job_Description = "";
string _Job_Title = "";
string _No_Of_Opennings = "";
string _DepartmentName = "";
string _ClientName = "";
string _Job_Position_Type = "";
string _Job_Location = "";
string _Hours_Per_Day = "";
string _Hiring_Manager = "";
string _Job_Currency = "";
string _Job_TimeZone = "";
string _Contract_Start_Date = "";
string _Contract_End_Date = "";
string _Max_submittion = "";
string _ReasonForOpen = "";
string _Urgent = "";
string _PayRate = "";
string _comments = "";
for (int intCount = 0; intCount < Response2.Count; intCount++)
{
_Job_Description = Response2[intCount].SelectSingleNode("JOB_DESC").InnerText;
_Job_Title = Server.HtmlDecode(Response2[intCount].SelectSingleNode("JOB_TITLE").InnerText);
_No_Of_Opennings = Response2[intCount].SelectSingleNode("NO_OF_OPENINGS").InnerText;
_DepartmentName = Response2[intCount].SelectSingleNode("DEPARTMENT_NAME").InnerText;
_ClientName = Response2[intCount].SelectSingleNode("CLIENT_NAME").InnerText;
_Job_Position_Type = Response2[intCount].SelectSingleNode("JOB_POSITION_TYPE").InnerText;
_Contract_Start_Date = DateTime.Parse(Response2[intCount].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("MMMM dd, yyyy");
_Contract_End_Date = DateTime.Parse(Response2[intCount].SelectSingleNode("CONTRACT_END_DATE").InnerText).ToString("MMMM dd, yyyy");
_Job_Location = Response2[intCount].SelectSingleNode("JOB_LOCATION").InnerText;
_Hours_Per_Day = Response2[intCount].SelectSingleNode("HOURS_PER_DAY").InnerText;
_Hiring_Manager = Response2[intCount].SelectSingleNode("HIRING_MANAGER_NAME").InnerText;
_Job_Currency = Response2[intCount].SelectSingleNode("JOB_CURRENCY").InnerText;
//_Contract_Start_Date = Response2[intCount].SelectSingleNode("CONTRACT_START_DATE").InnerText;
//_Contract_End_Date = Response2[intCount].SelectSingleNode("CONTRACT_END_DATE").InnerText;
_Job_TimeZone = Response2[intCount].SelectSingleNode("JOB_TIMEZONE").InnerText;
_Max_submittion = Response2[intCount].SelectSingleNode("MAX_SUBMISSION_PER_SUPPLIER").InnerText;
_ReasonForOpen = Response2[intCount].SelectSingleNode("REASON_FOR_OPEN").InnerText;
_Urgent = Response2[intCount].SelectSingleNode("URGENT").InnerText;
_PayRate = Response2[intCount].SelectSingleNode("STD_PAY_RATE").InnerText;
_comments = Response2[intCount].SelectSingleNode("COMMENTS").InnerText;
}
if (_Urgent == "1")
{
lblUrgent.Text = "(Urgent Request)";
}
DateTime dt = Convert.ToDateTime(_Contract_Start_Date);
DateTime dtt = Convert.ToDateTime(_Contract_End_Date);
lblPostingDate.Text = dt.ToString("dddd, dd MMMM yyyy HH:mm:ss").Replace("00:00:00", "");
lbljobtitle.Text = _Job_Title;
lblJobDescription.Text = Server.HtmlDecode(_Job_Description);
//lblNumberofPOsitions.Text = _No_Of_Opennings + " position(s) available, please respond by " + dtt.ToString("dddd, dd MMMM yyyy HH:mm:ss").Replace("00:00:00", ""); ;
// lblLocation.Text = _Job_Location;
//lblnoofopning.Text = _No_Of_Opennings;
//lblstartdate.Text = _Job_Posting_Start_Date;
//lblenddate.Text = _Job_Posting_End_Date;
//lbllocation.Text = _Job_Location;
//lblpayrate.Text = _PayRate;
if (_comments == "")
{
lblcomments.Text = "N/A";
}
else
{
lblcomments.Text = _comments;
}
//API.Service web3 = new API.Service();
API.Service web3 = new API.Service();
XmlDocument dom33 = new XmlDocument();
dom33.LoadXml("<XML>" + web3.get_Jobs(jobID.ToString(), Session["Email"].ToString(), Session["P@ss"].ToString(), Session["VendorID"].ToString(), Session["UserID"].ToString(), Session["ClientID"].ToString()).InnerXml + "</XML>");
XmlNodeList Response8 = dom33.SelectNodes("XML/RESPONSE/JOBS ");
lblnoofopning.Text = Response8[iResponse].SelectSingleNode("NO_OF_OPENINGS").InnerText;
lblstartdate.Text = DateTime.Parse(Response8[iResponse].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("dd MMM, yyyy");
lblenddate.Text = DateTime.Parse(Response8[iResponse].SelectSingleNode("CONTRACT_END_DATE").InnerText).ToString("dd MMM, yyyy");
lblUrgent.Text = Response8[iResponse].SelectSingleNode("URGENT").InnerText;
lbljobtitle.Text = Server.HtmlDecode(Response8[iResponse].SelectSingleNode("JOB_TITLE").InnerText);
string z = Response8[iResponse].SelectSingleNode("STD_PAY_RATE").InnerText;
if (z == "0")
{
x.Visible = false;
y.Visible = true;
lbllocation2.Text = Response8[iResponse].SelectSingleNode("JOB_LOCATION").InnerText;
lblbill.Text = Response8[iResponse].SelectSingleNode("STD_BILL_RATE").InnerText;
lbladdress2.Text = Response8[iResponse].SelectSingleNode("ADDRESS1").InnerText;
}
else
{
y.Visible = false;
x.Visible = true;
lblpay2.Text = Response8[iResponse].SelectSingleNode("STD_PAY_RATE").InnerText;
lbllocation.Text = Response8[iResponse].SelectSingleNode("JOB_LOCATION").InnerText;
lbladdres.Text = Response8[iResponse].SelectSingleNode("ADDRESS1").InnerText;
}
if (lblUrgent.Text == "1")
{
lblUrgent.Text = "(Urgent Request)";
}
else
{
lblUrgent.Text = "";
}
API.Service web1 = new API.Service();
XmlDocument dom2 = new XmlDocument();
//string strID = Request.QueryString["ID"];
dom2.LoadXml("<XML>" + web1.get_rating_with_jobid(Session["Email"].ToString(), Session["P@ss"].ToString(), jobID.ToString()).InnerXml + "</XML>");
XmlNodeList Response3 = dom2.SelectNodes("XML/RESPONSE/QUESTIONS_NO ");
string que1 = "";
string que2 = "";
string que3 = "";
string que4 = "";
string que5 = "";
string rating1 = "";
string rating2 = "";
string rating3 = "";
string rating4 = "";
string rating5 = "";
string emp_id = "";
string disable = "";
string rejected = "";
string more_info = "";
string cand_approve = "";
string interview_date = "";
string interview_confirm1 = "";
string interview_time = "";
string schedule = "";
que1 = Server.HtmlDecode(Response3[intCount1].SelectSingleNode("QUESTION1").InnerText);
if (que1 == "")
{
divstar.Visible = false;
}
else
{
divstar.Visible = true;
}
que2 = Response3[intCount1].SelectSingleNode("QUESTION2").InnerText;
que3 = Response3[intCount1].SelectSingleNode("QUESTION3").InnerText;
que4 = Response3[intCount1].SelectSingleNode("QUESTION4").InnerText;
que5 = Response3[intCount1].SelectSingleNode("QUESTION5").InnerText;
rating1 = Response3[intCount1].SelectSingleNode("RATING1").InnerText;
rating2 = Response3[intCount1].SelectSingleNode("RATING2").InnerText;
rating3 = Response3[intCount1].SelectSingleNode("RATING3").InnerText;
rating4 = Response3[intCount1].SelectSingleNode("RATING4").InnerText;
rating5 = Response3[intCount1].SelectSingleNode("RATING5").InnerText;
lblque1.Text = que1;
labque2.Text = que2;
lblque3.Text = que3;
lblque4.Text = que4;
lblque5.Text = que5;
txtRating1.Text = rating1;
txtRating2.Text = rating2;
txtRating3.Text = rating3;
txtRating4.Text = rating4;
txtRating5.Text = rating5;
string sTable = "<tbody>";
// API.Service web = new API.Service();
API.Service web = new API.Service();
XmlDocument dom1 = new XmlDocument();
//string strID = Request.QueryString["ID"];
dom1.LoadXml("<XML>" + web.get_candiate_for_that_particuler_job(Session["Email"].ToString(), Session["P@ss"].ToString(), jobID.ToString(), Session["VendorID"].ToString()).InnerXml + "</XML>");
XmlNodeList Response1 = dom1.SelectNodes("XML/RESPONSE/EMPLOYEE_NO");
sTable = "";
//string _messageVariable = "";
// _messageVariable = _messageVariable +
for (int iResponse2 = 0; iResponse2 < Response1.Count; iResponse2++)
{
emp_id = Response1[iResponse2].SelectSingleNode("EMPLOYEE_ID").InnerText;
if (emp_id.Length > 2)
{
emp_id = (emp_id.Substring(emp_id.Length - 6));
}
API.Service getWorkers = new API.Service();
// API.Service getWorkers = new API.Service();
XmlDocument dom3 = new XmlDocument();
dom1.LoadXml("<XML>" + getWorkers.get_employees(Session["Email"].ToString(), Session["P@ss"].ToString(), emp_id, "", "", "", "", "1", "").InnerXml + "</XML>");
XmlNodeList Response = dom1.SelectNodes("XML/RESPONSE/EMPLOYEE_NAME_ID");
sTable = sTable + "<tr>";
// sTable = sTable + "<td>" + @" <div class=""checkbox checkbox-single margin-none""> <input id=""checkAll"" type=""checkbox"" ></input> <label for=""checkbox2"" > Label </label> </div>" + " </TD>";
// sTable = sTable + "<td>" + _messageVariable + " </TD>";
//sTable = sTable + "<td><a href='preview_employee.aspx?empid=" + Response1[iResponse].SelectSingleNode("EMPLOYEE_ID").InnerText + "&jobId=" + Request.QueryString["jobID"] + "'>Edit</a> </td> ";
sTable = sTable + "<td>" + DateTime.Parse(Response1[iResponse2].SelectSingleNode("SUBMIT_DATE").InnerText).ToString("MMMM dd, yyyy") + " </td>";
sTable = sTable + "<td>" + Response1[iResponse2].SelectSingleNode("FIRST_NAME").InnerText + " " + Response1[iResponse2].SelectSingleNode("LAST_NAME").InnerText + " </td> ";
sTable = sTable + "<td>" + Response1[iResponse2].SelectSingleNode("EMAIL").InnerText + " </td> ";
sTable = sTable + "<td>" + Response1[iResponse2].SelectSingleNode("LOCATION").InnerText + " </td> ";
sTable = sTable + "<td>" + Response1[iResponse2].SelectSingleNode("STATUS").InnerText + " </td> ";
sTable = sTable + "<td>" + Response1[iResponse2].SelectSingleNode("PAY_RATE").InnerText + " </td> ";
sTable = sTable + "<td><a href='" + Response1[iResponse2].SelectSingleNode("RESUME_PATH").InnerText + "'>Resume</a> </td> ";
try
{
disable = Response[iResponse2].SelectSingleNode("INTERVIEW_REQUESTED").InnerText;
interview_date = Response[iResponse2].SelectSingleNode("INTERVIEW_DATE").InnerText;
interview_time = Response[iResponse2].SelectSingleNode("INTERVIEW_TIME").InnerText;
rejected = Response[iResponse2].SelectSingleNode("CANDIDATE_REJECTED").InnerText;
more_info = Response[iResponse2].SelectSingleNode("MORE_INFO").InnerText;
cand_approve = Response[iResponse2].SelectSingleNode("CANDIDATE_APPROVE").InnerText;
interview_confirm1 = Response[iResponse2].SelectSingleNode("INTERVIEW_CONFIRM").InnerText;
schedule = (interview_date.ToString().Replace("12:00:00 AM", "")) + (interview_time.ToString()).ToString();
}
catch (Exception ex)
{
disable = "";
interview_date = "";
interview_time = "";
rejected = "";
more_info = "";
cand_approve = "";
interview_confirm1 = "";
schedule = "";
}
DateTime cand_start_date = DateTime.Parse(Response[iResponse2].SelectSingleNode("STARTDATE").InnerText);
cand_start_date = DateTime.Parse(Response[iResponse2].SelectSingleNode("STARTDATE").InnerText);
string cand_start_date1 = (cand_start_date.ToString().Replace("12:00:00 AM", ""));
cand_start_date = DateTime.Parse(Response[iResponse2].SelectSingleNode("STARTDATE").InnerText);
DateTime contract_start_date = DateTime.Parse(Response[iResponse2].SelectSingleNode("CONTRACT_START_DATE").InnerText);
if ((interview_date != "") && (rejected == "0") && (more_info == "") && (cand_approve == ""))
{
if ((interview_date != "") && (rejected == "0") && (more_info == "") && (cand_approve == ""))
{
//sTable = sTable + "<td><a href='Client_View_Worker.aspx?wopen=Y&p=VW&approve=" + Response[iResponse].SelectSingleNode("EMPLOYEE_ID").InnerText + "'class='btn btn-success btn-xs' disabled data-toggle='tooltip' data-placement='top' name='abc' title='Interview Requested'><i class='fa fa-check'></i></a> <a href='Client_View_Worker.aspx?wopen=Y&p=VW&more=" + Response[iResponse].SelectSingleNode("EMPLOYEE_ID").InnerText + "' class='btn btn-default btn-xs' disabled data-toggle='tooltip' data-placement='top' name='abc' title='More details'><i class='fa fa-pencil'></i></a> <a href='Client_View_Worker.aspx?wopen=Y&p=VW&Reject=" + Response[iResponse].SelectSingleNode("EMPLOYEE_ID").InnerText + "' class='btn btn-danger btn-xs' disabled data-toggle='tooltip' data-placement='top' name='abc' title='Reject'><i class='fa fa-times'></i></a></td>";
if (interview_confirm1 == "1")
{
sTable = sTable + "<td>Interview confirm for:<br>" + schedule + "</td>";
}
else
{
sTable = sTable + "<td>Interview Requested for:<br>" + schedule + "</td>";
}
}
else
{
sTable = sTable + "<td>Interview Requested</td>";
}
}
else
if ((rejected != "") && (disable == "") && (more_info == "") && (rejected != "0") && (cand_approve == ""))
{
sTable = sTable + "<td>Rejected</td>";
}
else
if ((rejected == "0") && (disable == "") && (more_info != "") && (cand_approve == ""))
{
sTable = sTable + "<td>More Information Needed</td>";
}
else
if ((rejected == "0") && (disable == "") && (more_info == "") && (cand_approve != ""))
{
if (contract_start_date <= cand_start_date)
{
sTable = sTable + "<td>Working</td>";
}
else
{
sTable = sTable + "<td> Candidate set to start on:<br>" + cand_start_date1 + " </td>";
}
}
else
{
sTable = sTable + "<td><a href='Client_Job_Details.aspx?wopen=Y&p=VW&done=" + Response1[iResponse].SelectSingleNode("EMPLOYEE_ID").InnerText + "&jobID=" + Request.QueryString["jobID"] + "'class='btn btn-success btn-xs' data-toggle='tooltip' data-placement='top' name='abc' title='Request for an Interview or Approve candidate'><i class='fa fa-calendar fa-fw'></i></a> <a href='Client_Job_Details.aspx?wopen=Y&p=VW&more=" + Response1[iResponse].SelectSingleNode("EMPLOYEE_ID").InnerText + "&jobID=" + Request.QueryString["jobID"] + "' class='btn btn-default btn-xs' data-toggle='tooltip' data-placement='top' name='abc' title='Request more details'><i class='fa fa-pencil'></i></a> <a href='Client_Job_Details.aspx?wopen=Y&p=VW&Reject=" + Response1[iResponse].SelectSingleNode("EMPLOYEE_ID").InnerText + "&jobID=" + Request.QueryString["jobID"] + "' class='btn btn-danger btn-xs' data-toggle='tooltip' data-placement='top' name='abc' title='Reject Candidate'><i class='fa fa-times'></i></a></td>";
}
// sTable = sTable + "<td><select name='selDrop'><option name='option1' value='1'>Request For Interview</option><option name='option1' value='2'>Rejected</option><option name='option1' value='3'>More Details</option></select></td>";
sTable = sTable + "</tr>";
}
sTable = sTable + "</tbody>";
web.Dispose();
lblTableData.Text = sTable;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (Request["NM"] != null)
//{
// if (Request["NM"] == "Y")
// {
// Response.Redirect("Add_Worker.aspx?wopen=Y&p=AW&jobID=" + Request.QueryString["jobID"].ToString() + "&SN=T");
// }
//}
if (Session["Email"] == null)
{
//logout
Session.Abandon();
Response.Redirect("Login.aspx?m=You+have+logged+out");
Response.End();
}
btnpreview.Enabled = true;
//check if employee is a dup
if ((Request.Form["ctl00$MainContent$txtemail"] != null) && (Request.Form["ctl00$MainContent$txtemail"] != ""))
{
if (CheckCandidateDup(Request.Form["ctl00$MainContent$txtemail"]) == "YES")
{
lblDuplicate.Text = "This candidate already exists, please submit someone else";
btnpreview.Enabled = false;
}
else
{
lblDuplicate.Text = "";
}
}
if (Request.QueryString["jobID"] == null)
{
string a = "";
}
else
{
API.Service web1 = new API.Service();
// API.Service web1 = new API.Service();
XmlDocument dom2 = new XmlDocument();
int jobID = 0;
if (Request.QueryString["jobID"] != "")
{
jobID = Int32.Parse(Request.QueryString["jobID"].Substring(Request.QueryString["jobID"].Length - 5));
}
// string strID = Request.QueryString["jobID"];
dom2.LoadXml("<XML>" + web1.get_jobrating(Session["Email"].ToString(), Session["P@ss"].ToString(), jobID.ToString()).InnerXml + "</XML>");
XmlNodeList Response3 = dom2.SelectNodes("XML/RESPONSE/QUESTIONS_NO ");
string que1 = "";
string que2 = "";
string que3 = "";
string que4 = "";
string que5 = "";
string rating1 = "";
string rating2 = "";
string rating3 = "";
string rating4 = "";
string rating5 = "";
try
{
//que1 = Server.HtmlDecode(Response3[intCount1].SelectSingleNode("QUESTION1").InnerText);
que1 = Server.HtmlDecode(Response3[intCount1].SelectSingleNode("QUESTION1").InnerText);
que2 = Response3[intCount1].SelectSingleNode("QUESTION2").InnerText;
que3 = Response3[intCount1].SelectSingleNode("QUESTION3").InnerText;
que4 = Response3[intCount1].SelectSingleNode("QUESTION4").InnerText;
que5 = Response3[intCount1].SelectSingleNode("QUESTION5").InnerText;
rating1 = Response3[intCount1].SelectSingleNode("RATING1").InnerText;
rating2 = Response3[intCount1].SelectSingleNode("RATING2").InnerText;
rating3 = Response3[intCount1].SelectSingleNode("RATING3").InnerText;
rating4 = Response3[intCount1].SelectSingleNode("RATING4").InnerText;
rating5 = Response3[intCount1].SelectSingleNode("RATING5").InnerText;
}
catch (Exception ex)
{
//nothing
//que1 = "";
}
if (que1 == "")
{
divstar.Visible = false;
}
else
{
divstar.Visible = true;
}
lblque1.Text = que1;
labque2.Text = que2;
lblque3.Text = que3;
lblque4.Text = que4;
lblque5.Text = que5;
txtRating1.Text = rating1;
txtRating2.Text = rating2;
txtRating3.Text = rating3;
txtRating4.Text = rating4;
txtRating5.Text = rating5;
// API.Service web3 = new API.Service();
API.Service web3 = new API.Service();
XmlDocument dom3 = new XmlDocument();
dom3.LoadXml("<XML>" + web3.get_Jobs(jobID.ToString(), Session["Email"].ToString(), Session["P@ss"].ToString(), Session["VendorID"].ToString(), Session["UserID"].ToString(), Session["ClientID"].ToString()).InnerXml + "</XML>");
XmlNodeList Response8 = dom3.SelectNodes("XML/RESPONSE/JOBS ");
lblnoofopning.Text = Response8[iResponse].SelectSingleNode("NO_OF_OPENINGS").InnerText;
lblstartdate.Text = DateTime.Parse(Response8[iResponse].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("dd MMM, yyyy");
lblenddate.Text = DateTime.Parse(Response8[iResponse].SelectSingleNode("CONTRACT_END_DATE").InnerText).ToString("dd MMM, yyyy");
lblUrgent.Text = Response8[iResponse].SelectSingleNode("URGENT").InnerText;
lbljobtitle.Text = Server.HtmlDecode(Response8[iResponse].SelectSingleNode("JOB_TITLE").InnerText);
lbllocation2.Text = Response8[iResponse].SelectSingleNode("JOB_LOCATION").InnerText;
lblbill.Text = Response8[iResponse].SelectSingleNode("STD_BILL_RATE").InnerText;
lbladdress2.Text = Response8[iResponse].SelectSingleNode("ADDRESS1").InnerText;
lblpay2.Text = Response8[iResponse].SelectSingleNode("STD_PAY_RATE").InnerText;
lbllocation.Text = Response8[iResponse].SelectSingleNode("JOB_LOCATION").InnerText;
lbladdres.Text = Response8[iResponse].SelectSingleNode("ADDRESS1").InnerText;
lblsalary.Text = Response8[iResponse].SelectSingleNode("BASE_SALARY").InnerText;
lbllocation3.Text = Response8[iResponse].SelectSingleNode("JOB_LOCATION").InnerText;
lbladdress3.Text = Response8[iResponse].SelectSingleNode("ADDRESS1").InnerText;
lblpositiontype.Text = Response8[iResponse].SelectSingleNode("JOB_POSITION_TYPE").InnerText;;
if (lblpay2.Text == "" || lblpay2.Text == "0" && (lblbill.Text == "" || lblbill.Text == "0") && (lblsalary.Text != "" || lblsalary.Text != "0"))
// if (z == "0" && p != "0" && q == "0")
{
y.Visible = false;
x.Visible = false;
w.Visible = true;
}
else if (lblbill.Text == null || lblbill.Text == "0" && (lblpay2.Text != null || lblpay2.Text != "0") && (lblsalary.Text == "" || lblsalary.Text == "0"))
// else if (z != "0" && p == "0" && q == "0")
{
y.Visible = false;
x.Visible = true;
w.Visible = false;
}
else
{
x.Visible = false;
y.Visible = true;
w.Visible = false;
}
//string z = Response8[iResponse].SelectSingleNode("STD_PAY_RATE").InnerText;
//if (z == "0")
//{
// x.Visible = false;
// y.Visible = true;
// lbllocation2.Text = Response8[iResponse].SelectSingleNode("JOB_LOCATION").InnerText;
// lblbill.Text = Response8[iResponse].SelectSingleNode("STD_BILL_RATE").InnerText;
// lbladdress2.Text = Response8[iResponse].SelectSingleNode("ADDRESS1").InnerText;
//}
//else
//{
// y.Visible = false;
// x.Visible = true;
// lblpay.Text = Response8[iResponse].SelectSingleNode("VENDER_PAY_RATE").InnerText;
// lbllocation.Text = Response8[iResponse].SelectSingleNode("JOB_LOCATION").InnerText;
// lbladdres.Text = Response8[iResponse].SelectSingleNode("ADDRESS1").InnerText;
//}
if (lblUrgent.Text == "1")
{
lblUrgent.Text = "<blink>(Urgent Request)</blink>";
}
else
{
lblUrgent.Text = "";
}
}
if (Page.IsPostBack)
{
if (Request.QueryString["jobID"] == null)
{
string v = Request.Form["ctl00$MainContent$ddljobs"];
Response.Redirect("Add_worker.aspx?wopen=Y&p=AW&jobID=" + v.ToString());
}
// @" <div class=""modal slide-down fade"" id=""modal - select1"">" +
// @" < div class=""modal - dialog"">" +
// @" <div class=""v - cell"" >"+
// @" <div class=""modal - content"" >"+
// @" <div class=""modal - header"" >+
// @" <button type ='button' class='close' data-dismiss='modal'> "+
//@" <span aria-hidden=""true"">×</span><span class=""sr - only"">Close</span></button> "+
// @" </div>" +
// @" <div class=""modal - body"">" +
// @" <div class=""panel - body"">" +
// @" <asp:Label ID = ""lblmessege"" class=""media - heading margin - v - 5"" runat=""server""> stars are not matching</asp:Label>" +
// @" </div>" +
// @" </div>" +
// @" <div class=""modal - footer"">" +
// @" <button type = ""button"" class=""btn btn-default"" data-dismiss=""modal"">Close</button>" +
// @" <asp:Button ID = ""btnsbmit"" class=""btn btn-primary"" OnClick=""btnsbmit_Click"" runat=""server"" Text=""Continue"" /> " +
// @"</div>" +
// @" </div> " +
// @" </div> " +
// @" </div> " +
// @" </div> ";
// }
}
if (!Page.IsPostBack)
{
///Loadcountry();
Loadstate();
string v = Request.QueryString["jobID"];
if (v == null)
{
job.Visible = true;
Loadjobs();
}
else
{
job.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Email"] == null)
{
//logout
Session.Abandon();
HttpContext.Current.Response.Redirect("Login.aspx?m=You+have+logged+out");
HttpContext.Current.Response.End();
}
if (!Page.IsPostBack)
{
if (Request.QueryString["reply"] != null)
{
string empid_url2 = Request["empid"];
int empid_url3 = Int32.Parse(Request["empid"].Substring(Request["empid"].Length - 6));
API.Service getWorker = new API.Service();
// API.Service getWorker = new API.Service();
XmlDocument dom3 = new XmlDocument();
dom3.LoadXml("<XML>" + getWorker.get_employees(Session["Email"].ToString(), Session["P@ss"].ToString(), empid_url3.ToString(), Session["VendorID"].ToString(), Session["ClientID"].ToString(), "", "", "1", "").InnerXml + "</XML>");
XmlNodeList Response4 = dom3.SelectNodes("XML/RESPONSE/EMPLOYEE_NAME_ID");
lblname.Text = func.FixString(Response4[iResponse].SelectSingleNode("FIRSTNAME").InnerText) + " " + func.FixString(Response4[iResponse].SelectSingleNode("LASTNAME").InnerText);
jobid_feed = Response4[iResponse].SelectSingleNode("JOB_ID").InnerText;
}
}
string empid_url = Request["empid"];
int empid_url1 = Int32.Parse(Request["empid"].Substring(Request["empid"].Length - 6));
API.Service getWorkers = new API.Service();
XmlDocument dom1 = new XmlDocument();
dom1.LoadXml("<XML>" + getWorkers.get_employees(Session["Email"].ToString(), Session["P@ss"].ToString(), empid_url1.ToString(), "", Session["ClientID"].ToString(), "", "", "1", "").InnerXml + "</XML>");
XmlNodeList Response = dom1.SelectNodes("XML/RESPONSE/EMPLOYEE_NAME_ID");
// lblprofile.Text = Response[iResponse].SelectSingleNode("PROFILE_PICTURE_PATH").InnerText;
lblfirst.Text = func.FixString(Response[iResponse].SelectSingleNode("FIRSTNAME").InnerText);
lblmiddle.Text = func.FixString(Response[iResponse].SelectSingleNode("MIDDLE_NAME").InnerText);
lbllast.Text = func.FixString(Response[iResponse].SelectSingleNode("LASTNAME").InnerText);
lblemail.Text = Response[iResponse].SelectSingleNode("EMAIL").InnerText;
lblphone.Text = Response[iResponse].SelectSingleNode("PHONE").InnerText;
lbldob.Text = Response[iResponse].SelectSingleNode("DATE_OF_BIRTH").InnerText;
lblsuite.Text = Response[iResponse].SelectSingleNode("SUITE_NO").InnerText;
lbladdress.Text = func.FixString(Response[iResponse].SelectSingleNode("ADDRESS1").InnerText);
lblcity.Text = func.FixString(Response[iResponse].SelectSingleNode("LOCATION").InnerText);
lblprovince.Text = func.FixString(Response[iResponse].SelectSingleNode("PROVINCE").InnerText);
// lblcountry.Text = func.FixString(Response[iResponse].SelectSingleNode("COUNTRY").InnerText);
lblpostal.Text = Response[iResponse].SelectSingleNode("POSTAL").InnerText;
lblcomment.Text = func.FixString(Response[iResponse].SelectSingleNode("COMMENTS").InnerText);
lblavailable.Text = Response[iResponse].SelectSingleNode("AVAILABILITY_FOR_INTERVIEW").InnerText;
lblskype.Text = Response[iResponse].SelectSingleNode("SKYPE").InnerText;
lbllicence.Text = Response[iResponse].SelectSingleNode("LICENCE_NO").InnerText;
lbllastsin.Text = Response[iResponse].SelectSingleNode("LAST_4_DIGITS_OF_SSN_SIN").InnerText;
lblpay.Text = Response[iResponse].SelectSingleNode("PAY_RATE").InnerText;
lbljob.Text = func.FixString(Response[iResponse].SelectSingleNode("JOB_TITLE").InnerText + "-" + Response[iResponse].SelectSingleNode("JOB_ID").InnerText);
string jobid2 = Response[iResponse].SelectSingleNode("JOB_ID").InnerText;
Label1.Text = Response[iResponse].SelectSingleNode("PAY_RATE").InnerText;
API.Service web1 = new API.Service();
// API.Service web1 = new API.Service();
XmlDocument dom2 = new XmlDocument();
//string strID = Request.QueryString["ID"];
dom2.LoadXml("<XML>" + web1.get_Jobs(jobid2, Session["Email"].ToString(), Session["P@ss"].ToString(), Session["VendorID"].ToString(), Session["UserID"].ToString(), Session["ClientID"].ToString()).InnerXml + "</XML>");
XmlNodeList Response8 = dom2.SelectNodes("XML/RESPONSE/JOBS ");
lblnoofopning.Text = Response8[iResponse].SelectSingleNode("NO_OF_OPENINGS").InnerText;
lblstartdate.Text = DateTime.Parse(Response8[iResponse].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("dd MMM, yyyy");
lblenddate.Text = DateTime.Parse(Response8[iResponse].SelectSingleNode("CONTRACT_END_DATE").InnerText).ToString("dd MMM, yyyy");
lblUrgent.Text = Response8[iResponse].SelectSingleNode("URGENT").InnerText;
lbljobtitle.Text = Response8[iResponse].SelectSingleNode("JOB_TITLE").InnerText;
string z = Response8[iResponse].SelectSingleNode("STD_PAY_RATE").InnerText;
if (z == "0")
{
x.Visible = false;
y.Visible = true;
lbllocation2.Text = Response8[iResponse].SelectSingleNode("JOB_LOCATION").InnerText;
lblbill.Text = Response8[iResponse].SelectSingleNode("STD_BILL_RATE").InnerText;
}
else
{
y.Visible = false;
x.Visible = true;
lblpay.Text = Response8[iResponse].SelectSingleNode("STD_PAY_RATE").InnerText;
lbllocation.Text = Response8[iResponse].SelectSingleNode("JOB_LOCATION").InnerText;
}
if (lblUrgent.Text == "1")
{
lblUrgent.Text = "(Urgent Request)";
}
else
{
lblUrgent.Text = "";
}
dom2.LoadXml("<XML>" + web1.get_jobrating(Session["Email"].ToString(), Session["P@ss"].ToString(), jobid2).InnerXml + "</XML>");
XmlNodeList Response3 = dom2.SelectNodes("XML/RESPONSE/QUESTIONS_NO ");
string que1 = "";
string que2 = "";
string que3 = "";
string que4 = "";
string que5 = "";
string rating1 = "";
string rating2 = "";
string rating3 = "";
string rating4 = "";
string rating5 = "";
string emprating1 = "";
string emprating2 = "";
string emprating3 = "";
string emprating4 = "";
string emprating5 = "";
try
{
//que1 = Server.HtmlDecode(Response3[intCount1].SelectSingleNode("QUESTION1").InnerText);
que1 = Server.HtmlDecode(Response3[intCount1].SelectSingleNode("QUESTION1").InnerText);
que2 = Response3[intCount1].SelectSingleNode("QUESTION2").InnerText;
que3 = Response3[intCount1].SelectSingleNode("QUESTION3").InnerText;
que4 = Response3[intCount1].SelectSingleNode("QUESTION4").InnerText;
que5 = Response3[intCount1].SelectSingleNode("QUESTION5").InnerText;
rating1 = Response3[intCount1].SelectSingleNode("RATING1").InnerText;
rating2 = Response3[intCount1].SelectSingleNode("RATING2").InnerText;
rating3 = Response3[intCount1].SelectSingleNode("RATING3").InnerText;
rating4 = Response3[intCount1].SelectSingleNode("RATING4").InnerText;
rating5 = Response3[intCount1].SelectSingleNode("RATING5").InnerText;
dom2.LoadXml("<XML>" + web1.get_emprating(Session["Email"].ToString(), Session["P@ss"].ToString(), empid_url1.ToString()).InnerXml + "</XML>");
XmlNodeList Response33 = dom2.SelectNodes("XML/RESPONSE/QUESTIONS_NO ");
try
{
//que1 = Server.HtmlDecode(Response3[intCount1].SelectSingleNode("QUESTION1").InnerText);
emprating1 = Response33[iResponse].SelectSingleNode("RATING1").InnerText;
emprating2 = Response33[iResponse].SelectSingleNode("RATING2").InnerText;
emprating3 = Response33[iResponse].SelectSingleNode("RATING3").InnerText;
emprating4 = Response33[iResponse].SelectSingleNode("RATING4").InnerText;
emprating5 = Response33[iResponse].SelectSingleNode("RATING5").InnerText;
}
catch (Exception ex)
{
//nothing
//que1 = "";
}
}
catch (Exception ex)
{
//nothing
//que1 = "";
}
if (que1 == "")
{
divstar.Visible = false;
}
else
{
divstar.Visible = true;
}
lblque1.Text = que1;
labque2.Text = que2;
lblque3.Text = que3;
lblque4.Text = que4;
lblque5.Text = que5;
txtRating1.Text = rating1;
txtRating2.Text = rating2;
txtRating3.Text = rating3;
txtRating4.Text = rating4;
txtRating5.Text = rating5;
txtemprat1.Text = emprating1;
txtemprat2.Text = emprating2;
txtemprat3.Text = emprating3;
txtemprat4.Text = emprating4;
txtemprat5.Text = emprating5;
// dom1.LoadXml("<XML>" + getWorkers.get_resume(Session["Email"].ToString(), Session["P@ss"].ToString(), empid_url1.ToString(), "").InnerXml + "</XML>");
//try
//{
// XmlNodeList Response2 = dom1.SelectNodes("XML/RESPONSE/RESUME_ID");
// lblresume.Text = Response2[iResponse].SelectSingleNode("RESUME_PATH").InnerText;
//}
//catch (Exception ex)
//{
// lblresume.Text = "";
//}
dom1.LoadXml("<XML>" + getWorkers.get_resume(Session["Email"].ToString(), Session["P@ss"].ToString(), empid_url1.ToString(), "").InnerXml + "</XML>");
try
{
XmlNodeList Response2 = dom1.SelectNodes("XML/RESPONSE/RESUME_ID");
string resume = Response2[iResponse].SelectSingleNode("RESUME_PATH").InnerText;
// string resume = Response1[iResponse2].SelectSingleNode("RESUME_PATH").InnerText;
string resuepath = Response2[iResponse].SelectSingleNode("RESUME_PATH").InnerText.Substring(Response2[iResponse].SelectSingleNode("RESUME_PATH").InnerText.IndexOf("Resume\\"), Convert.ToInt32(Response2[iResponse].SelectSingleNode("RESUME_PATH").InnerText.Length) - Convert.ToInt32(Response2[iResponse].SelectSingleNode("RESUME_PATH").InnerText.IndexOf("Resume\\"))).Replace("\\", "//").ToString();
lblresume.Text = "<a href = 'http://www.flentispro.com/" + resuepath.Replace("//", "/") + "'> Resume </a>";
}
catch (Exception ex)
{
lblresume.Text = "";
}
API.Service jobInfo2 = new API.Service();
XmlDocument xmldoc11 = new XmlDocument();
string sTable9 = "<tbody>";
xmldoc11.LoadXml("<XML>" + jobInfo2.get_name_leave_request(Session["Email"].ToString(), Session["P@ss"].ToString(), Session["VendorID"].ToString(), empid_url1.ToString(), "", Session["ClientID"].ToString()).InnerXml + "</XML>");
XmlNodeList Response9 = xmldoc11.SelectNodes("XML/RESPONSE/NAME");
sTable9 = "";
int CountRows9 = 1;
int intCount9 = 0;
for (intCount9 = 0; intCount9 < Response9.Count; intCount9++)
{
sTable9 = sTable9 + "<tr>";
// sTable9 = sTable9 + "<td>" + func.FixString(Response9[intCount9].SelectSingleNode("FIRST_NAME").InnerText + " " + Response9[intCount9].SelectSingleNode("LAST_NAME").InnerText) + "</td>";
sTable9 = sTable9 + "<td>" + DateTime.Parse(Response9[intCount9].SelectSingleNode("REQUESTED_DATE").InnerText).ToString("dd MMM, yyyy") + " </td> ";
sTable9 = sTable9 + "<td>" + func.FixString(Response9[intCount9].SelectSingleNode("REQUESTED_REASON").InnerText) + "</td> ";
sTable9 = sTable9 + "<td>" + func.FixString(Response9[intCount9].SelectSingleNode("REQUESTED_COMMENTS").InnerText) + "</td> ";
string status = Response9[intCount9].SelectSingleNode("ACTION").InnerText;
if (status == "2")
{
sTable9 = sTable9 + "<td> Not approved</td>";
// sTable9 = sTable9 + "<td>Absence Request Not approved</td>";
}
if (status == "1")
{
sTable9 = sTable9 + "<td> Approved</td>";
// sTable9 = sTable9 + "<td>Absence Request Not approved</td>";
}
if (status == "0")
{
sTable9 = sTable9 + "<td> Rejected</td>";
// sTable9 = sTable9 + "<td>Absence Request Not approved</td>";
}
sTable9 = sTable9 + "</tr>";
CountRows9++;
}
if (Response9.Count == 0)
{
sTable9 = sTable9 + "<td colspan=4>" + "There are no Absence Requests at this time." + "</td> ";
sTable9 = sTable9 + "</tr>";
}
sTable9 = sTable9 + "</tbody>";
jobInfo2.Dispose();
lblrequestleave.Text = sTable9;
conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["dbconn"].ConnectionString);
try
{
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
//start, end and weeks
string sqlGetChat = " select feeedback_id, v_comments, v_create_date, c_comments, c_create_date from ovms_candidate_feedback " +
" where client_id = " + Session["ClientID"].ToString() +
" and vendor_id = " + Session["VendorID"].ToString() +
" and emplyee_id = " + empid_url1 +
" order by feeedback_id asc";
SqlCommand cmdGetChat = new SqlCommand(sqlGetChat, conn);
SqlDataReader rsGetChat = cmdGetChat.ExecuteReader();
//string _svendorList = "";
string sMessages = "";
while (rsGetChat.Read())
{
sMessages = sMessages + "<tr>" +
" <td width='50%' class='pull-left' style='color:blue'> " +
" " + rsGetChat["v_comments"].ToString() + " " +
" on" +
" " + rsGetChat["v_create_date"].ToString() + " " +
" </td>" +
" <td class='pull-right'></td>" +
" </tr>" +
" <tr>" +
" <td></td>" +
" <td style='color:red'>" +
" " + rsGetChat["c_comments"].ToString() + " " +
" " + rsGetChat["c_create_date"].ToString() + "";
if ((rsGetChat["c_comments"].ToString() == "") || (rsGetChat["c_comments"] == null))
{
//string empid_url = Request["empid"];
//int empid_url1 = Int32.Parse(Request["empid"].Substring(Request["empid"].Length - 6));
// Response.Redirect("Client_View_Worker_detail.aspx?wopen=Y&p=VW&empid=" + empid_url + "&reply=y");
sMessages = sMessages + "<a class='btn btn-success' href='Client_View_Worker_detail.aspx?wopen=Y&p=VW&empid=" + empid_url + "&reply=y'><i class='fa fa-check - circle' ></i> Reply</a>";
}
//<asp:Button ID='btnreplyc' ValidationGroup='n' runat='server' OnClick='btnreplyc_Click1' Text='Reply' CssClass='form-control' />
sMessages = sMessages + " </td>" +
" </tr>";
}
//close
rsGetChat.Close();
cmdGetChat.Dispose();
lblMessagesBackForth.Text = sMessages;
//rsStartEndWeeks.Close();
//cmdStartEndWeeks.Dispose();
}
}
catch (Exception ex)
{
//
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
// ////vendor request
// API.Service vendoreq = new API.Service();
//// API.Service jobInfo2 = new API.Service();
// XmlDocument xmldoc5 = new XmlDocument();
//' lblcreply.Visible = false;
//// btnreplyc.Visible = true;
//xmldoc11.LoadXml("<XML>" + vendoreq.get_v_feedback(Session["Email"].ToString(), Session["P@ss"].ToString(), "", empid_url1.ToString(), "",Session["VendorID"].ToString(), Session["ClientID"].ToString()).InnerXml + "</XML>");
// XmlNodeList Response5 = xmldoc11.SelectNodes("XML/RESPONSE/FEEDBACK");
// 'lblvendorcomments.Text = Response5[iResponse].SelectSingleNode("V_COMMENTS").InnerText;
// 'lbldate.Text= DateTime.Parse(Response5[iResponse].SelectSingleNode("V_CREATE_DATE").InnerText).ToString("dd MMM, yyyy");
// 'lblcreply.Text= Response5[iResponse].SelectSingleNode("C_COMMENTS").InnerText;
// if (lblcreply.Text!="")
// {
// lblcreply.Visible = true;
// btnreplyc.Visible = false;
// lbldatec.Text = " on " + DateTime.Parse(Response5[iResponse].SelectSingleNode("C_CREATE_DATE").InnerText).ToString("dd MMM, yyyy");
// }
// vendoreq.Dispose();
}
private void Loaddata()
{
int jobID = 0;
if (Request.QueryString["jobID"] != "")
{
jobID = Int32.Parse(Request.QueryString["jobID"].Substring(Request.QueryString["jobID"].Length - 5));
}
API.Service getWorkers = new API.Service();
// API.Service getWorkers = new API.Service();
XmlDocument dom1 = new XmlDocument();
dom1.LoadXml("<XML>" + getWorkers.get_Jobs(jobID.ToString(), Session["Email"].ToString(), Session["P@ss"].ToString(), Session["VendorID"].ToString(), Session["UserID"].ToString(), Session["ClientID"].ToString()).InnerXml + "</XML>");
XmlNodeList Response = dom1.SelectNodes("XML/RESPONSE/JOBS");
ddljobStatus.Text = Response[iResponse].SelectSingleNode("JOB_STATUS_ID").InnerText;
// LoadJobStatusnew(Response[iResponse].SelectSingleNode("JOB_STATUS").InnerText);
txtjobtitle.Value = Response[iResponse].SelectSingleNode("JOB_TITLE").InnerText;
// Loadjoblocationnew(Response[iResponse].SelectSingleNode("JOB_LOCATION").InnerText);
ddllocation.Text = Response[iResponse].SelectSingleNode("JOB_LOCATION_ID").InnerText;
txtnumberofopning.Value = Response[iResponse].SelectSingleNode("NO_OF_OPENINGS").InnerText;
// txtpositonstarrt.Value = Response[iResponse].SelectSingleNode("POSTING_START_DATE").InnerText;
//txtpositionend.Value = Response[iResponse].SelectSingleNode("POSTING_END_DATE").InnerText;
txthoursperday.Value = Response[iResponse].SelectSingleNode("HOURS_PER_DAY").InnerText;
ddldepartment.Text = Response[iResponse].SelectSingleNode("DEPARTMENT_ID").InnerText;
// Loaddepartmentnew(Response[iResponse].SelectSingleNode("DEPARTMENT_NAME").InnerText);
txtroles_and_responsibility.Text = Server.HtmlDecode(Response[iResponse].SelectSingleNode("JOB_DESC").InnerText);
ddlpositiontype.Text = Response[iResponse].SelectSingleNode("POSITION_TYPE_ID").InnerText;
// LoadpositiontypeSel(Response[iResponse].SelectSingleNode("JOB_POSITION_TYPE").InnerText);
// Loadvendornew(Response[iResponse].SelectSingleNode("VENDOR_NAME").InnerText);
ddlmove.SelectedValue = Response[iResponse].SelectSingleNode("ABLE_TO_MOVE").InnerText;
ddlvendor.Text = Response[iResponse].SelectSingleNode("VENDOR_ID").InnerText;
txttraveltime.Value = Response[iResponse].SelectSingleNode("TRAVEL_TIME").InnerText;
txthiremanagername.Value = Response[iResponse].SelectSingleNode("HIRING_MANAGER_NAME").InnerText;
txtcoordinator.Value = Response[iResponse].SelectSingleNode("COORDINATOR").InnerText;
// txtcreatedate.Value = Response[iResponse].SelectSingleNode("CREATE_DATE").InnerText;
txtmaxsub.Value = Response[iResponse].SelectSingleNode("MAX_SUBMISSION_PER_SUPPLIER").InnerText;
ddlreasonforopen.SelectedValue = Response[iResponse].SelectSingleNode("REASON_FOR_OPEN").InnerText;
ddlinterviw.SelectedValue = Response[iResponse].SelectSingleNode("INTERVIEW").InnerText;
txtbasesallary.Value = Response[iResponse].SelectSingleNode("BASE_SALARY").InnerText;
txtmarkup.Value = Response[iResponse].SelectSingleNode("MARK_UP").InnerText;
txtstd_pay_rate_from.Value = Response[iResponse].SelectSingleNode("STD_PAY_RATE").InnerText;
txtvendor_pay.Value = Response[iResponse].SelectSingleNode("VENDER_PAY_RATE").InnerText;
// lblovertime.Text = Response[iResponse].SelectSingleNode("OVERTIME_PAY_RATE").InnerText;
txtvendorot_pay.Value = Response[iResponse].SelectSingleNode("VENDER_OT_PAY_RATE").InnerText;
//lbldouble.Text = Response[iResponse].SelectSingleNode("DOUBLE_PAY_RATE").InnerText;
txtvendordbl_pay.Value = Response[iResponse].SelectSingleNode("VENDER_DT_PAY_RATE").InnerText;
txtst_bill_rate_from.Value = Response[iResponse].SelectSingleNode("STD_BILL_RATE").InnerText;
txtbasesallary.Value = Response[iResponse].SelectSingleNode("BASE_SALARY").InnerText;
txtmarkup.Value = Response[iResponse].SelectSingleNode("MARK_UP").InnerText;
txtbenifits.Text = Response[iResponse].SelectSingleNode("BENIFITS").InnerText;
txtbouns.Value = Response[iResponse].SelectSingleNode("BONUS").InnerText;
txtcontstart.Value = DateTime.Parse(Response[iResponse].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("dd MMM, yyyy");
txtendstart.Value = DateTime.Parse(Response[iResponse].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("dd MMM, yyyy");
txtjobstart.Value = DateTime.Parse(Response[iResponse].SelectSingleNode("CONTRACT_START_DATE").InnerText).ToString("dd MMM, yyyy");
if ((txtstd_pay_rate_from.Value == "" || txtstd_pay_rate_from.Value == "0") && (txtst_bill_rate_from.Value == "" || txtst_bill_rate_from.Value == "0") && (txtbasesallary.Value != "" || txtbasesallary.Value != "0"))
{
newdiv.Visible = false;
markupdiv.Visible = false;
permentdiv.Visible = true;
divposition.Visible = false;
divjobstart.Visible = true;
}
else if ((txtst_bill_rate_from.Value == null || txtst_bill_rate_from.Value == "0") && (txtstd_pay_rate_from.Value != null || txtstd_pay_rate_from.Value != "0") && (txtbasesallary.Value == "" || txtbasesallary.Value == "0"))
{
newdiv.Visible = false;
markupdiv.Visible = true;
permentdiv.Visible = false;
divposition.Visible = true;
divjobstart.Visible = false;
}
else
{
newdiv.Visible = true;
markupdiv.Visible = false;
permentdiv.Visible = false;
divposition.Visible = true;
divjobstart.Visible = false;
}
txtcomment.Text = Server.HtmlDecode(Response[iResponse].SelectSingleNode("COMMENTS").InnerText);
string job = Response[iResponse].SelectSingleNode("JOB_ID").InnerText;
//API.Service web1 = new API.Service();
//XmlDocument dom2 = new XmlDocument();
////string strID = Request.QueryString["ID"];
//dom2.LoadXml("<XML>" + web1.get_rating_with_jobid(Session["Email"].ToString(), Session["P@ss"].ToString(), job).InnerXml + "</XML>");
//XmlNodeList Response88 = dom2.SelectNodes("XML/RESPONSE");
// XmlNodeList Response3 = dom2.SelectNodes("XML/RESPONSE/QUESTIONS_NO ");
// txtQuestion1.Text = Response3[iResponse].SelectSingleNode("QUESTION1").InnerText;
// if (txtQuestion1.Text == "")
// {
// }
// else
// {
// display = 1;
// }
// txtQuestion2.Text = Response3[iResponse].SelectSingleNode("QUESTION2").InnerText;
// txtquestion3.Text = Response3[iResponse].SelectSingleNode("QUESTION3").InnerText;
// txtquestion4.Text = Response3[iResponse].SelectSingleNode("QUESTION4").InnerText;
// txtquestion5.Text = Response3[iResponse].SelectSingleNode("QUESTION5").InnerText;
// txtRating1.Text = Response3[iResponse].SelectSingleNode("RATING1").InnerText;
// txtRating2.Text = Response3[iResponse].SelectSingleNode("RATING2").InnerText;
// txtRating3.Text = Response3[iResponse].SelectSingleNode("RATING3").InnerText;
// txtRating4.Text = Response3[iResponse].SelectSingleNode("RATING4").InnerText;
// txtRating5.Text = Response3[iResponse].SelectSingleNode("RATING5").InnerText;
API.Service web1 = new API.Service();
// API.Service web1 = new API.Service();
XmlDocument dom2 = new XmlDocument();
// int jobID = 0;
//string strID = Request.QueryString["ID"];
dom2.LoadXml("<XML>" + web1.get_jobrating(Session["Email"].ToString(), Session["P@ss"].ToString(), jobID.ToString()).InnerXml + "</XML>");
XmlNodeList Response3 = dom2.SelectNodes("XML/RESPONSE/QUESTIONS_NO ");
string que1 = "";
string que2 = "";
string que3 = "";
string que4 = "";
string que5 = "";
string rating1 = "";
string rating2 = "";
string rating3 = "";
string rating4 = "";
string rating5 = "";
try
{
//que1 = Server.HtmlDecode(Response3[intCount1].SelectSingleNode("QUESTION1").InnerText);
que1 = Server.HtmlDecode(Response3[intCount1].SelectSingleNode("QUESTION1").InnerText);
que2 = Response3[intCount1].SelectSingleNode("QUESTION2").InnerText;
que3 = Response3[intCount1].SelectSingleNode("QUESTION3").InnerText;
que4 = Response3[intCount1].SelectSingleNode("QUESTION4").InnerText;
que5 = Response3[intCount1].SelectSingleNode("QUESTION5").InnerText;
rating1 = Response3[intCount1].SelectSingleNode("RATING1").InnerText;
rating2 = Response3[intCount1].SelectSingleNode("RATING2").InnerText;
rating3 = Response3[intCount1].SelectSingleNode("RATING3").InnerText;
rating4 = Response3[intCount1].SelectSingleNode("RATING4").InnerText;
rating5 = Response3[intCount1].SelectSingleNode("RATING5").InnerText;
}
catch (Exception ex)
{
//nothing
//que1 = "";
}
//if (que1 == "")
//{
// divstar.Visible = false;
//}
//else
//{
// divstar.Visible = true;
//}
txtQuestion1.Text = que1;
txtQuestion2.Text = que2;
txtquestion3.Text = que3;
txtquestion4.Text = que4;
txtquestion5.Text = que5;
txtRating1.Text = rating1;
txtRating2.Text = rating2;
txtRating3.Text = rating3;
txtRating4.Text = rating4;
txtRating5.Text = rating5;
}
protected void btnaddjob_Click(object sender, EventArgs e)
{
string UserID = "";
int sCheckedUrgent = 0;
if (checkurgent.Checked.ToString() == "true")
{
sCheckedUrgent = 1;
}
else
{
sCheckedUrgent = 0;
}
int jobID = 0;
if (Request.QueryString["jobID"] != "")
{
jobID = Int32.Parse(Request.QueryString["jobID"].Substring(Request.QueryString["jobID"].Length - 7));
}
// string UserID = "";
API.Service web = new API.Service();
// API.Service web = new API.Service();
XmlDocument dom1 = new XmlDocument();
UserID = Session["UserID"].ToString();
dom1.LoadXml("<XML>" + web.get_job_detail_id(Session["Email"].ToString(), Session["P@ss"].ToString(), jobID.ToString()).InnerXml + "</XML>");
XmlNodeList Response1 = dom1.SelectNodes("XML/RESPONSE");
string detailid = Response1.Item(0).SelectSingleNode("JOB_DETAIL_ID").InnerText;
if (newdiv.Visible == true && markupdiv.Visible == false && permentdiv.Visible == false && divposition.Visible == true && divjobstart.Visible == false)
{
dom1.LoadXml("<XML>" + web.update_job(jobID.ToString(), detailid, ddljobStatus.Text,
txtjobtitle.Value, ddldepartment.Text, Convert.ToString(Session["ClientID"]),
ddlpositiontype.Text, txtnumberofopning.Value,
ddlvendor.Text, ddllocation.Text, txttraveltime.Value, txthoursperday.Value,
txtroles_and_responsibility.Text, txthiremanagername.Value, txtcoordinator.Value,
txtcontstart.Value, txtendstart.Value, txtmaxsub.Value, ddlreasonforopen.SelectedValue,
ddlinterviw.SelectedValue, sCheckedUrgent.ToString(), Session["Email"].ToString(),
Session["P@ss"].ToString(), "0", ddlmove.SelectedValue, "0", txtst_bill_rate_from.Value
, "0", "0", txtcomment.Text, "0", "0", "0", UserID, "0", "0", "0", "1").InnerXml + "</XML>");
}
else if (newdiv.Visible == false && markupdiv.Visible == true && permentdiv.Visible == false && divposition.Visible == true && divjobstart.Visible == false)
{
dom1.LoadXml("<XML>" + web.update_job(jobID.ToString(), detailid, ddljobStatus.Text,
txtjobtitle.Value, ddldepartment.Text, Convert.ToString(Session["ClientID"]),
ddlpositiontype.Text, txtnumberofopning.Value,
ddlvendor.Text, ddllocation.Text, txttraveltime.Value, txthoursperday.Value,
txtroles_and_responsibility.Text, txthiremanagername.Value, txtcoordinator.Value,
txtcontstart.Value, txtendstart.Value, txtmaxsub.Value, ddlreasonforopen.SelectedValue,
ddlinterviw.SelectedValue, sCheckedUrgent.ToString(), Session["Email"].ToString(), Session["P@ss"].ToString(), txtstd_pay_rate_from.Value,
ddlmove.SelectedValue, txtmarkup.Value, "0", "0", "0",
txtcomment.Text, txtvendor_pay.Value, txtvendorot_pay.Value, txtvendordbl_pay.Value,
UserID, "0", "0", "0", "1").InnerXml + "</XML>");
}
else
{
dom1.LoadXml("<XML>" + web.update_job(jobID.ToString(), detailid, ddljobStatus.Text,
txtjobtitle.Value, ddldepartment.Text, Convert.ToString(Session["ClientID"]),
ddlpositiontype.Text, txtnumberofopning.Value,
ddlvendor.Text, ddllocation.Text, txttraveltime.Value, txthoursperday.Value,
txtroles_and_responsibility.Text, txthiremanagername.Value, txtcoordinator.Value,
txtjobstart.Value, "", txtmaxsub.Value, ddlreasonforopen.SelectedValue,
ddlinterviw.SelectedValue, sCheckedUrgent.ToString(), Session["Email"].ToString(), Session["P@ss"].ToString(), txtstd_pay_rate_from.Value,
ddlmove.SelectedValue, txtmarkup.Value, "0", "0", "0",
txtcomment.Text, txtvendor_pay.Value, txtvendorot_pay.Value, txtvendordbl_pay.Value,
UserID, txtbouns.Value, txtbenifits.Text.Replace("'", "''"), txtbasesallary.Value, "1").InnerXml + "</XML>");
}
XmlNodeList Response = dom1.SelectNodes("XML/RESPONSE");
if (Response.Item(0).SelectSingleNode("UPDATE_VALUE").InnerText == "1")
{
if (txtQuestion1.Text != "")
{
API.Service web1 = new API.Service();
// localhost.Service web1 = new localhost.Service();
XmlDocument dom2 = new XmlDocument();
dom2.LoadXml("<XML>" + web1.update_jobrating(Session["Email"].ToString(), Session["P@ss"].ToString(), ddlvendor.Text, Session["ClientID"].ToString(), txtQuestion1.Text, txtRating1.Text, txtQuestion2.Text, txtRating2.Text, txtquestion3.Text, txtRating3.Text, txtquestion4.Text, txtRating4.Text, txtquestion5.Text, txtRating5.Text, UserID, jobID.ToString()).InnerXml + "</XML>");
// dom1.LoadXml("<XML>" + web.Insert_Job_Questions(Session["Email"].ToString(), Session["P@ss"].ToString(), "0", ddlvendor.DataValueField , Session["ClientID"].ToString(), txtQuestion1.Text, txtRating1.Text, txtQuestion2.Text, txtRating2.Text, txtquestion3.Text, txtRating3.Text, txtquestion4.Text, txtRating4.Text, txtquestion5.Text, txtRating5.Text, UserID, job).InnerXml + "</XML>");
XmlNodeList Response2 = dom2.SelectNodes("XML/RESPONSE");
if (Response2.Item(0).SelectSingleNode("STATUS").InnerText == "1")
{
lblTableData.Text = "New Job Added succcessfully";
// lblTableData.Text = " Job updated succcessfully";
API.Service jobInfo = new API.Service();
XmlDocument xmldoc = new XmlDocument();
xmldoc.LoadXml("<XML>" + jobInfo.get_Jobs(jobID.ToString(), Session["Email"].ToString(), Session["P@ss"].ToString(), ddlvendor.Text, Session["UserID"].ToString(), Session["ClientID"].ToString()).InnerXml + "</XML>");
XmlNodeList Response7 = xmldoc.SelectNodes("XML/RESPONSE/JOBS ");
string jobtitle = Server.HtmlDecode(Response7[iResponse].SelectSingleNode("JOB_TITLE").InnerText);
string location = Response7[iResponse].SelectSingleNode("JOB_LOCATION").InnerText;
string noofopning = Response7[iResponse].SelectSingleNode("NO_OF_OPENINGS").InnerText;
string desc = Server.HtmlDecode(Response7[iResponse].SelectSingleNode("JOB_DESC").InnerText);
semail.sendEmail("*****@*****.**", " job upated by client " + Session["clientname"].ToString(), "<br>Client ID :" + Session["ClientID"].ToString() +
"<br>Client Name :" + Session["clientname"].ToString() +
"<br>jobId :" + jobID +
"<br>job Title :" + jobtitle +
"<br>job Description :" + desc +
"<br>location :" + location +
"<br>No of Openings :" + noofopning +
"<br><br>**" +
"<br>This notification was sent by FlentisPRO.If you have any questions regarding this notice," +
"<br>please contact the SAP Fieldglass Helpdesk at:" +
"<br>mailto:[email protected]" +
"<br>By Phone:" +
"<br>US(toll free) 1 800 123 1234" +
"<br>Please do not respond to this email, this is an automatic email message and this mailbox is not being monitored.", "", "");
HttpContext.Current.Response.Redirect("Client_Job_Details.aspx?jopen=Y&p=JV&jobID=" + Request.QueryString["jobID"] + "&u=y");
}
}
else
{
lblTableData.Text = " rating not updated ";
}
}
else
{
lblTableData.Text = " Job not updated ";
}
}
