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