private bool saveDataTransaction() { string sqlCommand = ""; int numRows; bool result = false; MySqlException internalEX = null; int selectedMonth = 0; DS.beginTransaction(); try { DS.mySqlConnect(); // CHECK FOR CURRENT ENTRY sqlCommand = "SELECT COUNT(1) FROM MASTER_SALES_TARGET WHERE TARGET_YEAR = " + periodeTahunCombo.Text + " AND TARGET_MONTH = " + periodeBulanCombo.SelectedIndex + 1; numRows = Convert.ToInt32(DS.getDataSingleValue(sqlCommand)); if (numRows > 0) { // UPDATE DATA SALES TARGET sqlCommand = "UPDATE MASTER_SALES_TARGET SET SALES_COMMISSION = " + commissionValue.Text + ", TARGET_AMOUNT = " + targetPenjualanTextBox.Text + " WHERE TARGET_YEAR = " + periodeTahunCombo.Text + " AND TARGET_MONTH = " + selectedMonth; } else { // INSERT NEW DATA SALES TARGET selectedMonth = periodeBulanCombo.SelectedIndex + 1; sqlCommand = "INSERT INTO MASTER_SALES_TARGET (TARGET_MONTH, TARGET_YEAR, TARGET_AMOUNT, SALES_COMMISSION) VALUES (" + selectedMonth + ", " + periodeTahunCombo.Text + ", " + targetPenjualanTextBox.Text + ", " + commissionValue.Text + ")"; } if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX)) { throw internalEX; } DS.commit(); result = true; } catch (Exception EX) { 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 = BranchIDTextbox.Text; String no_faktur = ""; int id = 2; DS.beginTransaction(); try { DS.mySqlConnect(); switch (mode) { case 1: sqlCommand = "INSERT INTO SYS_CONFIG (ID, NO_FAKTUR, BRANCH_ID, HQ_IP4) " + "VALUES (2, '', '" + branchID + "', '" + HQIP + "')"; options = gutil.INS; break; case 2: sqlCommand = "UPDATE SYS_CONFIG SET " + "BRANCH_ID = " + branchID + ", " + "HQ_IP4 = '" + HQIP + "' " + "WHERE ID = " + id; options = gutil.UPD; 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); }