private void scrambleTextPrism()
{
string line = string.Empty;
TextReader reader = new StreamReader(File.OpenRead(_fileName));
StringBuilder sb = new StringBuilder();
try
{
while ((line = reader.ReadLine()) != null)
{
string _scrambledssn = "";
string _start = line.Substring(0, 1);
if (_start.Trim().Equals("2"))
{
string _realssn = line.Substring(11, 10);
_realssn = ScrambleDAL.GetSSN(_realssn);
_scrambledssn = ScrambleDAL.scrambledData(_realssn, _key).PadLeft(10, '0');
if (!_scrambledssn.Equals(""))
{
line = line.Substring(0, 11) + _scrambledssn + line.Substring(21, (line.Length - 21));
}
}
sb.AppendLine(line);
}
exportScrambledTextFile(sb.ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
reader.Close();
}
}
private void scrambleTextNormal()
{
string _Pattern = @"(?<ssn>\d{3}-\d{2}-\d{4})";
string line = string.Empty;
TextReader reader = new StreamReader(File.OpenRead(_fileName));
StringBuilder sb = new StringBuilder();
try
{
while ((line = reader.ReadLine()) != null)
{
Match parsed = Regex.Match(line, _Pattern);
if (parsed.Success)
{
string _scrambledssn = "";
string _realssn = parsed.Groups["ssn"].Value.ToString();
_scrambledssn = ScrambleDAL.scrambledData(_realssn, _key);
if (!_scrambledssn.Equals(""))
{
line = line.Replace(_realssn, _scrambledssn);
}
}
sb.AppendLine(line);
}
exportScrambledTextFile(sb.ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
reader.Close();
}
}
public void scrambleExcelFile()
{
string _oldv = string.Empty;
try
{
myExcel = new Excel.Application();
myExcel.Workbooks.Open(_fileName, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing,
missing, missing, missing);
foreach (Excel.Worksheet sheet in myExcel.Sheets)
{
if ((sheet.Name).Contains(_sheetname))
{
sheet.Select(Type.Missing);
}
}
Excel.Worksheet ws = (Excel.Worksheet)myExcel.ActiveSheet;
_startIndex = 1;
_endIndex = ws.Cells.Find("*", System.Reflection.Missing.Value,
System.Reflection.Missing.Value, System.Reflection.Missing.Value,
Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious,
false, System.Reflection.Missing.Value, System.Reflection.Missing.Value).Row;
ScrambleDAL.openDB();
for (int i = _startIndex; i <= _endIndex; i++)
{
if (((Excel.Range)ws.Cells[i, _columnNumber]).Value2 != null)
{
_oldv = ((Excel.Range)ws.Cells[i, _columnNumber]).Value2.ToString();
string _newv = string.Empty;
if ((!_wageWorks) && (!_watsonWyatts) && matchSSN(_oldv))
{
_newv = ScrambleDAL.scrambledData(_oldv, _key);
}
else if (_wageWorks && matchSSN(_oldv))
{
string _ln = ((Excel.Range)ws.Cells[i, _lnamecolumnNumber]).Value2.ToString();
_ln = _ln.Substring(0, 3);
_newv = ScrambleDAL.scrambledDataCREF(_oldv, _ln, _key);
}
else if (_watsonWyatts && matchSSN(_oldv))
{
string _emplStatus = ((Excel.Range)ws.Cells[i, _empStatuscolumnNumber]).Value2.ToString();
if (_emplStatus.Trim().Equals("R"))
{
_newv = ScrambleDAL.scrambledData(_oldv, _key).Substring(5, 4);
}
else
{
_newv = _oldv;
}
}
else if (!matchSSN(_oldv))
{
_newv = _oldv;
}
((Excel.Range)ws.Cells[i, _columnNumber]).Value2 = _newv;
}
}
foreach (Excel.Workbook wb in myExcel.Workbooks)
{
wb.Save();
}
}
catch (Exception ex)
{
foreach (Excel.Workbook wb in myExcel.Workbooks)
{
wb.Saved = true;
}
throw ex;
}
finally
{
ScrambleDAL.closeDB();
Close(myExcel);
}
}
