public IActionResult GetFilteredAlertEntities_v1([FromBody] AlertJobFilter_v1 filter)
{
string EmailPoolSuperUserID = _configuration.GetSection("EditorialSettings:EmailPoolSuperUserID").Value;
var data = _repository.GetFilteredAlertEntities_v1(filter, EmailPoolSuperUserID);
return(Helper.CheckResult(data));
}
public IEnumerable <AlertJobFilterData_v1> GetFilteredAlertEntities_v1(AlertJobFilter_v1 filter, string SuperUserId)
{
int RecipientID = Int32.Parse(SuperUserId);
int NameID = 0; // Used in the usp_GetJobAlertsForQueue_By_Recipient_Job, putting a value to make the SP execute
int CountryID = filter.CountryID;
int AlertJobsID = filter.AlertJobsID;
var result = _context.AlertJobFilterData_v1
.AsNoTracking()
.FromSql(@"usp_GetJobAlertsForQueue_By_Recipient_Job @RecipientID={0}, @JobID={1}, @CountryID={2}, @NameID={3} ",
RecipientID,
AlertJobsID,
CountryID,
NameID
)
.Select(pg => new AlertJobFilterData_v1
{
PkJobID = pg.PkJobID,
JobName = pg.JobName,
JobUrl = pg.JobUrl,
OpenJobCount = pg.OpenJobCount,
AlertNameID = pg.AlertNameID,
fkCountryID = pg.fkCountryID,
Country = pg.Country,
NameEntry = pg.NameEntry,
EditTypeID = pg.EditTypeID,
DispositionTypeID = pg.DispositionTypeID,
fkRecipientID = pg.fkRecipientID,
DispositionUser = pg.DispositionUser,
EmailPoolDateCreated = pg.EmailPoolDateCreated,
EmailKey = pg.EmailKey,
EmailKeyNext = pg.EmailKeyNext,
Completed = pg.Completed
});
return(result);
}
