public DataSet GetAuditFile()
{
DataSet empds = new DataSet();
DataSet dshrainfo = new DataSet();
HRAOperDAL dobj = new HRAOperDAL();
empds.Clear();
dshrainfo.Clear();
int counter;
DataSet dsAudit = new DataSet();
dsAudit.Clear();
DataTable dsTable;
dsTable = dsAudit.Tables.Add("dsTable");
DataRow row2;
DataColumn col;
col = new DataColumn("SSN"); dsTable.Columns.Add(col);
col = new DataColumn("Emp#"); dsTable.Columns.Add(col);
col = new DataColumn("Name"); dsTable.Columns.Add(col);
col = new DataColumn("SubCtr"); dsTable.Columns.Add(col);
col = new DataColumn("CodeID"); dsTable.Columns.Add(col);
col = new DataColumn("Code Desc"); dsTable.Columns.Add(col);
col = new DataColumn("Value"); dsTable.Columns.Add(col);
empds = dobj.GetEmployeeInfo();
foreach (DataRow row in empds.Tables[0].Rows)
{
counter = 0;
dshrainfo = getHRaPartInfo(row);
foreach (DataRow row1 in dshrainfo.Tables[0].Rows)
{
if (row1["codedsc"].ToString() != "NAME" && row1["codedsc"].ToString() != "EMPNO")
{
counter++;
row2 = dsTable.NewRow();
row2["SSN"] = row["ssn"].ToString().Trim();
row2["Emp#"] = row["empno"].ToString();
row2["Name"] = row["lname"].ToString().Trim() + ", " + row["fname"].ToString().Trim();
row2["SubCtr"] = counter;
row2["CodeID"] = row1["codeid"].ToString();
row2["Code Desc"] = row1["codedsc"].ToString();
row2["Value"] = row1["value"].ToString();
dsTable.Rows.Add(row2);
}
}
}
return(dsAudit);
}
public string GetEligFile()
{
DataSet empds = new DataSet();
DataSet dshrainfo = new DataSet();
StringBuilder sb = new StringBuilder();
HRAOperDAL dobj = new HRAOperDAL();
empds.Clear();
dshrainfo.Clear();
int counter = 0;
string start, end;
string hraPlanNum = HRAOperDAL.GetHRAPlanNum();
/************** Header of Elig File ************************************/
sb.Append(GetEligFileHeader(hraPlanNum) + Environment.NewLine);
/************** Build Records ******************************************/
empds = dobj.GetEmployeeInfo();
foreach (DataRow row in empds.Tables[0].Rows)
{
//start and end of each line
start = "813" + " " + hraPlanNum.PadLeft(6, '0') + " " + row["ssn"].ToString().Trim().PadLeft(9, '0');
end = "";
end = end.PadRight(24, ' ') + Environment.NewLine;
//participant info
dshrainfo = getHRaPartInfo(row);
foreach (DataRow row1 in dshrainfo.Tables[0].Rows)
{
if (row1["codeid"].ToString() != "N/A" && row1["codeid"].ToString() != "RET")
{
sb.Append(start + row1["codeid"].ToString().PadLeft(3, '0') + HRA.GetFixedLengthString(row1["value"].ToString(), 32) + end);
counter++;
}
}
}
/***************** (Footer) Trailer Record *****************************/
sb.Append(GetEligFileFooter(counter, hraPlanNum));
return(sb.ToString());
}
