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