public void Add(Athlete athete)
{
var data =
new IT.Phrase(athete.Id.ToString() ,
IT.FontFactory.GetFont(IT.FontFactory.HELVETICA, SIZE_ROW, IT.Font.NORMAL));
var cell = new IT.pdf.PdfPCell(data);
cell.HorizontalAlignment = IT.Element.ALIGN_LEFT;
cell.PaddingBottom = PAD_BOTTOM;
table.AddCell(cell);
data = new IT.Phrase(athete.Surname + " " + athete.Name,
IT.FontFactory.GetFont(IT.FontFactory.HELVETICA, SIZE_ROW, IT.Font.NORMAL));
cell = new IT.pdf.PdfPCell(data);
cell.HorizontalAlignment = IT.Element.ALIGN_LEFT;
cell.PaddingBottom = PAD_BOTTOM;
table.AddCell(cell);
data = new IT.Phrase(" ",
IT.FontFactory.GetFont(IT.FontFactory.HELVETICA, SIZE_TITLE, IT.Font.NORMAL));
cell = new IT.pdf.PdfPCell(data);
cell.HorizontalAlignment = IT.Element.ALIGN_LEFT;
cell.PaddingBottom = PAD_BOTTOM;
table.AddCell(cell);
}
public void Save(Athlete athlete)
{
// if (IsNew(athlete)) {
// Insert(athlete);
// } else {
// Update(athlete);
// }
}
public void Insert(Athlete athlete)
{
command.CommandText = string.Format("INSERT INTO at VALUES({0},\"{1}\",\"{2}\",{3},'{4}', '{5}');",
athlete.Id,
athlete.Name,
athlete.Surname,
athlete.Year,
athlete.Gender.ToString(),
athlete.Time
);
command.ExecuteNonQuery();
}
public void Update(Athlete athlete)
{
string sql = "UPDATE at SET ";
sql += string.Format ("name = '{0}', SET surname = '{1}', set year = {2}, set gender = '{3}', set time = '{4}' ",
athlete.Name,
athlete.Surname,
athlete.Year,
athlete.Gender,
athlete.Time
);
sql += string.Format("WHERE id={0}", athlete.Id);
command.CommandText = sql;
command.ExecuteNonQuery();
}
public void Add(Athlete athete)
{
// posizione
var ps =
new IT.Phrase((++pos).ToString(),
IT.FontFactory.GetFont(IT.FontFactory.HELVETICA, SIZE_ROW, IT.Font.BOLD)
);
var cell = new IT.pdf.PdfPCell(ps);
cell.HorizontalAlignment = IT.Element.ALIGN_LEFT;
// evidenzia i primi 3
if (pos < 4) {
cell.GrayFill = 0.90F;
}
cell.PaddingBottom = PAD_BOTTOM;
table.AddCell(cell);
var data =
new IT.Phrase(athete.Id.ToString() ,
IT.FontFactory.GetFont(IT.FontFactory.HELVETICA, SIZE_ROW, IT.Font.NORMAL));
cell = new IT.pdf.PdfPCell(data);
cell.HorizontalAlignment = IT.Element.ALIGN_LEFT;
cell.PaddingBottom = PAD_BOTTOM;
table.AddCell(cell);
data = new IT.Phrase(athete.Surname + " " + athete.Name,
IT.FontFactory.GetFont(IT.FontFactory.HELVETICA, SIZE_ROW, IT.Font.NORMAL));
cell = new IT.pdf.PdfPCell(data);
cell.HorizontalAlignment = IT.Element.ALIGN_LEFT;
cell.PaddingBottom = PAD_BOTTOM;
table.AddCell(cell);
data = new IT.Phrase(athete.Year.ToString(),
IT.FontFactory.GetFont(IT.FontFactory.HELVETICA, SIZE_ROW, IT.Font.NORMAL));
cell = new IT.pdf.PdfPCell(data);
cell.HorizontalAlignment = IT.Element.ALIGN_LEFT;
cell.PaddingBottom = PAD_BOTTOM;
table.AddCell(cell);
string t = athete.Time == "99:99" ? "rit." : athete.Time;
data = new IT.Phrase(t,
IT.FontFactory.GetFont(IT.FontFactory.HELVETICA, SIZE_ROW, IT.Font.NORMAL));
cell = new IT.pdf.PdfPCell(data);
cell.HorizontalAlignment = IT.Element.ALIGN_RIGHT;
cell.PaddingBottom = PAD_BOTTOM;
table.AddCell(cell);
}
public SCG.IEnumerable<Athlete> Query(string sql)
{
command.CommandText = sql;
var list = new SCG.List<Athlete>();
using (var reader = command.ExecuteReader()) {
while (reader.Read()) {
var at = new Athlete();
at.Id = reader.GetInt32(0);
at.Name = reader.GetString(1);
at.Surname = reader.GetString(2);
at.Year = reader.GetInt32(3);
at.Gender = reader.GetString(4);
at.Time = reader.GetString(5);
list.Add(at);
}
}
return list;
}
public bool IsNew(Athlete athlete)
{
command.CommandText = "SELECT id FROM at";
return command.ExecuteScalar() != null;
}
