private static void Main() { System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); Stopwatch sw = new Stopwatch(); var noOfIterations = TotalRecords / noOfRecordsPerFile; for (var i = 0; i < noOfIterations; i++) { var reportService = new ReportPdf(); sw.Restart(); var reportData = CreateReportData(); var path = GetTempPdfPath(); reportService.Export(path, reportData); sw.Stop(); Console.WriteLine("Time taken" + sw.Elapsed.TotalSeconds); //Process.Start(path); } sw.Reset(); sw.Start(); Console.WriteLine(); ReportPdf.CombinePDFs(@"D:\APDFData", "ConcatenatedDocument1_tempfile.pdf"); sw.Stop(); Console.WriteLine("Time taken to combine the pdf" + sw.Elapsed.TotalSeconds); Console.ReadLine(); }
private static void Main() { Stopwatch sw = new Stopwatch(); var noOfIterations = TotalRecords / noOfRecordsPerFile; for (var i = 0; i < noOfIterations; i++) { var reportService = new ReportPdf(); sw.Restart(); var reportData = CreateReportData(); var path = GetTempPdfPath(); reportService.Export(path, reportData); sw.Stop(); Console.WriteLine("Time taken" + sw.Elapsed.TotalSeconds); Process.Start(path); } sw.Reset(); sw.Start(); Console.WriteLine(); ReportPdf.CombinePDFs(@"D:\GeneratedPDF", "ConcatenatedDocument1_tempfile.pdf"); sw.Stop(); Console.WriteLine("Time taken to combine the pdf" + sw.Elapsed.TotalSeconds); Console.ReadLine(); }
private static void Main() { var reportService = new ReportPdf(); var reportData = CreateReportData(); var path = GetTempPdfPath(); reportService.Export(path, reportData); Process.Start(path); }
private void PrintButtonClicked(object sender, RoutedEventArgs e) { var reportService = new ReportPdf(); var reportData = CreateReportData(); var path = GetTempPdfPath(); reportService.Export(path, reportData); Process.Start(path); }
public void TestePdfExport() { string daten = File.ReadAllText($"{System.AppDomain.CurrentDomain.BaseDirectory}\\TestDaten\\2019_Landesliga_RCA-Bayreuth_vs_ASV-Hof.json"); MannschaftskampfViewModel testMannschaftskampfViewModel = new MannschaftskampfViewModel(JObject.Parse(daten), null); var zusatzInfos = GetDemoZusatzInfos(); //TODO Löschen, sobald wirklich Punkte hinterlegt sind Random rnd = new Random(); int cnt = 0; foreach (Bout bout in testMannschaftskampfViewModel.Children) { for (int i = 0; i < rnd.Next(1, 10); i++) { var ringer = (rnd.Next(1, 3) == 1 ? Core.CS.BoutPoint.Wrestler.Home : Core.CS.BoutPoint.Wrestler.Opponent); var zeit = new DateTime( testMannschaftskampfViewModel.BoutDateDateTime.Year, testMannschaftskampfViewModel.BoutDateDateTime.Month, testMannschaftskampfViewModel.BoutDateDateTime.Day, testMannschaftskampfViewModel.ScaleTime.Hours, testMannschaftskampfViewModel.ScaleTime.Minutes + cnt + i + 4, rnd.Next(1, 59) ); bout.Points.Add(new Core.CS.BoutPoint(rnd.Next(1, 5).ToString(), null, ringer, zeit)); } cnt++; } Random random = new Random(); string filename = $"Test_{random.Next()}.pdf"; IReport bericht = new ReportPdf(); bericht.Export(filename, testMannschaftskampfViewModel, zusatzInfos); Process.Start(filename);//Öffne PDF }
public void SendReport(PartnerModel model) { var reportService = new ReportPdf(); string startDate = DateTime.Now.AddDays(-2).ToString("MM/dd/yyyy"); string endDate = DateTime.Now.AddDays(-1).ToString("MM/dd/yyyy"); List <ALMParnterSearchModelsData> listData = new List <ALMParnterSearchModelsData>(); var yesterDayDate = DateTime.Now.AddDays(-1).ToString("MM-dd-yyyy"); // string partnerData = "select PolicyDetail.PolicyNumber as PolicyNumber, PartnerCommissions.CommissionPercentage ,Branch.BranchName as BranchName, convert(varchar, PolicyDetail.CreatedOn, 106) as CreatedOn , PaymentInformation.PaymentId, VehicleDetail.Premium,cast(VehicleDetail.Premium * PartnerCommissions.CommissionPercentage as decimal(10, 2)) as Comission_Amount, Customer.ALMId from PolicyDetail join Customer on Customer.Id = PolicyDetail.CustomerId join VehicleDetail on VehicleDetail.PolicyId = PolicyDetail.Id join PaymentInformation on PaymentInformation.PolicyId = PolicyDetail.Id join Branch on VehicleDetail.ALMBranchId = Branch.Id join Partners on Partners.Id = Branch.PartnerId join PartnerCommissions on CommissionEffectiveDate <= PolicyDetail.CreatedOn and PartnerCommissions.PartnerId = branch.PartnerId where PolicyDetail.CreatedOn BETWEEN '" + startDate + "' AND '" + endDate + "' and branch.PartnerId=" + model.Id; string partnerData = "select PolicyDetail.PolicyNumber as PolicyNumber, Branch.BranchName as BranchName, "; partnerData += " convert(varchar, PolicyDetail.CreatedOn, 106) as CreatedOn, PaymentInformation.PaymentId, VehicleDetail.Premium, "; partnerData += " cast(VehicleDetail.Premium * ( select top 1 CommissionPercentage from PartnerCommissions as b where PartnerId=" + model.Id + " and b.CommissionEffectiveDate<= PolicyDetail.CreatedOn "; partnerData += " or b.CommissionEffectiveDate < (select top 1 CommissionEffectiveDate from PartnerCommissions where b.Id = b.Id+1 )) as decimal(10, 2)) as Comission_Amount, "; partnerData += " Customer.ALMId from PolicyDetail join Customer on Customer.Id = PolicyDetail.CustomerId join VehicleDetail on VehicleDetail.PolicyId = PolicyDetail.Id "; partnerData += " join PaymentInformation on PaymentInformation.PolicyId = PolicyDetail.Id join Branch on VehicleDetail.ALMBranchId = Branch.Id "; partnerData += " join Partners on Partners.Id = Branch.PartnerId where convert(varchar,PolicyDetail.CreatedOn,110)=convert(varchar,'" + yesterDayDate + "',110) and branch.PartnerId=" + model.Id; // convert(varchar(5),PolicyDetail.CreatedOn,110)=convert(varchar(5),getdate(),110) Library.WriteErrorLog("Query: " + partnerData); using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); SqlCommand com = new SqlCommand(partnerData); com.CommandType = CommandType.Text; com.Connection = con; using (SqlDataReader reader = com.ExecuteReader()) { if (reader.Read()) { ALMParnterSearchModelsData data = new ALMParnterSearchModelsData(); data.BranchName = reader["BranchName"] == null ? "" : Convert.ToString(reader["BranchName"]); data.PolicyNumber = reader["PolicyNumber"] == null ? "" : Convert.ToString(reader["PolicyNumber"]); listData.Add(data); } } } StructureSet structureSet = new StructureSet { Id = model.PartnerName + " ALM Daily Report ", Structures = listData.ToArray() }; var reportData = CreateReportData(model, structureSet); var path = GetTempPdfPath(); reportService.Export(path, reportData); //TODO list of Partners to recive emails var FromMailAddress = System.Configuration.ConfigurationManager.AppSettings["SendEmailFrom"].ToString(); var password = System.Configuration.ConfigurationManager.AppSettings["SendEmailFromPassword"].ToString(); var smtpAddress = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["SendEmailSMTP"]); MailMessage mail = new MailMessage(); mail.From = new MailAddress(FromMailAddress); mail.To.Add("*****@*****.**"); mail.Subject = "ALM Partner Daily Report "; mail.Body = "Please check attached file."; System.Net.Mail.Attachment attachment; attachment = new System.Net.Mail.Attachment(path); attachment.Name = "ALM Partner Daily Report"; mail.Attachments.Add(attachment); var smtp = new System.Net.Mail.SmtpClient(); { smtp.Host = smtpAddress; smtp.Port = 587; smtp.EnableSsl = true; smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network; smtp.Credentials = new System.Net.NetworkCredential(FromMailAddress, password); } smtp.Send(mail); }