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