public string GetReservationNumberFromDB(DateTime checkInDate, DateTime checkOutDate, int roomId)
{
List <ParmStruct> parms = new List <ParmStruct>();
parms.Add(new ParmStruct("@CheckInDate", SqlDbType.Date, 0, checkInDate, ParameterDirection.Input));
parms.Add(new ParmStruct("@CheckOutDate", SqlDbType.Date, 0, checkOutDate, ParameterDirection.Input));
parms.Add(new ParmStruct("@RoomId", SqlDbType.Int, 0, roomId, ParameterDirection.Input));
return(db.GetValue("spGetReservationNumber", parms).ToString());
}