public HttpResponseMessage PostPurchasesToXero(SearchFilter searchFilter)
        {
            using (DataClassesDataContext context = new DataClassesDataContext())
            {
                try
                {
                    var purchases = context.XEROPurchases(searchFilter.StartDate, searchFilter.EndDate);
                    foreach (var purchase in purchases)
                    {
                        PurchaseToInvoiceViewModelConverter purchaseConverter = new PurchaseToInvoiceViewModelConverter();
                        try
                        {
                            InvoiceViewModel invoiceViewModel = purchaseConverter.Convert(purchase);
                            purchasesToPostList.Add(invoiceViewModel);
                        }
                        catch (InvoiceValidationException e)
                        {
                            ModelStateDictionary dictionary = errorStringConvertor.Convert(e.Message);
                            return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, e.Message);
                        }
                        catch (SupplierDoesNotExistException e)
                        {
                            ModelStateDictionary dictionary = errorStringConvertor.Convert(e.Message);
                            return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, e.Message);
                        }
                    }
                }
                catch (System.Data.SqlClient.SqlException)
                {
                    ModelStateDictionary dictionary = errorStringConvertor.Convert("To many Purchases in daterange");
                    return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, dictionary);
                }
            }
            try
            {
                xeroLogic.ExportInvoices(purchasesToPostList);
            }
            catch (XeroApiLimitException e)
            {
                ModelStateDictionary dictionary = errorStringConvertor.Convert(e.Message);
                return this.Request.CreateErrorResponse(HttpStatusCode.BadGateway, dictionary);
            }
            catch (XeroException e)
            {
                ModelStateDictionary dictionary = errorStringConvertor.Convert(e.Message);
                return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, dictionary);
            }
            catch (XeroApiValidationException e)
            {
                ModelStateDictionary dictionary = errorStringConvertor.Convert(e.Message);
                return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, dictionary);
            }
            catch (Exception)
            {
                ModelStateDictionary dictionary = errorStringConvertor.Convert("Something went wrong. Please check the data and try again.");
                return this.Request.CreateErrorResponse(HttpStatusCode.InternalServerError, dictionary);
            }

            return this.Request.CreateResponse(HttpStatusCode.OK);
        }
コード例 #2
0
        public HttpResponseMessage GetCustomers(SearchFilter searchFilter)
        {
            List<CustomerViewModel> resultList = new List<CustomerViewModel>();
            using (DataClassesDataContext context = new DataClassesDataContext())
            {
                var customers = (from cu in context.CUSTOMERs.Where(cu => cu.DBTimeStamp >= searchFilter.StartDate
                    && cu.DBTimeStamp <= searchFilter.EndDate)
                                 select new CustomerViewModel()
                                     {
                                         customerId = cu.CUSTOMER_ID,
                                         firstname = cu.fname,
                                         lastname = cu.sname,
                                         email = cu.email,
                                         address1 = cu.address1,
                                         address2 = cu.address2,
                                         address3 = cu.address3,
                                         clubNumber = cu.club_no ?? 0,
                                         balance = cu.balance ?? 0
                                     }
                                 ).Take(1000);

                resultList = customers.ToList();
                return this.Request.CreateResponse(HttpStatusCode.OK, resultList);
            }
        }
コード例 #3
0
        public HttpResponseMessage GetPayment(SearchFilter searchFilter)
        {
            List<PaymentViewModel> resultList = new List<PaymentViewModel>();
            using (DataClassesDataContext context = new DataClassesDataContext())
            {
                try
                {
                    var payments = context.XEROPayments(searchFilter.StartDate, searchFilter.EndDate);

                    foreach (var payment in payments)
                    {
                        PaymentViewModel paymentViewModel = new PaymentViewModel()
                        {
                            InvoiceNumber = payment.InvoiceNumber,
                            ContactName = payment.ContactName,
                            Email = payment.EmailAddress,
                            Address1 = payment.POAddressLine1,
                            Address2 = payment.POAddressLine2,
                            Address3 = payment.POAddressLine3,
                            City = payment.POCity,
                            Region = payment.PORegion,
                            Country = payment.POCountry,
                            PostalCode = payment.POPostalCode,
                            InvoiceDate = payment.InvoiceDate.GetValueOrDefault().ToString("dd-MM-yy"),
                            DueDate = payment.DueDate.GetValueOrDefault().ToString("dd-MM-yy"),
                            InventoryItemCode = payment.InventoryItemCode.ToString(),
                            Description = payment.Description,
                            Quantity = payment.Quantity.ToString(),
                            UnitAmount = payment.UnitAmount.ToString(),
                            Discount = payment.Discount.ToString(),
                            AccountCode = payment.AccountCode.ToString(),
                            TaxType = payment.TaxType,
                            TrackingName = payment.TrackingName1,
                            TrackingOption = payment.TrackingOption1,
                            Reference = payment.Reference,
                            BrandingTheme = payment.BrandingTheme
                        };

                        resultList.Add(paymentViewModel);
                    }
                }
                catch (System.Data.SqlClient.SqlException)
                {
                    ModelStateDictionary dictionary = errorStringConvertor.Convert("To many payments in daterange");
                    return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, dictionary);
                }

                return this.Request.CreateResponse(HttpStatusCode.OK, resultList);
            }
        }
