/// <summary> /// Creates PDF reports and saves them as a PDF file /// </summary> public static void GeneratePdfReport() { File.Delete(PdfPath + PdfFileName); var repo = new MSSqlRepository(); var pdfData = repo.GetDataForPdfExport(); var doc = new Document(); PdfWriter.GetInstance(doc, new FileStream(PdfPath + PdfFileName, FileMode.Create)); doc.Open(); PdfPTable table = new PdfPTable(RowCountInPdfExport); table.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table.DefaultCell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; var headerBackground = new BaseColor(204, 204, 204); PdfPCell headerCell = new PdfPCell(new Phrase("Sample PDF Export From the Football Manager")); headerCell.Colspan = RowCountInPdfExport; headerCell.Padding = 10f; headerCell.HorizontalAlignment = 1; headerCell.BackgroundColor = headerBackground; table.AddCell(headerCell); string[] col = { "Date", "Staduim", "Home Team", "Away Team", "Result" }; for (int i = 0; i < col.Length; ++i) { PdfPCell columnCell = new PdfPCell(new Phrase(col[i])); columnCell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; columnCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; columnCell.BackgroundColor = headerBackground; table.AddCell(columnCell); } foreach (var item in pdfData) { PdfPCell townCell = new PdfPCell(new Phrase(item.Key)); townCell.Colspan = RowCountInPdfExport; townCell.Padding = 10f; table.AddCell(townCell); foreach (var match in item.Value) { table.AddCell(match.Date.Day + "." + match.Date.Month + "." + match.Date.Year); table.AddCell(match.Stadium); table.AddCell(match.HomeTeam); table.AddCell(match.AwayTeam); table.AddCell(match.Result); } } doc.Add(table); doc.Close(); Process.Start(PdfPath); }
/// <summary> /// Creates all JSON reports and save them in text file /// </summary> public static void JsonCreateReports() { var repo = new MSSqlRepository(); var teamReports = repo.GetTeamReport(); foreach (var report in teamReports) { SaveReport(report, report.Name); } Process.Start(SaveFilePath); }
private async void CreateSqlServerDb_Click(object sender, EventArgs e) { var repo = new MSSqlRepository(); try { await repo.CreateDb(); MessageBox.Show( "The db is created", "Db creation", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { // Find appropriate exception var exmes = ex.Message; } }
private void FillDatFromZip_Click(object sender, EventArgs e) { var openFileDialog = new OpenFileDialog(); var repo = new MSSqlRepository(); try { if (openFileDialog.ShowDialog() == DialogResult.OK) { var filePath = openFileDialog.FileName; var zip = ZipFile.Open(filePath, ZipArchiveMode.Read); using (zip) { var teams = Utilities.ExcelUtils.GetAllPlayers(zip); repo.FillPlayersFromZip(teams); } } MessageBox.Show( "The players are inserted", "Players insert", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (IOException) { MessageBox.Show( "Error reading file!", "Players insert", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void GenerateXmlReport_btn_Click(object sender, EventArgs e) { try { var repo = new MSSqlRepository(); XmlUtils.XmlCreateReports(repo.GetStadiumReport()); // Write logic here MessageBox.Show( "The XML report for stadiums", "Stadiums report generated!", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception) { // Find appropriate exception MessageBox.Show( "Something bad happened", "Fatal Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); } }
private void FillFromXml_btn_Click(object sender, EventArgs e) { var repo = new MSSqlRepository(); var ctx = new FootballContext(); var xmlToDtoConverter = new XmlToDtoMatchConverter(XmlMatchesPath); var dtoToMatchModelConverter = new DtoMatchToDbMatchConverter(xmlToDtoConverter, ctx); var matches = dtoToMatchModelConverter.GetAllMatches(); try { repo.FillMatchesFromXml(matches); MessageBox.Show( "The matches are inserted", "Matches insert", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception) { // Find appropriate exception MessageBox.Show( "Something bad happened", "Fatal Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); } }