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);
}
}
}
}
