Beispiel #1
0
        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);
        }
Beispiel #2
0
        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);
        }