コード例 #1
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        //const int para = 2;
        try
        {
            #region old
            //string cardnbr = "", usermodify = "";
            //usermodify = (string)Session["Username"];

            //cardnbr = tbSoThe.Text.Trim();
            //if (cardnbr != "")
            //{
            //    //cardnbr in varchar2,
            //    //usermodify in varchar2, 
            //    //Result_out out number,
            //    //Emsg_out out varchar2
            //    int i = 0;
            //    string name = "" + executedb.owner + "proc_unlock_pin";
            //    string[] InParaName = new string[2] { "cardnbr", "usermodify" };
            //    string[] OutParaName = new string[para] { "Result_out", "Emsg_out" };
            //    OracleType[] InParaType = new OracleType[2] { OracleType.VarChar, OracleType.VarChar };
            //    OracleType[] OutParaType = new OracleType[para] { 
            //        OracleType.Number,
            //        OracleType.VarChar
            //        //OracleType.Number
            //        };
            //    string[] InParaValues = new string[2] { cardnbr, usermodify };
            //    string[] OutParaValues = new string[para];
            //    for (i = 0; i < para; i++)
            //        OutParaValues[i] = "";
            //    int[] OutParaSize = new int[para] {
            //         0,                    
            //         200
            //    };
            //    string err = "";
            //    executedb.ExecuteProc(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref  OutParaValues, ref  err);
            //    if (err != "")
            //    {
            //        executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), "" + executedb.owner + "proc_close_card" + " --> " + err);
            //        //executedb.WriteLogPri(Environment.NewLine + DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString() + " - " + Session["Username"].ToString() + ": " + sql + Environment.NewLine + err1);
            //        //Response.Write("<script>alert('Error when executing from database!!!')</script>");
            //        Alert.Show("Error when executing from database!!!", this);
            //        //executedb.WriteLogPri(Environment.NewLine + DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString() + " - " + Session["Username"].ToString() + ": " + ""+ executedb.owner + "proc_nabcustomercarecredit" + " --> " + err);
            //        ////Response.Write("<script>alert('Error when executing from database!!!')</script>");
            //        //Alert.Show("Error when executing from database!!!", this);
            //    }
            //    else
            //    {
            //        if (OutParaValues[1].ToString() == "-1")
            //        {
            //            executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), "" + executedb.owner + "proc_unlock_pin" + " --> " + " --> " + err + Environment.NewLine + "Error Code: " + OutParaValues[1].ToString());
            //            Alert.Show("Error when executing from database!!!  Error Code:" + OutParaValues[1].ToString(), this);
            //        }
            //        else
            //        {
            //            Alert.Show("Đã thực hiện mở khóa PIN thành công cho thẻ: " + tbSoThe.Text, this);
            //            executedb.WriteLogINFO(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), " Mở khóa PIN thành công cho thẻ: " + tbSoThe.Text);
            //        }
            //        LoadData();
            //    }
            //}
#endregion
            conTTTSOA reset = new conTTTSOA();
            string sothe = tbSoThe.Text.Trim();
            string result = "";
            result = reset.SOA_Reset_Pin("WEB", sothe, "82");
            int s_rs = 8, e_rs = result.IndexOf("</result>"), s_msg = result.IndexOf("<msg>"), e_msg = result.IndexOf("</msg>");
            //Alert.Show(result.Substring(s_rs, e_rs - 8) + "___" + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
            if (result.Substring(s_rs, e_rs - 8) == "0")
            {
                Alert.Show("Thành công! Số thẻ: " + tbSoThe.Text.Trim(), this);
            }
            else
            {
                Alert.Show("Lỗi: " + result.Substring(s_rs, e_rs - 8) + " - " + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
            }
        }
        catch (Exception ex)
        {
            Alert.Show("Error from coding .....\\n", this);
            executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), ex.Message);
            //executedb.WriteLogPri(Environment.NewLine + DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString() + " - " + Session["Username"].ToString() + ": " + Environment.NewLine + ex.Message);
        }
    }
