private void Upload(AccountBookDto entry, string url) { var httpWebRequest = (HttpWebRequest)WebRequest.Create(url); httpWebRequest.ContentType = "application/json"; httpWebRequest.Method = "POST"; using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream())) { var entryAsJson = JsonConvert.SerializeObject(entry); streamWriter.Write(entryAsJson); } var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse(); using (var streamReader = new StreamReader(httpResponse.GetResponseStream())) { var result = streamReader.ReadToEnd(); Console.WriteLine(result); } }
public IList <AccountBookDto> Parse(string fileName, string user) { XSSFWorkbook wb; using (FileStream file = new FileStream(fileName, FileMode.Open, FileAccess.Read)) { wb = new XSSFWorkbook(file); } var accountBookEntries = new List <AccountBookDto>(); for (int i = 1; i < wb.NumberOfSheets; i++) { var sheet = wb.GetSheetAt(i); if (sheet != null) { DateTime lastValidBookingDate = new DateTime(); for (int row = StartRow; row <= sheet.LastRowNum; row++) { var currentRow = sheet.GetRow(row); if (currentRow == null) { continue; } var cell = user == "Alexander" ? StartColumnAlexander : StartColumnVerena; double?amount = null; string incomeExpense = string.Empty; // Booking Date var bookingDate = currentRow.GetCell(cell, MissingCellPolicy.CREATE_NULL_AS_BLANK).DateCellValue; if (bookingDate == null || bookingDate.Year == 0001) { bookingDate = lastValidBookingDate; } else { lastValidBookingDate = bookingDate; } // Title cell++; var title = currentRow.GetCell(cell, MissingCellPolicy.CREATE_NULL_AS_BLANK).StringCellValue; if (string.IsNullOrEmpty(title)) { // Ignore rows with empty title continue; } // Expense cell++; var expense = currentRow.GetCell(cell, MissingCellPolicy.CREATE_NULL_AS_BLANK).NumericCellValue; if (expense != 0) { amount = Math.Round(expense, 2); incomeExpense = "E"; } // Income cell++; var income = currentRow.GetCell(cell, MissingCellPolicy.CREATE_NULL_AS_BLANK).NumericCellValue; if (income != 0) { amount = Math.Round(income, 2);; incomeExpense = "I"; } // Voucher Expense cell++; // Voucher Income cell++; // Record Type cell++; var recordType = currentRow.GetCell(cell, MissingCellPolicy.CREATE_NULL_AS_BLANK).StringCellValue; if (recordType == "*" || recordType == "X") { // Ignore old voucher and special investment incomes and expenses continue; } if (bookingDate.Date >= new DateTime(2013, 01, 01).Date&& bookingDate.Date <= new DateTime(2015, 05, 31).Date) { // Map record types A --> M and M --> F for entries starting from 2013 and ending in May 2014 var newRecordType = recordType; if (recordType == "A") { newRecordType = "M"; } if (recordType == "M") { newRecordType = "F"; } recordType = newRecordType; } var accountBookDto = new AccountBookDto() { User = user, BookingDate = bookingDate, Title = title, Amount = amount.GetValueOrDefault(), IncomeExpense = incomeExpense, RecordType = recordType }; accountBookEntries.Add(accountBookDto); Console.WriteLine(accountBookDto); } } } return(accountBookEntries); }