public async Task <IHttpActionResult> DeleteStation(int stationId)
{
string token = Request.Headers.GetValues("Authorization").FirstOrDefault();
int userId = JwtHelper.Instance.GetUserId(token);
IStationDao stationDao = AdoFactory.Instance.GetStationDao("wetr");
IEnumerable <Station> stations = await stationDao.FindByUserIdAsync(userId);
if (stations.Where(s => s.StationId == stationId).Count() == 0)
{
/* No station found so it might have been already deleted. */
return(Content(HttpStatusCode.Forbidden, new object()));
}
IMeasurementDao measurementDao = AdoFactory.Instance.GetMeasurementDao("wetr");
if ((await measurementDao.FindByStationIdAsync(stationId)).Count() > 0)
{
/* There must not be any measurmenets associated with this station. */
return(Content(HttpStatusCode.Forbidden, new object()));
}
await stationDao.DeleteAsync(stationId);
return(Content(HttpStatusCode.OK, new object()));
}
public static async Task ClassCleanupAsync()
{
foreach (var m in measurements)
{
await measurementDao.DeleteAsync(m.MeasurementId);
}
await unitDao.DeleteAsync(34);
await measurementTypeDao.DeleteAsync(43);
await stationDao.DeleteAsync(32);
await stationTypeDao.DeleteAsync(83);
await addressDao.DeleteAsync(93);
await communityDao.DeleteAsync(74);
await districtDao.DeleteAsync(54);
await provinceDao.DeleteAsync(66);
await countryDao.DeleteAsync(33);
await userDao.DeleteAsync(23);
}
public static async Task ClassCleanupAsync()
{
await stationDao.DeleteAsync(1);
await stationTypeDao.DeleteAsync(1);
await addressDao.DeleteAsync(6);
await communityDao.DeleteAsync(6);
await districtDao.DeleteAsync(6);
await provinceDao.DeleteAsync(6);
await countryDao.DeleteAsync(9);
await userDao.DeleteAsync(1);
}
public async Task <bool> DeleteStation(Station station)
{
try
{
return(await stationDao.DeleteAsync(station.StationId));
}
catch (Common.Dal.Ado.MySqlException ex)
{
throw new BusinessSqlException(ex.Message, ex.InnerException);
}
}