public CabRoute(CabRoute 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 } }
private void FetchCableList(int id, IDBManager dbmgr) { string qryString = "SELECT * FROM viewCABROUTE_CHKD c WHERE c.NODE_ID = @node_id ORDER BY c.CABLE"; CabRoute item = new CabRoute(); // create new object type to be able to get property info ArrayList list = new ArrayList(); // create new ArrayList to house objects PropertyInfo[] p = item.GetType().GetProperties(); // get property info for item dbmgr.CreateParameters(1); // create parameters dbmgr.AddParameters(0, "@node_id", id); // node id dbmgr.ExecuteReader(CommandType.Text, qryString); // execute query while (dbmgr.DataReader.Read()) { item = new CabRoute(); // create new item item = (CabRoute)FetchObject(item, p, dbmgr); list.Add(item); // add item to the ArrayList } dbmgr.CloseReader(); _route.cablelist = list; // update item list }
private void FetchRouteList(int id, IDBManager dbmgr) { string qryString = "SELECT * FROM viewCABROUTE_PLANT cr WHERE cr.CABLE_ID = @cable_id ORDER BY cr.SEQ, cr.NODE"; CabRoute item = new CabRoute(); //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 CabRoute(); //create new item item = (CabRoute)FetchObject(item, p, dbmgr); list.Add(item); //add item to the ArrayList } } catch (Exception ex) { throw ex; } finally { dbmgr.Dispose(); } _cable.routelist = list; //update item list }
private void FetchCabRoutelist(int id, IDBManager dbmgr) { string qryString = "SELECT * FROM viewCABROUTE_COORD AS cr WHERE cr.PSBKRCAB_ID = @psbkrcab_id ORDER BY cr.SEQ, cr.NODE"; CabRoute item = new CabRoute(); ArrayList list = new ArrayList(); PropertyInfo[] p = item.GetType().GetProperties(); dbmgr.CreateParameters(1); dbmgr.AddParameters(0, "@psbkrcab_id", id); dbmgr.ExecuteReader(CommandType.Text, qryString); while (dbmgr.DataReader.Read()) { item = new CabRoute(); item = (CabRoute)FetchObject(item, p, dbmgr); list.Add(item); } dbmgr.CloseReader(); _power.cabroutelist = list; }