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