Пример #1
0
        /// <summary>
        /// Writes a processor file
        /// </summary>
        private void CreateMRF()
        {
            try
            {
            string dateTime = DateTime.Now.ToString("yyyyMMdd");
            string requestedDate = DateTime.Now.ToString("yyMMdd");

            string fileLocation = System.Configuration.ConfigurationManager.AppSettings["systemPathWrite"].ToString();
            string fileName = string.Empty;
            //fileLocation;
            string processorCode = string.Empty;
            string processorName = string.Empty;
            Int64 rowCount = 0;
            Int64 individualRows = 0;
            #region Load File

            //Get the list of datasource to be processed
            DataSet ds = new DataLayer().RetrieveProcessorQueue();
            logger.Log(NLog.LogLevel.Info, "<br/><font color=red>Creation  of the MRF files starts........." + DateTime.Now.ToString());
            //Get the list of processors to process the data file
            if (ds.Tables[1].Rows.Count > 0)
            {
                for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
                {
                    processorCode = ds.Tables[1].Rows[i]["processorId"].ToString();
                    processorName = ds.Tables[1].Rows[i]["name"].ToString();
                    #region Process the files
                    logger.Log(NLog.LogLevel.Info, "<br/><font color=red>Total Rows Count in MRF files Creation........." + ds.Tables[0].Rows.Count.ToString());
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        fileName = string.Concat(processorCode.Substring(0, 2), requestedDate.Substring(0, 6), ".mrf");
                        rowCount = ds.Tables[0].Rows.Count;
                        _filePath = Path.Combine(fileLocation, fileName);
                        logger.Log(NLog.LogLevel.Info, "<br/><font color=red>File Path:   " + _filePath);
                        individualRows = 0;
                        using (MRFWriter writer = new MRFWriter(_filePath))
                        {
                            logger.Log(NLog.LogLevel.Info, "<br/><font color=red> Processor Code:   " + processorCode);
                            ProcessorRow rowHeader = new ProcessorRow();
                            rowHeader.Add(String.Format("HEADER"));
                            rowHeader.Add(String.Format(dateTime));
                            rowHeader.Add(String.Format(processorCode));
                            writer.WriteRow(rowHeader);
                            for (int count = 0; count <= rowCount - 1; count++)
                            {

                                if (processorCode == String.Format(ds.Tables[0].Rows[count]["ProcessorId"].ToString()))
                                {
                                    /// Need to add logic to create the file based on the values from the file/db
                                    ProcessorRow row = new ProcessorRow();
                                    row.Add(String.Format(dateTime));
                                    row.Add(String.Format(ds.Tables[0].Rows[count]["ProcessorId"].ToString()));
                                    row.Add(String.Format(ds.Tables[0].Rows[count]["merchantId"].ToString()));
                                    logger.Log(NLog.LogLevel.Info, "<br/><font color=red> Merchant Id :   " + String.Format(ds.Tables[0].Rows[count]["merchantId"].ToString()));
                                    row.Add(String.Format(ds.Tables[0].Rows[count]["processorNumber"].ToString()));

                                    writer.WriteRow(row);
                                    new DataLayer().UpdateProcessorQueue(Convert.ToInt64(ds.Tables[0].Rows[count]["merchantId"].ToString()), ds.Tables[0].Rows[count]["processorNumber"].ToString());
                                    individualRows++;
                                }
                            }
                            ProcessorRow rowTrailer = new ProcessorRow();
                            rowTrailer.Add(String.Format("TRAILER"));
                            rowTrailer.Add(String.Format(dateTime));
                            rowTrailer.Add(String.Format(processorCode));
                            rowTrailer.Add(String.Format(individualRows.ToString()));
                            writer.WriteRow(rowTrailer);

                        }

                        /* if (System.Configuration.ConfigurationManager.AppSettings["isftp"].ToString() == "1")
                         {
                             FtpWebRequest ftp = (FtpWebRequest)WebRequest.Create(Path.Combine(System.Configuration.ConfigurationManager.AppSettings["ftpPathWrite"].ToString(), fileName));
                             ftp.Credentials = new NetworkCredential(System.Configuration.ConfigurationManager.AppSettings["username"].ToString(), System.Configuration.ConfigurationManager.AppSettings["password"].ToString());
                             ftp.Method = WebRequestMethods.Ftp.UploadFile;
                             FileStream fs = File.OpenRead(_filePath);
                             byte[] buffer = new byte[fs.Length];
                             fs.Read(buffer, 0, buffer.Length);
                             fs.Close();

                             Stream ftpstream = ftp.GetRequestStream();
                             ftpstream.Write(buffer, 0, buffer.Length);
                             ftpstream.Close();
                         }*/
                    }
                }

                    #endregion

                }

            }
            catch(Exception ex)
            {

                logger.Log(NLog.LogLevel.Info, "<br/><font color=red>Error while creating MRF........." + ex.InnerException.ToString());
            }
            logger.Log(NLog.LogLevel.Info, "<br/><font color=red>Creation  of the MRF Ends........." + DateTime.Now.ToString());
            #endregion
        }
