/// <summary>
/// Lista Areas en el aplicativo registradas
/// </summary>
/// <returns></returns>
public List <BEArea> ListarArea()
{
List <BEArea> Lista = new List <BEArea>();
BEArea item;
using (SqlConnection ocn = new SqlConnection(Util.getConnection()))
{
using (SqlCommand ocmd = new SqlCommand("Perfil.SP_Area_Select", ocn))
{
ocmd.CommandType = CommandType.StoredProcedure;
ocn.Open();
using (SqlDataReader oReader = ocmd.ExecuteReader())
{
while (oReader.Read())
{
//Instanciamos la variable
item = new BEArea();
//cargamos la informacion de la BD
if (!Convert.IsDBNull(oReader["id"]))
{
item.id = Convert.ToInt32(oReader["id"]);
}
if (!Convert.IsDBNull(oReader["gls_area"]))
{
item.gls_area = oReader["gls_area"].ToString();
}
if (!Convert.IsDBNull(oReader["estado"]))
{
item.estado = oReader["estado"].ToString();
}
//Agregamos el elemento al listado
Lista.Add(item);
}
}
}
ocn.Close();
return(Lista);
}
}
public List <BEArea> ListarArea()
{
List <BEArea> oListado = new List <BEArea>();
BEArea oItem;
using (NpgsqlConnection ocn = new NpgsqlConnection(Util.getConnection()))
{
ocn.Open();
NpgsqlTransaction tran = ocn.BeginTransaction();
using (NpgsqlCommand ocmd = new NpgsqlCommand("public.func_listar_area", ocn))
{
ocmd.CommandType = CommandType.StoredProcedure;
using (NpgsqlDataReader odr = ocmd.ExecuteReader())
{
while (odr.Read())
{
oItem = new BEArea();
if (!Convert.IsDBNull(odr["cod_area"]))
{
oItem.cod_area = Convert.ToInt32(odr["cod_area"]);
}
if (!Convert.IsDBNull(odr["gls_area"]))
{
oItem.gls_area = odr["gls_area"].ToString();
}
if (!Convert.IsDBNull(odr["cod_estado_registro"]))
{
oItem.cod_estado_registro = Convert.ToInt32(odr["cod_estado_registro"]);
}
oListado.Add(oItem);
}
odr.Close();
}
}
tran.Commit();
ocn.Close();
}
return(oListado);
}
public BEArea GetAreaxId(int id)
{
BEArea result = new BEArea();
SqlCommand cmd = new SqlCommand("dbo.uspGetAreaxId");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id", SqlDbType.Int, 14).Value = id;
SqlDataReader reader = ExecuteReader(cmd, 1);
while (reader.Read())
{
result.id = (!reader[0].Equals(DBNull.Value)) ? reader.GetInt32(0) : -1;
result.codigo = ((!reader[1].Equals(DBNull.Value)) ? reader.GetString(1) : "-");
result.descripcion = ((!reader[1].Equals(DBNull.Value)) ? reader.GetString(2) : "-");
}
return(result);
}
