public SelectList GetUsersSelectList() { AuditLogSearch au = new AuditLogSearch(); if (Session["AuditLogSearch"] != null) { au = (AuditLogSearch)Session["AuditLogSearch"]; } List <SelectListItem> listUsers = new List <SelectListItem>(); { UsersRepository modelRepo = new UsersRepository(); foreach (var item in modelRepo.ReadAll()) { SelectListItem itr = new SelectListItem(); itr.Text = item.FullName; itr.Value = item.UserID.ToString(); itr.Selected = false; listUsers.Add(itr); } } return(new SelectList(listUsers, "Value", "Text", au.SUserID)); }
public ActionResult Index(FormCollection formcollection) { AuditLogSearch au = new AuditLogSearch(); if (Session["AuditLogSearch"] != null) { au = (AuditLogSearch)Session["AuditLogSearch"]; } string txtDateFrom = formcollection["txtDateFrom"].ToString(); string txtDateTo = formcollection["txtDateTo"].ToString(); string txtAction = formcollection["txtAction"].ToString(); string userID = formcollection["UserID"].ToString(); ViewData["dateFrom"] = au.StxtDateFrom = txtDateFrom; ViewData["dateTo"] = au.StxtDateTo = txtDateTo; ViewData["action"] = au.StxtAction = txtAction; au.SUserID = userID; Session["AuditLogSearch"] = au; ViewBag.Users = GetUsersSelectList(); return(RedirectToAction("Index")); }
public List <AuditLogsExt> GetListOfAuditLog(AuditLogSearch au) { AuditLogRepository modelRepo = new AuditLogRepository(); var logs = modelRepo.searchResult(au.StxtDateFrom, au.StxtDateTo, au.StxtAction, au.SUserID).ToList(); return(logs); }
public PagedResponse <AuditLogDto> Execute(AuditLogSearch search) { var query = _context.UseCaseLogs.AsQueryable(); if (search.UseCaseStartDate != null && search.UseCaseEndDate != null) { query = query.Where(x => (x.Date >= search.UseCaseStartDate) && (x.Date <= search.UseCaseEndDate)); } else if (search.UseCaseStartDate != null) { query = query.Where(x => x.Date >= search.UseCaseStartDate); } else if (search.UseCaseEndDate != null) { query = query.Where(x => x.Date <= search.UseCaseEndDate); } if (!string.IsNullOrEmpty(search.NameUseCase) || !string.IsNullOrWhiteSpace(search.NameUseCase)) { query = query.Where(x => x.UseCaseName.ToLower().Contains(search.NameUseCase.ToLower())); } if (!string.IsNullOrEmpty(search.User) || !string.IsNullOrWhiteSpace(search.User)) { query = query.Where(x => x.Actor.ToLower().Contains(search.User.ToLower())); } return(query.MakePaged <AuditLogDto, UseCaseLog>(search, _mapper)); }
// GET: AuditLog #region Index & Audit Log Search Functionality public ActionResult Index(string secret) { if (secret == "M@nvF@t@123") { AuditLogSearch au = new AuditLogSearch(); if (Session["AuditLogSearch"] != null) { au = (AuditLogSearch)Session["AuditLogSearch"]; } ViewData["dateFrom"] = au.StxtDateFrom; ViewData["dateTo"] = au.StxtDateTo; ViewData["action"] = au.StxtAction; ViewBag.Users = GetUsersSelectList(); return(View(GetListOfAuditLog(au))); } else { return(RedirectToAction("Index", "Admin")); } }
public IActionResult Get([FromQuery] AuditLogSearch search, [FromServices] IGetAuditLogs query) { return(Ok(_executor.ExecuteQuery(query, search))); }