protected void Page_Load(object sender, EventArgs e) { try { string currentPageFileName = new FileInfo(this.Request.Url.AbsolutePath).Name; var PermMgr = new PermissionManager(Session); if (PermMgr.IsAdmin || PermMgr.CanManagePortal) { if (!IsPostBack) { var auditLogs = _db.AuditRecords.OrderByDescending(s => s.AuditDate).ToList(); TotalRecCount.Text = auditLogs.Count() + " Log(s)"; AudiTrailGrid.DataSource = auditLogs; AudiTrailGrid.DataBind(); ViewActive.Value = ""; ViewActiveTitle.Value = ""; } } else { Response.Redirect("NoPermission.aspx", false); } } catch (Exception ex) { ErecruitHelper.SetErrorData(ex, Session); Response.Redirect("ErrorPage.aspx", false); } }
protected void AudiTrailGrid_PageIndexChanging(object sender, GridViewPageEventArgs e) { try{ var auditLogs = _db.AuditRecords.OrderByDescending(s => s.AuditDate).ToList(); TotalRecCount.Text = auditLogs.Count() + " Log(s)"; AudiTrailGrid.DataSource = auditLogs; AudiTrailGrid.PageIndex = e.NewPageIndex; AudiTrailGrid.DataBind(); } catch (Exception ex) { ErecruitHelper.SetErrorData(ex, Session); Response.Redirect("ErrorPage.aspx", false); } }
protected void AudiTrailGrid_Sorting(object sender, GridViewSortEventArgs e) { try{ var auditLogs = _db.AuditRecords.OrderByDescending(s => s.AuditDate).ToList(); TotalRecCount.Text = auditLogs.Count() + " Log(s)"; if ((string)Session["EXP"] == e.SortExpression && (string)Session["DIRECTION"] == SortDirection.Ascending.ToString()) { e.SortDirection = SortDirection.Descending; } else { e.SortDirection = SortDirection.Ascending; } Session["EXP"] = e.SortExpression; Session["DIRECTION"] = e.SortDirection.ToString(); switch (e.SortExpression) { case "UserName": if (e.SortDirection == SortDirection.Ascending) { auditLogs = auditLogs.OrderBy(s => s.UserName).ToList(); AudiTrailGrid.DataSource = auditLogs; AudiTrailGrid.DataBind(); } else { auditLogs = auditLogs.OrderByDescending(s => s.UserName).ToList(); AudiTrailGrid.DataSource = auditLogs; AudiTrailGrid.DataBind(); } break; case "Action": if (e.SortDirection == SortDirection.Ascending) { auditLogs = auditLogs.OrderBy(s => s.Action).ToList(); AudiTrailGrid.DataSource = auditLogs; AudiTrailGrid.DataBind(); } else { auditLogs = auditLogs.OrderByDescending(s => s.Action).ToList(); AudiTrailGrid.DataSource = auditLogs; AudiTrailGrid.DataBind(); } break; case "TableName": if (e.SortDirection == SortDirection.Ascending) { auditLogs = auditLogs.OrderBy(s => s.TableName).ToList(); AudiTrailGrid.DataSource = auditLogs; AudiTrailGrid.DataBind(); } else { auditLogs = auditLogs.OrderByDescending(s => s.TableName).ToList(); AudiTrailGrid.DataSource = auditLogs; AudiTrailGrid.DataBind(); } break; //case "MemberName": // if (e.SortDirection == SortDirection.Ascending) // { // auditLogs = auditLogs.OrderBy(s => s.MemberName).ToList(); // AudiTrailGrid.DataSource = auditLogs; // AudiTrailGrid.DataBind(); // } // else // { // auditLogs = auditLogs.OrderByDescending(s => s.MemberName).ToList(); // AudiTrailGrid.DataSource = auditLogs; // AudiTrailGrid.DataBind(); // } // break; //case "OldValue": // if (e.SortDirection == SortDirection.Ascending) // { // auditLogs = auditLogs.OrderBy(s => s.OldValue).ToList(); // AudiTrailGrid.DataSource = auditLogs; // AudiTrailGrid.DataBind(); // } // else // { // auditLogs = auditLogs.OrderByDescending(s => s.OldValue).ToList(); // AudiTrailGrid.DataSource = auditLogs; // AudiTrailGrid.DataBind(); // } // break; //case "NewValue": // if (e.SortDirection == SortDirection.Ascending) // { // auditLogs = auditLogs.OrderBy(s => s.NewValue).ToList(); // AudiTrailGrid.DataSource = auditLogs; // AudiTrailGrid.DataBind(); // } // else // { // auditLogs = auditLogs.OrderByDescending(s => s.NewValue).ToList(); // AudiTrailGrid.DataSource = auditLogs; // AudiTrailGrid.DataBind(); // } // break; case "AuditDate": if (e.SortDirection == SortDirection.Ascending) { auditLogs = auditLogs.OrderBy(s => s.AuditDate).ToList(); AudiTrailGrid.DataSource = auditLogs; AudiTrailGrid.DataBind(); } else { auditLogs = auditLogs.OrderByDescending(s => s.AuditDate).ToList(); AudiTrailGrid.DataSource = auditLogs; AudiTrailGrid.DataBind(); } break; } } catch (Exception ex) { ErecruitHelper.SetErrorData(ex, Session); Response.Redirect("ErrorPage.aspx", false); } }
protected void SearchAuditTrail_Click(object sender, EventArgs e) { try{ var user = username.Text; var action = Action.Text; var c = cond.Value; var table = tablename.Text; // var col = column.Text; var dateLogged = AuditDate.Text; IQueryable <AuditRecord> logs; if (!string.IsNullOrEmpty(user)) { logs = _db.AuditRecords.Where(s => (s.UserName.Contains(user))); } else { logs = _db.AuditRecords.AsQueryable(); } if (!string.IsNullOrEmpty(table)) { logs = logs.Where(s => s.TableName.Contains(table)).AsQueryable(); } if (!string.IsNullOrEmpty(action)) { logs = logs.Where(s => s.Action.Contains(action)).AsQueryable(); } //if (!string.IsNullOrEmpty(col) ) //{ // logs = logs.Where(s => s.MemberName.Contains(col)).AsQueryable(); //} if (!string.IsNullOrEmpty(dateLogged)) { var logdate = ErecruitHelper.GetCurrentDateFromDateStringWithHM(dateLogged); if ((logdate) != null) { if (c == "=") { logs = logs.Where(s => s.AuditDate == (logdate)).AsQueryable(); } else if (c == "<") { logs = logs.Where(s => s.AuditDate < (logdate)).AsQueryable(); } else if (c == ">") { logs = logs.Where(s => s.AuditDate > (logdate)).AsQueryable(); } } } TotalRecCount.Text = logs.Count() + " Log(s)"; AudiTrailGrid.DataSource = logs; AudiTrailGrid.DataBind(); } catch (Exception ex) { ErecruitHelper.SetErrorData(ex, Session); Response.Redirect("ErrorPage.aspx", false); } }