Пример #1
0
 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"));
 }
Пример #2
0
        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());
        }
Пример #3
0
 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"));
 }
Пример #4
0
 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"));
 }
Пример #5
0
 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"));
 }
Пример #6
0
 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"));
 }
Пример #7
0
 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"));
 }
Пример #8
0
 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"));
 }
Пример #9
0
 public void ZeroTest()
 {
     Assert.AreEqual("zero z³otych 00/100", NumberToWordsConverter.ConvertNumberToAmountPln("0"));
 }