public static CashBasisIncomeReport RunReport( DateTimeOffset start, DateTimeOffset end, QuickBooksOnlineClient qboClient, List <int> ignoredCustomerIds) { var salesStart = start.AddDays(-365); var salesEnd = end.AddDays(365); string salesReceiptQuery = $"select * from SalesReceipt Where TxnDate >= '{salesStart:yyyy-MM-dd}' and TxnDate <= '{salesEnd:yyyy-MM-dd}'"; var salesReceipts = qboClient.QueryAll <SalesReceipt>(salesReceiptQuery); var paymentQuery = $"select * from Payment Where TxnDate >= '{salesStart:yyyy-MM-dd}' and TxnDate <= '{salesEnd:yyyy-MM-dd}'"; var payments = qboClient.QueryAll <Payment>(paymentQuery); payments = payments .Where(x => x.MetaData.CreateTime >= start && x.MetaData.CreateTime < end.AddDays(1) && !ignoredCustomerIds.Select(y => y.ToString()).Contains(x.CustomerRef.Value) ) .ToList(); salesReceipts = salesReceipts .Where(x => x.MetaData.CreateTime >= start && x.MetaData.CreateTime < end.AddDays(1) && !ignoredCustomerIds.Select(y => y.ToString()).Contains(x.CustomerRef.Value) ) .ToList(); return(new CashBasisIncomeReport { Payments = payments, SalesReceipts = salesReceipts }); }
public void Run(APIGatewayProxyRequest request, APIGatewayProxyResponse response, FinanceUser user) { var dbClient = new AmazonDynamoDBClient(); var qboDbClient = new DatabaseClient <QuickBooksOnlineConnection>(dbClient, new ConsoleLogger()); var qboClient = new QuickBooksOnlineClient(PrivateAccounting.Constants.LakelandMiPuebloRealmId, qboDbClient, new ConsoleLogger()); var vendorDataClient = new DatabaseClient <Vendor>(dbClient, new ConsoleLogger()); var vendor = vendorDataClient.Get(new Vendor { Id = request.QueryStringParameters["id"] }).Result; var start = request.QueryStringParameters["start"]; var end = request.QueryStringParameters["end"]; var invoices = qboClient.QueryAll <Invoice>($"select * from Invoice where CustomerRef = '{vendor.QuickBooksOnlineId}' and TxnDate >= '{start}' and TxnDate <= '{end}' ORDERBY TxnDate DESC"); invoices.AddRange(qboClient.QueryAll <Invoice>($"select * from Invoice where CustomerRef = '{vendor.QuickBooksOnlineId}' and TxnDate < '{start}' and Balance > '0' ORDERBY TxnDate DESC")); response.Body = JsonConvert.SerializeObject(invoices); }
public void Run(APIGatewayProxyRequest request, APIGatewayProxyResponse response, FinanceUser user) { var databaseClient = new DatabaseClient <QuickBooksOnlineConnection>(new AmazonDynamoDBClient(), new ConsoleLogger()); var qboClient = new QuickBooksOnlineClient(PrivateAccounting.Constants.LakelandMiPuebloRealmId, databaseClient, new ConsoleLogger()); var customers = qboClient.QueryAll <Customer>("select * from customer"); response.Body = JsonConvert.SerializeObject(customers); }
public void Run(APIGatewayProxyRequest request, APIGatewayProxyResponse response, FinanceUser user) { var receipt = JsonConvert.DeserializeObject <Receipt>(request.Body); var dbClient = new AmazonDynamoDBClient(); var logger = new ConsoleLogger(); var receiptDbClient = new DatabaseClient <ReceiptSaveResult>(dbClient, logger); var spotReservationDbClient = new DatabaseClient <SpotReservation>(dbClient, logger); var vendorDbClient = new DatabaseClient <Vendor>(dbClient, logger); var qboClient = new QuickBooksOnlineClient(PrivateAccounting.Constants.LakelandMiPuebloRealmId, new DatabaseClient <QuickBooksOnlineConnection>(dbClient, logger), logger); var allActiveCustomers = qboClient .QueryAll <Customer>("select * from customer") .ToDictionary(x => x.Id); var activeVendors = new ActiveVendorSearch() .GetActiveVendors(allActiveCustomers, vendorDbClient) .ToList(); var spotClient = new DatabaseClient <Spot>(dbClient, logger); var spotReservationCheck = new SpotReservationCheck(spotClient, spotReservationDbClient, activeVendors, allActiveCustomers); var validation = new ReceiptValidation(spotReservationCheck).Validate(receipt).Result; if (validation.Any()) { response.StatusCode = 400; response.Body = new JObject { { "error", JArray.FromObject(validation) } }.ToString(); return; } var taxRate = new Tax().GetTaxRate(qboClient, PropertyRentalManagement.Constants.QUICKBOOKS_RENTAL_TAX_RATE); var cardPayment = new CardPayment(logger, Configuration.CLOVER_MI_PUEBLO_PRIVATE_TOKEN); var receiptService = new ReceiptSave(receiptDbClient, qboClient, taxRate, spotReservationDbClient, logger, cardPayment); string customerId = receipt.Customer.Id; if (string.IsNullOrWhiteSpace(customerId)) { var customer = new Customer { DisplayName = receipt.Customer.Name }; customer = qboClient.Create(customer); customerId = customer.Id.ToString(); } var vendor = activeVendors.FirstOrDefault(x => x.QuickBooksOnlineId.GetValueOrDefault().ToString() == customerId) ?? vendorDbClient.Create(VendorService.CreateModel(int.Parse(customerId), null, null, null)); receipt.Id = string.IsNullOrWhiteSpace(receipt.Id) ? Guid.NewGuid().ToString() : receipt.Id; // Needed until UI is deployed. var receiptResult = receiptService.SaveReceipt(receipt, customerId, user.FirstName, user.LastName, user.Email, vendor, IpLookup.GetIp(request)); response.Body = JsonConvert.SerializeObject(receiptResult); }
public void Run(APIGatewayProxyRequest request, APIGatewayProxyResponse response, FinanceUser user) { List <string> errors = new List <string>(); var dbClient = new AmazonDynamoDBClient(); var logger = new ConsoleLogger(); var spotClient = new DatabaseClient <Spot>(dbClient, logger); var vendorDataClient = new DatabaseClient <Vendor>(dbClient, logger); var databaseClient = new DatabaseClient <QuickBooksOnlineConnection>(dbClient, logger); var qboClient = new QuickBooksOnlineClient(PrivateAccounting.Constants.LakelandMiPuebloRealmId, databaseClient, logger); var vendorUpdates = JsonConvert.DeserializeObject <Vendor>(request.Body); if (vendorUpdates.Memo != null && vendorUpdates.Memo.Length > 4000) { errors.Add("Memo can't exceed 4,000 characters"); } var spotReservationDbClient = new DatabaseClient <SpotReservation>(dbClient, logger); var allActiveCustomers = qboClient .QueryAll <Customer>("select * from customer") .ToDictionary(x => x.Id); var allActiveVendors = new ActiveVendorSearch() .GetActiveVendors(allActiveCustomers, vendorDataClient) .ToList(); var spotReservationCheck = new SpotReservationCheck(spotClient, spotReservationDbClient, allActiveVendors, allActiveCustomers); ZonedClock easternClock = SystemClock.Instance.InZone(Configuration.LakeLandMiPuebloTimeZone); LocalDate easternToday = easternClock.GetCurrentDate(); while (easternToday.DayOfWeek != IsoDayOfWeek.Sunday) { easternToday = easternToday.PlusDays(1); } string easternRentalDate = easternToday.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture); errors.AddRange(spotReservationCheck.GetSpotConflicts(vendorUpdates.Spots, easternRentalDate, vendorUpdates.Id).Result); if (errors.Any()) { response.StatusCode = 400; response.Body = new JObject { { "error", JArray.FromObject(errors) } }.ToString(); return; } var updated = vendorDataClient.Update(vendorUpdates); response.Body = JsonConvert.SerializeObject(updated); }
public void Run(APIGatewayProxyRequest request, APIGatewayProxyResponse response, FinanceUser user) { var dbClient = new AmazonDynamoDBClient(); var qboDbClient = new DatabaseClient <QuickBooksOnlineConnection>(dbClient, new ConsoleLogger()); var qboClient = new QuickBooksOnlineClient(PrivateAccounting.Constants.LakelandMiPuebloRealmId, qboDbClient, new ConsoleLogger()); var vendorClient = new DatabaseClient <PropertyRentalManagement.DatabaseModel.Vendor>(dbClient, new ConsoleLogger()); var nonRentalCustomerIds = PropertyRentalManagement.Constants.NonRentalCustomerIds; var allActiveCustomers = qboClient.QueryAll <Customer>("select * from customer") .Where(x => !nonRentalCustomerIds.Contains(x.Id.GetValueOrDefault())) .ToDictionary(x => x.Id); var activeVendors = new ActiveVendorSearch().GetActiveVendors(allActiveCustomers, vendorClient) .ToDictionary(x => x.QuickBooksOnlineId); var newCustomers = allActiveCustomers.Where(x => !activeVendors.ContainsKey(x.Key)); foreach (var newCustomer in newCustomers) { var vendor = VendorService.CreateModel(newCustomer.Key, null, null, null); vendorClient.Create(vendor); activeVendors.Add(vendor.QuickBooksOnlineId, vendor); } var json = new List <CustomerPaymentSettingsModel>(); foreach (var vendor in activeVendors.Values) { var customer = allActiveCustomers[vendor.QuickBooksOnlineId]; json.Add(new CustomerPaymentSettingsModel { Id = vendor.Id, QuickBooksOnlineId = vendor.QuickBooksOnlineId, PaymentFrequency = vendor.PaymentFrequency, RentPrice = vendor.RentPrice, Memo = vendor.Memo, FirstName = customer.GivenName, LastName = customer.FamilyName, DisplayName = customer.DisplayName, Balance = customer.Balance, Spots = vendor.Spots }); } response.Body = JsonConvert.SerializeObject(json); }
public void Run(APIGatewayProxyRequest request, APIGatewayProxyResponse response, FinanceUser user) { var dbClientCore = new AmazonDynamoDBClient(); var logger = new ConsoleLogger(); var spotClient = new DatabaseClient <Spot>(dbClientCore, logger); var spots = spotClient.ScanAll(new ScanRequest(new Spot().GetTable())) .OrderBy(x => x.Section?.Name) .ThenBy(x => x.Name) .ToList(); var qboClient = new QuickBooksOnlineClient(PrivateAccounting.Constants.LakelandMiPuebloRealmId, new DatabaseClient <QuickBooksOnlineConnection>(dbClientCore, logger), logger); var allActiveCustomers = qboClient .QueryAll <Customer>("select * from customer") .ToDictionary(x => x.Id); var allActiveVendors = new ActiveVendorSearch() .GetActiveVendors(allActiveCustomers, new DatabaseClient <Vendor>(dbClientCore, logger)) .ToList(); var spotReservationCheck = new SpotReservationCheck( spotClient, new DatabaseClient <SpotReservation>(dbClientCore, logger), allActiveVendors, allActiveCustomers ); var rentalDate = request.QueryStringParameters.ContainsKey("rentalDate") ? request.QueryStringParameters["rentalDate"] : string.Empty; var validation = ReceiptValidation.GetRentalDateValidation(rentalDate); if (validation.Any()) { response.StatusCode = 400; response.Body = new JObject { { "error", JArray.FromObject(validation) } }.ToString(); return; } validation = new List <string>(); DateTime.TryParseExact(rentalDate, "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out var parsedRentalDate); if (parsedRentalDate - DateTime.UtcNow > TimeSpan.FromDays(91)) // Endpoint is cached. The date constraint prevents denial of service causing the cache to be hit and database hits to plateau quickly. { validation.Add("rentalDate can't be greater than 90 days in the future"); } if (parsedRentalDate - DateTime.UtcNow < TimeSpan.FromDays(-1)) { validation.Add("rentalDate can't be in the past"); } if (validation.Any()) { response.StatusCode = 400; response.Body = new JObject { { "error", JArray.FromObject(validation) } }.ToString(); return; } var jsonResponse = new List <PublicSpot>(); foreach (var spot in spots) { var reservation = spotReservationCheck.GetReservation(spot.Id, rentalDate); int?reservedByQuickBooksOnlineId = 0; if (reservation?.Item1 != null) { reservedByQuickBooksOnlineId = reservation.Item1.QuickBooksOnlineId; } if (reservation?.Item2 != null) { reservedByQuickBooksOnlineId = reservation.Item2.QuickBooksOnlineId; } var publicSpot = new PublicSpot { Id = spot.Id, Name = spot.Name, Section = spot.Section, Right = spot.Right, Bottom = spot.Bottom }; if (reservedByQuickBooksOnlineId.HasValue && allActiveCustomers.TryGetValue(reservedByQuickBooksOnlineId, out var customer)) { publicSpot.ReservedBy = customer.DisplayName; } jsonResponse.Add(publicSpot); } response.Body = JsonConvert.SerializeObject(jsonResponse); }
public void SendToAccounting(DateTime date, ILogging logger) { var databaseClient = new DatabaseClient <QuickBooksOnlineConnection>(new AmazonDynamoDBClient(), logger); var qboClient = new QuickBooksOnlineClient(PrivateAccounting.Constants.LakelandMiPuebloRealmId, databaseClient, logger); var originalMonth = date.Month; var client = new CloverClient( Environment.GetEnvironmentVariable("CLOVER_MI_PUEBLO_CHICKEN_ACCESS_TOKEN"), Environment.GetEnvironmentVariable("CLOVER_MI_PUEBLO_CHICKEN_MERCHANT_ID"), logger ); var restaurantCustomer = qboClient .QueryAll <Customer>($"select * from Customer where Id = '{PrivateAccounting.Constants.LakelandMiPuebloAccountRestaurant}'") .First(); var cashTenderType = client.QueryAll <Tender>($"tenders") .Single(x => string.Equals(x.LabelKey, "com.clover.tender.cash", StringComparison.OrdinalIgnoreCase)); do { var salesReceipts = qboClient.QueryAll <SalesReceipt>( $"select * from SalesReceipt where CustomerRef = '{PrivateAccounting.Constants.LakelandMiPuebloAccountRestaurant}' and TxnDate = '{date:yyyy-MM-dd}'"); if (salesReceipts.Any()) { logger.Log($"Skipping {date:yyyy-MM-dd}, because a sales receipt already exists."); } else { var today = new DateTimeOffset(date).ToUnixTimeMilliseconds(); var tomorrow = new DateTimeOffset(date.AddDays(1)).ToUnixTimeMilliseconds(); var result = client.QueryAll <Payment>($"payments?filter=createdTime>={today}&filter=createdTime<{tomorrow}"); var cashPayments = result.Where(x => x.Tender.Id == cashTenderType.Id).ToList(); var cardPayments = result.Where(x => x.Tender.Id != cashTenderType.Id).ToList(); var cashTotal = GetTotal(cashPayments); var cardTotal = GetTotal(cardPayments); if (cashTotal > 0) { CreateSalesReceipt( qboClient, restaurantCustomer.Id, restaurantCustomer.DefaultTaxCodeRef.Value, PrivateAccounting.Constants.LakelandMiPuebloProductRestaurant, date, GetTotal(cashPayments), "Restaurant sales using cash in Clover Register"); } if (cardTotal > 0) { CreateSalesReceipt( qboClient, restaurantCustomer.Id, restaurantCustomer.DefaultTaxCodeRef.Value, PrivateAccounting.Constants.LakelandMiPuebloProductRestaurant, date, cardTotal, "Restaurant sales using credit card in Clover Register"); } } date = date.AddDays(1); } while (date.Month == originalMonth); }