private void btnPrint_Click(object sender, EventArgs e) { Cursor = Cursors.AppStarting; Form fx = new frmReportViewer1(ReportHelper1.LoadPurchaseOrderForm(c1TextBox1.Text)); fx.WindowState = FormWindowState.Maximized; fx.ShowDialog(); Cursor = Cursors.Default; }
private void btnPrint_Click(object sender, EventArgs e) { Cursor = Cursors.AppStarting; Form fx = new frmReportViewer1(ReportHelper1.LoadPurchaseInvoiceList((DateTime)dtpBegin.Value, ((DateTime)dtpEnd.Value).AddDays(1))); fx.WindowState = FormWindowState.Maximized; fx.ShowDialog(); Cursor = Cursors.Default; }
private void btnPrint_Click(object sender, EventArgs e) { Cursor = Cursors.AppStarting; Form fx = new frmReportViewer1(ReportHelper1.LoadInventoryStatus()); fx.WindowState = FormWindowState.Maximized; fx.ShowDialog(); Cursor = Cursors.Default; }
private void btnPrint_Click(object sender, EventArgs e) { Cursor = Cursors.AppStarting; Form fx = new frmReportViewer1(ReportHelper1.LoadPurchaseOrderList((DateTime)dtpBegin.Value, ((DateTime)dtpEnd.Value).AddDays(1))); fx.WindowState = FormWindowState.Maximized; fx.ShowDialog(); Cursor = Cursors.Default; /* * old print using c1report * ************************** * Cursor = Cursors.AppStarting; * * // hide unecessary column * this._grid.Caption = ""; * * // page setting * C1.Win.C1TrueDBGrid.Style headerstyle = new C1.Win.C1TrueDBGrid.Style(); * headerstyle.Font = new Font("Tahome", 18, FontStyle.Bold); * headerstyle.HorizontalAlignment = C1.Win.C1TrueDBGrid.AlignHorzEnum.Center; * this._grid.PrintInfo.PageHeader = this.Text; * this._grid.PrintInfo.PageHeaderStyle = headerstyle; * this._grid.PrintInfo.PageSettings.Landscape = true; * this._grid.PrintInfo.PageSettings.Margins.Top = 30; * this._grid.PrintInfo.PageSettings.Margins.Left = 30; * this._grid.PrintInfo.PageSettings.Margins.Bottom = 30; * this._grid.PrintInfo.PageSettings.Margins.Right = 30; * this._grid.PreviewInfo.Size = new System.Drawing.Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); * * // Column headers will be on every page. * this._grid.PrintInfo.RepeatColumnHeaders = true; * * // Display page numbers (centered). * this._grid.PrintInfo.PageFooter = @"Page: \p\t"; * this._grid.PrintInfo.PageFooter += Reports.ReportHelper1.GenerateFooter(); * * // Invoke print preview. * this._grid.PrintInfo.UseGridColors = false; * this._grid.PrintInfo.PrintPreview(); * * // unhide unecessary column * this._grid.Caption = this.Text; * * Cursor = Cursors.Default; * */ }
private void btnSave_Click(object sender, EventArgs e) { // Validate all required field(s) if (!ValidateUserInput()) { return; } // if you get here, it means that all user input has been validated Cursor = Cursors.AppStarting; try { // End editing BindingContext[dsCore1, "Orders"].EndCurrentEdit(); BindingContext[dsCore1, "OrderDetails"].EndCurrentEdit(); // There are changes that need to be made, so attempt to update the datasource by // calling the update method and passing the dataset and any parameters. if (txMode == DataEntryModes.Add) { // copy master record dari main dataset // harus dilakukan krena main dataset sebelumnya sudah // AcceptChanges padahal belum diupdate ke database dsChanges = new dsCore(); dsChanges.EnforceConstraints = false; dsChanges.Orders.Rows.Add(((DataRowView)this.BindingContext[dsCore1, "Orders"].Current).Row.ItemArray); // copy juga detail record dari main dataset for (int i = 0; i < dsCore1.OrderDetails.Rows.Count; i++) { dsChanges.OrderDetails.Rows.Add(dsCore1.OrderDetails.Rows[i].ItemArray); } // persist changes to database daOrders1.Update(dsChanges.Orders); daOrderDetails1.Update(dsChanges.OrderDetails); // only generate invoice GenerateInvoice(dsChanges); // generate payment record for cash payment if (radioButton1.Checked || Convert.ToDouble(c1NumericEdit1.Value) > 0) { GeneratePayment(dsChanges); } // inform user, successful DialogResult dr = RibbonMessageBox.Show("Data SUCCESFULLY saved to database\n" + (InvoiceID < 0 ? "" : "New Invoice Voucher [" + InvoiceNum + "] created automatically\n") + (PaymentID < 0 ? "" : "New Payment Voucher [" + PaymentNum + "] created automatically\n") + "Do you want to print this document?\n", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Question); // ask user for voucher print if (dr == DialogResult.Yes) { Cursor = Cursors.AppStarting; Form fx = new frmReportViewer1(ReportHelper1.LoadPurchaseOrderForm(c1TextBox1.Text)); fx.WindowState = FormWindowState.Maximized; fx.ShowDialog(); Cursor = Cursors.Default; } } else { // persist changes to database daOrders1.Update(dsCore1.Orders); daOrderDetails1.Update(dsCore1.OrderDetails); // inform user for successful update RibbonMessageBox.Show("Changes SUCCESFULLY saved to database", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } // success, close form btnClose.PerformClick(); } catch (SqlException ex) { // textfile logging Logger.ErrorRoutine(ex); // screen logging if (ex.Number != 2601) { RibbonMessageBox.Show("ERROR Saving Data: \n" + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { RibbonMessageBox.Show("ERROR Saving Data:\n" + "Document number [" + c1TextBox1.Text + "]already existed in database\n" + "Please change this document number and try saving again.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { // textfile logging Logger.ErrorRoutine(ex); // screen logging RibbonMessageBox.Show("ERROR Saving Data: \n" + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } Cursor = Cursors.Default; }
private void btnSave_Click(object sender, EventArgs e) { // Validate all required field(s) if (!ValidateUserInput()) { return; } // if you get here, it means that all user input has been validated Cursor = Cursors.AppStarting; try { // End editing BindingContext[dsCore1, "Orders"].EndCurrentEdit(); BindingContext[dsCore1, "OrderDetails"].EndCurrentEdit(); // Validaton Check order detail item -> by K if (dsCore1.OrderDetails.Rows.Count == 0) { RibbonMessageBox.Show("No item inventory in this order\n" + "Please input item at least one item\n", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } // End Validation -> by K // There are changes that need to be made, so attempt to update the datasource by // calling the update method and passing the dataset and any parameters. if (txMode == DataEntryModes.Add) { // copy master record dari main dataset // harus dilakukan krena main dataset sebelumnya sudah // AcceptChanges padahal belum diupdate ke database dsChanges = new dsCore(); dsChanges.EnforceConstraints = false; // Possible NULL value dataRowView .:By K:. var dataRowView = (DataRowView)BindingContext[dsCore1, "Orders"].Current; if (dataRowView != null) { dsChanges.Orders.Rows.Add(dataRowView.Row.ItemArray); } // copy juga detail record dari main dataset for (var i = 0; i < dsCore1.OrderDetails.Rows.Count; i++) { dsChanges.OrderDetails.Rows.Add(dsCore1.OrderDetails.Rows[i].ItemArray); } // persist changes to database daOrders1.Update(dsChanges.Orders); daOrderDetails1.Update(dsChanges.OrderDetails); // inform user, successful DialogResult dr = RibbonMessageBox.Show("Data SUCCESFULLY saved to database\n" + "Do you want to print this document?\n", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Question); // ask user for voucher print if (dr == DialogResult.Yes) { Cursor = Cursors.AppStarting; Form fx = new frmReportViewer1(ReportHelper1.LoadSalesQuotationForm(c1TextBox1.Text)); fx.WindowState = FormWindowState.Maximized; fx.ShowDialog(); Cursor = Cursors.Default; } } else { // persist changes to database daOrders1.Update(dsCore1.Orders); daOrderDetails1.Update(dsCore1.OrderDetails); // inform user for successful update RibbonMessageBox.Show("Changes SUCCESFULLY saved to database", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } // success, close form btnClose.PerformClick(); } catch (SqlException ex) { // textfile logging Logger.ErrorRoutine(ex); // screen logging if (ex.Number != 2601) { RibbonMessageBox.Show("ERROR Saving Data: \n" + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { RibbonMessageBox.Show("ERROR Saving Data:\n" + "Document number [" + c1TextBox1.Text + "]already existed in database\n" + "Please change this document number and try saving again.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { // textfile logging Logger.ErrorRoutine(ex); // screen logging RibbonMessageBox.Show("ERROR Saving Data: \n" + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } Cursor = Cursors.Default; }