コード例 #2
0
 protected void Button2_Click(object sender, EventArgs e)
 {
     //const int para = 2;
     try
     {            
         conTTTSOA kichhoat = new conTTTSOA();
         
         string sothe = tbSoThe.Text.Trim();
         string result = "";
         string userid = (string)Session["Username"];
         if (userid == "")
         {
             ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                       "err_msg",
                       "alert('Please log on again !!');window.location='../Default.aspx';",
                        true );
             return;
         }
         result = kichhoat.SOA_Delivery_Card("WEB", sothe, "82");
         int s_rs = 8, e_rs = result.IndexOf("</result>"), s_msg = result.IndexOf("<msg>"), e_msg = result.IndexOf("</msg>");
         //Alert.Show(result.Substring(s_rs, e_rs - 8) + "___" + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
         if (result.Substring(s_rs, e_rs - 8) == "0")
         {
             string sql = "", err = "";
             sql = " insert into nab_staff_process_logs_new ";
             sql += " (function_type,table_name,tag_value,user_create,date_create)";
             sql += " values ";
             sql += " ('Active Card' , 'SOA' , '" + sothe + "', '" + userid + "',sysdate)";
             if (executedb.ExecuteDML ( sql, ref err ))
             {
                 ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                       "err_msg",
                       "alert('Success!!!');",
                        true );
                 return;
             }
             else
             {
                 ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                        "err_msg",
                        "alert('Insert fail : " + err + "');",
                         true );
                 return;
             }
         }
         else
         {
             Alert.Show("Lỗi: " + result.Substring(s_rs, e_rs - 8) + " - " + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
         }
     }
     catch (Exception ex)
     {
         Alert.Show("Error from coding .....\\n", this);
         executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), ex.Message);
         //executedb.WriteLogPri(Environment.NewLine + DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString() + " - " + Session["Username"].ToString() + ": " + Environment.NewLine + ex.Message);
     }
 }
 private void Save()
 {
     try
     {
         if (tbCardNbr.Text.Trim() == "" || tbCardNbr.Visible == false)
         {
             Alert.Show("Chọn khách hàng.", this);
             return;
         }
         string userid = (string)Session["Username"];
         if (userid == "")
         {
             ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                       "err_msg",
                       "alert('Please log on again !!');window.location='../Default.aspx';",
                        true );
             return;
         }
         else
         {
             
             string result = "", cardnum = "", intype = "";
             if (cbTinhTrangDangKy.SelectedValue == "1" || cbTinhTrangDangKy.Text == "Đăng ký")
             {
                 intype = "A";
             }
             else
             { 
                 intype = "I"; 
             }
             cardnum = tbCardNbr.Text.Trim();
             conTTTSOA soa = new conTTTSOA();
             result = soa.SOA_Update_ECom_Flag("Web", cardnum, intype, "82");
             int s_rs = 8, e_rs = result.IndexOf("</result>"), s_msg = result.IndexOf("<msg>"), e_msg = result.IndexOf("</msg>");
             //Alert.Show(result.Substring(s_rs, e_rs - 8) + "___" + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
             if (result.Substring(s_rs, e_rs - 8) == "0")
             {
                 string sql = "", err = "";
                 sql = " insert into nab_staff_process_logs_new ";
                 sql += " (function_type,table_name,tag_value,user_create,date_create)";
                 sql += " values ";
                 sql += " ('Ecom Register' , 'SOA' , '" + cardnum + "', '" + userid + "',sysdate)";
                 if (!executedb.ExecuteDML ( sql, ref err ))
                 {
                     ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                            "err_msg",
                            "alert('Insert fail : " + err + "');",
                             true );
                     return;
                 }
                 if (cbTinhTrangDangKy.SelectedValue == "1" || cbTinhTrangDangKy.Text == "Đăng ký")
                     Alert.Show("Đăng kí thành công! Số thẻ: " + cardnum, this);
                 else
                 {
                     Alert.Show("Hủy thành công! Số thẻ: " + cardnum, this);
                 }
             }
             else
             {
                 Alert.Show("Lỗi: " + result.Substring(s_rs, e_rs - 8) + " - " + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
             }
         }
     }
     catch { }
 }
