public IActionResult CreateTenant(TenantsDTO newTenant)
{
newTenant.Dob = DateTime.Today;
var addNewTenant = _repo.AddTenants(newTenant);
return(Ok(addNewTenant));
}
public IEnumerable <Tenant> AddTenants(TenantsDTO newTenant)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"INSERT INTO [Tenants]
([FName]
,[LName]
,[Phone]
,[Street]
,[City]
,[State]
,[Zip]
,[Email]
,[DOB]
,[Notes]
,[IsActive]
)
output inserted.*
VALUES
(@FName
,@LName
,@Phone
,@Street
,@City
,@State
,@Zip
,@Email
,@DOB
,@Notes)
,@IsActive";
return(db.Query <Tenant>(sql, newTenant));
}
}
