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