コード例 #4
0
    protected void bt_Autho_Click(object sender, EventArgs e)
    {
        if (tb_Acc.Text.Trim() != "")
        {
            string usercreate = "", nqh_code = "", account = "",
                        profile = "", content = "";
            string[] event_code = cbNhomNo.SelectedValue.ToString().Split('|');
            content = cbNhomNo.Text;
            
            usercreate = (string)Session["Username"];
            account = tb_Acc.Text.Trim();
            profile = tb_ProfileCode.Text;

            try
            {
                
                if (rbproc.Checked)
                {
                    Alert.Show("Không chọn chức năng này !!! ", this);
                    /* Tam Hide lai phan chon Proc*/
                    //nqh_code = event_code[1];
                    //content = event_code[0];
                    //string id = getAccountID(account);
                    //if (id != "")
                    //{
                    //    if (profile.Trim() == "")
                    //    {
                    //        executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), "Can not get Profile Code for account:" + account);
                    //        Alert.Show("Error when get profile code for account:" + account, this);
                    //        return;
                    //    }
                    //    int i = 0;
                    //    string name = "CALL_EVENT";
                    //    string[] InParaName = new string[3] { "Contract_ID", "EVENT_ID", "CONTENT" };
                    //    OracleType[] InParaType = new OracleType[3] { OracleType.Number, OracleType.Number, OracleType.VarChar };
                    //    string[] InParaValues = new string[3] { id, nqh_code, content };
                    //    string[] OutParaName = new string[1] { "Emsg_out" };
                    //    OracleType[] OutParaType = new OracleType[1] { OracleType.VarChar };
                    //    int[] OutParaSize = new int[1] { 200 };
                    //    string[] OutParaValues = new string[1] {""};
                    //    string err = "";
                    //    executedb.ExecuteProc(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref OutParaValues, ref err);
                    //    if (err != "")
                    //    {
                    //        executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), "" + executedb.owner + "CALL_EVENT" + " --> " + err);
                    //        Alert.Show("Error when executing from database!!!", this);
                    //    }
                    //    else
                    //    {
                    //        if (OutParaValues[0].ToString().Substring(0,2) != "OK")
                    //        {
                    //            update_data(id, content, usercreate, "0", "Y");
                    //            Visible();
                    //            LoadGrid("N");
                    //            executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), "" + executedb.owner + "CALL_EVENT" + " --> " + " --> " + err + Environment.NewLine + "Error Code: " + OutParaValues[0].ToString());
                    //            Alert.Show("Error when executing from database!!!  Error Code:" + OutParaValues[0].ToString(), this);
                    //        }
                    //        else
                    //        {
                    //            update_data(id, content, usercreate, "1", "Y");
                    //            Visible();
                    //            LoadGrid("N");
                    //            bt_Autho.Enabled = false;
                    //            Alert.Show("Duyệt thành công !!! ", this);
                    //            executedb.WriteLogINFO(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), "Chuyen nhom no thanh cong cho tai khoan: " + account);
                    //        }
                    //    }
                    //}
                }
                else if (rbSOA.Checked)
                {
                    string result = "", err = "" ;
                    nqh_code = event_code[0];
                    if (err != "")
                    {
                        Alert.Show(err);
                    }
                    else
                    {
                            conTTTSOA soa = new conTTTSOA();
                            result = soa.SOA_Update_OVD("Web", account, nqh_code, "86");
                            int s_rs = 8, e_rs = result.IndexOf("</result>"), s_msg = result.IndexOf("<msg>"), e_msg = result.IndexOf("</msg>");

                            if (result.Substring(s_rs, e_rs - 8) == "0")
                            {
                                update_data(getAccountID(account), nqh_code, usercreate, "1", "Y");
                                Alert.Show("Duyệt thành công !!!", this);
                                LoadGrid("N");
                                Visible();
                            }
                            else
                            {
                                update_data(getAccountID(account), nqh_code, usercreate, "0", "Y");
                                 Alert.Show("Thực hiện chuyển nhóm nợ đã lỗi!", this);
                            }
                   }
               }
            }
            catch (Exception ex)
            {
                #region logException
                executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), ex.Message);
                Alert.Show("Error when executing coding!!!", this);
                #endregion logException
            }
        }
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        //Save(); //old
        try
        {
            string userid = (string)Session["Username"];
            if (userid == "")
            {
                ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                          "err_msg",
                          "alert('Please log on again !!');window.location='../Default.aspx';",
                           true );
                return;
            }
            string in_cr_account_nbr = "", in_autopayment_acc = "", AUTO_PAYMENT_FLAG = "";
            in_autopayment_acc = tbAC_Auto_payment.Text;            
            if (cbAuto_payment.Text.Trim().ToUpper() == "NONE")
            {
                AUTO_PAYMENT_FLAG = "000";
            }
            else
            {

                if (cbAuto_payment.Text.Trim().ToUpper() == "MIN DUE")// || cbAuto_payment.Text.Trim().ToUpper() == "Full Payment".ToUpper())
                {
                    AUTO_PAYMENT_FLAG = "M";
                }
                else
                {
                    if (cbAuto_payment.Text.Trim().ToUpper() == "Full Payment".ToUpper())
                        AUTO_PAYMENT_FLAG = "100";
                    else
                    {
                        if (cbAuto_payment.Text.Trim().ToUpper() == "Percentage".ToUpper())
                        {
                            if (tbPercent_Auto_payment.Text.Trim() == "")
                            {
                                Alert.Show("Please input percent to auto_payment!!!", this);
                                return;
                            }
                            else
                            {
                                try
                                {
                                    if (Convert.ToInt16(tbPercent_Auto_payment.Text.Trim()) > 100 || Convert.ToInt16(tbPercent_Auto_payment.Text.Trim()) < 0)
                                    {
                                        Alert.Show("Percent not corect!!!", this);
                                        return;
                                    }
                                    else
                                    {
                                        if (Convert.ToInt16(tbPercent_Auto_payment.Text.Trim()) < 10)
                                            AUTO_PAYMENT_FLAG = "00" + tbPercent_Auto_payment.Text.Trim();
                                        else
                                        {
                                            if (Convert.ToInt16(tbPercent_Auto_payment.Text.Trim()) >= 10 && Convert.ToInt16(tbPercent_Auto_payment.Text.Trim()) < 100)
                                            { AUTO_PAYMENT_FLAG = "0" + tbPercent_Auto_payment.Text.Trim(); }
                                            else
                                                AUTO_PAYMENT_FLAG = tbPercent_Auto_payment.Text.Trim();
                                        }
                                    }
                                }
                                catch
                                {
                                    Alert.Show("Percent not corect!!!", this);
                                    return;
                                }
                            }
                        }
                    }
                }
            }

            string sql = "", err = "";
            sql += "select ca.contract_number ";
            sql += "from " + executedb.owner + "acnt_contract ca ";
            sql += "where 1 = 1 ";
            sql += "  and ca.amnd_state ='A' ";
            sql += "  and ca.id = (select c.acnt_contract__oid ";
            sql += "               from " + executedb.owner + "acnt_contract c ";
            sql += "               where 1 = 1 ";
            sql += "                 and c.amnd_state = 'A' ";
            sql += "                 and c.con_cat = 'C' ";
            sql += "                 and c.contract_number = '" + tbCardNbr.Text.Trim() + "') ";
            DataTable issdt = executedb.getTable(sql, ref err);
            if (err != "")
            {
                Alert.Show("Error: " + err, this);
                return;
            }
            else
            {
                if (issdt.Rows.Count > 0)
                {
                    in_cr_account_nbr = issdt.Rows[0][0].ToString().Trim();
                }
                else
                {
                    Alert.Show("Không tìm thấy Số tài khoản cho thẻ này!", this);
                    return;
                }
            }
            conTTTSOA autopm = new conTTTSOA();
            string result = "";
            result = autopm.SOA_Update_Autopayment("Web", in_cr_account_nbr, in_autopayment_acc,AUTO_PAYMENT_FLAG, "82");
            int s_rs = 8, e_rs = result.IndexOf("</result>"), s_msg = result.IndexOf("<msg>"), e_msg = result.IndexOf("</msg>");
            if (result.Substring(s_rs, e_rs - 8) == "0")
            {
                sql = " insert into nab_staff_process_logs_new ";
                sql += " (function_type,table_name,tag_value,user_create,date_create)";
                sql += " values ";
                sql += " ('Update Auto Payment' , 'SOA' , '" + in_cr_account_nbr + "', '" + userid + "',sysdate)";
                if (executedb.ExecuteDML ( sql, ref err ))
                {
                    ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                          "err_msg",
                          "alert('Thành công! Số thẻ: " + tbCardNbr.Text.Trim ( ) + "');",
                           true );
                    return;
                }
                else
                {
                    ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                           "err_msg",
                           "alert('Insert fail : " + err + "');",
                            true );
                    return;
                }
            }
            else
            {
                Alert.Show("Lỗi: " + result.Substring(s_rs, e_rs - 8) + " - " + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
            }
        }
        catch
        {

        }
    }
