protected DataTable loadDataTable() { DataTable DT = new DataTable(); string sType = Request.QueryString["t"]; if (sType != null) { if (sType == "candidato") { var candidatos = InformacionPersonalCandidatoService.GetCandidatos(); if (candidatos != null) { DT.Clear(); DT.Columns.AddRange(new DataColumn[] { new DataColumn("Nombre"), new DataColumn("Apellido"), new DataColumn("Correo"), new DataColumn("Telefono"), new DataColumn("Nacionalidad"), new DataColumn("RFC"), new DataColumn("Direccion") }); foreach (var cand in candidatos) { DT.Rows.Add(new object[] { cand.Nombre, cand.Apellido, cand.Correo, cand.Telefono, cand.Nacionalidad, cand.RFC, cand.Direccion }); DT.AcceptChanges(); } } } else if (sType == "juez") { var jueces = InformacionPersonalJuezService.GetJueces(); if (jueces != null) { DT.Clear(); DT.Columns.AddRange(new DataColumn[] { new DataColumn("Nombre"), new DataColumn("Apellido"), new DataColumn("Correo") }); foreach (var juez in jueces) { DT.Rows.Add(new object[] { juez.Nombre, juez.Apellido, juez.Correo }); DT.AcceptChanges(); } } } } return(DT); }
private void LoadCandidateTable() { litUsuarios.Text = "Candidatos"; var candidatos = InformacionPersonalCandidatoService.GetCandidatos(); string sType = Request.QueryString["t"]; if (candidatos != null) { foreach (var cand in candidatos) { TableRow tr = new TableRow(); // profile image column TableCell tdIP = new TableCell(); tdIP.CssClass = "dt-profile-pic"; tdIP.Attributes.Add("onclick", "window.open('AdministraInformacionPersonal.aspx?id=" + cand.cveCandidato + "&t=" + sType + "');"); Image ipImage = new Image(); if (cand.NombreImagen != null) { ipImage.ImageUrl = "/ProfilePictures/" + cand.NombreImagen; } else { ipImage.ImageUrl = "/Resources/img/default-pp.jpg"; } ipImage.CssClass = "avatar img-circle"; ipImage.AlternateText = "avatar"; ipImage.Style.Add("width", "28px"); ipImage.Style.Add("height", "28px"); tdIP.Controls.Add(ipImage); // name column TableCell tdName = new TableCell(); tdName.Text = cand.Nombre; tdName.Attributes.Add("onclick", "window.open('AdministraInformacionPersonal.aspx?id=" + cand.cveCandidato + "&t=" + sType + "');"); // last name column TableCell tdLastName = new TableCell(); tdLastName.Text = cand.Apellido; tdLastName.Attributes.Add("onclick", "window.open('AdministraInformacionPersonal.aspx?id=" + cand.cveCandidato + "&t=" + sType + "');"); TableCell tdEmail = new TableCell(); LiteralControl lcMailLink = new LiteralControl("<a href=\"mailto:" + cand.Correo + "?Subject=Premios%20Institucionales\" target=\"_top\"> " + cand.Correo + "</a>"); tdEmail.Controls.Add(lcMailLink); TableCell tdPhone = new TableCell(); tdPhone.Text = cand.Telefono; tdPhone.Attributes.Add("onclick", "window.open('AdministraInformacionPersonal.aspx?id=" + cand.cveCandidato + "&t=" + sType + "');"); TableCell tdNationality = new TableCell(); tdNationality.Text = cand.Nacionalidad; tdNationality.Attributes.Add("onclick", "window.open('AdministraInformacionPersonal.aspx?id=" + cand.cveCandidato + "&t=" + sType + "');"); TableCell tdRFC = new TableCell(); tdRFC.Text = cand.RFC; tdRFC.Attributes.Add("onclick", "window.open('AdministraInformacionPersonal.aspx?id=" + cand.cveCandidato + "&t=" + sType + "');"); TableCell tdAddress = new TableCell(); tdAddress.Text = cand.Direccion; tdAddress.Attributes.Add("onclick", "window.open('AdministraInformacionPersonal.aspx?id=" + cand.cveCandidato + "&t=" + sType + "');"); TableCell tdConfirmacion = new TableCell(); tdConfirmacion.Attributes.Add("onclick", "window.open('AdministraInformacionPersonal.aspx?id=" + cand.cveCandidato + "&t=" + sType + "');"); LiteralControl lcConfirmacion; if (cand.Confirmado.HasValue && cand.Confirmado.Value) { tdConfirmacion.Style.Add("color", "#4caf50"); lcConfirmacion = new LiteralControl("<strong> <div style=\"display: none; \"> 2 </div> Confirmado </strong>"); } else { tdConfirmacion.Style.Add("color", "#f9a825"); lcConfirmacion = new LiteralControl("<strong> <div style=\"display: none; \"> 2 </div> Sin confirmar </strong>"); } tdConfirmacion.Controls.Add(lcConfirmacion); // status column TableCell tdPrivacidad = new TableCell(); tdPrivacidad.Attributes.Add("onclick", "window.open('AdministraInformacionPersonal.aspx?id=" + cand.cveCandidato + "&t=" + sType + "');"); LiteralControl lcPrivacidad; if (cand.FechaPrivacidadDatos != null) { tdPrivacidad.Style.Add("color", "#4caf50"); lcPrivacidad = new LiteralControl("<strong> <div style=\"display: none; \"> 2 </div> Aceptado </strong>"); } else { tdPrivacidad.Style.Add("color", "#f9a825"); lcPrivacidad = new LiteralControl("<strong> <div style=\"display: none; \"> 2 </div> Sin aceptar </strong>"); } tdPrivacidad.Controls.Add(lcPrivacidad); tr.Controls.Add(tdIP); tr.Controls.Add(tdName); tr.Controls.Add(tdLastName); tr.Controls.Add(tdEmail); tr.Controls.Add(tdPhone); tr.Controls.Add(tdNationality); tr.Controls.Add(tdRFC); tr.Controls.Add(tdAddress); tr.Controls.Add(tdConfirmacion); tr.Controls.Add(tdPrivacidad); listaCandidatosTableBody.Controls.Add(tr); } } }