protected void cmd_save_Click(object sender, EventArgs e)
{
string str_nameuser = txt_name_user.Text.ToUpper();
string str_apater = txt_apater.Text.ToUpper();
string str_amater = txt_amater.Text.ToUpper();
string str_codeuser = txt_code_user.Text.ToLower();
string str_password = mdl_encrypta.Encrypt(txt_password.Text.ToLower());
using (var data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_usuarios
where c.id_usuario == id_fuser
select c).FirstOrDefault();
items_user.codigo_usuario = str_codeuser;
items_user.nombres = str_nameuser;
items_user.a_paterno = str_apater;
items_user.a_materno = str_amater;
items_user.clave = str_password;
data_user.SaveChanges();
}
clean_data();
chkb_editar.Checked = false;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Datos de usuario actualizados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
protected void cmd_login_Click(object sender, EventArgs e)
{
string str_codeuser = txt_code_user.Text;
string str_password = mdl_encrypta.Encrypt(txt_password.Text);
string str_password_V;
int? str_id_type_user, str_iduser_status;
try
{
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_usuarios
where c.codigo_usuario == str_codeuser
select c).FirstOrDefault();
str_id_user = items_user.id_usuario;
str_password_V = items_user.clave;
str_id_type_user = items_user.id_tipo_usuario;
str_iduser_status = items_user.id_estatus;
if (str_password_V == str_password && str_iduser_status == 1)
{
using (var insert_user = new db_transcriptEntities())
{
var user_session = new inf_sesion
{
fecha_registro = DateTime.Now,
id_estatus_sesion = 1,
id_aspx = 1,
id_usuario = str_id_user
};
insert_user.inf_sesion.Add(user_session);
insert_user.SaveChanges();
}
Session["ss_id_user"] = mdl_user.code_user(str_codeuser);
Response.Redirect("ctrl_menu.aspx");
}
else
{
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Contraseña incorrecta, favor de contactar al Administrador.";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
}
catch
{
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Usuario incorrecto, favor de contactar al Administrador.";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
private static void DoWork(object sender, DoWorkEventArgs e)
{
// Long running background operation
using (var edm_material = new db_transcriptEntities())
{
var i_material = (from c in edm_material.inf_material
where c.id_estatus_material == 6
select c).ToList();
foreach (var item in i_material)
{
string str_path_ini, str_path_fin;
using (db_transcriptEntities data_path = new db_transcriptEntities())
{
var count_path = (from c in data_path.inf_ruta_videos
select c).FirstOrDefault();
str_path_fin = count_path.desc_ruta_fin;
str_path_ini = count_path.desc_ruta_fin + "\\" + str_video;
}
str_path_ini = str_path_fin + "\\" + item.archivo.ToString().Replace(".mp4", ".wmv");
string str_file_save = str_path_ini.ToString();
string str_save_file = str_path_ini.ToString().Replace(".wmv", ".mp4");
var ffMpeg = new NReco.VideoConverter.FFMpegConverter();
var ffProbe = new NReco.VideoInfo.FFProbe();
var videoInfo = ffProbe.GetMediaInfo(str_file_save);
string str_duration_wmv = videoInfo.Duration.Hours + ":" + videoInfo.Duration.Minutes + ":" + videoInfo.Duration.Seconds;
try
{
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 = 6;
data_mat.SaveChanges();
}
var two_user = new int?[] { 6 };
ffMpeg.ConvertMedia(str_file_save, str_save_file, Format.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();
items_mat.id_estatus_material = 1;
data_mat.SaveChanges();
}
two_user = new int?[] { 1 };
}
catch
{
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 = 5;
data_mat.SaveChanges();
}
}
var videoInfo_mp4 = ffProbe.GetMediaInfo(str_file_save);
string str_duration_mp4 = videoInfo_mp4.Duration.Hours + ":" + videoInfo_mp4.Duration.Minutes + ":" + videoInfo_mp4.Duration.Seconds;
if (str_duration_wmv == str_duration_mp4)
{
File.Delete(str_file_save);
}
else
{
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 = 5;
data_mat.SaveChanges();
}
}
}
}
}
protected void gv_files_RowCommand(object sender, GridViewCommandEventArgs e)
{
foreach (GridViewRow row in gv_files.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[3].FindControl("chk_select") as CheckBox);
if (chkRow.Checked)
{
if (row.RowType == DataControlRowType.DataRow)
{
Button btnButton = (Button)row.FindControl("cmd_action");
if (row.Cells[10].Text == "ERROR")
{
str_session = row.Cells[3].Text;
str_video = row.Cells[7].Text;
using (var edm_material = new db_transcriptEntities())
{
var i_material = (from c in edm_material.inf_material
where c.sesion == str_session
select c).FirstOrDefault();
i_material.id_estatus_material = 6;
edm_material.SaveChanges();
}
var two_user = new int?[] { 1, 4, 5, 6 };
flist_user(two_user);
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Comienza proceso de Conversión, favor de esperar.";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else if (row.Cells[10].Text == "ACTIVO")
{
str_session = row.Cells[3].Text;
str_video = row.Cells[7].Text;
div_panel.Visible = true;
UpdatePanel2.Update();
using (var edm_material = new db_transcriptEntities())
{
var i_material = new inf_log_videos
{
sesion = str_session,
video = str_video,
id_usuario = guid_fidusuario,
id_tribunal = guid_fidcentro,
fecha_registro = DateTime.Now,
fecha_registro_alt = DateTime.Now
};
edm_material.inf_log_videos.Add(i_material);
edm_material.SaveChanges();
}
str_session = row.Cells[3].Text;
str_video = row.Cells[7].Text;
string d_pdf = "videos\\" + str_session + "\\ExtraFiles\\" + str_session + "_Report.pdf";
iframe_pdf.Visible = true;
iframe_pdf.Attributes["src"] = d_pdf;
string str_namefile = @"videos\" + row.Cells[7].Text;
play_video.Visible = true;
play_video.Attributes["src"] = str_namefile;
}
}
}
}
}
}
protected void cmd_save_days_Click(object sender, EventArgs e)
{
int str_ndias = Convert.ToInt32(txt_days.Text);
Guid id_fcenter = Guid.Parse(lbl_idcenter.Text);
int str_count;
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_caducidad_videos
select c).Count();
str_count = items_user;
}
if (str_count == 0)
{
using (var insert_fiscal = new db_transcriptEntities())
{
var items_fiscal = new inf_caducidad_videos
{
dias_caducidad = str_ndias,
id_usuario = id_fuser,
id_centro = id_fcenter,
fecha_registro = DateTime.Now
};
insert_fiscal.inf_caducidad_videos.Add(items_fiscal);
insert_fiscal.SaveChanges();
}
txt_days.Text = "";
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.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 = inf_user;
gv_dayvideosf.DataBind();
gv_dayvideosf.Visible = true;
}
rb_add_dayvideos.Visible = false;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Caducidad de videos, 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 data_address = new db_transcriptEntities())
{
var items_address = (from c in data_address.inf_caducidad_videos
where c.id_caducidad_videos == str_code
select c).FirstOrDefault();
items_address.dias_caducidad = str_ndias;
data_address.SaveChanges();
}
txt_days.Text = "";;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Caducidad de videos, actualizado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.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 = inf_user;
gv_dayvideos.DataBind();
gv_dayvideos.Visible = true;
}
}
}
}
}
}
private void guarda_registro()
{
Guid guid_fempresa = Guid.NewGuid();
Guid id_fempresa = Guid.Parse("9A3C8442-2B53-45B7-9B5C-144BFA9C93BE");
string str_empresa = txt_tribunal.Text.ToUpper();
string str_telefono = txt_telefono.Text;
string str_email = txt_email.Text;
string str_callenum = txt_callenum.Text.ToUpper();
string str_cp = txt_cp.Text;
int int_colony = Convert.ToInt32(ddl_colonia.SelectedValue);
Guid guid_nusuario = Guid.NewGuid();
string str_nombres = txt_nombres.Text.ToUpper();
string str_apaterno = txt_apaterno.Text.ToUpper();
string str_amaterno = txt_amaterno.Text.ToUpper();
string str_usuairo = txt_usuario.Text.ToLower();
string str_password = mdl_encrypta.Encrypt(txt_clave.Text);
using (var m_empresa = new db_transcriptEntities())
{
var i_empresa = new inf_tribunal
{
id_tribunal = guid_fempresa,
id_estatus = 1,
nombre = str_empresa,
telefono = str_telefono,
email = str_email,
calle_num = str_callenum,
cp = str_cp,
id_asenta_cpcons = int_colony,
fecha_registro = DateTime.Now,
id_empresa = id_fempresa
};
m_empresa.inf_tribunal.Add(i_empresa);
m_empresa.SaveChanges();
}
using (var m_usuario = new db_transcriptEntities())
{
var i_usuario = new inf_usuarios
{
id_usuario = guid_nusuario,
id_estatus = 1,
id_tipo_usuario = 1,
nombres = str_nombres,
a_paterno = str_apaterno,
a_materno = str_amaterno,
codigo_usuario = str_usuairo,
clave = str_password,
fecha_registro = DateTime.Now,
id_tribunal = guid_fempresa
};
m_usuario.inf_usuarios.Add(i_usuario);
m_usuario.SaveChanges();
}
limpiar_textbox();
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Datos de administrador y tribunal actualizados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
protected void cmd_save_credentials_Click(object sender, EventArgs e)
{
string str_ip = txt_ip.Text;
string str_user = txt_user.Text;
string str_pass = txt_pass.Text;
Guid id_fcenter = Guid.Parse(lbl_idcenter.Text);
int str_count;
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_credenciales
select c).Count();
str_count = items_user;
}
if (str_count == 0)
{
using (var insert_fiscal = new db_transcriptEntities())
{
var items_fiscal = new inf_credenciales
{
ip = str_ip,
usuario = str_user,
clave = str_pass,
id_usuario = id_fuser,
id_centro = id_fcenter,
fecha_registro = DateTime.Now
};
insert_fiscal.inf_credenciales.Add(items_fiscal);
insert_fiscal.SaveChanges();
}
clean_txt();
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_credenciales
where u.ip == str_ip
select new
{
u.id_credenciales,
u.ip,
u.usuario,
u.fecha_registro
}).ToList();
gv_credentialsf.DataSource = inf_user;
gv_credentialsf.DataBind();
gv_credentialsf.Visible = true;
}
rb_add_credentials.Visible = false;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Datos de conexión guardados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else if (rb_edit_credentials.Checked)
{
foreach (GridViewRow row in gv_credentials.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 data_address = new db_transcriptEntities())
{
var items_address = (from c in data_address.inf_credenciales
where c.id_credenciales == str_code
select c).FirstOrDefault();
items_address.ip = str_ip;
items_address.usuario = str_user;
items_address.clave = str_pass;
data_address.SaveChanges();
}
clean_txt();
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Horario de Conversión de videos, actualizado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_credenciales
where u.ip == str_ip
select new
{
u.id_credenciales,
u.ip,
u.usuario,
u.fecha_registro
}).ToList();
gv_credentials.DataSource = inf_user;
gv_credentials.DataBind();
gv_credentials.Visible = true;
}
}
}
}
}
}
protected void cmd_save_Click(object sender, EventArgs e)
{
Guid id_fempresa = Guid.Parse("9A3C8442-2B53-45B7-9B5C-144BFA9C93BE");
Guid id_centro = Guid.NewGuid();
Guid str_iduser = Guid.NewGuid();
string str_nameuser = txt_name_user.Text.ToUpper();
string str_apater = txt_apater.Text.ToUpper();
string str_amater = txt_amater.Text.ToUpper();
string str_codeuser = txt_code_user.Text.ToLower();
string str_password = mdl_encrypta.Encrypt(txt_password.Text.ToLower());
string str_business_name = txt_business_name.Text.ToUpper();
int str_municipality = Convert.ToInt32(ddl_municipality.SelectedValue);
string str_colony = txt_colony.Text.ToUpper();
string str_street = txt_street.Text.ToUpper();
string str_cp = txt_cp.Text;
string str_phone = txt_phone.Text;
string str_phonealt = txt_phone_alt.Text;
using (var insert_fiscal = new db_transcriptEntities())
{
var items_fiscal = new inf_centro
{
id_estatus = 1,
fecha_registro = DateTime.Now,
nombre = str_business_name,
id_municipio = str_municipality,
colonia = str_colony,
calle_num = str_street,
cp = str_cp,
telefono = str_phone,
telefono_alt = str_phonealt,
id_centro = id_centro,
id_empresa = id_fempresa,
};
insert_fiscal.inf_centro.Add(items_fiscal);
insert_fiscal.SaveChanges();
}
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_usuarios
{
id_usuario = str_iduser,
nombres = str_nameuser,
a_paterno = str_apater,
a_materno = str_amater,
id_tipo_usuario = 2,
codigo_usuario = str_codeuser,
clave = str_password,
id_estatus = 1,
fecha_registro = DateTime.Now,
id_centro = id_centro
};
insert_user.inf_usuarios.Add(items_user);
insert_user.SaveChanges();
}
clean_text();
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Datos de administrador y juzgado guardados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
private void guarda_registro()
{
string str_empresa = txt_tribunal.Text.ToUpper();
string str_telefono = txt_telefono.Text;
string str_email = txt_email.Text;
string str_callenum = txt_callenum.Text.ToUpper();
string str_cp = txt_cp.Text;
int int_colony = Convert.ToInt32(ddl_colonia.SelectedValue);
using (var data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_tribunal
where c.id_tribunal == guid_fidcentro
select c).FirstOrDefault();
items_user.nombre = str_empresa;
items_user.telefono = str_telefono;
items_user.email = str_email;
items_user.calle_num = str_callenum;
items_user.cp = str_cp;
items_user.id_asenta_cpcons = int_colony;
data_user.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_tribunal
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_userf = new db_transcriptEntities())
{
var items_userf = new inf_tribunal_dep
{
id_usuario = guid_fidusuario,
id_tribunal = ii_fecha_transf[0].id_tribunal,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_userf.inf_tribunal_dep.Add(items_userf);
insert_userf.SaveChanges();
}
}
}
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;
guid_fidcentro = inf_user.id_tribunal;
}
limpiar_textbox();
chkb_editar.Checked = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Datos de tribunal actualizado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
protected void cmd_save_Click(object sender, EventArgs e)
{
if (rb_add_transformation.Checked || rb_edit_transformation.Checked)
{
Guid id_fcenter = Guid.Parse(lbl_idcenter.Text);
string str_date = txt_date.Text;
string str_hora = txt_hora.Text;
string str_format = ddl_fhora.SelectedValue;
string dateString = str_date + " " + str_hora + " " + str_format;
DateTime str_horario = DateTime.Parse(dateString);
if (rb_add_transformation.Checked)
{
using (var insert_fiscal = new db_transcriptEntities())
{
var items_fiscal = new inf_fecha_transformacion
{
horario = str_horario,
id_usuario = id_fuser,
id_centro = id_fcenter,
fecha_registro = DateTime.Now
};
insert_fiscal.inf_fecha_transformacion.Add(items_fiscal);
insert_fiscal.SaveChanges();
}
clean_txt();
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_fecha_transformacion
where u.horario == str_horario
select new
{
u.id_fecha_transformacion,
u.horario,
u.fecha_registro
}).ToList();
gv_transformationf.DataSource = inf_user;
gv_transformationf.DataBind();
gv_transformationf.Visible = true;
}
rb_add_transformation.Visible = false;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Horario de conversión de videos, agregado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else if (rb_edit_transformation.Checked)
{
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)
{
int str_code = Convert.ToInt32(row.Cells[1].Text);
using (var data_address = new db_transcriptEntities())
{
var items_address = (from c in data_address.inf_fecha_transformacion
where c.id_fecha_transformacion == str_code
select c).FirstOrDefault();
items_address.horario = str_horario;
data_address.SaveChanges();
}
clean_txt();
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Horario de conversión de videos, actualizado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_fecha_transformacion
select new
{
u.id_fecha_transformacion,
u.horario,
u.fecha_registro
}).ToList();
gv_transformation.DataSource = inf_user;
gv_transformation.DataBind();
gv_transformation.Visible = true;
}
}
}
}
}
}
else
{
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Favor de seleccionar una accion";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
protected void cmd_save_Click(object sender, EventArgs e)
{
Guid id_fempresa = Guid.Parse(lbl_idcenter.Text);
string str_business_name = txt_business_name.Text.ToUpper();
int str_municipality = Convert.ToInt32(ddl_municipality.SelectedValue);
string str_colony = txt_colony.Text.ToUpper();
string str_street = txt_street.Text.ToUpper();
string str_cp = txt_cp.Text;
string str_phone = txt_phone.Text;
string str_phonealt = txt_phone_alt.Text;
using (var data_addressF = new db_transcriptEntities())
{
var items_addressF = (from c in data_addressF.inf_centro
where c.id_centro == id_fempresa
select c).FirstOrDefault();
items_addressF.nombre = str_business_name;
items_addressF.id_municipio = str_municipality;
items_addressF.colonia = str_colony;
items_addressF.calle_num = str_street;
items_addressF.cp = str_cp;
items_addressF.telefono = str_phone;
items_addressF.telefono_alt = str_phonealt;
data_addressF.SaveChanges();
}
chkb_editar.Checked = false;
clean_text();
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_centro on i_u.id_centro equals i_e.id_centro
where i_u.id_usuario == id_fuser
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_centro
}).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_centro.ToString();
}
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Datos de juzgado actualizados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
protected void cmd_save_days_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_days.Text))
{
txt_days.BackColor = Color.Yellow;
}
else
{
txt_days.BackColor = Color.Transparent;
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;
}
}
}
}
}
}
}
protected void cmd_save_Click(object sender, EventArgs e)
{
if (rb_add_transformation.Checked || rb_edit_transformation.Checked)
{
if (string.IsNullOrEmpty(txt_date.Text))
{
txt_date.BackColor = Color.Yellow;
}
else
{
txt_date.BackColor = Color.Transparent;
if (string.IsNullOrEmpty(txt_hora.Text))
{
txt_hora.BackColor = Color.Yellow;
}
else
{
txt_hora.BackColor = Color.Transparent;
if (string.IsNullOrEmpty(ddl_fhora.Text))
{
ddl_fhora.BackColor = Color.Yellow;
}
else
{
ddl_fhora.BackColor = Color.Transparent;
string str_date = txt_date.Text;
string str_hora = txt_hora.Text;
string str_format = ddl_fhora.SelectedValue;
string dateString = str_date + " " + str_hora + " " + str_format;
DateTime str_horario = DateTime.Parse(dateString);
if (rb_add_transformation.Checked)
{
using (var edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = new inf_fecha_transformacion
{
horario = str_horario,
id_usuario = guid_fidusuario,
id_tribunal = guid_fidcentro,
fecha_registro = DateTime.Now
};
edm_fecha_transf.inf_fecha_transformacion.Add(ii_fecha_transf);
edm_fecha_transf.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_fecha_transformacion
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_fecha_transformacion_dep
{
id_usuario = guid_fidusuario,
id_fecha_transformacion = ii_fecha_transf[0].id_fecha_transformacion,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_user.inf_fecha_transformacion_dep.Add(items_user);
insert_user.SaveChanges();
}
}
}
clean_txt();
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_fecha_transformacion
where u.horario == str_horario
select new
{
u.id_fecha_transformacion,
u.horario,
u.fecha_registro
}).ToList();
gv_transformationf.DataSource = ii_fecha_transf;
gv_transformationf.DataBind();
gv_transformationf.Visible = true;
}
rb_add_transformation.Visible = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Horario de conversión de videos, agregado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else if (rb_edit_transformation.Checked)
{
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)
{
int str_code = Convert.ToInt32(row.Cells[1].Text);
using (var edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from c in edm_fecha_transf.inf_fecha_transformacion
where c.id_fecha_transformacion == str_code
select c).FirstOrDefault();
ii_fecha_transf.horario = str_horario;
edm_fecha_transf.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_fecha_transformacion
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_fecha_transformacion_dep
{
id_usuario = guid_fidusuario,
id_fecha_transformacion = ii_fecha_transf[0].id_fecha_transformacion,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_user.inf_fecha_transformacion_dep.Add(items_user);
insert_user.SaveChanges();
}
}
}
clean_txt();
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Horario de conversión de videos, actualizado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_fecha_transformacion
select new
{
u.id_fecha_transformacion,
u.horario,
u.fecha_registro
}).ToList();
gv_transformation.DataSource = ii_fecha_transf;
gv_transformation.DataBind();
gv_transformation.Visible = true;
}
}
}
}
}
}
}
}
}
else
{
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Favor de seleccionar una accion";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
protected void cmd_save_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_name_user.Text))
{
txt_name_user.BackColor = Color.Yellow;
}
else
{
txt_name_user.BackColor = Color.Transparent;
if (string.IsNullOrEmpty(txt_apater.Text))
{
txt_apater.BackColor = Color.Yellow;
}
else
{
txt_apater.BackColor = Color.Transparent;
if (string.IsNullOrEmpty(txt_amater.Text))
{
txt_amater.BackColor = Color.Yellow;
}
else
{
txt_amater.BackColor = Color.Transparent;
if (string.IsNullOrEmpty(txt_code_user.Text))
{
txt_code_user.BackColor = Color.Yellow;
}
else
{
txt_code_user.BackColor = Color.Transparent;
if (string.IsNullOrEmpty(txt_password.Text))
{
txt_password.BackColor = Color.Yellow;
}
else
{
txt_password.BackColor = Color.Transparent;
string str_nameuser = txt_name_user.Text.ToUpper();
string str_apater = txt_apater.Text.ToUpper();
string str_amater = txt_amater.Text.ToUpper();
string str_codeuser = txt_code_user.Text.ToLower();
string str_password = mdl_encrypta.Encrypt(txt_password.Text.ToLower());
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_usuarios
where c.id_usuario == guid_fidusuario
select c).ToList();
if (items_user[0].codigo_usuario == str_codeuser)
{
using (var data_userf = new db_transcriptEntities())
{
var items_userf = (from c in data_userf.inf_usuarios
where c.id_usuario == guid_fidusuario
select c).FirstOrDefault();
items_userf.codigo_usuario = str_codeuser;
items_userf.nombres = str_nameuser;
items_userf.a_paterno = str_apater;
items_userf.a_materno = str_amater;
items_userf.clave = str_password;
data_userf.SaveChanges();
}
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;
}
clean_data();
chkb_editar.Checked = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Datos de usuario actualizados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
using (db_transcriptEntities data_userb = new db_transcriptEntities())
{
var items_userb = (from c in data_userb.inf_usuarios
where c.codigo_usuario == str_codeuser
select c).ToList();
if (items_userb.Count == 0)
{
using (var data_userf = new db_transcriptEntities())
{
var items_userf = (from c in data_userf.inf_usuarios
where c.id_usuario == guid_fidusuario
select c).FirstOrDefault();
items_userf.codigo_usuario = str_codeuser;
items_userf.nombres = str_nameuser;
items_userf.a_paterno = str_apater;
items_userf.a_materno = str_amater;
items_userf.clave = str_password;
data_userf.SaveChanges();
}
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;
}
clean_data();
chkb_editar.Checked = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Datos de usuario actualizados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
//clean_data();
txt_code_user.Text = "";
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Usuario ya existe en la base, agregar otro usuario";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
}
}
}
}
}
}
}
}
protected void cmd_save_path_Click(object sender, EventArgs e)
{
Guid id_fcenter = Guid.Parse(lbl_idcenter.Text);
int str_count, str_fpath;
string str_user = txt_user.Text;
string str_pass = txt_pass.Text;
var networkPath = txt_path_videos.Text;
try
{
using (new NetworkConnection(networkPath, new NetworkCredential(str_user, str_pass)))
{
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_ruta_videos
select c).Count();
str_count = items_user;
}
if (str_count == 0)
{
using (var insert_fiscal = new db_transcriptEntities())
{
var items_fiscal = new inf_ruta_videos
{
desc_ruta_fin = @"C:\inetpub\wwwroot\videos",
ruta_user_ini = str_user,
ruta_pass_ini = str_pass,
desc_ruta_ini = networkPath,
id_usuario = id_fuser,
id_centro = id_fcenter,
fecha_registro = DateTime.Now
};
insert_fiscal.inf_ruta_videos.Add(items_fiscal);
insert_fiscal.SaveChanges();
}
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_ruta_videos
select new
{
u.id_ruta_videos,
u.desc_ruta_ini,
u.fecha_registro
}).ToList();
gv_routevideosf.DataSource = inf_user;
gv_routevideosf.DataBind();
gv_routevideosf.Visible = true;
}
txt_user.Text = "";
txt_pass.Text = "";
txt_path_videos.Text = "";
rb_add_routevideos.Visible = false;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Ruta de de videos guardada con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_ruta_videos
select c).FirstOrDefault();
str_fpath = items_user.id_ruta_videos;
}
using (var data_address = new db_transcriptEntities())
{
var items_address = (from c in data_address.inf_ruta_videos
where c.id_ruta_videos == str_fpath
select c).FirstOrDefault();
items_address.ruta_user_ini = str_user;
items_address.ruta_pass_ini = str_pass;
items_address.desc_ruta_ini = networkPath;
data_address.SaveChanges();
}
txt_user.Text = "";
txt_pass.Text = "";
txt_path_videos.Text = "";
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_ruta_videos
select new
{
u.id_ruta_videos,
u.desc_ruta_ini,
u.fecha_registro
}).ToList();
gv_routevideos.DataSource = inf_user;
gv_routevideos.DataBind();
gv_routevideos.Visible = true;
}
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Ruta de de videos actualizada con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
}
catch (DirectoryNotFoundException ex)
{
string str_msj = ex.Message.ToString();
lblModalTitle.Text = "tranScript";
lblModalBody.Text = str_msj;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
//if (Directory.Exists(str_path_video))
//{
//}
//else
//{
// lblModalTitle.Text = "tranScript";
// lblModalBody.Text = "Directorio invalido, favor de reintentar";
// ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
// upModal.Update();
//}
}
protected void cmd_save_credentials_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_ip.Text))
{
txt_ip.BackColor = Color.Yellow;
}
else
{
txt_ip.BackColor = Color.Transparent;
if (string.IsNullOrEmpty(txt_user.Text))
{
txt_user.BackColor = Color.Yellow;
}
else
{
txt_user.BackColor = Color.Transparent;
if (string.IsNullOrEmpty(txt_pass.Text))
{
txt_pass.BackColor = Color.Yellow;
}
else
{
txt_pass.BackColor = Color.Transparent;
string str_ip = txt_ip.Text;
string str_user = txt_user.Text;
string str_pass = txt_pass.Text;
int str_count;
using (db_transcriptEntities edm_conexion = new db_transcriptEntities())
{
var i_conexion = (from c in edm_conexion.inf_credenciales
select c).Count();
str_count = i_conexion;
}
if (str_count == 0)
{
using (var edm_conexion = new db_transcriptEntities())
{
var ii_conexion = new inf_credenciales
{
ip = str_ip,
usuario = str_user,
clave = str_pass,
fecha_registro = DateTime.Now
};
edm_conexion.inf_credenciales.Add(ii_conexion);
edm_conexion.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_credenciales
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_credenciales_dep
{
id_usuario = guid_fidusuario,
id_credenciales = ii_fecha_transf[0].id_credenciales,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_user.inf_credenciales_dep.Add(items_user);
insert_user.SaveChanges();
}
}
}
clean_txt();
using (db_transcriptEntities edm_conexion = new db_transcriptEntities())
{
var ii_conexion = (from u in edm_conexion.inf_credenciales
where u.ip == str_ip
select new
{
u.id_credenciales,
u.ip,
u.usuario,
u.fecha_registro
}).ToList();
gv_credentialsf.DataSource = ii_conexion;
gv_credentialsf.DataBind();
gv_credentialsf.Visible = true;
}
rb_add_credentials.Visible = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Datos de conexión, guardados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else if (rb_edit_credentials.Checked)
{
foreach (GridViewRow row in gv_credentials.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_conexion = new db_transcriptEntities())
{
var i_conexion = (from c in edm_conexion.inf_credenciales
where c.id_credenciales == str_code
select c).FirstOrDefault();
i_conexion.ip = str_ip;
i_conexion.usuario = str_user;
i_conexion.clave = str_pass;
edm_conexion.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_credenciales
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_credenciales_dep
{
id_usuario = guid_fidusuario,
id_credenciales = ii_fecha_transf[0].id_credenciales,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_user.inf_credenciales_dep.Add(items_user);
insert_user.SaveChanges();
}
}
}
clean_txt();
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Datos de conexión, actualizados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
using (db_transcriptEntities edm_conexion = new db_transcriptEntities())
{
var i_conexion = (from u in edm_conexion.inf_credenciales
select new
{
u.id_credenciales,
u.ip,
u.usuario,
u.fecha_registro
}).ToList();
gv_credentials.DataSource = i_conexion;
gv_credentials.DataBind();
gv_credentials.Visible = true;
}
}
}
}
}
//else if (rb_del_credentials.Checked)
//{
// foreach (GridViewRow row in gv_credentials.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 data_user = new db_transcriptEntities())
// {
// var items_user = (from c in data_user.inf_credenciales
// where c.id_credenciales == str_code
// select c).FirstOrDefault();
// data_user.inf_credenciales.Remove(items_user);
// data_user.SaveChanges();
// }
// clean_txt();
// lblModalTitle.Text = "transcript";
// lblModalBody.Text = "Datos de conexión, actualizado con éxito";
// ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
// upModal.Update();
// using (db_transcriptEntities edm_conexion = new db_transcriptEntities())
// {
// var i_conexion = (from u in edm_conexion.inf_credenciales
// select new
// {
// u.id_credenciales,
// u.ip,
// u.usuario,
// u.fecha_registro
// }).ToList();
// gv_credentials.DataSource = i_conexion;
// gv_credentials.DataBind();
// gv_credentials.Visible = true;
// }
// }
// }
// }
//}
}
}
}
}
protected void cmd_save_Click(object sender, EventArgs e)
{
if (rb_add.Checked == false & rb_edit.Checked == false & rb_del.Checked == false)
{
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Favor de seleccionar una acción";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
Guid str_idcentro = Guid.Parse(lbl_id_centerCP.Text);
Guid str_iduser = Guid.NewGuid();
string str_nameuser = txt_name_user.Text.ToUpper();
string str_apater = txt_apater.Text.ToUpper();
string str_amater = txt_amater.Text.ToUpper();
string str_codeuser = txt_code_user.Text.ToLower();
string str_password = mdl_encrypta.Encrypt(txt_password.Text.ToLower());
Guid f_id_user;
if (rb_add.Checked)
{
try
{
string str_filter_code;
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_usuarios
where c.codigo_usuario == str_codeuser
select c).FirstOrDefault();
str_filter_code = items_user.codigo_usuario.ToString();
}
if (str_codeuser == str_filter_code)
{
clean_data();
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Usuario ya existe en la base, agregar otro usuario";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
catch
{
int save_user = (int)(Session["ss_save_user"]);
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_usuarios
{
id_usuario = str_iduser,
nombres = str_nameuser,
a_paterno = str_apater,
a_materno = str_amater,
id_tipo_usuario = save_user,
codigo_usuario = str_codeuser,
clave = str_password,
id_estatus = 1,
fecha_registro = DateTime.Now,
id_centro = str_idcentro
};
insert_user.inf_usuarios.Add(items_user);
insert_user.SaveChanges();
}
clean_data();
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Datos de usuario guardados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
else if (rb_edit.Checked)
{
foreach (GridViewRow row in gv_usuarios.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[1].FindControl("chk_select") as CheckBox);
if (chkRow.Checked)
{
string codeuser = row.Cells[1].Text;
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_usuarios
where c.codigo_usuario == codeuser
select c).FirstOrDefault();
f_id_user = items_user.id_usuario;
}
using (var data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_usuarios
where c.id_usuario == f_id_user
select c).FirstOrDefault();
items_user.nombres = str_nameuser;
items_user.a_paterno = str_apater;
items_user.a_materno = str_amater;
items_user.codigo_usuario = str_codeuser;
items_user.clave = str_password;
data_user.SaveChanges();
}
clean_data();
rb_edit.Checked = false;
gv_usuarios.Visible = false;
txt_search.Visible = false;
cmd_search.Visible = false;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Datos de usuario actualizados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
}
}
else if (rb_del.Checked)
{
foreach (GridViewRow row in gv_usuarios.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chk_select") as CheckBox);
if (chkRow.Checked)
{
string codeuser = row.Cells[1].Text;
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_usuarios
where c.codigo_usuario == codeuser
select c).FirstOrDefault();
f_id_user = items_user.id_usuario;
}
using (var data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_usuarios
where c.id_usuario == f_id_user
select c).FirstOrDefault();
items_user.id_estatus = 3;
data_user.SaveChanges();
}
clean_data();
rb_del.Checked = false;
gv_usuarios.Visible = false;
txt_search.Visible = false;
cmd_search.Visible = false;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Datos de usuario eliminados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
}
}
}
}
protected void gv_files_RowCommand(object sender, GridViewCommandEventArgs e)
{
foreach (GridViewRow row in gv_files.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[3].FindControl("chk_select") as CheckBox);
if (chkRow.Checked)
{
if (row.RowType == DataControlRowType.DataRow)
{
Button btnButton = (Button)row.FindControl("cmd_action");
if (row.Cells[8].Text == "ERROR")
{
str_session = row.Cells[1].Text;
str_video = row.Cells[5].Text;
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 = 6;
data_mat.SaveChanges();
}
var two_user = new int?[] { 1, 6 };
flist_user(two_user);
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Comienza proceso de Conversión, favor de esperar.";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else if (row.Cells[8].Text == "CARGADO")
{
Guid id_fcenter = Guid.Parse(lbl_idcenter.Text);
div_panel.Visible = true;
UpdatePanel2.Update();
using (var insert_fiscal = new db_transcriptEntities())
{
var items_fiscal = new inf_log_videos
{
sesion = str_session,
video = str_video,
id_usuario = id_fuser,
id_centro = id_fcenter,
fecha_registro = DateTime.Now,
fecha_registro_alt = DateTime.Now
};
insert_fiscal.inf_log_videos.Add(items_fiscal);
insert_fiscal.SaveChanges();
}
string str_namefile = @"videos\" + row.Cells[5].Text;
play_video.Visible = true;
play_video.Attributes["src"] = str_namefile;
}
}
}
}
}
}
