private void PrintPreview(bool Privew) { crp = new rptMedicineStatus(); if (all == false) { if (this.cbxLabTest.SelectedItem != null) { LabTest lt = (LabTest)this.cbxLabTest.SelectedItem; ds = new MedicineBLL().GetMedicinesData(lt, false); } } else { ds = new MedicineBLL().GetMedicinesData(new LabTest(), true); } crp.SetDataSource(ds); string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); crp.SetParameterValue("Name", BranchName); crp.SetParameterValue("Address", BranchAddress); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (Privew) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreview(bool preview, PatientRegistration pr) { string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); prt = new DsPatientRegistration.PatientRegistrationDataTable(); object[] values = { 0, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Address, pr.TokenType, pr.CashReceived, pr.Room.Name, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; prt.LoadDataRow(values, true); rptTokenReceipt crp = new rptTokenReceipt(); crp.SetDataSource((DataTable)prt); crp.SetParameterValue("Duplicate", PrintDuplicate); crp.SetParameterValue("Name", BranchName); crp.SetParameterValue("Address", BranchAddress); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (preview) { frmViewer.ShowDialog(); } else { //frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } PrintDuplicate = false; }
private void PrintPreview(bool preview) { printds = new DsPrintedInvoices(); foreach (var item in pds.PrintedInvoices) { if (item.Exclude != true) { for (int i = 1; i <= item.NoOfBoxes; i++) { item.NumberOfTotal = i; item.CVisible = !this.chkPrintCompanyDetail.Checked; object[] values = item.ItemArray; printds.PrintedInvoices.Rows.Add(values); } } } rptLabels crp = new rptLabels(); crp.SetDataSource((DataTable)printds.PrintedInvoices); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (preview) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreviewLab(bool preview, InjectionLabTest pr) { prt = new DsPatientRegistration.PatientRegistrationDataTable(); foreach (var item in pr.Tests) { object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, item.TestName + " Qty : " + (item.TimesADay * item.TotalDays), pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.ExistingTokenNo, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; prt.LoadDataRow(values, true); } rptLabTestToken crp = new rptLabTestToken(); crp.SetDataSource((DataTable)prt); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); crp.SetParameterValue("Duplicate", PrintDuplicate); crp.SetParameterValue("Name", BranchName); crp.SetParameterValue("Address", BranchAddress); if (preview) { frmViewer.ShowDialog(); } else { //frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } PrintDuplicate = false; }
private void PrintPreviewLabandInj(bool preview, InjectionLabTest pr) { prt = new DsPatientRegistration.PatientRegistrationDataTable(); foreach (var item in pr.Tests) { //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Mobile, item.TestName + " Qty : " + item.TimesADay + "*" + item.TotalDays + "=" + (item.TimesADay * item.TotalDays) + " " + item.TimesADayUrdu, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.ExistingTokenNo, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, pr.CashReceivedByUser }; ------- Asif -- 02-04-19 //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Mobile, item.TestName + " " + item.TimesADayNumber, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.ExistingTokenNo, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, pr.CashReceivedByUser }; ------- Asif -- 08-04-19 //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.ExistingTokenNo, item.TestName + " \n" + item.TimesADayNumber, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.Room.Name, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, pr.CashReceivedByUser, pr.TokenBy }; ------- Asif -- 20-04-19 //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName + ' ' + pr.Patient.LastName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Age, pr.ExistingTokenNo, item.TestName + " (" + (item.TimesADay * item.TotalDays) + ")\n" + item.TimesADayUrdu, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.Room.Name + '-' + pr.Room.LabelName, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, pr.CashReceivedByUser, pr.TokenBy }; ------- Asif -- 01-06-19 object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName + ' ' + pr.Patient.LastName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Age, pr.ExistingTokenNo, item.TestName + " (" + (item.TimesADay * item.TotalDays) + ")\n" + item.TimesADayUrdu, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.Room.Name + '-' + pr.Room.LabelName, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, item.TotalDays, pr.TokenBy }; prt.LoadDataRow(values, true); } foreach (var item in pr.Injections) { //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Mobile, item.TestName + " Qty : " + item.TimesADay + "*" + item.TotalDays + "=" + (item.TimesADay * item.TotalDays) + " " + item.TimesADayUrdu, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.ExistingTokenNo, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; ------- Asif -- 02-04-19 //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Mobile, item.TestName + " " + item.TimesADayNumber, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.ExistingTokenNo, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; ------- Asif -- 08-04-19 //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.ExistingTokenNo, item.TestName + " \n" + item.TimesADayNumber, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.Room.Name, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, pr.TokenBy }; ------- Asif -- 20-04-19 //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName + ' ' + pr.Patient.LastName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Age, pr.ExistingTokenNo, item.TestName + " (" + (item.TimesADay * item.TotalDays) + ")\n" + item.TimesADayUrdu, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.Room.Name + '-' + pr.Room.LabelName, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, pr.TokenBy }; ------- Asif -- 01-06-19 object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName + ' ' + pr.Patient.LastName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Age, pr.ExistingTokenNo, item.TestName + " (" + (item.TimesADay * item.TotalDays) + ")\n" + item.TimesADayUrdu, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.Room.Name + '-' + pr.Room.LabelName, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, item.TotalDays, pr.TokenBy }; prt.LoadDataRow(values, true); } foreach (var item in pr.AssignedLabTest) { //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Mobile, item.TestName + " Qty : " + item.TimesADay + "*" + item.TotalDays + "=" + (item.TimesADay * item.TotalDays) + " " + item.TimesADayUrdu, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.ExistingTokenNo, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; ------- Asif -- 02-04-19 //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Mobile, item.TestName + " " + item.TimesADayNumber, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.ExistingTokenNo, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; ------- Asif -- 11-04-19 //object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName + ' ' + pr.Patient.LastName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Age, pr.ExistingTokenNo, item.TestName, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.Room.Name + '-' + pr.Room.LabelName, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, pr.CashReceivedByUser, pr.TokenBy }; ------- Asif -- 01-06-19 object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName + ' ' + pr.Patient.LastName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Age, pr.ExistingTokenNo, item.TestName, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.Room.Name + '-' + pr.Room.LabelName, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, item.TotalDays, pr.TokenBy }; prt.LoadDataRow(values, true); } rptLabTestToken crp = new rptLabTestToken(); crp.SetDataSource((DataTable)prt); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); string CompNo = ConfigurationManager.AppSettings["ComplaintNo"].ToString(); crp.SetParameterValue("Duplicate", PrintDuplicate); crp.SetParameterValue("Name", BranchName); crp.SetParameterValue("Address", BranchAddress); crp.SetParameterValue("CashRecievedByUser", pr.CashReceivedByUser); crp.SetParameterValue("ComplaintNo", "Complaint #: " + CompNo); if (preview) { frmViewer.ShowDialog(); } else { //frmViewer.crystalReportViewer1.RefreshReport(); crp.PrintToPrinter(1, false, 0, 0); //// -------- Asif -- 02-06-19 ----- Print Without Showing Print Dialog (Disallow Multiple Copies) //frmViewer.crystalReportViewer1.PrintReport(); //// -------- Asif -- 02-06-19 } PrintDuplicate = false; }
private void LoadReport() { // new QuriesBLL().UpdateQueries(); Just4LoadDataSet set = new Just4LoadDataSet(); FrmReportViewer viewer = new FrmReportViewer(); //rptJust4Load load = new rptJust4Load(); //load.SetDataSource(set); //viewer.crystalReportViewer1.ReportSource = load; //set.Dispose(); //viewer.Dispose(); //load.Dispose(); }
private void PrintPreview(bool Privew) { DSIssueBill.DTIssueBillDataTable ds = new LabTestBLL().PrintRecMedBill(rm); crp.SetDataSource((DataTable)ds); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (Privew) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreview(bool Privew) { DSIssueBill.DTIssueBillDataTable ds = new InjectionLabTestBLL().PrintIssueMedBill(r, rbRetail.Checked, rbPurchase.Checked); crp.SetDataSource((DataTable)ds); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (Privew) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreviewInjection(bool preview, InjectionLabTest pr) { string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); string CompNo = ConfigurationManager.AppSettings["ComplaintNo"].ToString(); prt = new DsPatientRegistration.PatientRegistrationDataTable(); if (pr.Injections.Count == 0) { object[] values = { 0, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName + ' ' + pr.Patient.LastName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Age, pr.Patient.Mobile, "", pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.ExistingTokenNo, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; prt.LoadDataRow(values, true); } else { foreach (LabTest item in pr.Injections) { object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName + ' ' + pr.Patient.LastName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Age, pr.Patient.Mobile, item.TestName, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, this.txtExistingToken.Text, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; prt.LoadDataRow(values, true); } } rptInectionToken crp = new rptInectionToken(); crp.SetDataSource((DataTable)prt); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; crp.SetParameterValue("Duplicate", PrintDuplicate); crp.SetParameterValue("Name", BranchName); crp.SetParameterValue("Address", BranchAddress); crp.SetParameterValue("ComplaintNo", "Complaint #: " + CompNo); if (preview) { frmViewer.ShowDialog(); } else { //frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } PrintDuplicate = false; }
private void PrintPreview(bool preview, PatientRegistration pr) { prt = new DsPatientRegistration.PatientRegistrationDataTable(); object[] values = { 0, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Address, pr.TokenType, pr.CashReceived, pr.Room.Name, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; prt.LoadDataRow(values, true); rptTokenReceipt crp = new rptTokenReceipt(); crp.SetDataSource((DataTable)prt); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (preview) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreviewInjection(bool preview, InjectionLabTest pr) { prt = new DsPatientRegistration.PatientRegistrationDataTable(); object[] values = { 0, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Address, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, this.txtExistingToken.Text, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; prt.LoadDataRow(values, true); rptInectionToken crp = new rptInectionToken(); crp.SetDataSource((DataTable)prt); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (preview) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreview(bool preview, PatientAdmission pa) { string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); DsPatientRegistration.PatientRegistrationDataTable prt = new DsPatientRegistration.PatientRegistrationDataTable(); PatientRegistration pr = new PatientRegistration(); pr = pa.PatientRegistration; pr.TokenBy = IsLoginUser; object[] values = { 0, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Address, pr.TokenType, pr.CashReceived, pr.Room.Name, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, 0, pr.TokenBy.UserName }; prt.LoadDataRow(values, true); DSPatientAdmission.PatientAdmissionDataTable pat = new DSPatientAdmission.PatientAdmissionDataTable(); object[] PAvalues = { pa.Pluse, pa.BP, pa.RR, pa.AdmissoinDate, pa.DiffDiag, pa.provDiag }; pat.LoadDataRow(PAvalues, true); rptPatientClinicalRoport crp = new rptPatientClinicalRoport(); // crp.SetDataSource((DataTable)prt); crp.Database.Tables[0].SetDataSource((DataTable)pat); crp.Database.Tables[1].SetDataSource((DataTable)prt); crp.SetDataSource((DataTable)pat); crp.SetParameterValue("Name", BranchName); crp.SetParameterValue("Address", BranchAddress); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (true) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreviewLab(bool preview, InjectionLabTest pr) { prt = new DsPatientRegistration.PatientRegistrationDataTable(); foreach (var item in pr.Tests) { object[] values = { item.LabTestId, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, item.TestName, pr.IsInjectionToken ? "Injection" : "Lab Test", pr.CashReceived, pr.ExistingTokenNo, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; prt.LoadDataRow(values, true); } rptLabTestToken crp = new rptLabTestToken(); crp.SetDataSource((DataTable)prt); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (preview) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreview(bool preview, PatientRegistration pr) { string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); string CompNo = ConfigurationManager.AppSettings["ComplaintNo"].ToString(); prt = new DsPatientRegistration.PatientRegistrationDataTable();///////// Token By Name Added pr.TokenBy = IsLoginUser; //object[] values = { 0, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Mobile, pr.Patient.Address, pr.TokenType, pr.CashReceived, pr.Room.Name, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, 0, pr.TokenBy.UserName }; object[] values = { 0, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName + ' ' + pr.Patient.LastName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Age, pr.Patient.Mobile, pr.Patient.Address, pr.TokenType, pr.CashReceived, pr.Room.Name + '-' + pr.Room.LabelName, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, 0, pr.TokenBy.UserName }; prt.LoadDataRow(values, true); rptTokenReceipt crp = new rptTokenReceipt(); crp.SetDataSource((DataTable)prt); crp.SetParameterValue("Duplicate", PrintDuplicate); crp.SetParameterValue("Name", BranchName); crp.SetParameterValue("Address", BranchAddress); crp.SetParameterValue("ComplaintNo", "Complaint #: " + CompNo); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (preview) { frmViewer.ShowDialog(); } else { //frmViewer.crystalReportViewer1.RefreshReport(); crp.PrintToPrinter(1, false, 0, 0); //// -------- Asif -- 02-06-19 ----- Print Without Showing Print Dialog (Disallow Multiple Copies) //frmViewer.crystalReportViewer1.PrintReport(); //// -------- Asif -- 02-06-19 } //var dialog = new PrintDialog(); //Nullable<bool> print = dialog.ShowDialog() == System.Windows.Forms.DialogResult.Yes ? true : false; ; //// if (print.HasValue && print.Value) //{ // var rd = new ReportDocument(); // //rd.ReportClientDocument // rd.Load(Application.StartupPath + "\\Reports\\rptTokenReceipt.rpt"); // rd.SetParameterValue("Duplicate", PrintDuplicate); // rd.SetParameterValue("Name", BranchName); // rd.SetParameterValue("Address", BranchAddress); // rd.SetDataSource((DataTable)prt); // dialog.PrinterSettings.Copies = 1; // rd.PrintOptions.PrinterName = dialog.PrinterSettings.PrinterName; // MessageBox.Show("Printing"); // //rd.PrintToPrinter(dialog.PrinterSettings.PrinterName, false, 0, 0); // try // { // rd.PrintToPrinter(1, true, 0, 1); // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } // try // { // rd.PrintToPrinter(1, true, 0, 0); // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } // // rd.PrintToPrinter(1, false, 0, 0); // { // // System.Drawing.Printing.PrintDocument pDoc = new PrintDocument(); // CrystalDecisions.Shared.PrintLayoutSettings PrintLayout = new CrystalDecisions.Shared.PrintLayoutSettings(); // System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings(); // printerSettings.PrinterName = dialog.PrinterSettings.PrinterName; // System.Drawing.Printing.PageSettings pSettings = new System.Drawing.Printing.PageSettings(printerSettings); // rd.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true; // rd.PrintOptions.PrinterDuplex = CrystalDecisions.Shared.PrinterDuplex.Simplex; // // OnMessageLogged(TraceEventType.Information, "PrePrint " + crReportDocument.PrintOptions.PrinterName); // System.Security.Principal.WindowsImpersonationContext ctx = System.Security.Principal.WindowsIdentity.Impersonate(IntPtr.Zero); // try // { // rd.PrintToPrinter(printerSettings, pSettings, false, PrintLayout); // // OnMessageLogged(TraceEventType.Information, "Printed " + pq.printerName); // } // catch (Exception eprint) // { // MessageBox.Show("Error" + eprint.Message); // //OnMessageLogged(TraceEventType.Information, "****Failed to Print** to printer " + pq.printerName + " Exception " + eprint.ToString()); // } // finally // { // // Resume impersonation // ctx.Undo(); // // OnMessageLogged(TraceEventType.Information, "Success Printing to " + pq.printerName); // } // } //} PrintDuplicate = false; }
private void PrintPreview(bool preview) { DsTokenSummary printds = new DsTokenSummary(); DsTokenSummary.PatientRegistrationDataTable resultTalbe = new DsTokenSummary.PatientRegistrationDataTable(); rptAllTokenReceipt crp = new rptAllTokenReceipt(); string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); printds = new TokenSummaryBLL().GetTokenSummary(dtpFrom.Value.Date, dtpTo.Value.Date, rbAll.Checked, rbInjection.Checked, rbCheckup.Checked, rbLab.Checked, rbMedicine.Checked, cb50.Checked); string tokenType = ""; string tokenRange = ""; if (rbAll.Checked == true) { tokenType = "All tokens"; } else if (rbCheckup.Checked == true) { tokenType = "Checkup only"; } else if (rbInjection.Checked == true) { tokenType = "Injection only"; } else if (rbLab.Checked == true) { tokenType = "Lab test only"; } else if (rbMedicine.Checked == true) { tokenType = "Medicines"; } if (rbRange.Checked == true) { try { int to = 0, from = 0; bool r; if (txtToToken.Text.Trim() != string.Empty) { r = int.TryParse(txtToToken.Text.Trim(), out to); } if (txtFromToken.Text.Trim() != string.Empty) { r = int.TryParse(txtFromToken.Text.Trim(), out from); } if (to == 0) { MessageBox.Show("Please Enter the Valid Token Number"); this.txtToToken.Focus(); return; } if (from == 0) { MessageBox.Show("Please Enter the Valid Token Number"); this.txtFromToken.Focus(); return; } string filterExpression = "TokenNumber >= " + from.ToString() + " and TokenNumber <= " + to.ToString(); DataRow[] TokenRows = ((DataTable)printds.PatientRegistration).Select(filterExpression); foreach (DataRow row in TokenRows) { resultTalbe.ImportRow(row); } tokenRange = from.ToString() + " to " + to.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Token Range Invalid"); return; } } else { resultTalbe = printds.PatientRegistration; tokenRange = "All Tokens"; } crp.SetDataSource((DataTable)resultTalbe); crp.SetParameterValue("TokenType", tokenType); crp.SetParameterValue("fromDate", dtpFrom.Value.Date); crp.SetParameterValue("toDate", dtpTo.Value.Date); crp.SetParameterValue("TokenRange", tokenRange); crp.SetParameterValue("BranchName", BranchName); crp.SetParameterValue("BranchAddress", BranchAddress); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (preview) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreview(bool preview) { DsTokenSummary printds = new DsTokenSummary(); DsTokenSummary.PatientRegistrationDataTable resultTalbe = new DsTokenSummary.PatientRegistrationDataTable(); rptAllTokenReceipt crp = new rptAllTokenReceipt(); string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); string shifttime = ""; int? uNO = 0; string UserName = "******"; if (chbUsers.Checked) { uNO = Convert.ToInt16(cbxUser.SelectedValue.ToString()); List <User> selectedusers = this.users.Where(u => u.Userno == uNO).ToList <User>(); foreach (var item in selectedusers) { UserName = item.UserName; } //UserBLL userBLL = new UserBLL(); //List<User> users = this.userBLL.GetUsers().Where(u => u.Userno == uNO).ToList<User>(); } if (cbxShifts.SelectedIndex == 0 || cbxShifts.SelectedIndex == -1) { printds = new TokenSummaryBLL().GetTokenSummary(dtpFrom.Value.Date, dtpTo.Value.Date, rbAll.Checked, rbInjection.Checked, rbCheckup.Checked, rbLab.Checked, rbMedicine.Checked, cb50.Checked, uNO); } else { printds = new TokenSummaryBLL().GetTokenSummary(dtpFrom.Value.Date, dtpTo.Value.Date, rbAll.Checked, rbInjection.Checked, rbCheckup.Checked, rbLab.Checked, rbMedicine.Checked, cb50.Checked, (Shift)cbxShifts.SelectedItem, uNO); Shift shift = (Shift)cbxShifts.SelectedItem; shift = new BLL.ShiftsBLL().GetShiftStartEndTime(shift, this.dtpFrom.Value.Date); shifttime = shift.ChangeDateTime.ToString("hh:mm:ss"); } string tokenType = ""; string tokenRange = ""; if (rbAll.Checked == true) { tokenType = "All tokens"; } else if (rbCheckup.Checked == true) { tokenType = "Checkup only"; } else if (rbInjection.Checked == true) { tokenType = "Injection only"; } else if (rbLab.Checked == true) { tokenType = "Lab test only"; } else if (rbMedicine.Checked == true) { tokenType = "Medicines"; } tokenType += " - " + cbxShifts.Text + ' ' + shifttime; string filterExpression; if (rbRange.Checked == true) { try { int to = 0, from = 0; bool r; if (txtToToken.Text.Trim() != string.Empty) { r = int.TryParse(txtToToken.Text.Trim(), out to); } if (txtFromToken.Text.Trim() != string.Empty) { r = int.TryParse(txtFromToken.Text.Trim(), out from); } if (to == 0) { MessageBox.Show("Please Enter the Valid Token Number"); this.txtToToken.Focus(); return; } if (from == 0) { MessageBox.Show("Please Enter the Valid Token Number"); this.txtFromToken.Focus(); return; } filterExpression = "TokenNumber >= " + from.ToString() + " and TokenNumber <= " + to.ToString(); DataRow[] TokenRows = ((DataTable)printds.PatientRegistration).Select(filterExpression); foreach (DataRow row in TokenRows) { resultTalbe.ImportRow(row); } tokenRange = from.ToString() + " to " + to.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Token Range Invalid"); return; } } else { resultTalbe = printds.PatientRegistration; tokenRange = "All Tokens"; } //if (rbCheckup.Checked) //{ // if (chbPoor.Checked) // { // if (String.IsNullOrEmpty(filterExpression)) // } //} crp.SetDataSource((DataTable)resultTalbe); crp.SetParameterValue("TokenType", tokenType); crp.SetParameterValue("fromDate", dtpFrom.Value.Date); crp.SetParameterValue("toDate", dtpTo.Value.Date); crp.SetParameterValue("TokenRange", tokenRange); crp.SetParameterValue("BranchName", BranchName); crp.SetParameterValue("BranchAddress", BranchAddress); crp.SetParameterValue("UserName", UserName); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; //frmViewer.crystalReportViewer1.SelectionFormula = "" if (preview) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreview(bool preview) { DSTTokenSummryUserWise printds = new DSTTokenSummryUserWise(); // DsTokenSummary.PatientRegistrationDataTable resultTalbe = new DsTokenSummary.PatientRegistrationDataTable(); DSTTokenSummryUserWise.TokenSummeryUserWiseDataTable resultTalbe = new DSTTokenSummryUserWise.TokenSummeryUserWiseDataTable(); rptTokensUserWise crp = new rptTokensUserWise(); string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); // string shifttime=""; ///////// --------------------------- Asif - 04-05-19 - Disable if & send time flag as parameter printds = new TokenSummaryBLL().GetTokenSummaryUserWise(dtpFrom.Value, dtpTo.Value, chkSelectTime.Checked); //if (chkSelectTime.Checked==true) //{ // printds = new TokenSummaryBLL().GetTokenSummaryUserWise(dtpFrom.Value, dtpTo.Value); //} //else //{ // printds = new TokenSummaryBLL().GetTokenSummaryUserWise(dtpFrom.Value.Date, dtpTo.Value.Date); //} ///////// --------------------------- Asif - 04-05-19 - Disable // printds = new TokenSummaryBLL().GetTokenSummaryUserWise(dtpFrom.Value, dtpTo.Value); //if (cbxShifts.SelectedIndex == 0 || cbxShifts.SelectedIndex == -1) // printds = new TokenSummaryBLL().GetTokenSummary(dtpFrom.Value.Date, dtpTo.Value.Date, rbAll.Checked, rbInjection.Checked, rbCheckup.Checked, rbLab.Checked, rbMedicine.Checked, cb50.Checked); //else //{ // Shift shift = (Shift)cbxShifts.SelectedItem; // shift = new BLL.ShiftsBLL().GetShiftStartEndTime(shift,this.dtpFrom.Value.Date); // shifttime = shift.ChangeDateTime.ToString("hh:mm:ss"); //} //string tokenType = ""; //string tokenRange = ""; //if (rbAll.Checked == true) // tokenType = "All tokens"; //else if (rbCheckup.Checked == true) // tokenType = "Checkup only"; //else if (rbInjection.Checked == true) // tokenType = "Injection only"; //else if (rbLab.Checked == true) // tokenType = "Lab test only"; //else if (rbMedicine.Checked == true) // tokenType = "Medicines"; //tokenType += " - " + cbxShifts.Text+shifttime; //if (rbRange.Checked == true) //{ // try // { // int to = 0, from = 0; // bool r; // if (txtToToken.Text.Trim() != string.Empty) // r = int.TryParse(txtToToken.Text.Trim(), out to); // if (txtFromToken.Text.Trim() != string.Empty) // r = int.TryParse(txtFromToken.Text.Trim(), out from); // if (to == 0) // { // MessageBox.Show("Please Enter the Valid Token Number"); // this.txtToToken.Focus(); // return; // } // if (from == 0) // { // MessageBox.Show("Please Enter the Valid Token Number"); // this.txtFromToken.Focus(); // return; // } // string filterExpression = "TokenNumber >= " + from.ToString() + " and TokenNumber <= " + to.ToString(); // DataRow[] TokenRows = ((DataTable)printds.PatientRegistration).Select(filterExpression); // foreach (DataRow row in TokenRows) // { // resultTalbe.ImportRow(row); // } // tokenRange = from.ToString() + " to " + to.ToString(); // } // catch (Exception ex) // { // MessageBox.Show(ex.Message, "Token Range Invalid"); // return; // } //} //else //{ // resultTalbe = printds.PatientRegistration; // tokenRange = "All Tokens"; //} resultTalbe = printds.TokenSummeryUserWise; crp.SetDataSource((DataTable)resultTalbe); // crp.SetParameterValue("TokenType", tokenType); if (chkSelectTime.Checked == true) { crp.SetParameterValue("fromDate", dtpFrom.Value.ToString("dd/MM/yyyy HH:mm")); crp.SetParameterValue("toDate", dtpTo.Value.ToString("dd/MM/yyyy HH:mm")); } else { crp.SetParameterValue("fromDate", dtpFrom.Value.ToString("dd/MM/yyyy")); crp.SetParameterValue("toDate", dtpTo.Value.ToString("dd/MM/yyyy")); } //crp.SetParameterValue("TokenRange", tokenRange); crp.SetParameterValue("BranchName", BranchName); crp.SetParameterValue("BranchAddress", BranchAddress); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (preview) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }