private void SaveNewItem(short StatusID, bool print)
{
string iLogID = string.Empty;
string mobil = string.Empty
, sopir = string.Empty
, keterangan = null;
int kernetid = -1
, sopirid = -1
, mobilid = -1
, kotaid = -1
//, salesid = -1
, custid = -1
, custtypetoid = -1
, custtypeid = -1;
int paid = 0;
if (custtype_ != "Botol")
{
DataRow[] dr = this.sinarekDataSet.custtype.Select("name = '" + custtype_ + "'");
custtypetoid = int.Parse(dr[0]["custtypeid"].ToString());
//dr = this.sinarekDataSet.custtype.Select("name = 'supplier'");
custtypeid = int.Parse(rddSup.Tag.ToString());
}
else
{
custtypetoid = int.Parse(rddSup.Tag.ToString());
}
if (chkAntar.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
sopirid = int.Parse(rddPelSopir.SelectedValue.ToString());
mobilid = int.Parse(rddPelMobil.SelectedValue.ToString());
kernetid = int.Parse(rddPelKernet.SelectedValue.ToString());
kotaid = int.Parse(rddTujuan.SelectedValue.ToString());
}
string[] sep = { "_" };
custid = int.Parse(rddSup.SelectedValue.ToString().Split(sep, StringSplitOptions.RemoveEmptyEntries)[0]);
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
//Always Create with status created
iLogID = tbl.pInsertLogProd(tanggalDateTimePicker.Value
, 0
, kernetid
, sopirid
, mobilid
, kotaid
, custtypeid
, mobil
, sopir
, keterangan
, custid
, custtypetoid
, custtypetoid
, NBConfig.ValidUserName
, StatusID, paid, 0).ToString();
}
custtypetoid = int.Parse(rddSup.Tag.ToString());
foreach (GridViewRowInfo item in radGridView1.Rows)
{
using (sinarekDataSetTableAdapters.logdetailTableAdapter tbl = new sinarekDataSetTableAdapters.logdetailTableAdapter())
{
try
{
tbl.pInsertLogOther(int.Parse(iLogID)
, item.Cells["keterangan"].Value.ToString()
, 0
, int.Parse(item.Cells["custtypeid"].Value.ToString())
, custtypetoid
, null
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, int.Parse(item.Cells["productid"].Value.ToString())
, int.Parse(item.Cells["status"].Value.ToString())
, decimal.Parse(item.Cells["harga"].Value.ToString())
, NBConfig.ValidUserName);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
MessageBox.Show("Data sudah terinput.", "SMS");
//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;
rptSJ rpt = new rptSJ();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["logid"].Value = iLogID;
IReportDocument iRpt = (IReportDocument)rpt;
//// PrinterSettings
printerSettings = new PrinterSettings();
//// Adjust the printer settings if necessary...
// Print the report using the printer settings.
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(iRpt, printerSettings);
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
tbl.UpdatePrinted(NBConfig.ValidUserName, long.Parse(iLogID));
}
helper.PrintLog(this.GetType().Name, rpt.Name, this.Text + ":LogID-" + iLogID);
}
else
{
MessageBox.Show("Transaksi masuk ini dapat dilihat di daftar transaksi yg belum di print.");
}
}
private void moveSJPel(string sTableName)
{
string sj, prevsj;
int sjid;
MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["SinarConnString"].ToString());
MySqlDataAdapter adapt = new MySqlDataAdapter("Select * From " + sTableName, conn);
DataTable dt = new DataTable(sTableName);
adapt.Fill(dt);
prevsj = string.Empty;
sjid = -1;
foreach (DataRow row in dt.Rows)
{
if (!string.IsNullOrEmpty(row["baseid"].ToString()))
{
sj = row["Nota"].ToString();
if (prevsj != sj)
{
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
try
{
sjid = int.Parse(tbl.pInsertLogProd(DateTime.Parse(row["tgl"].ToString())
, 0
, -2
, -2
, -2
, int.Parse(row["KOTAID"].ToString())
, int.Parse(row["SalesID"].ToString())
, row["KERNET"].ToString()
, row["SOPIR"].ToString()
, row["NOTA"].ToString()
, int.Parse(row["pelid"].ToString())
, 1
, row["KA"].ToString()
, 4, 0, 0).ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
if (sjid != -1)
{
using (sinarekDataSetTableAdapters.logdetailTableAdapter tbl = new sinarekDataSetTableAdapters.logdetailTableAdapter())
{
try
{
tbl.pInsertLogDetail(sjid
, int.Parse(row["baseid"].ToString())
, decimal.Parse(row["keluar"].ToString())
, -1
, 1
, 1
, row["KA"].ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
prevsj = sj;
}
}
}
private void SaveNewItem()
{
short StatusID = 4;
string iLogID = string.Empty;
string mobil = string.Empty
, sopir = string.Empty
, keterangan = null;
int kernetid = -1
, sopirid = -1
, mobilid = -1
, kotaid = -1
, salesid = -1
, custid = -1
, custtypeid = -1
, transtypeid = -1;
int paid = 0;
transtypeid = int.Parse(rddTipe.SelectedValue.ToString());
custtypeid = int.Parse(rddPel.Tag.ToString());
kotaid = int.Parse(rddTujuan.SelectedValue.ToString());
salesid = int.Parse(rddSales.SelectedValue.ToString());
if (chkAntar.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
sopirid = int.Parse(rddSopir.SelectedValue.ToString());
mobilid = int.Parse(rddMobil.SelectedValue.ToString());
kernetid = int.Parse(rddKernet.SelectedValue.ToString());
}
else
{
sopir = txtSopir.Text;
mobil = txtMobil.Text;
}
switch (rddTipe.Text.ToLower())
{
case "pelanggan":
case "staff":
case "pegawai":
case "satpam":
case "campuran":
custid = int.Parse(rddPel.SelectedValue.ToString());
break;
case "sales":
custid = int.Parse(rddSales.SelectedValue.ToString());
break;
case "contoh":
break;
}
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
//Always Create with status created
iLogID = tbl.pInsertLogProd(tanggalDateTimePicker.Value
, 0
, kernetid
, sopirid
, mobilid
, kotaid
, salesid
, mobil
, sopir
, keterangan
, custid
, custtypeid
, transtypeid
, NBConfig.ValidUserName
, StatusID, paid, 0).ToString();
}
foreach (GridViewRowInfo item in radGridView1.Rows)
{
using (sinarekDataSetTableAdapters.logdetailTableAdapter tbl = new sinarekDataSetTableAdapters.logdetailTableAdapter())
{
tbl.pInsertLogDetail(int.Parse(iLogID)
, int.Parse(item.Cells["productid"].Value.ToString())
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, transtypeid
, int.Parse(item.Cells["custtypeid"].Value.ToString())
, 1
, item.Cells["keterangan"].Value.ToString()
, NBConfig.ValidUserName);
}
}
RadMessageBox.Show("Data sudah terinput.", "SMS");
//Print
DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
, MessageBoxButtons.OKCancel
, RadMessageIcon.Question
, MessageBoxDefaultButton.Button1);
if (res == System.Windows.Forms.DialogResult.OK)
{
PrinterSettings printerSettings;
ReportProcessor reportProcessor;
rptSJ rpt = new rptSJ();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["logid"].Value = iLogID;
//rpt.ReportParameters["custtypetoid"].Value = rddTipe.SelectedValue;
IReportDocument iRpt = (IReportDocument)rpt;
//// PrinterSettings
printerSettings = new PrinterSettings();
//// Adjust the printer settings if necessary...
InstanceReportSource reportSource = new InstanceReportSource();
reportSource.ReportDocument = iRpt;
// Print the report using the printer settings.
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(reportSource, printerSettings);
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
tbl.UpdatePrinted(NBConfig.ValidUserName, long.Parse(iLogID));
}
helper.PrintLog(this.GetType().Name, rpt.Name, this.Text + ":LogID-" + iLogID);
}
else
{
MessageBox.Show("Surat Jalan ini dapat dilihat di daftar surat jalan yg belum di print.");
}
}
private void SaveNewItem(short StatusID, bool print)
{
string iLogID = string.Empty;
string mobil = string.Empty
, sopir = string.Empty
, keterangan = null;
int kernetid = -1
, sopirid = -1
, mobilid = -1
, kotaid = -1
, salesid = -1
, custid = -1
//, custtypetoid = -1
, transtypeid = -1
, custtypeid = -1;
int paid = 0;
DataRow[] dr = this.sinarekDataSet.custtype.Select("name = '" + custType_ + "'");
transtypeid = int.Parse(dr[0]["custtypeid"].ToString());
if (custType_ == "pakai")
{
custid = int.Parse(rddSup.SelectedValue.ToString());
custtypeid = int.Parse(rddSup.Tag.ToString());
}
//dr = this.sinarekDataSet.custtype.Select("name = 'supplier'");
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
//Always Create with status created
iLogID = tbl.pInsertLogProd(dtpTanggal.Value
, 1
, kernetid
, sopirid
, mobilid
, kotaid
, salesid
, mobil
, sopir
, keterangan
, custid
, custtypeid
, transtypeid
, NBConfig.ValidUserName
, StatusID, paid, 0).ToString();
}
//custtypeid = int.Parse(rddSup.Tag.ToString());
foreach (GridViewRowInfo item in radGridView1.Rows)
{
using (sinarekDataSetTableAdapters.logdetailTableAdapter tbl = new sinarekDataSetTableAdapters.logdetailTableAdapter())
{
try
{
tbl.pInsertLogOther(int.Parse(iLogID)
, item.Cells["keterangan"].Value.ToString()
, (int.Parse(item.Cells["status"].Value.ToString()) == 5 ? 1 : 0)
, int.Parse(item.Cells["custtypeid"].Value.ToString())
, int.Parse(item.Cells["custtypetoid"].Value.ToString())
, null
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, int.Parse(item.Cells["productid"].Value.ToString())
, int.Parse(item.Cells["status"].Value.ToString())
, 0
, NBConfig.ValidUserName);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
helper.NotifMessage("Data sudah terinput.\nTransaksi masuk ini dapat dilihat di daftar transaksi yg belum di print.");
}
private void SaveNewItem(short StatusID, bool print)
{
string iLogID = string.Empty;
string mobil = string.Empty
, sopir = string.Empty
, keterangan = null;
int kernetid = -1
, sopirid = -1
, mobilid = -1
, kotaid = -1
, custid = -1
, custtypeid = -1;
int paid = 0;
custtypeid = int.Parse(rddSup.Tag.ToString());
string[] sep = { "_" };
custid = int.Parse(rddSup.SelectedValue.ToString());
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
//Always Create with status created
iLogID = tbl.pInsertLogProdChild(dtpTanggal.Value
, parentid_
, 0
, kernetid
, sopirid
, mobilid
, kotaid
, custid
, mobil
, sopir
, keterangan
, custid
, custtypeid
, transtypeid_
, NBConfig.ValidUserName
, StatusID, paid, 0).ToString();
}
foreach (GridViewRowInfo item in radGridView1.Rows)
{
using (sinarekDataSetTableAdapters.logdetailTableAdapter tbl = new sinarekDataSetTableAdapters.logdetailTableAdapter())
{
try
{
tbl.pInsertLogOther(int.Parse(iLogID)
, item.Cells["keterangan"].Value.ToString()
, (int.Parse(item.Cells["status"].Value.ToString()) == 5 ? 1 : 0)
, int.Parse(item.Cells["custtypeid"].Value.ToString())
, int.Parse(item.Cells["custtypetoid"].Value.ToString())
, null
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, int.Parse(item.Cells["productid"].Value.ToString())
, int.Parse(item.Cells["status"].Value.ToString())
, 0
, NBConfig.ValidUserName);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
RadMessageBox.Show("Data sudah terinput.", "SMS");
//Print
DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
, MessageBoxButtons.OKCancel
, RadMessageIcon.Question
, MessageBoxDefaultButton.Button1);
if (res == System.Windows.Forms.DialogResult.OK)
{
PrinterSettings printerSettings;
ReportProcessor reportProcessor;
rptSJ rpt = new rptSJ();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["logid"].Value = iLogID;
IReportDocument iRpt = (IReportDocument)rpt;
//// PrinterSettings
printerSettings = new PrinterSettings();
//// Adjust the printer settings if necessary...
InstanceReportSource reportSource = new InstanceReportSource();
reportSource.ReportDocument = iRpt;
// Print the report using the printer settings.
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(reportSource, printerSettings);
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
tbl.UpdatePrinted(NBConfig.ValidUserName, long.Parse(iLogID));
}
helper.PrintLog(this.GetType().Name, rpt.Name, this.Text + ":LogID-" + iLogID);
}
else
{
MessageBox.Show("Transaksi masuk ini dapat dilihat di daftar transaksi yg belum di print.");
}
}
private void SaveEditItem()
{
string mobil = string.Empty
, sopir = string.Empty
, keterangan = null;
int kernetid = -1
, custid = -1
, sopirid = -1
, mobilid = -1
, kotaid = -1
, salesid = -1
, custtypeid = -1
, transtypeid = -1;
transtypeid = int.Parse(rddTipe.SelectedValue.ToString());
kotaid = int.Parse(rddTujuan.SelectedValue.ToString());
salesid = int.Parse(rddSales.SelectedValue.ToString());
if (chkAntar.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
sopirid = int.Parse(rddSopir.SelectedValue.ToString());
mobilid = int.Parse(rddMobil.SelectedValue.ToString());
kernetid = int.Parse(rddKernet.SelectedValue.ToString());
}
else
{
sopir = txtSopir.Text;
mobil = txtMobil.Text;
}
switch (rddTipe.Text.ToLower())
{
case "pelanggan":
custid = int.Parse(rddPel.SelectedValue.ToString());
custtypeid = int.Parse(rddPel.Tag.ToString());
break;
case "sales":
custid = int.Parse(rddSales.SelectedValue.ToString());
custtypeid = 2;
break;
case "staff":
case "satpam":
case "pegawai":
custid = int.Parse(rddPel.SelectedValue.ToString());
custtypeid = int.Parse(rddPel.Tag.ToString());
break;
case "contoh":
break;
}
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
//Update SJ
tbl.UpdateSJ(tanggalDateTimePicker.Value
, transtypeid
, custtypeid
, custid
, kernetid
, kotaid
, sopirid
, mobil
, mobilid
, salesid
, sopir
, keterangan
, NBConfig.ValidUserName
, logid_).ToString();
}
try
{
//logdetailTableAdapter.Update(this.sinarekDataSet.logdetail);
//insert new records
using (sinarekDataSetTableAdapters.logdetailTableAdapter tbl = new sinarekDataSetTableAdapters.logdetailTableAdapter())
{
foreach (GridViewRowInfo item in radGridView1.Rows)
{
if (item.Cells["detailid"].Value.ToString() == "-1")
{
tbl.pInsertLogDetail(int.Parse(logid_.ToString())
, int.Parse(item.Cells["productid"].Value.ToString())
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, int.Parse(item.Cells["custtypetoid"].Value.ToString())
, int.Parse(item.Cells["custtypeid"].Value.ToString())
, int.Parse(item.Cells["status"].Value.ToString())
, (item.Cells["keterangan"].Value == null ? "" : item.Cells["keterangan"].Value.ToString())
, NBConfig.ValidUserName);
}
else
{
tbl.UpdateItem(int.Parse(item.Cells["productid"].Value.ToString())
, int.Parse(item.Cells["custtypeid"].Value.ToString())
, int.Parse(item.Cells["custtypetoid"].Value.ToString())
, (item.Cells["keterangan"].Value == null ? "" : item.Cells["keterangan"].Value.ToString())
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, NBConfig.ValidUserName, long.Parse(item.Cells["detailid"].Value.ToString()));
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
helper.NotifMessage("SJ sudah tersimpan!");
}
private void SaveNewItem(short StatusID, bool print)
{
string iLogID = string.Empty;
string mobil = string.Empty
, sopir = string.Empty
, keterangan = null;
int kernetid = -1
, sopirid = -1
, mobilid = -1
, kotaid = -1
, salesid = -1
, custid = -1
, custtypetoid = -1;
int paid = 0;
custtypetoid = int.Parse(rddTipe.SelectedValue.ToString());
kotaid = int.Parse(rddTujuan.SelectedValue.ToString());
salesid = int.Parse(rddPelSales.SelectedValue.ToString());
switch (rddTipe.Text.ToLower())
{
case "pelanggan":
custid = int.Parse(mrddPel.SelectedValue.ToString());
if (chkAntar.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
sopirid = int.Parse(rddPelSopir.SelectedValue.ToString());
mobilid = int.Parse(rddPelMobil.SelectedValue.ToString());
kernetid = int.Parse(rddPelKernet.SelectedValue.ToString());
}
else
{
sopir = txtSopir.Text;
mobil = txtMobil.Text;
}
break;
case "sales":
salesid = int.Parse(rddSales.SelectedValue.ToString());
custid = int.Parse(rddSales.SelectedValue.ToString());
sopirid = int.Parse(rddSopir.SelectedValue.ToString());
mobilid = int.Parse(rddMobil.SelectedValue.ToString());
kernetid = int.Parse(rddKernet.SelectedValue.ToString());
break;
case "staff":
case "satpam":
case "buruh":
custid = int.Parse(rddCust.SelectedValue.ToString());
salesid = int.Parse(rddPelSales.SelectedValue.ToString());
break;
case "contoh":
break;
case "rusak":
break;
case "return":
//custtypeid and custtypetoid is switched
break;
}
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
//Always Create with status created
iLogID = tbl.pInsertLogProd(tanggalDateTimePicker.Value
, 1
, kernetid
, sopirid
, mobilid
, kotaid
, salesid
, mobil
, sopir
, keterangan
, custid
, custtypetoid
, NBConfig.ValidUserName
, StatusID, paid, 0).ToString();
}
foreach (GridViewRowInfo item in radGridView1.Rows)
{
using (sinarekDataSetTableAdapters.logdetailTableAdapter tbl = new sinarekDataSetTableAdapters.logdetailTableAdapter())
{
tbl.pInsertLogDetail(int.Parse(iLogID)
, int.Parse(item.Cells["productid"].Value.ToString())
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, -1
, 1
, 1
, NBConfig.ValidUserName);
}
}
MessageBox.Show("Data sudah terinput.", "SMS");
//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;
rptSJ rpt = new rptSJ();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["logid"].Value = iLogID;
rpt.ReportParameters["custtypetoid"].Value = rddTipe.SelectedValue;
IReportDocument iRpt = (IReportDocument)rpt;
//// PrinterSettings
printerSettings = new PrinterSettings();
//// Adjust the printer settings if necessary...
// Print the report using the printer settings.
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(iRpt, printerSettings);
}
else
{
MessageBox.Show("Surat Jalan ini dapat dilihat di daftar surat jalan yg belum di print.");
}
}
private void SaveNewItem(short StatusID, bool print)
{
string iLogID = string.Empty;
string mobil = string.Empty
, sopir = string.Empty
, keterangan = null;
int kernetid = -1
, sopirid = -1
, mobilid = -1
, kotaid = -1
, salesid = -1
, custid = -1
//, custtypetoid = -1
, transtypeid = -1
, custtypeid = -1;
int paid = 0;
string[] sep = { "_" };
custid = int.Parse(rddSup.SelectedValue.ToString().Split(sep, StringSplitOptions.RemoveEmptyEntries)[0]);
custtypeid = int.Parse(rddSup.Tag.ToString());
if (custType_ == "Barang Return")
{
DataRow[] dr = this.sinarekDataSet.custtype.Select("name = 'return'");
transtypeid = int.Parse(dr[0]["custtypeid"].ToString());
//dr = this.sinarekDataSet.custtype.Select("name = 'supplier'");
salesid = custid;
}
else
{
transtypeid = custtypeid;
}
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
//Always Create with status created
iLogID = tbl.pInsertLogProd(dtpTanggal.Value
, 1
, kernetid
, sopirid
, mobilid
, kotaid
, salesid
, mobil
, sopir
, keterangan
, custid
, custtypeid
, transtypeid
, NBConfig.ValidUserName
, StatusID, paid, 0).ToString();
}
custtypeid = int.Parse(rddSup.Tag.ToString());
foreach (GridViewRowInfo item in radGridView1.Rows)
{
using (sinarekDataSetTableAdapters.logdetailTableAdapter tbl = new sinarekDataSetTableAdapters.logdetailTableAdapter())
{
try
{
tbl.pInsertLogOther(int.Parse(iLogID)
, item.Cells["keterangan"].Value.ToString()
, (int.Parse(item.Cells["status"].Value.ToString()) == 5 ? 1 : 0)
, transtypeid
, int.Parse(item.Cells["custtypetoid"].Value.ToString())
, DateTime.Parse(item.Cells["expireddate"].Value.ToString())
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, int.Parse(item.Cells["productid"].Value.ToString())
, int.Parse(item.Cells["status"].Value.ToString())
, 0
, NBConfig.ValidUserName);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
MessageBox.Show("Data sudah terinput.", "SMS");
//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;
rptTM rpt = new rptTM();
rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
rpt.ReportParameters["logid"].Value = iLogID;
IReportDocument iRpt = (IReportDocument)rpt;
//// PrinterSettings
printerSettings = new PrinterSettings();
//// Adjust the printer settings if necessary...
InstanceReportSource reportSource = new InstanceReportSource();
reportSource.ReportDocument = iRpt;
// Print the report using the printer settings.
reportProcessor = new ReportProcessor();
reportProcessor.PrintReport(reportSource, printerSettings);
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
tbl.UpdatePrinted(NBConfig.ValidUserName, long.Parse(iLogID));
}
}
else
{
MessageBox.Show("Transaksi masuk ini dapat dilihat di daftar transaksi yg belum di print.");
}
}
private void SaveEditItem()
{
//Can only update items / kernet / sopir
string iLogID = string.Empty;
string mobil = string.Empty
, sopir = string.Empty
, keterangan = null;
int kernetid = -1
, sopirid = -1
, mobilid = -1
, kotaid = -1
, salesid = -1
, custtypetoid = -1;
custtypetoid = int.Parse(rddTipe.SelectedValue.ToString());
kotaid = int.Parse(rddTujuan.SelectedValue.ToString());
salesid = int.Parse(rddPelSales.SelectedValue.ToString());
switch (rddTipe.Text.ToLower())
{
case "pelanggan":
if (chkAntar.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
sopirid = int.Parse(rddPelSopir.SelectedValue.ToString());
mobilid = int.Parse(rddPelMobil.SelectedValue.ToString());
kernetid = int.Parse(rddPelKernet.SelectedValue.ToString());
}
else
{
sopir = txtSopir.Text;
mobil = txtMobil.Text;
}
break;
case "sales":
salesid = int.Parse(rddSales.SelectedValue.ToString());
sopirid = int.Parse(rddSopir.SelectedValue.ToString());
mobilid = int.Parse(rddMobil.SelectedValue.ToString());
kernetid = int.Parse(rddKernet.SelectedValue.ToString());
break;
case "staff":
case "satpam":
case "buruh":
case "contoh":
break;
}
using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
{
//Update SJ
tbl.UpdateSJ(tanggalDateTimePicker.Value
, kernetid
, kotaid
, sopirid
, mobil
, mobilid
, salesid
, sopir
, keterangan
, NBConfig.ValidUserName
, logid_).ToString();
}
using (sinarekDataSetTableAdapters.logdetailTableAdapter tbl = new sinarekDataSetTableAdapters.logdetailTableAdapter())
{
foreach (GridViewRowInfo item in radGridView1.Rows)
{
if (item.Cells["detailid"].Value != null)
{
//Update
tbl.UpdateItem(int.Parse(item.Cells["productid"].Value.ToString())
, int.Parse(item.Cells["custtypeid"].Value.ToString())
, custtypetoid
, ""
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, NBConfig.ValidUserName
, long.Parse(item.Cells["detailid"].Value.ToString()));
}
else
{
//Insert
tbl.pInsertLogDetail(int.Parse(logid_.ToString())
, int.Parse(item.Cells["productid"].Value.ToString())
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, custtypetoid
, int.Parse(item.Cells["custtypeid"].Value.ToString())
, 1
, NBConfig.ValidUserName);
}
}
}
helper.NotifMessage("SJ sudah tersimpan!");
}
