public int Registrar_Categoria(categoriaEntitis categoria) { try { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[dbo].[SP_SET_CATEGORIA]"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@idCat", categoria.idcategoria)); cmd.Parameters.Add(new SqlParameter("@nom", categoria.nombre)); cmd.Parameters.Add(new SqlParameter("@Desc", categoria.descripcion)); cmd.ExecuteNonQuery(); return(1); } } } catch (Exception) { return(0); } }
public DataTable BuscarCategoria(categoriaEntitis categoria) { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[dbo].[SP_GET_CATEGORIA_BUSCAR]"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@nombre", categoria.nombre); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public void Registrar_Categoria(categoriaEntitis categoria) { _metodos.Registrar_Categoria(categoria); }
public LogicaCategoria() { this._categoria = new categoriaEntitis(); }