public void LoadData(string categoryName, bool showId)
{
CategoryName = categoryName;
var userPreferenceSettingsDictionary = ActivityStreamCommon.GetUserPreferencesForActivityStream(CategoryName);
if (userPreferenceSettingsDictionary.Values.Count > 0)
{
//defaultCPE.SelectedColor = userPreferenceSettingsDictionary[ActivityStreamCommon.BackGroungColorKey];
txtHeight.Text = userPreferenceSettingsDictionary[ActivityStreamCommon.HeightKey];
txtInterval.Text = userPreferenceSettingsDictionary[ActivityStreamCommon.DateRangeKey];
txtColor.Text = userPreferenceSettingsDictionary[ActivityStreamCommon.BackGroungColorKey];
txtWidth.Text = userPreferenceSettingsDictionary[ActivityStreamCommon.WidthKey];
txtStartDate.Text = String.Format("{0:MM/dd/yyyy}", DateTime.Now);
drpActivityAlertMode.SelectedValue = userPreferenceSettingsDictionary[ActivityStreamCommon.DataTypeKey];
txtActivityStreamAuditId.Text = userPreferenceSettingsDictionary[ActivityStreamCommon.ActivityStreamAuditId];
txtActivityStreamPageSize.Text = userPreferenceSettingsDictionary[ActivityStreamCommon.ActivityStreamPageSize];
txtActivityStreamTitle.Text = userPreferenceSettingsDictionary[ActivityStreamCommon.ActivityStreamTitle];
drpPagingStyle.SelectedValue = userPreferenceSettingsDictionary[ActivityStreamCommon.ActivityStreamPagingStyle];
LoadSource();
LoadCurrentTarget();
}
else
{
txtHeight.Text = string.Empty;
txtInterval.Text = string.Empty;
txtColor.Text = string.Empty;
txtWidth.Text = string.Empty;
txtStartDate.Text = string.Empty;
txtActivityStreamAuditId.Text = string.Empty;
txtActivityStreamPageSize.Text = string.Empty;
txtActivityStreamTitle.Text = string.Empty;
}
}
private void LoadActivityStreamSettings()
{
var userPreferenceCategoryName = ActivityStreamName;
var userPreferenceSettingsDictionary = ActivityStreamCommon.GetUserPreferencesForActivityStream(userPreferenceCategoryName);
DateInterval = Convert.ToInt32(userPreferenceSettingsDictionary[ActivityStreamCommon.DateRangeKey]);
var backGroundColor = userPreferenceSettingsDictionary[ActivityStreamCommon.BackGroungColorKey];
var width = userPreferenceSettingsDictionary[ActivityStreamCommon.WidthKey];
var height = userPreferenceSettingsDictionary[ActivityStreamCommon.HeightKey];
DataViewMode = userPreferenceSettingsDictionary[ActivityStreamCommon.DataTypeKey];
ActivityStreamPageSize = Convert.ToInt32(userPreferenceSettingsDictionary[ActivityStreamCommon.ActivityStreamPageSize]);
lblActivityStreamTitle.Text = userPreferenceSettingsDictionary[ActivityStreamCommon.ActivityStreamTitle];
PagingStyle = userPreferenceSettingsDictionary[ActivityStreamCommon.ActivityStreamPagingStyle];
ActivityStreamGroupIntervalInSeconds = Convert.ToInt32(userPreferenceSettingsDictionary[ActivityStreamCommon.ActivityStreamGroupInterval]);
ActivityStreamTempPageSize = ActivityStreamPageSize;
lblDataViewMode.Text = "<font color='Teal'> Data View Mode: <font/>" + " <font color='Black'>*" + DataViewMode + "<font/>";
tblMain.Style["background-color"] = "#" + backGroundColor;
//tblMain.Height = height;
divContainer.Style.Add("width", width + "px");
divContainer.Style.Add("height", height + "px");
divContainer.Style.Add("overflow", "auto");
var x = "<font color='Black'>" + String.Format("{0:MM/dd/yyyy}", DateTime.Now.AddDays(DateInterval * (-1))) + " - " +
String.Format("{0:MM/dd/yyyy}", DateTime.Now) + "<font/>";
lblDateRange.Text = "<font color='Teal'> Date Range: <font/>" + " " + x;
try
{
ActivityStreamAuditId = Convert.ToInt32(userPreferenceSettingsDictionary[ActivityStreamCommon.ActivityStreamAuditId]);
lblActivityStreamAuditId.Text = lblCount.Text = "<font color='Teal'>" + "Audit Id: " + "<font/>" + "<font color='Black'>" + ActivityStreamAuditId + "<font/>";
}
catch { }
}
private List <UserActivityItem> CreateActivityStream(DataTable dtAuditdata)
{
var activitySteam = new List <UserActivityItem>();
var dv = dtAuditdata.DefaultView;
var rowFilter = String.Empty;
rowFilter = AuditHistory.DataColumns.AuditAction + " in ('Insert', 'Update', 'Delete') ";
//DataViewMode = "Test";
//if (DataViewMode != "Both")
//{
// if (DataViewMode == "Real Data")
// {
// rowFilter += " and " + DataModel.Framework.Audit.AuditHistory.DataColumns.EntityKey + " > 0";
// }
// else
// {
// rowFilter += " and " + DataModel.Framework.Audit.AuditHistory.DataColumns.EntityKey + " < 0";
// }
//}
var dtExcludedEntities = ActivityStreamCommon.GetExcludedSystemEntities(ActivityStreamName);
if (dtExcludedEntities != null && dtExcludedEntities.Rows.Count > 0)
{
var strEntities = String.Empty;
foreach (DataRow dr in dtExcludedEntities.Rows)
{
if (!string.IsNullOrEmpty(strEntities))
{
strEntities += ", ";
}
strEntities += Convert.ToString(dr[UserPreferenceSelectedItemDataModel.DataColumns.Value]);
}
rowFilter += " and " + AuditHistory.DataColumns.SystemEntityId + " not in (" + strEntities + ")";
}
dv.RowFilter = rowFilter;
//dv.Sort = "CreatedDate DESC";
double appTimeZoneDifference = 0;
try
{
appTimeZoneDifference = Convert.ToDouble(ConfigurationManager.AppSettings["UTCTimeZoneDifference"]);
}
catch { }
var prevCreatedBy = String.Empty;
var prevTimeGroup = String.Empty;
if (dv.Count > 0)
{
RowCount = Convert.ToInt32(dtAuditdata.Rows[0]["TotalCount"]);
dtAuditdata = dv.ToTable();
for (var iCount = 0; iCount < dtAuditdata.Rows.Count; iCount++)
{
var drv = dtAuditdata.Rows[iCount];
var userActivity = new UserActivityItem();
var activityText = String.Empty;
var systemEntity = Convert.ToString(drv[AuditHistory.DataColumns.SystemEntity]);
var entityRecordId = Convert.ToInt32(drv[AuditHistory.DataColumns.EntityKey]);
var auditAction = Convert.ToString(drv[AuditHistory.DataColumns.AuditAction]);
var createdBy = Convert.ToString(drv[AuditHistory.DataColumns.Person]);
var createdDate = Convert.ToDateTime(drv[BaseDataModel.BaseDataColumns.CreatedDate]);
var addTimeToAlert = GetActivityTimeText(createdDate, appTimeZoneDifference);
userActivity.TimeGrouping = GetActivityTimeGroup(createdDate, appTimeZoneDifference);
//Check whether the entity record still exist in the DB,
//need a common search procedure in the Business Layer or change the way audit records are sent from DB
if (prevCreatedBy == createdBy)
{
userActivity.ShowImage = false;
}
if (userActivity.TimeGrouping != prevTimeGroup)
{
userActivity.ShowImage = true;
userActivity.ShowTimeGroup = true;
}
var drs = GetGroupedRecords(systemEntity, createdDate, dtAuditdata);
if (drs != null && drs.Length > 1)
{
userActivity.gropedItems = new List <UserActivityChildItem>();
foreach (var drChild in drs)
{
var childItem = new UserActivityChildItem();
var childAuditAction = Convert.ToString(drChild[AuditHistory.DataColumns.AuditAction]);
var childEntityKey = Convert.ToInt32(drChild[AuditHistory.DataColumns.EntityKey]);
childItem.ChildText = GetChildActivityText(systemEntity, childEntityKey, childAuditAction);
userActivity.gropedItems.Add(childItem);
}
iCount += drs.Length - 1;
userActivity.TimeStampText = "\t\t\t\t\t\t<font size ='1.5'; color='Teal'>" + " - " + addTimeToAlert + "<font/>";
activityText = "<font color='Black'>" + createdBy + " changed records in " + systemEntity + "<font/>" + "<br />";
}
else
{
addTimeToAlert = "<font size ='1.5'; color='Teal'>" + " - " + addTimeToAlert + "<font/>";
activityText = "<font color='Black'>" + GetActivityText(createdBy, systemEntity, entityRecordId, auditAction) + "<font/>" + "<br />";
activityText += "\t\t\t\t\t\t" + addTimeToAlert;
}
userActivity.ActivityText = activityText;
activitySteam.Add(userActivity);
prevCreatedBy = createdBy;
prevTimeGroup = userActivity.TimeGrouping;
}
}
lblCount.Text = "<font color='Teal'>" + "Total Records: " + "<font/>" + "<font color='Black'>" + RowCount + "<font/>";
return(activitySteam);
}
private DataTable LoadExcludedSystemEntities(string categoryName)
{
DataTable dt = ActivityStreamCommon.GetExcludedSystemEntities(categoryName);
return(dt);
}
