public static List <CassandraRoom> ToCassandraRoom(this RowSet rows)
{
List <CassandraRoom> result = new List <CassandraRoom>();
string whichQuery = rows.Columns.First().Table;
foreach (var row in rows)
{
float cost = whichQuery.Equals("toclean") ? float.NaN : row.GetValue <float>("cost");
string guestFullName = whichQuery.Equals("byhotel") ? row.GetValue <string>("guestfullname") : String.Empty;
int guestId = whichQuery.Equals("byhotel") ? row.GetValue <int>("guestid") : 0;
CassandraRoom cr = new CassandraRoom()
{
Hotel = row.GetValue <string>("hotel"),
Floor = row.GetValue <int>("floor"),
RoomNumber = row.GetValue <int>("roomnumber"),
Cost = cost,
GuestFullName = guestFullName,
GuestId = guestId,
HotelId = row.GetValue <int>("hotelid"),
RoomId = row.GetValue <int>("roomid")
};
result.Add(cr);
}
return(result);
}
public ActionResult <CassandraRoom> GetUnoccupiedCheapest([FromBody] Hotel hotel)
{
CassandraRoom result = RoomQuery.ToOccupyCheapest(hotel);
return(result);
}
