public async Task Put(int id, [FromBody] Domain.CustomerAggregate.Customer value)
{
var customer = Get(id);
if (customer != null)
{
await _customerRepository.Update(value);
}
}
public async Task Add(Domain.CustomerAggregate.Customer prod)
{
using (IDbConnection dbConnection = _dbProvider.Connection)
{
string sQuery = "INSERT INTO Customers (FirstName, LastName, Address, PhoneNumber, Email, Gender, Birthday)"
+ " VALUES(@FirstName, @LastName, @Address, @PhoneNumber, @Email, @Gender, @Birthday)";
dbConnection.Open();
await dbConnection.ExecuteAsync(sQuery, prod);
}
}
public async Task Update(Domain.CustomerAggregate.Customer prod)
{
using (IDbConnection dbConnection = _dbProvider.Connection)
{
// Address, PhoneNumber, Email, Gender, Birthday
string sQuery = "UPDATE Customers SET FirstName = @FirstName,"
+ " LastName = @LastName"
+ " Address = @Address"
+ " PhoneNumber = @PhoneNumber"
+ " Email = @Email"
+ " Gender = @Gender"
+ " Birthday = @Birthday"
+ " WHERE CustomerId = @CustomerId";
dbConnection.Open();
await dbConnection.QueryAsync(sQuery, prod);
}
}
public async Task Post([FromBody] Domain.CustomerAggregate.Customer value)
{
await _customerRepository.Add(value);
}