protected void draw_custom_table()
{
SQLFunctions conn = new SQLFunctions();
TableRow row;
TableCell cell;
tableContent.Rows.Clear();
resultsTally rt = evaluateTopBooks();
List <resultsTally> lrt = new List <resultsTally>();
row = new TableRow();
cell = new TableCell();
if (rt.book_id > -1)
{
cell.Text = "With " + rt.numberVotes + " number one votes, the clear #1 is : " + rt.bookTitle;
row.Cells.Add(cell);
}
else if (rt.book_id == -2)
{
lrt = returnTiedTopBooks();
cell.Text = "Tied with " + lrt[0].numberVotes + " number one votes, the two best books are : " + lrt[0].bookTitle + " and " + lrt[1].bookTitle;
row.Cells.Add(cell);
}
else
{
cell.Text = "There no was no clear #1 pick for best book!";
row.Cells.Add(cell);
//cell = new TableCell();
//List<resultsTally> lrt = evaluateTopBookPlurality();
//cell.Text = "With " + lrt[0].numberVotes + " the plurality of people voted #1 as : " + lrt[0].bookTitle;
}
tableContent.Rows.Add(row);
rt = new resultsTally();
rt = evaluateBottomBooks();
row = new TableRow();
cell = new TableCell();
if (rt.book_id > -1)
{
cell.Text = "With " + rt.numberVotes + " number seven votes, the most disliked book is : " + rt.bookTitle;
row.Cells.Add(cell);
}
else if (rt.book_id == -2)
{
lrt = new List <resultsTally>();
//lrt = returnTiedBottomBooks();
cell.Text = "Tied with " + lrt[0].numberVotes + " number seven votes, the two worst books are : " + lrt[0].bookTitle + " and " + lrt[1].bookTitle;
row.Cells.Add(cell);
}
else
{
cell.Text = "There no was no clear #1 pick for worst book!";
row.Cells.Add(cell);
}
tableContent.Rows.Add(row);
int pages = conn.getTotalPagesRead(2018);
if (pages > -1)
{
row = new TableRow();
cell = new TableCell();
cell.Text = "We have read " + pages + " number of pages in 2018";
row.Cells.Add(cell);
tableContent.Rows.Add(row);
}
bookModel highCount = conn.getHighPageCount();
if (highCount.bookPageLength > -1)
{
row = new TableRow();
cell = new TableCell();
cell.Text = "The high page count is " + highCount.bookTitle + " with " + highCount.bookPageLength + " pages.";
row.Cells.Add(cell);
tableContent.Rows.Add(row);
}
bookModel lowCount = conn.getLowPageCount();
if (highCount.bookPageLength > -1)
{
row = new TableRow();
cell = new TableCell();
cell.Text = "The low page count is " + lowCount.bookTitle + " with " + lowCount.bookPageLength + " pages.";
row.Cells.Add(cell);
tableContent.Rows.Add(row);
}
int pubdate = conn.getAvgBookPublishYear(2018);
if (pubdate > -1)
{
row = new TableRow();
cell = new TableCell();
cell.Text = "The average first published year is " + pubdate;
row.Cells.Add(cell);
tableContent.Rows.Add(row);
}
}
