private void sendMailToolStripMenuItem_Click(object sender, EventArgs e)
        {
            string sql = "", err = "";
            if (dataGridView1.Rows.Count == 0)
            {
                MessageBox.Show("Please choose 1 row for editing");
                return;
            }
            if (dataGridView1.Rows.Count > 0)
            {
                this.Cursor = Cursors.WaitCursor;
                string app_no = dataGridView1["application_no", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string legal_id = dataGridView1["legal_id", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                //string client_code = dataGridView1["client_code", dataGridView1.CurrentCell.RowIndex].Value.ToString(); //2014-09-16 (7)
                string hold_flag = dataGridView1["Hold_Release", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string embosing_name = dataGridView1["embossed_name", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string branch = dataGridView1["Branch", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string ma_chinh_sach = dataGridView1["machinhsachtd", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string credit_limit = dataGridView1["credit_limit", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string cash_limit = dataGridView1["cash_limit", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string product = dataGridView1["Product", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string Organization = dataGridView1["Organization", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string basic_card = dataGridView1["The_Chinh_The_Phu", dataGridView1.CurrentCell.RowIndex].Value.ToString();

                Frm_SendMail a = new Frm_SendMail();
                a.gb_mail_to = Get_Email_To(branch.Trim().Substring(0, 4));
                a.gb_mail_cc = "[email protected];[email protected]";
                a.gb_subject = "Về việc gửi hồ sơ thẻ tín dụng";
                a.gb_body = Get_Email_Content_Manual(branch, embosing_name, app_no, legal_id, credit_limit, cash_limit, product, Organization, ma_chinh_sach, basic_card);
                a.ShowDialog();

                this.Cursor = Cursors.Default;

            }
            else
                return;
        }
        private void cancelToolStripMenuItem_Click(object sender, EventArgs e)
        {
            string sql = "", err = "";
            if (dataGridView1.Rows.Count == 0)
            {
                MessageBox.Show("Please choose 1 row for editing");
                return;
            }
            if (dataGridView1.Rows.Count > 0)
            {
                this.Cursor = Cursors.WaitCursor;
                string app_no = dataGridView1["application_no", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string legal_id = dataGridView1["legal_id", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                //string client_code = dataGridView1["client_code", dataGridView1.CurrentCell.RowIndex].Value.ToString(); //2014-09-16 (7)
                string hold_flag = dataGridView1["Hold_Release", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string embosing_name = dataGridView1["embossed_name", dataGridView1.CurrentCell.RowIndex].Value.ToString();

                #region 2015-09-22 (8)
                string branch = dataGridView1["Branch", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string ma_chinh_sach = dataGridView1["machinhsachtd", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string credit_limit = dataGridView1["credit_limit", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string cash_limit = dataGridView1["cash_limit", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string product = dataGridView1["Product", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string Organization = dataGridView1["Organization", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string basic_card = dataGridView1["The_Chinh_The_Phu", dataGridView1.CurrentCell.RowIndex].Value.ToString();
                #endregion 2015-09-22 (8)

                if (MessageBox.Show("Bạn có muốn CANCEL khách hàng " + embosing_name + "?", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    #region 2014-09-15 (6)
                    #region Lay gia tri truoc khi update
                    sql = " select rowid, nvl(authorize,'') authorize from " + Businessbp.executedb.owner + "cp_card";
                    sql += " where trim(source_application_no)='" + app_no.Trim() + "'";
                    sql += "      and trim(legal_id)='" + legal_id.Trim() + "'";
                    //sql += "      and trim(client_code)='" + client_code.Trim() + "'"; ////2014-09-16 (7)
                    DataTable dt = Businessbp.executedb.getTable(sql, ref err);
                    string authorize_old = dt.Rows[0]["authorize"].ToString();
                    string row_id = dt.Rows[0]["rowid"].ToString();
                    #endregion
                    #endregion

                    sql = " update " + Businessbp.executedb.owner + "cp_card set";
                    sql += " authorize='R'";
                    sql += " ,user_modify = '" + Businessbp.executedb.Usrid + "'";
                    sql += " ,date_modify = sysdate";
                    sql += " where trim(source_application_no)='" + app_no.Trim() + "'";
                    sql += "      and trim(legal_id)='" + legal_id.Trim() + "'";
                    //sql += "      and trim(client_code)='" + client_code.Trim() + "'"; //2014-09-16 (7)

                    Businessbp.executedb.ExecuteDML(sql, ref err);
                    if (err != "")
                    {
                        MessageBox.Show(err);
                        this.Cursor = Cursors.Default;
                        return;
                    }
                    else
                        MessageBox.Show("CANCEL cấp thẻ khách hàng " + embosing_name + " thành công!!!");

                    #region 2014-09-15 (6)
                    #region Insert vao log
                    string type = "func_insert_staff_process_log";
                    err = "";
                    string name = Businessbp.executedb.owner + "NAB_PROCESS_QUERY." + type;

                    string[] InParaName = new string[20] { "function_type", "table_name", "row_id", "tag_value", "column_1", "old_value_1", "new_value_1",
                                                        "column_2", "old_value_2", "new_value_2", "column_3", "old_value_3", "new_value_3",
                                                        "column_4", "old_value_4", "new_value_4", "column_5", "old_value_5", "new_value_5", "user_create"};
                    OracleType[] InParaType = new OracleType[20] { OracleType.VarChar, OracleType.VarChar, OracleType.VarChar, OracleType.VarChar, OracleType.VarChar,
                                                                   OracleType.VarChar, OracleType.VarChar, OracleType.VarChar, OracleType.VarChar, OracleType.VarChar,
                                                                   OracleType.VarChar, OracleType.VarChar, OracleType.VarChar, OracleType.VarChar, OracleType.VarChar,
                                                                   OracleType.VarChar, OracleType.VarChar, OracleType.VarChar, OracleType.VarChar, OracleType.VarChar,};
                    //Khai bao bien va set gia tri
                    string FUNCTION_TYPE = "", TABLE_NAME = "", ROW_ID = "", TAG_VALUE = "", COLUMN_1 = "", OLD_VALUE_1 = "", NEW_VALUE_1 = "",
                           COLUMN_2 = "", OLD_VALUE_2 = "", NEW_VALUE_2 = "", COLUMN_3 = "", OLD_VALUE_3 = "", NEW_VALUE_3 = "",
                           COLUMN_4 = "", OLD_VALUE_4 = "", NEW_VALUE_4 = "", COLUMN_5 = "", OLD_VALUE_5 = "", NEW_VALUE_5 = "", USER_CREATE = "";
                    //set gia tri
                    FUNCTION_TYPE = "CANCEL CARD";
                    TABLE_NAME = "CP_CARD";
                    ROW_ID = row_id;
                    TAG_VALUE = "<APP_NO>" + app_no + "</APP_NO>";
                    COLUMN_1 = "AUTHORIZE";
                    OLD_VALUE_1 = authorize_old;
                    NEW_VALUE_1 = "R";
                    USER_CREATE = Businessbp.executedb.Usrid;

                    string[] InParaValues = new string[20] { FUNCTION_TYPE, TABLE_NAME, ROW_ID, TAG_VALUE, COLUMN_1, OLD_VALUE_1, NEW_VALUE_1,
                                                             COLUMN_2, OLD_VALUE_2, NEW_VALUE_2, COLUMN_3, OLD_VALUE_3, NEW_VALUE_3,
                                                             COLUMN_4, OLD_VALUE_4, NEW_VALUE_4, COLUMN_5, OLD_VALUE_5, NEW_VALUE_5, USER_CREATE};
                    string[] OutParaName = new string[1] { "Emsg_out" };
                    OracleType[] OutParaType = new OracleType[1] { OracleType.VarChar };
                    int[] OutParaSize = new int[1] { 100 };
                    string[] OutParaValues = new string[1];

                    OracleType reParaType = OracleType.VarChar;
                    int reParaSize = 1;
                    string returnValue = "";
                    err = "";
                    Businessbp.executedb.ExecuteFunc(name, InParaName, InParaType, InParaValues, OutParaName, OutParaType, OutParaSize, reParaType, reParaSize, ref OutParaValues, ref returnValue, ref err);

                    if (err != "")
                    {
                        MessageBox.Show("Err Authorize\n" + err);
                    }
                    else
                    {
                        if (returnValue == "1")
                        {
                            MessageBox.Show("Insert log success!!!");
                        }
                        else
                        {
                            err = OutParaValues[0].ToString();
                            MessageBox.Show("Insert log fail: \n" + err);
                        }
                    }
                    #endregion
                    #endregion

                    LoadData();

                    #region 2015-09-22 (8)
                    Frm_SendMail a = new Frm_SendMail();
                    a.gb_mail_to = Get_Email_To(branch.Trim().Substring(0, 4));
                    //a.gb_mail_cc = "*****@*****.**" ; //OLD 2015-09-29 (9)
                    a.gb_mail_cc = "[email protected];[email protected]";// 2015-09-29 (9)
                    a.gb_subject = "Thông báo hủy thẻ";
                    a.gb_body = Get_Email_Content(branch, embosing_name, app_no, legal_id, credit_limit, cash_limit, product, Organization, ma_chinh_sach,basic_card);
                    a.ShowDialog();
                    #endregion 2015-09-22 (8)

                    this.Cursor = Cursors.Default;
                }
                else// Nếu chọn NO thì khong hold
                {
                    this.Cursor = Cursors.Default;
                    return;
                }

            }
            else
                return;
        }