//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) { } }
//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); } }
/// <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); }