protected void btnSave_Click(object sender, EventArgs e) { DataTable tbl = gvCvrg.DataSource as DataTable; if (tbl == null) { tbl = Data.GetPendingDependents(session_id, rblstEmployees.SelectedValue); } RadioButtonList rblst = null; string strRecord_id = ""; Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection(); Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction(); try { foreach (DataRow dr in tbl.Rows) { //rblst = FindControl ("rblst_" + dr["Record_id"].ToString()) as RadioButtonList; rblst = Bas_Utility.Utilities.GetRadioButtonList(Page, "rblst_" + dr["Record_id"].ToString()); strRecord_id = rblst.ID.Replace("rblst_", ""); if (rblst.SelectedValue.Equals("1")) { Data.MoveOutOfPending(session_id, strRecord_id, ViewState["User_Name"].ToString(), ViewState["email_apprve"].ToString()); ViewState["email_apprve"] = "0"; } else if (rblst.SelectedValue.Equals("0")) { Data.Deney_pending_Dep(session_id, strRecord_id, ViewState["User_Name"].ToString(), ViewState["email_descline"].ToString()); ViewState["email_descline"] = "0"; } else { //tx.Rollback(); //string strError = "<script>alert('You must ckeck all the dependents first')</script>"; //Page.ClientScript.RegisterStartupScript(Page.GetType(), "strError", strError); //return; } } tx.Commit(); } catch { tx.Rollback(); throw; } finally { SQLStatic.SQL.CloseConnection(conn); } jscriptsFunctions.Misc.AlertSaved(Page); if (!string.IsNullOrEmpty(Request.Params["ee"])) { if (!Data.HasMorePendingDep(Request.Params["ee"])) { Response.Redirect("default.aspx?SkipCheck=YES", true); } } if (!string.IsNullOrEmpty(Request.Params["ee"])) { DrawGrid(); if (!btnSave.Visible) { //btnNext.Enabled = true; lblNoPending.Visible = true; gvCvrg.Visible = false; return; } } Bulid_EEList(); if (rblstEmployees.Items.Count.Equals(0)) { Response.Redirect("Dependents.aspx?SkipCheck=YES&ee=" + Request.Params["ee"], true); } DrawGrid(); }
protected void Page_Load(object sender, EventArgs e) { #region BasTemplate if (!IsPostBack) { if ((Request.Params["SkipCheck"] == null) || (Request.Params["SkipCheck"] != "YES")) { SQLStatic.Sessions.SetSessionValue(Request.Cookies["Session_ID"].Value.ToString(), "main_run", Request.Path + "?SkipCheck=YES"); Response.Redirect("/web_projects/PTemplate/index.htm"); return; } Template.BasTemplate objBasTemplate = new Template.BasTemplate(); try { if (Request.Cookies["Session_ID"] == null) { Response.Redirect("/web_projects/login_error/ErrorPage.aspx?error=Cookie not found. Please signon first", true); } string strResult = objBasTemplate.Authenticate(Request.Cookies["Session_ID"].Value.ToString(), Request.Url.Authority.ToString(), Request.Url.AbsolutePath.ToString(), true, false); if (strResult != "") { Response.Redirect("/web_projects/login_error/ErrorPage.aspx?error=" + strResult, false); return; } ViewState["AccessType"] = objBasTemplate.strAccessType; ViewState["Employee_Number"] = objBasTemplate.strEmployee_Number; ViewState["Processing_Year"] = objBasTemplate.strProcessingYear; ViewState["Role_Restriction_Level"] = objBasTemplate.strRole_Restriction_Level; ViewState["Selected_Account_Number"] = objBasTemplate.strSelected_Account_Number; ViewState["Selected_Employee_Class_Code"] = objBasTemplate.strSelected_Employee_Class_Code; ViewState["User_Group_ID"] = objBasTemplate.strUser_Group_ID; ViewState["User_ID"] = objBasTemplate.strUser_ID; ViewState["User_Name"] = objBasTemplate.strUser_Name; ViewState["User_Primary_Role"] = objBasTemplate.strUser_Primary_Role; } catch (Exception ex) { string strError = "Error Message: " + ex.Message + "~~Application:" + ex.Source + "~~Method:" + ex.TargetSite + "~~Detail:" + ex.StackTrace; Response.Redirect("/web_projects/login_error/ErrorPage.aspx?error=" + strError.Replace("\n", "~")); } finally { objBasTemplate.CleanUp(); objBasTemplate.Dispose(); } } #endregion session_id = Request.Cookies["Session_ID"].Value.ToString(); if (!IsPostBack) { if (Data.requires_dep_verify(Request.Params["ee"]).Equals("1")) { SQLStatic.Sessions.SetSessionValue(session_id, "EMPLOYEE_NUMBER", Request.Params["ee"]); SQLStatic.Sessions.SetSessionValue(session_id, "ACCOUNT_NUMBER", SQLStatic.EmployeeData.Account_Number(Request.Params["ee"])); if (!string.IsNullOrEmpty(Request.Params["Verify"])) { Response.Redirect("/WEB_PROJECTS/DEPENDENT_AUDIT_WIZARD_APPROVAL/APPROVE.ASPX?SkipCheck=YES&type=2&EE=" + ViewState["Employee_Number"].ToString() + "&Verify=" + Request.Params["Verify"]); } else { Response.Redirect("/WEB_PROJECTS/DEPENDENT_AUDIT_WIZARD_APPROVAL/APPROVE.ASPX?SkipCheck=YES&type=2&EE=" + ViewState["Employee_Number"].ToString()); } } } if (!string.IsNullOrEmpty(Request.Params["ee"])) { if (!Data.HasMorePendingDep(Request.Params["ee"])) { Response.Redirect("default.aspx?SkipCheck=YES", true); } } if (!IsPostBack) { Bulid_EEList(); if (rblstEmployees.Items.Count.Equals(0)) { if (!string.IsNullOrEmpty(Request.Params["ee"])) { lblNoPending.Visible = true; jscriptsFunctions.Misc.Alert(Page, SQLStatic.EmployeeData.Account_Number(Request.Params["ee"]) + " Prcessed"); } else { try { jscriptsFunctions.Misc.Alert(Page, SQLStatic.EmployeeData.Account_Number(rblstEmployees.SelectedValue) + " Prcessed"); } catch { jscriptsFunctions.Misc.Alert(Page, " Prcessed"); } } btnBack_Click(null, null); //dveelist.Visible = false; //dvGrid.Style.Add("float", "left"); //dvButtons.Visible = false; //btnBack.Visible = true; ////btnNext.Visible = true; ////btnNext.Enabled = true; //btnSave.Visible = false; //lblNoPending.Visible = true; //lblNodep.Visible = false; return; } if (!string.IsNullOrEmpty(Request.Params["ee"])) { dveelist.Visible = false; dvGrid.Style.Add("float", "left"); btnBack.Visible = true; //btnNext.Visible = true; rblstEmployees.Items.FindByValue(Request.Params["ee"]).Selected = true; } else { btnBack.Visible = false; //btnNext.Visible = false; } ViewState["email_apprve"] = 1; ViewState["email_descline"] = 1; } if (rblstEmployees.Items.Count.Equals(0)) { if (string.IsNullOrEmpty(Request.Params["ee"])) { Response.Redirect("/WEB_PROJECTS/ADMIPOINT/DEFAULT.ASPX", true); } return; } if (SQLStatic.AccountData.RetaAccount(SQLStatic.EmployeeData.Account_Number(rblstEmployees.SelectedValue))) { dvButtons.Visible = false; ViewState["email_descline"] = 0; ViewState["email_apprve"] = 0; } DrawGrid(); try { lblName.Text = rblstEmployees.SelectedItem.Text + " Bas# " + rblstEmployees.SelectedValue + "<br />" + Generate_Account_Name(rblstEmployees.SelectedValue); } catch { lblName.Text = ""; } }