コード例 #1
0
ファイル: employeebranch.aspx.cs プロジェクト: bpfi/SLIK-BPFI
    private void SaveData()
    {
        GeneralDAL _dal         = null;
        Hashtable  _ht          = null;
        string     sNextEmpCode = string.Empty;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
            Shared.ApplyDefaultProp(_ht);

            _ht["branch_code"] = Request.Params["branch_code"];

            if (Request.Params["action"].Equals("add"))
            {
                _dal.Insert(TABLE_NAME, _ht, ref sNextEmpCode);
                txtEmployeeCode.Text = sNextEmpCode;
            }

            else
            {
                _dal.Update(TABLE_NAME, _ht);
            }

            Shared.ShowSuccessGritter(this, string.Format("employeebranch.aspx?action=edit&emp_code={0}&branch_code={1} ", txtEmployeeCode.Text, txtBranchCode.Text));
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #2
0
ファイル: masterwidget.aspx.cs プロジェクト: bpfi/SLIK-BPFI
    private void SaveData()
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
            Shared.ApplyDefaultProp(_ht);

            if (Request.Params["action"].Equals("add"))
            {
                _dal.Insert(TABLE_NAME, _ht);
            }

            else
            {
                _dal.Update(TABLE_NAME, _ht);
            }

            Shared.ShowSuccessGritter(this, string.Format("masterwidget.aspx?action=edit&code={0}", txtWidgetCode.Text));
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #3
0
    private void SaveData()
    {
        GeneralDAL _dal = null;
        Hashtable _ht = null;

        int iNextID = 0;

        try
        {
            _dal = new GeneralDAL();
            _ht = new Hashtable();

            MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);

            Shared.ApplyDefaultProp(_ht);

            _ht["p_id"] = txtId.Text;

            Shared.ApplyDefaultProp(_ht);

            if (Request.Params["action"].Equals("add"))
            {
                _dal.Insert(TABLE_NAME, _ht, ref iNextID);
                txtId.Text = iNextID.ToString() ;
            }
            else
                _dal.Update(TABLE_NAME, _ht);

            Shared.ShowSuccessGritter(this, string.Format("employeenotification.aspx?action=edit&id={0}", txtId.Text));
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #4
0
    private void SaveData()
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            MPF23.Shared.Mapper.UIToDB.Map(upd.Controls, _ht);

            Shared.ApplyDefaultProp(_ht);

            _ht["p_application_no"] = txtApplicationNoCustomer.Text;

            Shared.ApplyDefaultProp(_ht);


            if (Request.Params["action"].Equals("add"))
            {
                _dal.Insert(TABLE_NAME, _ht);
            }
            else
            {
                _dal.Update(TABLE_NAME, _ht);
            }

            Shared.ShowSuccessGritter(this, string.Format("applicationcustomer.aspx?action=edit&app_no={0}", txtApplicationNoCustomer.Text));
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #5
0
    private void SaveData()
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        int inextId = 0;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
            Shared.ApplyDefaultProp(_ht);

            _ht["p_code_question"] = txtCode.Text;

            if (Request.Params["action"].Equals("add"))
            {
                _dal.Insert(TABLE_NAME, _ht, ref inextId);
                txtId.Text = inextId.ToString();
            }

            else
            {
                _dal.Update(TABLE_NAME, _ht);
            }

            Shared.ShowSuccessGritter(this, string.Format("masterquestionchoice.aspx?action=edit&code={0}&id={1}", txtCode.Text, txtId.Text));
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #6
0
    private void AddDataToSourceGVW(string Code)
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            _ht["p_emp_code"]      = Request.Params["empcode"];
            _ht[SP_PARAMETER_CODE] = Code;
            Shared.ApplyDefaultProp(_ht);

            _dal.Insert("", SP_TARGET_TO_SOURCE, _ht);


            string script = "";
            if (Request.Params["gvw"] == null)
            {
                script += "javascript:parent.__doPostBack('ctl00$cpb$btnSearch','');";
            }
            else
            {
                script += "javascript:parent.__doPostBack('" + Request.Params["gvw"] + "','');";
            }

            ScriptManager.RegisterStartupScript(this, GetType(), "fn2", script, true);
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #7
0
    private void SaveDataCollection()
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
            Shared.ApplyDefaultProp(_ht);

            _ht["p_trx_no"] = lblTrxNo.Text;

            Shared.ApplyDefaultProp(_ht);

            if (Request.Params["action"].Equals("add"))
            {
                _dal.Insert(TABLE_NAME_MAIN, _ht);
            }

            else
            {
                _dal.Update(TABLE_NAME_MAIN, _ht);
            }

            Shared.ShowSuccessGritter(this, string.Format("collectionmain.aspx?action=edit&trxNo={0}", lblTrxNo.Text));
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #8
0
    private void SaveData()
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        int inextId = 0;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
            Shared.ApplyDefaultProp(_ht);

            _ht["p_id"] = Request.Params["id"];

            if (Request.Params["action"].Equals("add"))
            {
                _dal.Insert(TABLE_NAME_RESULTS, _ht, ref inextId);
                //txtID.Text = inextId.ToString();
            }

            else
            {
                _dal.Update(TABLE_NAME_RESULTS, _ht);
            }

            Shared.ShowSuccessGritter(this, string.Format("collectionresults.aspx?action=edit&id={0}", int.Parse(Request.Params["id"])));
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #9
0
    private void AddDataToTargetGVW(string Code)
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();
            for (int i = 0; i < Request.Params.Count; i++)
            {
                if (Request.Params.AllKeys[i] != null)
                {
                    if (Request.Params.AllKeys[i].StartsWith("par_"))
                    {
                        string par = Request.Params.AllKeys[i].Substring(4);

                        _ht["p_" + par] = Request.Params[i];
                    }
                    else if (Request.Params.AllKeys[i].StartsWith("parc_"))
                    {
                        string par = Request.Params.AllKeys[i].Substring(5);

                        _ht["p_" + par] = Request.Params[i];
                    }
                }
            }
            //System.Diagnostics.Debugger.Break();
            _ht[SP_PARAMETER_CODE] = Code;
            Shared.ApplyDefaultProp(_ht);

            _dal.Insert("", SP_SOURCE_TO_TARGET, _ht);

            string script = "";
            if (Request.Params["gvw"] == null)
            {
                script += "javascript:parent.__doPostBack('ctl00$cpb$btnSearch','');";
            }
            else
            {
                script += "javascript:parent.__doPostBack('" + Request.Params["gvw"] + "','');";
            }

            ScriptManager.RegisterStartupScript(this, GetType(), "fn2", script, true);
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #10
0
    //protected void btnSave_Click(object sender, EventArgs e)
    //{
    //    //commit data on gridview target
    //    CommitSaveData();
    //    string script = Shared.GenerateLookUpReturnString(ClientQueryString, gvwListTarget);
    //    ScriptManager.RegisterStartupScript(this, GetType(), "fn2", script, true);
    //}

    private void CommitSaveData()
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            _ht["p_emp_code"] = Request.Params["empcode"];
            Shared.ApplyDefaultProp(_ht);

            _dal.ExecRawSP(SP_SAVE_NAME, _ht);
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #11
0
    protected void btnChangeStatus_Click(object sender, EventArgs e)
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            _ht["p_code"] = Request.Params["subcode"];
            Shared.ApplyDefaultProp(_ht);

            _dal.ExecRawSP("xsp_master_general_subcode_update_status", _ht);
            Shared.ShowSuccessGritter(this, string.Format("mastergeneralsubcode.aspx?action=edit&general_code={0}&subcode={1}", txtGeneralCode.Text, txtCode.Text));
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #12
0
ファイル: masterwidget.aspx.cs プロジェクト: bpfi/SLIK-BPFI
    protected void btnChangeStatus_Click(object sender, EventArgs e)
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            _ht["p_code"] = Request.Params["code"];
            Shared.ApplyDefaultProp(_ht);

            _dal.ExecRawSP("xsp_master_widget_update_status", _ht); // untuk megeksekusi sp selain dari 5 sp pokok

            Shared.ShowSuccessGritter(this, string.Format("masterwidget.aspx?action=edit&code={0}", txtWidgetCode.Text));
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #13
0
ファイル: masterusermain.aspx.cs プロジェクト: bpfi/SLIK-BPFI
    protected void btnResetPassword_Click(object sender, EventArgs e)
    {
        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            _ht["p_uid"] = Request.Params["id"];
            Shared.ApplyDefaultProp(_ht);

            _dal.ExecRawSP("xsp_master_user_main_reset_password", _ht); // untuk megeksekusi sp selain dari 5 sp pokok

            Shared.ShowSuccessGritter(this, string.Format("masterusermain.aspx?action=edit&id={0}", lblId.Text));
        }
        catch (Exception ex)
        {
            Shared.ShowErrorDialog(this, ex);
        }
    }
コード例 #14
0
ファイル: Default.aspx.cs プロジェクト: bpfi/SLIK-BPFI
    //protected void Page_Load(object sender, EventArgs e)
    //{
    //    dataBranch();
    //    //LoadInit();
    //    if (!Page.IsPostBack)
    //    {
    //        //if (Request.Params["action"].Equals("edit"))
    //       // {
    //            //LoadData();
    //           // btnCancel.Text = "<i class='icon-remove'></i>Back";
    //        //}
    //    }
    //}

    //private void dataBranch()
    //{
    //    try
    //    {
    //        string constr = ConfigurationManager.ConnectionStrings["Test1"].ToString(); // connection string
    //        SqlConnection con = new SqlConnection(constr);
    //        con.Open();

    //        SqlCommand com = new SqlCommand("select * from Branch", con); // table name
    //        SqlDataAdapter da = new SqlDataAdapter(com);
    //        DataSet ds = new DataSet();
    //        da.Fill(ds);  // fill dataset
    //        txtBRANCH.DataTextField = ds.Tables[0].Columns["BranchFullName"].ToString(); // text field name of table dispalyed in dropdown
    //        txtBRANCH.DataValueField = ds.Tables[0].Columns["BranchID"].ToString();             // to retrive specific  textfield name
    //        txtBRANCH.DataSource = ds.Tables[0];      //assigning datasource to the dropdownlist
    //        txtBRANCH.DataBind();  //binding
    //        con.Close();
    //    }
    //    catch (Exception err)
    //    {

    //    }
    //}
    protected void btnSignIn_Click(object sender, EventArgs e)
    {
        //HttpCookie cookie = new HttpCookie("CurrentLanguage");
        //cookie.Value = ddlLanguage.SelectedValue;
        //Response.SetCookie(cookie);



        /*
         * validate user
         * if row > 0, maka ambil role user tersebut
         * redirect ke main.aspx
         * jika tidak, show error
         */

        GeneralDAL _dal = null;
        Hashtable  _ht  = null;

        bool IsValidUser     = true;
        bool IsValidPassword = true;
        bool IsActiveUser    = true;

        string UID = "";

        try
        {
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            _ht["p_uid"]      = txtUID.Text;
            _ht["p_password"] = txtPassword.Text;

            DataRow dr = _dal.GetRow("", "xsp_master_user_main_validate", _ht);

            //dr null jika tidak ada record, langsung lari ke catch
            if (dr != null)
            {
                UID = dr["ID"].ToString();

                if (dr["UPASS"].ToString().Equals(dr["UPASSMD5"].ToString()))
                {
                    //Masukan Role disini
                    //if (dr["p_uid"].ToString() == "ADM000")
                    //{
                    //    Response.Redirect("/module/finance/agunan.aspx");
                    //}

                    if (((int)dr["LAST_FAIL_COUNT"]) >= 5)
                    {
                        IsValidPassword = false;
                    }
                    else
                    {
                        if (dr["IS_ACTIVE"].ToString().Equals("1"))    //artinya user aktif
                        {
                            //reset fail count
                            _ht["p_uid"] = UID;
                            _dal.Update("", "xsp_master_user_main_reset_fail_count", _ht);

                            //update last login
                            _ht["p_uid"]        = UID;
                            _ht["p_login_date"] = DateTime.Now;
                            _dal.Update("", "xsp_master_user_main_update_last_login", _ht);

                            //save user profile ke session
                            Session[SessionKey.CURRENT_USER_SESSION_KEY] = dr;

                            //save user role ke session
                            Session[SessionKey.CURRENT_USER_ROLE_SESSION_KEY] = _dal.GetRows("", "xsp_master_user_main_getroles", _ht);

                            //save user ip address
                            if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] == null)
                            {
                                Session[SessionKey.CURRENT_USER_IP_ADDRESS_SESSION_KEY] = Request.ServerVariables["REMOTE_ADDR"];
                            }
                            else
                            {
                                Session[SessionKey.CURRENT_USER_IP_ADDRESS_SESSION_KEY] = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                            }

                            //insert master user login log
                            _ht["p_uid"]        = UID;
                            _ht["p_ip_address"] = Shared.CurrentIPAddress;
                            _ht["p_flag_code"]  = "SUCCESS";
                            Shared.ApplyDefaultProp(_ht);
                            _dal.Insert("", "xsp_master_user_login_log_insert", _ht);

                            if (((DateTime)dr["NEXT_CHANGE_PASS"]) <= DateTime.Now)
                            {
                                ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowModalChangePassword();", true);;
                            }
                            else
                            {
                                //redirect ke halaman main
                                //Response.Redirect("main.aspx");
                                //Masukan Role disini
                                if (dr["ID"].ToString() == "ADM000")
                                {
                                    Response.Redirect("branch/main_000.aspx");
                                }
                                else if (dr["ID"].ToString() == "1000000003")
                                {
                                    Response.Redirect("main.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM001")
                                {
                                    Response.Redirect("branch/main_001.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM002")
                                {
                                    Response.Redirect("branch/main_002.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM004")
                                {
                                    Response.Redirect("branch/main_004.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM005")
                                {
                                    Response.Redirect("branch/main_005.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM006")
                                {
                                    Response.Redirect("branch/main_006.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM007")
                                {
                                    Response.Redirect("branch/main_007.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM008")
                                {
                                    Response.Redirect("branch/main_008.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM009")
                                {
                                    Response.Redirect("branch/main_009.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM010")
                                {
                                    Response.Redirect("branch/main_010.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM011")
                                {
                                    Response.Redirect("branch/main_011.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM012")
                                {
                                    Response.Redirect("branch/main_012.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM013")
                                {
                                    Response.Redirect("branch/main_013.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM014")
                                {
                                    Response.Redirect("branch/main_014.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM015")
                                {
                                    Response.Redirect("branch/main_015.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM016")
                                {
                                    Response.Redirect("branch/main_016.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM017")
                                {
                                    Response.Redirect("branch/main_017.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM018")
                                {
                                    Response.Redirect("branch/main_018.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM019")
                                {
                                    Response.Redirect("branch/main_019.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM020")
                                {
                                    Response.Redirect("branch/main_020.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM021")
                                {
                                    Response.Redirect("branch/main_021.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM022")
                                {
                                    Response.Redirect("branch/main_022.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM023")
                                {
                                    Response.Redirect("branch/main_023.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM024")
                                {
                                    Response.Redirect("branch/main_024.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM025")
                                {
                                    Response.Redirect("branch/main_025.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM026")
                                {
                                    Response.Redirect("branch/main_026.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM027")
                                {
                                    Response.Redirect("branch/main_027.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM028")
                                {
                                    Response.Redirect("branch/main_028.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM029")
                                {
                                    Response.Redirect("branch/main_029.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM030")
                                {
                                    Response.Redirect("branch/main_030.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM031")
                                {
                                    Response.Redirect("branch/main_031.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM032")
                                {
                                    Response.Redirect("branch/main_032.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM033")
                                {
                                    Response.Redirect("branch/main_033.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM034")
                                {
                                    Response.Redirect("branch/main_034.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM035")
                                {
                                    Response.Redirect("branch/main_035.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM036")
                                {
                                    Response.Redirect("branch/main_036.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM037")
                                {
                                    Response.Redirect("branch/main_037.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM038")
                                {
                                    Response.Redirect("branch/main_038.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM039")
                                {
                                    Response.Redirect("branch/main_039.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM040")
                                {
                                    Response.Redirect("branch/main_040.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM041")
                                {
                                    Response.Redirect("branch/main_041.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM042")
                                {
                                    Response.Redirect("branch/main_042.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM043")
                                {
                                    Response.Redirect("branch/main_043.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM044")
                                {
                                    Response.Redirect("branch/main_044.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM045")
                                {
                                    Response.Redirect("branch/main_045.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM046")
                                {
                                    Response.Redirect("branch/main_046.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM047")
                                {
                                    Response.Redirect("branch/main_047.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM048")
                                {
                                    Response.Redirect("branch/main_048.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM049")
                                {
                                    Response.Redirect("branch/main_049.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM050")
                                {
                                    Response.Redirect("branch/main_050.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM051")
                                {
                                    Response.Redirect("branch/main_051.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM052")
                                {
                                    Response.Redirect("branch/main_052.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM053")
                                {
                                    Response.Redirect("branch/main_053.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM054")
                                {
                                    Response.Redirect("branch/main_054.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM055")
                                {
                                    Response.Redirect("branch/main_055.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM056")
                                {
                                    Response.Redirect("branch/main_056.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM057")
                                {
                                    Response.Redirect("branch/main_057.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM058")
                                {
                                    Response.Redirect("branch/main_058.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM059")
                                {
                                    Response.Redirect("branch/main_059.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM060")
                                {
                                    Response.Redirect("branch/main_060.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM061")
                                {
                                    Response.Redirect("branch/main_061.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM062")
                                {
                                    Response.Redirect("branch/main_062.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM063")
                                {
                                    Response.Redirect("branch/main_063.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM064")
                                {
                                    Response.Redirect("branch/main_064.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM065")
                                {
                                    Response.Redirect("branch/main_065.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM066")
                                {
                                    Response.Redirect("branch/main_066.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM067")
                                {
                                    Response.Redirect("branch/main_067.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM068")
                                {
                                    Response.Redirect("branch/main_068.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM069")
                                {
                                    Response.Redirect("branch/main_069.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM070")
                                {
                                    Response.Redirect("branch/main_070.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM071")
                                {
                                    Response.Redirect("branch/main_071.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM072")
                                {
                                    Response.Redirect("branch/main_072.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM073")
                                {
                                    Response.Redirect("branch/main_073.aspx");
                                }
                                else if (dr["ID"].ToString() == "ADM0900")
                                {
                                    Response.Redirect("branch/main_0900.aspx");
                                }
                            }
                        }
                        else
                        {
                            IsActiveUser = false;
                        }
                    }
                }
                else
                {
                    IsValidPassword = false;
                }
            }
            else
            {
                IsValidUser = false;
            }
        }
        catch
        {
            IsValidUser = false;
        }


        if (!IsActiveUser)
        {
            //show ke user message box, jika user dia tidak aktif
            ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('User not active. Please contact your MIS/IT Department.', '');", true);
        }
        else if (!IsValidPassword)
        {
            //cek last fail count untuk uid yang login
            _dal = new GeneralDAL();
            _ht  = new Hashtable();

            _ht["p_id"] = UID;

            DataRow dr = _dal.GetRow("", "xsp_master_user_main_getrow", _ht);


            _ht["p_login_date"]     = DateTime.Now;
            _ht["p_cre_date"]       = DateTime.Now;
            _ht["p_cre_by"]         = txtUID.Text;
            _ht["p_cre_ip_address"] = "127.0.0.1";

            if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] == null)
            {
                _ht["p_ip_address"] = Request.ServerVariables["REMOTE_ADDR"];
            }
            else
            {
                _ht["p_ip_address"] = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
            }


            if (((int)dr["LAST_FAIL_COUNT"]) >= 5)
            {
                _ht["p_flag_code"] = "FAIL MAX ATTEMPT";
                _ht["p_uid"]       = UID;

                //insert master user login log
                _dal.Insert("", "xsp_master_user_login_log_insert", _ht);

                //show warning max login attempt reached
                ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('Maximum try login reached. Please contact your MIS/IT Department.', '');", true);
            }
            else // jika uid tersebut tidak ada berarti invalid user, langsung di catch
            {
                _ht["p_flag_code"]      = "FAIL PASSWORD";
                _ht["p_uid"]            = UID;
                _ht["p_mod_date"]       = DateTime.Now.ToString("yyyy-MM-dd");
                _ht["p_mod_by"]         = txtUID.Text;
                _ht["p_mod_ip_address"] = "127.0.0.1";

                //insert master user login log
                try
                {
                    _dal.Insert("", "xsp_master_user_login_log_insert", _ht);

                    //update last fail count -> ditambahkan 1
                    _dal.Update("", "xsp_master_user_main_increment_fail_count", _ht);

                    ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('Invalid password', '');", true);
                }
                catch (Exception exp)
                {
                    string error = exp.Message;
                }
            }
        }
        else if (!IsValidUser)
        {
            ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('Invalid user', '');", true);
        }
    }