/// <summary> /// Right Pane navigation for Alerts displays Alerts information locks and dates /// </summary> /// <param name="filter"></param> /// <returns></returns> public IEnumerable <AlertJobFilterData> GetFilteredAlertEntities(AlertJobFilter filter) { var AlertJobQueueID = filter.AlertJobQueueID; var DueDate = filter.DueDate; var result = _context.AlertJobFilterData .AsNoTracking() .FromSql(@"usp_GetAlertEntries_sel @AlertJobQueueID={0}, @DueDate={1}", AlertJobQueueID, DueDate) .Select(pg => new AlertJobFilterData { AlertJobsQueueID = pg.AlertJobsQueueID, Job = pg.Job, JobURL = pg.JobURL, Due = pg.Due, Alert = pg.Alert, AlertDescription = pg.AlertDescription, Created = pg.Created, AlertJobEntityID = pg.AlertJobEntityID, WorkItemID = pg.WorkItemID, Status = pg.Status, Locked = pg.Locked }); return(result); }
public JsonResult GetAlertEntitiesFilter([FromBody] AlertJobFilter filter) { if (ModelState.IsValid && filter != null) { var AlertJobQueueID = filter.AlertJobQueueID; var DueDate = filter.DueDate; var result = _context.AlertJobFilterData .FromSql($"usp_GetAlertEntries_sel @AlertJobQueueID={AlertJobQueueID}, @DueDate={DueDate} ") .Select(pg => new AlertJobFilterData { AlertJobsQueueID = pg.AlertJobsQueueID, Job = pg.Job, Due = pg.Due, Alert = pg.Alert, AlertDescription = pg.AlertDescription, Created = pg.Created, AlertJobEntityID = pg.AlertJobEntityID, WorkItemID = pg.WorkItemID, Status = pg.Status, Locked = pg.Locked }).ToList(); return(Json(result)); } return(Json("No Data")); }
public void AlertJobsQueueEntity() { IEnumerable <AlertJobFilterData> AlertJobFilterDataItems = Enumerable.Empty <AlertJobFilterData>(); object t = new object(); AlertJobsQueueEntityData data = new AlertJobsQueueEntityData(); AlertJobsQueueEntity dataEntity = new AlertJobsQueueEntity(); AlertJobFilter filter = new AlertJobFilter(); Mock <IAlertJobsQueueEntityRepository> AlertJobsQueueEntityService = new Mock <IAlertJobsQueueEntityRepository>(); Guid guid = new Guid(); IConfiguration config = null; WorkItemPostData wrkitemdata = new WorkItemPostData(); AlertJobsQueueEntityDataSave datasave = new AlertJobsQueueEntityDataSave(); object obj = new object(); try { AlertJobsQueueEntityService.Setup(x => x.GetAlertBatchItems()).Returns(t); AlertJobsQueueEntityService.Setup(x => x.GetFilteredAlertEntities(It.IsAny <AlertJobFilter>())).Returns(AlertJobFilterDataItems); AlertJobsQueueEntityService.Setup(x => x.CheckWorkItemIDForEntity(It.IsAny <WorkItemPostData>(), It.IsAny <IConfiguration>())) .Returns(t); AlertJobsQueueEntityService.Setup(x => x.GetByGuid(It.IsAny <Guid>())).Returns(data); AlertJobsQueueEntityService.Setup(x => x.UpdateEntry(It.IsAny <AlertJobsQueueEntityDataSave>(), It.IsAny <IConfiguration>())) .Returns(dataEntity); var AlertJobsQueueEntityObject = AlertJobsQueueEntityService.Object; var p1 = AlertJobsQueueEntityObject.GetAlertBatchItems(); var p2 = AlertJobsQueueEntityObject.GetFilteredAlertEntities(filter); var p3 = AlertJobsQueueEntityObject.GetByGuid(guid); var p4 = AlertJobsQueueEntityObject.CheckWorkItemIDForEntity(wrkitemdata, config); var p5 = AlertJobsQueueEntityObject.UpdateEntry(datasave, config); Assert.IsAssignableFrom <object>(p1); Assert.IsAssignableFrom <IEnumerable <AlertJobFilterData> >(p2); Assert.IsAssignableFrom <AlertJobsQueueEntityData>(p3); Assert.IsAssignableFrom <object>(p4); Assert.IsAssignableFrom <AlertJobsQueueEntity>(p5); AlertJobsQueueEntityService.VerifyAll(); AlertJobsQueueEntityObject.Dispose(); } finally { AlertJobsQueueEntityService = null; } }
public IActionResult GetFilteredAlertEntities([FromBody] AlertJobFilter filter) { var data = _repository.GetFilteredAlertEntities(filter); return(Helper.CheckResult(data)); }