public RAreaBE ObtenerAreaPorId(int piIdArea)
{
RAreaBE oAreaBE = new RAreaBE();
Database objDB = Util.CrearBaseDatos();
using (DbCommand objCMD = objDB.GetStoredProcCommand("USPR_GET_OBTENERAREAPORID"))
{
try
{
objDB.AddInParameter(objCMD, "@Id", DbType.Int32, piIdArea);
using (IDataReader oDataReader = objDB.ExecuteReader(objCMD))
{
if (oDataReader.Read())
{
oAreaBE.Id = (int)oDataReader["Id"];
oAreaBE.IdGerenciaDivision = (int)oDataReader["IdGerenciaDivision"];
oAreaBE.IdGerenciaCentral = (int)oDataReader["IdGerenciaCentral"];
oAreaBE.Descripcion = (string)oDataReader["Descripcion"];
oAreaBE.ResponsableArea = (string)oDataReader["ResponsableArea"];
oAreaBE.JefeSupervisor = (string)oDataReader["JefeSupervisor"];
oAreaBE.EstaActivo = (bool)oDataReader["EstaActivo"];
}
}
}
catch (Exception ex)
{
throw ex;
}
}
return(oAreaBE);
}
public bool ActualizarArea(RAreaBE poAreaBE)
{
int res = 0;
Database objDB = Util.CrearBaseDatos();
using (DbCommand objCMD = objDB.GetStoredProcCommand("USPR_UPD_AREA"))
{
objDB.AddInParameter(objCMD, "@Id", DbType.Int32, poAreaBE.Id);
objDB.AddInParameter(objCMD, "@IdGerenciaDivision", DbType.Int32, poAreaBE.IdGerenciaDivision);
objDB.AddInParameter(objCMD, "@Descripcion", DbType.String, poAreaBE.Descripcion);
objDB.AddInParameter(objCMD, "@ResponsableArea", DbType.String, poAreaBE.ResponsableArea);
objDB.AddInParameter(objCMD, "@JefeSupervisor", DbType.String, poAreaBE.JefeSupervisor);
try
{
res = objDB.ExecuteNonQuery(objCMD);
}
catch (Exception ex)
{
throw ex;
}
}
return(res > 0);
}
public List <RAreaBE> ObtenerAreas(int IdGerenciaCentral, int IdGerenciaDivision)
{
List <RAreaBE> oListaAreaes = new List <RAreaBE>();
Database objDB = Util.CrearBaseDatos();
using (DbCommand objCMD = objDB.GetStoredProcCommand("USPR_GET_OBTENERAREACOMPLETO"))
{
try
{
objDB.AddInParameter(objCMD, "@idGerenciaCentral", DbType.Int32, IdGerenciaCentral);
objDB.AddInParameter(objCMD, "@idGerenciaDivision", DbType.Int32, IdGerenciaDivision);
using (IDataReader oDataReader = objDB.ExecuteReader(objCMD))
{
while (oDataReader.Read())
{
RAreaBE oAreaaBE = new RAreaBE();
oAreaaBE.Id = (int)oDataReader["Id"];
oAreaaBE.Descripcion = (string)oDataReader["Descripcion"];
oAreaaBE.ResponsableArea = (string)oDataReader["ResponsableArea"];
oAreaaBE.JefeSupervisor = (string)oDataReader["JefeSupervisor"];
oAreaaBE.IdGerenciaCentral = (int)oDataReader["IdGerenciaCentral"];
oAreaaBE.DescripcionGerenciaCentral = (string)oDataReader["GerenciaCentral"];
oAreaaBE.DescripcionGerenciaDivision = (string)oDataReader["GerenciaDivision"];
oAreaaBE.EstaActivo = (bool)oDataReader["EstaActivo"];
oListaAreaes.Add(oAreaaBE);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
return(oListaAreaes);
}
