public List <CategoriaBEAN> ListarCatInactivas()
{
List <CategoriaBEAN> lista = new List <CategoriaBEAN>();
CategoriaBEAN oCat;
try
{
using (var conn = new SqlConnection(_StringConnection))
{
using (var cmd = new SqlCommand("Sp_ListCategoriaInactivas", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
oCat = new CategoriaBEAN();
oCat.IdCategoria = Convert.ToInt32(dr[0]);
oCat.NombCat = Convert.ToString(dr[1]);
lista.Add(oCat);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lista);
}
public List <CategoriaBEAN> ActivarCat(int idCateg)
{
List <CategoriaBEAN> listaCat = new List <CategoriaBEAN>();
CategoriaBEAN oCatBean;
try
{
using (var con = new SqlConnection(_StringConnection))
{
using (var cmd = new SqlCommand("SP_ActivarCat", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idCat", idCateg);
con.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
oCatBean = new CategoriaBEAN();
oCatBean.IdCategoria = Convert.ToInt32(dr[0]);
oCatBean.NombCat = Convert.ToString(dr[1]);
listaCat.Add(oCatBean);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(listaCat);
}
public CategoriaBEAN BuscarCatId(int id)
{
CategoriaBEAN oCat = new CategoriaBEAN();
try
{
using (var con = new SqlConnection(_StringConnection))
{
using (var cmd = new SqlCommand("SP_BuscarCatId", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idCat", id);
con.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.Read())
{
oCat = new CategoriaBEAN();
oCat.IdCategoria = Convert.ToInt32(dr[0]);
oCat.NombCat = Convert.ToString(dr[1]);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(oCat);
}//EDITAR
public CategoriaBEAN ActualizarCategoria(CategoriaBEAN oCat)
{
try
{
using (var con = new SqlConnection(_StringConnection))
{
using (var cmd = new SqlCommand("SP_Update_Categoria", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idCat", oCat.IdCategoria);
cmd.Parameters.AddWithValue("@nomCat", oCat.NombCat);
con.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(oCat);
}
public List <CategoriaBEAN> RegistrarCat(CategoriaBEAN oCatBEAN)
{
List <CategoriaBEAN> lista = new List <CategoriaBEAN>();
try
{
using (var con = new SqlConnection(_StringConnection))
{
using (var cmd = new SqlCommand("sp_InsertCategoria", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@nombreCat", oCatBEAN.NombCat);
con.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lista);
}