public static void RenderReport() { var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor(); var deviceInfo = new Hashtable(); // Depending on the report definition choose ONE of the following REPORT SOURCES // -1- // ***CLR (CSharp) report definitions*** var reportSource = new Telerik.Reporting.TypeReportSource(); // reportName is the Assembly Qualified Name of the report reportSource.TypeName = "ReportLibraryDemo.Report1, ReportLibraryDemo, Version=14.1.20.618, Culture=neutral, PublicKeyToken=null"; // -1- //// -2- //// ***Declarative (TRDP/TRDX) report definitions*** //var reportSource = new Telerik.Reporting.UriReportSource(); //// reportName is the path to the TRDP/TRDX file //reportSource.Uri = reportName; //// -2- //// -3- //// ***Instance of the report definition*** //var reportSource = new Telerik.Reporting.InstanceReportSource(); //// Report1 is the class of the report. It should inherit Telerik.Reporting.Report class //reportSource.ReportDocument = new Report1(); //// -3- // Pass parameter value with the Report Source if necessary //object parameterValue = "Some Parameter Value"; //reportSource.Parameters.Add("ParameterName", parameterValue); Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo); string fileName = result.DocumentName + "." + result.Extension; var directoryInfo = Directory.GetParent(Directory.GetCurrentDirectory()).Parent; string projectPath = directoryInfo.FullName; string folderName = Path.Combine(projectPath, "Reports"); if (!Directory.Exists(folderName)) { Directory.CreateDirectory(folderName); } string filePath = Path.Combine(folderName, fileName); using (FileStream fs = new System.IO.FileStream(filePath, System.IO.FileMode.Create)) { fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length); } }
protected void test_Click(object sender, EventArgs e) { LabelRpt report = new LabelRpt(); string convertedfrom = "2017-11-1"; string convertedto = "2017-11-30"; var dt = GetData(convertedfrom, convertedto); var objectDataSource = new ObjectDataSource { DataSource = dt }; report.DataSource = objectDataSource; var table = report.Items.Find("list1", true)[0] as Telerik.Reporting.List; table.ColumnHeadersPrintOnEveryPage = true; table.DataSource = dt; Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor(); System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable(); Telerik.Reporting.TypeReportSource typeReportSource = new Telerik.Reporting.TypeReportSource(); typeReportSource.TypeName = "reportName"; Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", report, deviceInfo); string today = Convert.ToDateTime(DateTime.Now).ToString("ddMMyyyy"); string fileName = result.DocumentName + "_" + today + "." + result.Extension; string path = System.IO.Path.GetTempPath(); string filePath = System.IO.Path.Combine(path, fileName); TempPath.Text = filePath; using (System.IO.FileStream fs = new System.IO.FileStream(filePath, System.IO.FileMode.Create)) { fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length); } if (update(dt)) { RetrieveCombobox(); Response.Write("<script>alert('File Has been downloaded to your temporary Folder, see information above preview')</script>"); } else { Response.Write("Error has occurred"); } }
protected void Page_Load(object sender, EventArgs e) { ReportProcessor reportProcessor = new ReportProcessor(); // set any deviceInfo settings if necessary System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable(); Telerik.Reporting.TypeReportSource typeReportSource = new Telerik.Reporting.TypeReportSource(); // reportName is the Assembly Qualified Name of the report typeReportSource.TypeName = "PDF"; RenderingResult result = reportProcessor.RenderReport("PDF", typeReportSource, deviceInfo); string fileName = result.DocumentName + "." + result.Extension; string path = System.IO.Path.GetTempPath(); string filePath = System.IO.Path.Combine(path, fileName); using (System.IO.FileStream fs = new System.IO.FileStream(filePath, System.IO.FileMode.Create)) { fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length); } }
/// <summary> /// Required method for telerik Reporting designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Telerik.Reporting.NavigateToReportAction navigateToReportAction1 = new Telerik.Reporting.NavigateToReportAction(); Telerik.Reporting.TypeReportSource typeReportSource1 = new Telerik.Reporting.TypeReportSource(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(EmployeeSalesSummary)); Telerik.Reporting.GraphGroup graphGroup1 = new Telerik.Reporting.GraphGroup(); Telerik.Reporting.Drawing.ColorPalette colorPalette1 = new Telerik.Reporting.Drawing.ColorPalette(); Telerik.Reporting.GraphTitle graphTitle1 = new Telerik.Reporting.GraphTitle(); Telerik.Reporting.CategoryScale categoryScale1 = new Telerik.Reporting.CategoryScale(); Telerik.Reporting.NumericalScale numericalScale1 = new Telerik.Reporting.NumericalScale(); Telerik.Reporting.GraphGroup graphGroup2 = new Telerik.Reporting.GraphGroup(); Telerik.Reporting.GraphGroup graphGroup3 = new Telerik.Reporting.GraphGroup(); Telerik.Reporting.Drawing.ColorPalette colorPalette2 = new Telerik.Reporting.Drawing.ColorPalette(); Telerik.Reporting.GraphTitle graphTitle2 = new Telerik.Reporting.GraphTitle(); Telerik.Reporting.CategoryScale categoryScale2 = new Telerik.Reporting.CategoryScale(); Telerik.Reporting.NumericalScale numericalScale2 = new Telerik.Reporting.NumericalScale(); Telerik.Reporting.Drawing.ColorPalette colorPalette3 = new Telerik.Reporting.Drawing.ColorPalette(); Telerik.Reporting.GraphGroup graphGroup4 = new Telerik.Reporting.GraphGroup(); Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup4 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup5 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup6 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup7 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup8 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup9 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup10 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup11 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.TableGroup tableGroup12 = new Telerik.Reporting.TableGroup(); Telerik.Reporting.Group group1 = new Telerik.Reporting.Group(); Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule(); this.textBoxTableTitle = new Telerik.Reporting.TextBox(); this.textBoxCategoryAmount = new Telerik.Reporting.TextBox(); this.textBoxCategory = new Telerik.Reporting.TextBox(); this.textBoxSalesOrderNumber = new Telerik.Reporting.TextBox(); this.textBoxOrderTotal = new Telerik.Reporting.TextBox(); this.textBox4 = new Telerik.Reporting.TextBox(); this.textBox12 = new Telerik.Reporting.TextBox(); this.textBoxEmployeeSalesTotal = new Telerik.Reporting.TextBox(); this.textBoxTotalLabel = new Telerik.Reporting.TextBox(); this.textBox10 = new Telerik.Reporting.TextBox(); this.groupFooterSection1 = new Telerik.Reporting.GroupFooterSection(); this.groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection(); this.textBoxLogo = new Telerik.Reporting.TextBox(); this.textBoxDataRange = new Telerik.Reporting.TextBox(); this.textBoxReportEmployee = new Telerik.Reporting.TextBox(); this.shape3 = new Telerik.Reporting.Shape(); this.Employees = new Telerik.Reporting.SqlDataSource(); this.detail = new Telerik.Reporting.DetailSection(); this.panelWrapper = new Telerik.Reporting.Panel(); this.graph1 = new Telerik.Reporting.Graph(); this.cartesianCoordinateSystem1 = new Telerik.Reporting.CartesianCoordinateSystem(); this.graphAxis2 = new Telerik.Reporting.GraphAxis(); this.graphAxis1 = new Telerik.Reporting.GraphAxis(); this.mainDataSource = new Telerik.Reporting.SqlDataSource(); this.lineSeries1 = new Telerik.Reporting.AreaSeries(); this.graph2 = new Telerik.Reporting.Graph(); this.cartesianCoordinateSystem3 = new Telerik.Reporting.CartesianCoordinateSystem(); this.graphAxis6 = new Telerik.Reporting.GraphAxis(); this.graphAxis5 = new Telerik.Reporting.GraphAxis(); this.barSeries1 = new Telerik.Reporting.BarSeries(); this.crosstabEmployeeSales = new Telerik.Reporting.Crosstab(); this.textBox6 = new Telerik.Reporting.TextBox(); this.textBox5 = new Telerik.Reporting.TextBox(); this.textBox9 = new Telerik.Reporting.TextBox(); this.textBox13 = new Telerik.Reporting.TextBox(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // textBoxTableTitle // this.textBoxTableTitle.Name = "textBoxTableTitle"; this.textBoxTableTitle.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0799999237060547D), Telerik.Reporting.Drawing.Unit.Inch(0.47999998927116394D)); this.textBoxTableTitle.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBoxTableTitle.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D); this.textBoxTableTitle.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0.079999998211860657D); this.textBoxTableTitle.Value = "{Parameters.ReportDate.Value.ToString(\"MMMM yyyy\")} Order Summary"; // // textBoxCategoryAmount // this.textBoxCategoryAmount.Format = "{0:N2}"; this.textBoxCategoryAmount.Name = "textBoxCategoryAmount"; this.textBoxCategoryAmount.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.75D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); this.textBoxCategoryAmount.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBoxCategoryAmount.Value = "=Sum(Fields.LineTotal)"; // // textBoxCategory // this.textBoxCategory.Name = "textBoxCategory"; this.textBoxCategory.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.130000114440918D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); this.textBoxCategory.Value = "=Fields.Category"; // // textBoxSalesOrderNumber // typeReportSource1.Parameters.Add(new Telerik.Reporting.Parameter("OrderNumber", "=Fields.SalesOrderNumber")); typeReportSource1.Parameters.Add(new Telerik.Reporting.Parameter("ForYear", "=Parameters.ReportDate.Value.Year")); typeReportSource1.Parameters.Add(new Telerik.Reporting.Parameter("ForMonth", "=Parameters.ReportDate.Value.Month")); typeReportSource1.TypeName = "Telerik.Reporting.Examples.CSharp.Invoice, CSharp.ReportLibrary, Version=1.0.0.0," + " Culture=neutral, PublicKeyToken=null"; navigateToReportAction1.ReportSource = typeReportSource1; this.textBoxSalesOrderNumber.Action = navigateToReportAction1; this.textBoxSalesOrderNumber.Name = "textBoxSalesOrderNumber"; this.textBoxSalesOrderNumber.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2100000381469727D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); this.textBoxSalesOrderNumber.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(105)))), ((int)(((byte)(104))))); this.textBoxSalesOrderNumber.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Inch(0.05000000074505806D); this.textBoxSalesOrderNumber.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top; this.textBoxSalesOrderNumber.Value = "=Fields.SalesOrderNumber"; // // textBoxOrderTotal // this.textBoxOrderTotal.Format = "{0:N2}"; this.textBoxOrderTotal.Name = "textBoxOrderTotal"; this.textBoxOrderTotal.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.75D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); this.textBoxOrderTotal.Style.BorderColor.Default = System.Drawing.Color.Black; this.textBoxOrderTotal.Style.BorderColor.Top = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230))))); this.textBoxOrderTotal.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBoxOrderTotal.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBoxOrderTotal.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBoxOrderTotal.Value = "=Sum(Fields.LineTotal)"; // // textBox4 // this.textBox4.Name = "textBox4"; this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.130000114440918D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); this.textBox4.Style.BorderColor.Default = System.Drawing.Color.Black; this.textBox4.Style.BorderColor.Top = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230))))); this.textBox4.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox4.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; // // textBox12 // this.textBox12.Name = "textBox12"; this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2100000381469727D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); this.textBox12.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; // // textBoxEmployeeSalesTotal // this.textBoxEmployeeSalesTotal.Format = "{0:N2}"; this.textBoxEmployeeSalesTotal.Name = "textBoxEmployeeSalesTotal"; this.textBoxEmployeeSalesTotal.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.75D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); this.textBoxEmployeeSalesTotal.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBoxEmployeeSalesTotal.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D); this.textBoxEmployeeSalesTotal.Style.Font.Bold = true; this.textBoxEmployeeSalesTotal.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBoxEmployeeSalesTotal.Value = "=Sum(Fields.LineTotal)"; // // textBoxTotalLabel // this.textBoxTotalLabel.Name = "textBoxTotalLabel"; this.textBoxTotalLabel.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.130000114440918D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); this.textBoxTotalLabel.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBoxTotalLabel.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D); this.textBoxTotalLabel.Value = "Total:"; // // textBox10 // this.textBox10.Name = "textBox10"; this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2100000381469727D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); this.textBox10.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox10.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D); // // groupFooterSection1 // this.groupFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.1272023469209671D); this.groupFooterSection1.Name = "groupFooterSection1"; this.groupFooterSection1.Style.Visible = false; // // groupHeaderSection1 // this.groupHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(1D); this.groupHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBoxLogo, this.textBoxDataRange, this.textBoxReportEmployee, this.shape3 }); this.groupHeaderSection1.Name = "groupHeaderSection1"; this.groupHeaderSection1.PrintOnEveryPage = true; // // textBoxLogo // this.textBoxLogo.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D)); this.textBoxLogo.Name = "textBoxLogo"; this.textBoxLogo.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1972219944000244D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D)); this.textBoxLogo.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(195)))), ((int)(((byte)(47)))), ((int)(((byte)(11))))); this.textBoxLogo.Style.Font.Bold = true; this.textBoxLogo.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBoxLogo.Value = "SALES REPORT"; // // textBoxDataRange // this.textBoxDataRange.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.6000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBoxDataRange.Name = "textBoxDataRange"; this.textBoxDataRange.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.4999597072601318D), Telerik.Reporting.Drawing.Unit.Inch(0.19837446510791779D)); this.textBoxDataRange.Style.Font.Bold = true; this.textBoxDataRange.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBoxDataRange.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBoxDataRange.Value = "=Parameters.ReportDate.Value.ToString(\'MMM yyyy\')"; // // textBoxReportEmployee // this.textBoxReportEmployee.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.20011806488037109D)); this.textBoxReportEmployee.Name = "textBoxReportEmployee"; this.textBoxReportEmployee.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999603271484375D), Telerik.Reporting.Drawing.Unit.Inch(0.60000002384185791D)); this.textBoxReportEmployee.StyleName = "Header"; this.textBoxReportEmployee.Value = "=Parameters.Employee.Label"; // // shape3 // this.shape3.Anchoring = ((Telerik.Reporting.AnchoringStyles)((Telerik.Reporting.AnchoringStyles.Left | Telerik.Reporting.AnchoringStyles.Right))); this.shape3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.80019682645797729D)); this.shape3.Name = "shape3"; this.shape3.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999603271484375D), Telerik.Reporting.Drawing.Unit.Point(2D)); this.shape3.Stretch = true; this.shape3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.shape3.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.shape3.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.shape3.Style.BorderWidth.Top = Telerik.Reporting.Drawing.Unit.Point(1.5D); this.shape3.Style.Color = System.Drawing.Color.Transparent; // // Employees // this.Employees.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"; this.Employees.Name = "Employees"; this.Employees.SelectCommand = resources.GetString("Employees.SelectCommand"); // // detail // this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(6.8000006675720215D); this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.panelWrapper }); this.detail.KeepTogether = false; this.detail.Name = "detail"; // // panelWrapper // this.panelWrapper.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.graph1, this.graph2, this.crosstabEmployeeSales }); this.panelWrapper.KeepTogether = false; this.panelWrapper.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D), Telerik.Reporting.Drawing.Unit.Inch(7.8678131103515625E-05D)); this.panelWrapper.Name = "panelWrapper"; this.panelWrapper.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1000394821167D), Telerik.Reporting.Drawing.Unit.Inch(6.79992151260376D)); // // graph1 // graphGroup1.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.OrderDate.Month")); graphGroup1.Label = "= Fields.OrderDate.ToString(\"MMMM\")"; graphGroup1.Name = "orderDate.MonthGroup1"; graphGroup1.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.OrderDate.Month", Telerik.Reporting.SortDirection.Asc)); this.graph1.CategoryGroups.Add(graphGroup1); colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(247)))), ((int)(((byte)(150)))), ((int)(((byte)(70)))))); colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(172)))), ((int)(((byte)(198)))))); colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(100)))), ((int)(((byte)(162)))))); colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(182)))), ((int)(((byte)(87)))), ((int)(((byte)(8)))))); colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(39)))), ((int)(((byte)(106)))), ((int)(((byte)(124)))))); colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(77)))), ((int)(((byte)(59)))), ((int)(((byte)(98)))))); this.graph1.ColorPalette = colorPalette1; this.graph1.CoordinateSystems.Add(this.cartesianCoordinateSystem1); this.graph1.DataSource = this.mainDataSource; this.graph1.Legend.Position = Telerik.Reporting.GraphItemPosition.RightCenter; this.graph1.Legend.Style.LineColor = System.Drawing.Color.LightGray; this.graph1.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D); this.graph1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9458274841308594E-05D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.graph1.Name = "graph1"; this.graph1.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray; this.graph1.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D); this.graph1.Series.Add(this.lineSeries1); this.graph1.SeriesGroups.Add(graphGroup2); this.graph1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(2.4000000953674316D)); this.graph1.Style.Font.Name = "Segoe UI"; this.graph1.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Pixel(10D); this.graph1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Pixel(10D); this.graph1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Pixel(10D); this.graph1.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Pixel(10D); graphTitle1.Position = Telerik.Reporting.GraphItemPosition.TopCenter; graphTitle1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(14D); graphTitle1.Style.LineColor = System.Drawing.Color.LightGray; graphTitle1.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D); graphTitle1.Text = "Yearly Sales Comparison"; this.graph1.Titles.Add(graphTitle1); // // cartesianCoordinateSystem1 // this.cartesianCoordinateSystem1.Name = "cartesianCoordinateSystem1"; this.cartesianCoordinateSystem1.XAxis = this.graphAxis2; this.cartesianCoordinateSystem1.YAxis = this.graphAxis1; // // graphAxis2 // this.graphAxis2.LabelAngle = -90; this.graphAxis2.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray; this.graphAxis2.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D); this.graphAxis2.MajorGridLineStyle.Visible = true; this.graphAxis2.MajorTickMarkDisplayType = Telerik.Reporting.GraphAxisTickMarkDisplayType.None; this.graphAxis2.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray; this.graphAxis2.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D); this.graphAxis2.MinorGridLineStyle.Visible = false; this.graphAxis2.Name = "graphAxis2"; this.graphAxis2.Scale = categoryScale1; this.graphAxis2.Style.Font.Name = "Segoe UI"; this.graphAxis2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D); this.graphAxis2.Style.Visible = true; // // graphAxis1 // this.graphAxis1.LabelFormat = "{0:C0}K"; this.graphAxis1.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray; this.graphAxis1.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D); this.graphAxis1.MajorGridLineStyle.Visible = true; this.graphAxis1.MajorTickMarkDisplayType = Telerik.Reporting.GraphAxisTickMarkDisplayType.None; this.graphAxis1.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray; this.graphAxis1.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D); this.graphAxis1.MinorGridLineStyle.Visible = false; this.graphAxis1.Name = "graphAxis1"; this.graphAxis1.Scale = numericalScale1; this.graphAxis1.Style.Font.Name = "Segoe UI"; this.graphAxis1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D); this.graphAxis1.Style.Visible = true; // // mainDataSource // this.mainDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"; this.mainDataSource.Name = "mainDataSource"; this.mainDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { new Telerik.Reporting.SqlDataSourceParameter("@ReportYear", System.Data.DbType.String, null), new Telerik.Reporting.SqlDataSourceParameter("@ReportMonth", System.Data.DbType.String, null), new Telerik.Reporting.SqlDataSourceParameter("@EmployeeID", System.Data.DbType.Int32, "=Parameters.Employee.Value") }); this.mainDataSource.SelectCommand = resources.GetString("mainDataSource.SelectCommand"); // // lineSeries1 // this.lineSeries1.AreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D); this.lineSeries1.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked; this.lineSeries1.CategoryGroup = graphGroup1; this.lineSeries1.CoordinateSystem = this.cartesianCoordinateSystem1; this.lineSeries1.DataPointLabel = "=Sum(Fields.LineTotal)"; this.lineSeries1.DataPointLabelStyle.Visible = false; this.lineSeries1.DataPointStyle.Visible = false; this.lineSeries1.LegendItem.Value = "=Fields.OrderDate.Year"; this.lineSeries1.MarkerSize = Telerik.Reporting.Drawing.Unit.Mm(2D); this.lineSeries1.Name = "lineSeries1"; graphGroup2.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.OrderDate.Year")); graphGroup2.Name = "orderDate.YearGroup1"; graphGroup2.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.OrderDate.Year", Telerik.Reporting.SortDirection.Asc)); this.lineSeries1.SeriesGroup = graphGroup2; this.lineSeries1.Y = "=ISNULL(Sum(Fields.LineTotal), 0) / 1000.0"; // // graph2 // graphGroup3.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.Category")); graphGroup3.Name = "categoryGroup1"; graphGroup3.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.Category", Telerik.Reporting.SortDirection.Asc)); this.graph2.CategoryGroups.Add(graphGroup3); colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(247)))), ((int)(((byte)(150)))), ((int)(((byte)(70)))))); colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(172)))), ((int)(((byte)(198)))))); colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(100)))), ((int)(((byte)(162)))))); colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(182)))), ((int)(((byte)(87)))), ((int)(((byte)(8)))))); colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(39)))), ((int)(((byte)(106)))), ((int)(((byte)(124)))))); colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(77)))), ((int)(((byte)(59)))), ((int)(((byte)(98)))))); this.graph2.ColorPalette = colorPalette2; this.graph2.CoordinateSystems.Add(this.cartesianCoordinateSystem3); this.graph2.DataSource = this.mainDataSource; this.graph2.Legend.IsInsidePlotArea = false; this.graph2.Legend.Position = Telerik.Reporting.GraphItemPosition.RightCenter; this.graph2.Legend.Style.Font.Name = "Segoe UI"; this.graph2.Legend.Style.LineColor = System.Drawing.Color.LightGray; this.graph2.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D); this.graph2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(2.5999214649200439D)); this.graph2.Name = "graph2"; this.graph2.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray; this.graph2.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D); this.graph2.Series.Add(this.barSeries1); this.graph2.SeriesGroups.Add(graphGroup4); this.graph2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(2.4000000953674316D)); this.graph2.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Pixel(10D); this.graph2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Pixel(10D); this.graph2.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Pixel(10D); this.graph2.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Pixel(10D); graphTitle2.Position = Telerik.Reporting.GraphItemPosition.TopCenter; graphTitle2.Style.Font.Name = "Segoe UI"; graphTitle2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(14D); graphTitle2.Style.LineColor = System.Drawing.Color.LightGray; graphTitle2.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D); graphTitle2.Text = "Category Sales Comparison"; this.graph2.Titles.Add(graphTitle2); // // cartesianCoordinateSystem3 // this.cartesianCoordinateSystem3.Name = "cartesianCoordinateSystem3"; this.cartesianCoordinateSystem3.XAxis = this.graphAxis6; this.cartesianCoordinateSystem3.YAxis = this.graphAxis5; // // graphAxis6 // this.graphAxis6.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray; this.graphAxis6.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D); this.graphAxis6.MajorGridLineStyle.Visible = false; this.graphAxis6.MajorTickMarkDisplayType = Telerik.Reporting.GraphAxisTickMarkDisplayType.None; this.graphAxis6.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray; this.graphAxis6.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D); this.graphAxis6.MinorGridLineStyle.Visible = false; this.graphAxis6.Name = "graphAxis6"; this.graphAxis6.Scale = categoryScale2; this.graphAxis6.Style.Font.Name = "Segoe UI"; this.graphAxis6.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D); // // graphAxis5 // this.graphAxis5.LabelFormat = "{0:C0}K"; this.graphAxis5.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray; this.graphAxis5.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D); this.graphAxis5.MajorTickMarkDisplayType = Telerik.Reporting.GraphAxisTickMarkDisplayType.None; this.graphAxis5.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray; this.graphAxis5.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D); this.graphAxis5.MinorGridLineStyle.Visible = false; this.graphAxis5.Name = "graphAxis5"; this.graphAxis5.Scale = numericalScale2; this.graphAxis5.Style.Font.Name = "Segoe UI"; this.graphAxis5.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D); // // barSeries1 // this.barSeries1.CategoryGroup = graphGroup3; colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(247)))), ((int)(((byte)(150)))), ((int)(((byte)(70)))))); colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(172)))), ((int)(((byte)(198)))))); colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(100)))), ((int)(((byte)(162)))))); colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(182)))), ((int)(((byte)(87)))), ((int)(((byte)(8)))))); colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(39)))), ((int)(((byte)(106)))), ((int)(((byte)(124)))))); colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(77)))), ((int)(((byte)(59)))), ((int)(((byte)(98)))))); this.barSeries1.ColorPalette = colorPalette3; this.barSeries1.CoordinateSystem = this.cartesianCoordinateSystem3; this.barSeries1.DataPointLabel = "=Sum(Fields.LineTotal)"; this.barSeries1.DataPointLabelStyle.Visible = false; this.barSeries1.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D); this.barSeries1.DataPointStyle.Visible = true; this.barSeries1.LegendItem.Value = "=Fields.OrderDate.Year"; graphGroup4.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.OrderDate.Year")); graphGroup4.Name = "orderDate.YearGroup2"; graphGroup4.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.OrderDate.Year", Telerik.Reporting.SortDirection.Asc)); this.barSeries1.SeriesGroup = graphGroup4; this.barSeries1.Y = "=Sum(Fields.LineTotal) / 1000.0"; // // crosstabEmployeeSales // this.crosstabEmployeeSales.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0D))); this.crosstabEmployeeSales.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.48000001907348633D))); this.crosstabEmployeeSales.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.24000000953674316D))); this.crosstabEmployeeSales.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.24000000953674316D))); this.crosstabEmployeeSales.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.24000000953674316D))); this.crosstabEmployeeSales.Body.SetCellContent(1, 0, this.textBox6); this.crosstabEmployeeSales.Body.SetCellContent(0, 0, this.textBox5); this.crosstabEmployeeSales.Body.SetCellContent(2, 0, this.textBox9); this.crosstabEmployeeSales.Body.SetCellContent(3, 0, this.textBox13); this.crosstabEmployeeSales.ColumnGroups.Add(tableGroup1); this.crosstabEmployeeSales.DataSource = this.mainDataSource; this.crosstabEmployeeSales.Filters.Add(new Telerik.Reporting.Filter("= Fields.OrderDate.Year", Telerik.Reporting.FilterOperator.Equal, "=Parameters.ReportDate.Value.Year")); this.crosstabEmployeeSales.Filters.Add(new Telerik.Reporting.Filter("= Fields.OrderDate.Month", Telerik.Reporting.FilterOperator.Equal, "=Parameters.ReportDate.Value.Month")); this.crosstabEmployeeSales.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox6, this.textBox5, this.textBox9, this.textBox13, this.textBoxTableTitle, this.textBoxSalesOrderNumber, this.textBoxCategory, this.textBoxCategoryAmount, this.textBox12, this.textBox4, this.textBoxOrderTotal, this.textBox10, this.textBoxTotalLabel, this.textBoxEmployeeSalesTotal }); this.crosstabEmployeeSales.KeepTogether = false; this.crosstabEmployeeSales.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(5.4999213218688965D)); this.crosstabEmployeeSales.Name = "crosstabEmployeeSales"; this.crosstabEmployeeSales.NoDataMessage = "= \"No Sales for \" + Parameters.ReportDate.Value.ToString(\"MMMM, yyyy\")"; this.crosstabEmployeeSales.NoDataStyle.Color = System.Drawing.Color.Red; tableGroup2.Name = "RowGroup"; tableGroup2.ReportItem = this.textBoxTableTitle; tableGroup2.Sortings.Add(new Telerik.Reporting.Sorting("1", Telerik.Reporting.SortDirection.Asc)); tableGroup6.Name = "Detail"; tableGroup6.ReportItem = this.textBoxCategoryAmount; tableGroup5.ChildGroups.Add(tableGroup6); tableGroup5.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.Category")); tableGroup5.Name = "Category"; tableGroup5.ReportItem = this.textBoxCategory; tableGroup5.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.Category", Telerik.Reporting.SortDirection.Asc)); tableGroup4.ChildGroups.Add(tableGroup5); tableGroup4.Name = "Group6"; tableGroup4.ReportItem = this.textBoxSalesOrderNumber; tableGroup9.Name = "Group2"; tableGroup9.ReportItem = this.textBoxOrderTotal; tableGroup8.ChildGroups.Add(tableGroup9); tableGroup8.Name = "Group1"; tableGroup8.ReportItem = this.textBox4; tableGroup7.ChildGroups.Add(tableGroup8); tableGroup7.Name = "Group7"; tableGroup7.ReportItem = this.textBox12; tableGroup3.ChildGroups.Add(tableGroup4); tableGroup3.ChildGroups.Add(tableGroup7); tableGroup3.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.SalesOrderID")); tableGroup3.Name = "SalesOrder"; tableGroup3.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.SalesOrderNumber", Telerik.Reporting.SortDirection.Asc)); tableGroup12.Name = "Group4"; tableGroup12.ReportItem = this.textBoxEmployeeSalesTotal; tableGroup11.ChildGroups.Add(tableGroup12); tableGroup11.Name = "Group5"; tableGroup11.ReportItem = this.textBoxTotalLabel; tableGroup10.ChildGroups.Add(tableGroup11); tableGroup10.Name = "Group3"; tableGroup10.ReportItem = this.textBox10; this.crosstabEmployeeSales.RowGroups.Add(tableGroup2); this.crosstabEmployeeSales.RowGroups.Add(tableGroup3); this.crosstabEmployeeSales.RowGroups.Add(tableGroup10); this.crosstabEmployeeSales.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.09000015258789D), Telerik.Reporting.Drawing.Unit.Inch(1.2000000476837158D)); this.crosstabEmployeeSales.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(137)))), ((int)(((byte)(145)))), ((int)(((byte)(164))))); // // textBox6 // this.textBox6.Name = "textBox6"; this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); // // textBox5 // this.textBox5.Name = "textBox5"; this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.47999998927116394D)); this.textBox5.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None; this.textBox5.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.None; // // textBox9 // this.textBox9.Name = "textBox9"; this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); // // textBox13 // this.textBox13.Name = "textBox13"; this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D)); // // EmployeeSalesSummary // group1.GroupFooter = this.groupFooterSection1; group1.GroupHeader = this.groupHeaderSection1; group1.Groupings.Add(new Telerik.Reporting.Grouping("")); group1.Name = "group1"; this.Groups.AddRange(new Telerik.Reporting.Group[] { group1 }); this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.groupHeaderSection1, this.groupFooterSection1, this.detail }); this.Name = "EmployeeSalesSummary"; this.PageSettings.Landscape = false; this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D)); this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter; reportParameter1.AutoRefresh = true; reportParameter1.Name = "ReportDate"; reportParameter1.Text = "Report Date"; reportParameter1.Type = Telerik.Reporting.ReportParameterType.DateTime; reportParameter1.Value = "=#2003-07-01#"; reportParameter1.Visible = true; reportParameter2.AutoRefresh = true; reportParameter2.AvailableValues.DataSource = this.Employees; reportParameter2.AvailableValues.DisplayMember = "= Fields.Employee"; reportParameter2.AvailableValues.ValueMember = "= Fields.SalesPersonID"; reportParameter2.Name = "Employee"; reportParameter2.Text = "Employee"; reportParameter2.Type = Telerik.Reporting.ReportParameterType.Integer; reportParameter2.Value = "=283"; reportParameter2.Visible = true; this.ReportParameters.Add(reportParameter1); this.ReportParameters.Add(reportParameter2); styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)), new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox)) }); styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D); styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D); styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Header") }); styleRule2.Style.Font.Bold = true; styleRule2.Style.Font.Name = "Segoe UI Light"; styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(25D); styleRule2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D); styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top; styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Category") }); styleRule3.Style.Font.Name = "Segoe UI Light"; styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D); styleRule3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D); styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top; styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextBox)) }); styleRule4.Style.Font.Name = "Segoe UI"; styleRule4.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0D); styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom; this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] { styleRule1, styleRule2, styleRule3, styleRule4 }); this.Width = Telerik.Reporting.Drawing.Unit.Inch(8.09999942779541D); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for telerik Reporting designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Telerik.Reporting.Barcodes.Code128Encoder code128Encoder1 = new Telerik.Reporting.Barcodes.Code128Encoder(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Invoice)); Telerik.Reporting.TypeReportSource typeReportSource1 = new Telerik.Reporting.TypeReportSource(); Telerik.Reporting.Group group1 = new Telerik.Reporting.Group(); Telerik.Reporting.Drawing.TextWatermark textWatermark1 = new Telerik.Reporting.Drawing.TextWatermark(); Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule(); this.groupFooterSection1 = new Telerik.Reporting.GroupFooterSection(); this.groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection(); this.panel5 = new Telerik.Reporting.Panel(); this.Text1 = new Telerik.Reporting.TextBox(); this.barcode2 = new Telerik.Reporting.Barcode(); this.pictureBox1 = new Telerik.Reporting.PictureBox(); this.textBox1 = new Telerik.Reporting.TextBox(); this.panel3 = new Telerik.Reporting.Panel(); this.Id1 = new Telerik.Reporting.TextBox(); this.Text8 = new Telerik.Reporting.TextBox(); this.Field6 = new Telerik.Reporting.TextBox(); this.shape3 = new Telerik.Reporting.Shape(); this.OrderNumbersDataSource = new Telerik.Reporting.SqlDataSource(); this.detail = new Telerik.Reporting.DetailSection(); this.panel4 = new Telerik.Reporting.Panel(); this.textBox14 = new Telerik.Reporting.TextBox(); this.textBox10 = new Telerik.Reporting.TextBox(); this.textBox9 = new Telerik.Reporting.TextBox(); this.textBox8 = new Telerik.Reporting.TextBox(); this.textBox6 = new Telerik.Reporting.TextBox(); this.textBox4 = new Telerik.Reporting.TextBox(); this.textBox12 = new Telerik.Reporting.TextBox(); this.textBox13 = new Telerik.Reporting.TextBox(); this.textBox11 = new Telerik.Reporting.TextBox(); this.textBox16 = new Telerik.Reporting.TextBox(); this.textBox17 = new Telerik.Reporting.TextBox(); this.textBox18 = new Telerik.Reporting.TextBox(); this.textBox19 = new Telerik.Reporting.TextBox(); this.textBox21 = new Telerik.Reporting.TextBox(); this.panel1 = new Telerik.Reporting.Panel(); this.textBox24 = new Telerik.Reporting.TextBox(); this.textBox23 = new Telerik.Reporting.TextBox(); this.textBox25 = new Telerik.Reporting.TextBox(); this.textBox26 = new Telerik.Reporting.TextBox(); this.textBox27 = new Telerik.Reporting.TextBox(); this.textBox30 = new Telerik.Reporting.TextBox(); this.textBox29 = new Telerik.Reporting.TextBox(); this.textBox28 = new Telerik.Reporting.TextBox(); this.textBox32 = new Telerik.Reporting.TextBox(); this.textBox31 = new Telerik.Reporting.TextBox(); this.panel2 = new Telerik.Reporting.Panel(); this.textBox7 = new Telerik.Reporting.TextBox(); this.textBox2 = new Telerik.Reporting.TextBox(); this.textBox3 = new Telerik.Reporting.TextBox(); this.subReport1 = new Telerik.Reporting.SubReport(); this.InvoicesDataSource = new Telerik.Reporting.SqlDataSource(); this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection(); this.textBox5 = new Telerik.Reporting.TextBox(); this.textBox22 = new Telerik.Reporting.TextBox(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // groupFooterSection1 // this.groupFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.23541705310344696D); this.groupFooterSection1.Name = "groupFooterSection1"; this.groupFooterSection1.Style.Visible = false; // // groupHeaderSection1 // this.groupHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(1.4500000476837158D); this.groupHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.panel5 }); this.groupHeaderSection1.Name = "groupHeaderSection1"; // // panel5 // this.panel5.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.Text1, this.barcode2, this.pictureBox1, this.textBox1, this.panel3 }); this.panel5.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.010456085205078125D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D)); this.panel5.Name = "panel5"; this.panel5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(20.547340393066406D), Telerik.Reporting.Drawing.Unit.Cm(3.668447732925415D)); // // Text1 // this.Text1.CanGrow = false; this.Text1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(5.3865165710449219D), Telerik.Reporting.Drawing.Unit.Cm(0.73998814821243286D)); this.Text1.Name = "Text1"; this.Text1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(7.0666971206665039D), Telerik.Reporting.Drawing.Unit.Cm(1.3915178775787354D)); this.Text1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.Text1.Value = "275 Grove St., Suite 2-400, Newton, MA 02466\r\nPhone: +1.888.365.2779\r\nFax: +1.617" + ".249.2116"; // // barcode2 // this.barcode2.Encoder = code128Encoder1; this.barcode2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(15.098536491394043D), Telerik.Reporting.Drawing.Unit.Cm(0.00010012308484874666D)); this.barcode2.Name = "barcode2"; this.barcode2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(5.448702335357666D), Telerik.Reporting.Drawing.Unit.Cm(2.1811349391937256D)); this.barcode2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.barcode2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom; this.barcode2.Value = "=Fields.PurchaseOrderNumber"; // // pictureBox1 // this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.pictureBox1.MimeType = "image/jpeg"; this.pictureBox1.Name = "pictureBox1"; this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.8914073705673218D), Telerik.Reporting.Drawing.Unit.Inch(0.8587145209312439D)); this.pictureBox1.Value = ((object)(resources.GetObject("pictureBox1.Value"))); // // textBox1 // this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.1206760406494141D), Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D)); this.textBox1.Name = "textBox1"; this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.9106760025024414D), Telerik.Reporting.Drawing.Unit.Inch(0.29121589660644531D)); this.textBox1.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(195)))), ((int)(((byte)(47)))), ((int)(((byte)(11))))); this.textBox1.Value = "AdventureWorks"; // // panel3 // this.panel3.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.Id1, this.Text8, this.Field6, this.shape3 }); this.panel3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.93754321336746216D)); this.panel3.Name = "panel3"; this.panel3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0894250869750977D), Telerik.Reporting.Drawing.Unit.Inch(0.50285667181015015D)); // // Id1 // this.Id1.CanGrow = false; this.Id1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0D), Telerik.Reporting.Drawing.Unit.Cm(0D)); this.Id1.Name = "Id1"; this.Id1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(10.239533424377441D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D)); this.Id1.Style.BackgroundColor = System.Drawing.Color.Empty; this.Id1.Style.BorderColor.Default = System.Drawing.Color.Black; this.Id1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None; this.Id1.StyleName = "Header"; this.Id1.Value = "Sales Order: {Fields.SalesOrderID}"; // // Text8 // this.Text8.CanGrow = false; this.Text8.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(13.574539184570313D), Telerik.Reporting.Drawing.Unit.Cm(0D)); this.Text8.Name = "Text8"; this.Text8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(1.5236968994140625D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D)); this.Text8.Style.BackgroundColor = System.Drawing.Color.Empty; this.Text8.Style.Visible = true; this.Text8.StyleName = "Header"; this.Text8.Value = "Date:"; // // Field6 // this.Field6.CanGrow = false; this.Field6.Format = "{0:d}"; this.Field6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(15.133413314819336D), Telerik.Reporting.Drawing.Unit.Cm(0D)); this.Field6.Name = "Field6"; this.Field6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(5.4136261940002441D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D)); this.Field6.Style.BackgroundColor = System.Drawing.Color.Empty; this.Field6.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.Field6.StyleName = "Header"; this.Field6.Value = "= Fields.OrderDate"; // // shape3 // this.shape3.Anchoring = ((Telerik.Reporting.AnchoringStyles)((Telerik.Reporting.AnchoringStyles.Left | Telerik.Reporting.AnchoringStyles.Right))); this.shape3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.47507891058921814D)); this.shape3.Name = "shape3"; this.shape3.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0893850326538086D), Telerik.Reporting.Drawing.Unit.Point(2D)); this.shape3.Stretch = true; this.shape3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.shape3.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.shape3.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.shape3.Style.BorderWidth.Top = Telerik.Reporting.Drawing.Unit.Point(1.5D); this.shape3.Style.Color = System.Drawing.Color.Transparent; // // OrderNumbersDataSource // this.OrderNumbersDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"; this.OrderNumbersDataSource.Name = "OrderNumbers"; this.OrderNumbersDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { new Telerik.Reporting.SqlDataSourceParameter("@ForYear", System.Data.DbType.String, "=Parameters.ForYear.Value"), new Telerik.Reporting.SqlDataSourceParameter("@ForMonth", System.Data.DbType.String, "=Parameters.ForMonth.Value") }); this.OrderNumbersDataSource.SelectCommand = resources.GetString("OrderNumbersDataSource.SelectCommand"); // // detail // this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(3.2155463695526123D); this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.panel4, this.subReport1 }); this.detail.KeepTogether = false; this.detail.Name = "detail"; // // panel4 // this.panel4.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox14, this.textBox10, this.textBox9, this.textBox8, this.textBox6, this.textBox4, this.textBox12, this.textBox13, this.textBox11, this.textBox16, this.textBox17, this.textBox18, this.textBox19, this.textBox21, this.panel1, this.panel2, this.textBox2, this.textBox3 }); this.panel4.KeepTogether = false; this.panel4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.panel4.Name = "panel4"; this.panel4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0998811721801758D), Telerik.Reporting.Drawing.Unit.Inch(2.71911358833313D)); // // textBox14 // this.textBox14.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(0.59330624341964722D)); this.textBox14.Name = "textBox14"; this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7913684844970703D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox14.Value = "=Fields.Store"; // // textBox10 // this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.010495503433048725D), Telerik.Reporting.Drawing.Unit.Inch(1.5699173212051392D)); this.textBox10.Name = "textBox10"; this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.2792060375213623D), Telerik.Reporting.Drawing.Unit.Inch(0.29374995827674866D)); this.textBox10.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D); this.textBox10.Value = "=Fields.CustPhone"; // // textBox9 // this.textBox9.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.80837249755859375D)); this.textBox9.Name = "textBox9"; this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.9018634557724D), Telerik.Reporting.Drawing.Unit.Inch(0.2571415901184082D)); this.textBox9.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D); this.textBox9.Value = "=Fields.CustFirstName + \" \" + Fields.CustLastName"; // // textBox8 // this.textBox8.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.010456085205078125D), Telerik.Reporting.Drawing.Unit.Inch(0.60829383134841919D)); this.textBox8.Name = "textBox8"; this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.72496062517166138D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox8.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox8.Value = "CONTACT:"; // // textBox6 // this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(1.5699173212051392D)); this.textBox6.Name = "textBox6"; this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7913684844970703D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox6.Value = "=Fields.BillCountryRegion"; // // textBox4 // this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(1.3698383569717407D)); this.textBox4.Name = "textBox4"; this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7913684844970703D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox4.Value = "=Fields.BillPostalCode + \" \" + Fields.BillCity"; // // textBox12 // this.textBox12.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(1.1697593927383423D)); this.textBox12.Name = "textBox12"; this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.8776596784591675D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox12.Value = "=IsNull(Fields.BillAddress2, \'No secondary Address\')"; // // textBox13 // this.textBox13.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(0.9696807861328125D)); this.textBox13.Name = "textBox13"; this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7913684844970703D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox13.Value = "=Fields.BillAddress1"; // // textBox11 // this.textBox11.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(1.3698387145996094D)); this.textBox11.Name = "textBox11"; this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.72496062517166138D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox11.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox11.Value = "PHONE:"; // // textBox16 // this.textBox16.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(0.57831829786300659D)); this.textBox16.Name = "textBox16"; this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox16.Value = "=Fields.Store"; // // textBox17 // this.textBox17.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(0.96968048810958862D)); this.textBox17.Name = "textBox17"; this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox17.Value = "=Fields.ShipAddress1"; // // textBox18 // this.textBox18.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(1.1697593927383423D)); this.textBox18.Name = "textBox18"; this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox18.Value = "=IsNull(Fields.ShipAddress2, \'No secondary Address\')"; // // textBox19 // this.textBox19.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(1.3698383569717407D)); this.textBox19.Name = "textBox19"; this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox19.Value = "=Fields.ShipPostalCode + \" \" + Fields.ShipCity + \", \" + Fields.ShipStateProvince " + ""; // // textBox21 // this.textBox21.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(1.5699173212051392D)); this.textBox21.Name = "textBox21"; this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox21.Value = "=Fields.ShipCountryRegion"; // // panel1 // this.panel1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox24, this.textBox23, this.textBox25, this.textBox26, this.textBox27, this.textBox30, this.textBox29, this.textBox28, this.textBox32, this.textBox31 }); this.panel1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(2.0311710834503174D)); this.panel1.Name = "panel1"; this.panel1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0998411178588867D), Telerik.Reporting.Drawing.Unit.Inch(0.55303496122360229D)); // // textBox24 // this.textBox24.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D)); this.textBox24.Name = "textBox24"; this.textBox24.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1395833492279053D), Telerik.Reporting.Drawing.Unit.Inch(0.3425000011920929D)); this.textBox24.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox24.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox24.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.textBox24.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox24.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox24.Value = "DATE:"; // // textBox23 // this.textBox23.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.1396621465682983D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D)); this.textBox23.Name = "textBox23"; this.textBox23.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7561712265014648D), Telerik.Reporting.Drawing.Unit.Inch(0.3425000011920929D)); this.textBox23.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox23.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox23.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.textBox23.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox23.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox23.Value = "ORDER DATE:"; // // textBox25 // this.textBox25.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D)); this.textBox25.Name = "textBox25"; this.textBox25.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.6796835660934448D), Telerik.Reporting.Drawing.Unit.Inch(0.3425000011920929D)); this.textBox25.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox25.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox25.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.textBox25.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox25.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox25.Value = "SALES PERSON:"; // // textBox26 // this.textBox26.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.5756745338439941D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D)); this.textBox26.Name = "textBox26"; this.textBox26.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.3790086507797241D), Telerik.Reporting.Drawing.Unit.Inch(0.3425000011920929D)); this.textBox26.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox26.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox26.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.textBox26.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox26.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox26.Value = "PURCHASE ORDER:"; // // textBox27 // this.textBox27.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D)); this.textBox27.Name = "textBox27"; this.textBox27.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.3425000011920929D)); this.textBox27.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox27.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox27.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.textBox27.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox27.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox27.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox27.Value = "SHIPMENT METHOD"; // // textBox30 // this.textBox30.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(0.34261831641197205D)); this.textBox30.Name = "textBox30"; this.textBox30.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.6796832084655762D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox30.Value = "=Fields.SalesFirstName + \" \" + Fields.SalesLastName"; // // textBox29 // this.textBox29.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.5756745338439941D), Telerik.Reporting.Drawing.Unit.Inch(0.34261831641197205D)); this.textBox29.Name = "textBox29"; this.textBox29.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.3790086507797241D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox29.Value = "=Fields.PurchaseOrderNumber"; // // textBox28 // this.textBox28.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(0.34261831641197205D)); this.textBox28.Name = "textBox28"; this.textBox28.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450397968292236D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox28.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox28.Value = "=Fields.ShipMethod"; // // textBox32 // this.textBox32.Format = "{0:d}"; this.textBox32.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.1396620273590088D), Telerik.Reporting.Drawing.Unit.Inch(0.34261831641197205D)); this.textBox32.Name = "textBox32"; this.textBox32.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7561712265014648D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox32.Value = "=Fields.OrderDate"; // // textBox31 // this.textBox31.Format = "{0:d}"; this.textBox31.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.34261831641197205D)); this.textBox31.Name = "textBox31"; this.textBox31.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1395833492279053D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox31.Value = "=Today()"; // // panel2 // this.panel2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox7 }); this.panel2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D)); this.panel2.Name = "panel2"; this.panel2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0998411178588867D), Telerik.Reporting.Drawing.Unit.Inch(0.45000001788139343D)); this.panel2.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.panel2.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); // // textBox7 // this.textBox7.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox7.Name = "textBox7"; this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.9041273593902588D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D)); this.textBox7.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox7.StyleName = "Header"; this.textBox7.Value = "Customer Details"; // // textBox2 // this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.1311321258544922D), Telerik.Reporting.Drawing.Unit.Inch(0.60829383134841919D)); this.textBox2.Name = "textBox2"; this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.66167718172073364D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox2.Value = "ADDRESS:"; // // textBox3 // this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.35480260848999D), Telerik.Reporting.Drawing.Unit.Inch(0.57831794023513794D)); this.textBox3.Name = "textBox3"; this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.56537884473800659D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.textBox3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox3.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top; this.textBox3.Value = "SHIP TO:"; // // subReport1 // this.subReport1.KeepTogether = false; this.subReport1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.010495503433048725D), Telerik.Reporting.Drawing.Unit.Inch(2.865025520324707D)); this.subReport1.Name = "subReport1"; typeReportSource1.Parameters.Add(new Telerik.Reporting.Parameter("SaledOrderID", "=Fields.SalesOrderID")); typeReportSource1.TypeName = "Telerik.Reporting.Examples.CSharp.SalesOrderDetails, CSharp.ReportLibrary, Versio" + "n=1.0.0.0, Culture=neutral, PublicKeyToken=null"; this.subReport1.ReportSource = typeReportSource1; this.subReport1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0893068313598633D), Telerik.Reporting.Drawing.Unit.Inch(0.27500006556510925D)); // // InvoicesDataSource // this.InvoicesDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"; this.InvoicesDataSource.Name = "Invoices"; this.InvoicesDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { new Telerik.Reporting.SqlDataSourceParameter("@SalesOrderNumber", System.Data.DbType.String, "=Parameters.OrderNumber.Value") }); this.InvoicesDataSource.SelectCommand = resources.GetString("InvoicesDataSource.SelectCommand"); // // pageFooterSection1 // this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.2291666716337204D); this.pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox5, this.textBox22 }); this.pageFooterSection1.Name = "pageFooterSection1"; this.pageFooterSection1.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; // // textBox5 // this.textBox5.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox5.Name = "textBox5"; this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.8958332538604736D), Telerik.Reporting.Drawing.Unit.Inch(0.22912724316120148D)); this.textBox5.Value = "=PageExec(\"lineTotalDataTextBox\",Count(Fields.ProductNumber)) + \" products, \" + P" + "ageExec(\"lineTotalDataTextBox\",Sum(Fields.OrderQty)) + \" items on page \" + Page" + "Number"; // // textBox22 // this.textBox22.Format = "{0:C2}"; this.textBox22.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9685325622558594D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D)); this.textBox22.Name = "textBox22"; this.textBox22.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1312694549560547D), Telerik.Reporting.Drawing.Unit.Inch(0.22908782958984375D)); this.textBox22.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox22.Value = "=PageExec(\"lineTotalDataTextBox\",sum(LineTotal))"; // // Invoice // this.DataSource = this.InvoicesDataSource; this.Filters.Add(new Telerik.Reporting.Filter("=Fields.SalesOrderNumber", Telerik.Reporting.FilterOperator.Equal, "=Parameters.OrderNumber.Value")); group1.GroupFooter = this.groupFooterSection1; group1.GroupHeader = this.groupHeaderSection1; group1.Name = "group1"; this.Groups.AddRange(new Telerik.Reporting.Group[] { group1 }); this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.groupHeaderSection1, this.groupFooterSection1, this.detail, this.pageFooterSection1 }); this.Name = "Invoice"; this.PageSettings.Landscape = false; this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D)); this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter; textWatermark1.Color = System.Drawing.Color.Black; textWatermark1.Font.Bold = false; textWatermark1.Font.Italic = false; textWatermark1.Font.Name = "Tahoma"; textWatermark1.Font.Size = Telerik.Reporting.Drawing.Unit.Point(150D); textWatermark1.Font.Strikeout = false; textWatermark1.Font.Underline = false; textWatermark1.Opacity = 0.02D; textWatermark1.Orientation = Telerik.Reporting.Drawing.WatermarkOrientation.Diagonal; textWatermark1.Position = Telerik.Reporting.Drawing.WatermarkPosition.Front; textWatermark1.PrintOnFirstPage = true; textWatermark1.PrintOnLastPage = true; textWatermark1.Text = "Original"; this.PageSettings.Watermarks.Add(textWatermark1); reportParameter1.AutoRefresh = true; reportParameter1.AvailableValues.DataSource = this.OrderNumbersDataSource; reportParameter1.AvailableValues.DisplayMember = "SalesOrderNumber"; reportParameter1.AvailableValues.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.SalesOrderNumber", Telerik.Reporting.SortDirection.Asc)); reportParameter1.AvailableValues.ValueMember = "SalesOrderNumber"; reportParameter1.Name = "OrderNumber"; reportParameter1.Text = "Order #"; reportParameter1.Value = "=First(Fields.SalesOrderNumber)"; reportParameter1.Visible = true; reportParameter2.Name = "ForYear"; reportParameter2.Type = Telerik.Reporting.ReportParameterType.Integer; reportParameter2.Value = "=2003"; reportParameter3.Name = "ForMonth"; reportParameter3.Type = Telerik.Reporting.ReportParameterType.Integer; reportParameter3.Value = "=7"; this.ReportParameters.Add(reportParameter1); this.ReportParameters.Add(reportParameter2); this.ReportParameters.Add(reportParameter3); this.Style.BackgroundColor = System.Drawing.Color.White; styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)), new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox)) }); styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D); styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D); styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextBox)) }); styleRule2.Style.Font.Name = "Segoe UI"; styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D); styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Header") }); styleRule3.Style.Font.Bold = true; styleRule3.Style.Font.Name = "Segoe UI Light"; styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D); styleRule3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D); this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] { styleRule1, styleRule2, styleRule3 }); this.Width = Telerik.Reporting.Drawing.Unit.Inch(8.09999942779541D); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
private void OnStartOverview() { // set PeriodTo to end of Month PeriodTo = dateFunctions.MonthEnd(PeriodTo); CreateEmployeeSalaryOverview createOverview = new CreateEmployeeSalaryOverview(null, PeriodFrom.Date, PeriodTo.Date); overviews = createOverview.GetSalaryOverview(); if (SortByOffice) { overviews = overviews.OrderBy(s => s.OfficeLocation).ThenBy(s => s.EmployeeName).ToList(); } // create JsonFile JsonSerializerSettings settings = new JsonSerializerSettings(); settings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; settings.MissingMemberHandling = MissingMemberHandling.Ignore; string jsonContent = JsonConvert.SerializeObject(overviews, settings); string jsonfile = $"C:\\Users\\Public\\Documents\\Json.json"; System.IO.File.WriteAllText(jsonfile, jsonContent); //TypeReportSource source = new TypeReportSource(); //source.TypeName = typeof(AccountingHelper.Reporting.AnnualSalarySummary).AssemblyQualifiedName; //source.Parameters.Add("Source", jsonfile); //source.Parameters.Add("DataSelector", string.Empty); //ViewerParameter parameter = new ViewerParameter(); //parameter.typeReportSource = source; //eventAggregator.GetEvent<ViewerParameterEvent>().Publish(parameter); var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor(); // set any deviceInfo settings if necessary var deviceInfo = new System.Collections.Hashtable(); var reportSource = new Telerik.Reporting.TypeReportSource(); // reportName is the Assembly Qualified Name of the report reportSource.TypeName = typeof(AccountingHelper.Reporting.AnnualSalarySummary).AssemblyQualifiedName; // Pass parameter value with the Report Source if necessary reportSource.Parameters.Add("Source", jsonfile); reportSource.Parameters.Add("DataSelector", string.Empty); Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo); jsonfile = jsonfile.Replace(".json", ".pdf"); using (System.IO.FileStream fs = new System.IO.FileStream(jsonfile, System.IO.FileMode.Create)) { fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length); } SelectedFilename = jsonfile; result = reportProcessor.RenderReport("XLSX", reportSource, deviceInfo); string excelFileName = $"C:\\Users\\Public\\Documents\\gehaltsuebersicht.xlsx"; using (System.IO.FileStream fs = new System.IO.FileStream(excelFileName, System.IO.FileMode.Create)) { fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length); } }
// call report with reportname only void callreport(string Reportname) { Telerik.Reporting.TypeReportSource typeReportSource = new Telerik.Reporting.TypeReportSource(); string reportname; reportname = Reportname; switch (reportname) { #region Master case "Action Maintenance": ActionIDMaintenance ActionMaintenance = new ActionIDMaintenance(); typeReportSource.TypeName = typeof(ActionIDMaintenance).AssemblyQualifiedName; break; case "Batch Setup": BatchMaster BatchList = new BatchMaster(); typeReportSource.TypeName = typeof(BatchMaster).AssemblyQualifiedName; break; case "Company Asset Setup": //CompanyAssetMaster companyAsset = new CompanyAssetMaster(); //typeReportSource.TypeName = typeof(CompanyAssetMaster).AssemblyQualifiedName; break; case "Complain Code Setup": ComplainMaster complainCode = new ComplainMaster(); typeReportSource.TypeName = typeof(ComplainMaster).AssemblyQualifiedName; break; case "Country Setup": CountrySetup countrySetup = new CountrySetup(); typeReportSource.TypeName = typeof(CountrySetup).AssemblyQualifiedName; break; case "Daytype Setup": DayMaster dayTYpeSetup = new DayMaster(); typeReportSource.TypeName = typeof(DayMaster).AssemblyQualifiedName; break; case "Division Setup": DivisionMaster divisionMaster = new DivisionMaster(); typeReportSource.TypeName = typeof(DivisionMaster).AssemblyQualifiedName; break; case "Facility Setup": FacilitiesMaster facilitiesMaster = new FacilitiesMaster(); typeReportSource.TypeName = typeof(FacilitiesMaster).AssemblyQualifiedName; break; case "Nationality Setup": NationalityMaster nationalityMaster = new NationalityMaster(); typeReportSource.TypeName = typeof(NationalityMaster).AssemblyQualifiedName; break; case "Religion Setup": ReligionMaster religionMaster = new ReligionMaster(); typeReportSource.TypeName = typeof(ReligionMaster).AssemblyQualifiedName; break; case "Room Setup": RoomMaster roomMaster = new RoomMaster(); typeReportSource.TypeName = typeof(RoomMaster).AssemblyQualifiedName; break; case "Suggestion Master": SuggestionMaster suggestionMaster = new SuggestionMaster(); typeReportSource.TypeName = typeof(SuggestionMaster).AssemblyQualifiedName; break; case "Employer Setup": EmployerMaster employerMaster = new EmployerMaster(); typeReportSource.TypeName = typeof(EmployerMaster).AssemblyQualifiedName; break; case "Loan Type": SuggestionMaster suggestionMaster1 = new SuggestionMaster(); typeReportSource.TypeName = typeof(SuggestionMaster).AssemblyQualifiedName; break; #endregion #region Setup case "Attendence Machine": AttendenceSetup AttendenceSetup = new AttendenceSetup(); typeReportSource.TypeName = typeof(AttendenceSetup).AssemblyQualifiedName; break; case "Benefit Setup": BenefitMaster BenefitMaster = new BenefitMaster(); typeReportSource.TypeName = typeof(BenefitMaster).AssemblyQualifiedName; break; case "Branch Setup": BranchMaster branchmaster = new BranchMaster(); typeReportSource.TypeName = typeof(BranchMaster).AssemblyQualifiedName; break; case "Calender Setup": CalenderSetup CalenderList = new CalenderSetup(); typeReportSource.TypeName = typeof(CalenderSetup).AssemblyQualifiedName; break; case "Deduction Setup": DeductionMaster DeductionList = new DeductionMaster(); typeReportSource.TypeName = typeof(DeductionMaster).AssemblyQualifiedName; break; case "Employee Class Setup": ClassMaster classMaster = new ClassMaster(); typeReportSource.TypeName = typeof(ClassMaster).AssemblyQualifiedName; break; case "End of Service Master": EOSMaster eOSList = new EOSMaster(); typeReportSource.TypeName = typeof(EOSMaster).AssemblyQualifiedName; break; case "Grade Setup": EOSMaster eOSList1 = new EOSMaster(); typeReportSource.TypeName = typeof(EOSMaster).AssemblyQualifiedName; break; case "Gratuity Setup": GratuitySetup GratuityList = new GratuitySetup(); typeReportSource.TypeName = typeof(GratuitySetup).AssemblyQualifiedName; break; case "Leave Assignment": LeaveMasterMaster LeaveCodeList = new LeaveMasterMaster(); typeReportSource.TypeName = typeof(LeaveMasterMaster).AssemblyQualifiedName; break; case "Leave Type": LeaveMasterMaster LeaveCodeList1 = new LeaveMasterMaster(); typeReportSource.TypeName = typeof(LeaveMasterMaster).AssemblyQualifiedName; break; case "Overtime Setup": OvertimeSetup OvertimeList = new OvertimeSetup(); typeReportSource.TypeName = typeof(OvertimeSetup).AssemblyQualifiedName; break; case "Pay Code Setup": PaycodeMaster PaycodeList = new PaycodeMaster(); typeReportSource.TypeName = typeof(PaycodeMaster).AssemblyQualifiedName; break; case "Position Setup": PositionSetup PositionList = new PositionSetup(); typeReportSource.TypeName = typeof(PositionSetup).AssemblyQualifiedName; break; case "Project Setup": ProjectMaster ProjectList = new ProjectMaster(); typeReportSource.TypeName = typeof(ProjectMaster).AssemblyQualifiedName; break; case "Supervisor Setup": SuperviserSetup SuperviserList = new SuperviserSetup(); typeReportSource.TypeName = typeof(SuperviserSetup).AssemblyQualifiedName; break; case "Transaction Sequence": TransactionSequence TransactionSequenceList = new TransactionSequence(); typeReportSource.TypeName = typeof(TransactionSequence).AssemblyQualifiedName; break; #endregion #region Employee case "Employee Pay Code": EmployeeMonthlySalary employeeMonthlySalary = new EmployeeMonthlySalary(); typeReportSource.TypeName = typeof(EmployeeMonthlySalary).AssemblyQualifiedName; break; case "Employee Address": EmployeeAddresslist employeeAddresslist = new EmployeeAddresslist(); typeReportSource.TypeName = typeof(EmployeeAddresslist).AssemblyQualifiedName; break; case "Employee Card": EmployeeCard employeeCard = new EmployeeCard(); typeReportSource.TypeName = typeof(EmployeeCard).AssemblyQualifiedName; break; case "Employee Contract": EmployeeContractlist employeeContractlist = new EmployeeContractlist(); typeReportSource.TypeName = typeof(EmployeeContractlist).AssemblyQualifiedName; break; case "Employee IBAN": EmployeeIBANChecking employeeIBANChecking = new EmployeeIBANChecking(); typeReportSource.TypeName = typeof(EmployeeIBANChecking).AssemblyQualifiedName; break; case "Employee Master": EmployeeMasterList employeeMasterList = new EmployeeMasterList(); typeReportSource.TypeName = typeof(EmployeeMasterList).AssemblyQualifiedName; break; case "Employee Personal Info": EmployeePersonalinfo employeePersonalinfo = new EmployeePersonalinfo(); typeReportSource.TypeName = typeof(EmployeePersonalinfo).AssemblyQualifiedName; break; //case "Employee Master": // Employeemaster employeePersonalinfo = new EmployeePersonalinfo(); // typeReportSource.TypeName = typeof(EmployeePersonalinfo).AssemblyQualifiedName; // break; #endregion case "BenefitDetailList": BenefitDetailDRL BenefitDetailList = new BenefitDetailDRL(); typeReportSource.TypeName = typeof(BenefitDetailDRL).AssemblyQualifiedName; break; case "BranchList": BranchMaster BranchList = new BranchMaster(); typeReportSource.TypeName = typeof(BranchMaster).AssemblyQualifiedName; break; case "ClassList": ClassMaster ClassList = new ClassMaster(); typeReportSource.TypeName = typeof(ClassMaster).AssemblyQualifiedName; break; case "DeductionWithDetailList": DeductionDetailDRL DeductionWithDetailList = new DeductionDetailDRL(); typeReportSource.TypeName = typeof(DeductionDetailDRL).AssemblyQualifiedName; break; /* case "DeductionDetailList": * * DeductionWithDetailList DeductionDetailList = new DeductionWithDetailList(); * typeReportSource.TypeName = typeof(DeductionWithDetailList).AssemblyQualifiedName; * break; */ case "GratuitywithDetailList": GratuitySetupDRL GratuitywithDetailList = new GratuitySetupDRL(); typeReportSource.TypeName = typeof(GratuitySetupDRL).AssemblyQualifiedName; break; case "GratuityDTLList": GratuitySetupDTL GratuityDTLList = new GratuitySetupDTL(); typeReportSource.TypeName = typeof(GratuitySetupDTL).AssemblyQualifiedName; break; case "GratuityPaycodeList": GratuityPaycode GratuityPaycodeList = new GratuityPaycode(); typeReportSource.TypeName = typeof(GratuityPaycode).AssemblyQualifiedName; break; case "LeavePatternList": LeavePattern LeavePatternList = new LeavePattern(); typeReportSource.TypeName = typeof(LeavePattern).AssemblyQualifiedName; break; case "OvertimeWithDetailList": OvertimeSetupDRL OvertimeWithDetailList = new OvertimeSetupDRL(); typeReportSource.TypeName = typeof(OvertimeSetupDRL).AssemblyQualifiedName; break; case "OvertimeDTLList": OvertimeSetupDTL OvertimeDTLList = new OvertimeSetupDTL(); typeReportSource.TypeName = typeof(OvertimeSetupDTL).AssemblyQualifiedName; break; case "OvertimePaycodeList": OvertimePaycode OvertimePaycodeList = new OvertimePaycode(); typeReportSource.TypeName = typeof(OvertimePaycode).AssemblyQualifiedName; break; #region Leave Transaction Reports case "LeavetransactionbyID": LeaveTrxEntryByID LeaveTransaction = new LeaveTrxEntryByID(); typeReportSource.TypeName = typeof(LeaveTrxEntryByID).AssemblyQualifiedName; break; #endregion } ReportViewer1.ReportSource = typeReportSource; ReportViewer1.RefreshReport(); }
// call report with reportname and id param void callreport(string RequestId, string Reportname) { Telerik.Reporting.InstanceReportSource typeInstanceSource = new Telerik.Reporting.InstanceReportSource(); Telerik.Reporting.TypeReportSource typeReportSource = new Telerik.Reporting.TypeReportSource(); string reportname; reportname = Reportname; switch (reportname) { #region Transaction case "LeaveTrxEntryByID": LeaveTrxEntryByID LeaveTransaction = new LeaveTrxEntryByID(); typeReportSource.TypeName = typeof(LeaveTrxEntryByID).AssemblyQualifiedName; typeReportSource.Parameters.Add("ID", RequestId); break; case "ReimbursTrxEntryByID": ReimbursTrxEntryByID reimbursTrxEntryByID = new ReimbursTrxEntryByID(); typeReportSource.TypeName = typeof(ReimbursTrxEntryByID).AssemblyQualifiedName; typeReportSource.Parameters.Add("RecordID", RequestId); break; case "ReimbursmentT2byID": ebPayrollReports.Transactions.ID.ReimbursmentT2byID ReimbursmentT2byID = new ebPayrollReports.Transactions.ID.ReimbursmentT2byID(); typeReportSource.TypeName = typeof(ebPayrollReports.Transactions.ID.ReimbursmentT2byID).AssemblyQualifiedName; typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("RecordID", RequestId)); break; case "TimeSheetbyProject2": //var report = new ebPayrollReports.Transactions.Form.TimeSheetbyProject(); //typeInstanceSource.ReportDocument = report; //this.ReportViewer1.ReportSource = typeInstanceSource; //report.ReportParameters[0].Value = RequestId; ebPayrollReports.Transactions.Form.TimeSheetbyProject f = new ebPayrollReports.Transactions.Form.TimeSheetbyProject(); break; case "TimeSheetbyProject": var report = new ebPayrollReports.Transactions.Form.TimeSheetbyProject(); typeInstanceSource.ReportDocument = report; this.ReportViewer1.ReportSource = typeInstanceSource; report.ReportParameters[0].Value = RequestId; break; case "TimeSheetbyProjectLogs": var report2 = new ebPayrollReports.Transactions.Form.TimeSheetProjectLogs(); typeInstanceSource.ReportDocument = report2; this.ReportViewer1.ReportSource = typeInstanceSource; report2.ReportParameters[0].Value = RequestId; break; #endregion } ReportViewer1.RefreshReport(); }
private void PrintProtocolls(List <TravelExpense> travelExpensesToBeMoved) { List <int> idList = new List <int>(); foreach (TravelExpense item in travelExpensesToBeMoved) { idList.Add(item.Id); if (CreateFiles) { TravelExpense newItem = dbAccess.SetProvidedToDatev(item); if (item == null) { NotificationRequest.Raise(new Notification() { Title = "QuantCo Deutschland GmbH", Content = $"Beim Setzen des Datums 'ProvidedToDatev' ({item.Id} ist ein Fehler aufgetreten" }); } else { // reload travelexpenses to show the updates made in SetProvidedToDatev travelExpenses.Clear(); travelExpenses = new ObservableCollection <TravelExpense>(dbAccess.GetAllTravelExpenses()); ListOfTravelExpenses = CollectionViewSource.GetDefaultView(travelExpenses); ListOfTravelExpenses.CurrentChanged -= ListOfTravelExpenses_CurrentChanged; ListOfTravelExpenses.CurrentChanged += ListOfTravelExpenses_CurrentChanged; RaisePropertyChanged("ListOfTravelExpenses"); if (travelExpenses.Count > 0) { selectedItem = travelExpenses[0]; } } } } if (ShowReport) { TypeReportSource source = new TypeReportSource(); source.TypeName = typeof(AccountingHelper.Reporting.TravelExpenses).AssemblyQualifiedName; source.Parameters.Add("TravelExpenseIds", idList); ViewerParameter parameter = new ViewerParameter() { typeReportSource = source }; eventaggregator.GetEvent <ViewerParameterEvent>().Publish(parameter); } if (CreateFiles) { // create Report as pdf file var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor(); // set any deviceInfo settings if necessary var deviceInfo = new System.Collections.Hashtable(); var reportSource = new Telerik.Reporting.TypeReportSource(); // reportName is the Assembly Qualified Name of the report reportSource.TypeName = typeof(AccountingHelper.Reporting.TravelExpenses).AssemblyQualifiedName; // Pass parameter value with the Report Source if necessary reportSource.Parameters.Add("TravelExpenseIds", idList); Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo); using (System.IO.FileStream fs = new System.IO.FileStream(Path.Combine(csvFolder, "ProtokollReisekosten.pdf"), System.IO.FileMode.Create)) { fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length); } } }
private void TaxableIncomeSendEmailsToEmployees() { List <int> employeeList = dbAccess.GetEmployeeIdsForOpenTaxableIncome(); foreach (int employeeId in employeeList) { EmployeesForTravelExpenses employee = dbAccess.FindEmployeeById(employeeId); if (employee == null) { continue; } if (string.IsNullOrEmpty(employee.EmailAddress)) { continue; } // Render Report var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor(); // set any deviceInfo settings if necessary var deviceInfo = new System.Collections.Hashtable(); var reportSource = new Telerik.Reporting.TypeReportSource(); // reportName is the Assembly Qualified Name of the report reportSource.TypeName = typeof(AccountingHelper.Reporting.TaxableIncomeByEmployee).AssemblyQualifiedName; // Pass parameter value with the Report Source if necessary reportSource.Parameters.Add("EmployeeId", employeeId); Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo); // set Directory to Root/Datev/TaxableIncomeReports/ and Filename: Fullname + "Taxable Income" + Date string taxableIncomeFileName = Path.Combine(Properties.Settings.Default.RootDirectory, Properties.Settings.Default.DatevDirectory, "TaxableIncomeReports", $"{employee.FullName} TaxableIncome {DateTime.Now:d}.pdf"); using (System.IO.FileStream fs = new System.IO.FileStream(taxableIncomeFileName, System.IO.FileMode.Create)) { fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length); } // prepare Email SendEmailClass sendEmail = new SendEmailClass(); sendEmail.Subject = "Besteuerung von geldwerten Vorteilen "; sendEmail.ToAddress = employee.EmailAddress; sendEmail.Attachments.Add(taxableIncomeFileName); sendEmail.Body = $"Lieber {employee.FullName},{System.Environment.NewLine} {System.Environment.NewLine} als Anlage erhältst Du eine Liste der geldwerten Vorteile, die in Kürze versteuert werden. " + $"{System.Environment.NewLine} {System.Environment.NewLine} Mit freundlichen Grüßen {System.Environment.NewLine} {System.Environment.NewLine} QuantCo Deutschland GmbH"; bool success = sendEmail.SendEmailToServer(); if (!success) { NotificationRequest.Raise(new Notification() { Title = "QuantCo Deutschland GmbH", Content = $"Das Email an {sendEmail.ToAddress} konnte nicht gesendet werden" }); } //MailItem mailItem = outlookApp.CreateItem(OlItemType.olMailItem); //mailItem.BodyFormat = OlBodyFormat.olFormatHTML; //mailItem.SendUsingAccount = outlookUsingAccount; //mailItem.Subject = "Besteuerung von geldwerten Vorteilen "; //Recipient recipTo = mailItem.Recipients.Add(employee.EmailAddress); //recipTo.Type = (int)OlMailRecipientType.olTo; //if (!mailItem.Recipients.ResolveAll()) //{ // NotificationRequest.Raise(new Notification() // { // Title = "QuantCo Deutschland GmbH", // Content = $"Die E-Mail Adresse für {employee.FullName} ist ungültig" // }); // continue; //} //mailItem.Body = $"Lieber {employee.FullName},{System.Environment.NewLine} {System.Environment.NewLine} als Anlage erhältst Du eine Liste der geldwerten Vorteile, die in Kürze versteuert werden. " + // $"{System.Environment.NewLine} {System.Environment.NewLine} Mit freundlichen Grüßen {System.Environment.NewLine} {System.Environment.NewLine} QuantCo Deutschland GmbH"; // mailItem.Attachments.Add(taxableIncomeFileName, OlAttachmentType.olByValue); //mailItem.Save(); } }
private void OnPrepareTaxableExpenses() { List <int> employeeList = dbAccess.GetEmployeeIdsForOpenTaxableIncome(); if (employeeList.Count == 0) { NotificationRequest.Raise(new Notification() { Title = "QuantCo Deutschland GmbH", Content = "Es sind keine Datensätze vorhanden, die noch nicht versendet wurden" }); return; } TypeReportSource source = new TypeReportSource(); source.TypeName = typeof(AccountingHelper.Reporting.TaxableIncomeReport).AssemblyQualifiedName; ViewerParameter parameter = new ViewerParameter() { typeReportSource = source }; eventaggregator.GetEvent <ViewerParameterEvent>().Publish(parameter); #region Save Report as File // pdf Datei erzeugen und in Datev speichern // specify foldername .../Datev/TaxableIncomeReports/Report yyyyMMdd string foldername = Path.Combine(Properties.Settings.Default.RootDirectory, Properties.Settings.Default.DatevDirectory, "TaxableIncomeReports"); Directory.CreateDirectory(foldername); string filename = $"Report {DateTime.Now.Date:yyyyMMdd}.pdf"; filename = Path.Combine(foldername, filename); // create Report as pdf file var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor(); // set any deviceInfo settings if necessary var deviceInfo = new System.Collections.Hashtable(); var reportSource = new Telerik.Reporting.TypeReportSource(); // reportName is the Assembly Qualified Name of the report reportSource.TypeName = typeof(AccountingHelper.Reporting.TaxableIncomeReport).AssemblyQualifiedName; Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo); using (System.IO.FileStream fs = new System.IO.FileStream(filename, System.IO.FileMode.Create)) { fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length); } #endregion #region Send File To Taxadvisor // send file to taxAdvisor // prepare Email SendEmailClass sendEmail = new SendEmailClass(); sendEmail.Subject = "Besteuerung von geldwerten Vorteilen "; sendEmail.ToAddress = Properties.Settings.Default.BdoHr; sendEmail.Attachments.Add(filename); sendEmail.Body = $"Sehr geehrte Damen und Herren,{System.Environment.NewLine} {System.Environment.NewLine} als Anlage erhalten Sie eine Aufstellung über die geldwerten Vorteile aus den Reisekostenabrechnungen. " + $"{System.Environment.NewLine} {System.Environment.NewLine} Mit freundlichen Grüßen {System.Environment.NewLine} {System.Environment.NewLine} QuantCo Deutschland GmbH"; bool success = sendEmail.SendEmailToServer(); if (!success) { NotificationRequest.Raise(new Notification() { Title = "QuantCo Deutschland GmbH", Content = $"Das Email an {sendEmail.ToAddress} konnte nicht gesendet werden" }); } //MailItem mailItem = outlookApp.CreateItem(OlItemType.olMailItem); //mailItem.BodyFormat = OlBodyFormat.olFormatHTML; //mailItem.SendUsingAccount = outlookUsingAccount; //mailItem.Subject = "Besteuerung von geldwerten Vorteilen "; //string BdoHr = Properties.Settings.Default.BdoHr; //string[] emails = BdoHr.Split(';'); //foreach (string email in emails) //{ // Recipient recipTo = mailItem.Recipients.Add(email); // recipTo.Type = (int)OlMailRecipientType.olTo; //} //if (!mailItem.Recipients.ResolveAll()) //{ // NotificationRequest.Raise(new Notification() // { // Title = "QuantCo Deutschland GmbH", // Content = $"Die E-Mail-Adressen '{BdoHr}' enthalten mindestens einen falschen Eintrag" // }); //} //else //{ // mailItem.Body = $"Sehr geehrte Damen und Herren,{System.Environment.NewLine} {System.Environment.NewLine} als Anlage erhalten Sie eine Aufstellung über die geldwerten Vorteile aus den Reisekostenabrechnungen. " + // $"{System.Environment.NewLine} {System.Environment.NewLine} Mit freundlichen Grüßen {System.Environment.NewLine} {System.Environment.NewLine} QuantCo Deutschland GmbH"; // mailItem.Attachments.Add(filename, OlAttachmentType.olByValue); // mailItem.Save(); //} #endregion ConfirmationRequest.Raise(new Confirmation() { Title = "QuantCo Deutschland GmbH", Content = "Sollen die Einträge als 'gesendet' gekennzeichnet werden? " }, response => { if (response.Confirmed) { // send Emails to Employees TaxableIncomeSendEmailsToEmployees(); // mark records as sent int nrOfAmendments = dbAccess.SetProvidedToTaxableIncome(); NotificationRequest.Raise(new Notification() { Title = "QuantCo Deutschland GmbH", Content = $"Es wurden {nrOfAmendments} Datensätze geändert." }); } }); }
private void OnPayrollCost() { //TypeReportSource source = new TypeReportSource(); //source.TypeName = typeof(AccountingHelper.Reporting.MonthlySalary).AssemblyQualifiedName; //source.Parameters.Add("EndDate", reportDate); //source.Parameters.Add("StartDate", new DateTime(reportDate.Year, reportDate.Month, 1)); //source.Parameters.Add("MonthYear", $"{reportDate: MMMM yyyy}"); // new Version of MonthlySalary DateTime reportDate = timeFunctions.MonthEnd(timeFunctions.MonthEnd(MonthlySalaryDate)); CreateEmployeeSalaryOverview salaryOverview = new CreateEmployeeSalaryOverview(null, new DateTime(reportDate.Year, 1, 1), reportDate); List <EmployeesMonthlyPayments> monthlyPayments = salaryOverview.GetMonthlyPayments(reportDate.Month); JsonSerializerSettings settings = new JsonSerializerSettings(); settings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; settings.MissingMemberHandling = MissingMemberHandling.Ignore; string jsonContent = JsonConvert.SerializeObject(monthlyPayments, settings); string jsonfile = $"C:\\Users\\Public\\Documents\\MonthlyOverview.json"; System.IO.File.WriteAllText(jsonfile, jsonContent); Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor(); // set any deviceInfo settings if necessary var deviceInfo = new System.Collections.Hashtable(); var reportSource = new Telerik.Reporting.TypeReportSource(); // reportName is the Assembly Qualified Name of the report reportSource.TypeName = typeof(AccountingHelper.Reporting.MonthlySalaryOverview).AssemblyQualifiedName; // Pass parameter value with the Report Source if necessary reportSource.Parameters.Add("Source", jsonfile); reportSource.Parameters.Add("DataSelector", string.Empty); Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("XLSX", reportSource, deviceInfo); string xlsxFile = jsonfile.Replace("json", "xlsx"); using (System.IO.FileStream fs = new System.IO.FileStream(xlsxFile, System.IO.FileMode.Create)) { fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length); } ConfirmationRequest.Raise(new Confirmation() { Content = $"Es wurde eine Excel-Datei ({xlsxFile}) erstellt" + Environment.NewLine + Environment.NewLine + "Soll die Excel-Datei als E-Mail verschickt werden?", Title = "QuantCo Deutschland GmbH" }, response => { if (response.Confirmed) { // send E-mail to Property 'CEOto' SendEmailToCEO(xlsxFile); } }); ViewerParameter parameter = new ViewerParameter() { typeReportSource = reportSource }; eventAggregator.GetEvent <ViewerParameterEvent>().Publish(parameter); }