public async Task <IEnumerable <Tenant> > GetAllTenantAsync(TenantQueryParams queryParams) { try { List <Tenant> lstTenant = new List <Tenant>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spGetAllTenants", con); cmd.CommandType = CommandType.StoredProcedure; if (!string.IsNullOrEmpty(queryParams.SearchText)) { cmd.Parameters.AddWithValue("@SearchText", queryParams.SearchText); } cmd.Parameters.AddWithValue("@PageNumber", queryParams.PageNumber); cmd.Parameters.AddWithValue("@PageSize", queryParams.PageSize); con.Open(); SqlDataReader reader = await cmd.ExecuteReaderAsync(); while (reader.Read()) { Tenant tenant = new Tenant(); tenant.TenantId = Convert.ToInt32(reader["TenantId"]); tenant.TenantName = reader["TenantName"].ToString(); tenant.WorkspaceName = reader["WorkspaceName"].ToString(); tenant.CreatedDate = reader.SafeGetDate("CreatedDate"); tenant.ModifiedDate = reader.SafeGetDate("ModifyDate"); tenant.TotalDataCount = reader.SafeGetInt("Total"); lstTenant.Add(tenant); } con.Close(); } return(lstTenant.OrderByDescending(x => x.CreatedDate)); } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> GetTenantsAsync([FromQuery] TenantQueryParams queryParams) { var tenants = await _objTenant.GetAllTenantAsync(queryParams); return(Ok(tenants)); }