public void updateInventArticle() { CRUD sql = new CRUD(); int inventArtId; try { ckon.sqlCon().Open(); String cmd = "SELECT ARTICLE_ID FROM inventory GROUP BY ARTICLE_ID HAVING COUNT(*) > 1"; ckon.sqlDataRd = sql.ExecuteDataReader(cmd, ckon.sqlCon()); if (ckon.sqlDataRd.HasRows) { while (ckon.sqlDataRd.Read()) { inventArtId = Convert.ToInt32(ckon.sqlDataRd["ARTICLE_ID"].ToString()); string cmd_update = "UPDATE inventory SET GOOD_QTY = (SELECT SUM(GOOD_QTY) FROM inventory WHERE ARTICLE_ID = '" + inventArtId + "') WHERE ARTICLE_ID = '" + inventArtId + "'"; sql.ExecuteNonQuery(cmd_update); string cmd_delete = "WITH Temp " + "AS(SELECT Article_ID, ROW_NUMBER() OVER(PARTITION by Article_ID ORDER BY Article_ID) AS duplicateRecCount FROM inventory where ARTICLE_ID = '" + inventArtId + "') " + "DELETE FROM Temp WHERE duplicateRecCount > 1"; sql.ExecuteNonQuery(cmd_delete); } } } catch (Exception e) { MessageBox.Show(e.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void b_cancelShipping_Click(object sender, EventArgs e) { CRUD sql = new CRUD(); String cmd_deleteLine = "DELETE FROM deliverycustomer_line WHERE DELIVERY_CUST_ID = (SELECT DELIVERY_CUT_ID FROM deliverycustomer WHERE TRANSACTION_ID = '" + l_transaksi2.Text + "')"; sql.ExecuteNonQuery(cmd_deleteLine); String cmd_deleteHeader = "DELETE FROM deliverycustomer WHERE TRANSACTION_ID = '" + l_transaksi2.Text + "'"; sql.ExecuteNonQuery(cmd_deleteHeader); }
//============================================================================ //========================METHOD SAVE INTO TABLE CLOSING_SHIFT WHEN OPENED SHIFT==================== public void save_closing_shift() { CRUD sql = new CRUD(); //ckon.con.Close(); try { ckon.sqlCon().Open(); String cmd = "SELECT TOP 1* FROM closing_shift ORDER BY _id DESC"; ckon.sqlDataRd = sql.ExecuteDataReader(cmd, ckon.sqlCon()); if (ckon.sqlDataRd.HasRows) { while (ckon.sqlDataRd.Read()) { open_trans = Convert.ToInt32(ckon.sqlDataRd["REAL_TRANS_BALANCE"].ToString()); open_petty = Convert.ToInt32(ckon.sqlDataRd["REAL_PETTY_CASH"].ToString()); open_deposit = Convert.ToInt32(ckon.sqlDataRd["REAL_DEPOSIT"].ToString()); } } else { open_trans = 0; open_petty = 0; open_deposit = 0; } string name = System.Environment.MachineName; DateTime mydate = DateTime.Now; String time_now = mydate.ToString("yyyy-MM-dd H:mm:ss"); String cmd_insert = "INSERT INTO closing_shift (ID_SHIFT,STORE_ID,SHIFT,OPENING_TIME,OPENING_TRANS_BALANCE, OPENING_PETTY_CASH,OPENING_DEPOSIT,DEVICE_NAME,EMPLOYEE_ID,EMPLOYEE_NAME) VALUES ('" + string_id_shift + "','" + store_id + "', '" + shift_name + "', '" + time_now + "','" + open_trans + "','" + open_petty + "', '" + open_deposit + "','" + name + "','" + id_epy + "','" + nm_epy + "')"; sql.ExecuteNonQuery(cmd_insert); String cmd_update = "UPDATE auto_number SET Month = '" + bulan_shift + "', Number = '" + no_trans_shift + "' WHERE Type_Trans='" + tipe_closing_shift + "'"; sql.ExecuteNonQuery(cmd_update); } 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(); } } }
//DELETE TRANSAKSI sesuai id shift yang dikirim public void del_trans() { string command; try { command = "DELETE transaction_line FROM transaction_line INNER JOIN [transaction] " + "ON [transaction].TRANSACTION_ID = transaction_line.TRANSACTION_ID " + "WHERE [transaction].ID_SHIFT = '" + id + "' AND [transaction].STATUS = '0'"; CRUD del_TransLine = new CRUD(); del_TransLine.ExecuteNonQuery(command); command = "DELETE FROM [transaction] WHERE [transaction].ID_SHIFT = '" + id + "' AND [transaction].STATUS = '0'"; CRUD del_Transaction = new CRUD(); del_Transaction.ExecuteNonQuery(command); command = "DELETE inventory_line FROM inventory_line INNER JOIN [transaction] " + "ON [transaction].TRANSACTION_ID = inventory_line.TRANS_REF_ID " + "WHERE [transaction].ID_SHIFT = '" + id + "' AND [transaction].STATUS = '0'"; CRUD del_InvLine = new CRUD(); del_InvLine.ExecuteNonQuery(command); } catch (Exception e) { MessageBox.Show(e.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//================DATAGRIDVIEW TO DATABASE ========================================= public void cek_article2() { new_price = int.Parse(S_price); string j = "1"; //i = 0; try { ckon.sqlCon().Open(); string command = "SELECT * FROM transaction_line WHERE TRANSACTION_ID ='" + t_id + "' AND ARTICLE_ID='" + S_ID + "'"; CRUD sql = new CRUD(); ckon.sqlDataRd = sql.ExecuteDataReader(command, ckon.sqlCon()); if (ckon.sqlDataRd.HasRows) { while (ckon.sqlDataRd.Read()) { new_jumlah = Convert.ToInt32(ckon.sqlDataRd["QUANTITY"].ToString()); new_harga = Convert.ToInt32(ckon.sqlDataRd["SUBTOTAL"].ToString()); new_disc = Convert.ToInt32(ckon.sqlDataRd["DISCOUNT"].ToString()); } new_price = new_price - disc; new_jumlah = new_jumlah + 1; new_harga = new_harga + new_price; new_disc = new_disc + disc; String sql_transLine = "UPDATE transaction_line SET QUANTITY='" + new_jumlah + "',DISCOUNT='" + new_disc + "' ,SUBTOTAL='" + new_harga + "' WHERE TRANSACTION_ID='" + t_id + "' AND ARTICLE_ID='" + S_ID + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(sql_transLine); } else { int convert_harga;//convert harga menjadi integer//Jika diskon tidak ada, maka subtotal dikurangi diskon convert_harga = Int32.Parse(S_price); new_harga = convert_harga - disc; String sql_transLine = "INSERT INTO transaction_line (TRANSACTION_ID,ARTICLE_ID,QUANTITY,PRICE,DISCOUNT,SUBTOTAL, SPG_ID, DISCOUNT_CODE,DISCOUNT_TYPE,DISCOUNT_DESC) VALUES ('" + t_id + "','" + S_ID + "', '" + j + "', '" + S_price + "', '" + disc + "' ,'" + new_harga + "', '" + id_spg + "','" + disc_code + "','" + disc_type + "','" + disc_desc + "')"; CRUD input = new CRUD(); input.ExecuteNonQuery(sql_transLine); } } 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) { int addQty = 0; string storeCode = ""; foreach (DataGridViewRow row in dgv_SearchStock.Rows) { if (Convert.ToBoolean(row.Cells["CbSelected"].Value) == true) { addQty = Convert.ToInt32(row.Cells["Qty"].Value); if (storeCode != Convert.ToString(row.Cells["Store"].Value).Substring(0, 3)) { storeCode = Convert.ToString(row.Cells["Store"].Value).Substring(0, 3); discCalcSP(transactionId, articleId, addQty, spgId, "", storeCode); } } } if (addQty == 0) { MessageBox.Show("Quantity has not been marked, please mark it first", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { CRUD sql = new CRUD(); String cmd_delete = "DELETE FROM [tmp].[" + store + "] WHERE TRANSACTION_ID='" + transactionId + "' AND ARTICLE_ID='" + articleId + "' AND OMNISTORECODE = ''"; sql.ExecuteNonQuery(cmd_delete); this.Close(); uc_coba.Instance.retreive(); uc_coba.Instance.itung_total(); } }
//========================UPDATE REQ ORDER HEADER =============================================== public void update_header() { String cmd_update = "UPDATE mutasiorder SET MUTASI_TO_WAREHOUSE = '" + combo_mutasiTo.Text + "',REQUEST_DELIVERY_DATE = '" + tanggal_req.Text + "' ,TOTAL_QTY='" + l_qty.Text + "', CUST_ID_STORE='" + cust_id_store + "', EMPLOYEE_ID='" + epy_id + "', EMPLOYEE_NAME='" + epy_name + "' WHERE MUTASI_ORDER_ID = '" + l_transaksi.Text + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); }
//======MASUKAN DATA KE TRANSAKSI LINE========= public void insert() { String cmd_insert = "INSERT INTO transaction_line (TRANSACTION_ID,ARTICLE_ID,QUANTITY,PRICE,DISCOUNT,SUBTOTAL,SPG_ID,DISCOUNT_CODE,DISCOUNT_TYPE,DISCOUNT_DESC) VALUES ('" + id_trans + "','" + art_id + "','1','" + price + "','" + price + "','0','" + spg_id + "','" + disc_code + "','" + disc_type + "','" + disc_code + "')"; CRUD insert = new CRUD(); insert.ExecuteNonQuery(cmd_insert); }
//===================method for update into table closing shift===================== public void update() { double closingTrans, realTrans, disputeTrans; if (shift == "1") { get_opening_close(); } if (shift == "2") { get_opening(); } closingTrans = cash2 + edc; realTrans = valueCash + valueEDC; disputeTrans = cash_label + edc_label; DateTime mydate = DateTime.Now; String time_now = mydate.ToString("yyyy-MM-dd H:mm:ss"); String cmd_update = "UPDATE closing_shift SET CLOSING_TIME='" + time_now + "', CLOSING_TRANS_BALANCE='" + closingTrans + "', REAL_TRANS_BALANCE='" + realTrans + "', DISPUTE_TRANS_BALANCE='" + disputeTrans + "', CLOSING_PETTY_CASH='" + bg_ToCasir + "',REAL_PETTY_CASH='" + value_budget + "', DISPUTE_PETTY_CASH='" + petty_label + "',CLOSING_DEPOSIT='0',REAL_DEPOSIT='" + value_modal + "',DISPUTE_DEPOSIT='" + deposit_label + "',TOTAL_QTY='" + qty_article + "' ,STATUS_CLOSE='1', EMPLOYEE_ID='" + epy_id2 + "', EMPLOYEE_NAME='" + name_id2 + "' WHERE ID_SHIFT='" + id_shift2 + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); }
//==============fungsi hitung dan update transaction===================================== public void hitung() { int transType; if (cust_Id != "") { transType = 3; } else { transType = 1; } String cmd_update = "UPDATE [transaction] SET DISCOUNT='" + field_diskon2 + "',TOTAL='" + tot_bel + "', STATUS='1', PAYMENT_TYPE='3', EDC='" + edc1 + "', EDC2='" + edc2 + "' ,BANK_NAME='" + id_bank + "',BANK_NAME2='" + id_bank2 + "' ,NO_REF='" + t_rev.Text + "',NO_REF2='" + t_rev2.Text + "', TRANSACTION_TYPE = '" + transType + "' WHERE TRANSACTION_ID ='" + id_trans + "'"; CRUD edit = new CRUD(); edit.ExecuteNonQuery(cmd_update); uc_kembalian uc_k = new uc_kembalian(f1); f1.p_kanan.Controls.Clear(); //bunifuFlatButton1.selected = true; if (!f1.p_kanan.Controls.Contains(uc_kembalian.Instance)) { f1.p_kanan.Controls.Add(uc_kembalian.Instance); uc_kembalian.Instance.Dock = DockStyle.Fill; uc_kembalian.Instance.split_edc(id_trans, edc1, edc2, combo_bank1.Text, combo_bank2.Text); uc_kembalian.Instance.Show(); //uc_transaction.Instance.BringToFront(); } else { uc_kembalian.Instance.split_edc(id_trans, edc1, edc2, combo_bank1.Text, combo_bank2.Text); uc_kembalian.Instance.Show(); } }
//============FUNGSI CEK TABEL ARTICLE BERDASARKAN ARTICLE ID YANG TELAH DI SCAN== public void cek_article() { CRUD sql = new CRUD(); int total_amount_new; //ckon.con.Close(); //String sql = "SELECT * FROM article WHERE ARTICLE_ID = '" + t_barcode.Text + "'"; try { ckon.sqlCon().Open(); String cmd = "Select article._id, article.ARTICLE_ID, article.UNIT, article.PRICE, inventory.GOOD_QTY FROM article INNER JOIN inventory ON article._id = inventory.ARTICLE_ID WHERE inventory.GOOD_QTY >=1 AND article.ARTICLE_ID = '" + t_barcode.Text + "'"; ckon.sqlDataRd = sql.ExecuteDataReader(cmd, ckon.sqlCon()); if (ckon.sqlDataRd.HasRows) { while (ckon.sqlDataRd.Read()) { id_inv = ckon.sqlDataRd["_id"].ToString(); art_id = ckon.sqlDataRd["ARTICLE_ID"].ToString(); unit = ckon.sqlDataRd["UNIT"].ToString(); price = Convert.ToInt32(ckon.sqlDataRd["PRICE"].ToString()); good_qty = ckon.sqlDataRd["GOOD_QTY"].ToString(); } total_amount_new = price * Convert.ToInt32(good_qty); String cmd_roLine = "SELECT * FROM returnorder_line WHERE RETURN_ORDER_ID = '" + l_transaksi.Text + "' AND ARTICLE_ID = '" + art_id + "'"; ckon.sqlDataRd = sql.ExecuteDataReader(cmd_roLine, ckon.sqlCon()); if (ckon.sqlDataRd.HasRows) { MessageBox.Show("This Article Has Been Entered"); } else { String cmd_insert = "INSERT INTO returnorder_line (RETURN_ORDER_ID,ARTICLE_ID,QUANTITY,UNIT, SUBTOTAL) VALUES ('" + l_transaksi.Text + "','" + art_id + "', '" + good_qty + "', '" + unit + "','" + total_amount_new + "')"; sql.ExecuteNonQuery(cmd_insert); } } else { MessageBox.Show("Article Not Found Or Quantity Empty"); } } 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) { int dev = int.Parse(l_w_dev.Text); int rec = int.Parse(l_w_rec.Text); int total = rec - dev; try { String cmd_update = "UPDATE deliveryorder_line set QTY_RECEIVE ='" + l_w_rec.Text + "', QTY_DISPUTE = '" + total + "' WHERE _id='" + id_do_line + "' AND DELIVERY_ORDER_ID = '" + id_do_header + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); //ckon.con.Open(); //ckon.cmd = new MySqlCommand(sql, ckon.con); //kon.cmd.ExecuteNonQuery(); //ckon.con.Close(); UC_DO.Instance.retreive2(id_do_header); UC_DO.Instance.get_data(id_do_header); this.Close(); } catch { MessageBox.Show("updating failed data"); } }
//==================BUTTON BACK BARU WITH UNDERLINE============================ private void b_back2_Click(object sender, EventArgs e) { CRUD sql = new CRUD(); f1.p_kanan.Controls.Clear(); //bunifuFlatButton1.selected = true; if (!f1.p_kanan.Controls.Contains(uc_coba.Instance)) { f1.p_kanan.Controls.Add(uc_coba.Instance); uc_coba.Instance.Dock = DockStyle.Fill; //charge.Instance.id_trans(l_transaksi.Text, l_total.Text); //uc_coba.Instance.Show(); uc_coba.Instance.barcode_fokus(); uc_coba.Instance.BringToFront(); } else { //charge.Instance.Show(); uc_coba.Instance.barcode_fokus(); uc_coba.Instance.BringToFront(); } String del_trans_line = "DELETE FROM transaction_line WHERE TRANSACTION_ID = '" + l_transaksi2.Text + "'"; sql.ExecuteNonQuery(del_trans_line); }
//======================================DELETE DATA BEFORE GET FROM API================================== public void delete() { String cmd_delete = "DELETE FROM article"; CRUD delete = new CRUD(); delete.ExecuteNonQuery(cmd_delete); }
private void b_ok_Click(object sender, EventArgs e) { CRUD sql = new CRUD(); int addQty = 1; string storeCode = ""; discCalcSP(transactionId, "B001", addQty, spgId, "", storeCode); if (shippingByTrans) { } else { //if (!holdTrans) //{ string cmd_update = "UPDATE [tmp].[" + store + "] SET DELIVERYCUSTADDRESS = '" + t_DeliveryAddress.Text + "', OMNISHIPPINGCOST = '', OMNICOURIER = '" + cbDelivType.Text + "' " + "WHERE TRANSACTION_ID = '" + transactionId + "' AND ARTICLE_ID = '" + t_ArtId.Text + "' AND OMNISTORECODE = '" + t_FromStore.Text + "'"; sql.ExecuteNonQuery(cmd_update); //} //else //{ // string cmd_update = "UPDATE transaction_line SET DELIVERYCUSTADDRESS = '" + t_DeliveryAddress.Text + "', OMNISHIPPINGCOST = '', OMNICOURIER = '' " + // "WHERE TRANSACTION_ID = '" + transactionId + "' AND ARTICLE_ID = '" + t_ArtId.Text + "' AND OMNISTORECODE = '" + t_FromStore.Text + "'"; // sql.ExecuteNonQuery(cmd_update); //} } this.Close(); uc_coba.Instance.retreive(); uc_coba.Instance.itung_total(); }
//=============================COBA METHOD DENGAN TAMPILAN BARU WINDOWS FORM, JIKA DI OK public void method_confim_ok() { if (totall > bg_ToStore) { MessageBox.Show("Budget Exceeded"); } else { int total_budget = bg_ToStore - totall; //String sql = "UPDATE pettycash SET EXPENSE_CATEGORY='" + combo_expense.Text + "', EXPENSE_DATE='" + d_tgl_expense.Text + "', DESCRIPTION = '" + t_desc.Text + "', TOTAL_EXPENSE = '" + totall + "', STATUS = 1 WHERE PETTY_CASH_ID='" + l_transaksi.Text + "'"; //=============UPDATE PETTY CASH HEADER======================== String cmd_updatePtc = "UPDATE pettycash SET EXPENSE_DATE='" + d_tgl_expense.Text + "', TOTAL_EXPENSE = '" + totall + "', STATUS = 1 WHERE PETTY_CASH_ID='" + l_transaksi.Text + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_updatePtc); //===========UPDATE BUDGET TO STORE IN STORE TABLE==================== String cmd_updateStore = "UPDATE store SET BUDGET_TO_STORE = '" + total_budget + "'"; CRUD update2 = new CRUD(); update2.ExecuteNonQuery(cmd_updateStore); //============== //RunningNumber running = new RunningNumber(); //running.get_data_before("6", "PC"); new_invoice(); set_running_number(); combo_expense.SelectedIndex = -1; l_total.Text = "0"; dgv_petty.Rows.Clear(); holding(); get_budget(); get_expense(); } }
//================================================================================ public async Task Post_ChangePass() { link_api = link.aLink; ChangePass change = new ChangePass() { username = t_user.Text, currentpassword = t_passLama.Text, newpassword = replace_pass }; var stringPayload = JsonConvert.SerializeObject(change); String response = ""; var credentials = new NetworkCredential("username", "password"); var handler = new HttpClientHandler { Credentials = credentials }; var httpContent = new StringContent(stringPayload, Encoding.UTF8, "application/json"); using (var client = new HttpClient(handler)) { try { HttpResponseMessage message = client.PostAsync(link_api + "/api/ChangePasswordAPI", httpContent).Result; String cmd_update = "UPDATE Employee Set Pass = '******' where EMPLOYEE_ID='" + t_user.Text + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); MessageBox.Show("Password Successfully Changed, Please Login Again", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch { MessageBox.Show("Please Make Sure You're Connected To Internet", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
//======================INPUT TRANSAKSI HEADER====================================== public void save_trans_header() { //ckon.con.Close(); DateTime mydate = DateTime.Now; if (head_stts == 1) { //update by delete String cmd_delete = "DELETE FROM [transaction] WHERE TRANSACTION_ID='" + new_idTrans + "'"; CRUD delete = new CRUD(); delete.ExecuteNonQuery(cmd_delete); } String cmd_insert = "INSERT INTO [transaction] (TRANSACTION_ID,STORE_CODE,CUSTOMER_ID,EMPLOYEE_ID,RECEIPT_ID,SPG_ID,DISCOUNT,TOTAL,STATUS,PAYMENT_TYPE,CASH,EDC,EDC2,CHANGEE,VOUCHER,BANK_NAME,BANK_NAME2,NO_REF,NO_REF2, DATE, TIME,CUST_ID_STORE,CURRENCY,ID_SHIFT,ID_C_STORE,VOUCHER_ID,VOUCHER_CODE,REFERENCE_DOC,COMP_NAME,TRANSACTION_TYPE) VALUES ('" + new_idTrans + "', '" + store_code2 + "','" + cust_id + "','" + employee_id + "','" + receipt_id + "','" + spg_id + "','-" + discount + "', '-" + total + "', '2', '" + payment + "', '-" + cash + "', '-" + edc + "','-" + edc2 + "', '-" + changee + "', '-" + voucher + "','" + bank_name + "', '" + bank_name2 + "','" + no_ref + "','" + no_ref2 + "', '" + mydate.ToString("yyyy-MM-dd") + "', '" + mydate.ToLocalTime().ToString("H:mm:ss") + "','" + cust_id_Store + "','" + curr + "','" + id_shift2 + "','" + id_c_store + "','" + vou_id + "', '" + vou_code + "', '" + id_trans + "', '" + comp_nam + "', '1') "; CRUD insert = new CRUD(); insert.ExecuteNonQuery(cmd_insert); String cmd_update = "UPDATE [transaction] SET STATUS=2 WHERE TRANSACTION_ID='" + id_trans + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); //String query = "UPDATE auto_number SET Month = '" + bulan_now + "', Number = '" + number_trans + "' WHERE Type_Trans='1'"; //CRUD ubah = new CRUD(); //ubah.ExecuteNonQuery(query); }
//======================================DELETE DATA BEFORE GET FROM API================================== public void delete() { ckon.con.Close(); String sql = "DELETE FROM inventory"; CRUD delete = new CRUD(); delete.ExecuteNonQuery(sql); }
public void delete() { String cmd_delete = "DELETE FROM stock_take"; CRUD delete = new CRUD(); delete.ExecuteNonQuery(cmd_delete); dgv_inv.Rows.Clear(); }
//======================================DELETE DATA BEFORE GET FROM API================================== public void delete() { ckon.con.Close(); String sql = "DELETE FROM ho_transaction_type"; CRUD exec = new CRUD(); exec.ExecuteNonQuery(sql); }
//============================================================================================== //========================UPDATE REQ ORDER HEADER =============================================== public void update_header() { CRUD sql = new CRUD(); String cmd_update = "UPDATE requestorder SET TOTAL_QTY='" + l_qty.Text + "', STATUS='1', CUST_ID_STORE='" + cust_id_store + "', EMPLOYEE_ID='" + epy_id + "', EMPLOYEE_NAME='" + epy_name + "' WHERE REQUEST_ORDER_ID = '" + l_transaksi.Text + "'"; sql.ExecuteNonQuery(cmd_update); }
//=================================================================================== //====================UPDATE PETTY CASH HEADER========================= public void update_petty_header() { //MessageBox.Show(totall.ToString()); String cmd_update = "UPDATE pettycash SET EXPENSE_DATE='" + d_tgl_expense.Text + "', TOTAL_EXPENSE = '" + totall + "' WHERE PETTY_CASH_ID='" + l_transaksi.Text + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); }
//======================UPDATE TRANS(IS_CLOSING 0)============================= public void update_trans() { ckon.con.Close(); String cmd_update = "UPDATE [transaction] SET IS_CLOSE='1' WHERE IS_CLOSE='0'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); }
//========================UPDATE REQ ORDER HEADER =============================================== public void update_header() { DateTime mydate = DateTime.Now; String cmd_update = "UPDATE ho_header SET STORE_CODE = '" + kode_movement + "', MUTASI_FROM_WAREHOUSE = '" + kode_from + "', MUTASI_TO_WAREHOUSE = '" + kode_to + "',REQUEST_DELIVERY_DATE = '" + mydate.ToString("yyyy-MM-dd") + "', CUST_ID_STORE='" + cust_id_store + "', EMPLOYEE_ID='" + epy_id + "', EMPLOYEE_NAME='" + epy_name + "', TRANS_TYPE_ID='" + transtypeid + "', TRANS_TYPE_CODE='" + kode_movement + "', DATE='" + mydate.ToString("yyyy-MM-dd") + "', TIME='" + mydate.ToLocalTime().ToString("H:mm:ss") + "' WHERE MUTASI_ORDER_ID = '" + l_transaksi.Text + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); }
public void change_inv() { qty_total = good_qty - min_satu; String cmd_update = "UPDATE inventory SET GOOD_QTY='" + qty_total + "' WHERE _id='" + inv_id + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); }
//======================================DELETE DATA BEFORE GET FROM API================================== public void delete() { ckon.con.Close(); String sql = "DELETE FROM article_ho"; CRUD exec = new CRUD(); exec.ExecuteNonQuery(sql); }
public void return_inv_DO() { qty_total_trans = qty_rec_do + good_qty; String cmd_update = "UPDATE inventory SET GOOD_QTY='" + qty_total_trans + "' WHERE _id='" + inv_id + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); }
//===================================BUTTON oke=================================== private void b_ok_Click(object sender, EventArgs e) { Boolean api_response; CRUD sql = new CRUD(); try { if (cek_closing_shift == "0") { MessageBox.Show("Please Closing Shift First Before Closing Store"); } else { clearUploadSyncHist(); if (cash_label <= 0) { update_close(); String cmd_deleteTmp = "DELETE FROM [tmp].[" + store_code + "]"; sql.ExecuteNonQuery(cmd_deleteTmp); //===========API CLOSING STORE============ API_Closing_Store closing_Store = new API_Closing_Store(); closing_Store.get_code(id_cStrore2); api_response = closing_Store.Post_Closing_Store().Result; if (api_response) { //========for logout======== UC_Closing_Store.Instance.reset(); f1.Hide(); this.Hide(); Form_Login login = new Form_Login(); login.ShowDialog(); f1.Close(); this.Close(); } else { String cmd_update = "UPDATE closing_store SET STATUS_CLOSE='0' WHERE ID_C_STORE='" + id_cStrore2 + "'"; CRUD update = new CRUD(); update.ExecuteNonQuery(cmd_update); MessageBox.Show("Make Sure You are Connected To Internet"); } } else { MessageBox.Show("Tidak bisa closing store karena ada perbedaaan antara jumlah fisik dengan sistem"); } } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//==============================ACTION MINUS, PLUS OR DELETE DATA============================ private void dgv_request_CellClick(object sender, DataGridViewCellEventArgs e) { if (dgv_request.Columns[e.ColumnIndex].Name == "Delete") { String DEL = dgv_request.SelectedRows[0].Cells[1].Value.ToString(); String sql = "DELETE FROM ho_line WHERE MUTASI_ORDER_ID='" + l_transaksi.Text + "' AND ARTICLE_ID='" + DEL + "'"; CRUD sql_delete = new CRUD(); sql_delete.ExecuteNonQuery(sql); retreive(); qty(); } if (dgv_request.Columns[e.ColumnIndex].Name == "plus") { ckon.con.Close(); //String _id2 = dgv_request.SelectedRows[0].Cells[0].Value.ToString(); String ID = dgv_request.SelectedRows[0].Cells[1].Value.ToString(); String quantity = dgv_request.SelectedRows[0].Cells[7].Value.ToString(); String subtotal = dgv_request.SelectedRows[0].Cells[10].Value.ToString(); String price = dgv_request.SelectedRows[0].Cells[5].Value.ToString(); int new_price = Int32.Parse(price); int new_subtotal = Int32.Parse(subtotal); int new_qty = Int32.Parse(quantity); new_qty = new_qty + 1; new_subtotal = new_subtotal + new_price; String update = "UPDATE ho_line SET QUANTITY='" + new_qty + "',SUBTOTAL='" + new_subtotal + "' WHERE MUTASI_ORDER_ID='" + l_transaksi.Text + "' AND ARTICLE_ID='" + ID + "'"; CRUD sql_update = new CRUD(); sql_update.ExecuteNonQuery(update); retreive(); qty(); } if (dgv_request.Columns[e.ColumnIndex].Name == "minus") { String ID = dgv_request.SelectedRows[0].Cells[1].Value.ToString(); String quantity = dgv_request.SelectedRows[0].Cells[6].Value.ToString(); String subtotal = dgv_request.SelectedRows[0].Cells[8].Value.ToString(); String price = dgv_request.SelectedRows[0].Cells[7].Value.ToString(); int new_price = Int32.Parse(price); int new_subtotal = Int32.Parse(subtotal); int new_qty = Int32.Parse(quantity); new_qty = new_qty - 1; new_subtotal = new_subtotal - new_price; if (new_qty <= 0) { MessageBox.Show("Minimum QTY 1"); } else { String update = "UPDATE ho_line SET QUANTITY='" + new_qty + "', SUBTOTAL='" + new_subtotal + "' WHERE MUTASI_ORDER_ID='" + l_transaksi.Text + "' AND ARTICLE_ID='" + ID + "'"; CRUD sql_update = new CRUD(); sql_update.ExecuteNonQuery(update); retreive(); qty(); } } setFocus(); }