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!"); }