Пример #2
0
        private void CreateWSF()
        {
            string dateTime = DateTime.Now.ToString("yyyyMMdd");
            string requestedDate = DateTime.Now.ToString("yyMMdd");
            //_filePath = System.Configuration.ConfigurationManager.AppSettings["ftpPathWriteProcessorWSF"].ToString();
            string folderPath = System.Configuration.ConfigurationManager.AppSettings["ftpPathWriteProcessorWSF"].ToString();
            double totalBalance = 0d;
            string processorCode = string.Empty;
            Int64 rowCount = 0;

            //Get the list of datasource to be processed
            DataSet ds = new DataLayer().RetrieveWSFInformation();
            logger.Log(NLog.LogLevel.Info, "<br/><font color=red>Creation  of the WSF files starts........." + DateTime.Now.ToString());
            //Get the list of processors to process the data file
            if (ds.Tables[1].Rows.Count > 0)
            {
                for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
                {

                    processorCode = ds.Tables[1].Rows[i]["processorId"].ToString();

                    #region Process the files
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        rowCount = ds.Tables[0].Rows.Count;
                        //_filePath = string.Concat(processorCode.Substring(0, 2), requestedDate.Substring(0, 6), ".wsf");
                        string fileName= string.Concat(processorCode.Substring(0, 2), requestedDate.Substring(0, 6), ".wsf");

                    //    using (MRFWriter writer = new MRFWriter(_filePath))
                        using (MRFWriter writer = new MRFWriter(Path.Combine(folderPath, fileName)))
                        {
                            ProcessorRow rowHeader = new ProcessorRow();
                            rowHeader.Add(String.Format("HEADER"));
                            rowHeader.Add(String.Format(dateTime));
                            rowHeader.Add(String.Format(processorCode));
                            writer.WriteRow(rowHeader);
                            for (int count = 0; count <= rowCount - 1; count++)
                            {
                                /// Need to add logic to create the file based on the values from the file/db
                                ProcessorRow row = new ProcessorRow();
                                row.Add(String.Format(dateTime));
                                row.Add(String.Format(processorCode));
                                row.Add(String.Format(ds.Tables[0].Rows[count]["merchantId"].ToString()));
                                row.Add(String.Format(ds.Tables[0].Rows[count]["processorNumber"].ToString()));
                                row.Add(String.Format(ds.Tables[0].Rows[count]["balance"].ToString()));
                                row.Add(String.Format(ds.Tables[0].Rows[count]["rate"].ToString()));
                               totalBalance+=Convert.ToDouble(ds.Tables[0].Rows[count]["balance"].ToString());
                                writer.WriteRow(row);
                            }
                            ProcessorRow rowTrailer = new ProcessorRow();
                            rowTrailer.Add(String.Format("TRAILER"));
                            rowTrailer.Add(String.Format(dateTime));
                            rowTrailer.Add(String.Format(processorCode));
                            rowTrailer.Add(String.Format(rowCount.ToString()));
                            rowTrailer.Add(String.Format(totalBalance.ToString()));
                            writer.WriteRow(rowTrailer);

                        }
                    }

                }
                    #endregion
                logger.Log(NLog.LogLevel.Info, "<br/><font color=red>Reading of the files Ends........." + DateTime.Now.ToString());
            }
        }
Пример #3
0
        /// <summary>
        /// Reads a row of data from a CSV file
        /// </summary>
        /// <param name="row"></param>
        /// <returns></returns>
        public bool ReadRow(ProcessorRow row)
        {
            row.LineText = ReadLine();
                if (String.IsNullOrEmpty(row.LineText))
                    return false;

                int pos = 0;
                int rows = 0;

                while (pos < row.LineText.Length)
                {
                    string value;

                    // Special handling for quoted field
                    if (row.LineText[pos] == '"')
                    #region quotedtext
                    {
                        // Skip initial quote
                        pos++;

                        // Parse quoted value
                        int start = pos;
                        while (pos < row.LineText.Length)
                        {
                            // Test for quote character
                            if (row.LineText[pos] == '"')
                            {
                                // Found one
                                pos++;

                                // If two quotes together, keep one
                                // Otherwise, indicates end of value
                                if (pos >= row.LineText.Length || row.LineText[pos] != '"')
                                {
                                    pos--;
                                    break;
                                }
                            }
                            pos++;
                        }
                        value = row.LineText.Substring(start, pos - start);
                        value = value.Replace("\"\"", "\"");
                    }
                    #endregion
                    else
                    {
                        // Parse unquoted value
                        int start = pos;
                        while (pos < row.LineText.Length && row.LineText[pos] != ',')
                            pos++;
                        value = row.LineText.Substring(start, pos - start);

                    }

                    // Add field to list
                    if (rows < row.Count)
                        row[rows] = value;
                    else
                        row.Add(value);
                    rows++;

                    // Eat up to and including next comma
                    while (pos < row.LineText.Length && row.LineText[pos] != ',')
                        pos++;
                    if (pos < row.LineText.Length)
                        pos++;
                }
                // Delete any unused items
                while (row.Count > rows)
                    row.RemoveAt(rows);

                // Return true if any columns read
                return (row.Count > 0);
        }