public List <M_NodeInReservation> GetNodesInReservations()
{
var entities = new List <M_NodeInReservation>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_M_NodesInReservation_Repository_GetNodesInReservations, null)) {
while (rdr.Read())
{
var entity = new M_NodeInReservation();
entity.ReservationId = SqlTypeConverter.DBNullStringHandler(rdr["ReservationId"]);
entity.NodeId = SqlTypeConverter.DBNullStringHandler(rdr["NodeId"]);
entity.NodeType = SqlTypeConverter.DBNullEnmSSHHandler(rdr["NodeType"]);
entities.Add(entity);
}
}
return(entities);
}
public List <M_NodeInReservation> GetNodesInReservationsInReservation(string id)
{
SqlParameter[] parms = { new SqlParameter("@ReservationId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
var entities = new List <M_NodeInReservation>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_M_NodesInReservation_Repository_GetNodesInReservationsInReservation, parms)) {
while (rdr.Read())
{
var entity = new M_NodeInReservation();
entity.ReservationId = SqlTypeConverter.DBNullStringHandler(rdr["ReservationId"]);
entity.NodeId = SqlTypeConverter.DBNullStringHandler(rdr["NodeId"]);
entity.NodeType = SqlTypeConverter.DBNullEnmSSHHandler(rdr["NodeType"]);
entities.Add(entity);
}
}
return(entities);
}
