public DataSet GetWageworkSummaryRecon(string _qy)
{
HRA hobj = new HRA();
HRAAdminDAL dobj = new HRAAdminDAL();
string[] YRMOs = HRA.GetYRMOs(_qy);
int ptnminv1_cnt, wgwkinv_cnt, hraAuditR_cnt, ptnmPartData_cnt;
decimal rate, ptnminv1_amt, ptnminv1_calcamt;
Decimal totamt1, totamt2;
DataSet ds = new DataSet(); ds.Clear();
DataSet dsWgwkSum = new DataSet(); dsWgwkSum.Clear();
DataTable dsTable; dsTable = dsWgwkSum.Tables.Add("WgwkSummary");
DataRow row;
DataColumn col;
System.Type typeDecimal = System.Type.GetType("System.Decimal");
col = new DataColumn("Period"); dsTable.Columns.Add(col);
col = new DataColumn("Putnam Invoice Count"); dsTable.Columns.Add(col);
col = new DataColumn("Wageworks Invoice Count"); dsTable.Columns.Add(col);
col = new DataColumn("Diff(B-C)"); dsTable.Columns.Add(col);
col = new DataColumn("Putnam Participant Data Count"); dsTable.Columns.Add(col);
col = new DataColumn("Diff(C-E)"); dsTable.Columns.Add(col);
col = new DataColumn("HRAAUDITR Count(as of " + DateTime.Today.ToString("MM/dd/yyyy") + ")"); dsTable.Columns.Add(col);
col = new DataColumn("Diff(E-G)"); dsTable.Columns.Add(col);
col = new DataColumn("Rate"); dsTable.Columns.Add(col);
col = new DataColumn("Putnam Invoice Amount", typeDecimal); dsTable.Columns.Add(col);
col = new DataColumn("Amount(BxI)", typeDecimal); dsTable.Columns.Add(col);
foreach (string yrmo in YRMOs)
{
ds = dobj.GetPutnamInvData(_qy); ptnminv1_cnt = GetPutnamInvPart1Count(ds, yrmo);
wgwkinv_cnt = dobj.GetWgwkInvCount(yrmo);
ptnmPartData_cnt = dobj.GetPutnamPartDataCount(yrmo);
hraAuditR_cnt = dobj.GetHRAAuditRCount(yrmo);
rate = dobj.GetWageworkHeadcountRate(yrmo);
ptnminv1_amt = GetPutnamInvPart1Amt(ds, yrmo);
ptnminv1_calcamt = ptnminv1_cnt * rate;
row = dsTable.NewRow();
row["Period"] = hobj.GetYRMOformated(yrmo);
row["Putnam Invoice Count"] = ptnminv1_cnt;
row["Wageworks Invoice Count"] = wgwkinv_cnt;
row["Diff(B-C)"] = (ptnminv1_cnt - wgwkinv_cnt);
row["Putnam Participant Data Count"] = ptnmPartData_cnt;
row["Diff(C-E)"] = (wgwkinv_cnt - ptnmPartData_cnt);
row["HRAAUDITR Count(as of " + DateTime.Today.ToString("MM/dd/yyyy") + ")"] = hraAuditR_cnt;
row["Diff(E-G)"] = (ptnmPartData_cnt - hraAuditR_cnt);
row["Rate"] = rate;
row["Putnam Invoice Amount"] = ptnminv1_amt;
row["Amount(BxI)"] = ptnminv1_calcamt;
dsTable.Rows.Add(row);
}
totamt1 = Convert.ToDecimal(dsWgwkSum.Tables[0].Compute("SUM([Putnam Invoice Amount])", String.Empty));
totamt2 = Convert.ToDecimal(dsWgwkSum.Tables[0].Compute("SUM([Amount(BxI)])", String.Empty));
row = dsTable.NewRow();
row["Rate"] = "TOTAL:";
row["Putnam Invoice Amount"] = totamt1;
row["Amount(BxI)"] = totamt2;
dsTable.Rows.Add(row);
return(dsWgwkSum);
}
