//==================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");
}
}
//=====BUTTON OK
private void b_ok_Click(object sender, EventArgs e)
{
API_ReturnOrder returnOrder = new API_ReturnOrder();
bool api_response;
try
{
if (count_eror != 0)
{
MessageBox.Show("There Is A Total Quantity That Exceeds Inventory. Please Check Again !");
}
else
{
String cmd_update = "UPDATE returnorder SET REMARK= '" + t_remark.Text + "' ,TOTAL_QTY='" + qty2 + "', STATUS='1', EMPLOYEE_ID='" + epy_id2 + "', EMPLOYEE_NAME='" + epy_name2 + "', TOTAL_AMOUNT='" + total_amount + "', NO_SJ='" + no_sj2 + "' WHERE RETURN_ORDER_ID = '" + return_id2 + "'";
CRUD update = new CRUD();
update.ExecuteNonQuery(cmd_update);
api_response = returnOrder.returnOrder().Result;
if (api_response)
{
//===POTONG INVENTORY
Inv_Line inv = new Inv_Line();
String type_trans = "5";
inv.cek_type_trans(type_trans);
inv.cek_type_trans(type_trans);
inv.return_order(return_id2);
MessageBox.Show("Confirmed");
UC_Ret_order.Instance.reset();
UC_Ret_order.Instance.new_invoice();
UC_Ret_order.Instance.holding();
UC_Ret_order.Instance.runRetreive();
this.Close();
}
else
{
MessageBox.Show("Make Sure You are Connected To Internet");
}
}
}
catch
{
MessageBox.Show("data failured added");
this.Close();
}
}
//FUNGSI SIMPAN DO HEADER====
public void simpan_do_header2()
{
API_DeliveryOrderConfirm do_confirm = new API_DeliveryOrderConfirm();
try
{
Inv_Line inv = new Inv_Line();
String type_trans = "2";
inv.cek_type_trans(type_trans);
inv.get_do_line(id2);
do_confirm.deliveryOrderConfirm(id2, id_epy2, name_epy2, cust_id_store).Wait();
UC_DO.Instance.reset();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
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();
}
}
}
private void b_ok_Click(object sender, EventArgs e)
{
CRUD sql = new CRUD();
//wahyu 13-11-19
//set_running_number();
//ckon.con.Close();
try
{
ckon.sqlCon().Open();
String cmd = "SELECT top 1 a.TRANSACTION_ID FROM [transaction] a LEFT JOIN transaction_line b ON a.TRANSACTION_ID = b.TRANSACTION_ID WHERE b.transaction_ID is null AND STATUS IN ('0','3') and COMP_NAME='" + comp_nam + "' ORDER BY a._id asc";
ckon.sqlDataRd = sql.ExecuteDataReader(cmd, ckon.sqlCon());
if (ckon.sqlDataRd.HasRows)
{
while (ckon.sqlDataRd.Read())
{
head_stts = 1;
new_idTrans = ckon.sqlDataRd["TRANSACTION_ID"].ToString();
}
}
DateTime mydate = DateTime.Now;
Inv_Line inv = new Inv_Line();
String type_trans = "4";
inv.cek_type_trans(type_trans);
inv.void_trans(id_trans);
//====================================
String a = mydate.ToString("yyyy-MM-dd");
save_trans_header();
save_trans_line();
save_trans_header_new();
//
this.Close();
f1.label3.Text = "TRANSACTION";
f1.p_kanan.Controls.Clear();
if (!f1.p_kanan.Controls.Contains(uc_coba.Instance))
{
f1.p_kanan.Controls.Add(uc_coba.Instance);
f1.setProp();
uc_coba.Instance.Dock = DockStyle.Fill;
uc_coba.Instance.holding(a);
uc_coba.Instance.id_employe2 = employee_id;
uc_coba.Instance.voidClick(new_idTrans2);
uc_coba.Instance.BringToFront();
}
else
{
f1.p_kanan.Controls.Add(uc_coba.Instance);
f1.setProp();
uc_coba.Instance.Dock = DockStyle.Fill;
uc_coba.Instance.holding(a);
uc_coba.Instance.id_employe2 = employee_id;
uc_coba.Instance.voidClick(new_idTrans2);
uc_coba.Instance.BringToFront();
}
}
catch (Exception er)
{
MessageBox.Show("No connection to database", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (ckon.sqlDataRd != null)
{
ckon.sqlDataRd.Close();
}
if (ckon.sqlCon().State == ConnectionState.Open)
{
ckon.sqlCon().Close();
}
}
//String sqlStatus = "UPDATE transaction SET STATUS='3' WHERE STATUS='0' AND COMP_NAME='" + comp_nam + "'";
//CRUD ubah = new CRUD();
//ubah.ExecuteNonQuery(sqlStatus);
//ckon.cmd = new MySqlCommand(sql, ckon.con);
//ckon.con.Open();
//ckon.myReader = ckon.cmd.ExecuteReader();
//if (ckon.myReader.HasRows)
//{
// while (ckon.myReader.Read())
// {
// head_stts = 1;
// new_idTrans = ckon.myReader.GetString("TRANSACTION_ID");
// }
//} else
//{
// new_idTrans = final_running_number;
//}
//ckon.con.Close();
//end
}
//====================================================================================
//============================BUTTON CONFIRM======================================
private void b_confirm_Click(object sender, EventArgs e)
{
API_MutasiOrder mutasiOrder = new API_MutasiOrder();
bool api_response;
try
{
this.ActiveControl = t_barcode;
t_barcode.Focus();
if (l_qty.Text == "0" || combo_InOut.Text == "" || combo_coverage.Text == "" || combo_mutasiTo.Text == "")
{
MessageBox.Show("No Item On List And Please Select All Info");
}
else
{
get_data_combo_store();
if (combo_InOut.Text == "IN")
{
String cmd_update = "UPDATE mutasiorder SET MUTASI_FROM_WAREHOUSE='" + combo_store2 + "' ,MUTASI_TO_WAREHOUSE = '" + store_code + "',REQUEST_DELIVERY_DATE = '" + tanggal_req.Text + "' ,TOTAL_QTY='" + l_qty.Text + "', STATUS='1', CUST_ID_STORE='" + cust_id_store + "', EMPLOYEE_ID='" + epy_id + "', EMPLOYEE_NAME='" + epy_name + "',TOTAL_AMOUNT='" + total_amount + "', NO_SJ = '" + no_sj.Text + "' WHERE MUTASI_ORDER_ID = '" + l_transaksi.Text + "'";
CRUD update = new CRUD();
update.ExecuteNonQuery(cmd_update);
api_response = mutasiOrder.mutasiOrder().Result;
if (api_response)
{
MessageBox.Show("data successfully added");
reset();
holding();
new_invoice();
set_running_number();
save_trans_header();
}
else
{
MessageBox.Show("Make Sure You are Connected To Internet");
}
}
else
{
if (count_eror != 0)
{
MessageBox.Show("There Is A Total Quantity That Exceeds Inventory. Please Check Again !");
}
else
{
String cmd_update = "UPDATE mutasiorder SET MUTASI_FROM_WAREHOUSE='" + store_code + "' ,MUTASI_TO_WAREHOUSE = '" + combo_store2 + "',REQUEST_DELIVERY_DATE = '" + tanggal_req.Text + "' ,TOTAL_QTY='" + l_qty.Text + "', STATUS='1', CUST_ID_STORE='" + cust_id_store + "', EMPLOYEE_ID='" + epy_id + "', EMPLOYEE_NAME='" + epy_name + "',TOTAL_AMOUNT='" + total_amount + "', NO_SJ = '" + no_sj.Text + "' WHERE MUTASI_ORDER_ID = '" + l_transaksi.Text + "'";
CRUD update = new CRUD();
update.ExecuteNonQuery(cmd_update);
api_response = mutasiOrder.mutasiOrder().Result;
if (api_response)
{
//===POTONG INVENTORY SAAT MUTASI OUT
Inv_Line inv = new Inv_Line();
String type_trans = "3";
inv.cek_type_trans(type_trans);
inv.mutasi_out(l_transaksi.Text);
MessageBox.Show("data successfully added");
reset();
holding();
new_invoice();
set_running_number();
save_trans_header();
}
else
{
MessageBox.Show("Make Sure You are Connected To Internet");
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}