//Audit Trail methods

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

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

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

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

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

            ProjectsRecord rec = null;

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

            return(rec);
        }