コード例 #4
0
        public HttpResponseMessage GetSuppliers(SearchFilter searchFilter)
        {
            List<SupplierViewModel> resultList = new List<SupplierViewModel>();
            using (DataClassesDataContext context = new DataClassesDataContext())
            {
                var suppliers = (from sp in context.SUPPLIERs.Where(sp => sp.DBTimeStamp >= searchFilter.StartDate
                    && sp.DBTimeStamp <= searchFilter.EndDate)
                                 select new SupplierViewModel()
                                 {
                                     supplierCode = sp.supplier1,
                                     name = sp.name,
                                     email = sp.email,
                                     phone = sp.phone,

                                 }
                                 );

                resultList = suppliers.ToList();
                return this.Request.CreateResponse(HttpStatusCode.OK, resultList);
            }
        }
        public void whenAXeroApiValidationExceptionIsThrownThenABadRequestIsReturned()
        {
            List<InvoiceViewModel> tesInvoiceViewModel = new List<InvoiceViewModel>();

            var IXEROLogicMock = new Mock<IExportingInvoicesToXEROLogic>();
            IXEROLogicMock.Setup(xl => xl.ExportInvoices(It.IsAny<List<InvoiceViewModel>>())).Throws(new XeroApiValidationException());

            xeroWebAPIController.XeroLogic = IXEROLogicMock.Object;

            xeroWebAPIController.Request = new HttpRequestMessage();
            xeroWebAPIController.Configuration = new HttpConfiguration();

            DateTime startDate = new DateTime(2010, 1, 1);
            DateTime endDate = new DateTime(2014, 09, 28);
            SearchFilter searchFilter = new SearchFilter();
            searchFilter.StartDate = startDate;
            searchFilter.EndDate = endDate;
            HttpResponseMessage response = xeroWebAPIController.PostPurchasesToXero(searchFilter);

            IXEROLogicMock.Verify(x => x.ExportInvoices(It.IsAny<List<InvoiceViewModel>>()), Times.Once());
            Assert.AreEqual(response.StatusCode, HttpStatusCode.BadRequest);
        }
