private void barkodYazdir()
 {
     int x = 1;
     etiketler.Clear();
     foreach (string item in listboxLabel.Items)
     {
         Etiket s = new Etiket();
         s.ID = x;
         s.Barkod = item;
         etiketler.Add(s);
         x++;
     }
     if (MessageBox.Show(string.Format("{0} adet barkod bulundu. Yazdırılacak emin misiniz ?", etiketler.Count), "Yazdırma", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
     {
         rptBarkod Rapor = new rptBarkod();
         Rapor.DataSource = etiketler;
         Rapor.PageWidth = (int)spWidth.Value;
         Rapor.PageHeight = (int)spHeight.Value;
         ReportPrintTool reportPrintTool = new ReportPrintTool(Rapor);
         reportPrintTool.ShowPreviewDialog();
     }
     else
     {
         return;
     }
 }

        private void btnPrintByCustomer_Click(object sender, EventArgs e)
        {
            CustomersBO aCustomersBO = new CustomersBO();
            Customers aCustomer = new Customers();
            aCustomer = aCustomersBO.Select_ByID(int.Parse(loeListCustomer.EditValue.ToString()));
            this.aNewPaymentEN = this.aNewPaymentEN.SlipPaymentByCustomer(aCustomer);

            try
            {
                if (this.aNewPaymentEN.Status_BookingR == 8 || this.aNewPaymentEN.Status_BookingR == 7)
                {

                    frmRpt_Payment_BookingRs afrmRpt_Payment_BookingRs = new frmRpt_Payment_BookingRs(this.aNewPaymentEN);
                    ReportPrintTool tool = new ReportPrintTool(afrmRpt_Payment_BookingRs);
                    tool.ShowPreview();
                }
                else
                {
                    frmRpt_Payment_BookingRsUnPay afrmRpt_Payment_BookingRs = new frmRpt_Payment_BookingRsUnPay(this.aNewPaymentEN);
                    ReportPrintTool tool = new ReportPrintTool(afrmRpt_Payment_BookingRs);
                    tool.ShowPreview();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("frmTsk_ChoosePrintType.btnPrint_Click\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        public void Execute()
        {
            try
            {
                if(Prizm.Main.Common.DateExtension.CheckDiapason(viewModel.WeldDateFrom, viewModel.WeldDateTo))
                {
                    viewModel.Data = repo.GetPipelineElements(viewModel.WeldDateFrom, viewModel.WeldDateTo);
                    if(viewModel.Data == null || viewModel.Data.Rows.Count <= 0)
                        log.Warn("Construction report: Data Table for Weld by Date report is NULL or empty");

                    var report = new WeldDateXtraReport();

                    report.DataSource = viewModel.WeldDateReportDataList;
                    report.FootersVisibility = viewModel.IsFooterVisible;
                    var tool = new ReportPrintTool(report);
                    tool.AutoShowParametersPanel = false;
                    tool.ShowPreview();

                    RefreshVisualStateEvent();
                }
                else
                {
                    notify.ShowInfo(Program.LanguageManager.GetString(StringResources.Message_FailureReportDate),
                        Program.LanguageManager.GetString(StringResources.Message_FailureReportDateHeader));
                    log.Warn("Date limits not valid!" + "Diapason: start date= "
                        + viewModel.WeldDateFrom.ToString() + " end date= " + viewModel.WeldDateTo.ToString());
                }
            }
            catch(RepositoryException ex)
            {
                log.Warn(this.GetType().Name + " | " + ex.ToString());
                notify.ShowWarning(Program.LanguageManager.GetString(StringResources.Notification_Error_Db_Message),
            Program.LanguageManager.GetString(StringResources.Notification_Error_Db_Header));
            }
        }

        private void sbChiTietBaoCao_Click(object sender, EventArgs e)
        {
            BaoCaoNhapHang bc = new BaoCaoNhapHang();

            DataTable dt = gcChiTietBaoCao.DataSource as DataTable;
            if (dt != null && dt.Rows.Count > 0)
            {
                bc.ChiTietBaoCao = gcChiTietBaoCao.DataSource as DataTable;
                bc.ThoiGian = ((DateTime)deThoiGian.EditValue).ToString("MM/dd/yyyy");
                XRBaoCaoNhapHang BCTonKho = new XRBaoCaoNhapHang(bc);
                try
                {
                    BCTonKho.CreateDocument();
                }
                catch (Exception ex)
                {

                }
                ReportPrintTool printTool = new ReportPrintTool(BCTonKho);
                printTool.ShowPreviewDialog();
            }
            else
            {
                MessageBox.Show("Danh Sách Báo Cáo Trống",
                   "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            }
        }

        private void simpleButton2_Click(object sender, EventArgs e)
        {
            BaoCaoBangHang bc = new BaoCaoBangHang();
            DataTable dt = gcKetQua.DataSource as DataTable;
            if (dt != null && dt.Rows.Count > 0)
            {
                bc.Data = gcKetQua.DataSource as DataTable;
                bc.MaNhanVien = this.teMaNhanVien.Text;
                bc.TenNhanVien = this.teNhanVien.Text;
                bc.TuNgay = this.dateTuNgay.Text;
                bc.DenNgay = this.dateDienNgay.Text;

                XRLapBaoCaoBanHang BCTonKho = new XRLapBaoCaoBanHang(bc);
                try
                {
                    BCTonKho.CreateDocument();
                }
                catch (Exception ex)
                {

                }
                ReportPrintTool printTool = new ReportPrintTool(BCTonKho);
                printTool.ShowPreviewDialog();
            }
            else
            {
                MessageBox.Show("Danh Sách Báo Cáo Trống",
                   "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            }
        }

 public void Print()
 {
     using (ReportPrintTool printTool = new ReportPrintTool(DocumentSource as XtraReport))
     {
         printTool.Print();
     }
 }

 private void btnPrint_Click(object sender, EventArgs e)
 {
     ReportPrintTool pt = new ReportPrintTool(billReportView);
     pt.PrintingSystem.StartPrint +=
         new PrintDocumentEventHandler(printingSystem_StartPrint);
     pt.PrintDialog();
 }

 public void Execute()
 {
     if (Prizm.Main.Common.DateExtension.CheckDiapason(viewModel.StartDate, viewModel.EndDate))
     {
         try
         {
             data = repo.GetPipesFromInspection(viewModel.StartDate, viewModel.EndDate);
             IncomingReportsXtraReport report = new IncomingReportsXtraReport();
             SetDataSortByColumn("number");
             data.TranslateStatus<PartInspectionStatus>(SQLProvider.TableNameForInspectionReport, SQLProvider.ColumnNameForInspectionStatus, viewModel.localizedInspectionStatus);
             report.DataSource = data;
             report.FootersVisibility = viewModel.IsFooterVisible;
             report.CreateDocument();
             var tool = new ReportPrintTool(report);
             tool.AutoShowParametersPanel = false;
             tool.ShowPreview();
         }
         catch (RepositoryException ex)
         {
             log.Error(string.Concat(ex.InnerException.Message, ex.Message));
             notify.ShowFailure(ex.InnerException.Message, ex.Message);
         }
     }
     else
     {
         notify.ShowInfo(Program.LanguageManager.GetString(StringResources.Message_FailureReportDate),
             Program.LanguageManager.GetString(StringResources.Message_FailureReportDateHeader));
         log.Warn("Date limits not valid!" + "Diapason: start date= "
             + viewModel.StartDate.ToString() + " end date= " + viewModel.EndDate.ToString());
     }
 }

        public static void DoPrint(string pono,bool t)
        {
            var dm = new PoDataManager();
            var rpt = new RptPO();
            if (t)
            {
                rpt.Watermark.Text = "Internal Copy";
            }
            else
            {
                rpt.Watermark.Text = "Supplier Copy";
                dm.UpdatePrint(pono);
            }
            rpt.Watermark.TextDirection = DirectionMode.ForwardDiagonal;
            rpt.Watermark.Font = new Font(rpt.Watermark.Font.FontFamily, 50);
            rpt.Watermark.ForeColor = Color.Gray;
            rpt.Watermark.TextTransparency = 150;
            rpt.Watermark.ShowBehind = false;
            rpt.Company = Utils.Companyname;
            var ds = dm.DoPrint(pono);
            rpt.DataSource = ds;
            ReportPrintTool printTool = new ReportPrintTool(rpt);
           // printTool.ShowPreviewDialog();
            printTool.ShowPreview();

           // rpt.Print();
        }

        public frmPrintBarcode(frmPrintBarcode _barcode) {
            try 
            {
                InitializeComponent();
                splashScreenManager1.ShowWaitForm();
                this.pBarocde = _barcode;
                sBundleTicket report = new sBundleTicket();
                rptBarcodeList s = new rptBarcodeList();
                OprationBarcodeList list = new OprationBarcodeList();

               //report.SetDataSource(list.StickerBarcodeList(pBarocde.Options, pBarocde.CutNo, pBarocde.From, pBarocde.To));

               //this.crystalReportViewer1.ReportSource = report;

                BarcodeLabel lbl = new BarcodeLabel();
                lbl.DataSource = list.StickerBarcodeList(pBarocde.Options, pBarocde.CutNo, pBarocde.From, pBarocde.To);
                ReportPrintTool tool = new ReportPrintTool(lbl);
                tool.ShowPreview();


                splashScreenManager1.CloseWaitForm();
            }catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
                Debug.WriteLine(ex.Message);
            }
           
          
          
        }

        public void Execute()
        {
            try
            {
                viewModel.Data = repo.GetPipelineElements(
                    viewModel.PipeNumber,
                    viewModel.CheckedPipeTypes.Select<PipeMillSizeType, string>(x => x.Type).ToArray<string>());

                if(viewModel.Data == null || viewModel.Data.Rows.Count <= 0)
                    log.Warn(string.Format("Data Table for Pipe Report (pipe #{0}) report is NULL or empty", viewModel.PipeNumber));

                var report = new PipeConstructionXtraReport();

                report.DataSource = viewModel.PipeReportDataList;
                report.FootersVisibility = viewModel.IsFooterVisible;
                var tool = new ReportPrintTool(report);
                tool.AutoShowParametersPanel = false;
                tool.ShowPreview();

                RefreshVisualStateEvent();
            }
            catch(RepositoryException ex)
            {
                log.Warn(this.GetType().Name + " | " + ex.ToString());
                notify.ShowWarning(Program.LanguageManager.GetString(StringResources.Notification_Error_Db_Message),
            Program.LanguageManager.GetString(StringResources.Notification_Error_Db_Header));
            }
        }

        private void GetData(DateTime _fromDate,DateTime _toDate){
           try {
            
               var DataList =  from items in _OperationRepository.GetAll().ToList()

                              where items.Date >= _fromDate && items.Date >= _toDate

                               orderby items.WorkstationNo  
                               
                               select items;

               foreach (var pcs in DataList)
               {

                   lstProduction.Add(new HourlyIndividualProduction { EmployeeID=pcs.EmployeeID, Name=GetEmployeeNameByID(pcs.EmployeeID),   WorkstationNo=pcs.WorkstationNo,OperationNo=pcs.OperationNo,OperationName=pcs.OperationName,HourNo=pcs.HourNo,Efficiency=pcs.Efficiency,EarnSAH=pcs.SAH ,PCS=pcs.Pcs,Date=pcs.Date,StyleNo=pcs.StyleNo});
               
               }



               HourlyProductionByOperation report = new HourlyProductionByOperation();
               report.DataSource = lstProduction;
               ReportPrintTool tool = new ReportPrintTool(report);
               report.PrintingSystem.Document.AutoFitToPagesWidth = 1;
               tool.ShowPreview();


            }
            catch(Exception ex){
            
            }
        
        }

        private void btnListeYazdir_Click(object sender, EventArgs e)
        {
            if (gvListe.FocusedRowHandle < 0) return;

              ReportPrintTool pt1 = new ReportPrintTool(
            InitReport(InitData())
            );
              pt1.ShowPreviewDialog();
        }

        private void btnPrint_Click(object sender, EventArgs e)
        {
            // List<sp_BookingExt_GetAllBooking_Result> aListAllBookingEN = new List<sp_BookingExt_GetAllBooking_Result>();

            frmRpt_Revenues aReport = new frmRpt_Revenues(aListAllBookingEN, From,To,
                SumServiceHalls1_NotTax, SumServiceHalls2_NotTax, SumServiceHalls3_NotTax,
                SumServiceRooms1_NotTax, SumServiceRooms2_NotTax, SumServiceRooms3_NotTax);
            ReportPrintTool tool = new ReportPrintTool(aReport);
            tool.ShowPreview();
        }

 private void ReportClick(object sender, EventArgs e)
 {
     ArrayList v_arr_list = new ArrayList();
     v_arr_list.Add(new iParameter("iP_tieu_de_bao_cao", "BAO CAO DANH MUC MON HOC"));
     v_arr_list.Add(new iParameter("iP_trung_tam", "TO HOP GIAO DUC TOPICA"));
     v_arr_list.Add(new iParameter("iP_date_time", "Hà Nội, ngày 23 tháng 7 năm 2015"));
     BKI_QLTTQuocAnh.BaoCao.RPT_XtraReport v_xr = new BKI_QLTTQuocAnh.BaoCao.RPT_XtraReport(m_ds, m_grv, v_arr_list, System.Drawing.Printing.PaperKind.A4, true);
     ReportPrintTool v_xrpt = new ReportPrintTool(v_xr);
     v_xrpt.ShowPreview();
 }

 private void btnPrint_Click(object sender, EventArgs e)
 {
     if (LUEItems.EditValue == null)
     {
         return;
     }
     DataSources.dsTinyData.ProductsRow row = (DataSources.dsTinyData.ProductsRow)((DataRowView)LUEItems.GetSelectedDataRow()).Row;
     XrepBarcode rep = new XrepBarcode(row.ProductNumber, row.SellPrice.ToString());
     // Create a Print Tool and show the Print Preview form. 
     ReportPrintTool printTool = new ReportPrintTool(rep);
     printTool.ShowPreview();
 }

 private void btnPrintPerformance_Click(object sender, EventArgs e)
 {
     try
     {
         frmRpt_Performance_Rooms afrmRpt_Performance_Rooms = new frmRpt_Performance_Rooms(dtpFrom.DateTime, dtpTo.DateTime, 1);// 1 = IDLang
         ReportPrintTool tool = new ReportPrintTool(afrmRpt_Performance_Rooms);
         tool.ShowPreview();
     }catch(Exception ex)
     {
         MessageBox.Show("frmTsk_CalculationEfficiency.btnPrintPerformance_Click\n" + ex.ToString());
     }
 }

        private void button1_Click(object sender, EventArgs e)
        {
            XtraReport1 report = new XtraReport1();
            //// Add bounded labels to the Detail band of the report.
            report._bindData();
            report._group();
            report.DataSource = NhanVienPT.getAll();

            ReportPrintTool printTool = new ReportPrintTool(report);

            printTool.ShowRibbonPreview();
        }

        public override void ExecuteReport()
        {
            base.ExecuteReport();

            var sh = cbShop.Properties.Items.GetCheckedValues();
            var tbShop = new DataTable();
            tbShop.Columns.Add("Id", typeof(string));
            sh.ForEach(x => tbShop.Rows.Add(x));

            var sp = cbSupplier.Properties.Items.GetCheckedValues();
            var tbSuppl = new DataTable();
            tbSuppl.Columns.Add("Id", typeof(string));
            sp.ForEach(x => tbSuppl.Rows.Add(x));

            var sg = cbGroup.Properties.Items.GetCheckedValues();
            var tbGp = new DataTable();
            tbGp.Columns.Add("Id", typeof(string));
            sg.ForEach(x => tbGp.Rows.Add(x));

            string suppl = string.Join(", ", sp);
            string group = string.Join(", ", sg);

            try
            {
                Parameter.Connection.Open();
                using (
                    var command = new SqlCommand("rep_sel_OrederByShop", Parameter.Connection)
                                      {CommandType = CommandType.StoredProcedure, CommandTimeout = 60000})
                {
                    command.Parameters.AddWithValue("@dateBeg", dateBeg.DateTime.Date);
                    command.Parameters.AddWithValue("@dateEnd", dateEnd.DateTime.Date);
                    command.Parameters.AddWithValue("@ShopCodes", tbShop);

                    command.Parameters.AddWithValue("@Suppliers", tbSuppl);
                    command.Parameters.AddWithValue("@GoodGroups", tbGp);

                    var rep = new XtraReport1() {DataAdapter = new SqlDataAdapter(command)};
                    rep.Parameters["pDate"].Value = string.Format("Период: {0} по {1}", dateBeg.DateTime.Date.ToShortDateString(), dateEnd.DateTime.Date.ToShortDateString());

                    rep.Parameters["pGroup"].Value = string.Format("Товарная группа: {0}", string.IsNullOrEmpty(group) ? "Все" : group);
                    rep.Parameters["pSuppl"].Value = string.Format("Поставщик: {0}", string.IsNullOrEmpty(suppl) ? "Все" : suppl);

                    var reportPrintTool = new ReportPrintTool(rep) {AutoShowParametersPanel = false};
                    reportPrintTool.ShowPreviewDialog();
                }
            }
            finally
            {
                Parameter.Connection.Close();
            }

            //MessageBox.Show("ExecuteReport " + table.Rows.Count.ToString());
        }

 private void button1_Click(object sender, EventArgs e)
 {
     var Buf = new List<string>();
     foreach (string item in listBox1.Items)
     {
         Buf.Add(item);
     }
     var r = new XtraReport1();
     r.AddLabel(Buf, new Rectangle(0,0,630,23));
     var printTool = new ReportPrintTool(r);
     printTool.ShowPreview();
 }