public static DataTable ActivityByNameReport(ASPxGridView grid, BizPortalSessionContext context)
{
var dt = new DataTable();
dt.Columns.Add("No", typeof(int));
dt.Columns.Add("LoginName");
dt.Columns.Add("UserName");
dt.Columns.Add("GroupTitle");
dt.Columns.Add("UserRoles");
dt.Columns.Add("LastLogin");
dt.Columns.Add("LastAction");
dt.Columns.Add("Details");
dt.Columns.Add("PrintBy");
dt.Columns.Add("PrintTS");
DateTime printTS = DateTime.Now;
for (int i = 0; i < grid.VisibleRowCount; i++)
{
object[] log = ((DataRowView)grid.GetRow(i)).Row.ItemArray;
dt.Rows.Add((i + 1),
log[1].ToString(),
log[2].ToString(),
log[3].ToString(),
log[4].ToString(),
((DateTime)log[5] == TimeInterval.MinDate) ? "" : ((DateTime)log[5]).ToString("dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture),
log[6].ToString(),
LogSystem.StripTagsCharArray(log[7].ToString()),
(context.User == null) ? "" : context.User.LoginName,
printTS.ToString("dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)
);
}
return(dt);
}
public static DataTable ActivityLogClientReport(ASPxGridView grid, BizPortalSessionContext context)
{
var dt = new DataTable();
dt.Columns.Add("DateTime");
dt.Columns.Add("MemberNo");
dt.Columns.Add("MemberName");
dt.Columns.Add("MakerName");
dt.Columns.Add("Action");
dt.Columns.Add("Detail");
dt.Columns.Add("PrintBy");
dt.Columns.Add("PrintTS");
DateTime printTS = DateTime.Now;
for (int i = 0; i < grid.VisibleRowCount; i++)
{
object[] log = ((DataRowView)grid.GetRow(i)).Row.ItemArray;
dt.Rows.Add(
((DateTime)log[1] == TimeInterval.MinDate) ? "" : ((DateTime)log[1]).DateTimeFormat("dd/MM/yyyy HH:mm:ss"),
log[3].ToString(),
log[4].ToString(),
log[7].ToString(),
LogSystem.StripTagsCharArray(log[11].ToString()),
LogSystem.StripTagsCharArray(log[12].ToString()),
(context.User == null) ? "" : context.User.LoginName,
printTS.DateTimeFormat("dd/MM/yyyy HH:mm:ss")
);
}
return(dt);
}
public static DataTable MemberUserReport(ASPxGridView grid, BizPortalSessionContext context)
{
var dt = new DataTable();
dt.Columns.Add("No", typeof(int));
dt.Columns.Add("LoginName");
dt.Columns.Add("UserName");
dt.Columns.Add("Group");
dt.Columns.Add("EffectiveFrom");
dt.Columns.Add("EffectiveTo");
dt.Columns.Add("CreaterName");
dt.Columns.Add("CreateActionDate");
dt.Columns.Add("ApproverName");
dt.Columns.Add("ApproveActionDate");
dt.Columns.Add("UpdateName");
dt.Columns.Add("UpdateDate");
dt.Columns.Add("LastLogin");
dt.Columns.Add("LastLogout");
dt.Columns.Add("LastFailed");
dt.Columns.Add("LastFailedCount", typeof(int));
dt.Columns.Add("Status");
dt.Columns.Add("StatusTransaction");
dt.Columns.Add("PrintBy");
dt.Columns.Add("PrintTS");
DateTime printTS = DateTime.Now;
for (int i = 0; i < grid.VisibleRowCount; i++)
{
var item = ((DataRowView)grid.GetRow(i)).Row.ItemArray;
dt.Rows.Add(
(i + 1).ToString(),
item[1].ToString(), //LoginName
item[2].ToString(), //Person.NameWithoutAffixes
item[3].ToString(), //EffectiveMemberGroups
((DateTime)item[4]).DateTimeFormat("dd/MM/yyyy HH:mm"), //EffectivePeriodFrom
((DateTime)item[5]).DateTimeFormat("dd/MM/yyyy HH:mm"), //EffectivePeriodTo
item[6].ToString(), //CreateBy
((DateTime)item[7]).DateTimeFormat("dd/MM/yyyy HH:mm"), //CreateTS
item[8].ToString(), //ApproveBy
((DateTime)item[9]).DateTimeFormat("dd/MM/yyyy HH:mm"), //ApproveTS
item[10].ToString(), //UpdateBy
((DateTime)item[11]).DateTimeFormat("dd/MM/yyyy HH:mm"), //UpdateTS
((DateTime)item[12]).DateTimeFormat("dd/MM/yyyy HH:mm"), //LastLoginTimestamp
((DateTime)item[13]).DateTimeFormat("dd/MM/yyyy HH:mm"), //LastLogoutTS
((DateTime)item[14]).DateTimeFormat("dd/MM/yyyy HH:mm"), //LastFailedLoginTimestamp
item[15].ToString(), //User.ConsecutiveFailedLoginCount
LogSystem.StripTagsCharArray(item[16].ToString()), //Status
item[17].ToString(), //IsNotFinalized
(context.User == null) ? "" : context.User.LoginName,
printTS.ToString("dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)
);
}
return(dt);
}
public static DataTable MemberUserReportCancel(ASPxGridView grid, BizPortalSessionContext context)
{
var dt = new DataTable();
dt.Columns.Add("LoginName");
dt.Columns.Add("UserName");
dt.Columns.Add("Group");
dt.Columns.Add("EffectiveMemberGroups");
dt.Columns.Add("EffectiveFrom");
dt.Columns.Add("EffectiveTo");
dt.Columns.Add("CreaterName");
dt.Columns.Add("CreateActionDate");
dt.Columns.Add("ApproverName");
dt.Columns.Add("ApproveActionDate");
dt.Columns.Add("UpdateName");
dt.Columns.Add("UpdateDate");
dt.Columns.Add("LastLogin");
dt.Columns.Add("LastLogout");
dt.Columns.Add("LastFailed");
dt.Columns.Add("LastFailedCount");
dt.Columns.Add("Status");
dt.Columns.Add("StatusTransaction");
dt.Columns.Add("PrintBy");
dt.Columns.Add("PrintTS");
DateTime printTS = DateTime.Now;
for (int i = 0; i < grid.VisibleRowCount; i++)
{
var mu = (MemberUser)grid.GetRow(i);
dt.Rows.Add(
mu.LoginName,
mu.Name.ToString(),
LogSystem.GetGroupTitles(mu.EffectiveMemberGroups),
(mu.EffectivePeriod.EffectiveDate == TimeInterval.MinDate) ? "" : mu.EffectivePeriod.EffectiveDate.DateTimeFormat(),
(mu.EffectivePeriod.ExpiryDate == TimeInterval.MinDate) ? "" : mu.EffectivePeriod.ExpiryDate.DateTimeFormat(),
mu.CreateAction == null ? string.Empty : mu.CreateAction.ByUser.LoginName,
mu.CreateAction == null ? string.Empty : mu.CreateAction.Timestamp.DateTimeFormat(),
mu.ApproveAction == null ? string.Empty : mu.ApproveAction.ByUser.LoginName,
mu.ApproveAction == null ? string.Empty : mu.ApproveAction.Timestamp.DateTimeFormat(),
mu.UpdateAction.ByUser == null ? string.Empty : mu.UpdateAction.ByUser.LoginName,
(mu.UpdateAction.Timestamp == TimeInterval.MinDate) ? "" : mu.UpdateAction.Timestamp.DateTimeFormat(),
(mu.LastLoginTimestamp == TimeInterval.MinDate) ? "" : mu.LastLoginTimestamp.DateTimeFormat(),
(mu.LastLogoutTS == TimeInterval.MinDate) ? "" : mu.LastLogoutTS.DateTimeFormat(),
(mu.LastFailedLoginTimestamp == TimeInterval.MinDate) ? "" : mu.LastFailedLoginTimestamp.DateTimeFormat(),
Convert.ToString(mu.ConsecutiveFailedLoginCount),
LogSystem.StripTagsCharArray(UserService.GetUserStatus(mu, "en-US")),
(mu.IsNotFinalized || mu.IsNotFinalized) ? "รออนุมัติ" : "",
(context.User == null) ? "" : context.User.LoginName,
printTS.ToString("dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)
);
}
return(dt);
}
public static DataTable AccessLogCustomerReport(ASPxGridView grid, BizPortalSessionContext context
, string reportType, string durationDate, string member, string groupUser)
{
var dt = new DataTable();
dt.Columns.Add("No", typeof(int));
dt.Columns.Add("Date");
dt.Columns.Add("MemberNo");
dt.Columns.Add("MemberName");
dt.Columns.Add("LoginName");
dt.Columns.Add("Status");
dt.Columns.Add("LoginType");
dt.Columns.Add("LoginAction");
dt.Columns.Add("ReportType");
dt.Columns.Add("DurationDate");
dt.Columns.Add("Member");
dt.Columns.Add("GroupUser");
dt.Columns.Add("PrintBy");
dt.Columns.Add("PrintTS");
DateTime printTS = DateTime.Now;
for (int i = 0; i < grid.VisibleRowCount; i++)
{
object[] log = ((DataRowView)grid.GetRow(i)).Row.ItemArray;
dt.Rows.Add((i + 1),
((DateTime)log[1] == TimeInterval.MinDate) ? "" : ((DateTime)log[1]).DateTimeFormat("dd/MM/yyyy HH:mm:ss"),
log[3],
log[4],
log[6],
LogSystem.StripTagsCharArray(log[7].ToString()),
log[10],
log[12],
reportType, //ReportType
durationDate, //DurationDate
member, //Member
groupUser, //GroupUser
(context.User == null) ? "" : context.User.LoginName,
printTS.DateTimeFormat("dd/MM/yyyy HH:mm:ss")
);
}
return(dt);
}
