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