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)); } }