protected void GRDProgramas_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { Subprograma objSubProg = new Subprograma(); string Verificador = string.Empty; int fila = e.RowIndex; objSubProg.Id = Convert.ToString(GRDProgramas.Rows[fila].Cells[2].Text); if (SesionUsu.Usu_TipoUsu == "SA") { CN_Subprog.EliminarSubProg(objSubProg, ref Verificador); if (Verificador == "0") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(1, 'Se ha eliminado correctamente')", true); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, '" + Verificador + "')", true); } } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, '" + Verificador + "')", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, '" + ex.Message + "')", true); } }
public void ObtenerDatosSubprograma(ref Subprograma objSubprograma, ref string Verificador) { CD_Datos CDDatos = new CD_Datos(); OracleCommand Cmd = null; try { string[] ParametrosIn = { "P_ID" }; object[] Valores = { objSubprograma.Id }; string[] ParametrosOut = { "P_CLAVE", "P_DESCRIPCION", "P_VALOR", "P_BANDERA" }; Cmd = CDDatos.GenerarOracleCommand("OBT_SAF_BASICOS_SUB_PROG", ref Verificador, ParametrosIn, Valores, ParametrosOut); if (Verificador == "0") { objSubprograma = new Subprograma(); objSubprograma.Id = Convert.ToString(Cmd.Parameters["P_ID"].Value); objSubprograma.Clave = Convert.ToString(Cmd.Parameters["P_CLAVE"].Value); objSubprograma.Descripcion = Convert.ToString(Cmd.Parameters["P_DESCRIPCION"].Value); objSubprograma.NivAcad = Convert.ToString(Cmd.Parameters["P_VALOR"].Value); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { CDDatos.LimpiarOracleCommand(ref Cmd); } }
public void SubprogramasGrid(ref Subprograma objSubprograma, ref List <Subprograma> List) { CD_Datos CDDatos = new CD_Datos(); OracleCommand cmm = null; try { OracleDataReader dr = null; String[] Parametros = { "p_nivel_acad", "p_ejercicio", "p_dependencia", "p_dependencia_f" }; String[] Valores = { objSubprograma.NivAcad, objSubprograma.Ejercicio, objSubprograma.DependenciaI, objSubprograma.DependenciaF }; cmm = CDDatos.GenerarOracleCommandCursor("PKG_PRESUPUESTO.Obt_Grid_SubPrograma_Cat", ref dr, Parametros, Valores); while (dr.Read()) { objSubprograma = new Subprograma(); objSubprograma.Id = Convert.ToString(dr.GetValue(0)); objSubprograma.Subprog = Convert.ToString(dr.GetValue(1)); objSubprograma.Descripcion = Convert.ToString(dr.GetValue(2)); List.Add(objSubprograma); } dr.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { CDDatos.LimpiarOracleCommand(ref cmm); } }
protected void BTNEditarSubProg_Click(object sender, EventArgs e) { try { if (SesionUsu.Usu_TipoUsu == "SA") { Subprograma objSubProg = new Subprograma(); string Verificador = string.Empty; objSubProg.Id = (String)Session["SessionIdSubProg"]; objSubProg.NivAcad = DDLNvlacd2.SelectedValue; objSubProg.Clave = txtPrograma.Text; objSubProg.Descripcion = txtDescripcion.Text; CN_Subprog.EditarSubProg(ref objSubProg, ref Verificador); if (Verificador == "0") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(1, 'Se ha modificado correctamente.')", true); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, '" + Verificador + ".')", true); } } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, 'No tiene privilegios para realizar esta acción.')", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, '" + ex.Message + "')", true); } }
protected void GRDProgramas_SelectedIndexChanged(object sender, EventArgs e) { try { if (SesionUsu.Usu_TipoUsu == "SA") { Subprograma objSubProg = new Subprograma(); string Verificador = string.Empty; CargarCombos2(); objSubProg.Id = Convert.ToString(GRDProgramas.SelectedRow.Cells[2].Text); CN_Subprog.ObtenerDatosSubprograma(ref objSubProg, ref Verificador); if (Verificador == "0") { Multiview1.ActiveViewIndex = 1; Session["SessionIdSubProg"] = objSubProg.Id; DDLNvlacd2.SelectedValue = objSubProg.NivAcad; txtPrograma.Text = objSubProg.Clave; txtDescripcion.Text = objSubProg.Descripcion; } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, '" + Verificador + "')", true); } } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, 'No tiene los privilegios para realizar esta acción')", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, '" + ex.Message + "')", true); } }
public void SubprogramasGrid(ref Subprograma objSubprog, ref List <Subprograma> List) { try { CD_Subprograma CD_Subprograma = new CD_Subprograma(); CD_Subprograma.SubprogramasGrid(ref objSubprog, ref List); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void EliminarSubProg(Subprograma objSubprograma, ref string Verificador) { try { CD_Subprograma CD_Subprograma = new CD_Subprograma(); CD_Subprograma.EliminarSubProg(objSubprograma, ref Verificador); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void ObtenerDatosSubprograma(ref Subprograma objSubprograma, ref string Verificador) { try { CD_Subprograma CD_Subprograma = new CD_Subprograma(); CD_Subprograma.ObtenerDatosSubprograma(ref objSubprograma, ref Verificador); } catch (Exception ex) { throw new Exception(ex.Message); } }
// GET: Subprogramas/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Subprograma subprograma = db.Subprograma.Find(id); if (subprograma == null) { return(HttpNotFound()); } return(View(subprograma)); }
// GET: Subprogramas/Delete/5 public ActionResult DeleteConfirmed(int id) { try { Subprograma subprograma = db.Subprograma.Find(id); db.Subprograma.Remove(subprograma); db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception e) { return(View()); } }
// GET: Subprogramas/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Subprograma subprograma = db.Subprograma.Find(id); if (subprograma == null) { return(HttpNotFound()); } ViewBag.id_programa = new SelectList(db.Programa, "id_programa", "nombre", subprograma.id_programa); return(View(subprograma)); }
public ActionResult Edit([Bind(Include = "id_sub,nombre,descripcion,meta,monto,id_programa")] Subprograma subprograma) { if (ModelState.IsValid) { try { db.Entry(subprograma).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception e) { ViewBag.Flag = "field_error"; ViewBag.id_programa = new SelectList(db.Programa, "id_programa", "nombre", subprograma.id_programa); return(View(subprograma)); } } ViewBag.id_programa = new SelectList(db.Programa, "id_programa", "nombre", subprograma.id_programa); return(View(subprograma)); }
public void EditarSubProg(ref Subprograma objSubProg, ref string Verificador) { CD_Datos CDDatos = new CD_Datos(); OracleCommand Cmd = null; try { String[] Parametros = { "P_ID", "P_CLAVE", "P_DESCRIPCION", "P_VALOR" }; object[] Valores = { objSubProg.Id, objSubProg.Clave, objSubProg.Descripcion, objSubProg.NivAcad }; String[] ParametrosOut = { "p_Bandera" }; Cmd = CDDatos.GenerarOracleCommand("UPD_SAF_SUB_PROGRAMAS", ref Verificador, Parametros, Valores, ParametrosOut); } catch (Exception ex) { throw new Exception(ex.Message); } finally { CDDatos.LimpiarOracleCommand(ref Cmd); } }
public void EliminarSubProg(Subprograma objSubProg, ref string Verificador) { CD_Datos CDDatos = new CD_Datos(); OracleCommand Cmd = null; try { String[] Parametros = { "P_ID" }; object[] Valores = { objSubProg.Id }; String[] ParametrosOut = { "p_Bandera" }; Cmd = CDDatos.GenerarOracleCommand("", ref Verificador, Parametros, Valores, ParametrosOut); } catch (Exception ex) { throw new Exception(ex.Message); } finally { CDDatos.LimpiarOracleCommand(ref Cmd); } }
protected void DDLNvlacd_SelectedIndexChanged(object sender, EventArgs e) { try { Subprograma objSubprogramaa = new Subprograma(); List <Subprograma> list = new List <Subprograma>(); objSubprogramaa.DependenciaI = "11101"; objSubprogramaa.DependenciaF = "81101"; objSubprogramaa.NivAcad = DDLNvlacd.SelectedValue; objSubprogramaa.Ejercicio = SesionUsu.Usu_Ejercicio; CN_Subprog.SubprogramasGrid(ref objSubprogramaa, ref list); //SqlDataAdapter sda = new SqlDataAdapter(cmd); //DataSet ds = new DataSet(); //sda.Fill(ds);// GRDProgramas.DataSource = list; GRDProgramas.DataBind(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, '" + ex.Message + "')", true); } }
protected void GRDCargarDatosFuncion() { try { Multiview1.ActiveViewIndex = 0; Subprograma objSubprogramaa = new Subprograma(); List <Subprograma> list = new List <Subprograma>(); objSubprogramaa.DependenciaI = "11101"; objSubprogramaa.DependenciaF = "81101"; objSubprogramaa.NivAcad = "9"; objSubprogramaa.Ejercicio = SesionUsu.Usu_Ejercicio; CN_Subprog.SubprogramasGrid(ref objSubprogramaa, ref list); //SqlDataAdapter sda = new SqlDataAdapter(cmd); //DataSet ds = new DataSet(); //sda.Fill(ds);// GRDProgramas.DataSource = list; GRDProgramas.DataBind(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "modal", "mostrar_modal(0, '" + ex.Message + "')", true); } }