public async Task <GetResponse <IReadOnlyList <ISalesVerification> > > GetAllSalesVerificationAsync(int auditId, int entityId, string state, int locationId, SalesPeriodType periodType)
        {
            var getResponse = new GetResponse <IReadOnlyList <ISalesVerification> >();

            try
            {
                getResponse = await _salesRepository.GetAllSalesVerificationAsync(auditId, entityId, state, locationId, periodType);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
                getResponse.AddError(ex);
                _logManager.LogError(ex, "Error retrieving saless");
            }

            return(getResponse);
        }
Exemple #2
0
        public async Task <GetResponse <IReadOnlyList <ISalesVerification> > > GetAllSalesVerificationAsync(int auditId, int entityId, string state, int locationId, SalesPeriodType periodType)
        {
            var response = new GetResponse <IReadOnlyList <ISalesVerification> >();

            try
            {
                using (var connection = ConnectionFactory.GetConnection())
                {
                    var sql = "spsAllSalesVerification";

                    var results = await connection
                                  .QueryAsync <SalesVerificationDto>(sql, new { AuditId = auditId, EntityId = entityId, LocationId = locationId }, commandType : CommandType.StoredProcedure);

                    var filteredResults = results
                                          .Where(dto => dto.State == state && dto.PeriodType == (int)periodType)
                                          .AsList();

                    var items = filteredResults
                                .Select(dto => dto.ToModel())
                                .AsList();

                    foreach (var dto in filteredResults)
                    {
                        if (dto.VerificationFileId.HasValue)
                        {
                            var fileResult = await _auditUploadRepository.GetByIdAsync(dto.VerificationFileId.Value);

                            if (fileResult.IsSuccessful)
                            {
                                items.First(i => i.PeriodStart == dto.PeriodStart)
                                .VerificationFile = fileResult.Content;
                            }
                        }
                    }

                    response.Content = items;
                }
            }
            catch (Exception e)
            {
                var messaage = $@"Unable to retrieve sales records.";
                response.AddError(e);
                LogManager.LogError(e, messaage);
                Console.WriteLine(e);
            }

            return(response);
        }
        public async Task <GetResponse <IReadOnlyList <ISales> > > GetAllSalesAsync(int auditId, int entityId, int locationId, SalesPeriodType periodType)
        {
            var getResponse = new GetResponse <IReadOnlyList <ISales> >();

            try
            {
                getResponse = await _salesRepository.GetAllSalesAsync(auditId, entityId, periodType);

                if (getResponse.IsSuccessful)
                {
                    getResponse.Content = getResponse.Content
                                          .Where(s => s.LocationId == locationId)
                                          .ToList();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
                getResponse.AddError(ex);
                _logManager.LogError(ex, "Error retrieving saless");
            }

            return(getResponse);
        }
Exemple #4
0
        public async Task <GetResponse <IReadOnlyList <ISales> > > GetAllSalesAsync(int auditId, int entityId, SalesPeriodType periodType)
        {
            var response = new GetResponse <IReadOnlyList <ISales> >();

            try
            {
                using (var connection = ConnectionFactory.GetConnection())
                {
                    var sql = $@"spsAllSales";

                    var results = await connection.QueryAsync <SalesDto>(sql, new { AuditId = auditId, EntityId = entityId }, commandType : CommandType.StoredProcedure);

                    response.Content = results
                                       .Where(dto => dto.PeriodType == (int)periodType)
                                       .Select(dto => dto.ToModel())
                                       .AsList();
                }
            }
            catch (Exception e)
            {
                var messaage = $@"Unable to retrieve sales records.";
                response.AddError(e);
                LogManager.LogError(e, messaage);
                Console.WriteLine(e);
            }

            return(response);
        }