コード例 #1
0
        public Tax ValidateItem(Tax tax)
        {
            decimal amount;
            var invalid = new InvalidTax(tax);
            var valid = new ValidTax(tax);

            if (tax == null)
                return invalid;

            if (string.IsNullOrEmpty(tax.Account))
            {
                invalid.AccountMessage = "Account field is empty";
                return invalid;
            }

            if (string.IsNullOrEmpty(tax.Description))
            {
                invalid.DescriptionMessage = "Description field is empty";
                return invalid;
            }

            if (string.IsNullOrEmpty(tax.CurrencyCode))
            {
                invalid.CurrencyCodeMessage = "Currency Code field is empty";
                return invalid;
            }

            if (string.IsNullOrEmpty(tax.Amount))
            {
                invalid.AmountMessage = "Amount field is empty";
                return invalid;
            }

            var currency = Iso4217Lookup.LookupByCode(tax.CurrencyCode);
            if (!currency.Found)
            {
                invalid.CurrencyCodeMessage = "Currency Code value is invalid:" +
                                               "must be a valid ISO 4217 currency code ";
                return invalid;
            }

            if (!decimal.TryParse(tax.Amount, out amount))
            {
                invalid.CurrencyCodeMessage = "Amount value is invalid:" +
                                                "must be a valid number";
                return invalid;
            }

            return valid;
        }
コード例 #2
0
        public IEnumerable<Tax> Parse(string path)
        {
            string line;
            var taxes = new List<Tax>();

            using (var file = new StreamReader(path))
            {
                file.ReadLine();
                while ((line = file.ReadLine()) != null)
                {
                    var tax = new Tax();
                    var values = line.Split(',');

                    if (values.Length > 0)
                        tax.Account = values[0].Trim();

                    if (values.Length > 1)
                        tax.Description = values[1].Trim();

                    if (values.Length > 2)
                        tax.CurrencyCode = values[2].Trim();

                    if (values.Length > 3)
                    {
                        decimal amount;
                        decimal.TryParse(values[3], out amount);
                        tax.Amount = values[3];
                    }

                    taxes.Add(tax);
                }

                file.Close();
            }

            return taxes;
        }
コード例 #3
0
        public IEnumerable<Tax> Parse(string path)
        {
            var taxes = new List<Tax>();
            using (var stream = File.Open(path, FileMode.Open, FileAccess.Read))
            {
                IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
                excelReader.Read();

                while (excelReader.Read())
                {
                    var tax = new Tax();

                    tax.Account = excelReader.GetString(0);
                    tax.Description = excelReader.GetString(1);
                    tax.CurrencyCode = excelReader.GetString(2);
                    tax.Amount = excelReader.GetString(3);

                    if (!string.IsNullOrEmpty(tax.Account))
                        tax.Account.Trim();

                    if (!string.IsNullOrEmpty(tax.Description))
                        tax.Description.Trim();

                    if (!string.IsNullOrEmpty(tax.CurrencyCode))
                        tax.CurrencyCode.Trim();

                    if (!string.IsNullOrEmpty(tax.Amount))
                        tax.Amount.Trim();

                    taxes.Add(tax);
                }

                excelReader.Close();
            }

            return taxes;
        }
コード例 #4
0
 public bool Update(Tax tax)
 {
     return _repository.Update(tax);
 }