public static int AddCustomerResults(int id, int customerId, string firstName, string lastName, string cardResult)
{
CustomerResultsModel data = new CustomerResultsModel
{
Id = id,
CustomerId = customerId,
FirstName = firstName,
LastName = lastName,
CardResult = cardResult
};
string sql = @"INSERT into dbo.CustomerVisit (Id, CustomerId, FirstName, LastName, CardResult)
values (@Id, @CustomerId, @FirstName, @LastName, @CardResult);";
return(SqlDataAccess.Add(sql, data));
}