public void Delete(object obj)
{
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
DeleteDisposition(obj, _dbmgr);
}
public void Delete(object obj)
{
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
string type = obj.GetType().ToString();
switch (type)
{
case "FRIAS.Common.Entity.FireArea":
DeleteFireArea(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.FACompDisp":
DeleteCompDisp(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.FACabDisp":
DeleteCabDisp(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.FAVFDR":
DeleteVFDR(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.FADOC":
DeleteDocument(obj, _dbmgr);
break;
}
}
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;
}
public object Fetch(object obj)
{
int id;
string type; //type of object passed
string objtype = obj.GetType().ToString(); //get object type
if (objtype == "System.String")
{
string[] strTemp = ((string)obj).Split(new char[] { '|' }); //if the object type is a string then extract the id and type
id = Convert.ToInt32(strTemp[0]);
type = strTemp[1];
}
else
{
id = ((Disposition)obj).disp_id;
type = "all"; //object is a cable and get all information
}
_disp = new Disposition(); //create new instance of object
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
switch (type)
{
case "facompcabdisp":
FetchFACompCabList(id, _dbmgr);
return _disp.facompcablist;
case "all":
FetchDisposition(id, _dbmgr);
FetchFACompCabList(id, _dbmgr);
return _disp;
}
return _disp;
}
public void Delete(object obj)
{
// get connection
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
string type = obj.GetType().ToString();
// delete from database
switch (type)
{
case "FRIAS.Common.Entity.FireZone":
DeleteFireZone(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.FZProtection":
DeleteProtection(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.FZIgnition":
DeleteIgnition(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.FZIgnitionImpact":
DeleteIgnitionImpact(obj, _dbmgr);
break;
}
}
// fetches object and object items
// user has option of passing object itself OR a string with id and type delimited by '|'
public object Fetch(object obj)
{
int id = ((CableBlock)obj).comp_id;
// create new object and database connection
_cabBlock = new CableBlock();
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
_dbmgr.Open();
FetchComponent(id, _dbmgr);
FetchCableBlock(id, _dbmgr);
FetchVertexList(id, _dbmgr);
return _cabBlock;
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
}
public ComponentManager()
{
loadAssembly();
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
}
// deletes given object or object item
public void Delete(object obj)
{
// create database connection
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
// determine type of object
string type = obj.GetType().ToString();
switch (type)
{
case "FRIAS.Common.Entity.Component":
DeleteComponent(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.CompDwg":
DeleteDrawing(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.Subcomp":
DeleteSubcomp(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.CompPwr":
DeletePower(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.CompIntlk":
DeleteInterlock(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.CompCab":
DeleteCable(obj, _dbmgr);
break;
}
}
public object Fetch(object obj)
{
int id;
string type; // type of object passed
string objtype = obj.GetType().ToString(); // get object type
if (objtype == "System.String")
{
string[] strTemp = ((string)obj).Split(new char[] { '|' }); // if the object type is a string then extract the id and type
id = Convert.ToInt32(strTemp[0]);
type = strTemp[1];
}
else
{
id = ((Route)obj).node_id;
type = "all"; // object is a cable and get all information
}
_route = new Route(); // create new instance of object
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
_dbmgr.Open();
switch (type)
{
case "routeloca":
FetchRoutelocaList(id, _dbmgr);
return _route.routelocalist;
case "routelocadwg":
FetchRoutelocaList(id, _dbmgr);
FetchDrawingList(_route.routelocalist, _dbmgr);
return _route.drawinglist;
case "bdendpoint":
FetchBDEndpointList(id, _dbmgr);
return _route.bdendpointlist;
case "cable":
FetchCableList(id, _dbmgr);
return _route.cablelist;
default:
FetchRoute(id, _dbmgr);
FetchRoutelocaList(id, _dbmgr);
FetchBDEndpointList(id, _dbmgr);
FetchDrawingList(_route.routelocalist, _dbmgr);
FetchCableList(id, _dbmgr);
return _route;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
}
public object Fetch(object obj)
{
int id;
string type; // type of object passed
string objtype = obj.GetType().ToString(); // get object type
if (objtype == "System.String")
{
string[] strTemp = ((string)obj).Split(new char[] { '|' }); // if object type is a string then extract the id and type
id = Convert.ToInt32(strTemp[0]);
type = strTemp[1];
}
else
{
id = ((Power)obj).power_id;
type = "all"; // object is drawing and get all information
}
_power = new Power();
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
_dbmgr.Open();
switch (type)
{
case "component":
FetchComponentList(id, _dbmgr);
return _power.componentlist;
case "psload":
FetchPSLoadList(id, _dbmgr);
return _power.psloadlist;
case "psbkrcab":
FetchPSBkrCabList(id, _dbmgr);
return _power.psbkrcablist;
case "cabroutelist":
FetchCabRoutelist(id, _dbmgr);
return _power.cabroutelist;
default:
FetchPower(id, _dbmgr);
FetchComponentList(id, _dbmgr);
FetchPSLoadList(id, _dbmgr);
return _power;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
}
// deletes given object or object item
public void Delete(object obj)
{
// create database connection
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
DeleteRA(obj, _dbmgr);
}
public void Delete(object obj)
{
// get connection
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
// delete from database
DeleteFireRoom(obj, _dbmgr);
}
// fetches object and object items
// user has option of passing object itself OR a string with id and type delimited by '|'
public object Fetch(object obj)
{
int id;
string type;
string objtype = obj.GetType().ToString();
if (objtype == "System.String")
{
string[] strTemp = ((string)obj).Split(new char[] { '|' });
id = Convert.ToInt32(strTemp[0]);
type = strTemp[1];
}
else
{
id = ((Component)obj).comp_id;
type = "all";
}
// create new object and database connection
_comp = new Component();
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
_dbmgr.Open();
// determine type
switch (type)
{
case "ra":
FetchRAList(id, _dbmgr);
return _comp.ralist;
default:
FetchComponent(id, _dbmgr);
FetchFACompDispList(id, _dbmgr);
FetchRAList(id, _dbmgr);
return _comp;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
}
public void Delete(object obj)
{
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
string type = obj.GetType().ToString();
switch (type)
{
case "FRIAS.Common.Entity.Drawing":
DeleteDrawing(obj, _dbmgr);
break;
}
}
public object Fetch(object obj)
{
int id;
string type; //type of object passed
string objtype = obj.GetType().ToString(); //get object type
if (objtype == "System.String")
{
string[] strTemp = ((string)obj).Split(new char[] { '|' }); //if the object type is a string then extract the id and type
id = Convert.ToInt32(strTemp[0]);
type = strTemp[1];
}
else
{
id = ((Document)obj).doc_id;
type = "all"; //object is document and get all information
}
_document = new Document();
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
_dbmgr.Open();
switch (type)
{
case "firearea":
FetchFAList(id, _dbmgr);
return _document.falist;
default:
FetchDocument(id, _dbmgr);
FetchFAList(id, _dbmgr);
return _document;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
}
public object Fetch(object obj)
{
int id;
string type; // type of object passed
string objtype = obj.GetType().ToString(); // get object type
if (objtype == "System.String")
{
string[] strTemp = ((string)obj).Split(new char[] { '|' }); // if the object type is a string then extract the id and type
id = Convert.ToInt32(strTemp[0]);
type = strTemp[1];
}
else
{
id = ((Cable)obj).cable_id;
type = "all"; // object is a cable and get all information
}
_cable = new Cable();
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
switch (type)
{
case "component":
FetchComponentList(id, _dbmgr);
return _cable.componentlist;
case "drawing":
FetchDrawingList(id, _dbmgr);
return _cable.drawinglist;
case "routechg":
FetchRoutechgList(id, _dbmgr);
return _cable.routechglist;
case "all":
FetchCable(id, _dbmgr);
FetchComponentList(id, _dbmgr);
FetchDrawingList(id, _dbmgr);
FetchRoutechgList(id, _dbmgr);
FetchRouteList(id, _dbmgr);
FetchCRDPowerList(id, _dbmgr);
return _cable;
}
return _cable;
}
// fetches user information
public object Fetch(object obj)
{
string type;
string objtype = obj.GetType().ToString();
if (objtype == "System.String")
type = "userlist";
else
type = "user";
_user = new User();
_dbmgr = new DBManager(DBHelper.getProvider(Config.getValue("DBStr", "")));
_dbmgr.ConnectionString = Config.getValue("DBStr", "");
try
{
_dbmgr.Open();
switch (type)
{
case "userlist":
FetchAccessList(_dbmgr);
return _accesslist;
default:
FetchUser(obj, _dbmgr);
//if (_user.initial != null)
// FetchPlantInfo(_user, _dbmgr);
return _user;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
}
public object Fetch(object obj)
{
int id;
string type;
// determine id and type
string objtype = obj.GetType().ToString();
if (objtype == "System.String")
{
string[] strTemp = ((string)obj).Split(new char[] { '|' });
id = Convert.ToInt32(strTemp[0]);
type = strTemp[1];
}
else
{
id = ((FireZone)obj).fz_id;
type = "all";
}
// initialize
_firezone = new FireZone();
_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
switch (type)
{
case "firezone":
FetchFireZone(id, _dbmgr);
return _firezone;
case "protection":
FetchProtectionList(id, _dbmgr);
return _firezone;
case "ignition":
FetchIgnitionList(id, _dbmgr);
return _firezone;
case "ignitionimpact":
// TODO: Need to pass ignition information
//FetchIgnitionImpactList(id, _dbmgr);
return _firezone;
case "all":
FetchFireZone(id, _dbmgr);
FetchComponentList(id, _dbmgr);
FetchCableList(id, _dbmgr);
FetchRouteList(id, _dbmgr);
FetchProtectionList(id, _dbmgr);
FetchIgnitionList(id, _dbmgr);
return _firezone;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
return _firezone;
}
// fetches user access list
private void FetchAccessList(IDBManager dbmgr)
{
string qryString = "SELECT * FROM USERLIST ORDER BY NAME";
User item = new User();
ArrayList list = new ArrayList();
PropertyInfo[] p = item.GetType().GetProperties();
dbmgr.ExecuteReader(CommandType.Text, qryString);
while (dbmgr.DataReader.Read())
{
item = new User();
item = (User)FetchObject(item, p, dbmgr);
list.Add(item);
}
dbmgr.CloseReader();
_accesslist = list;
}
public void Update(object obj)
{
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
string type = obj.GetType().ToString();
switch (type)
{
case "FRIAS.Common.Entity.Route":
UpdateRoute(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.Routeloca":
UpdateRouteloca(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.RoutelocaDwg":
UpdateDrawing(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.RouteBDEndpoint":
UpdateBDEndpoint(obj, _dbmgr);
break;
}
}
public DataSet FetchDataSet(string criteria)
{
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
DataSet ds = new DataSet();
string qryString;
switch (_user.plant)
{
case "BLN":
case "TFAC":
qryString = "SELECT * FROM viewROUTELIST_FR ORDER BY NODE";
break;
default:
qryString = "SELECT * FROM viewROUTELIST ORDER BY NODE";
break;
}
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
_dbmgr.Open();
ds = (DataSet)_dbmgr.ExecuteDataSet(CommandType.Text, qryString);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
return ds;
}
// locks sign-off controls based on prep_by, chkd_by and user intitials
public static void LockControls(Control control, string prep_by, string chkd_by, User user)
{
if (user.level != User.admin)
{
// if there is no prep_by user cannot enter chkd_by or chkd_date
// NOTE: if user enter prep_date w/ prep_by=N/A error message is given in the page
if (prep_by == "N/A")
{
((DropDownList)control.FindControl("chkd_by")).Enabled = false;
((TextBox)control.FindControl("chkd_date")).Enabled = false;
}
// if user is preparer, he cannot also be the checker
if (user.initial == prep_by)
{
((DropDownList)control.FindControl("chkd_by")).Enabled = false;
((TextBox)control.FindControl("chkd_date")).Enabled = false;
}
else
{
// otherwise if user is not preparer, and therefore should not be able to change prep_by or prep_date
if (prep_by != "N/A")
{
((DropDownList)control.FindControl("prep_by")).Enabled = false;
((TextBox)control.FindControl("prep_date")).Enabled = false;
}
}
// if user is not checker and there is already a checker, then he cannot change chkd_date
if ((user.initial != chkd_by) && (chkd_by != "N/A"))
((TextBox)control.FindControl("chkd_date")).Enabled = false;
}
}
public void Update(object obj)
{
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
string type = obj.GetType().ToString(); //get the type of object
switch (type) //update respective object
{
case "FRIAS.Common.Entity.Document":
UpdateDocument(obj, _dbmgr);
break;
}
}
// fetches user information
private void FetchUser(object obj, IDBManager dbmgr)
{
string qryLocal = "SELECT * FROM USERLIST WHERE NAME=@name";
_user = (User)obj;
dbmgr.CreateParameters(1);
dbmgr.AddParameters(0, "@name", _user.name);
dbmgr.ExecuteReader(CommandType.Text, qryLocal);
if (dbmgr.DataReader.Read())
{
// get properties of object and fetch object
PropertyInfo[] p = _user.GetType().GetProperties();
_user = (User)FetchObject(_user, p, dbmgr);
}
else
{
_user.initial = "";
_user.password = null;
}
dbmgr.CloseReader();
}
public ArrayList FetchComboList(string initMsg, string param)
{
string qryString = "SELECT DISTINCT CABLE_ID, CABLE FROM viewFADATA_SSD WHERE FA_ID = @fa_id AND COMP_ID = @comp_id ORDER BY CABLE";
ArrayList list = new ArrayList();
string[] strTemp = ((string)param).Split(new char[] { '|' });
int fa_id = Convert.ToInt32(strTemp[0]);
int comp_id = Convert.ToInt32(strTemp[1]);
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
// initialize
if (initMsg.Length > 0)
list.Add(new ComboBoxItem(initMsg, "0"));
_dbmgr.Open();
_dbmgr.CreateParameters(2);
_dbmgr.AddParameters(0, "@fa_id", fa_id);
_dbmgr.AddParameters(1, "@comp_id", comp_id);
_dbmgr.ExecuteReader(CommandType.Text, qryString);
while (_dbmgr.DataReader.Read() == true)
{
if (_dbmgr.DataReader.GetInt32(0) != 0)
list.Add(new ComboBoxItem(_dbmgr.DataReader.GetString(1), _dbmgr.DataReader.GetInt32(0).ToString())); ;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
return list;
}
/// <summary>
/// Fetches Dataset
/// </summary>
/// <param name="criteria">Prep_Only, Prep and Chkd, Show All</param>
/// <returns>Dataset</returns>
public DataSet FetchDataSet(string criteria)
{
DataSet ds = new DataSet();
string qryString;
switch (criteria)
{
case "Prep Only":
qryString = "SELECT * FROM viewCOMPLIST_LITE WHERE PREP_DATE IS NOT NULL AND CHKD_DATE IS NULL ORDER BY COMP";
break;
case "Prep and Chkd":
qryString = "SELECT * FROM viewCOMPLIST_LITE WHERE PREP_DATE IS NOT NULL AND CHKD_DATE IS NOT NULL ORDER BY COMP";
break;
case "Show All":
default:
qryString = "SELECT * FROM viewCOMPLIST_LITE ORDER BY COMP";
break;
}
// create database connection
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
_dbmgr.Open();
ds = (DataSet)_dbmgr.ExecuteDataSet(CommandType.Text, qryString);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
return ds;
}
public DataSet FetchDataSet(string criteria)
{
DataSet ds = new DataSet();
string qryString = "SELECT * FROM viewFALIST ORDER BY FA";
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
_dbmgr.Open();
ds = (DataSet)_dbmgr.ExecuteDataSet(CommandType.Text, qryString);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
return ds;
}
// fetches object and object items
// user has option of passing object itself OR a string with id and type delimited by '|'
public object Fetch(object obj)
{
int id = 0;
string name = "";
string type = "all";
string objtype = obj.GetType().ToString();
if (objtype == "System.String")
{
// if the object type is a string then extract the id and type
string[] strTemp = ((string)obj).Split(new char[] { '|' });
type = strTemp[1];
if (type == "pricomp")
name = strTemp[0];
else
id = Convert.ToInt32(strTemp[0]);
}
else
id = ((Component)obj).comp_id;
// create new object and database connection
_comp = new Component();
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
_dbmgr.Open();
// determine type
switch (type)
{
case "drawing":
FetchDrawingList(id, _dbmgr);
return _comp.drawinglist;
case "power":
FetchPowerList(id, _dbmgr);
return _comp.powerlist;
case "subcomp":
FetchSubcompList(id, _dbmgr);
return _comp.subcomplist;
case "pricomp":
FetchPriCompList(name, _dbmgr);
return _comp.pricomplist;
case "interlock":
FetchIncomingIntlkList(id, _dbmgr);
return _comp.incomingintlklist;
case "cable":
FetchCableList(id, _dbmgr);
return _comp.cablelist;
case "be":
FetchBEList(id, _dbmgr);
return _comp.belist;
default:
FetchComponent(id, _dbmgr);
FetchDrawingList(id, _dbmgr);
FetchSubcompList(id, _dbmgr);
FetchPowerList(id, _dbmgr);
FetchLoadList(id, _dbmgr);
FetchIncomingIntlkList(id, _dbmgr);
FetchOutgoingIntlkList(id, _dbmgr);
FetchCableList(id, _dbmgr);
return _comp;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
}
public object Fetch(object obj)
{
int fa_id;
int comp_id = 0;
string type; // type of object passed
string objtype = obj.GetType().ToString(); // get object type
if (objtype == "System.String")
{
string[] strTemp = ((string)obj).Split(new char[] { '|' }); // if the object type is a string then extract the id and type
fa_id = Convert.ToInt32(strTemp[0]);
type = strTemp[1];
comp_id = Convert.ToInt32(strTemp[2]);
}
else
{
fa_id = ((FireArea)obj).fa_id;
type = "all"; // object is a cable and get all information
}
_firearea = new FireArea();
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
try
{
_dbmgr.Open();
switch (type)
{
//case "facompdisp":
// FetchCompDispList(fa_id, _dbmgr);
// return _firearea.compdisplist;
case "facabdisp":
FetchCabDispList(fa_id, comp_id, _dbmgr);
break;
//return _firearea.cabdisplist;
case "facompinfo":
FetchCabDispList(fa_id, comp_id, _dbmgr);
break;
//return _firearea;
case "faB3Table":
FetchFireArea(fa_id, _dbmgr);
FetchVFDRList(fa_id, _dbmgr);
FetchPGList(fa_id, _dbmgr);
FetchGENdocList(fa_id, _dbmgr);
FetchEEdocList(fa_id, _dbmgr);
FetchLICdocList(fa_id, _dbmgr);
FetchIgnitionList(fa_id, _dbmgr);
FetchProtectionList(fa_id, _dbmgr);
break;
//return _firearea;
case "all":
FetchFireArea(fa_id, _dbmgr);
FetchCompDispList(fa_id, _dbmgr);
FetchCascPowerList("SSD", fa_id, _dbmgr);
FetchCascIntlkList("SSD", fa_id, _dbmgr);
break;
//return _firearea;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbmgr.Dispose();
}
return _firearea;
}
public void Update(object obj)
{
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
string type = obj.GetType().ToString();
switch (type)
{
case "FRIAS.Common.Entity.PSLoad":
UpdatePSLoad(obj, _dbmgr);
break;
case "FRIAS.Common.Entity.PSBkrCab":
UpdatePSBkrCab(obj, _dbmgr);
break;
case "System.Collections.ArrayList":
UpdateCabRoute(obj, _dbmgr);
break;
}
}
