// 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(); } }
private void FetchComponent(int id, IDBManager dbmgr) { string qryLocal = "SELECT * FROM viewCOMPLIST WHERE COMP_ID=@id"; dbmgr.CreateParameters(1); // create required parameters dbmgr.AddParameters(0, "@id", id); dbmgr.ExecuteReader(CommandType.Text, qryLocal); // execute reader if (dbmgr.DataReader.Read()) { // get properties of object and fetch object PropertyInfo[] p = _comp.GetType().GetProperties(); _comp = (Component)FetchObject(_comp, p, dbmgr); } dbmgr.CloseReader(); }
public Component(Component oldobj) { PropertyInfo[] p = oldobj.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(oldobj, null), null); // set entity's property values to obj properties } }
// 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(); } }
private void UpdateStatus(IDBManager dbmgr, Component item, int statustype_id, string user_id, DateTime status_date) { if ((user_id == "N/A") || (user_id == "")) { // delete status dbmgr.CreateParameters(2); dbmgr.AddParameters(0, "@comp_id", item.comp_id); dbmgr.AddParameters(1, "@statustype_id", statustype_id); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.COMPSTATUS_d"); } else { if (status_date == Convert.ToDateTime(null)) { // update status dbmgr.CreateParameters(3); dbmgr.AddParameters(0, "@comp_id", item.comp_id); dbmgr.AddParameters(1, "@statustype_id", statustype_id); dbmgr.AddParameters(2, "@user_id", user_id); } else { // update status dbmgr.CreateParameters(4); dbmgr.AddParameters(0, "@comp_id", item.comp_id); dbmgr.AddParameters(1, "@statustype_id", statustype_id); dbmgr.AddParameters(2, "@user_id", user_id); dbmgr.AddParameters(3, "@status_date", status_date); } dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.COMPSTATUS_u"); } }
private void UpdateMasterDrawing(IDBManager dbmgr, Component item, int dwg_id, string dwg_ref, string dwg_rev, string dwg_cp, int dwg_type) { // if drawing ref is empty or N/A then delete if (dwg_ref == "") { dbmgr.CreateParameters(3); dbmgr.BeginTransaction(); dbmgr.AddParameters(0, "@comp_id", item.comp_id); dbmgr.AddParameters(1, "@dwg_id", dwg_id); dbmgr.AddParameters(2, "@dwgtype_id", dwg_type); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.COMPDWGS_d"); } // otherwise update else { // add updated/new dbmgr.CreateParameters(5); dbmgr.AddParameters(0, "@comp_id", item.comp_id); dbmgr.AddParameters(1, "@dwg_id", dwg_id); dbmgr.AddParameters(2, "@dwgtype_id", dwg_type); dbmgr.AddParameters(3, "@dwg_rev", dwg_rev); dbmgr.AddParameters(4, "@dwg_cp", dwg_cp); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.COMPDWGS_MASTER_u"); } }