/// <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
}
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());
}
}
/// <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);
}