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 = "";
}
}