private void SaveNewItem()
{
int sign = 1;
if ((bool)rddProduct.Tag)
{
sign = -1;
}
//SaveItem
using (sinarekDataSetTableAdapters.logotherTableAdapter tbl = new sinarekDataSetTableAdapters.logotherTableAdapter())
{
tbl.InsertDataPenjualan(long.Parse(logid_)
, int.Parse(ujid_)
, int.Parse(lappenid_)
, dtpTanggal.Value
, txtKeterangan.Text
, 0
, -1
, dtpTanggal.Value
, (sign * decimal.Parse(txtQuantity.Text))
, int.Parse(rddProduct.SelectedValue.ToString())
, decimal.Parse(txtPrice.Text)
, int.Parse(rddKota.SelectedValue.ToString())
, ""
, txtDetail2.Text
, txtTime.Text
, NBConfig.ValidUserName);
}
}
private void DeleteLogOther(string LogDetailID)
{
try
{
using (sinarekDataSetTableAdapters.logotherTableAdapter tbl = new sinarekDataSetTableAdapters.logotherTableAdapter())
{
tbl.DeleteLogOther(int.Parse(LogDetailID));
}
}
catch (Exception ex)
{
helper.SysLog(this.GetType().Name, this.Text, "DeleteLogOther : " + ex.Message);
}
}
private void SaveNewItem()
{
string logpelid;
try
{
//SaveItem
using (sinarekDataSetTableAdapters.logpelTableAdapter tbl = new sinarekDataSetTableAdapters.logpelTableAdapter())
{
logpelid = tbl.pDataPenjPelanggan(int.Parse(rddPel.SelectedValue.ToString())
, int.Parse(logid_)
, dtpTanggal.Value
, int.Parse(salesid_)
, (chkCredit.Checked ? 1 : 0)
, NBConfig.ValidUserName).ToString();
}
if (chkKunjungan.ToggleState == Telerik.WinControls.Enumerations.ToggleState.Off)
{
using (sinarekDataSetTableAdapters.logotherTableAdapter tbl = new sinarekDataSetTableAdapters.logotherTableAdapter())
{
foreach (GridViewRowInfo item in radGridView1.Rows)
{
tbl.InsertDataPenjualan(long.Parse(logid_)
, int.Parse(logpelid)
, int.Parse(lappenid_)
, dtpTanggal.Value
, (item.Cells["keterangan"].Value == null ? "" : item.Cells["keterangan"].Value.ToString())
, 0
, short.Parse(item.Cells["statusid"].Value.ToString())
, null
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, int.Parse(item.Cells["productid"].Value.ToString())
, decimal.Parse(item.Cells["harga"].Value.ToString())
, int.Parse(item.Cells["kotaid"].Value.ToString())
, item.Cells["nota"].Value.ToString()
, ""
, ""
, NBConfig.ValidUserName);
}
}
}
}
catch (Exception ex)
{
helper.ErrorMessage("Error menyimpan data penjualan");
helper.SysLog(this.GetType().Name, this.Text, ex.Message + " : " + ex.StackTrace);
}
}
private void SaveEditItem(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;
short custtypetoid = -1
, custtypeid = -1;
int paid = 0;
DataRow[] dr = this.sinarekDataSet.custtype.Select("name = 'gudang barang'");
custtypetoid = short.Parse(dr[0]["custtypeid"].ToString());
dr = this.sinarekDataSet.custtype.Select("name = 'supplier'");
custtypeid = short.Parse(dr[0]["custtypeid"].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
, 1
, kernetid
, sopirid
, mobilid
, kotaid
, salesid
, mobil
, sopir
, keterangan
, custid
, custtypetoid
, custtypetoid
, NBConfig.ValidUserName
, StatusID, paid, 0).ToString();
}
foreach (GridViewRowInfo item in radGridView1.Rows)
{
using (sinarekDataSetTableAdapters.logotherTableAdapter tbl = new sinarekDataSetTableAdapters.logotherTableAdapter())
{
try
{
tbl.InsertLogOtherDetail(int.Parse(iLogID)
, item.Cells["keterangan"].Value.ToString()
, 0
, custtypeid
, null
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, int.Parse(item.Cells["productid"].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;
rpt.ReportParameters["custtypetoid"].Value = 18;
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("Transaksi masuk ini dapat dilihat di daftar transaksi yg belum di print.");
}
}
private void SaveEditItem(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;
short custtypetoid = -1
, custtypeid = -1;
int paid = 0;
DataRow[] dr = this.sinarekDataSet.custtype.Select("name = 'gudang barang'");
custtypetoid = short.Parse(dr[0]["custtypeid"].ToString());
dr = this.sinarekDataSet.custtype.Select("name = 'supplier'");
custtypeid = short.Parse(dr[0]["custtypeid"].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
, 1
, kernetid
, sopirid
, mobilid
, kotaid
, salesid
, mobil
, sopir
, keterangan
, custid
, custtypetoid
, custtypetoid
, NBConfig.ValidUserName
, StatusID, paid, 0).ToString();
}
foreach (GridViewRowInfo item in radGridView1.Rows)
{
using (sinarekDataSetTableAdapters.logotherTableAdapter tbl = new sinarekDataSetTableAdapters.logotherTableAdapter())
{
try
{
tbl.InsertLogOtherDetail(int.Parse(iLogID)
, item.Cells["keterangan"].Value.ToString()
, 0
, custtypeid
, null
, decimal.Parse(item.Cells["quantity"].Value.ToString())
, int.Parse(item.Cells["productid"].Value.ToString())
, decimal.Parse(item.Cells["harga"].Value.ToString())
, 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.");
}
