public IActionResult CreateCustomerPersonal(AddCustomerPersonalInfoDTO newCustomerPersonalInfoDTO)
{
var newCustomerPersonalInfo = new CustomerPersonalInfo
{
Id = 1,
CustomerId = newCustomerPersonalInfoDTO.CustomerId,
FirstName = newCustomerPersonalInfoDTO.FirstName,
LastName = newCustomerPersonalInfoDTO.LastName,
CustomerEmail = newCustomerPersonalInfoDTO.CustomerEmail
};
var repo = new CustomerPersonalInfoRepository();
var customerPersonalInfoThatGotCreated = repo.AddNewCustomerPersonalInfo(newCustomerPersonalInfoDTO);
return(Created($"api/customerPersonalInfo/{customerPersonalInfoThatGotCreated.Id}", customerPersonalInfoThatGotCreated));
}
public CustomerPersonalInfo AddNewCustomerPersonalInfo(AddCustomerPersonalInfoDTO newCustomerPersonalInfo)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"INSERT INTO[dbo].[CustomerPersonalInfo]
([CustomerId]
,[FirstName]
,[LastName]
,[CustomerEmail])
output inserted.*
VALUES
(@customerId
, @firstName
, @lastName
, @customerEmail)";
return(db.QueryFirst <CustomerPersonalInfo>(sql, newCustomerPersonalInfo));
}
}
