public Object GetGolfJornadas(int eventoDeportivoId) { Datos data = new Datos(); data.data = GolfJornada.GetGolfJornadas(eventoDeportivoId); return(data); }
public Object GetGolfJornada(int jornadaId) { Datos data = new Datos(); data.data = GolfJornada.GetGolfJornada(jornadaId); return(data); }
public HttpResponseMessage GetRptListadoGolf(int eventoId, int jornadaId, int categoriaId, string jornada, string categoria) { DataTable dtLista = GolfJornada.GetLista(Convert.ToInt32(jornadaId), Convert.ToInt32(categoriaId)); DataTable dtHoyos = GolfHoyoPar.GetGolfHoyoPar((int)HoyoPar.Hoyo); string pathResources = WebApiApplication.ApplicationResources; string ruta = RptListadoGolf.ReporteListado(dtLista, dtHoyos, jornada, categoria, eventoId, pathResources); return(getReportePDF(ruta)); }
private static void SetHead(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); documentPdf.SetMargins(marginLeft, marginRight, marginTop, marginBottom); 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 = "todas"; header.Categoria = categoria; header.User = "";// user.Username; header.NombreReporte = "Resultados Finales."; header.LogoDerecha = Image.GetInstance(string.Format(@"{0}\Golf\{1}", pathImage, "golf.png")); header.LogoIzquierda = Image.GetInstance(string.Format(@"{0}\Golf\{1}", pathImage, "Federacion.png")); header.LogoAbajoDerecha = Image.GetInstance(string.Format(@"{0}\Hammer\{1}", pathImage, "marcaDoble.png")); header.LogoAbajoIzquierda = Image.GetInstance(string.Format(@"{0}\Hammer\{1}", pathImage, "hammerLogoH.png")); header.Fecha = GolfJornada.GetFechasJornadas(eventoid); 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(); }
public HttpResponseMessage GetDetallePersonaCompetidor(int personaId, int eventoId, string categoriaName) { List <GolfJornada> list = GolfJornada.GetGolfJornadas(Convert.ToInt32(eventoId)); string ids = string.Empty; foreach (GolfJornada item in list) { if (string.IsNullOrEmpty(ids)) { ids = item.JornadaId.ToString(); } else { ids = string.Format("{0},{1}", ids, item.JornadaId); } } DataTable dtDatosPersonales = GolfCompetidor.GetGolfCompetidorByPersonaId(personaId); string pathResources = WebApiApplication.ApplicationResources; string path = GolfCompetidorReport.ReporteResultadosCompetidor(dtDatosPersonales, eventoId, categoriaName, ids, personaId, pathResources); return(getReportePDF(path)); }
private static void SetHead(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); 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 = false; header.Jornada = "todas"; header.Categoria = categoria; header.User = "";// user.Username; header.NombreReporte = "Resultados Finales."; header.LogoDerecha = Image.GetInstance(string.Format(@"{0}\Golf\{1}", pathImage, "golf.png")); header.LogoIzquierda = Image.GetInstance(string.Format(@"{0}\Golf\{1}", pathImage, "Federacion.png")); header.LogoAbajoDerecha = Image.GetInstance(string.Format(@"{0}\Hammer\{1}", pathImage, "marcaDoble.png")); header.LogoAbajoIzquierda = Image.GetInstance(string.Format(@"{0}\Hammer\{1}", pathImage, "hammerLogoH.png")); header.Fecha = GolfJornada.GetFechasJornadas(eventoid); writer.PageEvent = header; documentPdf.Open(); }
public static string ReporteJornadaInscritos(DataTable dtInscritos, string pathSendet, int eventoid, int categoriaId, int jornadaId) { try { pathResource = pathSendet; fileName = string.Format("Jornadas=){0:yyMMdd_HHmmss}.pdf", DateTime.Now); path = string.Format(@"{0}\Reportes\{1}", pathResource, fileName); pathImage = string.Format(@"{0}\Images\", pathResource); DataTable dt = EventoDeportivo.GetEventoName(eventoid); HeaderGolf header = new HeaderGolf(); header.Titulo = dt.Rows.Count > 0 ? dt.Rows[0]["Nombre"].ToString().ToUpper() : ""; header.TituloIdioma = ""; header.SubTitulo = dt.Rows.Count > 0 ? dt.Rows[0]["Ubicacion"].ToString().ToUpper() : ""; header.Categoria = categoriaId == 0 ? "Todos" : GolfCategoria.GetGolCategoria(categoriaId).Descripcion; header.Fecha = GolfJornada.GetFechasJornadas(eventoid); var jornada = GolfJornada.GetGolfJornada(jornadaId); header.Jornada = jornadaId == 0? "Todos" : jornada.Descripcion; SetHead(header); //dtInscritos.Columns.Remove("PersonaId"); SetBody(dtInscritos, header.Titulo, jornada.Descripcion, jornada.Fecha?.ToString("dd MMM yyyy")); dt.Dispose(); return(path); } catch (Exception ex) { throw (ex); } finally { SetFooter(); } }
public DataTable GetGolfNroJornadas(int eventoId) { return(GolfJornada.GetNroJornadas(eventoId)); }
public DataTable GetGolfListaSHCP(int jornadaId, int categoriaId) { return(GolfJornada.GetListaSHCP(jornadaId, categoriaId)); }
public DataTable GetEquiposJornada(int EventoId, int PruebaEventoId, int par) { return(GolfJornada.getEquiposResultados(EventoId, PruebaEventoId, par)); }
public string GetGolfJornadasFechas(int eventoDeportivoId) { List <DateTime> ls = GolfJornada.GetGolfJornadasFechas(eventoDeportivoId); return(string.Format("Del {0:dd MMMM} al {1:dd MMMM} {1:yyyy}", ls[0], ls[ls.Count - 1])); }
public bool SaveGolfJornada([FromBody] GolfJornada jornada) { return(jornada.Save()); }
public bool DeleteGolfJornada(int jornadaId) { GolfJornada gj = new GolfJornada(); return(gj.Delete(jornadaId)); }
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(); }