Esempio n. 1
0
        public static IList FetchHistory()
        {
            // initialize
            History item = new History();
            PropertyInfo[] p = item.GetType().GetProperties();
            List<History> list = new List<History>();

            string qryString = "SELECT * FROM HISTORY_LOG";

            User user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
            IDBManager dbmgr = new DBManager(user.plantDBStr);
            dbmgr.ConnectionString = user.plantDBStr;

            try
            {
                dbmgr.Open();
                dbmgr.ExecuteReader(CommandType.Text, qryString);

                while (dbmgr.DataReader.Read())
                {
                    item = new History();
                    item = (History)FetchObject(item, p, dbmgr);
                    list.Add(item);
                }
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                dbmgr.Dispose();
            }
            return list;
        }
Esempio n. 2
0
        // procedure saves object to history
        // definition of variables passed:
        //      obj         : current object
        //      old_obj     : old object prior to update
        //      table_chg   : name of table that was changed
        //      data_chg    : data that was changed
        //      key_field   : name of key_field (column) within table
        //                    (eg. changes in COMPLIST will have COMP as key_field, changes in CABLIST will have CABLE
        //      dbmgr       : database manager
        //      fieldlist   : list of fields that were involved
        //                    (this is needed because more fields may exisit for a given entity than was changed in webform)
        public void SaveHistory(Object obj, Object old_obj, string user_id, string table_chg, string data_chg, string key_field, IDBManager dbmgr, string[] fieldList)
        {
            History hist;                                                                   // create new entity
            ArrayList listChgs = new ArrayList();                                           // array to hold list of changes

            // determine type of change: addition, deletion or modification
            // and set values accordingly

            // ADDITION: if old_obj is null then user entering a new record
            if (old_obj == null)
            {
                hist = new History();                                                       // create new instance
                hist.field_chg = "RECORD ADDED";                                            // new record added
                hist.new_data = data_chg;
                hist.old_data = "";                                                         // old data is null
                hist.user_id = user_id;
                hist.table_chg = table_chg;
                hist.key_field = key_field;
                listChgs.Add(hist);                                                         // add to arraylist
            }

            // DELETION: if obj is null then user deleting a record
            else if (obj == null)
            {
                hist = new History();                                                       // create new instance
                hist.field_chg = "RECORD DELETED";                                          // record deleted
                hist.new_data = "";                                                         // new data is null
                hist.old_data = data_chg;
                hist.user_id = user_id;
                hist.table_chg = table_chg;
                hist.key_field = key_field;
                listChgs.Add(hist);                                                         // add to arraylist
            }

            // MODIFICATION: otherwise user is modifying an existing record
            else
            {
                PropertyInfo[] properties = obj.GetType().GetProperties();
                foreach (PropertyInfo info in properties)
                {
                    // initialize by setting new and old data to empty string
                    string new_data = "";
                    string old_data = "";

                    // properties that are *list or arg* are used base properties used only for application
                    // these will not exist in table therefore screen for these
                    if (!info.PropertyType.Name.Contains("list") && !info.Name.Contains("arg"))
                    {
                        // check to see if control for given name
                        if (ControlExists(info.Name, fieldList))
                        {
                            if (info.GetValue(old_obj, null) != null)
                                old_data = info.GetValue(old_obj, null).ToString();
                            if (info.GetValue(obj, null) != null)
                                new_data = info.GetValue(obj, null).ToString();

                            // if the new and old data are not equal to one another
                            if (!new_data.Equals(old_data))
                            {
                                hist = new History();                                       // create new instance
                                hist.new_data = new_data;
                                hist.old_data = old_data;
                                hist.field_chg = info.Name.ToUpper();                       // set field changed (convert to upper case)
                                hist.user_id = user_id;
                                hist.table_chg = table_chg;
                                hist.key_field = key_field;
                                listChgs.Add(hist);                                         // add to arraylist
                            }
                        }
                    }
                }
            }

            // update HISTORY_LOG table as long as there is changes
            if (listChgs.Count > 0)
            {
                foreach (History h in listChgs)
                {
                    try
                    {
                        dbmgr.CreateParameters(6);
                        dbmgr.AddParameters(0, "@user_id", h.user_id);
                        dbmgr.AddParameters(1, "@field_chg", h.field_chg);
                        dbmgr.AddParameters(2, "@new_data", h.new_data);
                        dbmgr.AddParameters(3, "@old_data", h.old_data);
                        dbmgr.AddParameters(4, "@table_chg", h.table_chg);
                        dbmgr.AddParameters(5, "@key_field", h.key_field);
                        dbmgr.ExecuteNonQuery(System.Data.CommandType.StoredProcedure, "HISTORY_LOG_i");
                    }
                    catch (Exception ex)
                    {
                        throw (ex);
                    }
                }
            }
        }