public override string EvaluateExpressions(string url, string arg, bool bEncrypt, bool includeSession) { TrapIdentifiersRecord rec = null; try { rec = this.GetRecord(); } catch (Exception) { // Do Nothing } if (rec == null && url.IndexOf("{") >= 0) { // Localization. throw new Exception(Page.GetResourceValue("Err:RecDataSrcNotInitialized", "RatTrap")); } if (includeSession) { return(EvaluateExpressions(url, arg, rec, bEncrypt)); } else { return(EvaluateExpressions(url, arg, rec, bEncrypt, includeSession)); } }
//Audit Trail methods //Evaluates Initialize when->Reading record formulas specified at the data access layer protected virtual void TrapIdentifiersRecord_ReadRecord(Object sender, System.EventArgs e) { //Apply Initialize->Reading record formula only if validation is successful. TrapIdentifiersRecord TrapIdentifiersRec = (TrapIdentifiersRecord)sender; if (TrapIdentifiersRec != null && !TrapIdentifiersRec.IsReadOnly) { } }
//Evaluates Initialize when->Updating formulas specified at the data access layer protected virtual void TrapIdentifiersRecord_UpdatingRecord(Object sender, System.ComponentModel.CancelEventArgs e) { //Apply Initialize->Updating formula only if validation is successful. TrapIdentifiersRecord TrapIdentifiersRec = (TrapIdentifiersRecord)sender; Validate_Updating(); if (TrapIdentifiersRec != null && !TrapIdentifiersRec.IsReadOnly) { TrapIdentifiersRec.Parse(EvaluateFormula("UserID()", this, null), TrapIdentifiersTable.UpdatedBy); TrapIdentifiersRec.Parse(EvaluateFormula("Today()", this, null), TrapIdentifiersTable.UpdatedOn); } }
public virtual void LoadData() { // Load the data from the database into the DataSource DatabaseTheRatTrap%dbo.TrapIdentifiers record. // It is better to make changes to functions called by LoadData such as // CreateWhereClause, rather than making changes here. // The RecordUniqueId is set the first time a record is loaded, and is // used during a PostBack to load the record. if (this.RecordUniqueId != null && this.RecordUniqueId.Length > 0) { this.DataSource = TrapIdentifiersTable.GetRecord(this.RecordUniqueId, true); return; } // This is the first time a record is being retrieved from the database. // So create a Where Clause based on the staic Where clause specified // on the Query wizard and the dynamic part specified by the end user // on the search and filter controls (if any). WhereClause wc = this.CreateWhereClause(); // If there is no Where clause, then simply create a new, blank record. if (wc == null || !(wc.RunQuery)) { this.DataSource = new TrapIdentifiersRecord(); return; } // Retrieve the record from the database. It is possible TrapIdentifiersRecord[] recList = TrapIdentifiersTable.GetRecords(wc, null, 0, 2); if (recList.Length == 0) { // There is no data for this Where clause. wc.RunQuery = false; return; } // Set DataSource based on record retrieved from the database. this.DataSource = (TrapIdentifiersRecord)TrapIdentifiersRecord.Copy(recList[0], false); }
/// <summary> /// This is a shared function that can be used to get a TrapIdentifiersRecord record using a where and order by clause. /// </summary> public static TrapIdentifiersRecord GetRecord(BaseFilter join, string where, OrderBy orderBy) { SqlFilter whereFilter = null; if (where != null && where.Trim() != "") { whereFilter = new SqlFilter(where); } ArrayList recList = TrapIdentifiersTable.Instance.GetRecordList(join, whereFilter, null, orderBy, BaseTable.MIN_PAGE_NUMBER, BaseTable.MIN_BATCH_SIZE); TrapIdentifiersRecord rec = null; if (recList.Count > 0) { rec = (TrapIdentifiersRecord)recList[0]; } return(rec); }