public static bool AddRegistration(Registration registration) { SqlConnection connection = TechSupportDB.GetConnection(); string insertStatement = "INSERT Registrations " + "(CustomerID, ProductCode, RegistrationDate) " + "VALUES (@CustomerID, @ProductCode, @RegistrationDate)"; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.Parameters.AddWithValue( "@CustomerID", registration.CustomerID); insertCommand.Parameters.AddWithValue( "@ProductCode", registration.ProductCode); insertCommand.Parameters.AddWithValue( "@RegistrationDate", registration.RegistrationDate); try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }