public static Product ReturnItem(Product product) { try { SqlConnection connect = RetaloDB.GetConnection(); string selectStatement = "Select *" + "FROM Products" + " Where ProdID = @id"; SqlCommand selectCommand = new SqlCommand(selectStatement, connect); selectCommand.Parameters.AddWithValue("@id", product.ID); Product product2 = ProductOperations.ReturnProduct(selectCommand, connect); return(product2); } catch (Exception ex) { throw ex; } }
public static Boolean AddorUpdateItem(Product product) { try { if (ReturnItem(product) == null) { return(ProductOperations.AddProduct(product)); } else { return(ProductOperations.UpdateProduct(product.ID, product)); } } catch (Exception ex) { return(false); throw ex; } }