private bool checkUserNamePassword()
{
bool retVal = false;
string userName;
string password;
object result;
string sqlCommand = "";
userName = gutil.allTrim(userNameTextBox.Text);
userName = MySqlHelper.EscapeString(userName);
password = gutil.allTrim(passwordTextBox.Text);
password = MySqlHelper.EscapeString(password);
sqlCommand = "SELECT ID FROM MASTER_USER WHERE USER_NAME = '" + userName + "' AND USER_PASSWORD = '******'";
result = DS.getDataSingleValue(sqlCommand);
if (result != null)
{
selectedUserID = Convert.ToInt32(result);
retVal = true;
}
return(retVal);
}
private int getDebtID()
{
int result = 0;
result = Convert.ToInt32(DS.getDataSingleValue("SELECT IFNULL(DEBT_ID, 0) FROM DEBT WHERE PURCHASE_INVOICE = '" + selectedPOInvoice + "'"));
return(result);
}
private bool noPMExist(string roInvoiceValue)
{
bool result = false;
if (0 < Convert.ToInt32(DS.getDataSingleValue("SELECT COUNT(1) FROM PRODUCTS_MUTATION_HEADER WHERE PM_INVOICE = '" + roInvoiceValue + "'")))
{
result = true;
}
return(result);
}
private int getBranchID()
{
int result = 0;
int numOfRows = 0;
numOfRows = Convert.ToInt32(DS.getDataSingleValue("SELECT COUNT(1) FROM SYS_CONFIG WHERE ID = 2"));
if (numOfRows > 0)
{
result = Convert.ToInt32(DS.getDataSingleValue("SELECT IFNULL(BRANCH_ID, 0) FROM SYS_CONFIG WHERE ID = 2"));
}
return(result);
}
private void loadProductName()
{
string productName = "";
if ((newSelectedInternalProductID == selectedInternalProductID) || newSelectedInternalProductID == 0)
{
return;
}
DS.mySqlConnect();
productName = DS.getDataSingleValue("SELECT PRODUCT_NAME FROM MASTER_PRODUCT WHERE ID = " + newSelectedInternalProductID).ToString();
newProductIDTextBox.Text = productName;
}
private string getProductName(string barcodeValue)
{
string productName = "";
if (barcodeValue.Length > 0)
{
try
{
productName = DS.getDataSingleValue("SELECT IFNULL(PRODUCT_NAME, '') FROM MASTER_PRODUCT WHERE PRODUCT_BARCODE = '" + barcodeValue + "'").ToString();
}
catch (Exception e)
{}
}
return(productName);
}
private void loadUnitIDInformation()
{
string sqlCommand;
string unitName = "";
DS.mySqlConnect();
if (selectedUnitID == 0)
{
return;
}
sqlCommand = "SELECT IFNULL(UNIT_NAME, '') FROM MASTER_UNIT WHERE UNIT_ID = " + selectedUnitID;
unitName = DS.getDataSingleValue(sqlCommand).ToString();
unitTextBox.Text = unitName;
}
private void displayUserGroupName()
{
string groupName = "";
DS.mySqlConnect();
groupName = DS.getDataSingleValue("SELECT GROUP_USER_NAME FROM MASTER_GROUP WHERE GROUP_ID = " + selectedGroupID).ToString();
groupNameTextBox.Text = groupName;
}
private bool noROExist(string roInvoiceValue)
{
bool result = false;
if (0 < Convert.ToInt32(DS.getDataSingleValue("SELECT COUNT(1) FROM REQUEST_ORDER_HEADER WHERE RO_INVOICE = '" + roInvoiceValue + "'")))
{
result = true;
}
return(result);
}
private void loadData()
{
int dataCount = 0;
MySqlDataReader rdr;
dataCount = Convert.ToInt32(DS.getDataSingleValue("SELECT COUNT(1) FROM SYS_CONFIG_TAX"));
if (dataCount > 0)
{
using (rdr = DS.getData("SELECT * FROM SYS_CONFIG_TAX"))
{
if (rdr.HasRows)
{
rdr.Read();
persentasePenjualan.Text = rdr.GetString("PERSENTASE_PENJUALAN");
persentasePembelian.Text = rdr.GetString("PERSENTASE_PEMBELIAN");
omsetPenjualan.Text = rdr.GetString("AVERAGE_PENJUALAN_HARIAN");
omsetPembelian.Text = rdr.GetString("AVERAGE_PEMBELIAN_HARIAN");
rasioToleransi.Text = rdr.GetString("RASIO_TOLERANSI");
}
}
}
}
private bool ipAddressExist()
{
bool result = false;
int rowCount;
string ipAddress = ip1Textbox.Text.Trim() + "." + ip2Textbox.Text.Trim() + "." + ip3Textbox.Text.Trim() + "." + ip4Textbox.Text.Trim();
rowCount = Convert.ToInt32(DS.getDataSingleValue("SELECT COUNT(1) FROM MASTER_BRANCH WHERE BRANCH_IP4 = '" + ipAddress + "'"));
if (rowCount > 0)
{
result = true;
}
return(result);
}
private bool validateOldPassword()
{
string oldPassword = oldPasswordTextBox.Text;
oldPassword = MySqlHelper.EscapeString(oldPassword);
int result;
result = Convert.ToInt32(DS.getDataSingleValue("SELECT COUNT(1) FROM MASTER_USER WHERE ID = " + selectedUserID + " AND USER_PASSWORD = '******'"));
if (result != 0)
{
return(true);
}
gutil.saveSystemDebugLog(0, "VALIDATE OLD PASSWORD FAILED [" + oldPassword + "]");
return(false);
}
private void displaySpecificForm(int moduleID, string identifierNo)
{
int productID = 0;
switch (moduleID)
{
case globalConstants.MENU_TRANSAKSI_PENJUALAN:
pembayaranPiutangForm displayPiutangForm = new pembayaranPiutangForm(identifierNo);
displayPiutangForm.ShowDialog(this);
break;
case globalConstants.MENU_PURCHASE_ORDER:
pembayaranHutangForm displayHutangForm = new pembayaranHutangForm(identifierNo);
displayHutangForm.ShowDialog(this);
break;
case globalConstants.MENU_PEMBAYARAN_PIUTANG:
pembayaranPiutangForm displayPiutangFormConfirm = new pembayaranPiutangForm(identifierNo);
displayPiutangFormConfirm.ShowDialog(this);
break;
case globalConstants.MENU_PEMBAYARAN_HUTANG_SUPPLIER:
pembayaranHutangForm displayHutangFormConfirm = new pembayaranHutangForm(identifierNo);
displayHutangFormConfirm.ShowDialog(this);
break;
case globalConstants.MENU_REQUEST_ORDER:
dataMutasiBarangDetailForm displayedForm = new dataMutasiBarangDetailForm(globalConstants.CEK_DATA_MUTASI, identifierNo);
displayedForm.ShowDialog(this);
break;
case globalConstants.MENU_PRODUK:
productID = Convert.ToInt32(DS.getDataSingleValue("SELECT ID FROM MASTER_PRODUCT WHERE PRODUCT_ID = '" + identifierNo + "'"));
dataProdukDetailForm displayProdukDetail = new dataProdukDetailForm(globalConstants.EDIT_PRODUK, productID);
displayProdukDetail.ShowDialog(this);
break;
}
}
public void setUserID(int selectedUserID)
{
userID = selectedUserID;
userName = DS.getDataSingleValue("SELECT IFNULL(USER_NAME, '') FROM MASTER_USER WHERE ID = "+userID).ToString();
}
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 = "";
string dateLogin;
string dateLogOut;
string dateTimeFrom;
string dateTimeTo;
double totalCashTransaction = 0;
double totalNonCashTransaction = 0;
double totalOtherTransaction = 0;
MySqlException internalEX = null;
DS.beginTransaction();
try
{
DS.mySqlConnect();
if (loginState == 0)
{
dateLogin = String.Format(culture, "{0:dd-M-yyyy HH:mm}", DateTime.Now);
// INSERT TO CASHIER LOG
sqlCommand = "INSERT INTO CASHIER_LOG (USER_ID, DATE_LOGIN, AMOUNT_START) VALUES (" + gUtil.getUserID() + ", STR_TO_DATE('" + dateLogin + "', '%d-%m-%Y %H:%i'), " + startAmountBox.Text + ")";
if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX))
{
throw internalEX;
}
gUtil.saveSystemDebugLog(0, "INSERT DATA FOR A NEW CASHIER SESSION, SA=" + startAmountBox.Text);
}
else if (loginState == 1)
{
dateLogOut = String.Format(culture, "{0:dd-M-yyyy HH:mm}", DateTime.Now);
dateTimeFrom = String.Format(culture, "{0:yyyyMMddHHmm}", dateTimeLogin);
dateTimeTo = String.Format(culture, "{0:yyyyMMddHHmm}", DateTime.Now);
//GET TOTAL CASH TRANSACTION
sqlCommand = "SELECT IFNULL(SUM(SALES_TOTAL), 0) FROM SALES_HEADER " +
"WHERE SALES_TOP = 1 AND SALES_PAYMENT_METHOD = 0 " +
"AND DATE_FORMAT(SALES_DATE, '%Y%m%d%H%i') >= '" + dateTimeFrom + "' " +
"AND DATE_FORMAT(SALES_DATE, '%Y%m%d%H%i') <= '" + dateTimeTo + "'";
totalCashTransaction = Convert.ToDouble(DS.getDataSingleValue(sqlCommand));
//GET TOTAL NON CASH TRANSACTION
sqlCommand = "SELECT IFNULL(SUM(SALES_TOTAL), 0) FROM SALES_HEADER " +
"WHERE SALES_TOP = 1 AND SALES_PAYMENT_METHOD > 0 " +
"AND DATE_FORMAT(SALES_DATE, '%Y%m%d%H%i') >= '" + dateTimeFrom + "' " +
"AND DATE_FORMAT(SALES_DATE, '%Y%m%d%H%i') <= '" + dateTimeTo + "'";
totalNonCashTransaction = Convert.ToDouble(DS.getDataSingleValue(sqlCommand));
//GET TOTAL OTHER TRANSACTION
sqlCommand = "SELECT IFNULL(SUM(JOURNAL_NOMINAL), 0) FROM DAILY_JOURNAL DJ, MASTER_ACCOUNT MA " +
"WHERE DJ.PM_ID = 1 AND DJ.ACCOUNT_ID = MA.ACCOUNT_ID AND MA.ACCOUNT_TYPE_ID = 2 " +
"AND DATE_FORMAT(JOURNAL_DATETIME, '%Y%m%d%H%i') >= '" + dateTimeFrom + "' " +
"AND DATE_FORMAT(JOURNAL_DATETIME, '%Y%m%d%H%i') <= '" + dateTimeTo + "'";
totalOtherTransaction = Convert.ToDouble(DS.getDataSingleValue(sqlCommand));
sqlCommand = "UPDATE CASHIER_LOG SET DATE_LOGOUT = STR_TO_DATE('" + dateLogOut + "', '%d-%m-%Y %H:%i'), AMOUNT_END = " + endAmountBox.Text + ", COMMENT = '" + remarkTextBox.Text + "', TOTAL_CASH_TRANSACTION = " + totalCashTransaction + ", TOTAL_NON_CASH_TRANSACTION = " + totalNonCashTransaction + ", TOTAL_OTHER_TRANSACTION = " + totalOtherTransaction + " WHERE ID = " + logEntryID;
if (!DS.executeNonQueryCommand(sqlCommand, ref internalEX))
{
throw internalEX;
}
gUtil.saveSystemDebugLog(0, "UPDATE DATA FOR CASHIER END SESSION, EA=" + endAmountBox.Text + ", TC = " + totalCashTransaction + ", TN=" + totalNonCashTransaction + ", TO=" + totalOtherTransaction);
}
DS.commit();
result = true;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(result);
}
private void printDocument1_PrintPage(object sender, PrintPageEventArgs e)
{
String ucapan = "";
string nm, almt, tlpn, email;
//event printing
gUtil.saveSystemDebugLog(globalConstants.MENU_RETUR_PENJUALAN, "printDocument1_PrintPage, print POS size receipt");
Graphics graphics = e.Graphics;
Font font = new Font("Courier New", 10);
float fontHeight = font.GetHeight();
int startX = 5;
int colxwidth = 93; //31x3
int totrowwidth = 310; //310/10=31
int totrowheight = 20;
int startY = 5;
int Offset = 15;
int offset_plus = 3;
string sqlCommand = "";
string customer = "";
string tgl = "";
string group = "";
double total = 0;
string soInvoice = "";
//HEADER
//set allignemnt
StringFormat sf = new StringFormat();
sf.LineAlignment = StringAlignment.Center;
sf.Alignment = StringAlignment.Center;
//set whole printing area
System.Drawing.RectangleF rect = new System.Drawing.RectangleF(startX, startY + Offset, totrowwidth, totrowheight);
//set right print area
System.Drawing.RectangleF rectright = new System.Drawing.RectangleF(totrowwidth - colxwidth - startX, startY + Offset, colxwidth, totrowheight);
//set middle print area
System.Drawing.RectangleF rectcenter = new System.Drawing.RectangleF((startX + (totrowwidth / 2) - colxwidth - startX), startY + Offset, (totrowwidth / 2) - startX, totrowheight);
loadInfoToko(2, out nm, out almt, out tlpn, out email);
graphics.DrawString(nm, new Font("Courier New", 9),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 12;
rect.Y = startY + Offset;
graphics.DrawString(almt,
new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 10;
rect.Y = startY + Offset;
graphics.DrawString(tlpn,
new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
if (!email.Equals(""))
{
Offset = Offset + 10;
rect.Y = startY + Offset;
graphics.DrawString(email,
new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
}
Offset = Offset + 13;
rect.Y = startY + Offset;
String underLine = "-------------------------------------"; //37 character
graphics.DrawString(underLine, new Font("Courier New", 9),
new SolidBrush(Color.Black), rect, sf);
//end of header
//start of content
MySqlDataReader rdr;
DataTable dt = new DataTable();
DS.mySqlConnect();
//load customer id
sqlCommand = "SELECT RS.RS_INVOICE, RS.SALES_INVOICE AS 'INVOICE', C.CUSTOMER_FULL_NAME AS 'CUSTOMER',DATE_FORMAT(RS.RS_DATETIME, '%d-%M-%Y') AS 'DATE',RS.RS_TOTAL AS 'TOTAL', IF(C.CUSTOMER_GROUP=1,'RETAIL',IF(C.CUSTOMER_GROUP=2,'GROSIR','PARTAI')) AS 'GROUP' FROM RETURN_SALES_HEADER RS,MASTER_CUSTOMER C WHERE RS.CUSTOMER_ID = C.CUSTOMER_ID AND RS.RS_INVOICE = '" + returID + "'" +
" UNION " +
"SELECT RS.RS_INVOICE, RS.SALES_INVOICE AS 'INVOICE', 'P-UMUM' AS 'CUSTOMER', DATE_FORMAT(RS.RS_DATETIME, '%d-%M-%Y') AS 'DATE', RS.RS_TOTAL AS 'TOTAL', 'RETAIL' AS 'GROUP' FROM RETURN_SALES_HEADER RS WHERE RS.CUSTOMER_ID = 0 AND RS.RS_INVOICE = '" + returID + "'" +
"ORDER BY DATE ASC";
using (rdr = DS.getData(sqlCommand))
{
if (rdr.HasRows)
{
rdr.Read();
customer = rdr.GetString("CUSTOMER");
tgl = rdr.GetString("DATE");
total = rdr.GetDouble("TOTAL");
group = rdr.GetString("GROUP");
soInvoice = rdr.GetString("INVOICE");
}
}
DS.mySqlClose();
Offset = Offset + 12;
rect.Y = startY + Offset;
rect.X = startX + 15;
rect.Width = 280;
//SET TO LEFT MARGIN
sf.LineAlignment = StringAlignment.Near;
sf.Alignment = StringAlignment.Near;
ucapan = "RETUR PENJUALAN ";
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
//2. CUSTOMER NAME
Offset = Offset + 12;
rect.Y = startY + Offset;
ucapan = "PELANGGAN : " + customer + " [" + group + "]";
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 13;
rect.Y = startY + Offset;
rect.X = startX;
rect.Width = totrowwidth;
sf.LineAlignment = StringAlignment.Center;
sf.Alignment = StringAlignment.Center;
graphics.DrawString(underLine, new Font("Courier New", 9),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 12;
rect.Y = startY + Offset;
rect.Width = totrowwidth;
ucapan = "BUKTI RETUR ";
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 15 + offset_plus;
rect.Y = startY + Offset;
rect.X = startX + 15;
rect.Width = 280;
sf.LineAlignment = StringAlignment.Near;
sf.Alignment = StringAlignment.Near;
ucapan = "NO. RETUR " + returID;
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 15 + offset_plus;
rect.Y = startY + Offset;
rect.X = startX + 15;
rect.Width = 280;
sf.LineAlignment = StringAlignment.Near;
sf.Alignment = StringAlignment.Near;
ucapan = "NO. INVOICE " + soInvoice;
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 12;
rect.Y = startY + Offset;
ucapan = "TOTAL : " + total.ToString("C2", culture);
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 12;
rect.Y = startY + Offset;
ucapan = "TANGGAL : " + tgl;
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 12;
rect.Y = startY + Offset;
string nama = "";
loadNamaUser(gUtil.getUserID(), out nama);
ucapan = "OPERATOR : " + nama;
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 13;
rect.Y = startY + Offset;
rect.X = startX;
rect.Width = totrowwidth;
sf.LineAlignment = StringAlignment.Center;
sf.Alignment = StringAlignment.Center;
graphics.DrawString(underLine, new Font("Courier New", 9),
new SolidBrush(Color.Black), rect, sf);
// JUMLAH TOTAL INVOICE
sf.LineAlignment = StringAlignment.Near;
sf.Alignment = StringAlignment.Near;
// DISPLAY DETAIL FOR RETUR
string product_id = "";
string product_name = "";
double product_qty = 0;
double product_price = 0;
string product_desc = "";
double total_qty = 0;
//sqlCommand = "SELECT DATE_FORMAT(PC.PAYMENT_DATE, '%d-%M-%Y') AS 'PAYMENT_DATE', PC.PAYMENT_NOMINAL, PC.PAYMENT_DESCRIPTION FROM PAYMENT_CREDIT PC, CREDIT C WHERE PC.PAYMENT_CONFIRMED = 1 AND PC.CREDIT_ID = C.CREDIT_ID AND C.SALES_INVOICE = '" + selectedSOInvoice + "'";
sqlCommand = "SELECT RD.PRODUCT_ID, MP.PRODUCT_NAME, RD.PRODUCT_SALES_PRICE, RD.PRODUCT_RETURN_QTY, RD.RS_DESCRIPTION, RD.RS_SUBTOTAL " +
"FROM RETURN_SALES_DETAIL RD, MASTER_PRODUCT MP " +
"WHERE RD.RS_INVOICE = '" + returID + "' AND RD.PRODUCT_ID = MP.PRODUCT_ID";
using (rdr = DS.getData(sqlCommand))
{
if (rdr.HasRows)
{
while (rdr.Read())
{
product_id = rdr.GetString("PRODUCT_ID");
product_name = rdr.GetString("PRODUCT_NAME");
product_qty = rdr.GetDouble("PRODUCT_RETURN_QTY");
product_price = rdr.GetDouble("PRODUCT_SALES_PRICE");
product_desc = rdr.GetString("RS_DESCRIPTION");
Offset = Offset + 15;
rect.Y = startY + Offset;
rect.X = startX + 15;
rect.Width = 280;
sf.LineAlignment = StringAlignment.Near;
sf.Alignment = StringAlignment.Near;
ucapan = product_qty + " X [" + product_id + "] " + product_name;
if (ucapan.Length > 30)
{
ucapan = ucapan.Substring(0, 30); //maximum 30 character
}
//
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
rectright.Y = Offset - startY;
sf.LineAlignment = StringAlignment.Far;
sf.Alignment = StringAlignment.Far;
ucapan = "@ " + product_price.ToString("C2", culture);//" Rp." + product_price;
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rectright, sf);
if (product_desc.Length > 0)
{
Offset = Offset + 15;
rect.Y = startY + Offset;
rect.X = startX + 15;
rect.Width = 280;
sf.LineAlignment = StringAlignment.Near;
sf.Alignment = StringAlignment.Near;
ucapan = product_desc;
if (ucapan.Length > 30)
{
ucapan = ucapan.Substring(0, 30); //maximum 30 character
}
//
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
}
}
}
}
Offset = Offset + 13;
rect.Y = startY + Offset;
rect.X = startX;
rect.Width = totrowwidth;
sf.LineAlignment = StringAlignment.Center;
sf.Alignment = StringAlignment.Center;
graphics.DrawString(underLine, new Font("Courier New", 9),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 15;
rect.Y = startY + Offset;
rect.X = startX + 15;
rect.Width = 260;
sf.LineAlignment = StringAlignment.Near;
sf.Alignment = StringAlignment.Near;
ucapan = " JUMLAH :";
rectcenter.Y = rect.Y;
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rectcenter, sf);
sf.LineAlignment = StringAlignment.Far;
sf.Alignment = StringAlignment.Far;
ucapan = total.ToString("C2", culture);
rectright.Y = Offset - startY + 1;
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rectright, sf);
total_qty = Convert.ToDouble(DS.getDataSingleValue("SELECT IFNULL(SUM(PRODUCT_RETURN_QTY), 0) FROM RETURN_SALES_DETAIL RD, MASTER_PRODUCT MP WHERE RD.PRODUCT_ID = MP.PRODUCT_ID AND RD.RS_INVOICE = '" + returID + "'"));
Offset = Offset + 25 + offset_plus;
rect.Y = startY + Offset;
rect.X = startX + 15;
rect.Width = 280;
sf.LineAlignment = StringAlignment.Near;
sf.Alignment = StringAlignment.Near;
ucapan = "TOTAL BARANG : " + total_qty;
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
//eNd of content
//FOOTER
Offset = Offset + 13;
rect.Y = startY + Offset;
rect.X = startX;
rect.Width = totrowwidth;
sf.LineAlignment = StringAlignment.Center;
sf.Alignment = StringAlignment.Center;
graphics.DrawString(underLine, new Font("Courier New", 9),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 15;
rect.Y = startY + Offset;
ucapan = "TERIMA KASIH ATAS KUNJUNGAN ANDA";
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 15;
rect.Y = startY + Offset;
ucapan = "MAAF BARANG YANG SUDAH DIBELI";
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
Offset = Offset + 15;
rect.Y = startY + Offset;
ucapan = "TIDAK DAPAT DITUKAR/ DIKEMBALIKKAN";
graphics.DrawString(ucapan, new Font("Courier New", 7),
new SolidBrush(Color.Black), rect, sf);
//end of footer
}
private void loadNoFaktur()
{
noFakturValue = DS.getDataSingleValue("SELECT IFNULL(NO_FAKTUR, '') FROM SYS_CONFIG WHERE ID = 1").ToString();
noFakturTextBox.Text = noFakturValue;
}
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 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);
}
