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