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