public async Task Update(WaterChange waterChange)
{
using (var connection = _connectionFactory.GetOpenConnection())
{
waterChange.RowVersion = await connection.QueryFirstAsync <byte[]>(UpdateQuery, waterChange);
}
}
public async Task <WaterChange> Get(int Id)
{
WaterChange waterChange = null;
using (var connection = _connectionFactory.GetOpenConnection())
{
waterChange = await connection.QueryFirstOrDefaultAsync <WaterChange>(GetQuery, new { Id });
}
return(waterChange);
}
public async Task Add(WaterChange waterChange)
{
using (var connection = _connectionFactory.GetOpenConnection())
{
var result = await connection.QueryFirstAsync(InsertQuery, waterChange);
waterChange.Id = result.Id;
waterChange.RowVersion = result.RowVersion;
}
}
public async Task <bool> WaterChange(DateTime date, string comment, decimal liters, long aquariumId, string userId)
{
var waterchange = new WaterChange()
{
ObservationTime = date,
Comment = comment,
NumberOfLiters = liters
};
return(await WaterChange(waterchange, aquariumId, userId));
}
public async Task <IHttpActionResult> WaterChange([FromBody] WaterChange waterChange, long id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var res = await AquariumService.WaterChange(waterChange, id, await GetCurrentId());
return(Ok(new
{
Success = res
}));
}
public async Task <bool> WaterChange(WaterChange waterChange, long aquariumId, string userId)
{
var aqua = await UnitOfWork.AquariumsRepository.GetEntityAsync(aquariumId);
if (aqua == null || aqua.OwnerId != userId)
{
return(false);
}
waterChange.OwnerId = userId;
waterChange.AquariumId = aquariumId;
var wCh = UnitOfWork.WaterChangesRepository.Add(waterChange);
UnitOfWork.Save();
return(true);
}
public IActionResult AlterWaterChange(int aquariumId, [FromBody] WaterChange waterChange)
{
try
{
_logger.LogInformation("POST /v1/Aquarium/{aquariumId}/Water/Change called");
var aq = _aquariumService.GetAquariumById(aquariumId);
var id = _accountService.GetCurrentUserId();
if (!_accountService.CanModify(id, aq))
{
return(new UnauthorizedResult());
}
waterChange.AquariumId = aquariumId;
waterChange = _aquariumService.UpdateWaterChange(waterChange);
return(new OkObjectResult(waterChange));
}
catch (Exception ex)
{
_logger.LogError($"POST /v1/Aquarium/{aquariumId}/Water/Change endpoint caught exception: { ex.Message } Details: { ex.ToString() }");
return(NotFound());
}
}
public void Put(int id, [FromBody] WaterChange value)
{
var waterChange = service.Put <WaterChangeValidator>(value);
}
public void Post([FromBody] WaterChange value)
{
var waterChange = service.Post <WaterChangeValidator>(value);
}
public WaterChange UpdateWaterChange(WaterChange waterChange)
{
return(_aquariumDao.UpdateWaterChange(waterChange));
}
public WaterChange AddWaterChange(WaterChange waterChange)
{
return(_aquariumDao.AddWaterChange(waterChange));
}
