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