public void ThreeNumTest() { Assert.AreEqual("sto dwadzieœcia dziewiêæ z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("129")); Assert.AreEqual("trzysta piêtnaœcie z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("315")); Assert.AreEqual("osiemset piêædziesi¹t cztery z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("854")); Assert.AreEqual("dziewiêæset dziewiêædziesi¹t dziewiêæ z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("999")); }
private void FillInWorksheetWithData(ref Worksheet worksheet, InputCompany inputCompany, WhiteListVerResult whiteListVerResult) { if (inputCompany.NoteID.Length < 4) // means that only number is given { ((Range)worksheet.Cells[3, 1]).Formula = string.Format($"nr {inputCompany.NoteID}/{DateTime.Now.Month}/{DateTime.Now.Year}"); } else //means that the full number was given in the input file { ((Range)worksheet.Cells[3, 1]).Formula = string.Format($"nr {inputCompany.NoteID}"); } if (string.IsNullOrEmpty(inputCompany.NoteDate)) { ((Range)worksheet.Cells[3, 9]).Formula = DateTime.Now.ToString("dd.MM.yyyyr."); } else { ((Range)worksheet.Cells[3, 9]).Formula = string.Format($"{inputCompany.NoteDate}"); } ((Range)worksheet.Cells[4, 9]).Formula = GetPaymentPeriod(inputCompany.NoteTitle); string fullNameWithAbbr = FormatHelper.AbbreviateFullNameOfCompany(whiteListVerResult.FullName); fullNameWithAbbr = fullNameWithAbbr.Replace("\"", string.Empty); int numOfLinesForFullNames = 1 + (fullNameWithAbbr.Length / _maxLengthOfLineInFile); for (int j = 0; j < numOfLinesForFullNames; j++) { string temp = fullNameWithAbbr.Substring(j * _maxLengthOfLineInFile); temp = temp.Substring(0, Math.Min(_maxLengthOfLineInFile, temp.Length)).Trim(); ((Range)worksheet.Cells[8 + j, 8]).Formula = temp; } string addressFull = string.IsNullOrEmpty(whiteListVerResult.FullResidenceAddress) ? whiteListVerResult.FullWorkingAddress : whiteListVerResult.FullResidenceAddress; addressFull = string.Concat(AddressHelper.GetStreetPrefix(addressFull), _space, addressFull).Trim(); addressFull = addressFull.Replace(_colon, string.Empty); int addressDivIndex = _postalCodePattern.Match(addressFull).Index; ((Range)worksheet.Cells[8 + numOfLinesForFullNames, 8]).Formula = addressFull.Substring(0, addressDivIndex).Trim(); ((Range)worksheet.Cells[9 + numOfLinesForFullNames, 8]).Formula = addressFull.Substring(addressDivIndex).Trim(); ((Range)worksheet.Cells[14, 9]).Formula = whiteListVerResult.Nip.Insert(3, _space).Insert(6, _space).Insert(9, _space); ((Range)worksheet.Cells[17, 9]).Formula = FormatHelper.GetAccountNumberInString(whiteListVerResult.GivenAccountNumber); ((Range)worksheet.Cells[21, 9]).Formula = inputCompany.NoteNettoAmount; ((Range)worksheet.Cells[24, 3]).Formula = inputCompany.NoteTitle; string nettoAmountStr = inputCompany.NoteNettoAmount.Replace(_dot, _colon); double nettoAmount = double.Parse(nettoAmountStr); double vatAmout = Math.Round(0.08 * nettoAmount, 2); ((Range)worksheet.Cells[36, 3]).Formula = NumberToWordsConverter.ConvertNumberToAmountPln((nettoAmount + vatAmout).ToString()); }
public void FourDigitNumTest() { Assert.AreEqual("jeden tysi¹c dwieœcie trzydzieœci trzy z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("1233")); Assert.AreEqual("dwa tysi¹ce trzysta trzy z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("2303")); Assert.AreEqual("szeœæ tysiêcy trzynaœcie z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("6013")); Assert.AreEqual("piêæ tysiêcy dwieœcie dwadzieœcia osiem z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("5228")); Assert.AreEqual("trzy tysi¹ce sto z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("3100")); }
public void TeenstNumTest() { Assert.AreEqual("dziesiêæ z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("10")); Assert.AreEqual("jedenaœcie z³otych 89/100", NumberToWordsConverter.ConvertNumberToAmountPln("11,89")); Assert.AreEqual("dwanaœcie z³otych 87/100", NumberToWordsConverter.ConvertNumberToAmountPln("12.87")); Assert.AreEqual("trzynaœcie z³otych 76/100", NumberToWordsConverter.ConvertNumberToAmountPln("13.76")); Assert.AreEqual("dziewiêtnaœcie z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("19")); }
public void SiXDigitNumTest() { Assert.AreEqual("sto dwadzieœcia jeden tysiêcy dwieœcie czterdzieœci piêæ z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("121245")); Assert.AreEqual("trzysta dwa tysi¹ce trzy z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("302003")); Assert.AreEqual("piêæset tysiêcy jedenaœcie z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("500011")); Assert.AreEqual("dziewiêæset jedenaœcie tysiêcy trzynaœcie z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("911013")); Assert.AreEqual("sto tysiêcy z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("100000")); Assert.AreEqual("sto dwa tysi¹ce dwieœcie dwa z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("102202")); }
public void FiveDigitNumTest() { Assert.AreEqual("jedenaœcie tysiêcy dwieœcie czterdzieœci cztery z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("11244")); Assert.AreEqual("dwadzieœcia dwa tysi¹ce czterysta jeden z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("22401")); Assert.AreEqual("piêædziesi¹t szeœæ tysiêcy czternaœcie z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("56014")); Assert.AreEqual("trzydzieœci jeden tysiêcy z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("31000")); Assert.AreEqual("dwadzieœcia tysiêcy trzy z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("20003")); Assert.AreEqual("dziesiêæ tysiêcy czterysta piêædziesi¹t szeœæ z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("10456")); }
public void OneDigitNumTest() { Assert.AreEqual("jeden z³oty 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("1")); Assert.AreEqual("piêæ z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("5")); Assert.AreEqual("dziewiêæ z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("9")); Assert.AreEqual("dziewiêæ z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("9,00")); Assert.AreEqual("trzy z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("3")); Assert.AreEqual("trzy z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("3.00")); }
public void TwoDigitNumTest() { Assert.AreEqual("dwadzieœcia jeden z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("21")); Assert.AreEqual("trzydzieœci dwa z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("32")); Assert.AreEqual("czterdzieœci cztery z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("44")); Assert.AreEqual("piêædziesi¹t piêæ z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("55")); Assert.AreEqual("szeœædziesi¹t szeœæ z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("66")); Assert.AreEqual("szeœædziesi¹t z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("60")); Assert.AreEqual("siedemdziesi¹t trzy z³ote 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("73")); Assert.AreEqual("osiemdziesi¹t siedem z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("87")); Assert.AreEqual("dziewiêædziesi¹t osiem z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("98")); Assert.AreEqual("dwadzieœcia dwa z³ote 34/100", NumberToWordsConverter.ConvertNumberToAmountPln("22.34")); }
public void ZeroTest() { Assert.AreEqual("zero z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("0")); }