string GetEligFileHeader(string hraPlanNum) { StringBuilder sb = new StringBuilder(); sb.Append("PUTSY"); sb.Append(HRA.GetFixedLengthString(hraPlanNum, 6)); sb.Append(HRA.GetFixedLengthString("CENSUS", 9)); sb.Append(' ', 60); return(sb.ToString()); }
string GetEligFileFooter(int counter, string hraPlanNum) { string strcntr = counter.ToString(); strcntr = strcntr.PadLeft(11, '0'); StringBuilder sb = new StringBuilder(); sb.Append("PUTE"); sb.Append(' ', 1); sb.Append(HRA.GetFixedLengthString(hraPlanNum, 6)); sb.Append(HRA.GetFixedLengthString("CENSUS", 9)); sb.Append(' ', 29); sb.Append(strcntr); sb.Append(' ', 20); return(sb.ToString()); }
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()); }