protected override void ShowData(int auditHistoryId)
{
base.ShowData(auditHistoryId);
oDetailButtonPanel.SetId = SetId;
Clear();
var dataQuery = new DataModel.Framework.Audit.AuditHistory();
dataQuery.AuditHistoryId = auditHistoryId;
var entityList = AuditHistoryDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile);
if (entityList.Count == 1)
{
foreach (var entityItem in entityList)
{
lblAuditHistoryId.Text = entityItem.AuditHistoryId.ToString();
lblSystemEntityId.Text = entityItem.SystemEntityId.ToString();
lblEntityKey.Text = entityItem.EntityKey.ToString();
lblAuditActionId.Text = entityItem.AuditActionId.ToString();
lblCreatedDate.Text = entityItem.CreatedDate.ToString();
lblCreatedByPersonId.Text = entityItem.Person.ToString();
}
}
}
private static string Save(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.AuditHistoryInsert " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
case "Update":
sql += "dbo.AuditHistoryUpdate " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.AuditHistoryId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntityId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.EntityKey) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.AuditActionId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.CreatedDate) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.CreatedByPersonId);
return(sql);
}
public static DataTable GetEntityTestData(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile)
{
var SQL = string.Format("EXEC dbo.GetTestDataCount");
var oDT = new DataAccess.DBDataTable("EXEC GetTestDataCount", SQL, "TaskTimeTracker");
return(oDT.DBTable);
}
public static DataTable Search(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile);
var table = list.ToDataTable();
return(table);
}
public static void DeleteByEntity(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.AuditHistoryDeleteByEntity " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntityId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.EntityKey);
DataAccess.DBDML.RunSQL("AuditHistory.Delete", sql, DataStoreKey);
}
public static DataTable SearchBrokenHistoryRecords(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FindBrokenHistoryRecords " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.TypeOfIssue) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntityId);
var oDT = new DataAccess.DBDataTable("AuditHistory.FindBrokenHistoryRecords", sql, DataStoreKey);
return(oDT.DBTable);
}
public static void Delete(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile)
{
const string sql = @"dbo.AuditHistoryDelete ";
var parameters = new
{
AuditHistoryId = data.AuditHistoryId
};
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
}
public static DataTable SearchByActionByAndAuditAction(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.FindByActionByAuditAction " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
//", " + BaseColumns.ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.AuditActionId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.EntityKey) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.PersonId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntityId);
var oDT = new DataAccess.DBDataTable("AuditHistory.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
private DataTable GetData()
{
DataModel.Framework.Audit.AuditHistory data = oSearchFilter.SearchParameters;
if (!isSearch && !IsPostBack)
{
data.SystemEntityId = -1;
//data.TypeOfIssue = "-1";
}
var dt = Framework.Components.Audit.AuditHistoryDataManager.SearchBrokenHistoryRecords(data, SessionVariables.RequestProfile);
return(dt);
//return null;
}
public static DataTable SearchForActivityStream(DataModel.Framework.Audit.AuditHistory data, int pageSize, int pageIndex, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.AuditHistorySearchForActivityStream " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(DataModel.Framework.DataAccess.BaseDataModel.BaseDataColumns.PageSize, pageSize) +
", " + ToSQLParameter(DataModel.Framework.DataAccess.BaseDataModel.BaseDataColumns.PageIndex, pageIndex) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.PersonId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.FromSearchDate) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.ToSearchDate) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.DataViewMode);
var oDT = new DataAccess.DBDataTable("AuditHistory.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
private System.Data.DataTable GetData(int?systemEntityId, int?entityKey, int?auditActionId, DateTime?fromDate, DateTime?toDate, int?createdByPersonId)
{
// basic list -- no longer needed as Search will be more robust and powerfull
// List given search parameters
var data = new DataModel.Framework.Audit.AuditHistory();
data.SystemEntityId = systemEntityId;
data.EntityKey = entityKey;
data.AuditActionId = auditActionId;
data.FromSearchDate = fromDate;
data.ToSearchDate = toDate;
data.CreatedByPersonId = createdByPersonId;
var dt = Framework.Components.Audit.AuditHistoryDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
string[] deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new DataModel.Framework.Audit.AuditHistory();
data.AuditHistoryId = int.Parse(index);
Framework.Components.Audit.AuditHistoryDataManager.Delete(data, SessionVariables.RequestProfile);
}
//Framework.Components.Audit.AuditHistory.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.AuditHistory, AuditId);
Response.Redirect(Page.GetRouteUrl("AuditHistoryEntityRoute", new { Action = "Default", SetId = true }), false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
static public List <DataModel.Framework.Audit.AuditHistory> GetEntityDetails(DataModel.Framework.Audit.AuditHistory dataQuery, RequestProfile requestProfile)
{
const string sql = @"dbo.AuditHistorySearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, AuditActionId = dataQuery.AuditActionId
, EntityKey = dataQuery.EntityKey
, CreatedByPersonId = dataQuery.CreatedByPersonId
, TraceId = dataQuery.TraceId
, SystementityId = dataQuery.SystemEntityId
};
List <DataModel.Framework.Audit.AuditHistory> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <DataModel.Framework.Audit.AuditHistory>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static void Update(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DataAccess.DBDML.RunSQL("AuditHistory.Update", sql, DataStoreKey);
}
public static DataModel.Framework.Audit.AuditHistory GetDetails(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile);
return(list.FirstOrDefault());
}
public static string ToSQLParameter(DataModel.Framework.Audit.AuditHistory data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case DataModel.Framework.Audit.AuditHistory.DataColumns.AuditHistoryId:
if (data.AuditHistoryId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DataModel.Framework.Audit.AuditHistory.DataColumns.AuditHistoryId, data.AuditHistoryId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.AuditHistoryId);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntityId:
if (data.SystemEntityId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntityId, data.SystemEntityId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntityId);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.TraceId:
if (data.TraceId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DataModel.Framework.Audit.AuditHistory.DataColumns.TraceId, data.TraceId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.TraceId);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.EntityKey:
if (data.EntityKey != null)
{
returnValue = string.Format(BaseDataManager.SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Audit.AuditHistory.DataColumns.EntityKey, data.EntityKey);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.EntityKey);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.AuditActionId:
if (data.AuditActionId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DataModel.Framework.Audit.AuditHistory.DataColumns.AuditActionId, data.AuditActionId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.AuditActionId);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.CreatedDate:
if (data.CreatedDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DataModel.Framework.Audit.AuditHistory.DataColumns.CreatedDate, data.CreatedDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.CreatedDate);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.CreatedByPersonId:
if (data.CreatedByPersonId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DataModel.Framework.Audit.AuditHistory.DataColumns.CreatedByPersonId, data.CreatedByPersonId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.CreatedByPersonId);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.PersonId:
if (data.PersonId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DataModel.Framework.Audit.AuditHistory.DataColumns.PersonId, data.PersonId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.PersonId);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.TimeInterval:
if (data.TimeInterval != null)
{
returnValue = string.Format(BaseDataManager.SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Audit.AuditHistory.DataColumns.TimeInterval, data.TimeInterval);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.TimeInterval);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntity:
if (!string.IsNullOrEmpty(data.SystemEntity))
{
returnValue = string.Format(BaseDataManager.SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntity, data.SystemEntity);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntity);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.AuditAction:
if (!string.IsNullOrEmpty(data.AuditAction))
{
returnValue = string.Format(BaseDataManager.SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Audit.AuditHistory.DataColumns.AuditAction, data.AuditAction);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.AuditAction);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.Person:
if (!string.IsNullOrEmpty(data.Person))
{
returnValue = string.Format(BaseDataManager.SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Audit.AuditHistory.DataColumns.Person, data.Person);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.Person);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.DataViewMode:
if (!string.IsNullOrEmpty(data.DataViewMode))
{
returnValue = string.Format(BaseDataManager.SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Audit.AuditHistory.DataColumns.DataViewMode, data.DataViewMode);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.DataViewMode);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.ToSearchDate:
if (data.TimeInterval != null)
{
returnValue = string.Format(BaseDataManager.SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Audit.AuditHistory.DataColumns.ToSearchDate, data.ToSearchDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.ToSearchDate);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.FromSearchDate:
if (data.FromSearchDate != null)
{
returnValue = string.Format(BaseDataManager.SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Audit.AuditHistory.DataColumns.FromSearchDate, data.FromSearchDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.FromSearchDate);
}
break;
case DataModel.Framework.Audit.AuditHistory.DataColumns.TypeOfIssue:
if (!string.IsNullOrEmpty(data.TypeOfIssue))
{
returnValue = string.Format(BaseDataManager.SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DataModel.Framework.Audit.AuditHistory.DataColumns.TypeOfIssue, data.TypeOfIssue);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DataModel.Framework.Audit.AuditHistory.DataColumns.TypeOfIssue);
}
break;
default:
returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
