public CompCab(CompCab obj)
{
PropertyInfo[] p = obj.GetType().GetProperties(); // get entity properties
for (int i = 0; i < (p.Length); i++)
{
if (!p[i].PropertyType.Name.Contains("list") && !p[i].Name.Contains("arg"))
p[i].SetValue(this, p[i].GetValue(obj, null), null); // set entity's property values to obj properties
}
}
// procedure fetches cable list
private void FetchCableList(int id, IDBManager dbmgr)
{
string qryString = "SELECT * FROM viewCOMPCAB cc WHERE cc.COMP_ID = @comp_id ORDER BY cc.CABLE";
CompCab item = new CompCab();
ArrayList list = new ArrayList();
PropertyInfo[] p = item.GetType().GetProperties(); // get property info for item
dbmgr.CreateParameters(1); // create required parameters
dbmgr.AddParameters(0, "@comp_id", id); // component id
dbmgr.ExecuteReader(CommandType.Text, qryString); // execute query
while (dbmgr.DataReader.Read())
{
item = new CompCab(); // create new item
item = (CompCab)FetchObject(item, p, dbmgr);
list.Add(item); // add item to ArrayList
}
dbmgr.CloseReader();
_comp.cablelist = list; // update object item list
}
private void FetchComponentList(int id, IDBManager dbmgr)
{
string qryString = "SELECT * FROM viewCOMPCAB cc WHERE cc.CABLE_ID = @cable_id ORDER BY cc.COMP";
CompCab item = new CompCab(); //create new object type to be able to get property info
ArrayList list = new ArrayList(); //create new ArrayList to house objects
try
{
PropertyInfo[] p = item.GetType().GetProperties(); //get property info for item
dbmgr.Open(); //open database manager
dbmgr.CreateParameters(1); //create parameters
dbmgr.AddParameters(0, "@cable_id", id); //cable id
dbmgr.ExecuteReader(CommandType.Text, qryString); //execute query
while (dbmgr.DataReader.Read())
{
item = new CompCab(); //create new item
item = (CompCab)FetchObject(item, p, dbmgr);
list.Add(item); //add item to the ArrayList
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbmgr.Dispose();
}
_cable.componentlist = list; //update item list
}
private void FetchCableBlock(int id, IDBManager dbmgr)
{
string qryString = "SELECT cc.COMP_ID, cc.COMP, cc.COMP_SSD_REQ, cc.COMP_PRA_REQ, cc.COMP_NPO_REQ," +
"cc.CABLE_ID, cc.CABLE, cc.SSD_REQ, cc.PRA_REQ, cc.NPO_REQ, dbo.GET_CAB_LOCATION(cc.CABLE_ID) AS CABLE_LOCA, " +
"cc.FR_EQUIP_ID, cc.FR_EQUIP, c.FR_EQUIP_BD, dbo.GET_LOCATION(cc.FR_EQUIP) AS FR_LOCA, " +
"cc.TO_EQUIP_ID, cc.TO_EQUIP, c.TO_EQUIP_BD, dbo.GET_LOCATION(cc.TO_EQUIP) AS TO_LOCA " +
"FROM viewCOMPCAB cc " +
"INNER JOIN CABLIST c ON c.CABLE_ID = cc.CABLE_ID " +
"WHERE cc.COMP_ID = @comp_id " +
"ORDER BY cc.COMP, cc.CABLE ";
CompCab item = new CompCab();
ArrayList list = new ArrayList();
PropertyInfo[] p = item.GetType().GetProperties();
dbmgr.CreateParameters(1);
dbmgr.AddParameters(0, "@comp_id", id);
dbmgr.ExecuteReader(CommandType.Text, qryString);
while (dbmgr.DataReader.Read())
{
item = new CompCab();
item = (CompCab)FetchObject(item, p, dbmgr);
list.Add(item);
}
dbmgr.CloseReader();
_cabBlock.cablelist = list;
}
