public int parsePutnamAdj(DataSet ds, string _yrmo)
{
DateTime distdt;
string transType = "Adj";
Decimal distamt;
String ssn, name, lname, fname;
int _count = 0;
List <int> cols;
string _tableName = "PutnamAdjTable";
String[] colsH = new String[] { "TRADE", "Amount", "SSN", "Name" };
HRAImportDAL iObj = new HRAImportDAL();
cols = getColsIndices(ds, _tableName, colsH);
for (int i = 0; i < ds.Tables[_tableName].Rows.Count; i++)
{
distdt = Convert.ToDateTime(ds.Tables[_tableName].Rows[i][cols[0]]);
distamt = Decimal.Parse(ds.Tables[_tableName].Rows[i][cols[1]].ToString(), System.Globalization.NumberStyles.Currency);
ssn = ds.Tables[_tableName].Rows[i][cols[2]].ToString();
if (ssn.Contains("-"))
{
ssn = ssn.Replace("-", "");
}
name = ds.Tables[_tableName].Rows[i][cols[3]].ToString();
lname = name.Substring(0, name.IndexOf(',')).Trim(); lname = HRA.GetProperCase(lname);
fname = name.Substring(name.IndexOf(',') + 1).Trim(); fname = HRA.GetProperCase(fname);
if (iObj.insertPutnamAdj(_yrmo, distdt, transType, distamt, ssn, lname, fname))
{
_count++;
}
}
iObj.insertImportStatus(_yrmo, "PutnamAdj");
return(_count);
}
public int parseWageworks(DataSet ds, string _yrmo)
{
DateTime createdt;
Decimal amt;
String transtype, lname, fname, last4ssn;
int _count = 0;
List <int> cols;
string _tableName = "WageworksTable";
String[] colsH = new String[] { "CREATE_DATE", "Amount", "TRANSACTION_TYPE", "Last_Name", "First_Name", "LAST_4_SSN" };
HRAImportDAL iObj = new HRAImportDAL();
cols = getColsIndices(ds, _tableName, colsH);
for (int i = 0; i < ds.Tables[_tableName].Rows.Count; i++)
{
createdt = Convert.ToDateTime(ds.Tables[_tableName].Rows[i][cols[0]]);
amt = Decimal.Parse(ds.Tables[_tableName].Rows[i][cols[1]].ToString(), System.Globalization.NumberStyles.Currency);
transtype = ds.Tables[_tableName].Rows[i][cols[2]].ToString();
lname = ds.Tables[_tableName].Rows[i][cols[3]].ToString().Trim(); lname = HRA.GetProperCase(lname);
fname = ds.Tables[_tableName].Rows[i][cols[4]].ToString().Trim(); fname = HRA.GetProperCase(fname);
last4ssn = ds.Tables[_tableName].Rows[i][cols[5]].ToString();
if (iObj.insertWageworks(_yrmo, createdt, amt, transtype, lname, fname, last4ssn))
{
_count++;
}
}
iObj.insertImportStatus(_yrmo, "Wageworks");
return(_count);
}
public int parsePutnam(DataSet ds, string _yrmo, string _fname)
{
DateTime distdt;
Decimal distamt;
String transType, ssn, lname, fname;
int _count = 0;
List <int> cols;
String _tableName = "PutnamTable";
String[] colsH = new String[] { "First Name", "Last Name", "SSN", "Distribution Date", "Transaction Code", "Distribution Amount" };
HRAImportDAL iObj = new HRAImportDAL();
cols = getColsIndices(ds, _tableName, colsH);
for (int i = 0; i < ds.Tables[_tableName].Rows.Count; i++)
{
distdt = Convert.ToDateTime(ds.Tables[_tableName].Rows[i][cols[3]]);
transType = ds.Tables[_tableName].Rows[i][cols[4]].ToString();
distamt = Decimal.Parse(ds.Tables[_tableName].Rows[i][cols[5]].ToString(), System.Globalization.NumberStyles.Currency);
ssn = ds.Tables[_tableName].Rows[i][cols[2]].ToString();
if (ssn.Contains("-"))
{
ssn = ssn.Replace("-", "");
}
lname = ds.Tables[_tableName].Rows[i][cols[1]].ToString().Trim(); lname = HRA.GetProperCase(lname);
fname = ds.Tables[_tableName].Rows[i][cols[0]].ToString().Trim(); fname = HRA.GetProperCase(fname);
if (iObj.insertPutnam(_yrmo, distdt, transType, distamt, ssn, lname, fname))
{
_count++;
}
}
iObj.insertImportStatus(_yrmo, "Putnam");
return(_count);
}
public int parseWageworkInvoice(DataSet ds, string _fname, string source, string yrmo)
{
String last4ssn, lname, fname;
int _count = 0;
List <int> cols;
String _tableName = "WgwkInvTable";
String[] colsH = new String[] { "Last Name", "First Name", "ID Code" };
HRAImportDAL iObj = new HRAImportDAL();
cols = getColsIndices(ds, _tableName, colsH);
for (int i = 0; i < ds.Tables[_tableName].Rows.Count; i++)
{
lname = ds.Tables[_tableName].Rows[i][cols[0]].ToString().Trim(); lname = HRA.GetProperCase(lname);
if (lname.Contains(" "))
{
lname = lname.Replace(" ", " ");
lname = lname.Replace("'", "");
}
fname = ds.Tables[_tableName].Rows[i][cols[1]].ToString().Trim(); fname = HRA.GetProperCase(fname);
if (fname.Contains(" "))
{
fname = fname.Replace(" ", " ");
fname = fname.Replace("'", "");
}
last4ssn = ds.Tables[_tableName].Rows[i][cols[2]].ToString().Trim();
if (iObj.insertWageworkInvoice(lname, fname, last4ssn, source, yrmo))
{
_count++;
}
}
iObj.insertImportStatus(yrmo, "wgwk_invoice");
return(_count);
}
public int parsePutnamPartData(DataSet ds, string _fname, string source, string _qy)
{
Decimal balance;
String ssn, lname, fname, partStatDesc, dob, termdt;
SqlDateTime dobSql, termdtSql;
int _count = 0;
List <int> cols;
List <string> excludeSSNs;
Boolean excludeSSNfound;
String _tableName = "PutnamPartTable";
String[] colsH = new String[] { "SSN", "First Name", "Last Name", "Participant Status Description", "Date of Birth", "Termination Date", "Total Asset Balance" };
HRAImportDAL iObj = new HRAImportDAL();
cols = getColsIndices(ds, _tableName, colsH);
excludeSSNs = HRAAdminDAL.GetExcludeSSNs();
for (int i = 0; i < ds.Tables[_tableName].Rows.Count; i++)
{
ssn = ds.Tables[_tableName].Rows[i][cols[0]].ToString().Trim();
if (ssn.Contains("-"))
{
ssn = ssn.Replace("-", "");
}
ssn = ssn.TrimStart('0');
excludeSSNfound = false;
foreach (string excludeSSN in excludeSSNs)
{
if (ssn.Equals(excludeSSN))
{
excludeSSNfound = true;
break;
}
}
if (excludeSSNfound)
{
continue;
}
fname = ds.Tables[_tableName].Rows[i][cols[1]].ToString().Trim(); fname = HRA.GetProperCase(fname);
if (fname.Contains(" "))
{
fname = fname.Replace(" ", " ");
fname = fname.Replace("'", "");
}
lname = ds.Tables[_tableName].Rows[i][cols[2]].ToString().Trim(); lname = HRA.GetProperCase(lname);
if (lname.Contains(" "))
{
lname = lname.Replace(" ", " ");
lname = lname.Replace("'", "");
}
partStatDesc = ds.Tables[_tableName].Rows[i][cols[3]].ToString().Trim();
dob = ds.Tables[_tableName].Rows[i][cols[4]].ToString().Trim();
if (dob != null && dob != string.Empty)
{
dobSql = Convert.ToDateTime(dob);
}
else
{
dobSql = SqlDateTime.Null;
}
termdt = ds.Tables[_tableName].Rows[i][cols[5]].ToString().Trim();
if (termdt != null && termdt != string.Empty)
{
termdtSql = Convert.ToDateTime(termdt);
}
else
{
termdtSql = SqlDateTime.Null;
}
balance = Decimal.Parse(ds.Tables[_tableName].Rows[i][cols[6]].ToString(), System.Globalization.NumberStyles.Currency);
if (iObj.insertPutnamPartData(ssn, fname, lname, partStatDesc, dobSql, termdtSql, balance, source, _qy))
{
_count++;
}
}
iObj.insertImportStatus(_qy, "ptnm_partdata");
return(_count);
}
