/// <inheritdoc /> public bool CreateProduct(Products product) { using (var connection = new SqlConnection(ConnString)) { var command = new SqlCommand("addProduct", connection) { CommandType = CommandType.StoredProcedure }; command.Parameters.Add(ParamHelper.CreateParameter("pProductNumber", SqlDbType.Int, ParameterDirection.Input, product.ProductNumber)); command.Parameters.Add(ParamHelper.CreateParameter("pTitle", SqlDbType.NVarChar, ParameterDirection.Input, product.Title)); command.Parameters.Add(ParamHelper.CreateParameter("pPrice", SqlDbType.Decimal, ParameterDirection.Input, product.Price)); try { connection.Open(); command.ExecuteNonQuery(); return(true); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } } }