private void btnShowFullReport_Click(object sender, EventArgs e) { try { DataAccess.RedaV1Entities db = ModuleClass.GetConnection();//= new DataAccess.RedaV1Entities(ModuleClass.Connect()); int invoiceID = 123; var currentRow = db.vw_SaleReport.Where(s => s.ID == invoiceID).SingleOrDefault(); //(DataAccess.vw_SaleReport)gridViewSaleInvoice.GetFocusedRow(); SaleAllRpt rpt = new SaleAllRpt(Convert.ToDecimal(currentRow.Discount), Convert.ToDecimal(currentRow.Total), currentRow.ID.ToString(), currentRow.UserName.ToString()); var list = from s in db.vw_Sale2 where s.SaleInvoiceID == invoiceID select s; rpt.DataSource = list.ToList(); try { // string InvoicePrinter = System.Configuration.ConfigurationManager.AppSettings["InvoicePrinter"]; ReportPrintTool tool = new ReportPrintTool(rpt); tool.ShowPreview(); } catch (Exception ex) { ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null); } } catch (Exception ex) { ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null); } }
private void xrTableCell14_PreviewDoubleClick(object sender, PreviewMouseEventArgs e) { DataAccess.RedaV1Entities db = WinForm.ModuleClass.GetConnection();//= new DataAccess.RedaV1Entities(ModuleClass.Connect()); int invoiceID = Convert.ToInt32(e.Brick.Text); var currentRow = db.vw_SaleReport.Where(s => s.ID == invoiceID).SingleOrDefault(); //(DataAccess.vw_SaleReport)gridViewSaleInvoice.GetFocusedRow(); SaleAllRpt rpt = new SaleAllRpt(Convert.ToDecimal(currentRow.Discount), Convert.ToDecimal(currentRow.Total), currentRow.ID.ToString(), currentRow.UserName.ToString()); var list = from s in db.vw_Sale2 where s.SaleInvoiceID == invoiceID select s; rpt.DataSource = list.ToList(); try { ReportPrintTool tool = new ReportPrintTool(rpt); tool.ShowPreview(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }