private void InsertOtherTotal(string custType_, int Quantity) { int K16, BTL; string baseid; sinarekDataSet.productbaseDataTable dt = new sinarekDataSet.productbaseDataTable(); using (sinarekDataSetTableAdapters.productbaseTableAdapter tbl = new sinarekDataSetTableAdapters.productbaseTableAdapter()) { tbl.Fill(dt); } using (sinarekDataSetTableAdapters.producttotalTableAdapter tbl = new sinarekDataSetTableAdapters.producttotalTableAdapter()) { switch (custType_.ToLower()) { case "jadi": baseid = dt.Select("productshort = 'BK'and unitshort = 'K100'")[0]["Baseid"].ToString(); K16 = Math.DivRem((Quantity * 100), 16, out BTL); tbl.InsertProductTotal(dtpTanggal.Value , "", "JADI KARUNG", "", int.Parse(baseid), Quantity, "", NBConfig.ValidUserName); baseid = dt.Select("productshort = 'BK' and unitshort = 'K16'")[0]["Baseid"].ToString(); tbl.InsertProductTotal(dtpTanggal.Value , "", "JADI KARUNG", "", int.Parse(baseid), -1 * K16, "", NBConfig.ValidUserName); baseid = dt.Select("productshort = 'BK' and unitshort = 'BTL'")[0]["Baseid"].ToString(); tbl.InsertProductTotal(dtpTanggal.Value , "", "JADI KARUNG", "", int.Parse(baseid), -1 * BTL, "", NBConfig.ValidUserName); break; case "rusak": K16 = Math.DivRem(Quantity, 16, out BTL); baseid = dt.Select("productshort = 'BK' and unitshort = 'K16'")[0]["Baseid"].ToString(); tbl.InsertProductTotal(dtpTanggal.Value , "", "BARANG RUSAK", "", int.Parse(baseid), K16, "", NBConfig.ValidUserName); baseid = dt.Select("productshort = 'BK' and unitshort = 'BTL'")[0]["Baseid"].ToString(); tbl.InsertProductTotal(dtpTanggal.Value , "", "BARANG RUSAK", "", int.Parse(baseid), BTL, "", NBConfig.ValidUserName); break; } } }
private void SaveNewItem() { if (validateFields()) { using (sinarekDataSetTableAdapters.producttotalTableAdapter tbl = new sinarekDataSetTableAdapters.producttotalTableAdapter()) { try { tbl.InsertProductTotal(dtpTanggal.Value , "" , "AWAL" , "" , int.Parse(rddProduct.SelectedValue.ToString()) , decimal.Parse(txtSisa.Value.ToString()) , "" , NBConfig.ValidUserName); } catch (Exception ex) { MessageBox.Show(rddProduct.Text + " sudah terinput.", "SMS - Error Notification"); } } } }
private void btnPrint_Click(object sender, EventArgs e) { //TODO: After print update total in db //If total existed then delete and insert new one DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification" , MessageBoxButtons.OKCancel , RadMessageIcon.Question); if (res == System.Windows.Forms.DialogResult.OK) { PrinterSettings printerSettings; ReportProcessor reportProcessor; rptBotolKotor rpt = new rptBotolKotor(); rpt.ReportParameters["user"].Value = NBConfig.ValidUserName; rpt.ReportParameters["tanggal"].Value = dtpTanggal.Value; //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); helper.PrintLog(this.GetType().Name, rpt.Name, this.Text + ":tanggal-" + dtpTanggal.Value.ToString()); } catch (Exception ex) { helper.ErrorMessage(ex.Message); } sinarekDataSet.productbaseDataTable dt = new sinarekDataSet.productbaseDataTable(); using (sinarekDataSetTableAdapters.productbaseTableAdapter tbl = new sinarekDataSetTableAdapters.productbaseTableAdapter()) { tbl.Fill(dt); } using (sinarekDataSetTableAdapters.producttotalTableAdapter tbl = new sinarekDataSetTableAdapters.producttotalTableAdapter()) { foreach (GridViewSummaryItem item in radGridView1.SummaryRowsBottom[0]) { if (item.Name != "NoSJ" && item.Name != "Total") { string baseid = dt.Select("productshort = 'BK' and unitshort = '" + item.Name + "'")[0]["baseid"].ToString(); string obj = item.Evaluate(radGridView1.MasterTemplate).ToString(); tbl.InsertProductTotal(dtpTanggal.Value , "" , "AKHIR" , "" , int.Parse(baseid) , decimal.Parse(obj) , "", NBConfig.ValidUserName); } } } } }