private void btnCetak_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtKODEINVOICE.Text))
{
MessageBox.Show("KODE INVOICE KOSONG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtKODEINVOICE.Focus();
return;
}
if (string.IsNullOrEmpty(txtKODECUSTOMER.Text))
{
MessageBox.Show("KODE CUSTOMER KOSONG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtKODECUSTOMER.Focus();
return;
}
if (string.IsNullOrEmpty(txtNAMACUSTOMER.Text))
{
MessageBox.Show("NAMA CUSTOMER KOSONG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtNAMACUSTOMER.Focus();
return;
}
if (dgvSTTINV.SelectedCells.Count > 0)
{
if (string.IsNullOrEmpty(txtKET.Text))
{
MessageBox.Show("MOHON ISI KETERANGAN", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtKET.Focus();
return;
}
c.TGLINVOICE = dtINVOICEDATE.Value.ToString("yyyy-MM-dd");
c.KODEINVOICE = txtKODEINVOICE.Text;
c.KODECUSTOMER = txtKODECUSTOMER.Text;
c.KETERANGAN = txtKET.Text;
DataTable dt = b.SEARCH_NOINVOICE(txtKODEINVOICE.Text);
if (dt.Rows.Count > 0)
{
MessageBox.Show("NO INVOICE TELAH DIBUAT, SILAHKAN CETAK INVOICE", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
b.INSERT(c);
DataTable dtUPDATE = b.SEARCH_NOINVOICE(txtKODEINVOICE.Text);
if (dtUPDATE.Rows.Count > 0)
{
for (int i = 0; i < dtUPDATE.Rows.Count; i++)
{
IDINVOICE = int.Parse(dtUPDATE.Rows[i]["ID"].ToString());
}
}
for (int count = 0; count < dgvSTTINV.Rows.Count; count++)
{
string check = dgvSTTINV.Rows[count].Cells[0].Value.ToString();
if (check == "True")
{
string noconnote = dgvSTTINV.Rows[count].Cells[2].Value.ToString();
bb.UPDATESETINVOICE(IDINVOICE, noconnote);
}
}
cc.KODEIVOICE = txtKODEINVOICE.Text;
LOAD_DETAIL();
CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
REPORTS.INVOICE.FormINVOICE frm = new REPORTS.INVOICE.FormINVOICE(dtPRINT);
frm.ShowDialog();
// print
lblMESSAGE.Text = "SILAHKAN LAKUKAN PENCARIAN PERIODE DAN NAMA CUSTOMER YANG AKAN DIBUATKAN INVOICE";
CLEAR();
}
else
{
MessageBox.Show("TIDAK ADA STT YANG AKANG DI CETAK INVOICE", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
btnCARI.Focus();
}
}
private void btnCetak_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtKODEINVOICE.Text))
{
MessageBox.Show("KODE INVOICE KOSONG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtKODEINVOICE.Focus();
return;
}
if (string.IsNullOrEmpty(txtKODECUSTOMER.Text))
{
MessageBox.Show("KODE CUSTOMER KOSONG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtKODECUSTOMER.Focus();
return;
}
if (string.IsNullOrEmpty(txtNAMACUSTOMER.Text))
{
MessageBox.Show("NAMA CUSTOMER KOSONG", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtNAMACUSTOMER.Focus();
return;
}
if (dgvSTTINV.SelectedCells.Count > 0)
{
if (string.IsNullOrEmpty(txtKET.Text))
{
MessageBox.Show("MOHON ISI KETERANGAN", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtKET.Focus();
return;
}
c.TGLINVOICE = dtINVOICEDATE.Value.ToString("yyyy-MM-dd");
c.KODEINVOICE = txtKODEINVOICE.Text;
c.KODECUSTOMER = txtKODECUSTOMER.Text;
c.KETERANGAN = txtKET.Text;
DataTable dt = b.SEARCH_NOINVOICE(txtKODEINVOICE.Text);
if (dt.Rows.Count > 0)
{
MessageBox.Show("NO INVOICE TELAH DIBUAT, SILAHKAN CETAK INVOICE", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
b.INSERT(c);
DataTable dtUPDATE = b.SEARCH_NOINVOICE(txtKODEINVOICE.Text);
if (dtUPDATE.Rows.Count > 0)
{
for (int i = 0; i < dtUPDATE.Rows.Count; i++)
{
IDINVOICE = int.Parse(dtUPDATE.Rows[i]["ID"].ToString());
}
}
for (int count = 0; count < dgvSTTINV.Rows.Count; count++)
{
string check = dgvSTTINV.Rows[count].Cells[0].Value.ToString();
if (check == "True")
{
string noconnote = dgvSTTINV.Rows[count].Cells[2].Value.ToString();
bb.UPDATESETINVOICE(IDINVOICE, noconnote);
}
}
cc.KODEIVOICE = txtKODEINVOICE.Text;
LOAD_DETAIL();
CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
REPORTS.INVOICE.FormINVOICE frm = new REPORTS.INVOICE.FormINVOICE(dtPRINT);
frm.ShowDialog();
// print
lblMESSAGE.Text = "SILAHKAN LAKUKAN PENCARIAN PERIODE DAN NAMA CUSTOMER YANG AKAN DIBUATKAN INVOICE";
CLEAR();
}
else
{
MessageBox.Show("TIDAK ADA STT YANG AKANG DI CETAK INVOICE", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Stop);
btnCARI.Focus();
}
}
