public static string GetFechasJornadas(int eventoId) { DBTransaction db = new DBTransaction(); DataTable dt = db.GetDataView(string.Format("[fFechasJornada] ({0})", eventoId)); string fechas = string.Empty; foreach (DataRow dr in dt.Rows) { if (string.IsNullOrEmpty(fechas)) { fechas = string.Format(DBGlobalization.GetCultureInfo(), "{0:dd}", dr[0]); } else { fechas = string.Format(DBGlobalization.GetCultureInfo(), "{0},{1:dd}", fechas, dr[0]); } } if (dt.Rows.Count > 0) { fechas = string.Format("{0} de {1:MMMM}", fechas, dt.Rows[0][0]); } return(fechas); }
private static void SetHead(string jornada, string categoria, string descEvento, string lugarEvento, int eventoId) { float legalMarginWidth = ItextUtils.CentimetersToPoints(33.02F); float legalMarginHeight = ItextUtils.CentimetersToPoints(21.59F); float marginLeft = ItextUtils.CentimetersToPoints(1); float marginRight = ItextUtils.CentimetersToPoints(1); float marginTop = ItextUtils.CentimetersToPoints(1); float marginBottom = ItextUtils.CentimetersToPoints(4); documentPdf = new Document(); documentPdf.SetPageSize(PageSize.LETTER.Rotate()); documentPdf.SetMargins(marginLeft, marginRight, marginTop, marginBottom); //Segir buscando como cambiarl la funte de las letras de todo el doc //documentPdf PdfWriter writer = PdfWriter.GetInstance(documentPdf, new FileStream(path, FileMode.Create)); HeaderGolf header = new HeaderGolf(); header.Titulo = lugarEvento; header.TituloIdioma = "Casa de Campo Cochabamba"; header.SubTitulo = descEvento; header.Deporte = "golf"; header.HasLeyenda = true; header.Jornada = jornada; header.Categoria = categoria; header.User = "******"; header.NombreReporte = "ListadoEquipos"; header.LogoDerecha = Image.GetInstance(string.Format(@"{0}\Golf\golf.png", pathImage)); header.LogoIzquierda = Image.GetInstance(string.Format(@"{0}\Golf\Federacion.png", pathImage)); header.LogoAbajoDerecha = Image.GetInstance(string.Format(@"{0}\Hammer\marcaDoble.png", pathImage)); header.LogoAbajoIzquierda = Image.GetInstance(string.Format(@"{0}\Hammer\hammerLogoH.png", pathImage)); string fechas = string.Empty; foreach (DateTime item in GolfJornada.GetGolfJornadasFechas(eventoId)) { if (string.IsNullOrEmpty(fechas)) { fechas = string.Format(DBGlobalization.GetCultureInfo(), "{0:dd}", item); } else { fechas = string.Format(DBGlobalization.GetCultureInfo(), "{0},{1:dd}", fechas, item); } } header.Fecha = fechas; PdfPTable leyen = new PdfPTable(new float[] { 3, 1, 3, 1, 3, 1, 3, 1, 3, 1, 3, 1, 3, 1 }); leyen.AddCell(DrawTable.DrawCell("Leyenda", 6, CellBorder.NONE, CellAlignment.Left, 14, CellFontStyle.Bold)); leyen.AddCell(DrawTable.DrawCellHeader("Hoyo en Uno", 5, CellBorder.UNDEFINED, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, BaseColor.WHITE)); leyen.AddCell(DrawTable.DrawCellHeader(string.Empty, 5, CellBorder.BOX, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, BaseColor.YELLOW)); leyen.AddCell(DrawTable.DrawCellHeader("Albatros", 5, CellBorder.UNDEFINED, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, BaseColor.WHITE)); leyen.AddCell(DrawTable.DrawCellHeader(string.Empty, 5, CellBorder.BOX, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, new BaseColor(192, 119, 160))); leyen.AddCell(DrawTable.DrawCellHeader("Eagle", 5, CellBorder.UNDEFINED, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, BaseColor.WHITE)); leyen.AddCell(DrawTable.DrawCellHeader(string.Empty, 5, CellBorder.BOX, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, new BaseColor(248, 177, 17))); leyen.AddCell(DrawTable.DrawCellHeader("Birdie", 5, CellBorder.UNDEFINED, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, BaseColor.WHITE)); leyen.AddCell(DrawTable.DrawCellHeader(string.Empty, 5, CellBorder.BOX, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, new BaseColor(35, 190, 82))); leyen.AddCell(DrawTable.DrawCellHeader("PAR", 5, CellBorder.UNDEFINED, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, BaseColor.WHITE)); leyen.AddCell(DrawTable.DrawCellHeader(string.Empty, 5, CellBorder.BOX, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, BaseColor.WHITE)); leyen.AddCell(DrawTable.DrawCellHeader("Bogey", 5, CellBorder.UNDEFINED, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, BaseColor.WHITE)); leyen.AddCell(DrawTable.DrawCellHeader(string.Empty, 5, CellBorder.BOX, CellAlignment.Right, CellAlignment.Center, CellFontStyle.Bold, new BaseColor(92, 119, 229))); leyen.AddCell(DrawTable.DrawCellHeader("Doble Bogey o más", 5, CellBorder.UNDEFINED, CellAlignment.Center, CellAlignment.Center, CellFontStyle.Bold, BaseColor.WHITE)); leyen.AddCell(DrawTable.DrawCellHeader(string.Empty, 5, CellBorder.UNDEFINED, CellAlignment.Right, CellAlignment.Buttom, CellFontStyle.Normal, new BaseColor(237, 62, 48))); header.leyendas = leyen; writer.PageEvent = header; documentPdf.Open(); }