protected void btn_fconex_Click(object sender, EventArgs e)
{
int int_idespecializa = int.Parse(ddl_especializa.SelectedValue);
Guid str_localidad = Guid.Parse(ddl_localidad.SelectedValue);
using (db_transcriptEntities edm_conexion = new db_transcriptEntities())
{
var i_conexion = (from i_j in edm_conexion.v_salas
where i_j.id_juzgado == str_localidad
select new
{
i_j.codigo_juzgado,
i_j.desc_especializa,
i_j.localidad,
i_j.numero,
i_j.codigo_sala,
i_j.nombre,
i_j.ip,
i_j.usuario,
i_j.desc_ruta_ini,
i_j.ruta_user_ini
}).ToList();
if (i_conexion.Count == 0)
{
gv_credentials.Visible = false;
}
else
{
gv_credentials.DataSource = i_conexion;
gv_credentials.DataBind();
gv_credentials.Visible = true;
}
}
}
private void Inf_user()
{
try
{
using (db_transcriptEntities edm_usuario = new db_transcriptEntities())
{
var i_usuario = (from u in edm_usuario.inf_usuarios
where u.id_tipo_usuario == 1
select u).ToList();
if (i_usuario.Count == 0)
{
rfv_code_user.Enabled = false;
rfv_password.Enabled = false;
lkb_registro.Visible = true;
Mensaje("No existe administrador ni tribunal en la aplicación, favor de registrarlos.");
}
else
{
rfv_code_user.Enabled = true;
rfv_password.Enabled = true;
lkb_registro.Visible = false;
}
}
}
catch
{
Mensaje("Sin conexión a base de datos, contactar al administrador.");
}
}
protected void chkb_editar_CheckedChanged(object sender, EventArgs e)
{
if (chkb_editar.Checked)
{
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_usuarios
join tu in data_user.fact_tipo_usuarios on u.id_tipo_usuario equals tu.id_tipo_usuario
where u.id_usuario == guid_fidusuario
select new
{
u.codigo_usuario,
u.nombres,
u.a_paterno,
u.a_materno,
}).FirstOrDefault();
txt_name_user.Text = inf_user.nombres;
txt_apater.Text = inf_user.a_paterno;
txt_amater.Text = inf_user.a_materno;
txt_code_user.Text = inf_user.codigo_usuario;
}
}
else
{
clean_data();
}
}
protected void chkselect_dayvideos(object sender, EventArgs e)
{
foreach (GridViewRow row in gv_dayvideos.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chk_select") as CheckBox);
if (chkRow.Checked)
{
row.BackColor = Color.YellowGreen;
int str_code = Convert.ToInt32(row.Cells[1].Text);
using (db_transcriptEntities edm_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = (from u in edm_cadvideos.inf_caducidad_videos
where u.id_caducidad_videos == str_code
select new
{
u.id_caducidad_videos,
u.dias_caducidad,
u.fecha_registro
}).FirstOrDefault();
txt_days.Text = i_cadvideos.dias_caducidad.ToString();
}
}
else
{
row.BackColor = Color.White;
}
}
}
}
protected void rb_edit_transformation_CheckedChanged(object sender, EventArgs e)
{
div_inftransformation.Visible = true;
rb_add_transformation.Checked = false;
gv_transformationf.Visible = false;
clean_txt();
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var i_fecha_transf = (from u in edm_fecha_transf.inf_fecha_transformacion
select new
{
u.id_fecha_transformacion,
u.horario,
u.fecha_registro
}).ToList();
if (i_fecha_transf.Count == 0)
{
rb_edit_transformation.Checked = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Sin registro, favor de agregar uno";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
gv_transformation.DataSource = i_fecha_transf;
gv_transformation.DataBind();
gv_transformation.Visible = true;
}
}
}
private void inf_user()
{
guid_fidusuario = (Guid)(Session["ss_id_user"]);
using (db_transcriptEntities edm_usuario = new db_transcriptEntities())
{
var i_usuario = (from i_u in edm_usuario.inf_usuarios
join i_tu in edm_usuario.fact_tipo_usuarios on i_u.id_tipo_usuario equals i_tu.id_tipo_usuario
join i_e in edm_usuario.inf_tribunal on i_u.id_tribunal equals i_e.id_tribunal
where i_u.id_usuario == guid_fidusuario
select new
{
i_u.nombres,
i_u.a_paterno,
i_u.a_materno,
i_tu.desc_tipo_usuario,
i_tu.id_tipo_usuario,
i_e.nombre,
i_e.id_tribunal
}).FirstOrDefault();
lbl_fuser.Text = i_usuario.nombres + " " + i_usuario.a_paterno + " " + i_usuario.a_materno;
lbl_profileuser.Text = i_usuario.desc_tipo_usuario;
lbl_idprofileuser.Text = i_usuario.id_tipo_usuario.ToString();
lbl_centername.Text = i_usuario.nombre;
guid_fidcentro = i_usuario.id_tribunal;
}
}
protected void gv_usuarios_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gv_files.PageIndex = e.NewPageIndex;
DateTime str_fdateini = Convert.ToDateTime(txt_dateini.Text);
DateTime str_fdatefin = Convert.ToDateTime(txt_datefin.Text);
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from inf_lv in data_user.inf_material_dep
join inf_u in data_user.inf_usuarios on inf_lv.id_usuario equals inf_u.id_usuario
where inf_lv.fecha_registro_alt >= str_fdateini && inf_lv.fecha_registro_alt <= str_fdatefin
select new
{
inf_lv.id__material_dep,
inf_lv.sesion,
inf_lv.video,
inf_u.nombres,
inf_u.a_paterno,
inf_u.a_materno,
inf_lv.fecha_registro,
inf_lv.fecha_registro_alt,
}).ToList();
gv_files.DataSource = inf_user;
gv_files.DataBind();
gv_files.Visible = true;
}
}
private void flist_user(int?[] id_flist_user)
{
if (lbl_idprofileuser.Text == "2")
{
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_usuarios
join e in data_user.fact_estatus on u.id_estatus equals e.id_estatus
where id_flist_user.Contains(u.id_tipo_usuario)
where u.id_usuario != guid_fidusuario
where u.id_estatus == 1
select new
{
u.codigo_usuario,
e.desc_estatus,
u.fecha_registro,
u.nombres,
u.a_paterno,
u.a_materno
}).ToList();
gv_usuarios.DataSource = inf_user;
gv_usuarios.DataBind();
gv_usuarios.Visible = true;
}
}
else
{
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_usuarios
join e in data_user.fact_estatus on u.id_estatus equals e.id_estatus
where id_flist_user.Contains(u.id_tipo_usuario)
where u.id_usuario != guid_fidusuario
where u.id_estatus == 1
select new
{
u.codigo_usuario,
e.desc_estatus,
u.fecha_registro,
u.nombres,
u.a_paterno,
u.a_materno
}).ToList();
gv_usuarios.DataSource = inf_user;
gv_usuarios.DataBind();
gv_usuarios.Visible = true;
}
}
if (rb_edit.Checked)
{
}
}
private void inf_user()
{
guid_fidusuario = (Guid)(Session["ss_id_user"]);
using (db_transcriptEntities edm_usuario = new db_transcriptEntities())
{
var i_usuario = (from i_u in edm_usuario.inf_usuarios
join i_tu in edm_usuario.fact_tipo_usuarios on i_u.id_tipo_usuario equals i_tu.id_tipo_usuario
join i_e in edm_usuario.inf_tribunal on i_u.id_tribunal equals i_e.id_tribunal
where i_u.id_usuario == guid_fidusuario
select new
{
i_u.nombres,
i_u.a_paterno,
i_u.a_materno,
i_tu.desc_tipo_usuario,
i_tu.id_tipo_usuario,
i_e.nombre,
i_e.id_tribunal
}).FirstOrDefault();
lbl_fuser.Text = i_usuario.nombres + " " + i_usuario.a_paterno + " " + i_usuario.a_materno;
lbl_profileuser.Text = i_usuario.desc_tipo_usuario;
lbl_idprofileuser.Text = i_usuario.id_tipo_usuario.ToString();
lbl_centername.Text = i_usuario.nombre;
guid_fidcentro = i_usuario.id_tribunal;
}
using (db_transcriptEntities edm_conexion = new db_transcriptEntities())
{
var i_conexion = (from i_j in edm_conexion.v_salas
select new
{
i_j.codigo_juzgado,
i_j.desc_especializa,
i_j.localidad,
i_j.numero,
i_j.codigo_sala,
i_j.nombre,
i_j.ip,
i_j.usuario,
i_j.desc_ruta_ini,
i_j.ruta_user_ini
}).ToList();
if (i_conexion.Count == 0)
{
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Sin registros, favor de agregarlo en la pantalla de Control de Juzgados";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
}
private void inf_user()
{
guid_fidusuario = (Guid)(Session["ss_id_user"]);
//Session.Abandon();
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from i_u in data_user.inf_usuarios
join i_tu in data_user.fact_tipo_usuarios on i_u.id_tipo_usuario equals i_tu.id_tipo_usuario
join i_e in data_user.inf_tribunal on i_u.id_tribunal equals i_e.id_tribunal
where i_u.id_usuario == guid_fidusuario
select new
{
i_u.nombres,
i_u.a_paterno,
i_u.a_materno,
i_tu.desc_tipo_usuario,
i_tu.id_tipo_usuario,
i_e.nombre,
i_e.id_tribunal
}).FirstOrDefault();
lbl_fuser.Text = inf_user.nombres + " " + inf_user.a_paterno + " " + inf_user.a_materno;
lbl_profileuser.Text = inf_user.desc_tipo_usuario;
lbl_idprofileuser.Text = inf_user.id_tipo_usuario.ToString();
lbl_centername.Text = inf_user.nombre;
lbl_idcenter.Text = inf_user.id_tribunal.ToString();
int str_id_type_user = inf_user.id_tipo_usuario;
switch (str_id_type_user)
{
case 1:
break;
case 2:
break;
case 3:
break;
case 4:
//div_tracing.Visible = false;
div_control_centers.Visible = false;
div_resumen.Visible = false;
break;
}
}
}
private void inf_user()
{
guid_fidusuario = (Guid)(Session["ss_id_user"]);
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from i_u in data_user.inf_usuarios
join i_tu in data_user.fact_tipo_usuarios on i_u.id_tipo_usuario equals i_tu.id_tipo_usuario
join i_e in data_user.inf_tribunal on i_u.id_tribunal equals i_e.id_tribunal
where i_u.id_usuario == guid_fidusuario
select new
{
i_u.nombres,
i_u.a_paterno,
i_u.a_materno,
i_tu.desc_tipo_usuario,
i_tu.id_tipo_usuario,
i_e.nombre,
i_e.id_tribunal
}).FirstOrDefault();
lbl_name.Text = inf_user.nombres + " " + inf_user.a_paterno + " " + inf_user.a_materno;
lbl_profile_user.Text = inf_user.desc_tipo_usuario;
lbl_id_profile_user.Text = inf_user.id_tipo_usuario.ToString();
lbl_user_centerCP.Text = inf_user.nombre;
lbl_id_centerCP.Text = inf_user.id_tribunal.ToString();
int str_id_type_user = inf_user.id_tipo_usuario;
switch (str_id_type_user)
{
case 1:
break;
case 2:
break;
case 3:
div_administrador.Visible = false;
break;
case 4:
div_administrador.Visible = false;
div_superintendent.Visible = false;
div_operator.Visible = false;
break;
}
}
}
private void load_ddl()
{
using (db_transcriptEntities m_especializa = new db_transcriptEntities())
{
var i_especializa = (from c in m_especializa.fact_especializa
select c).ToList();
ddl_especializa.DataSource = i_especializa;
ddl_especializa.DataTextField = "desc_especializa";
ddl_especializa.DataValueField = "id_especializa";
ddl_especializa.DataBind();
}
ddl_especializa.Items.Insert(0, new ListItem("Seleccionar", "0"));
ddl_localidad.Items.Insert(0, new ListItem("Seleccionar", "0"));
}
private void datos_sepomex(string str_codigo)
{
using (db_transcriptEntities db_sepomex = new db_transcriptEntities())
{
var tbl_sepomex = (from c in db_sepomex.inf_sepomex
where c.d_codigo == str_codigo
select c).ToList();
ddl_colonia.DataSource = tbl_sepomex;
ddl_colonia.DataTextField = "d_asenta";
ddl_colonia.DataValueField = "id_asenta_cpcons";
ddl_colonia.DataBind();
if (tbl_sepomex.Count == 1)
{
txt_municipio.Text = tbl_sepomex[0].D_mnpio;
txt_estado.Text = tbl_sepomex[0].d_estado;
rfv_colonia.Enabled = true;
rfv_name_user.Enabled = true;
rfv_code_user.Enabled = true;
rfv_password.Enabled = true;
}
if (tbl_sepomex.Count > 1)
{
ddl_colonia.Items.Insert(0, new ListItem("*Colonia", "0"));
txt_municipio.Text = tbl_sepomex[0].D_mnpio;
txt_estado.Text = tbl_sepomex[0].d_estado;
rfv_colonia.Enabled = true;
rfv_name_user.Enabled = true;
rfv_code_user.Enabled = true;
rfv_password.Enabled = true;
}
else if (tbl_sepomex.Count == 0)
{
ddl_colonia.Items.Clear();
ddl_colonia.Items.Insert(0, new ListItem("*Colonia", "0"));
txt_municipio.Text = "";
txt_estado.Text = "";
rfv_colonia.Enabled = false;
rfv_name_user.Enabled = false;
rfv_code_user.Enabled = false;
rfv_password.Enabled = false;
}
}
}
private void inf_user()
{
guid_fidusuario = (Guid)(Session["ss_id_user"]);
using (db_transcriptEntities edm_usuario = new db_transcriptEntities())
{
var i_usuario = (from i_u in edm_usuario.inf_usuarios
join i_tu in edm_usuario.fact_tipo_usuarios on i_u.id_tipo_usuario equals i_tu.id_tipo_usuario
join i_e in edm_usuario.inf_tribunal on i_u.id_tribunal equals i_e.id_tribunal
where i_u.id_usuario == guid_fidusuario
select new
{
i_u.nombres,
i_u.a_paterno,
i_u.a_materno,
i_tu.desc_tipo_usuario,
i_tu.id_tipo_usuario,
i_e.nombre,
i_e.id_tribunal
}).FirstOrDefault();
lbl_fuser.Text = i_usuario.nombres + " " + i_usuario.a_paterno + " " + i_usuario.a_materno;
lbl_profileuser.Text = i_usuario.desc_tipo_usuario;
lbl_idprofileuser.Text = i_usuario.id_tipo_usuario.ToString();
lbl_centername.Text = i_usuario.nombre;
guid_fidcentro = i_usuario.id_tribunal;
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var i_fecha_transf = (from c in edm_fecha_transf.inf_caducidad_videos
select c).ToList();
if (i_fecha_transf.Count != 0)
{
rb_add_dayvideos.Visible = false;
}
else
{
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Sin registro, favor de agregar uno";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
}
protected void cmd_search_Click(object sender, EventArgs e)
{
if (rb_internos.Checked == false & rb_externos.Checked == false)
{
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Favor de seleccionar una opción";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
DateTime str_fdateini = Convert.ToDateTime(txt_dateini.Text);
DateTime str_fdatefin = Convert.ToDateTime(txt_datefin.Text);
if (rb_internos.Checked)
{
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from inf_lv in data_user.inf_material_dep
join inf_u in data_user.inf_usuarios on inf_lv.id_usuario equals inf_u.id_usuario
where inf_lv.fecha_registro_alt >= str_fdateini && inf_lv.fecha_registro_alt <= str_fdatefin
select new
{
inf_lv.id__material_dep,
inf_lv.sesion,
inf_lv.video,
inf_u.nombres,
inf_u.a_paterno,
inf_u.a_materno,
inf_lv.fecha_registro,
inf_lv.fecha_registro_alt,
}).ToList();
gv_files.DataSource = inf_user;
gv_files.DataBind();
gv_files.Visible = true;
}
}
else if (rb_externos.Checked)
{
gv_files.Visible = false;
}
}
}
protected void cmd_search_Click(object sender, EventArgs e)
{
string str_userb = txt_search.Text;
int? save_user = (int)(Session["ss_save_user"]);
var two_user = new int?[] { save_user };
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_usuarios
join est in data_user.fact_estatus on u.id_estatus equals est.id_estatus
where u.nombres.Contains(str_userb)
where two_user.Contains(u.id_tipo_usuario)
where u.id_usuario != guid_fidusuario
where u.id_estatus == 1
select new
{
u.codigo_usuario,
est.desc_estatus,
u.fecha_registro,
u.nombres,
u.a_paterno,
u.a_materno
}).ToList();
if (inf_user.Count == 0)
{
gv_usuarios.DataSource = inf_user;
gv_usuarios.DataBind();
gv_usuarios.Visible = true;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Usuario no exite o tiene un perfil diferente";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
gv_usuarios.DataSource = inf_user;
gv_usuarios.DataBind();
gv_usuarios.Visible = true;
}
}
}
protected void ddl_nomnum_SelectedIndexChanged(object sender, EventArgs e)
{
int int_idespecializa = int.Parse(ddl_especializa.SelectedValue);
string str_localidad = ddl_localidad.SelectedValue;
Guid guid_idjusgado;
using (db_transcriptEntities m_especializa = new db_transcriptEntities())
{
var i_especializa = (from c in m_especializa.inf_juzgados
join i_tu in m_especializa.inf_salas on c.id_juzgado equals i_tu.id_juzgado
where c.id_especializa == int_idespecializa
where c.localidad == str_localidad
select c).FirstOrDefault();
guid_idjusgado = i_especializa.id_juzgado;
}
}
protected void ddl_especializa_SelectedIndexChanged(object sender, EventArgs e)
{
int int_idespecializa = int.Parse(ddl_especializa.SelectedValue);
ddl_localidad.Items.Clear();
using (db_transcriptEntities m_especializa = new db_transcriptEntities())
{
var i_especializa = (from c in m_especializa.inf_juzgados
where c.id_especializa == int_idespecializa
select c).Distinct().ToList();
ddl_localidad.DataSource = i_especializa;
ddl_localidad.DataTextField = "localidad";
ddl_localidad.DataValueField = "id_juzgado";
ddl_localidad.DataBind();
}
ddl_localidad.Items.Insert(0, new ListItem("Seleccionar", "0"));
}
protected void chkselect_transformation(object sender, EventArgs e)
{
foreach (GridViewRow row in gv_transformation.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chk_select") as CheckBox);
if (chkRow.Checked)
{
row.BackColor = Color.YellowGreen;
int str_code = Convert.ToInt32(row.Cells[1].Text);
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var i_fecha_transf = (from u in edm_fecha_transf.inf_fecha_transformacion
where u.id_fecha_transformacion == str_code
select new
{
u.id_fecha_transformacion,
u.horario,
u.fecha_registro
}).FirstOrDefault();
CultureInfo ci = CultureInfo.InvariantCulture;
DateTime str_date = Convert.ToDateTime(i_fecha_transf.horario);
//txt_date.Attributes["value"] = str_date.ToShortDateString();
txt_date.Text = str_date.ToString("yyyy/MM/dd");
//txt_date = str_date.ToString("yyyy/MM/dd");
txt_hora.Text = str_date.ToString("hh:mm.F", ci);
string str_tt = i_fecha_transf.horario.Value.ToString("tt");
//ddl_fhora.SelectedValue = str_tt.ToLower();
}
}
else
{
row.BackColor = Color.White;
chkRow.Checked = false;
}
}
}
}
private void load_ddl()
{
ddl_colonia.Items.Clear();
ddl_colonia.Items.Insert(0, new ListItem("Seleccionar", "0"));
chkb_editar.Checked = true;
if (chkb_editar.Checked)
{
using (db_transcriptEntities m_tribunal = new db_transcriptEntities())
{
var i_tribunal = (from u in m_tribunal.inf_tribunal
where u.id_tribunal == guid_fidcentro
select u).FirstOrDefault();
txt_tribunal.Text = i_tribunal.nombre;
txt_telefono.Text = i_tribunal.telefono;
txt_email.Text = i_tribunal.email;
txt_callenum.Text = i_tribunal.callenum;
using (db_transcriptEntities db_sepomex = new db_transcriptEntities())
{
var tbl_sepomex = (from c in db_sepomex.inf_sepomex
where c.id_codigo == i_tribunal.id_codigo
select c).ToList();
ddl_colonia.DataSource = tbl_sepomex;
ddl_colonia.DataTextField = "d_asenta";
ddl_colonia.DataValueField = "id_asenta_cpcons";
ddl_colonia.DataBind();
txt_cp.Text = tbl_sepomex[0].d_codigo;
ddl_colonia.SelectedValue = tbl_sepomex[0].id_asenta_cpcons.ToString();
txt_municipio.Text = tbl_sepomex[0].D_mnpio;
txt_estado.Text = tbl_sepomex[0].d_estado;
}
}
}
else
{
limpiar_textbox();
}
}
private void flist_user(int?[] str_idload)
{
string str_dateini = txt_dateini.Text;
string str_datefin = txt_datefin.Text;
string sessionf = txt_expedient.Text;
DateTime str_fdateini = DateTime.Parse(str_dateini);
DateTime str_fdatefin = DateTime.Parse(str_datefin);
using (db_transcriptEntities edm_material = new db_transcriptEntities())
{
var i_material = (from inf_m in edm_material.inf_material
join inf_em in edm_material.fact_estatus_material on inf_m.id_estatus_material equals inf_em.id_estatus_material
join inf_rv in edm_material.inf_ruta_videos on inf_m.id_ruta_videos equals inf_rv.id_ruta_videos
join inf_s in edm_material.inf_salas on inf_rv.id_sala equals inf_s.id_sala
join inf_j in edm_material.inf_juzgados on inf_s.id_juzgado equals inf_j.id_juzgado
where str_idload.Contains(inf_m.id_estatus_material)
where inf_m.fecha_registro >= str_fdateini && inf_m.fecha_registro <= str_fdatefin
where inf_m.sesion == sessionf
select new
{
inf_j.localidad,
inf_j.numero,
inf_m.sesion,
inf_m.titulo,
inf_m.localizacion,
inf_m.tipo,
inf_m.archivo,
inf_m.duracion,
inf_m.fecha_registro,
inf_em.desc_estatus_material,
inf_m.id_material
}).ToList();
gv_files.DataSource = i_material;
gv_files.DataBind();
gv_files.Visible = true;
}
}
protected void chkb_editar_CheckedChanged(object sender, EventArgs e)
{
if (chkb_editar.Checked)
{
using (db_transcriptEntities m_tribunal = new db_transcriptEntities())
{
var i_tribunal = (from u in m_tribunal.inf_tribunal
where u.id_tribunal == guid_fidcentro
select u).FirstOrDefault();
txt_tribunal.Text = i_tribunal.nombre;
txt_telefono.Text = i_tribunal.telefono;
txt_email.Text = i_tribunal.email;
txt_callenum.Text = i_tribunal.callenum;
using (db_transcriptEntities db_sepomex = new db_transcriptEntities())
{
var tbl_sepomex = (from c in db_sepomex.inf_sepomex
where c.id_codigo == i_tribunal.id_codigo
select c).ToList();
ddl_colonia.DataSource = tbl_sepomex;
ddl_colonia.DataTextField = "d_asenta";
ddl_colonia.DataValueField = "id_asenta_cpcons";
ddl_colonia.DataBind();
txt_cp.Text = tbl_sepomex[0].d_codigo;
ddl_colonia.SelectedValue = tbl_sepomex[0].id_asenta_cpcons.ToString();
txt_municipio.Text = tbl_sepomex[0].D_mnpio;
txt_estado.Text = tbl_sepomex[0].d_estado;
}
}
}
else
{
limpiar_textbox();
}
}
protected void rb_edit_dayvideos_CheckedChanged(object sender, EventArgs e)
{
rb_add_dayvideos.Checked = false;
div_infdayvideos.Visible = true;
rb_add_dayvideos.Checked = false;
gv_dayvideosf.Visible = false;
txt_days.Text = "";
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_caducidad_videos
select new
{
u.id_caducidad_videos,
u.dias_caducidad,
u.fecha_registro
}).ToList();
if (inf_user.Count == 0)
{
rb_edit_dayvideos.Checked = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Sin registro, favor de agregar uno";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
gv_dayvideos.DataSource = inf_user;
gv_dayvideos.DataBind();
gv_dayvideos.Visible = true;
}
}
}
protected void cmd_login_Click(object sender, EventArgs e)
{
string str_codeuser = txt_code_user.Text;
string str_password = encrypta.Encrypt(txt_password.Text);
string str_password_V;
int? str_id_type_user, str_iduser_status;
try
{
using (db_transcriptEntities edm_usuario = new db_transcriptEntities())
{
var i_usuario = (from c in edm_usuario.inf_usuarios
where c.codigo_usuario == str_codeuser
select c).FirstOrDefault();
str_id_user = i_usuario.id_usuario;
str_password_V = i_usuario.clave;
str_id_type_user = i_usuario.id_tipo_usuario;
str_iduser_status = i_usuario.id_estatus;
if (str_password_V == str_password && str_iduser_status == 1)
{
Session["ss_id_user"] = str_id_user;
Response.Redirect("menu.aspx");
}
else
{
Mensaje("Contraseña incorrecta, favor de contactar al Administrador.");
}
}
}
catch
{
Mensaje("Usuario incorrecto, favor de contactar al Administrador.");
}
}
protected void cmd_search_Click(object sender, EventArgs e)
{
//play_video.Visible = false;
//div_panel.Visible = false;
//UpdatePanel2.Update();
using (var edm_materialf = new db_transcriptEntities())
{
var i_materialf = (from c in edm_materialf.inf_material
select c).ToList();
if (i_materialf.Count == 0)
{
gv_files.Visible = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Sin videos por Cargar, favor de reintentar o contactar con el administrador";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
iframe_pdf.Visible = false;
play_video.Visible = false;
upModal.Update();
}
else
{
using (var edm_material = new db_transcriptEntities())
{
var i_material = (from c in edm_material.inf_material
select c).ToList();
if (i_material.Count == 0)
{
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Sin videos por Cargar";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
}
else
{
using (var edm_materialff = new db_transcriptEntities())
{
var i_materialff = (from c in edm_materialff.inf_material
where c.id_estatus_material == 6
select c).ToList();
if (i_materialff.Count == 0)
{
var two_userff = new int?[] { 1, 3, 4, 5, 8, 9 };
flist_user(two_userff);
iframe_pdf.Visible = false;
play_video.Visible = false;
upModal.Update();
}
else
{
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Se estan CARGANDO videos, favor de esperar";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
var two_userff = new int?[] { 1, 3, 4, 5, 8, 9 };
flist_user(two_userff);
iframe_pdf.Visible = false;
play_video.Visible = false;
upModal.Update();
}
}
}
}
}
}
}
protected void Unnamed_Click(object sender, EventArgs e)
{
//play_video.Visible = false;
//div_panel.Visible = false;
//UpdatePanel2.Update();
GridViewRow row = (sender as LinkButton).NamingContainer as GridViewRow;
var two_user = new int?[] { 1, 3, 4, 5, 8, 9 };
string status = row.Cells[5].Text.ToString().Trim();
int id_m_ext = int.Parse(row.Cells[0].Text);
int id_m;
switch (status)
{
case "XML":
break;
case "ACTIVO":
string str_session_p;
str_session = row.Cells[1].Text;
str_video = row.Cells[2].Text + ".mp4";
//using (var data_mat = new db_transcriptEntities())
//{
// var items_mat = (from c in data_mat.inf_material
// where c.sesion == str_session
// select c).FirstOrDefault();
// str_session_p
//}
using (var edm_material = new db_transcriptEntities())
{
var i_material = new inf_material_dep
{
sesion = str_session,
video = str_video,
id_usuario = guid_fidusuario,
id_material = 0,
fecha_registro = DateTime.Now,
fecha_registro_alt = DateTime.Now
};
edm_material.inf_material_dep.Add(i_material);
edm_material.SaveChanges();
}
using (var data_mat = new db_transcriptEntities())
{
var items_mat = (from c in data_mat.inf_material_ext
where c.id_material_ext == id_m_ext
select c).FirstOrDefault();
id_m = items_mat.id_material;
}
using (var data_mat = new db_transcriptEntities())
{
var items_mat = (from c in data_mat.inf_material
where c.id_material == id_m
select c).FirstOrDefault();
string sessionf = items_mat.sesion;
string d_pdf = "videos\\" + sessionf + "\\" + str_session + "\\" + str_session + "\\ExtraFiles\\" + str_session + "_Report.pdf";
iframe_pdf.Visible = true;
iframe_pdf.Attributes["src"] = d_pdf;
string str_namefile = @"videos\\" + sessionf + "\\" + str_session + "\\" + str_session + "\\" + str_video;
play_video.Attributes["src"] = str_namefile;
}
s_gn = 1;
break;
case "ERROR":
using (var data_mat = new db_transcriptEntities())
{
var items_mat = (from c in data_mat.inf_material
where c.sesion == str_session
select c).FirstOrDefault();
items_mat.id_estatus_material = 3;
data_mat.SaveChanges();
}
break;
case "NUEVO":
using (var data_mat = new db_transcriptEntities())
{
var items_mat = (from c in data_mat.inf_material
where c.sesion == str_session
select c).FirstOrDefault();
items_mat.id_estatus_material = 3;
data_mat.SaveChanges();
}
flist_user(two_user);
break;
}
//play_video.Visible = true;
//div_panel.Visible = true;
//UpdatePanel2.Update();
//Response.Redirect(Request.Url.AbsoluteUri);
}
protected void gv_material_ext_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
GridViewRow gvr = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
string status = gvr.Cells[5].Text.ToString().Trim();
int id_sessionf = int.Parse(gvr.Cells[0].Text);
int id_session;
string str_sessionf;
using (var data_mat = new db_transcriptEntities())
{
var items_mat = (from c in data_mat.inf_material_ext
where c.id_material_ext == id_sessionf
select c).FirstOrDefault();
id_session = items_mat.id_material;
}
using (var data_mat = new db_transcriptEntities())
{
var items_mat = (from c in data_mat.inf_material
where c.id_material == id_session
select c).FirstOrDefault();
str_sessionf = items_mat.sesion;
}
str_session = gvr.Cells[1].Text;
str_video = gvr.Cells[2].Text + ".mp4";
var two_user = new int?[] { 1, 3, 4, 5, 8, 9 };
switch (status)
{
case "ACTIVO":
using (var edm_material = new db_transcriptEntities())
{
var i_material = new inf_material_dep
{
sesion = str_session,
video = str_video,
id_usuario = guid_fidusuario,
id_material = 0,
fecha_registro = DateTime.Now,
fecha_registro_alt = DateTime.Now
};
edm_material.inf_material_dep.Add(i_material);
edm_material.SaveChanges();
}
string d_pdf = "videos\\" + str_sessionf + "\\" + str_session + "\\" + str_session + "\\ExtraFiles\\" + str_session + "_Report.pdf";
iframe_pdf.Visible = true;
iframe_pdf.Attributes["src"] = d_pdf;
string str_namefile = @"videos\\" + str_sessionf + "\\" + str_session + "\\" + str_session + "\\" + str_video;
play_video.Visible = true;
play_video.Attributes["src"] = str_namefile;
Button btn = e.CommandSource as Button;
string name_btn = btn.Text;
if (name_btn == "PDF")
{
lblModalTitle.Text = "transcript";
Label1.Text = "Expediente:" + str_sessionf + " - Sesión:" + str_session + " - Archivo:" + str_video.Replace(".mp4", "");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal_pdf", "$('#myModal_pdf').modal();", true);
up_pdf.Update();
}
else
{
lblModalTitle.Text = "transcript";
Label2.Text = "Expediente:" + str_sessionf + " - Sesión:" + str_session + " - Archivo:" + str_video.Replace(".mp4", "");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal_video", "$('#myModal_video').modal();", true);
up_video.Update();
}
break;
case "ERROR":
using (var data_mat = new db_transcriptEntities())
{
var items_mat = (from c in data_mat.inf_material
where c.sesion == str_session
select c).FirstOrDefault();
items_mat.id_estatus_material = 3;
data_mat.SaveChanges();
}
flist_user(two_user);
break;
case "NUEVO":
using (var data_mat = new db_transcriptEntities())
{
var items_mat = (from c in data_mat.inf_material
where c.sesion == str_session
select c).FirstOrDefault();
items_mat.id_estatus_material = 3;
data_mat.SaveChanges();
}
flist_user(two_user);
break;
}
}
catch
{ }
}
protected void gv_files_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int customerId = int.Parse(gv_files.DataKeys[e.Row.RowIndex].Value.ToString());
var gv_material_ext = (GridView)e.Row.FindControl("gv_material_ext");
using (db_transcriptEntities edm_material = new db_transcriptEntities())
{
var i_material = (from inf_m in edm_material.inf_material_ext
join inf_em in edm_material.fact_estatus_material on inf_m.id_estatus_material equals inf_em.id_estatus_material
join inf_rv in edm_material.inf_ruta_videos on inf_m.id_ruta_videos equals inf_rv.id_ruta_videos
join inf_s in edm_material.inf_salas on inf_rv.id_sala equals inf_s.id_sala
join inf_j in edm_material.inf_juzgados on inf_s.id_juzgado equals inf_j.id_juzgado
where inf_m.id_material == customerId
select new
{
inf_m.sesion,
inf_m.archivo,
inf_m.duracion,
inf_m.fecha_registro,
inf_em.desc_estatus_material,
inf_m.id_material,
inf_m.id_material_ext
}).ToList();
gv_material_ext.DataSource = i_material;
gv_material_ext.DataBind();
gv_material_ext.Visible = true;
//if (gv_material_ext.Rows.Count == 0)
//{
//}
//else
//{
// Button btnButton_ext = (Button)gv_material_ext.FindControl("cmd_action_ext");
// string _EstatusExt = gv_material_ext.Rows[1].Cells[4].Text;
// if (_EstatusExt == "ERROR")
// {
// //btnButton_ext.Text = "CARGAR";
// //btnButton_ext.Enabled = true;
// }
// else if (_EstatusExt == "ACTIVO")
// {
// //btnButton_ext.Text = "VER";
// //btnButton_ext.Enabled = true;
// }
// else if (_EstatusExt == "CARGANDO")
// {
// //btnButton_ext.Text = "ESPERAR";
// //btnButton_ext.Enabled = false;
// }
// else if (_EstatusExt == "CARGAR")
// {
// //btnButton_ext.Text = "VALIDANDO";
// //btnButton_ext.Enabled = false;
// }
// else if (_EstatusExt == "INACTIVO")
// {
// //btnButton_ext.Text = "";
// //btnButton_ext.Enabled = false;
// }
//}
}
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
Button btnButton = (Button)e.Row.FindControl("btn_pdf");
Button btnButton_v = (Button)e.Row.FindControl("btn_video");
if (e.Row.Cells[11].Text == "ERROR")
{
btnButton.Text = "CARGAR";
btnButton.Enabled = true;
}
else if (e.Row.Cells[11].Text == "ACTIVO")
{
btnButton.Text = "PDF";
btnButton.Enabled = true;
btnButton_v.Text = "VER";
btnButton_v.Enabled = true;
}
else if (e.Row.Cells[11].Text == "CARGANDO")
{
btnButton.Text = "ESPERAR";
btnButton.Enabled = false;
}
else if (e.Row.Cells[11].Text == "CARGAR")
{
btnButton.Text = "VALIDANDO";
btnButton.Enabled = false;
}
else if (e.Row.Cells[11].Text == "INACTIVO")
{
btnButton.Text = "";
btnButton.Enabled = false;
}
else if (e.Row.Cells[11].Text == "NUEVO")
{
btnButton.Text = "CARGAR";
btnButton.Enabled = true;
}
}
}
private void flist_user(int?[] str_idload)
{
CultureInfo en = new CultureInfo("en-US");
Thread.CurrentThread.CurrentCulture = en;
string str_dateini = txt_dateini.Text;
string str_datefin = txt_datefin.Text;
DateTime str_fdateini = DateTime.Parse(str_dateini);
DateTime str_fdatefin = DateTime.Parse(str_datefin);
if (lbl_idprofileuser.Text == "4")
{
using (db_transcriptEntities edm_material = new db_transcriptEntities())
{
var i_material = (from inf_m in edm_material.inf_material
join inf_em in edm_material.fact_estatus_material on inf_m.id_estatus_material equals inf_em.id_estatus_material
where str_idload.Contains(inf_m.id_estatus_material)
where inf_m.fecha_registro >= str_fdateini && inf_m.fecha_registro <= str_fdatefin
select new
{
inf_m.sesion,
inf_m.titulo,
inf_m.localizacion,
inf_m.tipo,
inf_m.archivo,
inf_m.duracion,
inf_m.fecha_registro,
inf_em.desc_estatus_material,
inf_m.id_material
}).ToList();
gv_files.DataSource = i_material;
gv_files.DataBind();
gv_files.Visible = true;
}
}
else
{
using (db_transcriptEntities edm_material = new db_transcriptEntities())
{
var i_material = (from inf_m in edm_material.inf_material
join inf_em in edm_material.fact_estatus_material on inf_m.id_estatus_material equals inf_em.id_estatus_material
join inf_rv in edm_material.inf_ruta_videos on inf_m.id_ruta_videos equals inf_rv.id_ruta_videos
join inf_s in edm_material.inf_salas on inf_rv.id_sala equals inf_s.id_sala
join inf_j in edm_material.inf_juzgados on inf_s.id_juzgado equals inf_j.id_juzgado
where str_idload.Contains(inf_m.id_estatus_material)
where inf_m.fecha_registro >= str_fdateini && inf_m.fecha_registro <= str_fdatefin
select new
{
inf_j.localidad,
inf_j.numero,
inf_m.sesion,
inf_m.titulo,
inf_m.localizacion,
inf_m.tipo,
inf_m.archivo,
inf_m.duracion,
inf_m.fecha_registro,
inf_em.desc_estatus_material,
inf_m.id_material
}).ToList();
gv_files.DataSource = i_material;
gv_files.DataBind();
gv_files.Visible = true;
}
}
}
protected void cmd_save_days_Click(object sender, EventArgs e)
{
int str_ndias = Convert.ToInt32(txt_days.Text);
int str_count;
using (db_transcriptEntities edm_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = (from c in edm_cadvideos.inf_caducidad_videos
select c).Count();
str_count = i_cadvideos;
}
if (str_count == 0)
{
using (var edm_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = new inf_caducidad_videos
{
dias_caducidad = str_ndias,
id_usuario = guid_fidusuario,
id_tribunal = guid_fidcentro,
fecha_registro = DateTime.Now
};
edm_cadvideos.inf_caducidad_videos.Add(i_cadvideos);
edm_cadvideos.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_caducidad_videos
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_caducidad_videos_dep
{
id_usuario = guid_fidusuario,
id_caducidad_videos = ii_fecha_transf[0].id_caducidad_videos,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_user.inf_caducidad_videos_dep.Add(items_user);
insert_user.SaveChanges();
}
}
}
txt_days.Text = "";
using (db_transcriptEntities edm_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = (from u in edm_cadvideos.inf_caducidad_videos
where u.dias_caducidad == str_ndias
select new
{
u.id_caducidad_videos,
u.dias_caducidad,
u.fecha_registro
}).ToList();
gv_dayvideosf.DataSource = i_cadvideos;
gv_dayvideosf.DataBind();
gv_dayvideosf.Visible = true;
}
rb_add_dayvideos.Visible = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Dias de respaldo, agregado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
foreach (GridViewRow row in gv_dayvideos.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chk_select") as CheckBox);
if (chkRow.Checked)
{
int str_code = Convert.ToInt32(row.Cells[1].Text);
using (var edm_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = (from c in edm_cadvideos.inf_caducidad_videos
where c.id_caducidad_videos == str_code
select c).FirstOrDefault();
i_cadvideos.dias_caducidad = str_ndias;
edm_cadvideos.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_caducidad_videos
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_caducidad_videos_dep
{
id_usuario = guid_fidusuario,
id_caducidad_videos = ii_fecha_transf[0].id_caducidad_videos,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_user.inf_caducidad_videos_dep.Add(items_user);
insert_user.SaveChanges();
}
}
}
txt_days.Text = "";;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Dias de respaldo, actualizado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
using (db_transcriptEntities edm_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = (from u in edm_cadvideos.inf_caducidad_videos
where u.id_caducidad_videos == str_code
select new
{
u.id_caducidad_videos,
u.dias_caducidad,
u.fecha_registro
}).ToList();
gv_dayvideos.DataSource = i_cadvideos;
gv_dayvideos.DataBind();
gv_dayvideos.Visible = true;
}
}
}
}
}
}
