//==================klik data di tabel agar masuk ke transaksi line==============================================
private void dgv_hold_MouseDoubleClick(object sender, MouseEventArgs e)
{
id_inv = dgv_hold.SelectedRows[0].Cells[2].Value.ToString();
//ambil article id, masukan ke variable
art_id = dgv_hold.SelectedRows[0].Cells[0].Value.ToString();
//MessageBox.Show(art_id + "");
//======mencari data article sesuai article code==
search_data_article();
//===========masukan ke transaksi line
insert();
//===========potong inventory article===
//MEMOTONG ARTICLE
Inv_Line inv = new Inv_Line();
int qty_min_plus = -1;
String type_trans = "1";
inv.cek_qty_inv(id_inv);
inv.cek_type_trans(type_trans);
inv.cek_inv_line(id_trans, qty_min_plus);
//==panggil method di uc_coba(halaman transaksi)
DiscountAfterUsePromNew afteruser = new DiscountAfterUsePromNew();
afteruser.retreive(trans_id, kodetoko3, custid3);
//uc_coba.Instance.retreive();
//uc_coba.Instance.itung_total();
//====tutup dialog===
this.Close();
}
private void dgv_2_MouseDoubleClick(object sender, MouseEventArgs e)
{
CRUD sql = new CRUD();
try
{
S_ID = dgv_2.SelectedRows[0].Cells[0].Value.ToString();
S_price = dgv_2.SelectedRows[0].Cells[4].Value.ToString();
id_inv = dgv_2.SelectedRows[0].Cells[5].Value.ToString();
AddTransLine add = new AddTransLine();
add.get_data(code_store, customer, S_ID, id_spg);
add.get_data_trans_line(Convert.ToInt32(S_price), t_id);
//add.Post_Discount();
discCalcSP(t_id, S_ID, purchQty, id_spg, "");
//add.cek_article2();
//MEMOTONG ARTICLE
Inv_Line inv = new Inv_Line();
int qty_min_plus = -1;
String type_trans = "1";
inv.cek_qty_inv(id_inv);
inv.cek_type_trans(type_trans);
inv.cek_inv_line(t_id, qty_min_plus);
back_uc();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
//=================SELECT VALUE BY PRESS ENTER=======================
private void dgv_2_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Return)
{
try
{
//S_ID = dgv_2.SelectedRows[0].Cells[0].Value.ToString();
//S_price = dgv_2.SelectedRows[0].Cells[4].Value.ToString();
//id_inv = dgv_2.SelectedRows[0].Cells[5].Value.ToString();
////============================================================
//Post_Discount();
////============================================================
//cek_article2();
////MEMOTONG ARTICLE
//Inv_Line inv = new Inv_Line();
//int qty_min_plus = -1;
//String type_trans = "1";
//inv.cek_qty_inv(id_inv);
//inv.cek_type_trans(type_trans);
//inv.cek_inv_line(t_id, qty_min_plus);
//back_uc();
S_ID = dgv_2.SelectedRows[0].Cells[0].Value.ToString();
S_price = dgv_2.SelectedRows[0].Cells[4].Value.ToString();
id_inv = dgv_2.SelectedRows[0].Cells[5].Value.ToString();
AddTransLine add = new AddTransLine();
add.get_data(code_store, customer, S_ID, id_spg);
add.get_data_trans_line(Convert.ToInt32(S_price), t_id);
//add.Post_Discount();
discCalcSP(t_id, S_ID, purchQty, id_spg, "");
//add.cek_article2();
//MEMOTONG ARTICLE
Inv_Line inv = new Inv_Line();
int qty_min_plus = -1;
String type_trans = "1";
inv.cek_qty_inv(id_inv);
inv.cek_type_trans(type_trans);
inv.cek_inv_line(t_id, qty_min_plus);
back_uc();
}
catch
{
MessageBox.Show("Select a value in the table");
}
//MessageBox.Show("Enter pressed");
}
}
public void cek_article(string _articleId, int _qty)
{
CRUD sql = new CRUD();
koneksi ckonCheck = new koneksi();
String cmd_article;
String cmd_invent;
Boolean hasRows = false;
try
{
ckon.sqlCon().Open();
ckonCheck.sqlCon().Open();
cmd_article = "SELECT * FROM article WHERE article.ARTICLE_ID_ALIAS = '" + _articleId + "'";
ckonCheck.sqlDataRd = sql.ExecuteDataReader(cmd_article, ckonCheck.sqlCon());
if (ckonCheck.sqlDataRd.HasRows)
{
while (ckonCheck.sqlDataRd.Read())
{
artIdLoc = ckonCheck.sqlDataRd["ARTICLE_ID"].ToString();
hasRows = true;
}
}
if (hasRows)
{
if (ckon.sqlDataRd != null)
{
ckon.sqlDataRd.Close();
}
cmd_article = "SELECT * FROM article WHERE ARTICLE_ID = '" + artIdLoc + "'";
ckon.sqlDataRdHeader = sql.ExecuteDataReader(cmd_article, ckon.sqlCon());
if (ckon.sqlDataRdHeader.HasRows)
{
while (ckon.sqlDataRdHeader.Read())
{
id_inv = ckon.sqlDataRdHeader["_id"].ToString();
}
cmd_invent = "SELECT * FROM inventory WHERE ARTICLE_ID = " + id_inv + " AND GOOD_QTY >= 1";
ckon.sqlDataRd = sql.ExecuteDataReader(cmd_invent, ckon.sqlCon());
if (ckon.sqlDataRd.HasRows)
{
//MEMOTONG ARTICLE
Inv_Line inv = new Inv_Line();
int qty_min_plus = _qty;
String type_trans = "10";
inv.cek_qty_inv(id_inv);
inv.cek_type_trans(type_trans);
inv.cek_inv_line(t_delivCustId.Text, qty_min_plus);
}
}
else
{
MessageBox.Show("Article Not Found");
}
}
else
{
if (ckon.sqlDataRd != null)
{
ckon.sqlDataRd.Close();
}
cmd_article = "SELECT * FROM article WHERE ARTICLE_ID = '" + artIdLoc + "'";
ckon.sqlDataRdHeader = sql.ExecuteDataReader(cmd_article, ckon.sqlCon());
if (ckon.sqlDataRdHeader.HasRows)
{
while (ckon.sqlDataRdHeader.Read())
{
id_inv = ckon.sqlDataRdHeader["_id"].ToString();
}
cmd_invent = "SELECT * FROM inventory WHERE ARTICLE_ID = " + id_inv + " AND GOOD_QTY >= 1";
ckon.sqlDataRd = sql.ExecuteDataReader(cmd_invent, ckon.sqlCon());
if (ckon.sqlDataRd.HasRows)
{
//MEMOTONG ARTICLE
Inv_Line inv = new Inv_Line();
int qty_min_plus = _qty;
String type_trans = "10";
inv.cek_qty_inv(id_inv);
inv.cek_type_trans(type_trans);
inv.cek_inv_line(t_delivCustId.Text, qty_min_plus);
}
}
else
{
MessageBox.Show("Article Not Found");
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (ckon.sqlDataRd != null)
{
ckon.sqlDataRd.Close();
}
if (ckon.sqlCon().State == ConnectionState.Open)
{
ckon.sqlCon().Close();
}
}
}