public FireArea(FireArea 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 UpdateStatus(IDBManager dbmgr, FireArea 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, "@fa_id", item.fa_id); dbmgr.AddParameters(1, "@statustype_id", statustype_id); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.FASTATUS_d"); } else { // update status dbmgr.CreateParameters(4); dbmgr.AddParameters(0, "@fa_id", item.fa_id); dbmgr.AddParameters(1, "@statustype_id", statustype_id); dbmgr.AddParameters(2, "@user_id", user_id); if (status_date == Convert.ToDateTime(null)) // set date to null dbmgr.AddParameters(3, "@status_date", null); else // update date dbmgr.AddParameters(3, "@status_date", status_date); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.FASTATUS_u"); } }
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; }
private void FetchFireArea(int id, IDBManager dbmgr) { string qryLocal = "SELECT * FROM viewFALIST WHERE FA_ID=@id ORDER BY FA"; dbmgr.CreateParameters(1); dbmgr.AddParameters(0, "@id", id); dbmgr.ExecuteReader(CommandType.Text, qryLocal); if (dbmgr.DataReader.Read()) { PropertyInfo[] p = _firearea.GetType().GetProperties(); _firearea = (FireArea)FetchObject(_firearea, p, dbmgr); } dbmgr.CloseReader(); }