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