public bool InsertCustomer(Customer ourCustomer)
{
int rowsAffected = this._db.Execute(@"INSERT Customer([CustomerFirstName],[CustomerLastName],[IsActive]) values (@CustomerFirstName, @CustomerLastName, @IsActive)",
new { CustomerFirstName = ourCustomer.CustomerFirstName, CustomerLastName = ourCustomer.CustomerLastName, IsActive = true });
if (rowsAffected > 0)
{
return true;
}
return false;
}
public bool UpdateCustomer(Customer ourCustomer)
{
int rowsAffected = this._db.Execute(
"UPDATE [Customer] SET [CustomerFirstName] = @CustomerFirstName ,[CustomerLastName] = @CustomerLastName, [IsActive] = @IsActive WHERE CustomerID = " +
ourCustomer.CustomerID, ourCustomer);
if (rowsAffected > 0)
{
return true;
}
return false;
}