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();
}