コード例 #6
0
        public HttpResponseMessage GetPurchases(SearchFilter searchFilter)
        {
            List<PurchaseViewModel> resultList = new List<PurchaseViewModel>();
            using (DataClassesDataContext context = new DataClassesDataContext())
            {
                try
                {
                    var purchases = context.XEROPurchases(searchFilter.StartDate, searchFilter.EndDate);

                    foreach (var purchase in purchases)
                    {
                        PurchaseViewModel purchaseViewModel = new PurchaseViewModel()
                        {
                            InvoiceNumber = purchase.InvoiceNumber,
                            EmailAddress = purchase.EmailAddress,
                            Address1 = purchase.POAddressLine1,
                            Address2 = purchase.POAddressLine2,
                            Address3 = purchase.POAddressLine3,
                            Address4 = purchase.POAddressLine4,
                            City = purchase.POCity,
                            Region = purchase.PORegion,
                            Country = purchase.POCountry,
                            PostalCode = purchase.POPostalCode,
                            InvoiceDate = purchase.InvoiceDate.GetValueOrDefault().ToString("dd-MM-yy"),
                            DueDate = purchase.DueDate.GetValueOrDefault().ToString("dd-MM-yy"),
                            InventoryItemCode = purchase.InventoryItemCode.ToString(),
                            Description = purchase.Description,
                            Quantity = purchase.Quantity.ToString(),
                            UnitAmount = purchase.UnitAmount.ToString(),
                            AccountCode = purchase.AccountCode.ToString(),
                            TaxType = purchase.TaxType,
                            TrackingName = purchase.TrackingName1,
                            TrackingOption = purchase.TrackingOption1,
                            Currency = purchase.Currency,

                        };

                        try
                        {
                            purchaseViewModel.ContactName = getSupplierName(purchase.ContactName);
                        }
                        catch(PurchaseValidationException e)
                        {
                            ModelStateDictionary dictionary = errorStringConvertor.Convert(e.Message);
                            return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, dictionary);
                        }
                        catch (SupplierDoesNotExistException e )
                        {
                            ModelStateDictionary dictionary = errorStringConvertor.Convert(e.Message);
                            return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, dictionary);
                        }

                        resultList.Add(purchaseViewModel);
                    }
                }
                catch (System.Data.SqlClient.SqlException)
                {
                    ModelStateDictionary dictionary = errorStringConvertor.Convert("To many invoices in daterange");
                    return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, dictionary);
                }

                return this.Request.CreateResponse(HttpStatusCode.OK, resultList);
            }
        }
        public void whenPostPurchasesToXeroWithValidDatesIsCalledAThenHttpStatusCodeOkIsReturned()
        {
            List<InvoiceViewModel> tesInvoiceViewModel = new List<InvoiceViewModel>();

            var IXEROLogicMock = new Mock<IExportingInvoicesToXEROLogic>();
            IXEROLogicMock.Setup(xl => xl.ExportInvoices(It.IsAny<List<InvoiceViewModel>>())).Returns(tesInvoiceViewModel);

            xeroWebAPIController.XeroLogic = IXEROLogicMock.Object;

            xeroWebAPIController.Request = new HttpRequestMessage();
            xeroWebAPIController.Configuration = new HttpConfiguration();

            DateTime startDate = new DateTime(2015, 3, 12);
            DateTime endDate = new DateTime(2015, 09, 28);
            SearchFilter searchFilter = new SearchFilter();
            searchFilter.StartDate = startDate;
            searchFilter.EndDate = endDate;
            HttpResponseMessage response = xeroWebAPIController.PostPurchasesToXero(searchFilter);

            IXEROLogicMock.Verify(x => x.ExportInvoices(It.IsAny<List<InvoiceViewModel>>()), Times.Once());
            Assert.AreEqual(response.StatusCode, HttpStatusCode.OK);
        }
コード例 #8
0
        public HttpResponseMessage GetInvoice(SearchFilter searchFilter)
        {
            List<InvoiceFrontEndViewModel> resultList = new List<InvoiceFrontEndViewModel>();
            using (DataClassesDataContext context = new DataClassesDataContext())
            {
                try
                {
                    var invoices = context.AccountSalesService(searchFilter.StartDate, searchFilter.EndDate);

                    foreach (var invoice in invoices)
                    {
                        string customerName = "";
                        try
                        {
                            customerName = getCustomerName(invoice.ContactName);
                        }
                        catch (CustomerDoesNotExistException e)
                        {
                            ModelStateDictionary dictionary = errorStringConvertor.Convert(e.Message);
                            return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, dictionary);
                        }
                        InvoiceFrontEndViewModel invoiceViewModel = new InvoiceFrontEndViewModel()
                        {
                            InvoiceNumber = invoice.InvoiceNumber,

                            ContactName = getCustomerName(invoice.ContactName),
                            Email = invoice.EmailAddress,
                            Address1 = invoice.POAddressLine1,
                            Address2 = invoice.POAddressLine2,
                            Address3 = invoice.POAddressLine3,
                            City = invoice.POCity,
                            Region = invoice.PORegion,
                            Country = invoice.POCountry,
                            PostalCode = invoice.POPostalCode,
                            InvoiceDate = invoice.InvoiceDate.GetValueOrDefault().ToString("dd-MM-yy"),
                            DueDate = invoice.DueDate.GetValueOrDefault().ToString("dd-MM-yy"),
                            InventoryItemCode = invoice.InventoryItemCode.ToString(),
                            Description = invoice.Description,
                            Quantity = invoice.Quantity.ToString(),
                            UnitAmount = invoice.UnitAmount.ToString(),
                            Discount = invoice.Discount.ToString(),
                            AccountCode = invoice.AccountCode.ToString(),
                            TaxType = invoice.TaxType,
                            TrackingName = invoice.TrackingName1,
                            TrackingOption = invoice.TrackingOption1,
                            Currency = "NZD",
                            BrandingTheme = invoice.BrandingTheme
                        };

                        resultList.Add(invoiceViewModel);
                    }
                }
                catch (System.Data.SqlClient.SqlException)
                {
                    ModelStateDictionary dictionary = errorStringConvertor.Convert("To many invoices in daterange");
                    return this.Request.CreateErrorResponse(HttpStatusCode.BadRequest, dictionary);
                }

                return this.Request.CreateResponse(HttpStatusCode.OK, resultList);
            }
        }