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