public async Task <Result <RoomieData> > FindRoomieByEmail(string email)
{
using (SqlConnection con = new SqlConnection(_connectionString))
{
RoomieData r = await con.QueryFirstOrDefaultAsync <RoomieData>(
@"SELECT * FROM rm2.vRoomie u WHERE u.Email = @Email;",
new { Email = email }
);
if (r == null)
{
return(Result.Failure <RoomieData>(Status.NotFound, "Roomie was not found."));
}
return(Result.Success(Status.Ok, r));
}
}
public async Task <Result <RoomieData> > FindById(int roomieId)
{
using (var con = new SqlConnection(_connectionString))
{
RoomieData r = await con.QueryFirstOrDefaultAsync <RoomieData>(
@"SELECT * FROM rm2.tRoomie r WHERE r.RoomieId = @RoomieId;",
new { RoomieId = roomieId }
);
if (r == null)
{
return(Result.Failure <RoomieData>(Status.NotFound, "Roomie was not found."));
}
return(Result.Success(Status.Ok, r));
}
}
