protected void Page_Load(object sender, EventArgs e) { string sDates = ""; string sDateDetails = ""; string sTable = ""; string disable = ""; string rejected = ""; string more_info = ""; string cand_approve = ""; string interview_date = ""; string interview_confirm1 = ""; string interview_time = ""; string schedule = ""; string job_end_date = ""; string emp_end_date = ""; string job_id = ""; string more_info_reply = ""; string message_time = ""; string vendor_reject_candidate = ""; string interview_rescheduled; conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["dbconn"].ConnectionString); //show timesheets needed to be approved try { if (conn.State == System.Data.ConnectionState.Closed) { conn.Open(); //string sqlGetJobCountNoAction = " select distinct ed.create_date " + // " from ovms_employee_details ed, ovms_employees em, ovms_employee_actions ea " + // " where ed.employee_id = em.employee_id " + // " and ed.create_date <= '" + sDate + "' " + // " and ed.active = 1 " + // " and em.active = 1 " + // " and ea.client_id = em.client_id " + // " and em.client_id = " + Session["ClientID"].ToString() + " " + // " and em.employee_id not in (select employee_id from ovms_employee_actions as ea ) " + // " and ed.first_name <> '' " + // " order by ed.create_date asc"; //SqlCommand cmdGetNoAction = new SqlCommand(sqlGetJobCountNoAction, conn); //SqlDataReader rsGetNoAction = cmdGetNoAction.ExecuteReader(); //string sPopulateDrop = ""; //if (rsGetNoAction.HasRows == true) //{ // sDates = ""; // while (rsGetNoAction.Read()) // { // sDates = sDates + "<optgroup label='" + rsGetNoAction["create_date"].ToString().Replace("12:00:00 AM", "") + "'>here"; string sqlGetActionDetailsNoFeedback = " select distinct concat('W', clt.client_alias, '00', right('0000' + convert(varchar(4), em.employee_id), 4)) employee_id, ed.create_date , " + " (select job_title from ovms_jobs where job_id = (select job_id from ovms_employees where employee_id = ed.employee_id)) as job_Title, " + " dbo.CamelCase(ed.First_Name) as First_Name, " + " dbo.CamelCase(ed.Last_Name) as Last_Name, " + " em.vendor_id, em.client_Id, em.job_id,j.contract_start_date,j.contract_end_date,ed.end_date,ed.start_date, " + " em.user_id from ovms_employee_details ed " + " inner join ovms_candidate_feedback as f on f.emplyee_id = ed.employee_id, " + " ovms_jobs as j , " + " ovms_employees em, ovms_clients as clt, ovms_employee_actions eact " + " where ed.employee_id = em.employee_id " + " and em.client_id = clt.client_id and ed.active = 1 " + " and em.active = 1 " + " and j.job_id = em.job_id " + " and eact.client_id = em.client_id " + " and em.client_id = " + Session["ClientID"].ToString() + " " + " and em.employee_id not in (select employee_id from ovms_employee_actions as eact ) " + " and ed.first_name <> ''"; SqlCommand cmdActionDetails = new SqlCommand(sqlGetActionDetailsNoFeedback, conn); SqlDataReader rsGetNoActionDetails = cmdActionDetails.ExecuteReader(); sDateDetails = ""; sTable = sTable + "<tbody>"; if (rsGetNoActionDetails.HasRows == true) { while (rsGetNoActionDetails.Read()) { sTable = sTable + "<tr>"; sTable = sTable + "<td><a target='_blank' href='Client_View_Worker_detail.aspx?wopen=Y&p=VW&empid=" + rsGetNoActionDetails["employee_id"].ToString() + "'>" + rsGetNoActionDetails["employee_id"].ToString() + " </a></td> "; sTable = sTable + "<td>" + func.FixString(rsGetNoActionDetails["First_Name"].ToString()) + " " + func.FixString(rsGetNoActionDetails["Last_Name"].ToString()) + "</td> "; sTable = sTable + "<td>" + rsGetNoActionDetails["job_Title"].ToString() + " </td> "; string employee2 = rsGetNoActionDetails["employee_id"].ToString(); string employeeID = (employee2.Substring(employee2.Length - 6)); API.Service getMSGcount = new API.Service(); XmlDocument doc1 = new XmlDocument(); doc1.LoadXml("<XML>" + getMSGcount.get_message_count_interview_client(Session["Email"].ToString(), Session["P@ss"].ToString(), employeeID).InnerXml + "</XML>"); XmlNodeList Response07 = doc1.SelectNodes("XML/RESPONSE/MESSAGE "); if (Response07.Count != 0) { sTable = sTable + "<td><font color='red'><blink><i class='fa fa-fw fa-envelope-o'></i></blink></font><br><a target='_blank' href='C_Dashboard.aspx?wopen=Y&p=VW&done_dash=" + rsGetNoActionDetails["employee_id"].ToString() + "&job_id=" + rsGetNoActionDetails["job_id"].ToString() + "&job_end_date=" + rsGetNoActionDetails["contract_end_date"].ToString() + "&emp_enddate=" + rsGetNoActionDetails["end_date"].ToString() + "'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 target='_blank' href='C_Dashboard.aspx?wopen=Y&p=VW&Reject_dash=" + rsGetNoActionDetails["employee_id"].ToString() + "&job_id=" + rsGetNoActionDetails["job_id"].ToString() + "&job_end_date=" + rsGetNoActionDetails["contract_end_date"].ToString() + "&emp_enddate=" + rsGetNoActionDetails["end_date"].ToString() + "' class='btn btn-danger btn-xs' data-toggle='tooltip' data-placement='top' name='abc' title='Reject Candidate'><i class='fa fa-times'></i></a> " + "<a target='_blank' href='C_Dashboard.aspx?wopen=Y&p=VW&emp_id=" + rsGetNoActionDetails["employee_id"].ToString() + "&schedule_int=" + schedule + "&forImsgDash=" + 1 + "'class='btn btn-primary btn-xs' data-toggle='tooltip' data-placement='top' name='abc' title='Send Comments To Vendor'><i class='fa fa-comment''></i></a></td>"; } else { sTable = sTable + "<td><a target='_blank' href='C_Dashboard.aspx?wopen=Y&p=VW&done_dash=" + rsGetNoActionDetails["employee_id"].ToString() + "&job_id=" + rsGetNoActionDetails["job_id"].ToString() + "&job_end_date=" + rsGetNoActionDetails["contract_end_date"].ToString() + "&emp_enddate=" + rsGetNoActionDetails["end_date"].ToString() + "'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 target='_blank' href='C_Dashboard.aspx?wopen=Y&p=VW&Reject_dash=" + rsGetNoActionDetails["employee_id"].ToString() + "&job_id=" + rsGetNoActionDetails["job_id"].ToString() + "&job_end_date=" + rsGetNoActionDetails["contract_end_date"].ToString() + "&emp_enddate=" + rsGetNoActionDetails["end_date"].ToString() + "' class='btn btn-danger btn-xs' data-toggle='tooltip' data-placement='top' name='abc' title='Reject Candidate'><i class='fa fa-times'></i></a> " + "<a target='_blank' href='C_Dashboard.aspx?wopen=Y&p=VW&emp_id=" + rsGetNoActionDetails["employee_id"].ToString() + "&schedule_int=" + schedule + "&forImsgDash=" + 1 + "'class='btn btn-primary btn-xs' data-toggle='tooltip' data-placement='top' name='abc' title='Send Comments To Vendor'><i class='fa fa-comment''></i></a></td>"; } sTable = sTable + "</tr>"; } //close rsGetNoActionDetails.Close(); cmdActionDetails.Dispose(); } else { sTable = sTable + "<tr>"; sTable = sTable + "<td colspan=3>No Candidate at this time</td>"; sTable = sTable + "</tr>"; } sTable = sTable + "</tbody>"; lblTableData.Text = sTable; } } catch (Exception ex) { // } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } }