protected void Page_Load(object sender, EventArgs e)
{
int i = 0; // i used for count the number of the row
DataView dv = (DataView)DSTopic.Select(DataSourceSelectArguments.Empty);
if (dv != null) //Exception Detect
{
/*-----------------------------------------------Table Header-----------------------------------------------*/
TableHeaderRow header = new TableHeaderRow();
TableCell TopicContent = new TableCell();;
header.ForeColor = ColorTranslator.FromHtml("#a4d5f7");
header.Font.Bold = true;
header.Font.Name = "Calibri";
TopicContent.Text = "Topics:"; //List of each topic
TopicContent.HorizontalAlign = HorizontalAlign.Left;
header.Cells.Add(TopicContent);
Table1.Rows.Add(header);
foreach (DataRow dr in dv.Table.Rows) // add each row to table1
{
i++;
TableRow row = new TableRow();
TableCell Content = new TableCell(); // Topic Info for each topic
if (i % 2 == 0) //dynamic background color even-> black & odd -> grey
{
Content.BackColor = ColorTranslator.FromHtml("#a4d5f7");
Content.ForeColor = ColorTranslator.FromHtml("#ffffff");
}
else
{
Content.BackColor = ColorTranslator.FromHtml("#4498d2");
Content.ForeColor = ColorTranslator.FromHtml("#ffffff");
}
Content.HorizontalAlign = HorizontalAlign.Left;
Content.Font.Name = "Calibri";
string TopicURL = string.Format("Topic.aspx?Id={0}&Name={1}&Title={2}", dr["Id"].ToString(), dr["OwnerName"].ToString(), dr["Topic"].ToString());
string UserURL = string.Format("UserProfile.aspx?U={0}&Name={1}", dr["Owner"].ToString(), dr["OwnerName"].ToString());//redirect to user page
Content.Text = "<a href=\"" + UserURL + "\" style=\"color:#ffffff\" >"
+ "<img src=\"" + GetPicById(int.Parse(dr["Owner"].ToString())) + "\" width=\"15\" height=\"15\" style=\"border:1px; border-color:#a4d5f7\"/> " + dr["OwnerName"].ToString() + "</a>" //Poster
+ " <div style=\"font-size:10px\">" + dr["LastTime"].ToString() + "</div><br/>" // Post time
+ "<a href=\"" + TopicURL + "\">" + dr["Topic"].ToString() + "</a><br/>"; // Topic
row.Cells.Add(Content);
Table1.Rows.Add(row);
Table1.CellPadding = 15; // Content Indent
Table1.Style.Add("width", "95% !important"); // Inline percentage of table width
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int i = 0;
DataView dv1 = (DataView)DSTopic.Select(DataSourceSelectArguments.Empty);
if (dv1 != null) //Exception Detect
{
/*-----------------------------------------------Table Header-----------------------------------------------*/
TableHeaderRow header = new TableHeaderRow();
TableCell TopicContent = new TableCell();;
header.ForeColor = ColorTranslator.FromHtml("#a4d5f7");
header.Font.Bold = true;
header.Font.Name = "Calibri";
TopicContent.Text = "Popular Topics:"; //List of each topic
TopicContent.HorizontalAlign = HorizontalAlign.Left;
header.Cells.Add(TopicContent);
Table1.Rows.Add(header);
foreach (DataRow dr in dv1.Table.Rows) // add each row to table1
{
i++;
TableRow row = new TableRow();
TableCell Content = new TableCell(); // Topic Info for each topic
if (i % 2 == 0) //dynamic background color even-> black & odd -> grey
{
Content.BackColor = ColorTranslator.FromHtml("#a4d5f7");
Content.ForeColor = ColorTranslator.FromHtml("#ffffff");
}
else
{
Content.BackColor = ColorTranslator.FromHtml("#4498d2");
Content.ForeColor = ColorTranslator.FromHtml("#ffffff");
}
Content.HorizontalAlign = HorizontalAlign.Left;
Content.Font.Name = "Calibri";
string TopicURL = string.Format("Topic.aspx?Id={0}&Name={1}&Title={2}", dr["Id"].ToString(), dr["OwnerName"].ToString(), dr["Topic"].ToString());
string UserURL = string.Format("UserProfile.aspx?U={0}&Name={1}", dr["Owner"].ToString(), dr["OwnerName"].ToString());//redirect to user page
Content.Text = "<a href=\"" + UserURL + "\" style=\"color:#ffffff\" >"
+ "<img src=\"" + GetPicById(int.Parse(dr["Owner"].ToString())) + "\" width=\"15\" height=\"15\" style=\"border:1px; border-color:#a4d5f7\"/> " + dr["OwnerName"].ToString() + "</a> "
+ "<a href=\"" + TopicURL + "\">" + dr["Topic"].ToString() + "</a> " + dr["Likes"].ToString() + " Likes <br/>" //Poster
+ " <div style=\"font-size:10px\">" + dr["LastTime"].ToString() + "</div><br/>" // Post time
;
row.Cells.Add(Content);
Table1.Rows.Add(row);
Table1.CellPadding = 15; // Content Indent
Table1.Style.Add("width", "95% !important"); // Inline percentage of table width
}
}
i = 0; // i used for count the number of the row
DataView dv2 = (DataView)DSBand.Select(DataSourceSelectArguments.Empty);
if (dv2 != null) //Exception Detect
{
/*-----------------------------------------------Table Header-----------------------------------------------*/
TableHeaderRow header = new TableHeaderRow();
TableCell ActerName = new TableCell();
header.ForeColor = ColorTranslator.FromHtml("#a4d5f7");
header.Font.Bold = true;
header.Font.Name = "Calibri";
ActerName.Text = "Popular Band or Singer";
ActerName.HorizontalAlign = HorizontalAlign.Left;
header.Cells.Add(ActerName);
BandTable.Rows.Add(header);
foreach (DataRow dr in dv2.Table.Rows) // add each row to table1
{
i++;
TableRow row = new TableRow();
TableCell BandInfo = new TableCell(); // we do not need to see the first item "id", so begin with item2
row.Cells.Add(BandInfo);
if (i % 2 == 0) //dynamic background color even-> black & odd -> grey
{
BandInfo.BackColor = ColorTranslator.FromHtml("#a4d5f7");
BandInfo.ForeColor = ColorTranslator.FromHtml("#ffffff");
}
else
{
BandInfo.BackColor = ColorTranslator.FromHtml("#4498d2");
BandInfo.ForeColor = ColorTranslator.FromHtml("#ffffff");
}
BandInfo.HorizontalAlign = HorizontalAlign.Left;
BandInfo.Font.Name = "Calibri";
/* Output format: use <div></div> wrap information
* URL linked to the band profile page and transfer the infomation of the page to that one
* ProfilePic for the path of the pictures
*/
string URL = string.Format("BandProfile.aspx?Id={0}&Name={1}", dr["Id"].ToString(), dr["Name"].ToString());
string ProfilePic = dr["Pic"].ToString();
string dateString = dr["EstTime"].ToString();
DateTime DBdate = DateTime.Parse(dateString, System.Globalization.CultureInfo.InvariantCulture);
BandInfo.Text =
"<a href=\"" + URL + "\"><img src=\"" + ProfilePic + "\" width=\"30\" height=\"30\" /> " + dr["Name"].ToString() + "</a> Est. " + DBdate.Year.ToString() +
" " + dr["Likes"].ToString() + " Likes";
BandTable.Rows.Add(row);
BandTable.CellPadding = 15; // Content Indent
BandTable.Style.Add("width", "95% !important"); // Inline percentage of table width
}
}
}
