public List <AuditSummarySearchDTO> GetSearchAuditdata(AuditSearchDTO auditSearchDTO, long userID, long RoleID)
{
List <AuditSummarySearchDTO> result = new List <AuditSummarySearchDTO>();
AuditSearch request = new AuditSearch();
ObjectMapper.Map(auditSearchDTO, request);
ObjectMapper.Map(RaceRepository.GetSearchAuditdata(request, userID, RoleID), result);
return(result);
}
public List <SpAuditSummarySearch_Result> GetSearchAuditdata(AuditSearch auditSearch, long userID, long RoleID)
{
List <SpAuditSummarySearch_Result> result = new List <SpAuditSummarySearch_Result>();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,
new TransactionOptions
{
IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted
}))
{
result = SmartDostDbContext.SpAuditSummarySearch(fromDate: auditSearch.Assessment_From_Date, toDate: auditSearch.Assessment_To_Date, currentStatus: null, state: auditSearch.Unit,
city: auditSearch.Region, supFromDate: auditSearch.SupdateFrom, supToDate: auditSearch.SupdateTo, supStatus: auditSearch.supStatus, qC1FromDate: auditSearch.QClevel1datefrom, qC1ToDate: auditSearch.QClevel1dateto,
qC1Status: auditSearch.qC1Status, qC2FromDate: auditSearch.QClevel2DateFrom, qC2ToDate: auditSearch.QClevel2DateTo, qC2Status: auditSearch.qC2Status, storeCode: auditSearch.storeCode, advanceFilterRequired: auditSearch.advanceFilterRequired,
loggedUserID: userID, loggedUserRoleID: RoleID).ToList();
scope.Complete();
}
return(result);
}