private void btnDeleteTransaction_Click(object sender, EventArgs e)
{
if (gridSalesHeader.Rows.Count > 0)
{
int index = gridSalesHeader.CurrentRow.Index;
if (index >= 0 && index < gridSalesHeader.Rows.Count)
{
AnsBox ans = new AnsBox(main, "Yakin di HAPUS?", "WARNING!");
DialogResult result = ans.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
int salesID = Int32.Parse(gridSalesHeader.Rows[index].Cells["SalesID"].Value.ToString());
ExecuteQuery("DELETE FROM PrintingSalesHeader WHERE printingSalesID = '" + salesID + "'");
ExecuteQuery("DELETE FROM PrintingSalesDetail WHERE printingSalesID = '" + salesID + "'");
ExecuteQuery("DELETE FROM PrintingSalesDetailFinishing WHERE printingSalesID = '" + salesID + "'");
ExecuteQuery("DELETE FROM PrintingSalesDetailFile WHERE printingSalesID = '" + salesID + "'");
ExecuteQuery("DELETE FROM PrintingSalesPayment WHERE printingSalesID = '" + salesID + "'");
ExecuteQuery("DELETE FROM PrintingSalesDelivery WHERE printingSalesID = '" + salesID + "'");
RefreshHeader(query);
main.SetMessage("PrintingSalesID -> " + salesID + " has been deleted.");
}
}
}
}
private void btnDeleteCustomer_Click(object sender, EventArgs e)
{
if (tbCustomerID.Text != "")
{
AnsBox ans = new AnsBox(main, "Yakin di HAPUS '" + tbCustomerName.Text + "'(" + tbCustomerID.Text + ")?", "WARNING!");
DialogResult result = ans.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
ExecuteQuery("DELETE FROM MsCustomer WHERE customerID = " + tbCustomerID.Text + "");
}
}
}
private void btnHapusBayar_Click(object sender, EventArgs e)
{
if (gridSalesPayment.Rows.Count > 0)
{
int index = gridSalesPayment.CurrentRow.Index;
if (index >= 0 && index < gridSalesPayment.Rows.Count)
{
AnsBox ans = new AnsBox(main, "Yakin di HAPUS?", "WARNING!");
DialogResult result = ans.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
ExecuteQuery("DELETE FROM PrintingSalesPayment WHERE printingSalesID = '" + salesID + "' AND paymentID = '" + gridSalesPayment.Rows[index].Cells["PaymentID"].Value.ToString() + "'");
main.SetMessage("Pembayaran dengan SalesID : " + salesID + " (kode pembayaran : " + gridSalesPayment.Rows[index].Cells["PaymentID"].Value.ToString() + ") telah di HAPUS");
RefreshPayment(salesID);
}
}
}
}
private void button5_Click(object sender, EventArgs e)
{
if (method == "" && nudPembayaran.Value != 0)
{
MsgBox temp = new MsgBox(main, "Pilih metode pembayaran! Wajib tepat!");
temp.ShowDialog();
}
else
{
if (nudPembayaran.Value == 0)
{
AnsBox hutang = new AnsBox(main, "Tidak melakukan pembayaran?");
DialogResult result = hutang.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
nudPembayaran.Focus();
nudPembayaran.Select(0, 9);
}
}
else
{
DataTable dt = ExecuteQuery("SELECT paymentID FROM PrintingSalesPayment WHERE printingSalesID = '" + salesID + "' ORDER BY paymentID DESC LIMIT 0, 1");
int paymentID = (dt != null) ? (dt.Rows.Count == 1) ? (Int32.Parse(dt.Rows[0]["paymentID"].ToString()) + 1) : 1 : 1;
ExecuteQuery("INSERT INTO PrintingSalesPayment VALUES ('" + salesID + "', '" + paymentID + "', now(), '" + nudPembayaran.Value + "', '" + nudPembayaran2.Value + "', '', '" + method + "', '')");
if (method == "CASH")
{
ConnPrintingCashDrawer();
OpenPrintingCashDrawer();
ClosePrintingCashDrawer();
}
DialogResult = System.Windows.Forms.DialogResult.OK;
}
}
}
private void btnPrintWO_Click(object sender, EventArgs e)
{
DataTable dt = main.ExecuteQuery("SELECT psh.printingSalesID, salesTime, "
+ "parentCompanyName, companyName, customerName, "
+ "purchaseOrderID, deliveryNote, printingType, printingTitle, "
+ "jobType, CONCAT(FORMAT(quantity,0), ' ', quantityType) as quantity, "
+ "CONCAT(FORMAT(inschiet,0), ' ', inschietType) as inschiet, material, paperSize, "
+ "imageSize, sidePrint, totalPlat, description, deadline, note "
+ "FROM PrintingSalesHeader psh "
+ "LEFT JOIN PrintingSalesDetail psd ON psh.printingSalesID = psd.printingSalesID "
+ "LEFT JOIN MsCustomer cu ON cu.customerID = psh.customerID "
+ "LEFT JOIN MsCompany co ON co.companyID = cu.companyID "
+ "LEFT JOIN MsParentCompany pc ON co.parentCompanyID = pc.parentCompanyID "
+ "WHERE psh.printingSalesID = '" + salesID + "'");
DataTable dtSub2 = main.ExecuteQuery("SELECT printingSalesID, printingType, printingTitle, finishingType, detail as descriptionFinishing FROM PrintingSalesDetailFinishing WHERE printingSalesID = '" + salesID + "'");
if (dt == null)
{
MessageBox.Show("ERROR PRINT REPORT (LAPORAN HARIAN DI CLOSING FORM STATIONERY)");
this.Dispose();
}
else
{
if (dt.Rows.Count > 0)
{
Rahayu_Program.Report.PrintingSales.PrintingSalesWorkOrder laporan = new Rahayu_Program.Report.PrintingSales.PrintingSalesWorkOrder();
foreach (DataRow i in dt.Rows)
{
AnsBox ans = new AnsBox(main, i["printingType"].ToString() + ", " + i["printingTitle"].ToString() + ", cetak?");
DialogResult result = ans.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
laporan.DataSourceConnections.Clear();
laporan.SetDataSource(dt);
laporan.Subreports["PrintingSalesSubReportFinishing.rpt"].DataSourceConnections.Clear();
if (dtSub2.Rows.Count > 0)
{
laporan.Subreports["PrintingSalesSubReportFinishing.rpt"].SetDataSource(dtSub2);
}
//buatLaporanByQuery(laporan);
//direct print
laporan.PrintOptions.PrinterName = System.IO.File.ReadAllText(Application.StartupPath + @"\config\printer\printing-sales-wo.is");
laporan.PrintToPrinter(1, false, 0, 0);
}
else
{
ans = new AnsBox(main, "batal cetak WO?");
result = ans.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
break;
}
}
}
}
else
{
MessageBox.Show("DATA TIDAK ADA (LAPORAN HARIAN DI CLOSING FORM STATIONERY)");
}
}
}
