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