private void ViewcandidateInTable()
{
string sTable = "<tbody>";
API.Service getWorkers = new API.Service();
// API.Service getWorkers = new API.Service();
XmlDocument dom1 = new XmlDocument();
dom1.LoadXml("<XML>" + getWorkers.get_employees(Session["Email"].ToString(), Session["P@ss"].ToString(), "", "", Session["ClientID"].ToString(), "", "", "1", "").InnerXml + "</XML>");
XmlNodeList Response = dom1.SelectNodes("XML/RESPONSE/EMPLOYEE_NAME_ID");
int CountRows = 1;
sTable = "";
string _sBackground = "";
for (int iResponse = 0; iResponse < Response.Count; iResponse++)
{
if (CountRows % 2 >= 1)
{
//enableordisable = "";
_sBackground = "bgcolor='#ECF0F1'";
}
else
{
// enableordisable = "disabled";
_sBackground = "";
}
string worker_status = Response[iResponse].SelectSingleNode("CANDIDATE_APPROVE").InnerText;
DateTime candidate_start_date = DateTime.Parse(Response[iResponse].SelectSingleNode("STARTDATE").InnerText);
DateTime job_start_date = DateTime.Parse(Response[iResponse].SelectSingleNode("CONTRACT_START_DATE").InnerText);
DateTime thisday = DateTime.Today;
if (worker_status == "1" && (candidate_start_date <= thisday))
{
sTable = sTable + "<tr " + _sBackground + ">";
sTable = sTable + "<td>" + CountRows + "</td>";
//sTable = sTable + "<td>" + Response[iResponse].SelectSingleNode("ACTIVE").InnerText + " </TD>";
sTable = sTable + "<td><a href='Client_View_Worker_detail.aspx?wopen=Y&p=VW&empid=" + Response[iResponse].SelectSingleNode("EMPLOYEE_ID").InnerText + "'>" + Response[iResponse].SelectSingleNode("EMPLOYEE_ID").InnerText + "</a> </td> ";
sTable = sTable + "<td>" + func.FixString(Response[iResponse].SelectSingleNode("FIRSTNAME").InnerText + " " + Response[iResponse].SelectSingleNode("LASTNAME").InnerText) + "</td> ";
sTable = sTable + "<td>" + func.FixString(Response[iResponse].SelectSingleNode("JOB_TITLE").InnerText) + " </td> ";
sTable = sTable + "<td>" + func.FixString(Response[iResponse].SelectSingleNode("LOCATION").InnerText) + " </td> ";
sTable = sTable + "<td>" + DateTime.Parse(Response[iResponse].SelectSingleNode("STARTDATE").InnerText).ToString("dd MMM, yyyy") + " </td> ";
sTable = sTable + "<td>" + DateTime.Parse(Response[iResponse].SelectSingleNode("ENDDATE").InnerText).ToString("dd MMM, yyyy") + " </td> ";
sTable = sTable + "</tr>";
CountRows++;
}
}
sTable = sTable + "</tbody>";
getWorkers.Dispose();
lblTableData.Text = sTable;
}
protected void btnsend_Click(object sender, EventArgs e)
{
///get job_id using employyee_id
string empid_url = Request["empid"];
int empid_url1 = Int32.Parse(Request["empid"].Substring(Request["empid"].Length - 6));
// API.Service setfeedback = new API.Service();
API.Service setfeedback = new API.Service();
XmlDocument dom1 = new XmlDocument();
dom1.LoadXml("<XML>" + setfeedback.get_employees(Session["Email"].ToString(), Session["P@ss"].ToString(), empid_url1.ToString(), Session["VendorID"].ToString(), Session["ClientID"].ToString(), "", "", "1", "").InnerXml + "</XML>");
XmlNodeList Response = dom1.SelectNodes("XML/RESPONSE/EMPLOYEE_NAME_ID");
// lblname.Text = func.FixString(Response[iResponse].SelectSingleNode("FIRSTNAME").InnerText) + " " + func.FixString(Response[iResponse].SelectSingleNode("LASTNAME").InnerText);
jobid_feed = Response[iResponse].SelectSingleNode("JOB_ID").InnerText;
///get feedback id using employyee_id,jobid,client id,vendor id
dom1.LoadXml("<XML>" + setfeedback.get_v_feedback(Session["Email"].ToString(), Session["P@ss"].ToString(), "", empid_url1.ToString(), "", Session["VendorID"].ToString(), Session["ClientID"].ToString()).InnerXml + "</XML>");
XmlNodeList Response5 = dom1.SelectNodes("XML/RESPONSE/FEEDBACK");
string feedback_id = Response5[iResponse].SelectSingleNode("FEEEDBACK_ID").InnerText;
/// insert comment in to table
dom1.LoadXml("<XML>" + setfeedback.insert_c_comments_feedback(Session["Email"].ToString(), Session["P@ss"].ToString(), jobid_feed, txtfeedcomment.Text, empid_url1.ToString(), Session["VendorID"].ToString(), Session["ClientID"].ToString(), feedback_id).InnerXml + "</XML>");
XmlNodeList Response2 = dom1.SelectNodes("XML/RESPONSE");
if (Response2.Item(0).SelectSingleNode("STATUS").InnerText == "1")
{
HttpContext.Current.Response.Redirect("C_View_Candidate.aspx?wopen=Y&p=VW&empid=" + empid_url);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//update timesheet status
if (Request.QueryString["action"] != null)
{
//timesheet popup modal action text
//lblAction.Text = "Timesheet Action";
// lblActionTimeSheet.Text = "Are you sure you want to " + Request.QueryString["action"] + " this timesheet?";
if (Request.QueryString["ModalAction"] != null)
{
//update status
conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["dbconn"].ConnectionString);
try
{
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
string _TimeSheetID = "0";
string sqlGetTimeSheetID = "";
//start, end and weeks
//get timesheetID + 7
sqlGetTimeSheetID = " select timesheet_id " +
" from ovms_timesheet " +
" where day = " + Request.QueryString["fromD"].ToString() + " " +
" and month = " + Request.QueryString["FromM"].ToString() + " " +
" and year = " + Request.QueryString["FromY"].ToString() + " " +
" and employee_id = " + Request.QueryString["TID"].ToString() + " " +
" and active = 1";
SqlCommand cmdGetTimeSheetID = new SqlCommand(sqlGetTimeSheetID, conn);
SqlDataReader rsGetTimeSheetID = cmdGetTimeSheetID.ExecuteReader();
if (rsGetTimeSheetID.HasRows == true)
{
while (rsGetTimeSheetID.Read())
{
_TimeSheetID = rsGetTimeSheetID["timesheet_id"].ToString();
}
}
//close
rsGetTimeSheetID.Close();
cmdGetTimeSheetID.Dispose();
string sSQLUpdate = "";
string sAction = "";
if (Request.QueryString["action"] == "Approve")
{
//update
sAction = "Approve";
sSQLUpdate = " update ovms_timesheet_details " +
" set timesheet_status_id = 1 " +
" where timesheet_id between " + _TimeSheetID + " and " + (Convert.ToInt32(_TimeSheetID.ToString()) + +Convert.ToInt32("6")) + " " +
" and active = 1";
string emp_id = Request.QueryString["TID"].ToString();
string totalhours = Request.QueryString["hours"].ToString();
string name = Request.QueryString["Mess"].ToString();
// string vendor_email = Session["Vendor_Email"].ToString();
semail.sendEmail("*****@*****.**", "TIMESHEET is approved - (" + name + ")", "<br>Worker ID :" + emp_id +
"<br>Time Sheet Billable Days : 7 days" +
"<br>Time Sheet Billable Hours :" + totalhours +
"<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.", "", "");
}
if (Request.QueryString["action"] == "Reject")
{
//update
string emp_id = Request.QueryString["TID"].ToString();
string reason_of_rejection = Request.QueryString["reason"].ToString();
string day = Request.QueryString["fromD"].ToString();
string month = Request.QueryString["FromM"].ToString();
string year = Request.QueryString["FromY"].ToString();
// string test = year + month + day;
DateTime tsheet_strt_date = Convert.ToDateTime(day + "/" + month + "/" + year);
DateTime tsheet_end_date = tsheet_strt_date.AddDays(7);
sAction = "Reject";
sSQLUpdate = " update ovms_timesheet_details " +
" set timesheet_status_id = 2 " +
" where timesheet_id between " + _TimeSheetID + " and " + (Convert.ToInt32(_TimeSheetID.ToString()) + +Convert.ToInt32("6")) + " " +
" and active = 1";
sSQLUpdate = sSQLUpdate + " INSERT INTO ovms_timesheet_comments " +
" (timesheet_id, employee_id, timesheet_comments,from_date, to_date)" +
" VALUES(" + _TimeSheetID + "," + emp_id + " , ' " + reason_of_rejection + "','" + tsheet_strt_date + "' , '" + tsheet_end_date + "')";
string emp_id_reject = Request.QueryString["TID"].ToString();
API.Service name = new API.Service();
XmlDocument _xmlDoc = new XmlDocument();
_xmlDoc.LoadXml("<XML>" + name.get_employees(Session["Email"].ToString(), Session["P@ss"].ToString(), emp_id_reject, "", "", "", "", "1", "").InnerXml + "</XML>");
XmlNodeList ea1 = _xmlDoc.SelectNodes("XML/RESPONSE/EMPLOYEE_NAME_ID");
string name2 = "";
name2 = ea1[iResponse].SelectSingleNode("FIRSTNAME").InnerText;
string job_name = ea1[iResponse].SelectSingleNode("JOB_TITLE").InnerText;
string vendor_email = Session["Vendor_Email"].ToString();
semail.sendEmail("*****@*****.**", "TIMESHEET is rejected - (" + name + ")", "<br>Worker Name :" + name2 +
"<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.", "", "");
}
// Uri uri = new Uri("http://www.opusingats.com/e_Timesheet_Email.aspx?timesheet_id=1");
// string data = "field-keywords=ASP.NET 2.0";
// HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(uri);
// request.Method = WebRequestMethods.Http.Post;
// request.ContentLength = data.Length;
// request.ContentType = "application/x-www-form-urlencoded";
// StreamWriter writer = new StreamWriter(request.GetRequestStream());
// writer.Write(data);
// writer.Close();
// HttpWebResponse response = (HttpWebResponse)request.GetResponse();
// StreamReader reader = new StreamReader(response.GetResponseStream());
// string tmp = reader.ReadToEnd();
// response.Close();
// Response.Write(tmp);
// Response.Write(tmp);
// MailMessage mail = new MailMessage();
// set the addresses
// mail.From = new MailAddress("*****@*****.**"); //IMPORTANT: This must be same as your smtp authentication address.
// mail.To.Add("*****@*****.**");
// set the content
// mail.Subject = "This is an email";
// mail.Body = tmp;
// mail.IsBodyHtml = true;
// send the message
// SmtpClient smtp = new SmtpClient("mail.opusingats.com");
//IMPORANT: Your smtp login email MUST be same as your FROM address.
// NetworkCredential Credentials = new NetworkCredential("*****@*****.**", "Maracaibo15@.");
// smtp.Credentials = Credentials;
// smtp.Send(mail);
// blMessage.Text = "Mail Sent";
SqlCommand cmdUpdateTimeSheet1 = new SqlCommand(sSQLUpdate, conn);
int iUpdate = cmdUpdateTimeSheet1.ExecuteNonQuery();
cmdUpdateTimeSheet1.Dispose();
}
}
catch (Exception ex)
{
string abc = "";
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
} //end of ModalAction
}
Response.Redirect("Client.aspx?TU=True");
Response.End();
//end of update timesheet status
}
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;
}
}
private void ViewinterviewInTable()
{
string sTable = "<tbody>";
API.Service jobInfo = new API.Service();
XmlDocument xmldoc = new XmlDocument();
XmlDocument empcomment = new XmlDocument();
API.Service getWorkers = new API.Service();
DateTime datetoday = System.DateTime.Now;
//xmldoc.LoadXml("<XML>" + jobInfo.get_JobView("*****@*****.**", "ferivan", "2", "", "", "", "", "", "", "").InnerXml + "</XML>");
xmldoc.LoadXml("<XML>" + jobInfo.get_interview(Session["Email"].ToString(), Session["P@ss"].ToString(), Session["VendorID"].ToString(), Session["ClientID"].ToString(), datetoday.ToString()).InnerXml + "</XML>");
XmlNodeList Response = xmldoc.SelectNodes("XML/RESPONSE/INTERVIEW ");
sTable = "";
int CountRows = 1;
string _sBackground = "";
for (int intCount = 0; intCount < Response.Count; intCount++)
{
//if (intCount % 2 >= 1)
//{
// //enableordisable = "";
// _sBackground = "bgcolor='#ECF0F1'";
//}
//else
//{
// // enableordisable = "disabled";
// _sBackground = "";
//}
string iDate = Response[intCount].SelectSingleNode("INTERVIEW_DATE").InnerText;
if (iDate != string.Empty)
{
iDate = DateTime.Parse(Response[intCount].SelectSingleNode("INTERVIEW_DATE").InnerText).ToString("dd MMM, yyyy");
}
else
{
iDate = "N/A";
}
string check_status = Response[intCount].SelectSingleNode("STATUS").InnerText;
if (check_status != "Rejected by Client" && check_status != "Rejected by Vendor")
{
string empid = Response[intCount].SelectSingleNode("EMP_ID").InnerText;
string empid2 = Response[intCount].SelectSingleNode("EMP_ID").InnerText.Substring((empid).Length - 5);
string comment = "";
empcomment.LoadXml("<XML>" + getWorkers.get_employees(Session["Email"].ToString(), Session["P@ss"].ToString(), empid2, Session["VendorID"].ToString(), Session["ClientID"].ToString(), "", "", "1", "").InnerXml + "</XML>");
XmlNodeList commentsemp = empcomment.SelectNodes("XML/RESPONSE/EMPLOYEE_NAME_ID");
try
{
comment = commentsemp[iresponse].SelectSingleNode("INTERVIEW_REQUEST_COMMENT").InnerText;
}
catch
{
comment = "";
}
if (comment == "" || comment == null)
{
comment = "No comments given";
}
sTable = sTable + "<tr " + _sBackground + ">";
sTable = sTable + "<td>" + CountRows + "</td>";
sTable = sTable + "<td><a href='Client_View_Worker_detail.aspx?&empID=" + Response[intCount].SelectSingleNode("EMP_ID").InnerText + "'>" + Response[intCount].SelectSingleNode("EMP_ID").InnerText + "</td>";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("CANDIDATE_NAME").InnerText + "</td> ";
sTable = sTable + "<td>" + Server.HtmlDecode(Response[intCount].SelectSingleNode("JOB_TITLE").InnerText) + " </td> ";
//sTable = sTable + "<td>" + DateTime.Parse(Response[intCount].SelectSingleNode("INTERVIEW_DATE").InnerText).ToString("dd MMM, yyyy") + " </td> ";
sTable = sTable + "<td align='center'>" + iDate + " </td> ";
sTable = sTable + "<td align='center'>" + Response[intCount].SelectSingleNode("INTERVIEW_START_TIME").InnerText + "</td>";
sTable = sTable + "<td align='center'>" + Response[intCount].SelectSingleNode("INTERVIEW_END_TIME").InnerText + "</td>";
sTable = sTable + "<td>" + Response[intCount].SelectSingleNode("INTERVIEWER").InnerText + "</td>";
sTable = sTable + "<td>" + comment + "</td>";
sTable = sTable + "</tr>";
CountRows++;
}
}
sTable = sTable + "</tbody>";
jobInfo.Dispose();
lblTableData.Text = sTable;
}
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();
}