private void radGridView2_CommandCellClick(object sender, EventArgs e)
{
string lappenjid;
GridCommandCellElement cell = (GridCommandCellElement)sender;
if (cell.CommandButton.TextElement.Text == "Input Laporan")
{
//Create Laporan
using (sinarekDataSetTableAdapters.lappenTableAdapter tbl = new sinarekDataSetTableAdapters.lappenTableAdapter())
{
try
{
lappenjid = tbl.pInsertLapPenj(int.Parse(cell.RowInfo.Cells["LogID"].Value.ToString())
, DateTime.Now
, DateTime.Now
, NBConfig.ValidUserName
, "UJ").ToString();
EditLaporan(lappenjid
, cell.RowInfo.Cells["NOSJ"].Value.ToString()
, false);
this.uangjalanTableAdapter.FillByNoLap(this.sinarekDataSet.uangjalan);
this.vlappenTableAdapter.FillByTanggal(this.sinarekDataSet.vlappen, dtpTanggalLaporan.Value);
}
catch (Exception ex)
{
helper.NotifMessage("Laporan UJ untuk " + cell.RowInfo.Cells["NOSJ"].Value.ToString() + " sudah terinput.");
helper.SysLog(this.GetType().Name, this.Text, "Create Laporan UJ :" + ex.Message);
lappenjid = tbl.GetLapPenID(int.Parse(cell.RowInfo.Cells["LogID"].Value.ToString())
, "UJ").ToString();
}
}
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
//Check if there is at least one rincian
//Check nota sequence
//Check nilai surat jalan vs nilai uang setoran
//Others info connected to this transaction
//Print Selected Transaction
//Print
DialogResult res = MessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
, MessageBoxButtons.OKCancel
, MessageBoxIcon.Question);
if (res == System.Windows.Forms.DialogResult.OK)
{
PrinterSettings printerSettings;
ReportProcessor reportProcessor;
rptLaporanPenj rpt = new rptLaporanPenj();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["lappenid"].Value = lappenid_;
//rpt.ReportParameters["custtypetoid"].Value = custtypetoid;
IReportDocument iRpt = (IReportDocument)rpt;
//// PrinterSettings
printerSettings = new PrinterSettings();
try
{
InstanceReportSource reportSource = new InstanceReportSource();
reportSource.ReportDocument = iRpt;
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(reportSource, printerSettings);
using (sinarekDataSetTableAdapters.lappenTableAdapter tbl = new sinarekDataSetTableAdapters.lappenTableAdapter())
{
tbl.UpdateLapPenj(NBConfig.ValidUserName
, 1
, 1
, int.Parse(lappenid_));
}
SetFormPrinted();
}
catch (Exception ex)
{
helper.ErrorMessage(ex.Message);
}
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
string iLappenID = radGridView3.SelectedRows[0].Cells["lappenID"].Value.ToString();
//Print
DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
, MessageBoxButtons.OKCancel
, RadMessageIcon.Question
, MessageBoxDefaultButton.Button2);
if (res == System.Windows.Forms.DialogResult.OK)
{
PrinterSettings printerSettings;
ReportProcessor reportProcessor;
rptLaporanUJ rpt = new rptLaporanUJ();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["lappenid"].Value = iLappenID;
rpt.ReportParameters["logid"].Value = radGridView3.SelectedRows[0].Cells["logID"].Value.ToString();
IReportDocument iRpt = (IReportDocument)rpt;
iRpt.DocumentName = radGridView3.SelectedRows[0].Cells["NOSJ"].Value.ToString() + " "
+ radGridView3.SelectedRows[0].Cells["SalesName"].Value.ToString();
//// PrinterSettings
printerSettings = new PrinterSettings();
try
{
InstanceReportSource reportSource = new InstanceReportSource();
reportSource.ReportDocument = iRpt;
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(reportSource, printerSettings);
using (sinarekDataSetTableAdapters.lappenTableAdapter tbl = new sinarekDataSetTableAdapters.lappenTableAdapter())
{
tbl.UpdateLapPenj(NBConfig.ValidUserName
, 1
, 1, int.Parse(iLappenID));
}
helper.PrintLog(this.GetType().Name, rpt.Name, "Print:" + iLappenID);
this.vlappenTableAdapter.FillByTanggal(this.sinarekDataSet.vlappen, dtpTanggalLaporan.Value, "UJ");
}
catch (Exception ex)
{
helper.SysLog(this.GetType().Name, this.Text, ex.Message);
//helper.ErrorMessage(ex.Message);
}
}
}
private void btnPrintSales_Click(object sender, EventArgs e)
{
//Print
DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
, MessageBoxButtons.OKCancel
, RadMessageIcon.Question
, MessageBoxDefaultButton.Button2);
if (res == System.Windows.Forms.DialogResult.OK)
{
PrinterSettings printerSettings;
ReportProcessor reportProcessor;
rptLaporanPenjSales rpt = new rptLaporanPenjSales();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["salesname"].Value = lblSales.Text;
rpt.ReportParameters["tanggal"].Value = dtpTanggal.Value;
IReportDocument iRpt = (IReportDocument)rpt;
//iRpt.DocumentName = radGridView1.SelectedRows[0].Cells["NOSJ"].Value.ToString() + " "
// + radGridView1.SelectedRows[0].Cells["SalesName"].Value.ToString();
//// PrinterSettings
printerSettings = new PrinterSettings();
try
{
InstanceReportSource reportSource = new InstanceReportSource();
reportSource.ReportDocument = iRpt;
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(reportSource, printerSettings);
//SavedToPDF(iRpt, @"C:\Users\VINA\Documents\Laporan Penjualan");
using (sinarekDataSetTableAdapters.lappenTableAdapter tbl = new sinarekDataSetTableAdapters.lappenTableAdapter())
{
tbl.UpdatePrintedSales(NBConfig.ValidUserName
, 1
, dtpTanggal.Value
, lblSales.Text);
}
helper.PrintLog(this.GetType().Name, rpt.Name, "PrintSales:" + lblSales.Text + "," + dtpTanggal.Value.ToString("dd MMM yy"));
this.vlappenTableAdapter.FillByTanggal(this.sinarekDataSet.vlappen, dtpTanggal.Value, "Penjualan");
}
catch (Exception ex)
{
helper.ErrorMessage(ex.Message);
}
}
}
private void SaveNewItem()
{
string lappenjid = string.Empty;
if (ValidateFields())
{
using (sinarekDataSetTableAdapters.lappenTableAdapter tbl = new sinarekDataSetTableAdapters.lappenTableAdapter())
{
try
{
lappenjid = tbl.pInsertLapPenj(int.Parse(row_["logid"].ToString())
, dtpTanggal.Value
, dtpKembali.Value
, NBConfig.ValidUserName
, "Penjualan").ToString();
}
catch (Exception ex)
{
helper.NotifMessage("Laporan untuk " + txtSuratJalan.Text + " sudah terinput.");
helper.SysLog(this.GetType().Name, this.Text, "SaveNewItem :" + ex.Message);
lappenjid = tbl.GetLapPenID(int.Parse(row_["logid"].ToString())
, "Penjualan").ToString();
}
finally
{
}
}
//Pas Value to other form
this.Hide();
frmInputPenjualan frm = new frmInputPenjualan(row_, lappenjid, dtpKembali.Value, dtpTglSJ.Value, dtpTanggal.Value);
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog(this.Owner);
this.Close();
}
}
private void radGridView2_CommandCellClick(object sender, EventArgs e)
{
string lappenjid;
GridCommandCellElement cell = (GridCommandCellElement)sender;
string question = string.Empty;
if (cell.RowInfo.Cells["NOSJ"].Value.ToString() == "KAS")
{
question = "Yakin " + cell.RowInfo.Cells["sopirname"].Value.ToString()
+ " sudah kembali dari belanja ?";
}
else
{
question = "Yakin mobil " + cell.RowInfo.Cells["mobilname"].Value.ToString() + " oleh sopir "
+ cell.RowInfo.Cells["sopirname"].Value.ToString()
+ " sudah kembali dari "
+ cell.RowInfo.Cells["tujuan"].Value.ToString();
}
switch (cell.CommandButton.TextElement.Text)
{
case "Input Laporan":
//Print
DialogResult res = RadMessageBox.Show(question, "SMS - Verification"
, MessageBoxButtons.OKCancel
, RadMessageIcon.Question
, MessageBoxDefaultButton.Button2);
if (res == System.Windows.Forms.DialogResult.OK)
{
//Create Laporan
using (sinarekDataSetTableAdapters.lappenTableAdapter tbl = new sinarekDataSetTableAdapters.lappenTableAdapter())
{
try
{
if (cell.RowInfo.Cells["NOSJ"].Value.ToString() != "KAS")
{
lappenjid = tbl.pInsertLapPenj(int.Parse(cell.RowInfo.Cells["LogID"].Value.ToString())
, DateTime.Now
, DateTime.Now
, NBConfig.ValidUserName
, "UJ").ToString();
EditLaporan(lappenjid
, cell.RowInfo.Cells["NOSJ"].Value.ToString()
, false);
}
else
{
lappenjid = tbl.pInsertLapPenj(int.Parse(cell.RowInfo.Cells["ujid"].Value.ToString())
, DateTime.Now
, DateTime.Now
, NBConfig.ValidUserName
, "UB").ToString();
EditLaporanUB(radGridView2, lappenjid
, cell.RowInfo.Cells["NOSJ"].Value.ToString()
, false);
}
this.uangjalanTableAdapter.FillByNoLap(this.sinarekDataSet.uangjalan);
this.vlappenTableAdapter.FillByTanggal(this.sinarekDataSet.vlappen, dtpTanggalLaporan.Value, "UJ");
sinarekDataSet.vlappenDataTable dt = new sinarekDataSet.vlappenDataTable();
this.vlappenTableAdapter.FillByTanggal(dt, dtpTanggalKas.Value, "UB");
radGridView4.DataSource = dt;
}
catch (Exception ex)
{
helper.NotifMessage("Laporan UJ untuk " + cell.RowInfo.Cells["NOSJ"].Value.ToString() + " sudah terinput.");
helper.SysLog(this.GetType().Name, this.Text, "Create Laporan UJ :" + ex.Message);
//lappenjid = tbl.GetLapPenID(int.Parse(cell.RowInfo.Cells["LogID"].Value.ToString()), "UJ").ToString();
}
}
}
break;
case "Batal":
DialogResult res2 = RadMessageBox.Show("Yakin uang jalan mobil " + cell.RowInfo.Cells["mobilname"].Value.ToString() + " oleh sopir "
+ cell.RowInfo.Cells["sopirname"].Value.ToString()
+ " tujuan ke "
+ cell.RowInfo.Cells["tujuan"].Value.ToString() + " akan dibatalkan ?", "SMS - Verification"
, MessageBoxButtons.OKCancel
, RadMessageIcon.Question
, MessageBoxDefaultButton.Button2);
if (res2 == System.Windows.Forms.DialogResult.OK)
{
this.uangjalanTableAdapter.UpdateStatus(3, NBConfig.ValidUserName
, int.Parse(cell.RowInfo.Cells["ujid"].Value.ToString()));
this.uangjalanTableAdapter.FillByNoLap(this.sinarekDataSet.uangjalan);
this.vlappenTableAdapter.FillByTanggal(this.sinarekDataSet.vlappen, dtpTanggalLaporan.Value, "UJ");
}
break;
}
}
