private bool loadImportedDataRO(string filePath) { bool result = false; string sqlCommand = ""; string roInvoice = ""; DS.beginTransaction(); try { DS.mySqlConnect(); System.IO.StreamReader file = new System.IO.StreamReader(filePath); roInvoice = file.ReadLine(); if (!noROExist(roInvoice)) { while ((sqlCommand = file.ReadLine()) != null) { DS.executeNonQueryCommand(sqlCommand); } file.Close(); DS.commit(); } else { MessageBox.Show("NOMOR REQUEST ORDER SUDAH ADA"); } } catch (Exception e) { try { //myTrans.Rollback(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { MessageBox.Show("An exception of type " + ex.GetType() + " was encountered while attempting to roll back the transaction."); } } MessageBox.Show("An exception of type " + e.GetType() + " was encountered while inserting the data."); MessageBox.Show("Neither record was written to database."); } finally { DS.mySqlClose(); result = true; } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; double unitConversion = getConvertValue(); DS.beginTransaction(); try { DS.mySqlConnect(); switch (currentMode) { case NEW_CONVERSION: sqlCommand = "INSERT INTO UNIT_CONVERT (CONVERT_UNIT_ID_1, CONVERT_UNIT_ID_2, CONVERT_MULTIPLIER) VALUES (" + selectedUnit1_ID + ", " + selectedUnit2_ID + ", " + unitConversion + ")"; gUtil.saveSystemDebugLog(globalConstants.MENU_SATUAN, "ADD NEW UNIT CONVERT [" + selectedUnit1_ID + "/" + selectedUnit2_ID + "/" + unitConversion + "]"); break; case EDIT_CONVERSION: sqlCommand = "UPDATE UNIT_CONVERT SET CONVERT_MULTIPLIER = " + unitConversion + " WHERE CONVERT_UNIT_ID_1 = " + selectedUnit1_ID + " AND CONVERT_UNIT_ID_2 = " + selectedUnit2_ID; gUtil.saveSystemDebugLog(globalConstants.MENU_SATUAN, "UPDATE UNIT CONVERT [" + selectedUnit1_ID + "/" + selectedUnit2_ID + "/" + unitConversion + "]"); break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { gUtil.saveSystemDebugLog(globalConstants.MENU_SATUAN, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gUtil.showDBOPError(ex, "ROLLBACK"); } } gUtil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; DS.beginTransaction(); try { DS.mySqlConnect(); sqlCommand = "UPDATE PRODUCT_LOCATION SET PRODUCT_LOCATION_QTY = PRODUCT_LOCATION_QTY + " + jumlahTextBox.Text + " WHERE LOCATION_ID = " + selectedTujuanLocation + " AND PRODUCT_ID = " + selectedProductID; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } sqlCommand = "UPDATE PRODUCT_LOCATION SET PRODUCT_LOCATION_QTY = PRODUCT_LOCATION_QTY - " + jumlahTextBox.Text + " WHERE LOCATION_ID = " + selectedAsalLocation + " AND PRODUCT_ID = " + selectedProductID; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gUtil.showDBOPError(ex, "ROLLBACK"); } } gUtil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; string newPassword = newPasswordTextBox.Text; //newPassword = MySqlHelper.EscapeString(newPassword); MySqlException internalEX = null; DS.beginTransaction(); try { DS.mySqlConnect(); sqlCommand = "UPDATE MASTER_USER SET USER_PASSWORD = '******' WHERE ID = " + selectedUserID; gutil.saveSystemDebugLog(0, "UPDATE NEW PASSWORD [" + newPassword + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; DS.beginTransaction(); noFakturValue = noFakturTextBox.Text; try { DS.mySqlConnect(); sqlCommand = "UPDATE SYS_CONFIG SET NO_FAKTUR = '" + noFakturValue + "' WHERE ID = 1"; gutil.saveSystemDebugLog(globalConstants.MENU_SET_NO_FAKTUR, "UPDATE SYS CONFIG VALUE [" + noFakturValue + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { gutil.saveSystemDebugLog(globalConstants.MENU_SET_NO_FAKTUR, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
public bool saveDataTransaction() { bool result = false; string sqlCommand = ""; string paymentDateTime = ""; DateTime selectedPaymentDate; string paymentDueDateTime = ""; DateTime selectedPaymentDueDate; double paymentNominal = 0; int paymentMethod = 0; string paymentDescription = ""; int paymentConfirmed = 0; MySqlException internalEX = null; selectedPaymentDate = paymentDateTimePicker.Value; paymentDateTime = String.Format(culture, "{0:dd-MM-yyyy}", selectedPaymentDate); paymentNominal = Convert.ToDouble(totalPaymentMaskedTextBox.Text); paymentDescription = MySqlHelper.EscapeString(descriptionTextBox.Text); paymentMethod = paymentCombo.SelectedIndex; if (paymentNominal > globalTotalValue) { paymentNominal = globalTotalValue; } // LARAS : ALL TRANSACTIONS ARE IN CASH paymentMethod = 0; if (paymentMethod < 3) //0, 1, 2 { // TUNAI, KARTU DEBIT, KARTU KREDIT paymentConfirmed = 1; paymentDueDateTime = paymentDateTime; gutil.saveSystemDebugLog(globalConstants.MENU_PEMBAYARAN_HUTANG_SUPPLIER, "PAYMENT DEBT BY CASH"); } else if (paymentMethod == 3) //3 { // TRANSFER paymentDueDateTime = paymentDateTime; gutil.saveSystemDebugLog(globalConstants.MENU_PEMBAYARAN_HUTANG_SUPPLIER, "PAYMENT DEBT BY TRANSFER"); } else if (paymentMethod > 3) //4, 5 { // CEK, BG selectedPaymentDueDate = cairDTPicker.Value; paymentDueDateTime = String.Format(culture, "{0:dd-MM-yyyy}", selectedPaymentDueDate); gutil.saveSystemDebugLog(globalConstants.MENU_PEMBAYARAN_HUTANG_SUPPLIER, "PAYMENT DEBT BY CHEQUE OR BG"); } DS.beginTransaction(); try { DS.mySqlConnect(); // SAVE HEADER TABLE sqlCommand = "INSERT INTO PAYMENT_DEBT (DEBT_ID, PAYMENT_DATE, PM_ID, PAYMENT_NOMINAL, PAYMENT_DESCRIPTION, PAYMENT_CONFIRMED, PAYMENT_DUE_DATE) VALUES " + "(" + selectedDebtID + ", STR_TO_DATE('" + paymentDateTime + "', '%d-%m-%Y'), 1, " + gutil.validateDecimalNumericInput(paymentNominal) + ", '" + paymentDescription + "', " + paymentConfirmed + ", STR_TO_DATE('" + paymentDueDateTime + "', '%d-%m-%Y'))"; gutil.saveSystemDebugLog(globalConstants.MENU_PEMBAYARAN_HUTANG_SUPPLIER, "INSERT INTO PAYMENT DEBT [" + selectedDebtID + ", " + gutil.validateDecimalNumericInput(paymentNominal) + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } if (paymentNominal == globalTotalValue && paymentConfirmed == 1) { // UPDATE CREDIT TABLE sqlCommand = "UPDATE DEBT SET DEBT_PAID = 1 WHERE DEBT_ID = " + selectedDebtID; gutil.saveSystemDebugLog(globalConstants.MENU_PEMBAYARAN_HUTANG_SUPPLIER, "UPDATE DEBT, SET TO FULLY PAID [" + selectedDebtID + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } // UPDATE SALES HEADER TABLE sqlCommand = "UPDATE PURCHASE_HEADER SET PURCHASE_PAID = 1 WHERE PURCHASE_INVOICE = '" + selectedPOInvoice + "'"; gutil.saveSystemDebugLog(globalConstants.MENU_PEMBAYARAN_HUTANG_SUPPLIER, "UPDATE PURCHASE HEADER SET TO FULLY PAID [" + selectedPOInvoice + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } DS.commit(); result = true; } catch (Exception e) { gutil.saveSystemDebugLog(globalConstants.MENU_PEMBAYARAN_HUTANG_SUPPLIER, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction(bool closeStockTake = false) { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; int userID = 0; string productAdjustmentDate = ""; string revisiNo = ""; DS.beginTransaction(); try { DS.mySqlConnect(); userID = gUtil.getUserID(); //productAdjustmentDate = gUtil.getCustomStringFormatDate(DateTime.Now); // TEMP productAdjustmentDate = gUtil.getCustomStringFormatDate(stockTakeDateTimePicker.Value); switch (moduleID) { case NEW_DAILY_STOCK_TAKE: globalProductAdjustmentID = getProductAdjustmentID(); // SAVE DATA HEADER if (closeStockTake) { sqlCommand = "INSERT INTO PRODUCT_DAILY_ADJUSTMENT_HEADER (PRODUCT_ADJUSTMENT_ID, PRODUCT_ADJUSTMENT_DATE, USER_ID, STOCK_TAKE_CLOSED) VALUES (" + globalProductAdjustmentID + ", STR_TO_DATE('" + productAdjustmentDate + "', '%d-%m-%Y %H:%i'), " + userID + ", 1)"; } else { sqlCommand = "INSERT INTO PRODUCT_DAILY_ADJUSTMENT_HEADER (PRODUCT_ADJUSTMENT_ID, PRODUCT_ADJUSTMENT_DATE, USER_ID, STOCK_TAKE_CLOSED) VALUES (" + globalProductAdjustmentID + ", STR_TO_DATE('" + productAdjustmentDate + "', '%d-%m-%Y %H:%i'), " + userID + ", 0)"; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } break; case EDIT_DAILY_STOCK_TAKE: // UPDATE DATA HEADER sqlCommand = "UPDATE PRODUCT_DAILY_ADJUSTMENT_HEADER SET " + "USER_ID = " + userID + " WHERE PRODUCT_ADJUSTMENT_ID = " + globalProductAdjustmentID; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } // CLEAR UP DATA DETAIL sqlCommand = "DELETE FROM PRODUCT_DAILY_ADJUSTMENT_DETAIL WHERE PRODUCT_ADJUSTMENT_ID = " + globalProductAdjustmentID; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } if (closeStockTake) { // UPDATE FLAG sqlCommand = "UPDATE PRODUCT_DAILY_ADJUSTMENT_HEADER SET " + "STOCK_TAKE_CLOSED = 1 WHERE PRODUCT_ADJUSTMENT_ID = " + globalProductAdjustmentID; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } //// SAVE DATA REVISI //revisiNo = getRevisiNo(); //sqlCommand = "INSERT INTO PRODUCT_DAILY_ADJUSTMENT_HISTORY (PRODUCT_ADJUSTMENT_ID, PRODUCT_REVISION_NO, REVISION_REMARK) VALUES(" + // globalProductAdjustmentID + ", " + revisiNo + ", '" + revisionRemark.Text + "')"; //if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) // throw internalEX; break; } // SAVE DATA DETAIL for (int i = 0; i < detailDataGrid.Rows.Count; i++) { sqlCommand = "INSERT INTO PRODUCT_DAILY_ADJUSTMENT_DETAIL (PRODUCT_ADJUSTMENT_ID, PRODUCT_ID, PRODUCT_LAST_STOCK_QTY, PRODUCT_RECEIVED_QTY, PRODUCT_BS_QTY, PRODUCT_SOLD_QTY, PRODUCT_LEFTOVER_QTY, REMARKS, PRODUCT_ADJUSTMENT_QTY, PRODUCT_RIIL_QTY) VALUES (" + globalProductAdjustmentID + ", '" + detailDataGrid.Rows[i].Cells["productID"].Value.ToString() + "', " + detailDataGrid.Rows[i].Cells["awal"].Value.ToString() + ", " + detailDataGrid.Rows[i].Cells["produksi"].Value.ToString() + ", " + detailDataGrid.Rows[i].Cells["BS"].Value.ToString() + ", " + detailDataGrid.Rows[i].Cells["laku"].Value.ToString() + ", " + detailDataGrid.Rows[i].Cells["akhir"].Value.ToString() + ", '" + detailDataGrid.Rows[i].Cells["remark"].Value.ToString() + "', " + detailDataGrid.Rows[i].Cells["penyesuaian"].Value.ToString() + ", " + detailDataGrid.Rows[i].Cells["akhirRiil"].Value.ToString() + ")"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } if (closeStockTake) { // UPDATE STOCK AWAL WITH AKHIR RIIL VALUE sqlCommand = "UPDATE MASTER_PRODUCT SET PRODUCT_STOCK_QTY = " + detailDataGrid.Rows[i].Cells["akhirRiil"].Value.ToString() + ", PRODUCT_STOCK_AWAL = " + detailDataGrid.Rows[i].Cells["akhirRiil"].Value.ToString() + " WHERE PRODUCT_ID = '" + detailDataGrid.Rows[i].Cells["productID"].Value.ToString() + "'"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } } DS.commit(); result = true; } catch (Exception e) { try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gUtil.showDBOPError(ex, "ROLLBACK"); } } gUtil.showDBOPError(e, "INSERT"); result = false; } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; string noRakBaris = ""; string noRakKolom = ""; //string produkBarcode = ""; MySqlException internalEX = null; //string produkID = getProdukID(); //productID = kodeProdukTextBox.Text.Trim(); //string produkBarcode = barcodeTextBox.Text; //if (produkBarcode.Equals("")) // produkBarcode = " "; if (originModuleID != globalConstants.EDIT_PRODUK) { selectedProductID = getProdukID(); } string produkName = namaProdukTextBox.Text.Trim(); string produkDesc = produkDescTextBox.Text.Trim(); if (produkDesc.Equals("")) { produkDesc = " "; } else { produkDesc = MySqlHelper.EscapeString(produkDesc); } string produkHargaPokok = hppTextBox.Text; string produkHargaEcer = hargaEcerTextBox.Text; string produkHargaPartai = hargaPartaiTextBox.Text; string produkHargaGrosir = hargaGrosirTextBox.Text; string produkBrand = merkTextBox.Text.Trim(); if (produkBrand.Equals("")) { produkBrand = " "; } else { produkBrand = MySqlHelper.EscapeString(produkBrand); } string produkQty = stokAwalTextBox.Text; if (produkQty.Equals("")) { produkQty = "0"; } string limitStock = limitStokTextBox.Text; if (limitStock.Equals("")) { limitStock = "0"; } //noRakBaris = noRakBarisTextBox.Text; //noRakKolom= noRakKolomTextBox.Text; while (noRakBaris.Length < 2) { noRakBaris = "-" + noRakBaris; } while (noRakKolom.Length < 2) { noRakKolom = "0" + noRakKolom; } string produkShelves = noRakBaris + noRakKolom; byte produkSvc = 0; if (produkJasaCheckbox.Checked) { produkSvc = 1; } else { produkSvc = 0; } byte produkStatus = 0; if (nonAktifCheckbox.Checked) { produkStatus = 0; } else { produkStatus = 1; } string produkPhoto = " "; if (!selectedPhoto.Equals("")) { produkPhoto = selectedProductID + ".jpg"; } DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.EDIT_PRODUK: // UPDATE MASTER_PRODUK TABLE sqlCommand = "UPDATE MASTER_PRODUCT SET " + // "PRODUCT_BARCODE = '" + produkBarcode + "', " + "PRODUCT_NAME = '" + produkName + "', " + "PRODUCT_DESCRIPTION = '" + produkDesc + "', " + "PRODUCT_BASE_PRICE = " + produkHargaPokok + ", " + "PRODUCT_RETAIL_PRICE = " + produkHargaEcer + ", " + "PRODUCT_BULK_PRICE = " + produkHargaPartai + ", " + "PRODUCT_WHOLESALE_PRICE = " + produkHargaGrosir + ", " + "PRODUCT_PHOTO_1 = '" + produkPhoto + "', " + "UNIT_ID = " + selectedUnitID + ", " + "PRODUCT_STOCK_QTY = " + produkQty + ", " + "PRODUCT_LIMIT_STOCK = " + limitStock + ", " + "PRODUCT_SHELVES = '" + produkShelves + "', " + "PRODUCT_ACTIVE = " + produkStatus + ", " + "PRODUCT_BRAND = '" + produkBrand + "', " + "PRODUCT_IS_SERVICE = " + produkSvc + " " + "WHERE PRODUCT_ID = '" + selectedProductID + "'"; gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "UPDATE CURRENT PRODUCT DATA [" + selectedProductID + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } // UPDATE PRODUCT_CATEGORY TABLE gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "UPDATE PRODUCT CATEGORY FOR [" + selectedProductID + "]"); // delete the content first, and insert the new data based on the currentSelectedKategoryID LIST sqlCommand = "DELETE FROM PRODUCT_CATEGORY WHERE PRODUCT_ID = '" + selectedProductID + "'"; gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "DELETE CURRENT PRODUCT CATEGORY FOR [" + selectedProductID + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } // SAVE TO PRODUCT_CATEGORY TABLE gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "INSERT PRODUCT CATEGORY FOR [" + selectedProductID + "]"); for (int i = 0; i < currentSelectedKategoriID.Count(); i++) { sqlCommand = "INSERT INTO PRODUCT_CATEGORY (PRODUCT_ID, CATEGORY_ID) VALUES ('" + selectedProductID + "', " + currentSelectedKategoriID[i] + ")"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } // UPDATE PRODUCT LOCATION TABLE for (int j = 0; j < detailQty.Count; j++) { sqlCommand = "UPDATE PRODUCT_LOCATION SET PRODUCT_LOCATION_QTY = " + Convert.ToDouble(detailQty[j]) + " WHERE LOCATION_ID = " + detailLokasiDataGridView.Rows[j].Cells["ID"].Value.ToString() + " AND PRODUCT_ID = '" + selectedProductID + "'"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } break; default: // NEW PRODUK // SAVE TO MASTER_PRODUK TABLE sqlCommand = "INSERT INTO MASTER_PRODUCT " + "(PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, PRODUCT_BASE_PRICE, PRODUCT_RETAIL_PRICE, PRODUCT_BULK_PRICE, PRODUCT_WHOLESALE_PRICE, PRODUCT_PHOTO_1, UNIT_ID, PRODUCT_STOCK_QTY, PRODUCT_LIMIT_STOCK, PRODUCT_SHELVES, PRODUCT_ACTIVE, PRODUCT_BRAND, PRODUCT_IS_SERVICE) " + "VALUES " + "('" + selectedProductID + "', '" + produkName + "', '" + produkDesc + "', " + produkHargaPokok + ", " + produkHargaEcer + ", " + produkHargaPartai + ", " + produkHargaGrosir + ", '" + produkPhoto + "', " + selectedUnitID + ", " + produkQty + ", " + limitStock + ", '" + produkShelves + "', " + produkStatus + ", '" + produkBrand + "', " + produkSvc + ")"; gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "INSERT NEW PRODUCT [" + selectedProductID + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } // SAVE TO PRODUCT_CATEGORY TABLE gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "INSERT PRODUCT CATEGORY FOR [" + selectedProductID + "]"); for (int i = 0; i < currentSelectedKategoriID.Count(); i++) { sqlCommand = "INSERT INTO PRODUCT_CATEGORY (PRODUCT_ID, CATEGORY_ID) VALUES ('" + selectedProductID + "', " + currentSelectedKategoriID[i] + ")"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } // SAVE TO PRODUCT_LOCATION_TABLE for (int j = 0; j < detailQty.Count; j++) { sqlCommand = "INSERT INTO PRODUCT_LOCATION (LOCATION_ID, PRODUCT_ID, PRODUCT_LOCATION_QTY) VALUES (" + detailLokasiDataGridView.Rows[j].Cells["ID"].Value.ToString() + ", '" + selectedProductID + "', " + Convert.ToDouble(detailQty[j]) + ")"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } break; } //DS.executeNonQueryCommand(sqlCommand); if (!selectedPhoto.Equals("PRODUCT_PHOTO/" + produkPhoto) && !selectedPhoto.Equals(""))// && result == true) { gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "SET PRODUCT IMAGE [" + selectedPhoto + "]"); panelImage.BackgroundImage = null; System.IO.File.Copy(selectedPhoto, "PRODUCT_PHOTO/" + produkPhoto + "_temp"); gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "COPY SELECTED IMAGE TO PRODUCT_PHOTO FOLDER"); if (System.IO.File.Exists("PRODUCT_PHOTO/" + produkPhoto)) { gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "DELETE CURRENT PRODUCT IMAGE [" + selectedProductID + "]"); System.GC.Collect(); System.GC.WaitForPendingFinalizers(); System.IO.File.Delete("PRODUCT_PHOTO/" + produkPhoto); } System.IO.File.Move("PRODUCT_PHOTO/" + produkPhoto + "_temp", "PRODUCT_PHOTO/" + produkPhoto); panelImage.BackgroundImage = Image.FromFile("PRODUCT_PHOTO/" + produkPhoto); gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "RENAME AND SET NEW PRODUCT IMAGE"); } DS.commit(); result = true; } catch (Exception e) { gUtil.saveSystemDebugLog(globalConstants.MENU_TAMBAH_PRODUK, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gUtil.showDBOPError(ex, "ROLLBACK"); } } gUtil.showDBOPError(e, "ROLLBACK"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; double calculatedResult = 0; double actualResult = 0; double productLoss = 0; string selectedDate = DateTime.Now.ToString(); string pl_Date = String.Format(culture, "{0:dd-MM-yyyy}", Convert.ToDateTime(selectedDate)); DS.beginTransaction(); calculatedResult = Convert.ToDouble(resultTextBox.Text); actualResult = Convert.ToDouble(actualQtyTextBox.Text); productLoss = calculatedResult - actualResult; try { DS.mySqlConnect(); newSelectedProductID = gUtil.getProductID(newSelectedInternalProductID); selectedProductID = gUtil.getProductID(selectedInternalProductID); //REDUCE CURRENT PRODUCT LOCATION QTY sqlCommand = "UPDATE PRODUCT_LOCATION SET PRODUCT_LOCATION_QTY = PRODUCT_LOCATION_QTY - " + gUtil.validateDecimalNumericInput(Convert.ToDouble(numberOfProductTextBox.Text)) + " WHERE PRODUCT_ID = " + selectedProductID + " AND LOCATION_ID = " + locationID; gUtil.saveSystemDebugLog(globalConstants.MENU_PECAH_SATUAN_PRODUK, "REDUCE PRODUCT LOCATION QTY [" + productIDTextBox.Text + "] AMT [" + gUtil.validateDecimalNumericInput(Convert.ToDouble(numberOfProductTextBox.Text)) + "/" + locationID + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } //REDUCE CURRENT STOCK QTY sqlCommand = "UPDATE MASTER_PRODUCT SET PRODUCT_STOCK_QTY = PRODUCT_STOCK_QTY - " + gUtil.validateDecimalNumericInput(Convert.ToDouble(numberOfProductTextBox.Text)) + " WHERE ID = " + selectedInternalProductID; gUtil.saveSystemDebugLog(globalConstants.MENU_PECAH_SATUAN_PRODUK, "REDUCE QTY [" + productIDTextBox.Text + "] AMT [" + gUtil.validateDecimalNumericInput(Convert.ToDouble(numberOfProductTextBox.Text)) + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } //INCREASE NEW PRODUCT LOCATION QTY sqlCommand = "UPDATE PRODUCT_LOCATION SET PRODUCT_LOCATION_QTY = PRODUCT_LOCATION_QTY + " + actualResult + " WHERE PRODUCT_ID = " + newSelectedProductID + " AND LOCATION_ID = " + locationID; gUtil.saveSystemDebugLog(globalConstants.MENU_PECAH_SATUAN_PRODUK, "ADD PRODUCT LOCATION QTY [" + newProductIDTextBox.Text + "] AMT [" + actualResult + "] [" + locationID + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } //INCREASE NEW STOCK QTY sqlCommand = "UPDATE MASTER_PRODUCT SET PRODUCT_STOCK_QTY = PRODUCT_STOCK_QTY + " + actualResult + " WHERE ID = " + newSelectedInternalProductID; gUtil.saveSystemDebugLog(globalConstants.MENU_PECAH_SATUAN_PRODUK, "ADD QTY [" + newProductIDTextBox.Text + "] AMT [" + actualResult + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } //if (actualResult < calculatedResult) { // INSERT INTO PRODUCT LOSS TABLE sqlCommand = "INSERT INTO PRODUCT_LOSS (PL_DATETIME, PRODUCT_ID, PRODUCT_QTY, NEW_PRODUCT_ID, NEW_PRODUCT_QTY, TOTAL_LOSS) " + "VALUES (STR_TO_DATE('" + pl_Date + "', '%d-%m-%Y'), " + selectedInternalProductID + ", " + Convert.ToDouble(numberOfProductTextBox.Text) + ", " + newSelectedInternalProductID + ", " + gUtil.validateDecimalNumericInput(Convert.ToDouble(resultTextBox.Text)) + ", " + gUtil.validateDecimalNumericInput(productLoss) + ")"; gUtil.saveSystemDebugLog(globalConstants.MENU_PECAH_SATUAN_PRODUK, "ADD PRODUCT LOSS QTY [" + productIDTextBox.Text + "] AMT [" + gUtil.validateDecimalNumericInput(productLoss) + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } DS.commit(); result = true; } catch (Exception e) { gUtil.saveSystemDebugLog(globalConstants.MENU_PECAH_SATUAN_PRODUK, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gUtil.showDBOPError(ex, "ROLLBACK"); } } gUtil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveData() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; int i = 0; int moduleIdValue = 0; int tempModuleID = 0; int userAccessValue = 0; DS.beginTransaction(); try { DS.mySqlConnect(); i = 0; while (i < groupAccessDataGridView.Rows.Count) { tempModuleID = Convert.ToInt32(groupAccessDataGridView.Rows[i].Cells["moduleID"].Value); if (moduleIdValue != tempModuleID) { if (moduleIdValue != 0) { if (Convert.ToInt32(DS.getDataSingleValue("SELECT COUNT(1) FROM USER_ACCESS_MANAGEMENT WHERE MODULE_ID = " + moduleIdValue + " AND GROUP_ID = " + selectedGroupID)) == 0) { // INSERT MODE sqlCommand = "INSERT INTO USER_ACCESS_MANAGEMENT (GROUP_ID, MODULE_ID, USER_ACCESS_OPTION) VALUES (" + selectedGroupID + ", " + moduleIdValue + ", " + userAccessValue + ")"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } else { // EDIT MODE sqlCommand = "UPDATE USER_ACCESS_MANAGEMENT SET USER_ACCESS_OPTION = " + userAccessValue + " WHERE GROUP_ID = " + selectedGroupID + " AND MODULE_ID = " + moduleIdValue; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } } moduleIdValue = tempModuleID; userAccessValue = 0; } if (Convert.ToBoolean(groupAccessDataGridView.Rows[i].Cells["hakAkses"].Value)) { userAccessValue = userAccessValue + Convert.ToInt32(groupAccessDataGridView.Rows[i].Cells["featureID"].Value); } i++; } // INSERT / UPDATE if (Convert.ToInt32(DS.getDataSingleValue("SELECT COUNT(1) FROM USER_ACCESS_MANAGEMENT WHERE MODULE_ID = " + moduleIdValue + " AND GROUP_ID = " + selectedGroupID)) == 0) { // INSERT MODE sqlCommand = "INSERT INTO USER_ACCESS_MANAGEMENT (GROUP_ID, MODULE_ID, USER_ACCESS_OPTION) VALUES (" + selectedGroupID + ", " + moduleIdValue + ", " + userAccessValue + ")"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } else { // EDIT MODE sqlCommand = "UPDATE USER_ACCESS_MANAGEMENT SET USER_ACCESS_OPTION = " + userAccessValue + " WHERE GROUP_ID = " + selectedGroupID + " AND MODULE_ID = " + moduleIdValue; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } //DS.executeNonQueryCommand(sqlCommand); DS.commit(); result = true; } catch (Exception e) { try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction(int mode) { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; string HQIP = HQIP1.Text.Trim() + "." + HQIP2.Text.Trim() + "." + HQIP3.Text.Trim() + "." + HQIP4.Text.Trim();; String branchID = branchComboHidden.Text; //BranchIDTextbox.Text; String locationID = locationComboHidden.Text; //locationIDTextBox.Text; //String no_faktur = ""; String nama_toko = MySqlHelper.EscapeString(NamaTokoTextbox.Text); String alamat_toko = MySqlHelper.EscapeString(AlamatTextbox.Text); String telepon_toko = MySqlHelper.EscapeString(TeleponTextbox.Text); String email_toko = MySqlHelper.EscapeString(EmailTextbox.Text); int id = 2; DS.beginTransaction(); try { DS.mySqlConnect(); switch (mode) { case 1: sqlCommand = "INSERT INTO SYS_CONFIG (ID, NO_FAKTUR, BRANCH_ID, LOCATION_ID, HQ_IP4, STORE_NAME, STORE_ADDRESS, STORE_PHONE, STORE_EMAIL, POS_RECEIPT_PRINTER, KUARTO_PRINTER) " + "VALUES (2, '', '" + branchID + "', '" + locationID + "', '" + HQIP + "', '" + nama_toko + "', '" + alamat_toko + "', '" + telepon_toko + "', '" + email_toko + "', '" + posReceiptPrinter.Text + "', '" + kuartoPrinter.Text + "')"; options = gutil.INS; gutil.saveSystemDebugLog(0, "INSERT DATA ID 2 TO SYS_CONFIG"); break; case 2: sqlCommand = "UPDATE SYS_CONFIG SET " + "BRANCH_ID = " + branchID + ", " + "LOCATION_ID = " + locationID + ", " + "HQ_IP4 = '" + HQIP + "', " + "STORE_NAME = '" + nama_toko + "', " + "STORE_ADDRESS = '" + alamat_toko + "', " + "STORE_PHONE = '" + telepon_toko + "', " + "STORE_EMAIL = '" + email_toko + "', " + "POS_RECEIPT_PRINTER = '" + posReceiptPrinter.Text + "', " + "KUARTO_PRINTER = '" + kuartoPrinter.Text + "' " + "WHERE ID = " + id; options = gutil.UPD; gutil.saveSystemDebugLog(0, "UPDATE DATA ID 2"); break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { gutil.saveSystemDebugLog(0, "UPDATE / INSERT FAILED"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; DS.beginTransaction(); try { DS.mySqlConnect(); for (int i = 0; i < pengaturanKategoriDataGridView.Rows.Count; i++) { if (categoryProductValue[i].hasCategoryID != Convert.ToBoolean(pengaturanKategoriDataGridView.Rows[i].Cells["hakAkses"].Value)) { if ((categoryProductValue[i].hasCategoryID)) { sqlCommand = "DELETE FROM PRODUCT_CATEGORY WHERE PRODUCT_ID = '" + pengaturanKategoriDataGridView.Rows[i].Cells["PRODUCT_ID"].Value.ToString() + "' AND CATEGORY_ID = " + selectedCategoryID; gutil.saveSystemDebugLog(globalConstants.MENU_PENGATURAN_KATEGORI_PRODUK, "REMOVE CATEGORY [" + selectedCategoryID + "] FOR PRODUCT [" + pengaturanKategoriDataGridView.Rows[i].Cells["PRODUCT_ID"].Value.ToString() + "]"); } else { sqlCommand = "INSERT INTO PRODUCT_CATEGORY (PRODUCT_ID, CATEGORY_ID) VALUES ('" + pengaturanKategoriDataGridView.Rows[i].Cells["PRODUCT_ID"].Value.ToString() + "', " + selectedCategoryID + ")"; gutil.saveSystemDebugLog(globalConstants.MENU_PENGATURAN_KATEGORI_PRODUK, "ADD CATEGORY [" + selectedCategoryID + "] FOR PRODUCT [" + pengaturanKategoriDataGridView.Rows[i].Cells["PRODUCT_ID"].Value.ToString() + "]"); } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } } DS.commit(); result = true; } catch (Exception e) { gutil.saveSystemDebugLog(globalConstants.MENU_PENGATURAN_KATEGORI_PRODUK, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; string suppName = MySqlHelper.EscapeString(supplierNameTextBox.Text.Trim()); string suppAddress1 = MySqlHelper.EscapeString(supplierAddress1TextBox.Text.Trim()); if (suppAddress1.Equals("")) { suppAddress1 = " "; } string suppAddress2 = MySqlHelper.EscapeString(supplierAddress2TextBox.Text.Trim()); if (suppAddress2.Equals("")) { suppAddress2 = " "; } string suppAddressCity = MySqlHelper.EscapeString(supplierAddressCityTextBox.Text.Trim()); if (suppAddressCity.Equals("")) { suppAddressCity = " "; } string suppPhone = supplierPhoneTextBox.Text.Trim(); if (suppPhone.Equals("")) { suppPhone = " "; } string suppFax = supplierFaxTextBox.Text.Trim(); if (suppFax.Equals("")) { suppFax = " "; } string suppEmail = MySqlHelper.EscapeString(supplierEmailTextBox.Text.Trim()); if (suppEmail.Equals("")) { suppEmail = " "; } byte suppStatus = 0; if (nonAktifCheckbox.Checked) { suppStatus = 0; } else { suppStatus = 1; } DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.NEW_SUPPLIER: sqlCommand = "INSERT INTO MASTER_SUPPLIER " + "(SUPPLIER_FULL_NAME, SUPPLIER_ADDRESS1, SUPPLIER_ADDRESS2, SUPPLIER_ADDRESS_CITY, SUPPLIER_PHONE, SUPPLIER_FAX, SUPPLIER_EMAIL, SUPPLIER_ACTIVE) " + "VALUES ('" + suppName + "', '" + suppAddress1 + "', '" + suppAddress2 + "', '" + suppAddressCity + "', '" + suppPhone + "', '" + suppFax + "', '" + suppEmail + "', " + suppStatus + ")"; gUtil.saveSystemDebugLog(globalConstants.MENU_SUPPLIER, "INSERT NEW SUPPLIER [" + suppName + "]"); break; case globalConstants.EDIT_SUPPLIER: sqlCommand = "UPDATE MASTER_SUPPLIER SET " + "SUPPLIER_FULL_NAME = '" + suppName + "', " + "SUPPLIER_ADDRESS1 = '" + suppAddress1 + "', " + "SUPPLIER_ADDRESS2 = '" + suppAddress2 + "', " + "SUPPLIER_ADDRESS_CITY = '" + suppAddressCity + "', " + "SUPPLIER_PHONE = '" + suppPhone + "', " + "SUPPLIER_FAX = '" + suppFax + "', " + "SUPPLIER_EMAIL = '" + suppEmail + "', " + "SUPPLIER_ACTIVE = " + suppStatus + " " + "WHERE SUPPLIER_ID = " + selectedSupplierID; gUtil.saveSystemDebugLog(globalConstants.MENU_SUPPLIER, "UPDATE SUPPLIER [" + selectedSupplierID + "]"); break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { gUtil.saveSystemDebugLog(globalConstants.MENU_SUPPLIER, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gUtil.showDBOPError(ex, "ROLLBACK"); } } gUtil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; double newStockQty = 0; string adjustmentDate; string descriptionParam; string selectedKodeProduct = ""; double qtyDiff = 0; double oldStockQty = 0; double totalCurrentQty = 0; MySqlException internalEX = null; oldStockQty = Convert.ToDouble(jumlahAwalMaskedTextBox.Text); newStockQty = Convert.ToDouble(jumlahBaruMaskedTextBox.Text); qtyDiff = oldStockQty - newStockQty; adjustmentDate = String.Format(culture, "{0:dd-MM-yyyy}", DateTime.Now); if (descriptionTextBox.Text.Length <= 0) { descriptionTextBox.Text = " "; } descriptionParam = MySqlHelper.EscapeString(descriptionTextBox.Text); DS.beginTransaction(); try { DS.mySqlConnect(); selectedKodeProduct = gutil.getProductID(selectedProductID); // UPDATE PRODUCT LOCATION TABLE WITH THE NEW QTY sqlCommand = "UPDATE PRODUCT_LOCATION SET PRODUCT_LOCATION_QTY = " + newStockQty + " WHERE LOCATION_ID = " + locationID + " AND PRODUCT_ID = " + selectedKodeProduct; gutil.saveSystemDebugLog(globalConstants.MENU_PENYESUAIAN_STOK, "UPDATE PRODUCT LOCATION QTY [" + selectedProductID + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } if (qtyDiff > 0) { // UPDATE MASTER PRODUCT WITH THE NEW QTY sqlCommand = "UPDATE MASTER_PRODUCT SET PRODUCT_STOCK_QTY = PRODUCT_STOCK_QTY + " + qtyDiff + " WHERE ID = " + selectedProductID; } else { qtyDiff = Math.Abs(qtyDiff); // UPDATE MASTER PRODUCT WITH THE NEW QTY sqlCommand = "UPDATE MASTER_PRODUCT SET PRODUCT_STOCK_QTY = PRODUCT_STOCK_QTY - " + qtyDiff + " WHERE ID = " + selectedProductID; } gutil.saveSystemDebugLog(globalConstants.MENU_PENYESUAIAN_STOK, "UPDATE STOCK QTY [" + selectedProductID + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } // INSERT INTO PRODUCT ADJUSTMENT TABLE sqlCommand = "INSERT INTO PRODUCT_ADJUSTMENT (PRODUCT_ID, PRODUCT_ADJUSTMENT_DATE, PRODUCT_OLD_STOCK_QTY, PRODUCT_NEW_STOCK_QTY, PRODUCT_ADJUSTMENT_DESCRIPTION) VALUES " + "('" + kodeProductTextBox.Text + "', STR_TO_DATE('" + adjustmentDate + "', '%d-%m-%Y'), " + oldStockQty + ", " + newStockQty + ", '" + descriptionParam + "')"; gutil.saveSystemDebugLog(globalConstants.MENU_PENYESUAIAN_STOK, "INSERT INTO PRODUCT ADJUSTMENT TABLE [" + kodeProductTextBox.Text + ", " + jumlahAwalMaskedTextBox.Text + ", " + jumlahBaruMaskedTextBox.Text + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { gutil.saveSystemDebugLog(globalConstants.MENU_PENYESUAIAN_STOK, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { //commit to database bool result = false; string sqlCommand = ""; MySqlException internalEX = null; int Account_ID = 0; String TglTrans = ""; String timeTrans = ""; Double NominalAkun = 0; int branch_id = getBranchID(); String deskripsi = ""; int user_id = 0; int pm_id = 0; String deskripsiakun = ""; DS.beginTransaction(); try { DS.mySqlConnect(); for (int rows = 0; rows < TransaksiAccountGridView.Rows.Count; rows++) { selectedDJID = 0; selectedDJID = Int32.Parse(TransaksiAccountGridView.Rows[rows].Cells["journal_id"].Value.ToString()); originModuleID = globalConstants.NEW_DJ; if (selectedDJID > 0) { originModuleID = globalConstants.EDIT_DJ; } // CHECK WHETHER DATA NEED TO BE SAVED OR DELETED if (true == Convert.ToBoolean(TransaksiAccountGridView.Rows[rows].Cells["isDeleted"].Value)) { if (originModuleID == globalConstants.NEW_DJ) // SKIP IF IT'S A NEW ENTRY { continue; } else { originModuleID = globalConstants.DELETE_DJ; // CHANGE MODE TO DELETE IF IT'S AN EXISTING ENTRY } } //TglTrans = String.Format(culture, "{0:dd-MM-yyyy}", TransaksiAccountGridView.Rows[rows].Cells[1].Value.ToString()); //timeTrans = gutil.getCustomStringFormatTime(DateTime.Now); //TglTrans = TglTrans + " " + timeTrans; TglTrans = TransaksiAccountGridView.Rows[rows].Cells["tanggal"].Value.ToString(); Account_ID = Int32.Parse(TransaksiAccountGridView.Rows[rows].Cells["kode_akun"].Value.ToString()); pm_id = Int32.Parse(TransaksiAccountGridView.Rows[rows].Cells["PaymentMethodID"].Value.ToString()); Double debet, credit; if (Double.TryParse(TransaksiAccountGridView.Rows[rows].Cells["debet"].Value.ToString(), out debet)) { } if (Double.TryParse(TransaksiAccountGridView.Rows[rows].Cells["kredit"].Value.ToString(), out credit)) { } if (debet == 0) { //credit NominalAkun = credit; } else { NominalAkun = debet; } deskripsiakun = TransaksiAccountGridView.Rows[rows].Cells["deskripsi_akun"].Value.ToString(); user_id = selectedUserID; switch (originModuleID) { case globalConstants.NEW_DJ: sqlCommand = "INSERT INTO DAILY_JOURNAL (ACCOUNT_ID, JOURNAL_DATETIME, JOURNAL_NOMINAL, BRANCH_ID, JOURNAL_DESCRIPTION, USER_ID, PM_ID) " + "VALUES (" + Account_ID + ", STR_TO_DATE('" + TglTrans + "', '%d-%m-%Y %H:%i')" + ", '" + NominalAkun + "', '" + branch_id + "', '" + deskripsiakun + "', '" + user_id + "', " + pm_id + ")"; options = gutil.INS; gutil.saveSystemDebugLog(globalConstants.MENU_TRANSAKSI_HARIAN, "INSERT NEW DATA TO DAILY JOURNAL TABLE [" + Account_ID + ", " + NominalAkun + "]"); break; case globalConstants.EDIT_DJ: sqlCommand = "UPDATE DAILY_JOURNAL SET " + "ACCOUNT_ID = " + Account_ID + ", " + "JOURNAL_DATETIME = " + "STR_TO_DATE('" + TglTrans + "', '%d-%m-%Y %H:%i')" + ", " + "JOURNAL_NOMINAL = '" + NominalAkun + "', " + "BRANCH_ID = '" + branch_id + "', " + "JOURNAL_DESCRIPTION = '" + deskripsiakun + "', " + "USER_ID = '" + user_id + "', " + "PM_ID = '" + pm_id + "' " + "WHERE JOURNAL_ID = '" + selectedDJID + "'"; options = gutil.UPD; gutil.saveSystemDebugLog(globalConstants.MENU_TRANSAKSI_HARIAN, "UPDATE DATA ON DAILY JOURNAL TABLE [" + selectedDJID + "]"); break; case globalConstants.DELETE_DJ: sqlCommand = "DELETE FROM DAILY_JOURNAL WHERE JOURNAL_ID = '" + selectedDJID + "'"; gutil.saveSystemDebugLog(globalConstants.MENU_TRANSAKSI_HARIAN, "DELETE DATA ON DAILY JOURNAL TABLE [" + selectedDJID + "]"); break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } DS.commit(); result = true; } catch (Exception e) { gutil.saveSystemDebugLog(globalConstants.MENU_TRANSAKSI_HARIAN, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; string groupName = MySqlHelper.EscapeString(namaGroupTextBox.Text.Trim()); string groupDesc = MySqlHelper.EscapeString(deskripsiTextBox.Text.Trim()); byte groupStatus = 0; byte groupCashier = 0; if (nonAktifCheckbox.Checked) { groupStatus = 0; } else { groupStatus = 1; } if (cashierCheckBox.Checked) { groupCashier = 1; } else { groupCashier = 0; } DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.NEW_GROUP_USER: case globalConstants.PENGATURAN_GRUP_AKSES: sqlCommand = "INSERT INTO MASTER_GROUP (GROUP_USER_NAME, GROUP_USER_DESCRIPTION, GROUP_USER_ACTIVE, GROUP_IS_CASHIER) VALUES ('" + groupName + "', '" + groupDesc + "', " + groupStatus + ", " + groupCashier + ")"; break; case globalConstants.EDIT_GROUP_USER: sqlCommand = "UPDATE MASTER_GROUP SET GROUP_USER_NAME = '" + groupName + "', GROUP_USER_DESCRIPTION = '" + groupDesc + "', GROUP_USER_ACTIVE = " + groupStatus + ", GROUP_IS_CASHIER = " + groupCashier + " WHERE GROUP_ID = " + selectedGroupID; break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { if (originModuleID == globalConstants.PENGATURAN_GRUP_AKSES && result == true) { selectedGroupID = Convert.ToInt32(DS.getDataSingleValue("SELECT MAX(GROUP_ID) FROM MASTER_GROUP WHERE GROUP_USER_NAME = '" + groupName + "' AND GROUP_USER_DESCRIPTION = '" + groupDesc + "' ")); parentForm.setSelectedGroupID(selectedGroupID); } DS.mySqlClose(); } return(result); }
private bool loadImportedDataPM(string fileName) { bool result = false; string sqlCommand = ""; string pmInvoice = ""; //bool checkForRO = true; //int lastPos = 0; //int prevPos = 0; //int firstPos = 0; string roInvoice = ""; string tempString = ""; int importedBranchID = 0; int storedBranchID = 0; MySqlException internalEX = null; DS.beginTransaction(); try { DS.mySqlConnect(); System.IO.StreamReader file = new System.IO.StreamReader(fileName); pmInvoice = file.ReadLine(); roInvoice = file.ReadLine(); tempString = file.ReadLine();; if (int.TryParse(tempString, out importedBranchID)) { storedBranchID = getBranchID(); if (storedBranchID != importedBranchID) { file.Close(); throw new Exception("INFORMASI BRANCH ID TIDAK SESUAI"); } } else { //MessageBox.Show("INFORMASI BRANCH ID TIDAK DITEMUKAN"); file.Close(); throw new Exception("INFORMASI BRANCH ID TIDAK DITEMUKAN"); } if (!noPMExist(pmInvoice)) { while ((sqlCommand = file.ReadLine()) != null) { //if (checkForRO) //{ // tempString = sqlCommand; // // GET RO_INVOICE // if (sqlCommand.LastIndexOf("RO_INVOICE") > 0) // { // lastPos = sqlCommand.LastIndexOf("',"); // prevPos = sqlCommand.LastIndexOf(", '", lastPos - 1); // roInvoice = sqlCommand.Substring(prevPos+3, lastPos - prevPos-3); // } // // GET BRANCH_ID // if (sqlCommand.IndexOf("BRANCH_ID_TO") > 0) // { // firstPos = tempString.IndexOf("('"); // tempString = tempString.Substring(firstPos); // firstPos = tempString.IndexOf(","); // tempString = tempString.Substring(firstPos+1); // firstPos = tempString.IndexOf(","); // tempString = tempString.Substring(firstPos + 1); // firstPos = tempString.IndexOf(","); // tempString = tempString.Substring(1, firstPos-1); // if (int.TryParse(tempString, out importedBranchID)) // { // storedBranchID = getBranchID(); // if (storedBranchID != importedBranchID) // { // //MessageBox.Show("INFORMASI BRANCH ID TIDAK SESUAI"); // file.Close(); // throw new Exception("INFORMASI BRANCH ID TIDAK SESUAI"); // } // } // else // { // //MessageBox.Show("INFORMASI BRANCH ID TIDAK DITEMUKAN"); // file.Close(); // throw new Exception("INFORMASI BRANCH ID TIDAK DITEMUKAN"); // } // } //} //checkForRO = false; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } file.Close(); if (roInvoice.Length > 0) { sqlCommand = "UPDATE REQUEST_ORDER_HEADER SET RO_ACTIVE = 0 WHERE RO_INVOICE = '" + roInvoice + "'"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } DS.commit(); result = true; } else { file.Close(); throw new Exception("NOMOR MUTASI SUDAH ADA"); } } catch (Exception e) { result = false; try { //myTrans.Rollback(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { MessageBox.Show("An exception of type " + ex.GetType() + " was encountered while attempting to roll back the transaction."); } } MessageBox.Show(e.Message); } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; string kodeakun = kodeTextbox.Text.Trim(); string deskripsiakun = MySqlHelper.EscapeString(DeskripsiTextbox.Text.Trim()); int tipeakun = Int32.Parse(TipeComboBox.SelectedValue.ToString()); int nonactive = 1; if (NonactiveCheckbox.Checked == true) { nonactive = 0; } DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.NEW_AKUN: sqlCommand = "INSERT INTO MASTER_ACCOUNT (ACCOUNT_ID, ACCOUNT_NAME, ACCOUNT_TYPE_ID, ACCOUNT_ACTIVE) " + "VALUES ('" + kodeakun + "', '" + deskripsiakun + "', '" + tipeakun + "', " + nonactive + ")"; gUtil.saveSystemDebugLog(globalConstants.MENU_PENGATURAN_NO_AKUN, "INSERT DATA TO MASTER ACCOUNT [" + kodeakun + "]"); break; case globalConstants.EDIT_AKUN: sqlCommand = "UPDATE MASTER_ACCOUNT SET " + "ACCOUNT_ID = '" + kodeakun + "', " + "ACCOUNT_NAME = '" + deskripsiakun + "', " + "ACCOUNT_TYPE_ID = '" + tipeakun + "', " + "ACCOUNT_ACTIVE = '" + nonactive + "' " + "WHERE ID = '" + selectedAccountID + "'"; gUtil.saveSystemDebugLog(globalConstants.MENU_PENGATURAN_NO_AKUN, "UPDATE DATA ON MASTER ACCOUNT [" + selectedAccountID + "]"); break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { gUtil.saveSystemDebugLog(globalConstants.MENU_PENGATURAN_NO_AKUN, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gUtil.showDBOPError(ex, "ROLLBACK"); } } gUtil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; int custBlocked = 0; string selectedDate = dateJoinedDateTimePicked.Value.ToShortDateString(); string custJoinedDate = String.Format(culture, "{0:dd-MM-yyyy}", Convert.ToDateTime(selectedDate)); string custName = MySqlHelper.EscapeString(custNameTextBox.Text.Trim()); double maxCreditAmount = 0; string custAddress1 = custAddress1TextBox.Text.Trim(); if (custAddress1.Equals("")) { custAddress1 = " "; } else { custAddress1 = MySqlHelper.EscapeString(custAddress1); } string custAddress2 = custAddress2TextBox.Text.Trim(); if (custAddress2.Equals("")) { custAddress2 = " "; } else { custAddress2 = MySqlHelper.EscapeString(custAddress2); } string custAddressCity = custAddressCityTextBox.Text.Trim(); if (custAddressCity.Equals("")) { custAddressCity = " "; } else { custAddressCity = MySqlHelper.EscapeString(custAddressCity); } string custPhone = custTelTextBox.Text.Trim(); if (custPhone.Equals("")) { custPhone = " "; } else { custPhone = MySqlHelper.EscapeString(custPhone); } string custFax = custFaxTextBox.Text.Trim(); if (custFax.Equals("")) { custFax = " "; } else { custFax = MySqlHelper.EscapeString(custFax); } string custEmail = custEmailTextBox.Text.Trim(); if (custEmail.Equals("")) { custEmail = " "; } else { custEmail = MySqlHelper.EscapeString(custEmail); } string custTotalSales = custTotalSalesTextBox.Text.Trim(); if (custTotalSales.Equals("")) { custTotalSales = "0"; } int custGroup = groupPelangganCombo.SelectedIndex + 1; byte custStatus = 0; if (nonAktifCheckbox.Checked) { custStatus = 0; } else { custStatus = 1; } if (maxCredit.Text.Length > 0) { maxCreditAmount = Convert.ToDouble(maxCredit.Text); } if (blockedCustomer.Checked) { custBlocked = 1; } DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.NEW_CUSTOMER: sqlCommand = "INSERT INTO MASTER_CUSTOMER " + "(CUSTOMER_FULL_NAME, CUSTOMER_ADDRESS1, CUSTOMER_ADDRESS2, CUSTOMER_ADDRESS_CITY, CUSTOMER_PHONE, CUSTOMER_FAX, CUSTOMER_EMAIL, CUSTOMER_ACTIVE, CUSTOMER_JOINED_DATE, CUSTOMER_TOTAL_SALES_COUNT, CUSTOMER_GROUP, MAX_CREDIT, CUSTOMER_BLOCKED, REGION_ID) " + "VALUES ('" + custName + "', '" + custAddress1 + "', '" + custAddress2 + "', '" + custAddressCity + "', '" + custPhone + "', '" + custFax + "', '" + custEmail + "', " + custStatus + ", STR_TO_DATE('" + custJoinedDate + "', '%d-%m-%Y'), " + custTotalSales + ", " + custGroup + ", " + maxCreditAmount + ", " + custBlocked + ", " + selectedRegionID + ")"; gUtil.saveSystemDebugLog(globalConstants.MENU_PELANGGAN, "INSERT NEW CUSTOMER DATA [" + custName + "]"); break; case globalConstants.EDIT_CUSTOMER: sqlCommand = "UPDATE MASTER_CUSTOMER SET " + "CUSTOMER_FULL_NAME = '" + custName + "', " + "CUSTOMER_ADDRESS1 = '" + custAddress1 + "', " + "CUSTOMER_ADDRESS2 = '" + custAddress2 + "', " + "CUSTOMER_ADDRESS_CITY = '" + custAddressCity + "', " + "CUSTOMER_PHONE = '" + custPhone + "', " + "CUSTOMER_FAX = '" + custFax + "', " + "CUSTOMER_EMAIL = '" + custEmail + "', " + "CUSTOMER_ACTIVE = " + custStatus + ", " + "CUSTOMER_JOINED_DATE = STR_TO_DATE('" + custJoinedDate + "', '%d-%m-%Y'), " + "CUSTOMER_TOTAL_SALES_COUNT = " + custTotalSales + ", " + "CUSTOMER_GROUP = " + custGroup + ", " + "MAX_CREDIT = " + maxCreditAmount + ", " + "CUSTOMER_BLOCKED = " + custBlocked + ", " + "REGION_ID = " + selectedRegionID + " " + "WHERE CUSTOMER_ID = " + selectedCustomerID; gUtil.saveSystemDebugLog(globalConstants.MENU_PELANGGAN, "EDIT CUSTOMER DATA [" + selectedCustomerID + "]"); break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { gUtil.saveSystemDebugLog(globalConstants.MENU_PELANGGAN, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gUtil.showDBOPError(ex, "ROLLBACK"); } } gUtil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; string regionName = MySqlHelper.EscapeString(namaGroupTextBox.Text.Trim()); string regionDesc = MySqlHelper.EscapeString(deskripsiTextBox.Text.Trim()); byte regionStatus = 0; if (nonAktifCheckbox.Checked) { regionStatus = 0; } else { regionStatus = 1; } DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.NEW_LOCATION: sqlCommand = "INSERT INTO MASTER_LOCATION (LOCATION_NAME, LOCATION_DESCRIPTION, LOCATION_ACTIVE) VALUES ('" + regionName + "', '" + regionDesc + "', " + regionStatus + ")"; break; case globalConstants.EDIT_LOCATION: sqlCommand = "UPDATE MASTER_LOCATION SET LOCATION_NAME = '" + regionName + "', LOCATION_DESCRIPTION= '" + regionDesc + "', LOCATION_ACTIVE = " + regionStatus + " WHERE ID = " + selectedLocationID; break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; string categoryID = ""; string categoryName = MySqlHelper.EscapeString(categoryNameTextBox.Text.Trim()); string categoryDesc = MySqlHelper.EscapeString(categoryDescriptionTextBox.Text.Trim()); byte categoryStatus = 0; if (nonAktifCheckbox.Checked) { categoryStatus = 0; } else { categoryStatus = 1; } DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.NEW_CATEGORY: //if (gutil.isSS_ServerApp() == 1) //{ // categoryID = gutil.getAutoGenerateID("MASTER_CATEGORY", "", "", "CATEGORY_ID"); // sqlCommand = "INSERT INTO MASTER_CATEGORY (CATEGORY_ID, CATEGORY_NAME, CATEGORY_DESCRIPTION, CATEGORY_ACTIVE) " + // "VALUES ('" + categoryID + "', '" + categoryName + "', '" + categoryDesc + "', " + categoryStatus + ")"; //} //else sqlCommand = "INSERT INTO MASTER_CATEGORY (CATEGORY_NAME, CATEGORY_DESCRIPTION, CATEGORY_ACTIVE) " + "VALUES ('" + categoryName + "', '" + categoryDesc + "', " + categoryStatus + ")"; gutil.saveSystemDebugLog(globalConstants.MENU_KATEGORI, "ADD NEW CATEGORY [" + categoryName + "]"); break; case globalConstants.EDIT_CATEGORY: sqlCommand = "UPDATE MASTER_CATEGORY SET " + "CATEGORY_NAME = '" + categoryName + "', " + "CATEGORY_DESCRIPTION = '" + categoryDesc + "', " + "CATEGORY_ACTIVE = " + categoryStatus + " " + "WHERE CATEGORY_ID = " + selectedCategoryID; gutil.saveSystemDebugLog(globalConstants.MENU_KATEGORI, "UPDATE CATEGORY [" + selectedCategoryID + "]"); break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { gutil.saveSystemDebugLog(globalConstants.MENU_KATEGORI, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; string unitName = MySqlHelper.EscapeString(unitNameTextBox.Text.Trim()); string unitDesc = MySqlHelper.EscapeString(unitDescriptionTextBox.Text.Trim()); byte unitStatus = 0; if (nonAktifCheckbox.Checked) { unitStatus = 0; } else { unitStatus = 1; } DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.NEW_UNIT: sqlCommand = "INSERT INTO MASTER_UNIT (UNIT_NAME, UNIT_DESCRIPTION, UNIT_ACTIVE) VALUES ('" + unitName + "', '" + unitDesc + "', " + unitStatus + ")"; gutil.saveSystemDebugLog(globalConstants.MENU_SATUAN, "ADD NEW UNIT [" + unitName + "]"); break; case globalConstants.EDIT_UNIT: sqlCommand = "UPDATE MASTER_UNIT SET UNIT_NAME = '" + unitName + "', UNIT_DESCRIPTION = '" + unitDesc + "', UNIT_ACTIVE = " + unitStatus + " WHERE UNIT_ID = " + selectedUnitID; gutil.saveSystemDebugLog(globalConstants.MENU_SATUAN, "UPDATE UNIT [" + selectedUnitID + "] [" + unitName + ", " + unitDesc + ", " + unitStatus + "]"); break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { gutil.saveSystemDebugLog(globalConstants.MENU_SATUAN, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool updateLocalData() { bool result = false; string sqlCommand = ""; string productID; string productBarcode; string productName; string productDescription; string productBasePrice; string productRetailPrice; string productBulkPrice; string productWholesalePrice; string productService; string productUnitID; string categoryID; MySqlException internalEX = null; MySqlDataReader rdr; DataTable dt = new DataTable(); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); int i = 0; DS.beginTransaction(); gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "UPDATE LOCAL DATA"); sqlCommand = "SELECT PRODUCT_ID FROM MASTER_PRODUCT WHERE PRODUCT_ACTIVE = 1"; try { DS.mySqlConnect(); using (rdr = DS.getData(sqlCommand)) { if (rdr.HasRows) { dt.Load(rdr); rdr.Close(); dataGridView1.DataSource = dt; i = 0; // UPDATE CURRENT DATA IN LOCAL DATABASE gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "UPDATE CURRENT DATA IN LOCAL DATABASE"); while (i < dataGridView1.Rows.Count) { productID = dataGridView1.Rows[i].Cells["PRODUCT_ID"].Value.ToString(); productBasePrice = DS.getDataSingleValue("SELECT PRODUCT_BASE_PRICE FROM TEMP_MASTER_PRODUCT WHERE PRODUCT_ID = '" + productID + "'").ToString(); productRetailPrice = DS.getDataSingleValue("SELECT PRODUCT_RETAIL_PRICE FROM TEMP_MASTER_PRODUCT WHERE PRODUCT_ID = '" + productID + "'").ToString(); productBulkPrice = DS.getDataSingleValue("SELECT PRODUCT_BULK_PRICE FROM TEMP_MASTER_PRODUCT WHERE PRODUCT_ID = '" + productID + "'").ToString(); productWholesalePrice = DS.getDataSingleValue("SELECT PRODUCT_WHOLESALE_PRICE FROM TEMP_MASTER_PRODUCT WHERE PRODUCT_ID = '" + productID + "'").ToString(); productUnitID = DS.getDataSingleValue("SELECT UNIT_ID FROM TEMP_MASTER_PRODUCT WHERE PRODUCT_ID = '" + productID + "'").ToString(); sqlCommand = "UPDATE MASTER_PRODUCT SET " + "PRODUCT_BASE_PRICE = " + productBasePrice + ", PRODUCT_RETAIL_PRICE = " + productRetailPrice + ", PRODUCT_BULK_PRICE = " + productBulkPrice + ", PRODUCT_WHOLESALE_PRICE = " + productWholesalePrice + ", UNIT_ID = " + productUnitID + " WHERE PRODUCT_ID = '" + productID + "'"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } //sqlCommand = "DELETE FROM TEMP_MASTER_PRODUCT WHERE PRODUCT_ID = '" + productID + "'"; //if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) // throw internalEX; i++; } gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "FINISHED UPDATE CURRENT DATA IN LOCAL DATABASE"); dataGridView1.DataSource = null; // INSERT NEW PRODUCT CATEGORY sqlCommand = "SELECT * FROM TEMP_PRODUCT_CATEGORY WHERE CONCAT(PRODUCT_ID, '-', CATEGORY_ID) NOT IN (SELECT CONCAT(PRODUCT_ID, '-', CATEGORY_ID) FROM PRODUCT_CATEGORY)"; using (rdr = DS.getData(sqlCommand)) { gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "INSERT NEW PRODUCT CATEGORY [" + Convert.ToInt32(rdr.HasRows) + "]"); if (rdr.HasRows) { dt2.Load(rdr); rdr.Close(); dataGridView1.DataSource = dt2; i = 0; while (i < dataGridView1.Rows.Count) { productID = dataGridView1.Rows[i].Cells["PRODUCT_ID"].Value.ToString(); categoryID = dataGridView1.Rows[i].Cells["CATEGORY_ID"].Value.ToString(); sqlCommand = "INSERT INTO PRODUCT_CATEGORY (PRODUCT_ID, CATEGORY_ID) VALUES (" + "'" + productID + "', " + categoryID + ")"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } i++; } } } dataGridView1.DataSource = null; // INSERT NEW DATA sqlCommand = "SELECT * FROM TEMP_MASTER_PRODUCT WHERE PRODUCT_ID NOT IN (SELECT PRODUCT_ID FROM MASTER_PRODUCT)"; using (rdr = DS.getData(sqlCommand)) { gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "INSERT NEW PRODUCT DATA [" + Convert.ToInt32(rdr.HasRows) + "]"); if (rdr.HasRows) { dt3.Load(rdr); rdr.Close(); dataGridView1.DataSource = dt3; i = 0; while (i < dataGridView1.Rows.Count) { productID = MySqlHelper.EscapeString(dataGridView1.Rows[i].Cells["PRODUCT_ID"].Value.ToString()); productBarcode = MySqlHelper.EscapeString(dataGridView1.Rows[i].Cells["PRODUCT_BARCODE"].Value.ToString()); productName = MySqlHelper.EscapeString(dataGridView1.Rows[i].Cells["PRODUCT_NAME"].Value.ToString()); productDescription = MySqlHelper.EscapeString(dataGridView1.Rows[i].Cells["PRODUCT_DESCRIPTION"].Value.ToString()); productBasePrice = dataGridView1.Rows[i].Cells["PRODUCT_BASE_PRICE"].Value.ToString(); productRetailPrice = dataGridView1.Rows[i].Cells["PRODUCT_RETAIL_PRICE"].Value.ToString(); productBulkPrice = dataGridView1.Rows[i].Cells["PRODUCT_BULK_PRICE"].Value.ToString(); productWholesalePrice = dataGridView1.Rows[i].Cells["PRODUCT_WHOLESALE_PRICE"].Value.ToString(); productService = dataGridView1.Rows[i].Cells["PRODUCT_IS_SERVICE"].Value.ToString(); productUnitID = dataGridView1.Rows[i].Cells["UNIT_ID"].Value.ToString(); sqlCommand = "INSERT INTO MASTER_PRODUCT (PRODUCT_ID, PRODUCT_BARCODE, PRODUCT_NAME, PRODUCT_DESCRIPTION, PRODUCT_BASE_PRICE, PRODUCT_RETAIL_PRICE, PRODUCT_BULK_PRICE, PRODUCT_WHOLESALE_PRICE, UNIT_ID, PRODUCT_STOCK_QTY, PRODUCT_LIMIT_STOCK, PRODUCT_SHELVES, PRODUCT_ACTIVE, PRODUCT_IS_SERVICE) VALUES (" + "'" + productID + "', '" + productBarcode + "', '" + productName + "', '" + productDescription + "', " + productBasePrice + ", " + productRetailPrice + ", " + productBulkPrice + ", " + productWholesalePrice + ", " + productUnitID + ", 0, 0, '--00', 1, " + productService + ")"; if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } i++; } } } DS.commit(); } } result = true; } catch (Exception e) { gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "ROLLBACK"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; string userName = userNameTextBox.Text.Trim(); string userPhone = MySqlHelper.EscapeString(userPhoneTextBox.Text.Trim()); byte userStatus = 0; if (nonAktifCheckbox.Checked) { userStatus = 0; } else { userStatus = 1; } DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.NEW_SALESPERSON: sqlCommand = "INSERT INTO MASTER_SALESPERSON(SALES_PERSON_NAME, SALES_PERSON_PHONE, SALES_PERSON_ACTIVE) " + "VALUES ('" + userName + "', '" + userPhone + "', " + userStatus + ")"; break; case globalConstants.EDIT_SALESPERSON: sqlCommand = "UPDATE MASTER_SALESPERSON " + "SET SALES_PERSON_NAME = '" + userName + "', " + "SALES_PERSON_PHONE = '" + userPhone + "', " + "SALES_PERSON_ACTIVE = " + userStatus + " " + "WHERE ID = " + selectedUserID; break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; string returID = "0"; int supplierID = 0; string ReturDateTime = ""; double returTotal = 0; double hppValue; double qtyValue; string descriptionValue; DateTime selectedReturDate; MySqlException internalEX = null; // RE-GENERATE NO RETUR IN CASE ID CHANGED noReturTextBox.Text = GUTIL.getAutoGenerateID("RETURN_PURCHASE_HEADER", "RP", "-", "RP_ID"); returID = noReturTextBox.Text; supplierID = selectedSupplierID; selectedReturDate = ReturDtPicker_1.Value; ReturDateTime = String.Format(culture, "{0:dd-MM-yyyy}", selectedReturDate); returTotal = globalTotalValue; DS.beginTransaction(); try { DS.mySqlConnect(); // SAVE HEADER TABLE sqlCommand = "INSERT INTO RETURN_PURCHASE_HEADER (RP_ID, SUPPLIER_ID, RP_DATE, RP_TOTAL, RP_PROCESSED) VALUES " + "('" + returID + "', " + supplierID + ", STR_TO_DATE('" + ReturDateTime + "', '%d-%m-%Y'), " + returTotal + ", 1)"; GUTIL.saveSystemDebugLog(globalConstants.MENU_RETUR_PEMBELIAN, "INSERT TO RETURN PURCHASE HEADER"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } // SAVE DETAIL TABLE for (int i = 0; i < detailReturDataGridView.Rows.Count; i++) { if (null != detailReturDataGridView.Rows[i].Cells["productID"].Value && GUTIL.isProductIDExist(detailReturDataGridView.Rows[i].Cells["productID"].Value.ToString())) { hppValue = Convert.ToDouble(detailReturDataGridView.Rows[i].Cells["hpp"].Value); //Convert.ToDouble(productPriceList[i]); qtyValue = Convert.ToDouble(detailReturDataGridView.Rows[i].Cells["qty"].Value); //Convert.ToDouble(detailQty[i]); try { descriptionValue = detailReturDataGridView.Rows[i].Cells["description"].Value.ToString(); } catch (Exception ex) { descriptionValue = " "; } sqlCommand = "INSERT INTO RETURN_PURCHASE_DETAIL (RP_ID, PRODUCT_ID, PRODUCT_BASEPRICE, PRODUCT_QTY, RP_DESCRIPTION, RP_SUBTOTAL) VALUES " + "('" + returID + "', '" + detailReturDataGridView.Rows[i].Cells["productID"].Value.ToString() + "', " + hppValue + ", " + qtyValue + ", '" + MySqlHelper.EscapeString(descriptionValue) + "', " + Convert.ToDouble(detailReturDataGridView.Rows[i].Cells["subTotal"].Value) + ")"; GUTIL.saveSystemDebugLog(globalConstants.MENU_RETUR_PEMBELIAN, "INSERT TO RETURN PURCHASE DETAIL"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } // UPDATE PRODUCT LOCATION DATA sqlCommand = "UPDATE PRODUCT_LOCATION SET PRODUCT_LOCATION_QTY = PRODUCT_LOCATION_QTY - " + qtyValue + " WHERE PRODUCT_ID = '" + detailReturDataGridView.Rows[i].Cells["productID"].Value.ToString() + "' AND LOCATION_ID = " + locationID; GUTIL.saveSystemDebugLog(globalConstants.MENU_RETUR_PEMBELIAN, "UPDATE PRODUCT LOCATION DATA"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } // UPDATE MASTER PRODUCT sqlCommand = "UPDATE MASTER_PRODUCT SET PRODUCT_STOCK_QTY = PRODUCT_STOCK_QTY - " + qtyValue + " WHERE PRODUCT_ID = '" + detailReturDataGridView.Rows[i].Cells["productID"].Value.ToString() + "'"; GUTIL.saveSystemDebugLog(globalConstants.MENU_RETUR_PEMBELIAN, "UPDATE MASTER PRODUCT"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } } DS.commit(); result = true; } catch (Exception e) { GUTIL.saveSystemDebugLog(globalConstants.MENU_RETUR_PEMBELIAN, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { GUTIL.showDBOPError(ex, "ROLLBACK"); } } GUTIL.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool pullDetailMessageAndSaveToTable(int moduleID, string sqlCommand) { MySqlDataReader rdr; string param1; string param2; string productID; bool newData = false; double jumlahPembayaran; string deskripsiPembayaran; string messageContent = ""; string insertSQLCommand = ""; string todayDate = String.Format(culture, "{0:dd-MM-yyyy}", DateTime.Now); DS.beginTransaction(); try { DS.mySqlConnect(); using (rdr = DS.getData(sqlCommand)) { if (rdr.HasRows) { newData = true; while (rdr.Read()) { param1 = rdr.GetString("PARAM_1"); param2 = rdr.GetString("PARAM_2"); switch (moduleID) { case globalConstants.MENU_TRANSAKSI_PENJUALAN: messageContent = "SALES INVOICE [" + param1 + "] JATUH TEMPO TGL " + param2; break; case globalConstants.MENU_PURCHASE_ORDER: messageContent = "PURCHASE ORDER [" + param1 + "] JATUH TEMPO TGL " + param2; break; case globalConstants.MENU_PEMBAYARAN_PIUTANG: jumlahPembayaran = rdr.GetDouble("JUMLAH"); deskripsiPembayaran = rdr.GetString("DESCRIPTION"); messageContent = "PEMBAYARAN SALES INVOICE [" + param1 + "] [" + deskripsiPembayaran + "] SEBESAR " + jumlahPembayaran.ToString("C2", culture) + " JATUH TEMPO " + param2; break; case globalConstants.MENU_PEMBAYARAN_HUTANG_SUPPLIER: jumlahPembayaran = rdr.GetDouble("JUMLAH"); deskripsiPembayaran = rdr.GetString("DESCRIPTION"); messageContent = "PEMBAYARAN PURCASE ORDER [" + param1 + "] [" + deskripsiPembayaran + "] SEBESAR " + jumlahPembayaran.ToString("C2", culture) + " JATUH TEMPO" + param2; break; case globalConstants.MENU_REQUEST_ORDER: messageContent = "REQUEST ORDER [" + param1 + "] EXPIRED PADA TGL " + param2; break; case globalConstants.MENU_PRODUK: messageContent = "[" + param1 + "] SUDAH MENDEKATI LIMIT, STOK [" + param2 + "]"; productID = rdr.GetString("PRODUCT_ID"); param1 = productID; break; } insertSQLCommand = "INSERT INTO MASTER_MESSAGE (STATUS, MODULE_ID, IDENTIFIER_NO, MSG_DATETIME_CREATED, MSG_CONTENT) " + "VALUES " + "(0, " + moduleID + ", '" + param1 + "', STR_TO_DATE('" + todayDate + "', '%d-%m-%Y'), '" + messageContent + "')"; DS.executeNonQueryCommand(insertSQLCommand); } DS.commit(); } } } catch (Exception e) { try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); } finally { DS.mySqlClose(); } return(newData); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; string kodeRakValue; string nomorRakValue; MySqlException internalEX = null; DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.PENGATURAN_HARGA_JUAL: for (int i = 0; i < dataProdukDataGridView.Rows.Count; i++) { if (Convert.ToBoolean(dataProdukDataGridView.Rows[i].Cells["CHANGED"].Value)) { sqlCommand = "UPDATE MASTER_PRODUCT SET " + "PRODUCT_RETAIL_PRICE = " + Convert.ToInt32(dataProdukDataGridView.Rows[i].Cells["HARGA_ECER"].Value) + ", " + "PRODUCT_BULK_PRICE = " + Convert.ToInt32(dataProdukDataGridView.Rows[i].Cells["HARGA_PARTAI"].Value) + ", " + "PRODUCT_WHOLESALE_PRICE = " + Convert.ToInt32(dataProdukDataGridView.Rows[i].Cells["HARGA_GROSIR"].Value) + " " + "WHERE ID = " + Convert.ToInt32(dataProdukDataGridView.Rows[i].Cells["ID"].Value); gutil.saveSystemDebugLog(globalConstants.MENU_PENGATURAN_HARGA, "UPDATE HARGA FOR [" + Convert.ToString(dataProdukDataGridView.Rows[i].Cells["kodeProduk"].Value) + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } } break; case globalConstants.PENGATURAN_LIMIT_STOK: for (int i = 0; i < dataProdukDataGridView.Rows.Count; i++) { if (Convert.ToBoolean(dataProdukDataGridView.Rows[i].Cells["CHANGED"].Value)) { sqlCommand = "UPDATE MASTER_PRODUCT SET " + "PRODUCT_LIMIT_STOCK = " + Convert.ToInt32(dataProdukDataGridView.Rows[i].Cells["LIMIT_STOK"].Value) + " " + "WHERE ID = " + Convert.ToInt32(dataProdukDataGridView.Rows[i].Cells["ID"].Value); gutil.saveSystemDebugLog(globalConstants.MENU_PENGATURAN_LIMIT_STOK, "UPDATE LIMIT STOK FOR [" + Convert.ToString(dataProdukDataGridView.Rows[i].Cells["kodeProduk"].Value) + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } } break; case globalConstants.PENGATURAN_NOMOR_RAK: for (int i = 0; i < dataProdukDataGridView.Rows.Count; i++) { if (Convert.ToBoolean(dataProdukDataGridView.Rows[i].Cells["CHANGED"].Value)) { kodeRakValue = dataProdukDataGridView.Rows[i].Cells["KODE_RAK"].Value.ToString(); while (kodeRakValue.Length < 2) { kodeRakValue = "-" + kodeRakValue; } nomorRakValue = dataProdukDataGridView.Rows[i].Cells["NOMOR_RAK"].Value.ToString(); while (nomorRakValue.Length < 2) { nomorRakValue = "0" + nomorRakValue; } sqlCommand = "UPDATE MASTER_PRODUCT SET " + "PRODUCT_SHELVES = '" + kodeRakValue + nomorRakValue + "' " + "WHERE ID = " + Convert.ToInt32(dataProdukDataGridView.Rows[i].Cells["ID"].Value); gutil.saveSystemDebugLog(globalConstants.MENU_PENGATURAN_NOMOR_RAK, "UPDATE NOMOR RAK FOR [" + Convert.ToString(dataProdukDataGridView.Rows[i].Cells["kodeProduk"].Value) + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } } break; } DS.commit(); result = true; } catch (Exception e) { gutil.saveSystemDebugLog(globalConstants.MENU_PENGATURAN_HARGA, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; MySqlException internalEX = null; string branchName = MySqlHelper.EscapeString(branchNameTextBox.Text.Trim()); string branchIPv4 = ip1Textbox.Text.Trim() + "." + ip2Textbox.Text.Trim() + "." + ip3Textbox.Text.Trim() + "." + ip4Textbox.Text.Trim(); string branchAddress1 = MySqlHelper.EscapeString(branchAddress1TextBox.Text.Trim()); string branchAddress2 = MySqlHelper.EscapeString(branchAddress2TextBox.Text.Trim()); string branchAddressCity = MySqlHelper.EscapeString(branchAddressCityTextBox.Text.Trim()); string branchPhone = MySqlHelper.EscapeString(branchTelephoneTextBox.Text.Trim()); byte branchStatus = 0; if (nonAktifCheckbox.Checked) { branchStatus = 0; } else { branchStatus = 1; } DS.beginTransaction(); try { DS.mySqlConnect(); switch (originModuleID) { case globalConstants.NEW_BRANCH: sqlCommand = "INSERT INTO MASTER_BRANCH (BRANCH_NAME, BRANCH_ADDRESS_1, BRANCH_ADDRESS_2, BRANCH_ADDRESS_CITY, BRANCH_TELEPHONE, BRANCH_IP4, BRANCH_ACTIVE) " + "VALUES ('" + branchName + "', '" + branchAddress1 + "', '" + branchAddress2 + "', '" + branchAddressCity + "', '" + branchPhone + "', '" + branchIPv4 + "', " + branchStatus + ")"; break; case globalConstants.EDIT_BRANCH: sqlCommand = "UPDATE MASTER_BRANCH SET " + "BRANCH_NAME = '" + branchName + "', " + "BRANCH_ADDRESS_1 = '" + branchAddress1 + "', " + "BRANCH_ADDRESS_2 = '" + branchAddress2 + "', " + "BRANCH_ADDRESS_CITY = '" + branchAddressCity + "', " + "BRANCH_TELEPHONE = '" + branchPhone + "', " + "BRANCH_IP4 = '" + branchIPv4 + "', " + "BRANCH_ACTIVE = '" + branchStatus + "' " + "WHERE BRANCH_ID = '" + selectedBranchID + "'"; break; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception e) { try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gUtil.showDBOPError(ex, "ROLLBACK"); } } gUtil.showDBOPError(e, "INSERT"); result = false; } finally { DS.mySqlClose(); } return(result); }
private bool saveDataTransaction() { bool result = false; string sqlCommand = ""; string productQty; string productOldQty; string productID; string adjusmentDate = ""; string productDescription = ""; int i = 0; MySqlException internalEX = null; DS.beginTransaction(); try { adjusmentDate = String.Format(culture, "{0:dd-MM-yyyy}", DateTime.Now); DS.mySqlConnect(); i = 0; while (i < detailImportDataGrid.Rows.Count) { productQty = detailImportDataGrid.Rows[i].Cells["productRealQty"].Value.ToString(); productID = MySqlHelper.EscapeString(detailImportDataGrid.Rows[i].Cells["productID"].Value.ToString()); productOldQty = detailImportDataGrid.Rows[i].Cells["productQty"].Value.ToString(); productDescription = MySqlHelper.EscapeString(detailImportDataGrid.Rows[i].Cells["description"].Value.ToString()); if (!productOldQty.Equals(productQty)) { sqlCommand = "UPDATE MASTER_PRODUCT SET " + "PRODUCT_STOCK_QTY = " + productQty + " " + "WHERE PRODUCT_ID = '" + productID + "'"; gutil.saveSystemDebugLog(globalConstants.MENU_PENYESUAIAN_STOK, "UPDATE STOCK QTY [" + productID + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } sqlCommand = "INSERT INTO PRODUCT_ADJUSTMENT (PRODUCT_ID, PRODUCT_ADJUSTMENT_DATE, PRODUCT_OLD_STOCK_QTY, PRODUCT_NEW_STOCK_QTY, PRODUCT_ADJUSTMENT_DESCRIPTION) " + "VALUES " + "('" + productID + "', STR_TO_DATE('" + adjusmentDate + "', '%d-%m-%Y'), " + productOldQty + ", " + productQty + ", '" + productDescription + "')"; gutil.saveSystemDebugLog(globalConstants.MENU_PENYESUAIAN_STOK, "INSERT INTO PRODUCT ADJUSTMENT [" + productID + ", " + productOldQty + ", " + productQty + "]"); if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } } i += 1; } DS.commit(); result = true; } catch (Exception e) { gutil.saveSystemDebugLog(globalConstants.MENU_PENYESUAIAN_STOK, "EXCEPTION THROWN [" + e.Message + "]"); try { DS.rollBack(); } catch (MySqlException ex) { if (DS.getMyTransConnection() != null) { gutil.showDBOPError(ex, "ROLLBACK"); } } gutil.showDBOPError(e, "ROLLBACK"); result = false; } finally { DS.mySqlClose(); } return(result); }