Beispiel #1
0
        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();
            }
        }