public static void AddUserFish(UserFish userFish)
{
using (var con = GetUserDbConnection())
{
con.InsertOrReplace(userFish);
}
}
public static async Task AddUserFish(UserFish userFish)
{
var con = await GetUserDbConnection();
await con.InsertOrReplaceAsync(userFish);
await con.CloseAsync();
}
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken)
{
var fish = new Fish
{
Id = request.Id,
FisherId = request.FisherId,
GuideId = request.GuideId,
OrganizationId = request.OrganizationId,
FishTypeId = request.FishTypeId,
ExceptionalCatch = request.ExceptionalCatch,
UnusualCatch = request.UnusualCatch,
Latitude = request.Latitude,
Longitude = request.Longitude,
SkyTypeId = request.SkyTypeId,
WindTypeId = request.WindTypeId,
WaterTypeId = request.WaterTypeId,
MoonPhase = request.MoonPhase,
MoonIlluminationPercent = request.MoonIlluminationPercent,
AirTemperature = request.AirTemperature,
WaterTemperature = request.WaterTemperature,
CaughtDate = request.CaughtDate,
LastModifiedDate = request.LastModifiedDate
};
_context.FishCaught.Add(fish);
//get a user object for the current logged in user
var user = await _context.Users.SingleOrDefaultAsync(x =>
x.UserName == _userAccessor.GetCurrentUsername());
//object for the person who liked the post? maybe
var liker = new UserFish
{
AppUser = user,
Fish = fish,
Liked = true
};
//add the "liker" to our UserFishCaught
_context.UserFishCaught.Add(liker);
//if _context.SaveChangesAsync returns something greater than zero
//that means the fish was succesfully added.
var success = await _context.SaveChangesAsync() > 0;
if (success)
{
return(Unit.Value);
}
//if request is unsuccessfull, we will throw an exception
throw new Exception("Problem saving changes");
}
