private void btnCorpLogReltn_Click(object sender, EventArgs e)
{
int cntr = 1;
int count = 0;
int num = 0;
bool eof = false;
string rec = "";
string[] recs;
string record = "";
DataIO fI1 = new DataIO();
DataIO fI2 = new DataIO();
DataIO fI3 = new DataIO();
DataIO fI4 = new DataIO();
DataIO fI5 = new DataIO();
DataIO fO = new DataIO();
DataIO fO2 = new DataIO();
//Hashtable hash = new Hashtable();
//Hashtable hashC = new Hashtable();
//ArrayList lst = new ArrayList();
fI1.OpenFile(@"E:\Huron\Input\CORSP_LOG_RELTN.csv", DataIO.IO.INPUT);
fO.OpenFile(@"E:\Huron\Input\CORSP_LOG_RELTN_REDUCED.csv", DataIO.IO.OUTPUT);
while (eof == false)
{
fI1.ReadRecord_All();
rec = fI1.RecordData;
if (rec == "END OF FILE")
{
break;
}
else
{
recs = rec.Split(',');
if (recs[13] != "0")
{
fO.WriteRecordNoCriteria(rec);
}
}
count++;
if (count % 100 == 0)
{
DisplayResults(count.ToString());
}
}
lblStatus.Text = count.ToString();
Application.DoEvents();
}
private void button4_Click(object sender, EventArgs e)
{
int cntr = 1;
int count = 0;
int num = 0;
bool eof = false;
string rec = "";
string[] recs;
string record = "";
DataIO fI1 = new DataIO();
DataIO fI2 = new DataIO();
DataIO fI3 = new DataIO();
DataIO fI4 = new DataIO();
DataIO fI5 = new DataIO();
DataIO fO = new DataIO();
DataIO fO2 = new DataIO();
//Hashtable hash = new Hashtable();
//Hashtable hashC = new Hashtable();
//ArrayList lst = new ArrayList();
fI1.OpenFile(@"P:\Huron_Extracts\BARFiles\Encounter_20200317.csv", DataIO.IO.INPUT);
//fO.OpenFile(@"E:\Huron\Output\TestAZ.txt", DataIO.IO.OUTPUT);
//fO2.OpenFile(@"P:\TempFiles\DupRec2.txt", DataIO.IO.OUTPUT);
while (eof == false)
{
fI1.ReadRecord_All();
rec = fI1.RecordData;
if (rec == "END OF FILE")
{
break;
}
//else
//{
// if (rec.Substring(0, 2) == "10" || rec.Substring(0, 2) == "40")
// {
// if (rec.Substring(0, 2) == "40")
// rec = rec.Substring(0, 14) + rec.Substring(14).Trim();
// fO.WriteRecordNoCriteria(rec);
// }
//}
count++;
if (count % 100 == 0)
{
DisplayResults(count.ToString());
}
}
}
private void button3_Click(object sender, EventArgs e)
{
int cntr = 1;
int count = 0;
int num = 0;
bool eof = false;
string rec = "";
string[] recs;
string record = "";
DataIO fI1 = new DataIO();
DataIO fI2 = new DataIO();
DataIO fI3 = new DataIO();
DataIO fI4 = new DataIO();
DataIO fI5 = new DataIO();
DataIO fO = new DataIO();
DataIO fO2 = new DataIO();
//Hashtable hash = new Hashtable();
//Hashtable hashC = new Hashtable();
//ArrayList lst = new ArrayList();
fI1.OpenFile(@"E:\Huron\Output\SHAZ_TSHX_SLHX_FB_1.txt", DataIO.IO.INPUT);
fO.OpenFile(@"E:\Huron\Output\TestAZ.txt", DataIO.IO.OUTPUT);
//fO2.OpenFile(@"P:\TempFiles\DupRec2.txt", DataIO.IO.OUTPUT);
while (eof == false)
{
fI1.ReadRecord();
rec = fI1.RecordData;
if (rec == "END OF FILE")
{
break;
}
else
{
if (rec.Substring(0, 2) == "10" || rec.Substring(0, 2) == "40")
{
if (rec.Substring(0, 2) == "40")
{
rec = rec.Substring(0, 14) + rec.Substring(14).Trim();
}
fO.WriteRecordNoCriteria(rec);
}
}
count++;
if (count % 100 == 0)
{
DisplayResults(count.ToString());
}
}
//while (eof == false)
//{
// fI1.ReadRecord();
// rec = fI1.RecordData;
// if (rec == "END OF FILE")
// break;
// else
// {
// recs = rec.Split('\t');
// if (hash.Contains(recs[0].Trim()) == false)
// fO2.WriteRecordNoCriteria(rec);
// }
// count++;
// if (count % 100 == 0)
// DisplayResults(count.ToString());
//}
lblStatus.Text = count.ToString();
Application.DoEvents();
}
private void button1_Click(object sender, EventArgs e)
{
int cntr = 1;
int count = 0;
int num = 0;
bool eof = false;
string rec = "";
string[] recs;
string record = "";
string ftype = "";
DataIO fI1 = new DataIO();
DataIO fI2 = new DataIO();
DataIO fI3 = new DataIO();
DataIO fI4 = new DataIO();
DataIO fI5 = new DataIO();
DataIO fO = new DataIO();
DataIO fO2 = new DataIO();
Hashtable hash = new Hashtable();
string acct = "";
string nacct = "";
Hashtable hashC = new Hashtable();
//ArrayList lst = new ArrayList();
fI1.OpenFile(@"E:\Huron\Input\RCA_DRV_ATB_DET_FEB 13_MVHX_TAB.txt", DataIO.IO.INPUT);
fI2.OpenFile(@"E:\Huron\Output\BAR\SHAZ_MVHX_FB_20200308_1.txt", DataIO.IO.INPUT);
fI3.OpenFile(@"E:\Huron\Output\BAR\SHAZ_MVHX_UB_20200308_1.txt", DataIO.IO.INPUT);
fI4.OpenFile(@"E:\Huron\Output\BAR\SHAZ_MVHX_BD_20200308_1.txt", DataIO.IO.INPUT);
fI5.OpenFile(@"E:\Huron\Output\BAR\SHAZ_MVHX_ZERO_20200308_1.txt", DataIO.IO.INPUT);
fO.OpenFile(@"E:\Huron\Input\BarResultsMVHX.txt", DataIO.IO.OUTPUT);
while (eof == false)
{
fI1.ReadRecord_All();
rec = fI1.RecordData;
if (rec == "END OF FILE")
{
break;
}
else
{
recs = rec.Split('\t');
hash.Add(recs[2].Trim(), "");
}
count++;
if (count % 100 == 0)
{
DisplayResults(count.ToString());
}
}
for (int x = 1; x <= 4; x++)
{
while (eof == false)
{
if (x == 1)
{
fI2.ReadRecord_All();
rec = fI2.RecordData;
ftype = "FB";
}
else if (x == 2)
{
fI3.ReadRecord_All();
rec = fI3.RecordData;
ftype = "UB";
}
else if (x == 3)
{
fI4.ReadRecord_All();
rec = fI4.RecordData;
ftype = "BD";
}
else if (x == 4)
{
fI5.ReadRecord_All();
rec = fI5.RecordData;
ftype = "ZERO";
}
if (rec == "END OF FILE")
{
break;
}
else
{
if (rec.Substring(0, 2) == "20")
{
nacct = rec.Substring(2, 12);
acct = "15" + nacct.Substring(3);
if (hash.Contains(acct) == true)
{
fO.WriteRecordNoCriteria(nacct + '\t' + acct + '\t' + ftype + '\t' + "FOUND ON ATB");
}
else
{
if (rec.Substring(16, 8).Trim() != "REF")
{
fO.WriteRecordNoCriteria(nacct + '\t' + acct + '\t' + ftype + '\t' + "NOT FOUND ON ATB" + '\t' + "(CLIENT ACCOUNT)");
}
else
{
fO.WriteRecordNoCriteria(nacct + '\t' + acct + '\t' + ftype + '\t' + "NOT FOUND ON ATB");
}
}
if (hashC.Contains(acct) == false)
{
hashC.Add(acct, "");
}
}
}
count++;
if (count % 100 == 0)
{
DisplayResults(count.ToString());
}
}
}
fI1.CloseFile();
fI1.OpenFile(@"E:\Huron\Input\RCA_DRV_ATB_DET_FEB 13_MVHX_TAB.txt", DataIO.IO.INPUT);
while (eof == false)
{
fI1.ReadRecord_All();
rec = fI1.RecordData;
if (rec == "END OF FILE")
{
break;
}
else
{
recs = rec.Split('\t');
acct = recs[2].Trim();
nacct = "ZV0" + acct.Substring(2);
if (hashC.Contains(recs[2].Trim()) == false)
{
fO.WriteRecordNoCriteria(nacct + '\t' + acct + '\t' + "FOUND ON ATB NOT IN FILE");
}
else
{
fO.WriteRecordNoCriteria(nacct + '\t' + acct + '\t' + "FOUND ON ATB AND FILE");
}
}
count++;
if (count % 100 == 0)
{
DisplayResults(count.ToString());
}
}
lblStatus.Text = count.ToString();
Application.DoEvents();
}