protected void btnSubmit_Click(object sender, EventArgs e) { resultDiv2.Visible = false; div2_error.Visible = false; div2_alert.Visible = false; String yrmo = ddlYrmo2.SelectedValue; HRASofoDAL robj = new HRASofoDAL(); if (Page.IsValid) { if (txtPrevYRMO2.Visible) { lbl_error2.Text = "Enter YRMO in format 'yyyymm'"; return; } try { ManualReconcile(); HRA_Results.SavePrintFiles(_category, yrmo); viewresult2(yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskR(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "HRA", "Reconciliation", "SOFO Reconciliation", yrmo); } catch (Exception ex) { resultDiv2.Visible = false; MultiView1.SetActiveView(view_main2); robj.ReconDelete(yrmo); div2_error.Visible = true; lbl_error2.Text = "Error - " + ex.Message; } } }
protected void lnk_genRpts_OnClick(object sender, EventArgs e) { lbl_err.Text = ""; try { HRAOperDAL.InsertStopDate(); HRAOperDAL.InsertEligFileContent(); HRAOperDAL.InsertAuditR(); NameValueCollection eligFileMsg = HRAOperDAL.GetEligFileCreatedMsg(); if (eligFileMsg.Get("timecreated") != null) { lbl_notice.Text = "Last time File Generated: " + eligFileMsg.Get("timecreated") + " by " + eligFileMsg.Get("createduser"); } SetNoRecsMsg(); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskR(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "HRA", "Operations", "Generate Eligibility File ", DateTime.Today.ToString("yyyyMMdd")); HRA_Results.SavePrintFiles(_class, tbx_deathsXdays.Text.ToString()); resultdiv.Visible = true; } catch (Exception ex) { lbl_err.Text = "Error in generation reports<br />" + ex.Message; } }
void Reconcile(string _qy) { HRAAdminDAL robj = new HRAAdminDAL(); HRAAdminBill hobj = new HRAAdminBill(); hobj.CheckRptsImported(_qy); robj.insertReconStatus(_qy); HRA_Results.SavePrintFiles(_class, _qy); }
protected void btn_manImport_Click(object sender, EventArgs e) { string yrmo = ddlYrmo1.SelectedItem.Text; div1_error.Visible = false; div1_alert.Visible = false; HRASofoDAL robj = new HRASofoDAL(); if (Page.IsValid) { if (txtPrevYRMO1.Visible) { lbl_error1.Text = "Enter YRMO in format 'yyyymm'"; return; } string strFilePath1 = ""; if (FileUpload1.GotFile) { try { string fn = System.IO.Path.GetFileName(FileUpload1.FilePost.FileName); strFilePath1 = Server.MapPath("~/uploads/") + fn; if (File.Exists(strFilePath1)) { File.Delete(strFilePath1); } FileUpload1.FilePost.SaveAs(strFilePath1); AutoReconcile(strFilePath1); HRA_Results.SavePrintFiles(_category, yrmo); viewresult1(yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskR(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "HRA", "Reconciliation", "SOFO Reconciliation", yrmo); } catch (Exception ex) { resultDiv1.Visible = false; MultiView3.SetActiveView(view_main1); robj.ReconDelete(yrmo); div1_error.Visible = true; lbl_error1.Text = "Error - " + ex.Message; } finally { if (File.Exists(strFilePath1)) { File.Delete(strFilePath1); } FileUpload1.FilePost.InputStream.Flush(); FileUpload1.FilePost.InputStream.Close(); FileUpload1.FilePost.InputStream.Dispose(); } } } }
void HRAReconcile(string yrmo) { HRA_ReconDAL.Pass1_InsertPutnam(yrmo); HRA_ReconDAL.Pass2_InsertPutnamAdj(yrmo); HRA_Recon.Pass3_CurWageworks(yrmo); HRA_Recon.Pass4_PriWageworks(yrmo); HRA_ReconDAL.Pass5_InsertDiffAmt(yrmo); HRA_ReconDAL.insertReconStatus(yrmo, "Recon"); HRA_Recon.InsertPrevCFData(yrmo); HRA_Results.SavePrintFiles(_class, yrmo); }
protected void lnk_gen_childBenLtrRpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; try { HRA_Results.GenerateReport("EligChildBenLtr", String.Empty); } catch (Exception ex) { lbl_error.Text = "Error in generating Child Beneficiary Letter Report<br />" + ex.Message; } }
protected void lnk_genEligRpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; try { HRA_Results.GenerateReport("Elig", String.Empty); } catch (Exception ex) { lbl_error.Text = "Error in generating HRA Eligibility File<br />" + ex.Message; } }
protected void lnk_gen_termAuditRpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; try { HRA_Results.GenerateReport("EligTermAudit", String.Empty); } catch (Exception ex) { lbl_error.Text = "Error in generating Terminations Audit Report<br />" + ex.Message; } }
protected void lnk_gen_deathsXdaysRpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; try { HRA_Results.GenerateReport("EligDeathsXdays", tbx_deathsXdays.Text.ToString()); } catch (Exception ex) { lbl_error.Text = "Error in generating Status Changes Audit Report<br />" + ex.Message; } }
protected void lnk_gen_eligBen24Rpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; try { HRA_Results.GenerateReport("EligBen24", String.Empty); } catch (Exception ex) { lbl_error.Text = "Error in generating Benificiary Turns 24 Report<br />" + ex.Message; } }
protected void lnk_gen_noBenOwnerRpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; try { HRA_Results.GenerateReport("EligNoBenOwner", String.Empty); } catch (Exception ex) { lbl_error.Text = "Error in generating HRA Died No Owner Verified Report<br />" + ex.Message; } }
protected void lnk_genWPnoBal_Rpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; string _qy = ddlQY.SelectedItem.Text.ToString(); try { HRA_Results.GenerateReport("AdminWPnoBal", _qy); } catch (Exception ex) { lbl_error.Text = "Error in generating 'Report of participant(s) in Wageworks with Zero Asset Balance in Putnam'<br />" + ex.Message; } }
protected void lnk_genDispPW_Rpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; string _qy = ddlQY.SelectedItem.Text.ToString(); try { HRA_Results.GenerateReport("AdminDispPW", _qy); } catch (Exception ex) { lbl_error.Text = "Error in generating 'Putnam to Wageworks Discrepancy Report'<br />" + ex.Message; } }
protected void lnk_genAUDITR_Rpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; string _qy = ddlQY.SelectedItem.Text.ToString(); try { HRA_Results.GenerateReport("HRAAUDITR", _qy); } catch (Exception ex) { lbl_error.Text = "Error in generating 'HRAAUDITR Report'<br />" + ex.Message; } }
protected void lnk_genTranRpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; string yrmo = ddlYrmo.SelectedItem.Text; try { HRA_Results.GenerateReport("Transaction", yrmo); } catch (Exception ex) { lbl_error.Text = "Error in generating Transaction Report<br />" + ex.Message; } }
protected void lnk_genCFnotClearRpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; string yrmo = ddlYrmo.SelectedItem.Text; try { HRA_Results.GenerateReport("CFnotCleared", yrmo); } catch (Exception ex) { lbl_error.Text = "Error in generating Carry Forward not Cleared Report<br />" + ex.Message; } }
protected void lnk_genPtnmPartData_Rpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; string _qy = ddlQY.SelectedItem.Text.ToString(); try { HRA_Results.GenerateReport("PtnmPartData", _qy); } catch (Exception ex) { lbl_error.Text = "Error in generating 'Putnam Participant Data Report'<br />" + ex.Message; } }
protected void lnk_genReconRpt_OnClick(object sender, EventArgs e) { lbl_error.Text = ""; string _qy = ddlQY.SelectedItem.Text.ToString(); try { HRA_Results.GenerateReport("AdminRecon", _qy); } catch (Exception ex) { lbl_error.Text = "Error in generating 'Admin Invoice Reconciliation Report'<br />" + ex.Message; } }
protected void btn_genRpt2_Click(object sender, EventArgs e) { string yrmo = ddlYrmo2.SelectedItem.Text; div2_error.Visible = false; try { HRA_Results.GenerateReport("SOFO", yrmo); } catch (Exception ex) { div2_error.Visible = true; lbl_error2.Text = "Error in generating HRA Putnam Balance Report<br />" + ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["mid"] == null || Int32.Parse(Session["mid"].ToString()) == 0) { Response.Redirect("~/Home.aspx"); } if (!Page.IsPostBack) { string _filename, _filepath, _file; _filename = HRA_Results.GetFileName("Elig", String.Empty); _filepath = HRA_ReconDAL.GetFilePath(_class, "Elig"); _file = _filepath + _filename; tbx_eligPath.Text = _file; tbx_fldrPath.Text = "C:\\EligPGP"; string uname = HttpContext.Current.User.Identity.Name.ToString(); AdminBLL.InRole(uname, "M200", "M203"); } }
protected void btn_autoImport_Click(object sender, EventArgs e) { HRASofoDAL robj = new HRASofoDAL(); Impersonation _imp = new Impersonation(); string yrmo = ddlYrmo1.SelectedItem.Text; string clientfilename, clientfile, serverPath; string serverfile = ""; div1_error.Visible = false; div1_alert.Visible = false; if (Page.IsValid) { if (txtPrevYRMO1.Visible) { lbl_error1.Text = "Enter YRMO in format 'yyyymm'"; return; } try { serverPath = Server.MapPath("~/uploads/"); clientfilename = HRA.GetInputFileName(yrmo, source); serverfile = serverPath + clientfilename; if (_imp.impersonateValidUser(Session["uid"].ToString(), "CORP", EncryptDecrypt.Decrypt(Session["pwd"].ToString()))) { clientfile = HRAImportDAL.GetClientFilePath(_category, source) + "\\" + clientfilename; File.Copy(clientfile, serverfile); _imp.undoImpersonation(); } else { throw new Exception("Error in accessing network location"); } if (!(File.Exists(serverfile))) { throw new Exception("Unable to import file from specified location.<br/>Please check if file exists and you are logged in to the network."); } AutoReconcile(serverfile); HRA_Results.SavePrintFiles(_category, yrmo); viewresult1(yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskR(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "HRA", "Reconciliation", "SOFO Reconciliation", yrmo); } catch (Exception ex) { MultiView3.SetActiveView(view_main1); robj.ReconDelete(yrmo); div1_error.Visible = true; lbl_error1.Text = "Error - " + ex.Message; } finally { if (File.Exists(serverfile)) { File.Delete(serverfile); } } } }