/// <summary>
/// Method to get all the reservation nodes information
/// </summary>
public List <NodeInReservationInfo> GetReservationNodes(string id)
{
SqlParameter[] parms = { new SqlParameter("@ReservationId", SqlDbType.VarChar, 100) };
parms[0].Value = id;
var entities = new List <NodeInReservationInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_LSC_GETRESERVATIONODES, parms)) {
while (rdr.Read())
{
var entity = new NodeInReservationInfo {
ReservationId = ComUtility.DBNullStringHandler(rdr["ReservationId"]),
NodeId = ComUtility.DBNullStringHandler(rdr["NodeId"]),
NodeType = ComUtility.DBNullResNodeHandler(rdr["NodeType"])
};
entities.Add(entity);
}
}
return(entities);
}