Ejemplo n.º 1
0
        public static List <Transaction> GetTransactions(string sourceFilePath, string accountMappingPath)
        {
            List <AccountMapping> listofAccountMappings = ProcessAccountMapping.GetAccountMappings(accountMappingPath);

            return(File.ReadAllLines(sourceFilePath)
                   .Skip(1)
                   .Select(s =>
            {
                var str = s.Split(',');
                return new Transaction
                {
                    id = str[0],
                    loadDate = str[1],
                    iban = str[2],
                    companyCode = listofAccountMappings.Where(a => a.iban == str[2]).Select(a => a.companyCode).First(),
                    fixedGLAccountNumber = listofAccountMappings.Where(a => a.iban == str[2]).Select(a => a.fixedGLAccountNumber).First(),
                    documentCode = listofAccountMappings.Where(a => a.iban == str[2]).Select(a => a.documentCode).First(),
                    statementNumber = str[3],
                    entryDate = str[4],
                    valueDate = str[5],
                    transactionDescription = str[6],
                    amount = str[7],
                    additionaInfo = str[8],
                    glAccountNumber = "NA",
                    codaDescription = ""
                };
            }
                           ).ToList());
        }
Ejemplo n.º 2
0
        public static List <Transaction> GetTransactions(DataTable sourceDataTable, DataTable accountMapping)
        {
            List <AccountMapping> listofAccountMappings = ProcessAccountMapping.GetAccountMappings(accountMapping);

            return(sourceDataTable.AsEnumerable().Select(dr => { return GetTransaction(dr, listofAccountMappings); }).ToList());
        }