/// <summary> /// Updates the CommonSettings. /// </summary> internal void Save() { DataCommand cmd = CoreDataHelper.CreateDataCommand(); using (TransactionScope scope = new TransactionScope()) { DataHelper.SaveDataSetSimple(null, cmd, CurrentDto, "CommonSettings"); scope.Complete(); } }
/// <summary> /// Loads the settings. /// </summary> internal void Load() { DataCommand cmd = CoreDataHelper.CreateDataCommand(); cmd.CommandText = "ecf_Settings"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", AppContext.Current.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.DataSet = CurrentDto; cmd.TableMapping = DataHelper.MapTables("CommonSettings"); DataService.LoadDataSet(cmd); }
/// <summary> /// Loads by the application name. /// </summary> /// <param name="name">The name.</param> internal void LoadByApplication(string name) { DataCommand cmd = CoreDataHelper.CreateDataCommand(); cmd.CommandText = String.Format("ecf_ApplicationByName"); cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("Name", name, DataParameterType.NVarChar, 200)); cmd.DataSet = CurrentDto; cmd.TableMapping = DataHelper.MapTables("Application"); DataService.LoadDataSet(cmd); }
/// <summary> /// Loads by the application name. /// </summary> /// <param name="name">The name.</param> internal void LoadBySettingName(string name) { DataCommand cmd = CoreDataHelper.CreateDataCommand(); cmd.CommandText = String.Format("ecf_Setting_Name"); cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", AppContext.Current.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("Name", name, DataParameterType.NVarChar, 100)); cmd.DataSet = CurrentDto; cmd.TableMapping = DataHelper.MapTables("CommonSettings"); DataService.LoadDataSet(cmd); }
/// <summary> /// Load the log by id. /// </summary> internal void Load(int logId) { DataCommand cmd = CoreDataHelper.CreateDataCommand(); cmd.CommandText = String.Format("ecf_ApplicationLog_LogId"); cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("LogId", logId, DataParameterType.Int)); cmd.DataSet = this.CurrentDto; cmd.TableMapping = DataHelper.MapTables("ApplicationLog"); DataService.LoadDataSet(cmd); }
/// <summary> /// Loads the specified operation. /// </summary> /// <param name="source">Is system log.</param> /// <param name="source">The source.</param> /// <param name="operation">The operation.</param> /// <param name="objectType">Type of the object.</param> /// <param name="created">The created.</param> /// <param name="startingRecord">The starting record.</param> /// <param name="numberOfRecords">The number of records.</param> /// <param name="totalRecords">The total records.</param> internal void Load(bool isSystemLog, string source, string operation, string objectType, DateTime created, int startingRecord, int numberOfRecords, ref int totalRecords) { DataCommand cmd = CoreDataHelper.CreateDataCommand(); cmd.CommandText = String.Format("ecf_ApplicationLog"); cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", AppContext.Current.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("IsSystemLog", isSystemLog, DataParameterType.Bit, 1)); if (!String.IsNullOrEmpty(source)) { cmd.Parameters.Add(new DataParameter("Source", source, DataParameterType.NVarChar, 100)); } if (!String.IsNullOrEmpty(operation)) { cmd.Parameters.Add(new DataParameter("Operation", operation, DataParameterType.NVarChar, 50)); } if (!String.IsNullOrEmpty(objectType)) { cmd.Parameters.Add(new DataParameter("ObjectType", objectType, DataParameterType.NVarChar, 50)); } if (created != DateTime.MinValue) { cmd.Parameters.Add(new DataParameter("Created", created, DataParameterType.DateTime)); } cmd.Parameters.Add(new DataParameter("StartingRec", startingRecord, DataParameterType.Int)); cmd.Parameters.Add(new DataParameter("NumRecords", numberOfRecords, DataParameterType.Int)); cmd.DataSet = this.CurrentDto; cmd.TableMapping = DataHelper.MapTables("ApplicationLog"); DataService.LoadDataSet(cmd); if (CurrentDto.ApplicationLog.Count > 0) { totalRecords = (int)this.CurrentDto.ApplicationLog[0]["TotalCount"]; } }
/// <summary> /// Loads by the application ID. /// </summary> /// <param name="appId">The app id.</param> internal void LoadByApplication(Guid appId) { DataCommand cmd = CoreDataHelper.CreateDataCommand(); cmd.CommandText = String.Format("ecf_Application"); cmd.Parameters = new DataParameters(); if (appId == Guid.Empty) { cmd.Parameters.Add(new DataParameter("ApplicationId", DataParameterType.UniqueIdentifier)); } else { cmd.Parameters.Add(new DataParameter("ApplicationId", appId, DataParameterType.UniqueIdentifier)); } cmd.DataSet = CurrentDto; cmd.TableMapping = DataHelper.MapTables("Application"); DataService.LoadDataSet(cmd); }