Example #1
0
 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();
        }