Пример #1
0
        public IList <Invoice> Handle(GetInvoices message)
        {
            const string queryTemplate = @"
                SELECT 
                    i.*,
                    u.*,
                    c.*
                FROM Accounting.Invoice i
                JOIN Users.[User] u ON i.CreatedById = u.Id
                JOIN Companies.Company c ON i.CompanyId = c.Id
                WHERE
                    (@IsCompanyIdDefault = 1 AND @InvoiceNumber IS NULL) OR
                    ((@IsCompanyIdDefault = 0 AND i.CompanyID = @CompanyID) {CompOper}
                    (@InvoiceNumber IS NOT NULL AND i.InvoiceNumber = @InvoiceNumber))";

            var query = queryTemplate.Replace("{CompOper}", message.SearchOption.ToSqlOperator());
            Func <Invoice, User, Company, Invoice> mapper = (invoice, user, company) =>
            {
                invoice.CreatedBy = user;
                invoice.Company   = company;

                return(invoice);
            };

            return(_UnitOfWork.Query(query, mapper, new
            {
                IsCompanyIdDefault = message.CompanyId == default(Guid) ? 1 : 0,
                message.CompanyId,
                message.InvoiceNumber
            }).ToList());
        }
        public async Task <ActionResult <Invoice[]> > Get(string customer = null, int skip = 0, int take = 10)
        {
            try
            {
                var request = new GetInvoices {
                    Customer = customer, Skip = skip, Take = take
                };

                var invoices = await _useCases.Invoke <Invoice[]>(request);

                return(Ok(invoices));
            }
            catch (Exception ex)
            {
                _logger.LogError(ex, "Error getting invoices");

                while (ex.InnerException != null)
                {
                    ex = ex.InnerException;
                }

                return(StatusCode(500, new { message = ex.Message, details = ex.StackTrace }));
            }
        }
Пример #3
0
 public async Task <Invoice[]> Invoke(GetInvoices request)
 {
     return(await _repository.GetInvoices(request.Customer, request.Skip, request.Take));
 }