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)); } }