Example #1
0
        //Audit Trail methods

        //Evaluates Initialize when->Reading record formulas specified at the data access layer
        protected virtual void ProjectNotesRecord_ReadRecord(Object sender, System.EventArgs e)
        {
            //Apply Initialize->Reading record formula only if validation is successful.
            ProjectNotesRecord ProjectNotesRec = (ProjectNotesRecord)sender;

            if (ProjectNotesRec != null && !ProjectNotesRec.IsReadOnly)
            {
            }
        }
Example #2
0
        //Evaluates Initialize when->Updating formulas specified at the data access layer
        protected virtual void ProjectNotesRecord_UpdatingRecord(Object sender, System.ComponentModel.CancelEventArgs e)
        {
            //Apply Initialize->Updating formula only if validation is successful.
            ProjectNotesRecord ProjectNotesRec = (ProjectNotesRecord)sender;

            Validate_Updating();
            if (ProjectNotesRec != null && !ProjectNotesRec.IsReadOnly)
            {
                ProjectNotesRec.Parse(EvaluateFormula("UserID()", this, null), ProjectNotesTable.UpdatedBy);
                ProjectNotesRec.Parse(EvaluateFormula("Today()", this, null), ProjectNotesTable.UpdatedOn);
            }
        }
Example #3
0
        /// <summary>
        /// This is a shared function that can be used to get a ProjectNotesRecord record using a where and order by clause.
        /// </summary>
        public static ProjectNotesRecord GetRecord(BaseFilter join, string where, OrderBy orderBy)
        {
            SqlFilter whereFilter = null;

            if (where != null && where.Trim() != "")
            {
                whereFilter = new SqlFilter(where);
            }

            ArrayList recList = ProjectNotesTable.Instance.GetRecordList(join, whereFilter, null, orderBy, BaseTable.MIN_PAGE_NUMBER, BaseTable.MIN_BATCH_SIZE);

            ProjectNotesRecord rec = null;

            if (recList.Count > 0)
            {
                rec = (ProjectNotesRecord)recList[0];
            }

            return(rec);
        }