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