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