public bool InsertarProducto(ProductoBe productoBe) { _cnx.ConnectionString = _miConexion.GetCnx(); _cmd.Connection = _cnx; _cmd.CommandType = CommandType.StoredProcedure; _cmd.CommandText = "SP_InsertProducto"; try { _cmd.Parameters.Add(new SqlParameter("@Nom_pro", SqlDbType.VarChar, 30)); _cmd.Parameters["@Nom_pro"].Value = productoBe.NomPro; _cmd.Parameters.Add(new SqlParameter("@Det_pro", SqlDbType.VarChar, 50)); _cmd.Parameters["@Det_pro"].Value = productoBe.DetPro; _cnx.Open(); _cmd.ExecuteNonQuery(); _vexito = true; } catch (SqlException) { _vexito = false; } finally { if (_cnx.State == ConnectionState.Open) { _cnx.Close(); } _cmd.Parameters.Clear(); } return _vexito; }
public bool InsertarProducto(ProductoBe prodBe) { return _productoBl.InsertarProducto(prodBe); }