public async Task <HealthCheckResult> CheckHealthAsync(HealthCheckContext context, CancellationToken ct) { using TransactionScope tran = Tran.BeginScope(IsolationLevel.ReadUncommitted); using SqlConnection connection = _dbContextFactory.CreateConnection(); await connection.OpenAsync(ct); SqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "select top(1) MigrationId from Tds.__EFMigrationsHistory order by MigrationId desc"; object lastMigration = await cmd.ExecuteScalarAsync(ct); cmd.CommandText = "select count(*) from Tds.__EFMigrationsHistory"; object count = await cmd.ExecuteScalarAsync(ct); return(HealthCheckResult.Healthy( CompareMigrationHistoryToAssembly(lastMigration.ToString(), int.Parse(count.ToString() !)))); }
async Task <ICollection <State> > IStateService.GetStatesAsync() { try { List <State> list = new List <State>(); using (MySqlConnection con = _dbContextFactory.CreateConnection()) { await con.OpenAsync(); using (MySqlCommand cmd = new MySqlCommand("select s.* from State s", con)) { using (var reader = await cmd.ExecuteReaderAsync()) { while (reader.Read()) { list.Add(new State() { state_id = Convert.ToInt32(reader["state_id"]), countryCode = reader["countryCode"].ToString(), name_id = Convert.ToInt32(reader["name_id"]), stateCode = reader["stateCode"].ToString(), latitude = Convert.ToDecimal(reader["latitude"]), longitude = Convert.ToDecimal(reader["longitude"]), polygon = reader["polygon"].ToString() }); } } } await con.CloseAsync(); } return(list); } catch (Exception e) { throw new Exception(e.Message); } }
public async Task <ICollection <GeoTableView> > GetGeoTableViewAsync() { try { List <GeoTableView> list = new List <GeoTableView>(); using (MySqlConnection con = _dbContextFactory.CreateConnection()) { await con.OpenAsync(); using (MySqlCommand cmd = new MySqlCommand("select g.* from GeoTableView g", con)) { using (var reader = await cmd.ExecuteReaderAsync()) { while (reader.Read()) { list.Add(new GeoTableView() { Id = Convert.ToInt32(reader["Id"]), WardId = Convert.ToInt32(reader["WardId"]), Ward = reader["Ward"].ToString(), DistrictId = Convert.ToInt32(reader["DistrictId"]), District = reader["District"].ToString(), CityId = Convert.ToInt32(reader["CityId"]), City = reader["City"].ToString() }); } } } await con.CloseAsync(); } return(list); } catch (Exception e) { throw new Exception(e.Message); } }