/// <summary>
/// create responsive table for each table by looking at the url
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
dataTableName = GetDataTableName(Request.Url.AbsoluteUri);
if (dataTableName.Equals("users"))
{
table.CssClass = "table users-table Report1942Font";
sqlConnection = new SqlConnection(resources.ResourceManager.GetString("Connection_String"));
sqlConnection.Open();
string sqlCmd = "SELECT * FROM [Users]";
SqlCommand sqlCommand = new SqlCommand(sqlCmd, sqlConnection);
SqlDataReader reader = sqlCommand.ExecuteReader();
string[] titles = { "ID", "Username", "Password", "Email", "Content Creator", "Content Consumer", "Validated", "RandomKey", "User Color", "Admin" };
GenerateHeaderRow(titles);
TableFooterRow footer_row = new TableFooterRow();
int i = 0;
int counter = 0;
if (reader.Read())
{
footer_row = GenerateFooterRow(reader, ref counter);
}
do
{
table.Controls.Add(GenerateTableRow(reader, i, ref counter));
i++;
} while (reader.Read());
reader.Close();
sqlConnection.Close();
title.InnerHtml = "USERS";
table.Controls.Add(footer_row);
}
if (dataTableName.Equals("models"))
{
table.CssClass = "table models-table Report1942Font";
ws = new maker_service.WebService();
string[] titles = { "Model ID", "User ID", "Date", "Data Path", "Name", "Description", "Thumbnail" };
GenerateHeaderRow(titles);
ws.OpenConnection();
DataSet dataset = ws.GenericReaderQuery("SELECT * FROM [Models]");
TableFooterRow footer_row = new TableFooterRow();
int i = 0;
int counter = 0;
DataTableReader reader = dataset.Tables[0].CreateDataReader();
if (reader.Read())
{
footer_row = GenerateFooterRow(reader, ref counter);
}
do
{
table.Controls.Add(GenerateTableRow(reader, i, ref counter));
i++;
} while (reader.Read());
reader.Close();
ws.CloseConnection();
title.InnerHtml = "MODELS";
table.Controls.Add(footer_row);
}
if (dataTableName.Equals("downloads"))
{
table.CssClass = "table models-table Report1942Font";
ws = new maker_service.WebService();
string[] titles = { "Download ID", "User ID", "Model ID", "Download Date" };
GenerateHeaderRow(titles);
ws.OpenConnection();
DataSet dataset = ws.GenericReaderQuery("SELECT * FROM [Downloads]");
TableFooterRow footer_row = new TableFooterRow();
int i = 0;
int counter = 0;
DataTableReader reader = dataset.Tables[0].CreateDataReader();
if (reader.Read())
{
footer_row = GenerateFooterRow(reader, ref counter);
}
do
{
table.Controls.Add(GenerateTableRow(reader, i, ref counter));
i++;
} while (reader.Read());
reader.Close();
ws.CloseConnection();
title.InnerHtml = "Downloads";
table.Controls.Add(footer_row);
}
if (dataTableName.Equals("ratings"))
{
table.CssClass = "table models-table Report1942Font";
ws = new maker_service.WebService();
string[] titles = { "Rate ID", "User ID", "Model ID", "Value" };
GenerateHeaderRow(titles);
ws.OpenConnection();
DataSet dataset = ws.GenericReaderQuery("SELECT * FROM [Ratings]");
TableFooterRow footer_row = new TableFooterRow();
int i = 0;
int counter = 0;
DataTableReader reader = dataset.Tables[0].CreateDataReader();
if (reader.Read())
{
footer_row = GenerateFooterRow(reader, ref counter);
}
do
{
table.Controls.Add(GenerateTableRow(reader, i, ref counter));
i++;
} while (reader.Read());
reader.Close();
ws.CloseConnection();
title.InnerHtml = "Ratings";
table.Controls.Add(footer_row);
}
}