protected void gv_material_ext_RowCommand(object sender, GridViewCommandEventArgs e) { try { GridViewRow gvr = (GridViewRow)(((Button)e.CommandSource).NamingContainer); string status = gvr.Cells[5].Text.ToString().Trim(); int id_sessionf = int.Parse(gvr.Cells[0].Text); int id_session; string str_sessionf; using (var data_mat = new db_transcriptEntities()) { var items_mat = (from c in data_mat.inf_material_ext where c.id_material_ext == id_sessionf select c).FirstOrDefault(); id_session = items_mat.id_material; } using (var data_mat = new db_transcriptEntities()) { var items_mat = (from c in data_mat.inf_material where c.id_material == id_session select c).FirstOrDefault(); str_sessionf = items_mat.sesion; } str_session = gvr.Cells[1].Text; str_video = gvr.Cells[2].Text + ".mp4"; var two_user = new int?[] { 1, 3, 4, 5, 8, 9 }; switch (status) { case "ACTIVO": using (var edm_material = new db_transcriptEntities()) { var i_material = new inf_material_dep { sesion = str_session, video = str_video, id_usuario = guid_fidusuario, id_material = 0, fecha_registro = DateTime.Now, fecha_registro_alt = DateTime.Now }; edm_material.inf_material_dep.Add(i_material); edm_material.SaveChanges(); } string d_pdf = "videos\\" + str_sessionf + "\\" + str_session + "\\" + str_session + "\\ExtraFiles\\" + str_session + "_Report.pdf"; iframe_pdf.Visible = true; iframe_pdf.Attributes["src"] = d_pdf; string str_namefile = @"videos\\" + str_sessionf + "\\" + str_session + "\\" + str_session + "\\" + str_video; play_video.Visible = true; play_video.Attributes["src"] = str_namefile; Button btn = e.CommandSource as Button; string name_btn = btn.Text; if (name_btn == "PDF") { lblModalTitle.Text = "transcript"; Label1.Text = "Expediente:" + str_sessionf + " - Sesión:" + str_session + " - Archivo:" + str_video.Replace(".mp4", ""); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal_pdf", "$('#myModal_pdf').modal();", true); up_pdf.Update(); } else { lblModalTitle.Text = "transcript"; Label2.Text = "Expediente:" + str_sessionf + " - Sesión:" + str_session + " - Archivo:" + str_video.Replace(".mp4", ""); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal_video", "$('#myModal_video').modal();", true); up_video.Update(); } break; case "ERROR": using (var data_mat = new db_transcriptEntities()) { var items_mat = (from c in data_mat.inf_material where c.sesion == str_session select c).FirstOrDefault(); items_mat.id_estatus_material = 3; data_mat.SaveChanges(); } flist_user(two_user); break; case "NUEVO": using (var data_mat = new db_transcriptEntities()) { var items_mat = (from c in data_mat.inf_material where c.sesion == str_session select c).FirstOrDefault(); items_mat.id_estatus_material = 3; data_mat.SaveChanges(); } flist_user(two_user); break; } } catch { } }
protected void Unnamed_Click(object sender, EventArgs e) { //play_video.Visible = false; //div_panel.Visible = false; //UpdatePanel2.Update(); GridViewRow row = (sender as LinkButton).NamingContainer as GridViewRow; var two_user = new int?[] { 1, 3, 4, 5, 8, 9 }; string status = row.Cells[5].Text.ToString().Trim(); int id_m_ext = int.Parse(row.Cells[0].Text); int id_m; switch (status) { case "XML": break; case "ACTIVO": string str_session_p; str_session = row.Cells[1].Text; str_video = row.Cells[2].Text + ".mp4"; //using (var data_mat = new db_transcriptEntities()) //{ // var items_mat = (from c in data_mat.inf_material // where c.sesion == str_session // select c).FirstOrDefault(); // str_session_p //} using (var edm_material = new db_transcriptEntities()) { var i_material = new inf_material_dep { sesion = str_session, video = str_video, id_usuario = guid_fidusuario, id_material = 0, fecha_registro = DateTime.Now, fecha_registro_alt = DateTime.Now }; edm_material.inf_material_dep.Add(i_material); edm_material.SaveChanges(); } using (var data_mat = new db_transcriptEntities()) { var items_mat = (from c in data_mat.inf_material_ext where c.id_material_ext == id_m_ext select c).FirstOrDefault(); id_m = items_mat.id_material; } using (var data_mat = new db_transcriptEntities()) { var items_mat = (from c in data_mat.inf_material where c.id_material == id_m select c).FirstOrDefault(); string sessionf = items_mat.sesion; string d_pdf = "videos\\" + sessionf + "\\" + str_session + "\\" + str_session + "\\ExtraFiles\\" + str_session + "_Report.pdf"; iframe_pdf.Visible = true; iframe_pdf.Attributes["src"] = d_pdf; string str_namefile = @"videos\\" + sessionf + "\\" + str_session + "\\" + str_session + "\\" + str_video; play_video.Attributes["src"] = str_namefile; } s_gn = 1; break; case "ERROR": using (var data_mat = new db_transcriptEntities()) { var items_mat = (from c in data_mat.inf_material where c.sesion == str_session select c).FirstOrDefault(); items_mat.id_estatus_material = 3; data_mat.SaveChanges(); } break; case "NUEVO": using (var data_mat = new db_transcriptEntities()) { var items_mat = (from c in data_mat.inf_material where c.sesion == str_session select c).FirstOrDefault(); items_mat.id_estatus_material = 3; data_mat.SaveChanges(); } flist_user(two_user); break; } //play_video.Visible = true; //div_panel.Visible = true; //UpdatePanel2.Update(); //Response.Redirect(Request.Url.AbsoluteUri); }
protected void gv_usr_ext_RowCommand(object sender, GridViewCommandEventArgs e) { string str_session = null; string str_video = null; string str_pdf = null; string str_mp4 = null; string str_exp = null; int int_estatus; Guid guid_exp, guid_se; try { GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); guid_se = Guid.Parse(gvr.Cells[0].Text.ToString().Trim()); using (var data_mat = new bd_tsEntities()) { var items_mat = (from c in data_mat.inf_exp_mat where c.id_exp_mat == guid_se select c).FirstOrDefault(); guid_exp = Guid.Parse(items_mat.id_control_exp.ToString()); str_video = items_mat.ruta_archivo; str_pdf = items_mat.ruta_ext.Replace("C:\\inetpub\\wwwroot\\", "").Replace(".mp4", ".pdf"); str_mp4 = items_mat.ruta_archivo.Replace("C:\\inetpub\\wwwroot\\", ""); int_estatus = 1; str_session = items_mat.nom_archivo; var i_extmat = (from c in data_mat.inf_master_jvl where c.id_control_exp == guid_exp select c).FirstOrDefault(); str_exp = i_extmat.sesion; } //using (var data_mat = new bd_tsEntities()) //{ // var items_mat = (from c in data_mat.inf_material // where c.id_material == id_session // select c).FirstOrDefault(); // str_sessionf = items_mat.sesion; //} switch (int_estatus) { case 1: guid_fidusuario = (Guid)(Session["ss_id_user"]); using (var edm_material = new bd_tsEntities()) { var i_material = new inf_material_dep { id_exp_mat = guid_se, id_usuario = guid_fidusuario, fecha_registro = DateTime.Now, fecha_registro_alt = DateTime.Now }; edm_material.inf_material_dep.Add(i_material); edm_material.SaveChanges(); } //string d_pdf = "videos\\" + str_sessionf + "\\" + str_session + "\\" + str_session + "\\ExtraFiles\\" + str_session + "_Report.pdf"; //iframe_pdf.Visible = true; //iframe_pdf.Attributes["src"] = d_pdf; //string str_namefile = @"videos\\" + str_sessionf + "\\" + str_session + "\\" + str_session + "\\" + str_video; LinkButton btn = e.CommandSource as LinkButton; string name_btn = null; name_btn = btn.ID; if (name_btn == "lkb_pdf_exp") { iframe_pdf.Visible = true; iframe_pdf.Attributes["src"] = str_pdf; lblModalTitle.Text = "transcript"; Label1.Text = "Expediente:" + str_exp + " - Sesión:" + str_session + ""; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal_pdf", "$('#myModal_pdf').modal();", true); up_pdf.Update(); } else { play_video.Visible = true; play_video.Attributes["src"] = str_mp4; lblModalTitle.Text = "transcript"; Label2.Text = "Expediente:" + str_exp + " - Sesión:" + str_session + ""; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal_video", "$('#myModal_video').modal();", true); up_video.Update(); } break; case 2: using (var data_mat = new bd_tsEntities()) { var items_mat = (from c in data_mat.inf_material where c.sesion == str_session select c).FirstOrDefault(); items_mat.id_estatus_material = 3; data_mat.SaveChanges(); } //flist_user(two_user); break; case 3: using (var data_mat = new bd_tsEntities()) { var items_mat = (from c in data_mat.inf_material where c.sesion == str_session select c).FirstOrDefault(); items_mat.id_estatus_material = 3; data_mat.SaveChanges(); } //flist_user(two_user); break; } } catch { } }