コード例 #6
0
 private void Save()
 {
     try
     {
         if (tbCardNbr.Text.Trim() == "" || tbCardNbr.Visible == false)
         {
             Alert.Show("Chọn khách hàng.", this);
             return;
         }
         if (Session["Username"].ToString().Trim() == "")
         {
             Alert.Show("Ngắt section.Vui lòng đăng nhập lại.", this);
             return;
         }
         else
         {
             
             string result = "", cardnum = "", intype = "";
             if (cbVIP.SelectedValue == "0" || cbVIP.Text == "Normal")
                 intype = "N";
             else                    
             {
                 if (cbVIP.SelectedValue == "1" || cbVIP.Text == "VIP")
                 {
                     intype = "V";
                 }
                 else
                 {
                     intype = "S";
                 }
             }
             cardnum = tbCardNbr.Text.Trim();
             conTTTSOA soa = new conTTTSOA();
             result = soa.SOA_Update_Vip_Flag("Web", cardnum, intype, "82");
             int s_rs = 8, e_rs = result.IndexOf("</result>"), s_msg = result.IndexOf("<msg>"), e_msg = result.IndexOf("</msg>");
             //Alert.Show(result.Substring(s_rs, e_rs - 8) + "___" + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
             if (result.Substring(s_rs, e_rs - 8) == "0")
             {
                 Alert.Show("Thành công! Số thẻ: " + cardnum, this);
             }
             else
             {
                 Alert.Show("Lỗi: " + result.Substring(s_rs, e_rs - 8) + " - " + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
             }
         }
     }
     catch { }
 }
コード例 #7
0
 protected void Button2_Click(object sender, EventArgs e)
 {
     #region proc_old
     //const int para = 2;
     //try
     //{
     //    string cardnbr = "", usermodify = "";
     //    usermodify = (string)Session["Username"];
     //    string type = "";
     //    if (rbVanBan.Checked)
     //    {
     //        type = "VB";
     //    }
     //    else
     //    {
     //        type = "MB";
     //    }
     //    cardnbr = tbSoThe.Text.Trim();
     //    if (cardnbr != "")
     //    {
     //        int i = 0;
     //        string name = "" + executedb.owner + "proc_close_card";
     //        string[] InParaName = new string[3] { "cardnbr", "usermodify", "type" };
     //        string[] OutParaName = new string[para] { "Result_out", "Emsg_out" };
     //        OracleType[] InParaType = new OracleType[3] { OracleType.VarChar, OracleType.VarChar, OracleType.VarChar };
     //        OracleType[] OutParaType = new OracleType[para] { 
     //        OracleType.Number,
     //        OracleType.VarChar
     //        };
     //        string[] InParaValues = new string[3] { cardnbr, usermodify, type };
     //        string[] OutParaValues = new string[para];
     //        for (i = 0; i < para; i++)
     //            OutParaValues[i] = "";
     //        int[] OutParaSize = new int[para] {
     //         0,                    
     //         200
     //    };
     //        string err = "";
     //        executedb.ExecuteProc(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, ref  OutParaValues, ref  err);
     //        if (err != "")
     //        {
     //            executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), "" + executedb.owner + "proc_close_card" + " --> " + err);
     //            Alert.Show("Error when executing from database!!!", this);
     //        }
     //        else
     //        {
     //            if (OutParaValues[1].ToString() == "-1")
     //            {
     //                executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), "" + executedb.owner + "proc_close_card" + " --> " + " --> " + err + Environment.NewLine + "Error Code: " + OutParaValues[1].ToString());
     //                Alert.Show("Error when executing from database!!!  Error Code:" + OutParaValues[1].ToString(), this);
     //            }
     //            else
     //            {
     //                Alert.Show("Đã thực hiện Khóa thẻ thành công cho thẻ: " + tbSoThe.Text, this);
     //                executedb.WriteLogINFO(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), " Đã thực hiện Khóa thẻ thành công cho thẻ: " + tbSoThe.Text);
     //            }
     //            LoadData();
     //        }
     //    }
     //}
     #endregion
     try
     {
         string cardnum = tbSoThe.Text.Trim();
         string ten = tbTenKH.Text.Trim();
         string result = "";
         string userid = (string)Session["Username"];
         if (userid == "")
         {
             ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                       "err_msg",
                       "alert('Please log on again !!');window.location='../Default.aspx';",
                        true );
             return;
         }
         conTTTSOA soa = new conTTTSOA();
         result = soa.SOA_Lock_Card("WEB", cardnum, "82");
         int s_rs = 8, e_rs = result.IndexOf("</result>"), s_msg = result.IndexOf("<msg>"), e_msg = result.IndexOf("</msg>");
         //Alert.Show(result.Substring(s_rs, e_rs - 8) + "___" + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
         if (result.Substring(s_rs, e_rs - 8) == "0")
         {
             string sql = "", err = "";
             sql = " insert into nab_staff_process_logs_new ";
             sql += " (function_type,table_name,tag_value,user_create,date_create)";
             sql += " values ";
             sql += " ('Lock Card' , 'SOA' , '" + cardnum + "', '" + userid + "',sysdate)";
             if (executedb.ExecuteDML ( sql, ref err ))
             {
                 ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                       "err_msg",
                       "alert('Success!!!');",
                        true );
                 return;
             }
             else
             {
                 ScriptManager.RegisterStartupScript ( this.Page, this.Page.GetType ( ),
                        "err_msg",
                        "alert('Insert fail : " + err + "');",
                         true );
                 return;
             }
             
         }
         else
         {
             Alert.Show("Lỗi: " + result.Substring(s_rs, e_rs - 8) + " - " + result.Substring(s_msg + 5, e_msg - s_msg - 5), this);
         }
     }
     catch (Exception ex)
     {
         #region logException
         executedb.WriteLogERROR(Session["Username"].ToString(), "IP: " + Request.UserHostAddress, this.Page.ToString(), System.Reflection.MethodBase.GetCurrentMethod().ToString(), ex.Message);
         //executedb.WriteLogPri(Environment.NewLine + DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString() + " - " + Session["Username"].ToString() + ": " + ex.Message);
         //Response.Write("<script>alert('Error when executing coding')</script>");
         Alert.Show("Error when executing coding!!!", this);
         #endregion logException
     }
 }