private void Button_Click(object sender, RoutedEventArgs e) { ConfigurationCashHelper.Update(); PassJournalTranslator.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=PassJournal_1;Integrated Security=True;Language='English'"; var report = new WorkingTimeReport(); var filter = new WorkingTimeReportFilter() { //SortColumn = "Number", //PassCardForcing = false, //PassCardLocked = false, //UseArchive = true, //Organisations = new List<Guid>() { new Guid("F6E5DA71-C4D7-4421-94A9-F5F7ED7DDF7E") }, //PeriodType = ReportPeriodType.Month, //DateTimeFrom = new DateTime(2015,01,01), //DateTimeTo = DateTime.Today.AddDays(1), }; filter.Timestamp = DateTime.Now; filter.User = WindowsIdentity.GetCurrent().Name; report.ApplyFilter(filter); var model = new XtraReportPreviewModel(report) { IsParametersPanelVisible = false, AutoShowParametersPanel = false, IsDocumentMapVisible = false, ZoomMode = new ZoomFitModeItem(ZoomFitMode.WholePage), }; documentViewer1.Model = model; report.CreateDocument(); }
public MainWindowViewModel() { PreviewModel = new XtraReportPreviewModel(report); PreviewModel.PreviewMouseMove += model_PreviewMouseMove; PreviewModel.PreviewClick += model_PreviewClick; report.CreateDocument(); }
public BaseViewModel(Guid divisionId) { UserDivision = db.Division.FirstOrDefault(x => x.ID == divisionId); CreateReportCore(delegate(IReport report) { reportPreviewModel = CreateReportPreviewModel(report); }); }
void documentMap_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs <object> e) { XtraReportPreviewModel model = (XtraReportPreviewModel)preview.Model; if (model != null) { model.DocumentMapSelectedNode = e.NewValue as DocumentMapTreeViewNode; } }
private void UpdatePreview() { XtraSchedulerReport report = new XtraSchedulerReport(); report.LoadLayout(ReportTemplateInfoSource[ActiveReportTemplateIndex].ReportTemplatePath); adapter.TimeInterval = new TimeInterval(IntervalStart, IntervalEnd); report.SchedulerAdapter = adapter.SchedulerAdapter; report.CreateDocument(); PreviewModel = new XtraReportPreviewModel(report); }
private void documentPreview1_Loaded(object sender, RoutedEventArgs e) { report = new XtraReport1() { RequestParameters = true }; XtraReportPreviewModel model = new XtraReportPreviewModel(); model.Report = report; report.CreateDocument(); documentPreview1.Model = model; }
public MainWindow() { InitializeComponent(); this.dataSet = new CarsDBDataSet(); // Bind the scheduler storage to appointment data. storage.AppointmentStorage.DataSource = dataSet.CarScheduling; // Load data into the 'CarsDBDataSet.CarScheduling' table. this.tableAdapter = new CarsDBDataSetTableAdapters.CarSchedulingTableAdapter(); this.tableAdapter.Fill(dataSet.CarScheduling); // Create a new report instance. XtraSchedulerReport report = new XtraSchedulerReport(); // Specify the scheduler storage for the print adapter. printAdapter.SchedulerStorage = storage; // Specify the time inteval and start day of week used by the print adapter to create a report. printAdapter.TimeInterval = new TimeInterval(new DateTime(2010, 7, 15), new DateTime(2010, 7, 30)); printAdapter.FirstDayOfWeek = FirstDayOfWeek.Tuesday; // Implement appointment filtering. printAdapter.ValidateAppointments += new AppointmentsValidationEventHandler(printAdapter_ValidateAppointments); // Specify the print adapter which provides data for the report. report.SchedulerAdapter = printAdapter.SchedulerAdapter; // Create a document from the report, so the report can be displayed or printed. report.CreateDocument(); // Create a preview model with the specified report. XtraReportPreviewModel previewModel = new XtraReportPreviewModel(report); // Specify the model for the DocumentPreview control. documentPreview.Model = previewModel; }
private void Window_Loaded(object sender, RoutedEventArgs e) { XtraReportPreviewModel model = new XtraReportPreviewModel(report); model.AutoShowParametersPanel = false; oDocPreview.Model = model; //XtraPageSettingsBase oPage = report.PrintingSystem.PageSettings; //oPage.PaperKind = System.Drawing.Printing.PaperKind.Custom; //oPage = report.PrintingSystem.PageSettings; //model.Report.ApplyPageSettings(oPage); //report.PrintingSystem.SetCommandVisibility(PrintingSystemCommand.SendFile, CommandVisibility.None); //report.PrintingSystem.SetCommandVisibility(PrintingSystemCommand.Watermark, CommandVisibility.None); //report.CreateDocument(); //report.CreateDocument(false); //DocumentPreviewWindow oPrev = new DocumentPreviewWindow() { Model = model }; //report.CreateDocument(false); //oPrev.ShowDialog(); //report.CreateDocument(true); }
private void Window_KeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.F1) { XtraReport1 report = new XtraReport1(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = Properties.Settings.Default.path; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); //using (ReportPrintTool printTool = new ReportPrintTool(report)) //{ // printTool.Print(); // //or printTool.PrintDialog(); //} } }
protected virtual XtraReportPreviewModel CreateReportPreviewModel(IReport report) { var rr = new XtraReportPreviewModel(report); return new XtraReportPreviewModel(report); }
private void Print_Click(object sender, RoutedEventArgs e) { var SumPricee = new FunctionsOfSum(); var Fa_delete = new Assest.OrcDataAcess(); var FA = new Assest.OrcDataAcess(); try { double afo = 0; var Filtring = new List <string>(); foreach (string item in PriceList) { Filtring.Add(item.Replace("SAR", "")); } var accc = new Assest.OrcDataAcess(); List <string> L0 = new List <string>(); List <string> L1 = new List <string>(); List <string> L2 = new List <string>(); List <string> L3 = new List <string>(); List <string> L4 = new List <string>(); List <string> L5 = new List <string>(); List <string> L6 = new List <string>(); // List <string> L7 = new List <string>(); //dis List <string> L8 = new List <string>(); //pricef List <string> L9 = new List <string>(); //dat /* * * * */ DataTable tt = new DataTable(); accc.Show(tt); // Finall_Price = (Double)((Price * Discount) / 100) - Price; foreach (DataRow r in tt.Rows) { L1.Add(r.Field <string>("NAME")); L2.Add(r.Field <string>("BARCODE")); L3.Add(r.Field <string>("PRICE_A")); L4.Add(r.Field <string>("PRICE")); L5.Add(r.Field <string>("ID")); L6.Add(r.Field <string>("QUANTITY")); L7.Add(r.Field <string>("Dis")); L8.Add(r.Field <string>("Price_F")); } tt.Clear(); accc.show3(tt); foreach (DataRow r in tt.Rows) { L0.Add(r.Field <String>("NUMF")); } foreach (string asf in Filtring) { afo += double.Parse(asf); } PriceList.Add(afo.ToString()); Pricce.Text = "SAR " + afo.ToString(); var RepHelper = new ReportHelper(); var ILIST = new List <ReportHelper>(); ILIST.Add(new ReportHelper() { Getprice_ = Pricce.Text }); XtraReport3 report = new XtraReport3(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); string id_3 = ""; //int finalprice = int.Parse(SumPricee.sumPrice().Replace("SAR", "").Replace(",", "")); //double Ristt = double.Parse(afo.ToString().Replace("SAR", "").Replace(",", "")); //double FInaal = finalprice + Ristt; for (int i = 0; i < L1.Count; i++) { if (L1[i] == Name.Text) { id_3 = L5[i]; } } List <int> sawf = new List <int>(); foreach (string d in L0) { sawf.Add(int.Parse(d)); } #region Convert Days to arabic language string dayoftheweek = ""; switch (DateTime.Now.DayOfWeek) { case DayOfWeek.Sunday: { dayoftheweek = ".الاحد"; break; } case DayOfWeek.Monday: { dayoftheweek = ".الاثنين"; break; } case DayOfWeek.Thursday: { dayoftheweek = ".الخميس"; break; } case DayOfWeek.Saturday: { dayoftheweek = ".السبت"; break; } case DayOfWeek.Friday: { dayoftheweek = "الجمعة."; break; } case DayOfWeek.Tuesday: { dayoftheweek = "الثلاثاء."; break; } case DayOfWeek.Wednesday: { dayoftheweek = "الاربعاء."; break; } } #endregion if (L0.Count == 0) { //null } else { numfa = sawf.Max() + 1; } if (sawf.Count == 0) { UmAlQuraCalendar um = new UmAlQuraCalendar(); String CurrentDate = (int.Parse(DateTime.Now.Year.ToString()) < 1600) ? DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() : um.GetYear(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetMonth(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetDayOfMonth(DateTime.Parse(DateTime.Now.ToString())).ToString(); for (int i = 0; i < L1.Count; i++) { double Price = 0; double Discount = 0; double Finall_Price = 0; string Result = ""; DateTime dtttt = new DateTime(); for (int ii = 0; ii < asdf.Count; ii++) { if (L1[i] == asdf[ii]) { accc.insert3(CurrentDate, L1[i], getwholeprice(i, L4, L7), L5[i], L6[i], L3[i], L2[i], numfa.ToString(), dayoftheweek, Pricce.Text); Price = (String.IsNullOrEmpty(L4[i].Replace("SAR", ""))) ? 0 : (Double)Double.Parse(double.Parse(L4[i].Replace("SAR", "")).ToString().Replace("SAR", "")); Discount = (String.IsNullOrEmpty(L7[i].Replace("%", ""))) ? 0 : (Double)Double.Parse(double.Parse(L7[i].Replace("%", "")).ToString().Replace("%", "")); Finall_Price = (Double)((Price * Discount) / 100) - Price; Finall_Price = Finall_Price * int.Parse(L6[i]); Result = "SAR " + Finall_Price.ToString("N2").Replace("-", ""); var mainwi = new MainWindow(L1[i], L4[i], L6[i], L2[i], L3[i], L5[i], L7[i], Result); mainwi.EDIT_MAX(); } /* * * L1.Add(r.Field<string>("NAME")); * L2.Add(r.Field<string>("BARCODE")); * L3.Add(r.Field<string>("PRICE_A")); * L4.Add(r.Field<string>("PRICE")); * L5.Add(r.Field<string>("ID")); * L6.Add(r.Field<string>("QUANTITY")); * L7.Add(r.Field<string>("Dis")); * L8.Add(r.Field<string>("Price_F")); */ } } if (GID.Count > 0) { for (int i = 0; i < GID.Count; i++) { FA.Delete(GID[i]); } } } else { #region Date UmAlQuraCalendar um = new UmAlQuraCalendar(); String CurrentDate = (int.Parse(DateTime.Now.Year.ToString()) < 1600) ? DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() : um.GetYear(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetMonth(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetDayOfMonth(DateTime.Parse(DateTime.Now.ToString())).ToString(); #endregion for (int i = 0; i < L1.Count; i++) { double Price = 0; double Discount = 0; double Finall_Price = 0; string Result = ""; DateTime dtttt = new DateTime(); for (int ii = 0; ii < asdf.Count; ii++) { if (L1[i] == asdf[ii]) { accc.insert3(CurrentDate, L1[i], getwholeprice(i, L4, L7), L5[i], L6[i], L3[i], L2[i], numfa.ToString(), dayoftheweek, Pricce.Text); Price = (String.IsNullOrEmpty(L4[i].Replace("SAR", ""))) ? 0 : (Double)Double.Parse(double.Parse(L4[i].Replace("SAR", "")).ToString().Replace("SAR", "")); Discount = (String.IsNullOrEmpty(L7[i].Replace("%", ""))) ? 0 : (Double)Double.Parse(double.Parse(L7[i].Replace("%", "")).ToString().Replace("%", "")); Finall_Price = (Double)((Price * Discount) / 100) - Price; Finall_Price = Finall_Price * int.Parse(L6[i]); Result = "SAR " + Finall_Price.ToString("N2").Replace("-", ""); var mainwi = new MainWindow(L1[i], L4[i], L6[i], L2[i], L3[i], L5[i], L7[i], Result); mainwi.EDIT_MAX(); } } } if (GID.Count > 0) { for (int i = 0; i < GID.Count; i++) { FA.Updating_QUa("0", GID[i].ToString()); } } } asdf.Clear(); for (int i = 0; i < PriceList.Count; i++) { Fa_delete._Delete(double.Parse(PriceList[i].Replace("SAR", "").Replace(",", ""))); } } catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message + ":" + ex.HResult.ToString()); } DD.ItemsSource = ""; Observ.Clear(); NameList.Clear(); PriceList.Clear(); }
/* * private System.Drawing.Image fQRCode(string mQRTitle, string mQRData){ * try{ * // Dim QRPath As String * BarcodeSettings QRSetting = new BarcodeSettings(); * QRSetting.Type = BarCodeType.QRCode; * QRSetting.Data = mQRData; * QRSetting.Data2D = mQRTitle; * QRSetting.QRCodeDataMode = QRCodeDataMode.AlphaNumber; * * QRSetting.ResolutionType = ResolutionType.Graphics; * QRSetting.Unit = System.Drawing.GraphicsUnit.Millimeter; * QRSetting.DpiX = 300; * QRSetting.DpiY = 300; * * QRSetting.BarHeight = 25; * QRSetting.HasBorder = false; * QRSetting.BorderWidth = 1; * * QRSetting.ImageHeight = 25; // 2.53 Inch | 64.2 Inch |128mm | 480 Pixel * QRSetting.ImageWidth = 25; * QRSetting.AutoResize = true; * * QRSetting.X = 0.5F; * QRSetting.QRCodeECL = QRCodeECL.H; * QRSetting.TopMargin = 1; * QRSetting.LeftMargin = 1; * QRSetting.RightMargin = 1; * QRSetting.BottomMargin = 1; * QRSetting.ForeColor = System.Drawing.Color.Black; * // QRSetting.ForeColor = Color.CadetBlue * * System.Drawing.Font myFont = new System.Drawing.Font("Verdana", 8); * QRSetting.TextFont = myFont; * QRSetting.ShowText = false; * QRSetting.TopText = mQRTitle; * QRSetting.TopTextColor = System.Drawing.Color.Green; * QRSetting.ShowTextOnBottom = false; * * BarCodeGenerator QRGer = new BarCodeGenerator(QRSetting); * System.Drawing.Image Img = QRGer.GenerateImage(); * * // 'Dim QRBitmap As System.Drawing.Bitmap = oQR.GetGraphic(20) * System.IO.MemoryStream oMS = new System.IO.MemoryStream(); * Img.Save(oMS, System.Drawing.Imaging.ImageFormat.Png); * return Img; * } * catch (Exception ex) * { * return null; * } * } */ #endregion public void rptInMaVach(DataTable oTblSP, Boolean isDG = false, Boolean isMaQR = true, String isMauIn = "25_15") { try { if (oTblSP == null || oTblSP.Rows.Count <= 0) { Utils.showMessage(String.Format("Bạn chưa chọn sản phẩm cần tạo mã {0}", isMaQR == true ? " QRCode.." : " Vạch.."), "Lưu ý"); return; } SqlParameter[] arrPara = new SqlParameter[5]; arrPara[0] = new SqlParameter("@tblMasp", SqlDbType.Structured); arrPara[0].Value = oTblSP; arrPara[1] = new SqlParameter("@Loai", SqlDbType.TinyInt); arrPara[1].Value = isMaQR == true ? 0 : 1; arrPara[2] = new SqlParameter("@Cogia", SqlDbType.Bit); arrPara[2].Value = isDG == true ? 1 : 0; arrPara[3] = new SqlParameter("@Denngay", SqlDbType.NVarChar, 15); arrPara[3].Value = MTGlobal.MT_DENNGAY; arrPara[4] = new SqlParameter("@Nguoidung", SqlDbType.NVarChar, 50); arrPara[4].Value = MTGlobal.MT_USER_LOGIN; DataTable otblMaCode = new MTSQLServer().wRead("rptDM_InMaQRCode", arrPara); if (otblMaCode != null) { switch (isMauIn) { case "25_15": rptHH_QRCode_25_15 oReport = new rptHH_QRCode_25_15(); oReport.InitMacode(isMaQR); oReport.DataSource = otblMaCode; oReport.BindData(); SetCustomPageQR(oReport, isMauIn); setFormatReport(oReport); XtraReportPreviewModel model = new XtraReportPreviewModel(oReport); model.AutoShowParametersPanel = false; DocumentPreviewWindow oPrev = new DocumentPreviewWindow() { Model = model }; oPrev.WindowStyle = System.Windows.WindowStyle.SingleBorderWindow; oPrev.WindowState = System.Windows.WindowState.Normal; oPrev.WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen; oPrev.Title = "IN MÃ VẠCH"; oPrev.ShowDialog(); break; //3TEM/ROW case "35_22": /* * Spire.Barcode.BarcodeSettings.ApplyKey("3GZHB-UT3PY-9YAGD-EXYS6-PREGK"); * DataTable oTblCode = new DataTable(); * oTblCode.Columns.Add("Macode", typeof(System.String)); * oTblCode.Columns.Add("MacodeText", typeof(System.String)); * oTblCode.Columns.Add("PicCode", typeof(System.Drawing.Image)); * foreach (DataRow vR in otblMaCode.Rows) { * DataRow dR = oTblCode.NewRow(); * dR["Macode"] = vR["Macode"]; * dR["MacodeText"] = vR["MacodeText"]; * dR["PicCode"] =fQRCode(vR["MacodeText"].ToString(),vR["Macode"].ToString()); * oTblCode.Rows.Add(dR); * * } * oTblCode.AcceptChanges(); * rptHH_QRCode_3temImg_35_22 oReport3t = new rptHH_QRCode_3temImg_35_22(); * oReport3t.InitMacode(isMaQR); * oReport3t.DataSource = oTblCode; * oReport3t.BindData(); * SetCustomPageQR(oReport3t, isMauIn); * setFormatReport(oReport3t); * * PrintPreview oPreview3t = new PrintPreview(); * oPreview3t.report = oReport3t; * * oPreview3t.Show(); * break; */ if (isMaQR) { rptHH_QRCode_35_22 oRptQRcode3T = new rptHH_QRCode_35_22(); oRptQRcode3T.InitMacode(isMaQR); oRptQRcode3T.DataSource = otblMaCode; oRptQRcode3T.BindData(); SetCustomPageQR(oRptQRcode3T, isMauIn); setFormatReport(oRptQRcode3T); PrintPreview oPreviewQR = new PrintPreview(); oPreviewQR.report = oRptQRcode3T; oPreviewQR.ShowDialog(); /* * XtraReportPreviewModel model2 = new XtraReportPreviewModel(oRptQRcode3T); * model2.AutoShowParametersPanel = false; * DocumentPreviewWindow oPrev2 = new DocumentPreviewWindow() { Model = model2 }; * oPrev2.UpdateLayout(); * * oPrev2.WindowStyle = System.Windows.WindowStyle.SingleBorderWindow; * oPrev2.WindowState = System.Windows.WindowState.Normal; * oPrev2.WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen; * oPrev2.Title = "IN MÃ QRCODE"; * //oPrev2.Topmost = true; * oPrev2.ShowDialog(); */ } else { rptHH_Barcode_35_22 oRptBarcode3T = new rptHH_Barcode_35_22(); oRptBarcode3T.InitMacode(isMaQR); oRptBarcode3T.DataSource = otblMaCode; oRptBarcode3T.BindData(); XtraReportPreviewModel model2 = new XtraReportPreviewModel(oRptBarcode3T); model2.AutoShowParametersPanel = false; DocumentPreviewWindow oPrev2 = new DocumentPreviewWindow() { Model = model2 }; //oRptBarcode3T.CreateDocument(false); oPrev2.WindowStyle = System.Windows.WindowStyle.SingleBorderWindow; oPrev2.WindowState = System.Windows.WindowState.Normal; oPrev2.WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen; oPrev2.Title = "IN MÃ VẠCH"; //oPrev2.Topmost = true; //SetCustomPageQR(oRptBarcode3T, isMauIn); setFormatReport(oRptBarcode3T); oPrev2.ShowDialog(); } break; case "30_30": rptHH_QRCode_30_30 oReport30 = new rptHH_QRCode_30_30(); oReport30.InitMacode(isMaQR); oReport30.DataSource = otblMaCode; oReport30.BindData(); setFormatReport(oReport30); SetCustomPageQR(oReport30); PrintPreview oPreview30 = new PrintPreview(); oPreview30.report = oReport30; oPreview30.ShowDialog(); break; } } else { Utils.showMessage("Không thể đọc dữ liệu tạo mã vạch..", "Thông báo"); } } catch { } }
private void printControl1_Load(object sender, EventArgs e) { XtraReportPreviewModel model = new XtraReportPreviewModel(report); model.AutoShowParametersPanel = false; }
private async void PrivewDoucmentPrinter_Click(object sender, RoutedEventArgs e) { if (IS_SELECTED) { if (PrintHelper.Print.IsMounth_) { PrintHelper.Print.GET_STRATED(); var Dataopp = new Assest.OrcDataAcess(); XtraReport4 report = new XtraReport4(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); Dataopp.Delete4(); } else if (PrintHelper.Print.IsYear_) { PrintHelper.Print.GET_STRATED(); var Dataopp = new Assest.OrcDataAcess(); XtraReport4 report = new XtraReport4(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); Dataopp.Delete4(); } else if (PrintHelper.Print.IsDay_) { PrintHelper.Print.GET_STRATED(); var Dataopp = new Assest.OrcDataAcess(); XtraReport4 report = new XtraReport4(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); Dataopp.Delete4(); } else if (!PrintHelper.Print.IsDay_ && !PrintHelper.Print.IsMounth_ && !PrintHelper.Print.IsYear_) { SYear(); PrintHelper.Print.GET_STRATED(); var Dataopp = new Assest.OrcDataAcess(); XtraReport4 report = new XtraReport4(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); Dataopp.Delete4(); } } else if (!is_Repair_Selected) { XtraReport1 report = new XtraReport1(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); } if (is_Repair_Selected) { if (Encode1.Text == "/d") { NewModel(type_of_date.day); PrintHelper.Print.IsMounth_ = false; PrintHelper.Print.IsDay_ = true; PrintHelper.Print.IsYear_ = false; Reports.XtraReport5 report = new Reports.XtraReport5(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); mo.Delete1(); PrintHelper.Print.IsMounth_ = false; PrintHelper.Print.IsDay_ = false; PrintHelper.Print.IsYear_ = false; } else if (Encode1.Text == "/m") { NewModel(type_of_date.month); PrintHelper.Print.IsMounth_ = true; PrintHelper.Print.IsDay_ = false; PrintHelper.Print.IsYear_ = false; Reports.XtraReport5 report = new Reports.XtraReport5(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); mo.Delete1(); PrintHelper.Print.IsMounth_ = false; PrintHelper.Print.IsDay_ = false; PrintHelper.Print.IsYear_ = false; } else if (Encode1.Text == "/y") { NewModel(type_of_date.year); PrintHelper.Print.IsMounth_ = false; PrintHelper.Print.IsDay_ = false; PrintHelper.Print.IsYear_ = true; Reports.XtraReport5 report = new Reports.XtraReport5(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); mo.Delete1(); PrintHelper.Print.IsMounth_ = false; PrintHelper.Print.IsDay_ = false; PrintHelper.Print.IsYear_ = false; } else if (String.IsNullOrEmpty(Encode1.Text)) { NewModel(type_of_date.year); PrintHelper.Print.IsMounth_ = false; PrintHelper.Print.IsDay_ = false; PrintHelper.Print.IsYear_ = true; Reports.XtraReport5 report = new Reports.XtraReport5(); SQLiteConnectionParameters FF = new SQLiteConnectionParameters(); FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db"; ((SqlDataSource)report.DataSource).ConnectionParameters = FF; XtraReportPreviewModel model = new XtraReportPreviewModel(report); DocumentPreviewWindow windoww = new DocumentPreviewWindow() { Model = model }; report.CreateDocument(true); windoww.ShowDialog(); mo.Delete1(); PrintHelper.Print.IsMounth_ = false; PrintHelper.Print.IsDay_ = false; PrintHelper.Print.IsYear_ = false; } else { //later } } }