public async Task <IHttpActionResult> GetMyStations()
{
string token = Request.Headers.GetValues("Authorization").FirstOrDefault();
int userId = JwtHelper.Instance.GetUserId(token);
IStationDao stationDao = AdoFactory.Instance.GetStationDao("wetr");
IAddressDao addressDao = AdoFactory.Instance.GetAddressDao("wetr");
ICommunityDao communitDao = AdoFactory.Instance.GetCommunityDao("wetr");
IDistrictDao districtDao = AdoFactory.Instance.GetDistrictDao("wetr");
IProvinceDao provinceDao = AdoFactory.Instance.GetProvinceDao("wetr");
ICountryDao countryDao = AdoFactory.Instance.GetCountryDao("wetr");
IEnumerable <Station> myStations = null;
myStations = await stationDao.FindByUserIdAsync(userId);
List <StationDTO> convertedStations = new List <StationDTO>();
/* Infer location ids for convenience */
foreach (var s in myStations)
{
StationDTO station = new StationDTO(s);
station.CommunityId = (await addressDao.FindByIdAsync(station.AddressId)).CommunityId;
station.DistrictId = (await communitDao.FindByIdAsync(station.CommunityId)).DistrictId;
station.ProvinceId = (await districtDao.FindByIdAsync(station.DistrictId)).ProvinceId;
station.CountryId = (await provinceDao.FindByIdAsync(station.ProvinceId)).CountryId;
station.Location = (await addressDao.FindByIdAsync(station.AddressId)).Location;
convertedStations.Add(station);
}
return(Content(HttpStatusCode.OK, convertedStations));
}
public async Task <IHttpActionResult> GetStation(int id)
{
IStationDao stationDao = AdoFactory.Instance.GetStationDao("wetr");
IAddressDao addressDao = AdoFactory.Instance.GetAddressDao("wetr");
ICommunityDao communitDao = AdoFactory.Instance.GetCommunityDao("wetr");
IDistrictDao districtDao = AdoFactory.Instance.GetDistrictDao("wetr");
IProvinceDao provinceDao = AdoFactory.Instance.GetProvinceDao("wetr");
ICountryDao countryDao = AdoFactory.Instance.GetCountryDao("wetr");
Station myStations = await stationDao.FindByIdAsync(id);
if (myStations == null)
{
return(Content(HttpStatusCode.BadRequest, new object()));
}
StationDTO station = new StationDTO(myStations);
station.CommunityId = (await addressDao.FindByIdAsync(station.AddressId)).CommunityId;
station.DistrictId = (await communitDao.FindByIdAsync(station.CommunityId)).DistrictId;
station.ProvinceId = (await districtDao.FindByIdAsync(station.DistrictId)).ProvinceId;
station.CountryId = (await provinceDao.FindByIdAsync(station.ProvinceId)).CountryId;
station.Location = (await addressDao.FindByIdAsync(station.AddressId)).Location;
return(Content(HttpStatusCode.OK, station));
}
public async override Task TestDeleteAsync()
{
using (var transaction = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
int addressId = 1;
Assert.IsTrue(await addressDao.DeleteAsync(addressId));
Address test = await addressDao.FindByIdAsync(addressId);
Assert.IsNull(test);
}
}
public async Task <IHttpActionResult> GetStations(int communityId)
{
IStationDao stationDao = AdoFactory.Instance.GetStationDao("wetr");
IAddressDao addressDao = AdoFactory.Instance.GetAddressDao("wetr");
ICommunityDao communitDao = AdoFactory.Instance.GetCommunityDao("wetr");
IDistrictDao districtDao = AdoFactory.Instance.GetDistrictDao("wetr");
IProvinceDao provinceDao = AdoFactory.Instance.GetProvinceDao("wetr");
ICountryDao countryDao = AdoFactory.Instance.GetCountryDao("wetr");
IEnumerable <Station> stations = null;
stations = await stationDao.FindAllAsync();
List <StationDTO> convertedStations = new List <StationDTO>();
/* Infer location ids for convenience */
foreach (var s in stations)
{
StationDTO station = new StationDTO(s);
station.CommunityId = (await addressDao.FindByIdAsync(station.AddressId)).CommunityId;
station.DistrictId = (await communitDao.FindByIdAsync(station.CommunityId)).DistrictId;
station.ProvinceId = (await districtDao.FindByIdAsync(station.DistrictId)).ProvinceId;
station.CountryId = (await provinceDao.FindByIdAsync(station.ProvinceId)).CountryId;
station.Location = (await addressDao.FindByIdAsync(station.AddressId)).Location;
convertedStations.Add(station);
}
if (communityId != 0)
{
convertedStations.RemoveAll(s => s.CommunityId != communityId);
}
return(Content(HttpStatusCode.OK, convertedStations));
}
public async Task <Country> GetCountryForAddressId(int addressId)
{
try
{
Address a = await addressDao.FindByIdAsync(addressId);
Community c = await communityDao.FindByIdAsync(a.CommunityId);
District d = await districtDao.FindByIdAsync(c.DistrictId);
Province p = await provinceDao.FindByIdAsync(d.ProvinceId);
return(await countryDao.FindByIdAsync(p.CountryId));
}
catch (Common.Dal.Ado.MySqlException ex)
{
throw new BusinessSqlException(ex.Message, ex.InnerException);
}
}