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();
}
}
