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; } } } } } }