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