public object Fetch(object obj) { int id; id = ((FireRoom)obj).rm_id; // initialize _fireroom = new FireRoom(); _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; try { _dbmgr.Open(); // fetch object information FetchFireRoom(id, _dbmgr); FetchComponentList(id, _dbmgr); FetchCableList(id, _dbmgr); FetchRouteList(id, _dbmgr); } catch (Exception ex) { throw ex; } finally { _dbmgr.Dispose(); } return _fireroom; }
// procedure fetches fire zone information private void FetchFireRoom(int id, IDBManager dbmgr) { string qryString = "SELECT * FROM viewFRLIST WHERE RM_ID=@id"; dbmgr.CreateParameters(1); dbmgr.AddParameters(0, "@id", id); dbmgr.ExecuteReader(CommandType.Text, qryString); if (dbmgr.DataReader.Read()) { // get properties of object and fetch object PropertyInfo[] p = _fireroom.GetType().GetProperties(); _fireroom = (FireRoom)FetchObject(_fireroom, p, dbmgr); } dbmgr.CloseReader(); }