public async Task <IActionResult> Post([FromBody] PostLandlord landlord)
{
var id = await repository.Insert(landlord);
if (id == 0)
{
return(BadRequest("post request failed"));
}
return(Ok(id));
}
public async Task <int> Insert(PostLandlord landlord)
{
try
{
using (IDbConnection dbConnection = db)
{
string insertQuery = "INSERT INTO dbo.Landlords (Forename, Surname, Phone, Email)" +
"VALUES(@Forename, @Surname, @Phone, @Email);" +
"SELECT CAST(SCOPE_IDENTITY() AS int)";
dbConnection.Open();
var idCollection = await dbConnection.QueryAsync <int>(insertQuery, landlord);
return(idCollection.FirstOrDefault());
}
}
catch
{
return(0);
}
}
