Exemple #1
0
        public string[] CreateOutput()
        {
            string outputPathAMPFF_HSBC = System.IO.Path.Combine(m_FileOutputFolder, "APSMPFI." + m_VendorCode + "." + m_SubmissionCutOffDateTime.ToString("yyyyMMdd") + ".M50");
            string outputPathAMPFF_HASE = System.IO.Path.Combine(m_FileOutputFolder, "APSMPFI." + m_VendorCode + "." + m_SubmissionCutOffDateTime.ToString("yyyyMMdd") + ".E50");

            string outputPathAMCND_HSBC = System.IO.Path.Combine(m_FileOutputFolder, "APSMPFI." + m_VendorCode + "." + m_SubmissionCutOffDateTime.ToString("yyyyMMdd") + ".M23");
            string outputPathAMCND_HASE = System.IO.Path.Combine(m_FileOutputFolder, "APSMPFI." + m_VendorCode + "." + m_SubmissionCutOffDateTime.ToString("yyyyMMdd") + ".E23");


            HSBCFileExchangeProcess HSBCAMPFFFileExchange = new HSBCFileExchangeProcess();

            HSBCAMPFFFileExchange.FileID      = HSBCFileIDEnum.AMPFF;
            HSBCAMPFFFileExchange.Environment = Environment;
            HSBCAMPFFFileExchange.CreateWriter(outputPathAMPFF_HSBC);

            HSBCFileExchangeProcess HangSengAMPFFFileExchange = new HSBCFileExchangeProcess();

            HangSengAMPFFFileExchange.FileID      = HSBCFileIDEnum.AMPFF;
            HangSengAMPFFFileExchange.Environment = Environment;
            HangSengAMPFFFileExchange.CreateWriter(outputPathAMPFF_HASE);

            HSBCFileExchangeProcess HSBCAMCNDFileExchange = new HSBCFileExchangeProcess();

            HSBCAMCNDFileExchange.FileID      = HSBCFileIDEnum.AMCND;
            HSBCAMCNDFileExchange.Environment = Environment;
            HSBCAMCNDFileExchange.CreateWriter(outputPathAMCND_HSBC);

            HSBCFileExchangeProcess HangSengAMCNDFileExchange = new HSBCFileExchangeProcess();

            HangSengAMCNDFileExchange.FileID      = HSBCFileIDEnum.AMCND;
            HangSengAMCNDFileExchange.Environment = Environment;
            HangSengAMCNDFileExchange.CreateWriter(outputPathAMCND_HASE);

            DBFilter filter = new DBFilter();

            filter.add(new NullTerm("CompanyMPFFileConsolidateDateTime"));
            filter.add(new Match("CompanyMPFFileConfirmDateTime", "<=", m_SubmissionCutOffDateTime));

            ArrayList list = ECompanyMPFFile.db.select(m_dbConn, filter);

            foreach (ECompanyMPFFile mpfFile in list)
            {
                string transactionRefreence = "HREXM" + mpfFile.CompanyMPFFileID.ToString("0000000000");
                transactionRefreence += CheckDigit(transactionRefreence);

                HSBCFileExchangeProcess currentFileProcess = null;

                if (mpfFile.CompanyMPFFileFileType.Equals("AMPFF"))
                {
                    if (mpfFile.CompanyMPFFileTrusteeCode.Equals("HSBC"))
                    {
                        currentFileProcess = HSBCAMPFFFileExchange;
                    }
                    else if (mpfFile.CompanyMPFFileTrusteeCode.Equals("HangSeng"))
                    {
                        currentFileProcess = HangSengAMPFFFileExchange;
                    }

                    EHSBCExchangeProfile exchangeProfile = new EHSBCExchangeProfile();
                    exchangeProfile.HSBCExchangeProfileID = mpfFile.HSBCExchangeProfileID;
                    EHSBCExchangeProfile.db.select(m_dbConn, exchangeProfile);
                    string[] submissionHeader = new string[6];
                    submissionHeader[0] = "S";
                    submissionHeader[1] = exchangeProfile.HSBCExchangeProfileRemoteProfileID.PadRight(18).Substring(0, 18);
                    submissionHeader[2] = string.Empty.PadRight(28);
                    submissionHeader[3] = transactionRefreence.PadRight(16).Substring(0, 16);
                    submissionHeader[4] = "   ";
                    submissionHeader[5] = mpfFile.CompanyMPFFileConfirmDateTime.ToString("yyyyMMddHHmmss");

                    string strSubmissionHeader = string.Join(string.Empty, submissionHeader);
                    if (strSubmissionHeader.Length != currentFileProcess.RecordLength)
                    {
                        throw new Exception("Invalid submission header length");
                    }

                    currentFileProcess.AddLine(strSubmissionHeader);


                    string   currentBankFilePath = System.IO.Path.Combine(m_DefaultBankFilePath, mpfFile.CompanyMPFFileDataFileRelativePath);
                    FileInfo fileInfo            = new System.IO.FileInfo(currentBankFilePath);

                    StreamReader bankFileStream = fileInfo.OpenText();
                    char[]       charRead       = new char[80];

                    try
                    {
                        while (bankFileStream.Read(charRead, 0, 80) > 0)
                        {
                            string line = new string(charRead);
                            currentFileProcess.AddLine(line);
                        }
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                    finally
                    {
                        bankFileStream.Close();
                    }
                }
                else if (mpfFile.CompanyMPFFileFileType.Equals("AMCND"))
                {
                    if (mpfFile.CompanyMPFFileTrusteeCode.Equals("HSBC"))
                    {
                        currentFileProcess = HSBCAMCNDFileExchange;
                    }
                    else if (mpfFile.CompanyMPFFileTrusteeCode.Equals("HangSeng"))
                    {
                        currentFileProcess = HangSengAMCNDFileExchange;
                    }

                    ECompanyDatabase companyDB = new ECompanyDatabase();
                    companyDB.CompanyDBID = mpfFile.CompanyDBID;
                    ECompanyDatabase.db.select(m_dbConn, companyDB);
                    //string[] submissionHeader = new string[7];
                    //submissionHeader[0] = "S";
                    //submissionHeader[1] = companyDB.CompanyDBClientCode.PadRight(18).Substring(0, 18);
                    //submissionHeader[2] = string.Empty.PadRight(28);
                    //submissionHeader[3] = transactionRefreence.PadRight(16).Substring(0, 16);
                    //submissionHeader[4] = "   ";
                    //submissionHeader[5] = mpfFile.CompanyMPFFileConfirmDateTime.ToString("yyyyMMddHHmmss");
                    //submissionHeader[6] = string.Empty.PadRight(1420);

                    //string strSubmissionHeader = string.Join(string.Empty, submissionHeader);
                    //if (strSubmissionHeader.Length != currentFileProcess.RecordLength)
                    //    throw new Exception("Invalid submission header length");

                    //currentFileProcess.AddLine(strSubmissionHeader);


                    string   currentBankFilePath = System.IO.Path.Combine(m_DefaultBankFilePath, mpfFile.CompanyMPFFileDataFileRelativePath);
                    FileInfo fileInfo            = new System.IO.FileInfo(currentBankFilePath);

                    StreamReader bankFileStream = fileInfo.OpenText();

                    try
                    {
                        while (!bankFileStream.EndOfStream)
                        {
                            string line = bankFileStream.ReadLine();
                            if (!line.StartsWith("HEADER "))
                            {
                                currentFileProcess.AddLine(line.PadRight(currentFileProcess.RecordLength));
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                    finally
                    {
                        bankFileStream.Close();
                    }
                }
                if (Environment == HSBCEnvironmentIndicatorEnum.Production)
                {
                    mpfFile.CompanyMPFFileConsolidateDateTime  = AppUtils.ServerDateTime();
                    mpfFile.CompanyMPFFileTransactionReference = transactionRefreence;
                    ECompanyMPFFile.db.update(m_dbConn, mpfFile);
                }
            }
            HSBCAMPFFFileExchange.Close();
            HangSengAMPFFFileExchange.Close();
            HSBCAMCNDFileExchange.Close();
            HangSengAMCNDFileExchange.Close();


            return(new string[] { outputPathAMPFF_HSBC, outputPathAMPFF_HASE, outputPathAMCND_HSBC, outputPathAMCND_HASE });
        }
Exemple #2
0
        public string[] CreateOutput()
        {
            string outputPathHSBC = System.IO.Path.Combine(m_FileOutputFolder, "APSMPFI." + m_VendorCode + "." + m_SubmissionCutOffDateTime.ToString("yyyyMMdd") + ".M60");
            string outputPathHASE = System.IO.Path.Combine(m_FileOutputFolder, "APSMPFI." + m_VendorCode + "." + m_SubmissionCutOffDateTime.ToString("yyyyMMdd") + ".E60");

            HSBCFileExchangeProcess HSBCAutoPayFileExchange = new HSBCFileExchangeProcess();

            HSBCAutoPayFileExchange.FileID      = HSBCFileIDEnum.AISTN;
            HSBCAutoPayFileExchange.Environment = Environment;
            HSBCAutoPayFileExchange.CreateWriter(outputPathHSBC);

            HSBCFileExchangeProcess HangSengAutoPayFileExchange = new HSBCFileExchangeProcess();

            HangSengAutoPayFileExchange.FileID      = HSBCFileIDEnum.AISTN;
            HangSengAutoPayFileExchange.Environment = Environment;
            HangSengAutoPayFileExchange.CreateWriter(outputPathHASE);

            DBFilter filter = new DBFilter();

            filter.add(new NullTerm("CompanyAutopayFileConsolidateDateTime"));
            filter.add(new Match("CompanyAutopayFileConfirmDateTime", "<=", m_SubmissionCutOffDateTime));

            ArrayList list = ECompanyAutopayFile.db.select(m_dbConn, filter);

            foreach (ECompanyAutopayFile autoPayFile in list)
            {
                string transactionRefreence = "HREXA" + autoPayFile.CompanyAutopayFileID.ToString("0000000000");
                transactionRefreence += CheckDigit(transactionRefreence);

                HSBCFileExchangeProcess currentFileProcess = null;
                if (autoPayFile.CompanyAutopayFileBankCode.Equals("004"))
                {
                    currentFileProcess = HSBCAutoPayFileExchange;
                }
                else if (autoPayFile.CompanyAutopayFileBankCode.Equals("024"))
                {
                    currentFileProcess = HangSengAutoPayFileExchange;
                }

                EHSBCExchangeProfile exchangeProfile = new EHSBCExchangeProfile();
                exchangeProfile.HSBCExchangeProfileID = autoPayFile.HSBCExchangeProfileID;
                EHSBCExchangeProfile.db.select(m_dbConn, exchangeProfile);
                string[] submissionHeader = new string[6];
                submissionHeader[0] = "S";
                submissionHeader[1] = exchangeProfile.HSBCExchangeProfileRemoteProfileID.PadRight(18).Substring(0, 18);
                submissionHeader[2] = string.Empty.PadRight(28);
                submissionHeader[3] = transactionRefreence.PadRight(16).Substring(0, 16);
                submissionHeader[4] = "   ";
                submissionHeader[5] = autoPayFile.CompanyAutopayFileConfirmDateTime.ToString("yyyyMMddHHmmss");

                string strSubmissionHeader = string.Join(string.Empty, submissionHeader);
                if (strSubmissionHeader.Length != currentFileProcess.RecordLength)
                {
                    throw new Exception("Invalid submission header length");
                }

                currentFileProcess.AddLine(strSubmissionHeader);

                string   currentBankFilePath = System.IO.Path.Combine(m_DefaultBankFilePath, autoPayFile.CompanyAutopayFileDataFileRelativePath);
                FileInfo fileInfo            = new System.IO.FileInfo(currentBankFilePath);

                StreamReader bankFileStream = fileInfo.OpenText();
                char[]       charRead       = new char[80];

                try
                {
                    while (bankFileStream.Read(charRead, 0, 80) > 0)
                    {
                        string line = new string(charRead);
                        currentFileProcess.AddLine(line);
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    bankFileStream.Close();
                }
                if (Environment == HSBCEnvironmentIndicatorEnum.Production)
                {
                    autoPayFile.CompanyAutopayFileConsolidateDateTime  = AppUtils.ServerDateTime();
                    autoPayFile.CompanyAutopayFileTransactionReference = transactionRefreence;
                    ECompanyAutopayFile.db.update(m_dbConn, autoPayFile);
                }
            }
            HSBCAutoPayFileExchange.Close();
            HangSengAutoPayFileExchange.Close();
            return(new string[] { outputPathHSBC, outputPathHASE });
        }