public ActionResult DowndZip(string corr_planificacion)
{
Int64 nroTarja = 0;
string planDescJson = new PlanificacionDescBLL().sp_selPlanDescIDBLL(corr_planificacion);
PlanificacionDescBO planDesc = new PlanificacionDescBO();
planDesc = JsonConvert.DeserializeObject <PlanificacionDescBO>(planDescJson);
TarjaDescDetBO tarja = new TarjaDescDetBLL().sp_sel_tarjaDescDetBLL(corr_planificacion);
nroTarja = tarja.Nro_tarja;
string contenedor = planDesc.Cod_contenedor;
var memoryStream = new ZipFotos().crearZip(nroTarja, planDesc.Fecha);
byte[] byteInfo = memoryStream.ToArray();
memoryStream.Write(byteInfo, 0, byteInfo.Length);
memoryStream.Position = 0;
Response.Buffer = true;
string base64string = Convert.ToBase64String(byteInfo);
return(File(byteInfo, "application/gzip", contenedor + ".zip"));
}
public ActionResult CrearPdf(string corr_planificacion)
{
Int64 nroTarja = 0;
string planDescJson = new PlanificacionDescBLL().sp_selPlanDescIDBLL(corr_planificacion);
PlanificacionDescBO planDesc = new PlanificacionDescBO();
planDesc = JsonConvert.DeserializeObject <PlanificacionDescBO>(planDescJson);
TarjaDescDetBO tarja = new TarjaDescDetBLL().sp_sel_tarjaDescDetBLL(corr_planificacion);
nroTarja = tarja.Nro_tarja;
Document doc = new Document(PageSize.A4.Rotate());
MemoryStream outstreem = new MemoryStream();
string fileName = null;
PdfWriter.GetInstance(doc, outstreem).CloseStream = false;
doc.Open();
doc = new PdfDesco().BindingData(doc, planDesc, tarja);
fileName = "reporte-" + nroTarja;
doc.Close();
byte[] byteInfo = outstreem.ToArray();
outstreem.Write(byteInfo, 0, byteInfo.Length);
outstreem.Position = 0;
Response.Buffer = true;
string base64string = Convert.ToBase64String(byteInfo);
return(File(byteInfo, "application/pdf"));
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
if (!ValidarCamposBusqueda())
{
llenarGrilla();
return;
}
DateTime date = DateTime.Today;
Random rnd = new Random();
CorrelativoPlan = date.Year.ToString() + date.Month.ToString() + date.Day.ToString() + date.Hour.ToString() + date.Minute.ToString() + date.Second.ToString() + "-" + date.Millisecond.ToString() + rnd.Next(0, 99999);
DataTable dt = new DataTable();
PlanificacionDescBO plan = new PlanificacionDescBO();
plan.Bl = txtBL.Text;
plan.Mddt = txtMddt.Text;
plan.Cod_manifiesto = CorrelativoPlan;
plan.Cod_agencia = Convert.ToInt32(ddlTerminal.SelectedValue);
plan.Cod_nave = ddlNaves.SelectedValue;
plan.Cod_viaje = Convert.ToInt32(txtViaje.Text);
plan.Pue_codO = ddlOrigen.SelectedValue;
plan.Pue_codD = ddlDestino.SelectedValue;
plan.Rut_cliente = Convert.ToInt32(ddlCliente.SelectedValue);
plan.Cod_iso = ddlISO.SelectedValue;
plan.Estado_tarja = 1;
plan.Cod_contenedor = txtContenedor.Text + txtContenedorNum.Text + txtContenedorDV.Text;
plan.Sello1 = txtSello1.Text;
plan.Sello2 = txtSello2.Text;
plan.Sello3 = txtSello3.Text;
plan.Fecha = DateTime.ParseExact(txtFecha.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
plan.HoraI = TimeSpan.ParseExact(txtHoraI.Text, @"h\:mm", CultureInfo.InvariantCulture);
plan.HoraT = TimeSpan.ParseExact(txtHoraT.Text, @"h\:mm", CultureInfo.InvariantCulture);
if (ddlTarjador.SelectedValue != "")
{
plan.Rut_tarjador = Convert.ToInt32(ddlTarjador.SelectedValue);
}
else
{
plan.Rut_tarjador = 0;
}
DateTime pass = DateTime.Today;
plan.Desbloqueo_sello = pass.Month.ToString() + pass.Day.ToString();
try
{
dt = new PlanificacionDescBLL().sp_ins_planDescBLL(plan);
}
catch (Exception ex)
{
throw new Exception("Ha ocurrido el siguiente error: " + ex.ToString());
}
llenarGrilla();
limpiarFormulario();
}
protected void btnModificar_Click(object sender, EventArgs e)
{
if (!ValidarCamposMod())
{
return;
}
DateTime date = DateTime.Today;
Random rnd = new Random();
CorrelativoPlan = date.Year.ToString() + date.Month.ToString() + date.Day.ToString() + date.Hour.ToString() + date.Minute.ToString() + date.Second.ToString() + "-" + date.Millisecond.ToString() + rnd.Next(0, 99999);
DataTable dt = new DataTable();
PlanificacionDescBO plan = new PlanificacionDescBO();
plan.Bl = txtBlMod.Text;
plan.Mddt = txtManoMod.Text;
plan.Cod_manifiesto = corrPlan.Text;
plan.Cod_agencia = Convert.ToInt32(ddlTermMod.SelectedValue);
plan.Cod_nave = ddlNaveMod.SelectedValue;
plan.Cod_viaje = Convert.ToInt32(txtViajeMod.Text);
plan.Pue_codO = ddlPueOrMod.SelectedValue;
plan.Pue_codD = ddlPueDesMod.SelectedValue;
plan.Rut_cliente = Convert.ToInt32(ddlClienteMod.SelectedValue);
plan.Cod_iso = ddlIsoMod.SelectedValue;
plan.Estado_tarja = 1;
plan.Cod_contenedor = txtNumContMod.Text + txtSiglaContMod.Text + txtDvContMod.Text;
plan.Sello1 = txtSello1Mod.Text;
plan.Sello2 = txtSello2Mod.Text;
plan.Sello3 = txtSello3Mod.Text;
plan.Fecha = DateTime.ParseExact(txtFechaMod.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
plan.HoraI = TimeSpan.ParseExact(txtHoraIMod.Text, @"h\:mm", CultureInfo.InvariantCulture);
plan.HoraT = TimeSpan.ParseExact(txtHoraTMod.Text, @"h\:mm", CultureInfo.InvariantCulture);
if (ddlTarjador.SelectedValue != "")
{
plan.Rut_tarjador = Convert.ToInt32(ddlTarjadorMod.SelectedValue);
}
else
{
plan.Rut_tarjador = 0;
}
DateTime pass = DateTime.Today;
plan.Desbloqueo_sello = pass.Month.ToString() + pass.Day.ToString();
try
{
dt = new PlanificacionDescBLL().sp_updt_planDescBLL(plan);
}
catch (Exception ex)
{
throw new Exception("Ha ocurrido el siguiente error: " + ex.ToString());
}
llenarGrilla();
}
public static void EliminarPlan(ref GlobalResponse globalResponse, string corr_planificacion)
{
DataTable dt;
try
{
dt = new PlanificacionDescBLL().sp_del_planDescBLL(corr_planificacion);
}
catch (Exception ex)
{
globalResponse.Message = ex.Message;
globalResponse.HasError = true;
}
}
public string EditarPlan(ref GlobalResponse globalResponse, string corr_planificacion)
{
string planes = string.Empty;
try
{
planes = new PlanificacionDescBLL().sp_selPlanDescIDBLL(corr_planificacion);
}
catch (Exception ex)
{
globalResponse.Message = ex.Message;
globalResponse.HasError = true;
}
return(planes);
}
public static string eliminarPlanDesc(string corr_plan)
{
DataTable dt;
try
{
dt = new PlanificacionDescBLL().sp_del_planDescBLL(corr_plan);
}
catch (Exception ex)
{
throw ex;
}
string codstring = dt.Rows[0].ItemArray[0].ToString();
return(codstring);
}
public string ObtPlanDesco(ref GlobalResponse globalResponse, int rut_cliente)
{
string planes = string.Empty;
try
{
planes = new PlanificacionDescBLL().sp_selPlanDescCliente(rut_cliente);
}
catch (Exception ex)
{
globalResponse.Message = ex.Message;
globalResponse.HasError = true;
}
return(planes);
}
public string ObtPlanDesco(ref GlobalResponse globalResponse, string terminal)
{
string planes = string.Empty;
int cod_term = Convert.ToInt32(terminal);
try
{
planes = new PlanificacionDescBLL().sp_sel_planDescBLL(cod_term);
}
catch (Exception ex)
{
globalResponse.Message = ex.Message;
globalResponse.HasError = true;
}
return(planes);
}
public static void GuardarPlan(ref GlobalResponse globalResponse, string manifiesto, string bl, string mddt, string terminal, string contenedor, string nave, string viaje, string puertOr, string puerDest, string cliente, string iso, string sello, string fecha, string hInicio, string hTermino, string tarjador)
{
PlanificacionDescBO planDesc = new PlanificacionDescBO();
planDesc.Cod_manifiesto = manifiesto;
planDesc.Bl = bl;
planDesc.Mddt = mddt;
planDesc.Cod_agencia = Convert.ToInt32(terminal);
planDesc.Cod_nave = nave;
planDesc.Cod_viaje = Convert.ToInt32(viaje);
planDesc.Pue_codO = puertOr;
planDesc.Pue_codD = puerDest;
planDesc.Rut_cliente = Convert.ToInt32(cliente);
planDesc.Cod_contenedor = contenedor;
planDesc.Cod_iso = iso;
planDesc.Sello1 = sello;
DateTime fch = DateTime.ParseExact(fecha, "dd/MM/yyyy", CultureInfo.InvariantCulture);
planDesc.Fecha = fch;
TimeSpan horaIn = TimeSpan.ParseExact(hInicio, @"h\:mm", CultureInfo.InvariantCulture);
TimeSpan horaTer = TimeSpan.ParseExact(hTermino, @"h\:mm", CultureInfo.InvariantCulture);
planDesc.HoraI = horaIn;
planDesc.HoraT = horaTer;
planDesc.Desbloqueo_sello = fch.Month.ToString() + "" + fch.Day.ToString();
planDesc.Cod_manifiesto = manifiesto;
planDesc.Estado_tarja = 1;
planDesc.Rut_tarjador = Convert.ToInt32(tarjador);
DataTable dt;
try
{
dt = new PlanificacionDescBLL().sp_ins_planDescBLL(planDesc);
}
catch (Exception ex)
{
globalResponse.Message = ex.Message;
globalResponse.HasError = true;
}
}
public static Dictionary <string, string> modificarPlanDesc(string corr_plan)
{
DataTable dt = new DataTable();
try
{
dt = new PlanificacionDescBLL().sp_selPlanDescIDBLL(corr_plan);
}
catch (Exception ex)
{
throw ex;
}
Dictionary <string, string> plan = new Dictionary <string, string>();
var contenedor = dt.Rows[0].ItemArray[4].ToString();
plan.Add("corr_planificacion", dt.Rows[0].ItemArray[0].ToString().Trim());
plan.Add("gls_bl", dt.Rows[0].ItemArray[1].ToString().Trim());
plan.Add("cod_puerto_or", dt.Rows[0].ItemArray[2].ToString().Trim());
plan.Add("cod_puerto_dest", dt.Rows[0].ItemArray[3].ToString().Trim());
plan.Add("numcont", contenedor.Substring(0, 4).Trim());
plan.Add("siglacont", contenedor.Substring(4, 6).Trim());
plan.Add("dvCont", contenedor.Substring(10, 1).Trim());
plan.Add("cod_iso", dt.Rows[0].ItemArray[5].ToString().Trim());
plan.Add("gls_sello1", dt.Rows[0].ItemArray[6].ToString().Trim());
plan.Add("gls_sello2", dt.Rows[0].ItemArray[7].ToString().Trim());
plan.Add("gls_sello3", dt.Rows[0].ItemArray[8].ToString().Trim());
plan.Add("rut_cliente", dt.Rows[0].ItemArray[9].ToString().Trim());
//plan.Add("fecha", dt.Rows[0].ItemArray[10].ToString().Substring(0, 8).Trim());
plan.Add("horaI", dt.Rows[0].ItemArray[11].ToString().Substring(0, 5).Trim());
plan.Add("horaT", dt.Rows[0].ItemArray[12].ToString().Substring(0, 5).Trim());
plan.Add("mano_trabajo", dt.Rows[0].ItemArray[13].ToString().Trim());
plan.Add("cod_nave", dt.Rows[0].ItemArray[14].ToString().Trim());
plan.Add("n_viaje", dt.Rows[0].ItemArray[15].ToString().Trim());
plan.Add("cod_terminal", dt.Rows[0].ItemArray[16].ToString().Trim());
plan.Add("n_estado", dt.Rows[0].ItemArray[17].ToString().Trim());
plan.Add("desbloqueo", dt.Rows[0].ItemArray[18].ToString().Trim());
plan.Add("rut_tarjador", dt.Rows[0].ItemArray[19].ToString().Trim());
return(plan);
}
protected void llenarGrilla()
{
string permiso = Session["permiso"].ToString();
string terminal = Session["terminal"].ToString();
StringBuilder strblVideo = new StringBuilder();
Literal lTabla = new Literal();
string tabla = string.Empty;
DataTable dt = new DataTable();
try
{
dt = new PlanificacionDescBLL().sp_sel_planDescBLL();
}
catch (Exception ex)
{
throw ex;
}
if (!permiso.Equals("Administrador"))
{
if (!permiso.Equals("Sup Contratista"))
{
strblVideo.Append("<thead>");
strblVideo.Append("<th></th>");
strblVideo.Append("<th></th>");
strblVideo.Append("<th>BL</th>");
strblVideo.Append("<th>CLIENTE</th>");
strblVideo.Append("<th>NAVE</th>");
strblVideo.Append("<th>CONTENEDOR</th>");
strblVideo.Append("<th>FECHA</th>");
strblVideo.Append("<th>TERMINAL</th>");
strblVideo.Append("<th>CLAVE</th>");
strblVideo.Append("<th>ESTADO</th>");
strblVideo.Append("<th></th>");
strblVideo.Append("</thead>");
strblVideo.Append("<tbody>");
foreach (DataRow row in dt.Rows)
{
if (terminal.Equals(row["terminal"].ToString()))
{
DateTime date = new DateTime();
date = Convert.ToDateTime(row["FECHA"]);
strblVideo.Append("<tr class=odd gradeX>");
strblVideo.Append("<td><button id=" + row["corr_planificacion"] + " runat=\"server\" onclick=\"eliminar(this.id); \" class=\"btn red\" >" +
"<i class=\"fa fa-trash-o\"></i></button>" + "</td>");
strblVideo.Append("<td><button id=" + row["corr_planificacion"] + " runat=\"server\" onclick=\"modificar(this.id);\" class=\"btn blue\" >" +
"<i class=\"fa fa-edit\"></i></button>" + "</td>");
strblVideo.Append("<td>" + row["gls_bl"] + "</td>");
strblVideo.Append("<td>" + row["CLIENTE"] + "</td>");
strblVideo.Append("<td>" + row["NAVE"] + "</td>");
strblVideo.Append("<td>" + row["CONTENEDOR"] + "</td>");
strblVideo.Append("<td>" + date.Day + "/" + date.Month + "/" + date.Year + "</td>");
strblVideo.Append("<td>" + row["terminal"] + "</td>");
strblVideo.Append("<td>" + row["desbloqueo"] + "</td>");
strblVideo.Append("<td>" + row["estado"] + "</td>");
if (row["estado"].ToString().Equals("Cerradas"))
{
strblVideo.Append("<td><button id=" + row["corr_planificacion"] + " runat=\"server\" onclick=\"exportar(this.id); \" class=\"btn blue\" >" +
"<i class=\"fa fa-cloud-download\"></i></button>" + "</td>");
}
else
{
strblVideo.Append("<td>En Proceso</td>");
}
strblVideo.Append("</tr>");
}
}
strblVideo.Append("</tbody>");
}
else
{
strblVideo.Append("<thead>");
strblVideo.Append("<th>BL</th>");
strblVideo.Append("<th>CLIENTE</th>");
strblVideo.Append("<th>NAVE</th>");
strblVideo.Append("<th>CONTENEDOR</th>");
strblVideo.Append("<th>FECHA</th>");
strblVideo.Append("<th>TERMINAL</th>");
strblVideo.Append("<th>CLAVE</th>");
strblVideo.Append("<th>ESTADO</th>");
strblVideo.Append("<th></th>");
strblVideo.Append("</thead>");
strblVideo.Append("<tbody>");
foreach (DataRow row in dt.Rows)
{
if (terminal.Equals(row["terminal"].ToString()))
{
DateTime date = new DateTime();
date = Convert.ToDateTime(row["FECHA"]);
strblVideo.Append("<tr class=odd gradeX>");
strblVideo.Append("<td>" + row["gls_bl"] + "</td>");
strblVideo.Append("<td>" + row["CLIENTE"] + "</td>");
strblVideo.Append("<td>" + row["NAVE"] + "</td>");
strblVideo.Append("<td>" + row["CONTENEDOR"] + "</td>");
strblVideo.Append("<td>" + date.Day + "/" + date.Month + "/" + date.Year + "</td>");
strblVideo.Append("<td>" + row["terminal"] + "</td>");
strblVideo.Append("<td>" + row["desbloqueo"] + "</td>");
strblVideo.Append("<td>" + row["estado"] + "</td>");
if (row["estado"].ToString().Equals("Cerradas"))
{
strblVideo.Append("<td><button id=" + row["corr_planificacion"] + " runat=\"server\" onclick=\"exportar(this.id); \" class=\"btn blue\" >" +
"<i class=\"fa fa-cloud-download\"></i></button>" + "</td>");
}
else
{
strblVideo.Append("<td>En Proceso</td>");
}
strblVideo.Append("</tr>");
}
}
strblVideo.Append("</tbody>");
}
}
else
{
strblVideo.Append("<thead>");
strblVideo.Append("<th></th>");
strblVideo.Append("<th></th>");
strblVideo.Append("<th>BL</th>");
strblVideo.Append("<th>CLIENTE</th>");
strblVideo.Append("<th>NAVE</th>");
strblVideo.Append("<th>CONTENEDOR</th>");
strblVideo.Append("<th>FECHA</th>");
strblVideo.Append("<th>TERMINAL</th>");
strblVideo.Append("<th>CLAVE</th>");
strblVideo.Append("<th>ESTADO</th>");
strblVideo.Append("<th></th>");
strblVideo.Append("</thead>");
strblVideo.Append("<tbody>");
foreach (DataRow row in dt.Rows)
{
DateTime date = new DateTime();
date = Convert.ToDateTime(row["FECHA"]);
strblVideo.Append("<tr class=odd gradeX>");
strblVideo.Append("<td><button id=" + row["corr_planificacion"] + " runat=\"server\" onclick=\"eliminar(this.id); \" class=\"btn red\" >" +
"<i class=\"fa fa-trash-o\"></i></button>" + "</td>");
strblVideo.Append("<td><button id=" + row["corr_planificacion"] + " runat=\"server\" onclick=\"modificar(this.id);\" class=\"btn blue\" >" +
"<i class=\"fa fa-edit\"></i></button>" + "</td>");
strblVideo.Append("<td>" + row["gls_bl"] + "</td>");
strblVideo.Append("<td>" + row["CLIENTE"] + "</td>");
strblVideo.Append("<td>" + row["NAVE"] + "</td>");
strblVideo.Append("<td>" + row["CONTENEDOR"] + "</td>");
strblVideo.Append("<td>" + date.Day + "/" + date.Month + "/" + date.Year + "</td>");
strblVideo.Append("<td>" + row["terminal"] + "</td>");
strblVideo.Append("<td>" + row["desbloqueo"] + "</td>");
strblVideo.Append("<td>" + row["estado"] + "</td>");
if (row["estado"].ToString().Equals("Cerradas"))
{
strblVideo.Append("<td><button id=" + row["corr_planificacion"] + " runat=\"server\" onclick=\"exportar(this.id); \" class=\"btn blue\" >" +
"<i class=\"fa fa-cloud-download\"></i></button>" + "</td>");
}
else
{
strblVideo.Append("<td>En Proceso</td>");
}
strblVideo.Append("</tr>");
}
strblVideo.Append("</tbody>");
}
tabla = strblVideo.ToString();
lTabla.Text = tabla;
pnlTablaVideos.Controls.Add(lTabla);
pnlTablaVideos.Visible = true;
UpdatePanel1.Update();
UpdatePanel1.Visible = true;
}
public void cargarLista()
{
if (Session["nombre"] == null)
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
//Poner datos
}
string permiso = Session["permiso"].ToString();
string terminal = Session["terminal"].ToString();
StringBuilder strblVideo = new StringBuilder();
Literal lTabla = new Literal();
string tabla = string.Empty;
DataTable dt = new PlanificacionDescBLL().sp_sel_planDescBLL();
if (!permiso.Equals("Sup Contratista"))
{
strblVideo.Append("<thead>");
strblVideo.Append("<th></th>");
strblVideo.Append("<th></th>");
strblVideo.Append("<th>BL</th>");
strblVideo.Append("<th>CLIENTE</th>");
strblVideo.Append("<th>NAVE</th>");
strblVideo.Append("<th>CONTENEDOR</th>");
strblVideo.Append("<th>FECHA</th>");
strblVideo.Append("<th>TERMINAL</th>");
strblVideo.Append("<th>CLAVE</th>");
strblVideo.Append("<th>ESTADO</th>");
strblVideo.Append("<th></th>");
strblVideo.Append("</thead>");
strblVideo.Append("<tbody>");
foreach (DataRow row in dt.Rows)
{
DateTime date = new DateTime();
date = Convert.ToDateTime(row["FECHA"]);
strblVideo.Append("<tr class=odd gradeX>");
strblVideo.Append("<td><button id=" + row["MANIFIESTO"] + " runat=\"server\" onclick=\"eliminar(this.id); \" class=\"btn red\" >" +
"<i class=\"fa fa-trash-o\"></i></button>" + "</td>");
strblVideo.Append("<td><button id=" + row["MANIFIESTO"] + " runat=\"server\" onclick=\"modificar(this.id);\" class=\"btn blue\" >" +
"<i class=\"fa fa-edit\"></i></button>" + "</td>");
strblVideo.Append("<td>" + row["BL"] + "</td>");
strblVideo.Append("<td>" + row["CLIENTE"] + "</td>");
strblVideo.Append("<td>" + row["NAVE"] + "</td>");
strblVideo.Append("<td>" + row["CONTENEDOR"] + "</td>");
strblVideo.Append("<td>" + date.Day + "/" + date.Month + "/" + date.Year + "</td>");
strblVideo.Append("<td>" + row["terminal"] + "</td>");
strblVideo.Append("<td>" + row["desbloqueo"] + "</td>");
strblVideo.Append("<td>" + row["estado"] + "</td>");
if (row["estado"].ToString().Equals("Cerradas"))
{
strblVideo.Append("<td><button id=" + row["MANIFIESTO"] + " runat=\"server\" onclick=\"exportar(this.id); \" class=\"btn blue\" >" +
"<i class=\"fa fa-cloud-download\"></i></button>" + "</td>");
}
else
{
strblVideo.Append("<td>En Proceso</td>");
}
strblVideo.Append("</tr>");
}
strblVideo.Append("</tbody>");
}
else
{
strblVideo.Append("<thead>");
strblVideo.Append("<th>BL</th>");
strblVideo.Append("<th>CLIENTE</th>");
strblVideo.Append("<th>NAVE</th>");
strblVideo.Append("<th>CONTENEDOR</th>");
strblVideo.Append("<th>FECHA</th>");
strblVideo.Append("<th>TERMINAL</th>");
strblVideo.Append("<th>CLAVE</th>");
strblVideo.Append("<th>ESTADO</th>");
strblVideo.Append("<th></th>");
strblVideo.Append("</thead>");
strblVideo.Append("<tbody>");
foreach (DataRow row in dt.Rows)
{
if (terminal.Equals(row["age_cod"].ToString()))
{
DateTime date = new DateTime();
date = Convert.ToDateTime(row["FECHA"]);
strblVideo.Append("<tr class=odd gradeX>");
strblVideo.Append("<td>" + row["BL"] + "</td>");
strblVideo.Append("<td>" + row["CLIENTE"] + "</td>");
strblVideo.Append("<td>" + row["NAVE"] + "</td>");
strblVideo.Append("<td>" + row["CONTENEDOR"] + "</td>");
strblVideo.Append("<td>" + date.Day + "/" + date.Month + "/" + date.Year + "</td>");
strblVideo.Append("<td>" + row["terminal"] + "</td>");
strblVideo.Append("<td>" + row["desbloqueo"] + "</td>");
strblVideo.Append("<td>" + row["estado"] + "</td>");
if (row["estado"].ToString().Equals("Cerradas"))
{
strblVideo.Append("<td><button id=" + row["MANIFIESTO"] + " runat=\"server\" onclick=\"exportar(this.id); \" class=\"btn blue\" >" +
"<i class=\"fa fa-cloud-download\"></i></button>" + "</td>");
}
else
{
strblVideo.Append("<td>En Proceso</td>");
}
strblVideo.Append("</tr>");
}
}
strblVideo.Append("</tbody>");
}
tabla = strblVideo.ToString();
lTabla.Text = tabla;
pnlTablaVideos.Controls.Add(lTabla);
pnlTablaVideos.Visible = true;
UpdatePanel1.Update();
UpdatePanel1.Visible = true;
}
