protected void btnLogin_Click(object sender, EventArgs e)
{
DBMater dbm = new DBMater();
SqlCommand adcmd = new SqlCommand("Select Count(1) from FBAdmin where UserName = @UserName and Password = @Password");
adcmd.CommandType = System.Data.CommandType.Text;
adcmd.Connection = dbm.GetConnection();
adcmd.Parameters.AddWithValue("@UserName", inputUser.Text.Trim());
adcmd.Parameters.AddWithValue("@Password", inputPassword.Text.Trim());
int count = Convert.ToInt32(adcmd.ExecuteScalar());
if (count == 1)
{
Session["UserName"] = inputUser.Text.Trim();
Response.Redirect("Admin.aspx");
}
else
{
lblErrorMessage.Visible = true;
}
dbm.closeConnection();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DBMater dbm = new DBMater();
#region TablePremierleague
SqlDataReader EPLrdr = dbm.GetReader("SELECT ClubName, Played, GD, Points FROM FBClub where LeagueID = 505 ORDER BY Points DESC;");
EPLtable.Append("<table class='table'>");
EPLtable.Append("<thead>");
EPLtable.Append("<tr><th scope ='col'> Pos</th><th scope = 'col'> Club</th><th scope = 'col'> Pl</th><th scope = 'col'> GD</th><th scope = 'col'> Pts</th></tr>");
EPLtable.Append("</tr>");
EPLtable.Append("</thead>");
if (EPLrdr.HasRows)
{
int i = 1;
while (EPLrdr.Read())
{
EPLtable.Append("<tbody>");
EPLtable.Append("<tr>");
EPLtable.Append("<td>" + i++ + "</td>");
EPLtable.Append("<td>" + EPLrdr[0] + "</td>");
EPLtable.Append("<td>" + EPLrdr[1] + "</td>");
EPLtable.Append("<td>" + EPLrdr[2] + "</td>");
EPLtable.Append("<td>" + EPLrdr[3] + "</td>");
EPLtable.Append("</tr>");
EPLtable.Append("</tbody>");
}
}
EPLtable.Append("</table>");
EPLPlaceHolder.Controls.Add(new Literal {
Text = EPLtable.ToString()
});
EPLrdr.Close();
#endregion
#region TableFBLaLiga
SqlDataReader LFPrdr = dbm.GetReader("SELECT ClubName, Played, GD, Points FROM FBClub where LeagueID = 504 ORDER BY Points DESC;");
LFPtable.Append("<table class='table'>");
LFPtable.Append("<thead>");
LFPtable.Append("<tr><th scope ='col'> Pos</th><th scope = 'col'> Club</th><th scope = 'col'> Pl</th><th scope = 'col'> GD</th><th scope = 'col'> Pts</th></tr>");
LFPtable.Append("</tr>");
LFPtable.Append("</thead>");
if (LFPrdr.HasRows)
{
int i = 1;
while (LFPrdr.Read())
{
LFPtable.Append("<tbody>");
LFPtable.Append("<tr>");
LFPtable.Append("<td>" + i++ + "</td>");
LFPtable.Append("<td>" + LFPrdr[0] + "</td>");
LFPtable.Append("<td>" + LFPrdr[1] + "</td>");
LFPtable.Append("<td>" + LFPrdr[2] + "</td>");
LFPtable.Append("<td>" + LFPrdr[3] + "</td>");
LFPtable.Append("</tr>");
LFPtable.Append("</tbody>");
}
}
LFPtable.Append("</table>");
LFPPlaceHolder.Controls.Add(new Literal {
Text = LFPtable.ToString()
});
LFPrdr.Close();
#endregion
#region TableFBBL
SqlDataReader BLrdr = dbm.GetReader("SELECT ClubName, Played, GD, Points FROM FBClub where LeagueID = 501 ORDER BY Points DESC;");
BLtable.Append("<table class='table'>");
BLtable.Append("<thead>");
BLtable.Append("<tr><th scope ='col'> Pos</th><th scope = 'col'> Club</th><th scope = 'col'> Pl</th><th scope = 'col'> GD</th><th scope = 'col'> Pts</th></tr>");
BLtable.Append("</tr>");
BLtable.Append("</thead>");
if (BLrdr.HasRows)
{
int i = 1;
while (BLrdr.Read())
{
BLtable.Append("<tbody>");
BLtable.Append("<tr>");
BLtable.Append("<td>" + i++ + "</td>");
BLtable.Append("<td>" + BLrdr[0] + "</td>");
BLtable.Append("<td>" + BLrdr[1] + "</td>");
BLtable.Append("<td>" + BLrdr[2] + "</td>");
BLtable.Append("<td>" + BLrdr[3] + "</td>");
BLtable.Append("</tr>");
BLtable.Append("</tbody>");
}
}
BLtable.Append("</table>");
BLPlaceHolder.Controls.Add(new Literal {
Text = BLtable.ToString()
});
BLrdr.Close();
#endregion
#region TableFBSA
SqlDataReader SArdr = dbm.GetReader("SELECT ClubName, Played, GD, Points FROM FBClub where LeagueID = 502 ORDER BY Points DESC;");
SAtable.Append("<table class='table'>");
SAtable.Append("<thead>");
SAtable.Append("<tr><th scope ='col'> Pos</th><th scope = 'col'> Club</th><th scope = 'col'> Pl</th><th scope = 'col'> GD</th><th scope = 'col'> Pts</th></tr>");
SAtable.Append("</tr>");
SAtable.Append("</thead>");
if (SArdr.HasRows)
{
int i = 1;
while (SArdr.Read())
{
SAtable.Append("<tbody>");
SAtable.Append("<tr>");
SAtable.Append("<td>" + i++ + "</td>");
SAtable.Append("<td>" + SArdr[0] + "</td>");
SAtable.Append("<td>" + SArdr[1] + "</td>");
SAtable.Append("<td>" + SArdr[2] + "</td>");
SAtable.Append("<td>" + SArdr[3] + "</td>");
SAtable.Append("</tr>");
SAtable.Append("</tbody>");
}
}
SAtable.Append("</table>");
SAPlaceHolder.Controls.Add(new Literal {
Text = SAtable.ToString()
});
SArdr.Close();
#endregion
#region TableFBL1
SqlDataReader L1rdr = dbm.GetReader("SELECT ClubName, Played, GD, Points FROM FBClub where LeagueID = 503 ORDER BY Points DESC;");
L1table.Append("<table class='table'>");
L1table.Append("<thead>");
L1table.Append("<tr><th scope ='col'> Pos</th><th scope = 'col'> Club</th><th scope = 'col'> Pl</th><th scope = 'col'> GD</th><th scope = 'col'> Pts</th></tr>");
L1table.Append("</tr>");
L1table.Append("</thead>");
if (L1rdr.HasRows)
{
int i = 1;
while (L1rdr.Read())
{
L1table.Append("<tbody>");
L1table.Append("<tr>");
L1table.Append("<td>" + i++ + "</td>");
L1table.Append("<td>" + L1rdr[0] + "</td>");
L1table.Append("<td>" + L1rdr[1] + "</td>");
L1table.Append("<td>" + L1rdr[2] + "</td>");
L1table.Append("<td>" + L1rdr[3] + "</td>");
L1table.Append("</tr>");
L1table.Append("</tbody>");
}
}
L1table.Append("</table>");
L1PlaceHolder.Controls.Add(new Literal {
Text = L1table.ToString()
});
L1rdr.Close();
#endregion
#region News1
SqlDataReader Newsrdr1 = dbm.GetReader("select FBImage.IDNews, TitleNews, ContentNews, IName, Data from FBNews inner join FBImage on FBNews.IDNews = FBImage.IDNews where FBNews.IDNews = (select MAx(FBNews.IDNews) from FBNews)");
while (Newsrdr1.Read())
{
byte[] imagedata = (byte[])Newsrdr1["Data"];
string img = Convert.ToBase64String(imagedata, 0, imagedata.Length);
Image1.ImageUrl = "data:image/png;base64," + img;
News1 = Newsrdr1[1].ToString();
}
TtNews1.DataBind();
Newsrdr1.Close();
#endregion
#region News2
SqlDataReader Newsrdr2 = dbm.GetReader("select FBImage.IDNews, TitleNews, ContentNews, IName, Data from FBNews inner join FBImage on FBNews.IDNews = FBImage.IDNews where FBNews.IDNews = (select MAx(FBNews.IDNews) - 1 from FBNews)");
while (Newsrdr2.Read())
{
byte[] imagedata = (byte[])Newsrdr2["Data"];
string img = Convert.ToBase64String(imagedata, 0, imagedata.Length);
Image2.ImageUrl = "data:image/png;base64," + img;
News1 = Newsrdr2[1].ToString();
}
TtNews2.DataBind();
Newsrdr2.Close();
#endregion
#region News3
SqlDataReader Newsrdr3 = dbm.GetReader("select FBImage.IDNews, TitleNews, ContentNews, IName, Data from FBNews inner join FBImage on FBNews.IDNews = FBImage.IDNews where FBNews.IDNews = (select MAx(FBNews.IDNews) - 2 from FBNews)");
while (Newsrdr3.Read())
{
byte[] imagedata = (byte[])Newsrdr3["Data"];
string img = Convert.ToBase64String(imagedata, 0, imagedata.Length);
Image3.ImageUrl = "data:image/png;base64," + img;
News1 = Newsrdr3[1].ToString();
}
TtNews3.DataBind();
Newsrdr3.Close();
#endregion
#region NewsCardsrdr
SqlDataReader NewsCardsrdr = dbm.GetReader("select FBImage.IDNews, TitleNews, LeadNews, ContentNews, IName, Data from FBNews inner join FBImage on FBNews.IDNews = FBImage.IDNews where FBNews.IDNews = (select MAx(FBNews.IDNews) from FBNews)");
SqlDataReader NewsCardsrdr2 = dbm.GetReader("select FBImage.IDNews, TitleNews, LeadNews, ContentNews, IName, Data from FBNews inner join FBImage on FBNews.IDNews = FBImage.IDNews where FBNews.IDNews = (select MAx(FBNews.IDNews) - 1 from FBNews)");
SqlDataReader NewsCardsrdr3 = dbm.GetReader("select FBImage.IDNews, TitleNews, LeadNews, ContentNews, IName, Data from FBNews inner join FBImage on FBNews.IDNews = FBImage.IDNews where FBNews.IDNews = (select MAx(FBNews.IDNews) - 2 from FBNews)");
SqlDataReader NewsCardsrdr4 = dbm.GetReader("select FBImage.IDNews, TitleNews, LeadNews, ContentNews, IName, Data from FBNews inner join FBImage on FBNews.IDNews = FBImage.IDNews where FBNews.IDNews = (select MAx(FBNews.IDNews) - 3 from FBNews)");
SqlDataReader NewsCardsrdr5 = dbm.GetReader("select FBImage.IDNews, TitleNews, LeadNews, ContentNews, IName, Data from FBNews inner join FBImage on FBNews.IDNews = FBImage.IDNews where FBNews.IDNews = (select MAx(FBNews.IDNews) - 4 from FBNews)");
SqlDataReader NewsCardsrdr6 = dbm.GetReader("select FBImage.IDNews, TitleNews, LeadNews, ContentNews, IName, Data from FBNews inner join FBImage on FBNews.IDNews = FBImage.IDNews where FBNews.IDNews = (select MAx(FBNews.IDNews) - 5 from FBNews)");
NewsCards(NewsCardsrdr);
NewsCards(NewsCardsrdr2);
NewsCards(NewsCardsrdr3);
NewsCards(NewsCardsrdr4);
NewsCards(NewsCardsrdr5);
NewsCards(NewsCardsrdr6);
#endregion
dbm.closeConnection();
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblUserConnect.Text = "Username : "******"UserName"];
#region TablePremierleague
SqlDataReader EPLrdr = dbm.GetReader("SELECT * FROM FBClub where LeagueID = 505 ORDER BY LeagueID DESC;");
EPLtable.Append("<table class='table'>");
EPLtable.Append("<thead>");
EPLtable.Append("<tr><th scope ='col'> ID</th><th scope = 'col'> Club</th><th scope = 'col'> Played</th><th scope = 'col'> Won</th><th scope = 'col'> Drawn</th>");
EPLtable.Append("<th scope ='col'> Lost</th><th scope = 'col'> GF</th><th scope = 'col'> GA</th><th scope = 'col'> GD</th><th scope = 'col'> Points</th>");
EPLtable.Append("</tr>");
EPLtable.Append("</thead>");
if (EPLrdr.HasRows)
{
while (EPLrdr.Read())
{
EPLtable.Append("<tbody>");
EPLtable.Append("<tr>");
EPLtable.Append("<td><a style='color:#f7560c'> " + EPLrdr[0] + "</a></td>");
EPLtable.Append("<td>" + EPLrdr[1] + "</td>");
EPLtable.Append("<td>" + EPLrdr[2] + "</td>");
EPLtable.Append("<td>" + EPLrdr[3] + "</td>");
EPLtable.Append("<td>" + EPLrdr[4] + "</td>");
EPLtable.Append("<td>" + EPLrdr[5] + "</td>");
EPLtable.Append("<td>" + EPLrdr[6] + "</td>");
EPLtable.Append("<td>" + EPLrdr[7] + "</td>");
EPLtable.Append("<td>" + EPLrdr[8] + "</td>");
EPLtable.Append("<td>" + EPLrdr[9] + "</td>");
EPLtable.Append("</tr>");
EPLtable.Append("</tbody>");
}
}
EPLtable.Append("</table>");
EPLPlaceHolder.Controls.Add(new Literal {
Text = EPLtable.ToString()
});
EPLrdr.Close();
#endregion
#region TableLaLiga
SqlDataReader LFPrdr = dbm.GetReader("SELECT * FROM FBClub where LeagueID = 504 ORDER BY LeagueID DESC;");
LFPtable.Append("<table class='table'>");
LFPtable.Append("<thead>");
LFPtable.Append("<tr><th scope ='col'> ID</th><th scope = 'col'> Club</th><th scope = 'col'> Played</th><th scope = 'col'> Won</th><th scope = 'col'> Drawn</th>");
LFPtable.Append("<th scope ='col'> Lost</th><th scope = 'col'> GF</th><th scope = 'col'> GA</th><th scope = 'col'> GD</th><th scope = 'col'> Points</th>");
LFPtable.Append("</tr>");
LFPtable.Append("</thead>");
if (LFPrdr.HasRows)
{
while (LFPrdr.Read())
{
LFPtable.Append("<tbody>");
LFPtable.Append("<tr>");
LFPtable.Append("<td><a style='color:#f7560c'> " + LFPrdr[0] + "</a></td>");
LFPtable.Append("<td>" + LFPrdr[1] + "</td>");
LFPtable.Append("<td>" + LFPrdr[2] + "</td>");
LFPtable.Append("<td>" + LFPrdr[3] + "</td>");
LFPtable.Append("<td>" + LFPrdr[4] + "</td>");
LFPtable.Append("<td>" + LFPrdr[5] + "</td>");
LFPtable.Append("<td>" + LFPrdr[6] + "</td>");
LFPtable.Append("<td>" + LFPrdr[7] + "</td>");
LFPtable.Append("<td>" + LFPrdr[8] + "</td>");
LFPtable.Append("<td>" + LFPrdr[9] + "</td>");
LFPtable.Append("</tr>");
LFPtable.Append("</tbody>");
}
}
LFPtable.Append("</table>");
LFPPlaceHolder.Controls.Add(new Literal {
Text = LFPtable.ToString()
});
LFPrdr.Close();
#endregion
#region TableBundesLiga
SqlDataReader BLrdr = dbm.GetReader("SELECT * FROM FBClub where LeagueID = 501 ORDER BY LeagueID DESC;");
BLtable.Append("<table class='table'>");
BLtable.Append("<thead>");
BLtable.Append("<tr><th scope ='col'> ID</th><th scope = 'col'> Club</th><th scope = 'col'> Played</th><th scope = 'col'> Won</th><th scope = 'col'> Drawn</th>");
BLtable.Append("<th scope ='col'> Lost</th><th scope = 'col'> GF</th><th scope = 'col'> GA</th><th scope = 'col'> GD</th><th scope = 'col'> Points</th>");
BLtable.Append("</tr>");
BLtable.Append("</thead>");
if (BLrdr.HasRows)
{
while (BLrdr.Read())
{
BLtable.Append("<tbody>");
BLtable.Append("<tr>");
BLtable.Append("<td><a style='color:#f7560c'> " + BLrdr[0] + "</a></td>");
BLtable.Append("<td>" + BLrdr[1] + "</td>");
BLtable.Append("<td>" + BLrdr[2] + "</td>");
BLtable.Append("<td>" + BLrdr[3] + "</td>");
BLtable.Append("<td>" + BLrdr[4] + "</td>");
BLtable.Append("<td>" + BLrdr[5] + "</td>");
BLtable.Append("<td>" + BLrdr[6] + "</td>");
BLtable.Append("<td>" + BLrdr[7] + "</td>");
BLtable.Append("<td>" + BLrdr[8] + "</td>");
BLtable.Append("<td>" + BLrdr[9] + "</td>");
BLtable.Append("</tr>");
BLtable.Append("</tbody>");
}
}
BLtable.Append("</table>");
BLPlaceHolder.Controls.Add(new Literal {
Text = BLtable.ToString()
});
BLrdr.Close();
#endregion
#region TableSerie A
SqlDataReader SArdr = dbm.GetReader("SELECT * FROM FBClub where LeagueID = 502 ORDER BY LeagueID DESC;");
SAtable.Append("<table class='table'>");
SAtable.Append("<thead>");
SAtable.Append("<tr><th scope ='col'> ID</th><th scope = 'col'> Club</th><th scope = 'col'> Played</th><th scope = 'col'> Won</th><th scope = 'col'> Drawn</th>");
SAtable.Append("<th scope ='col'> Lost</th><th scope = 'col'> GF</th><th scope = 'col'> GA</th><th scope = 'col'> GD</th><th scope = 'col'> Points</th>");
SAtable.Append("</tr>");
SAtable.Append("</thead>");
if (SArdr.HasRows)
{
while (SArdr.Read())
{
SAtable.Append("<tbody>");
SAtable.Append("<tr>");
SAtable.Append("<td><a style='color:#f7560c'> " + SArdr[0] + "</a></td>");
SAtable.Append("<td>" + SArdr[1] + "</td>");
SAtable.Append("<td>" + SArdr[2] + "</td>");
SAtable.Append("<td>" + SArdr[3] + "</td>");
SAtable.Append("<td>" + SArdr[4] + "</td>");
SAtable.Append("<td>" + SArdr[5] + "</td>");
SAtable.Append("<td>" + SArdr[6] + "</td>");
SAtable.Append("<td>" + SArdr[7] + "</td>");
SAtable.Append("<td>" + SArdr[8] + "</td>");
SAtable.Append("<td>" + SArdr[9] + "</td>");
SAtable.Append("</tr>");
SAtable.Append("</tbody>");
}
}
SAtable.Append("</table>");
SAPlaceHolder.Controls.Add(new Literal {
Text = SAtable.ToString()
});
SArdr.Close();
#endregion
#region TableLigue 1
SqlDataReader L1rdr = dbm.GetReader("SELECT * FROM FBClub where LeagueID = 503 ORDER BY LeagueID DESC;");
L1table.Append("<table class='table'>");
L1table.Append("<thead>");
L1table.Append("<tr><th scope ='col'> ID</th><th scope = 'col'> Club</th><th scope = 'col'> Played</th><th scope = 'col'> Won</th><th scope = 'col'> Drawn</th>");
L1table.Append("<th scope ='col'> Lost</th><th scope = 'col'> GF</th><th scope = 'col'> GA</th><th scope = 'col'> GD</th><th scope = 'col'> Points</th>");
L1table.Append("</tr>");
L1table.Append("</thead>");
if (L1rdr.HasRows)
{
while (L1rdr.Read())
{
L1table.Append("<tbody>");
L1table.Append("<tr>");
L1table.Append("<td><a style='color:#f7560c'> " + L1rdr[0] + "</a></td>");
L1table.Append("<td>" + L1rdr[1] + "</td>");
L1table.Append("<td>" + L1rdr[2] + "</td>");
L1table.Append("<td>" + L1rdr[3] + "</td>");
L1table.Append("<td>" + L1rdr[4] + "</td>");
L1table.Append("<td>" + L1rdr[5] + "</td>");
L1table.Append("<td>" + L1rdr[6] + "</td>");
L1table.Append("<td>" + L1rdr[7] + "</td>");
L1table.Append("<td>" + L1rdr[8] + "</td>");
L1table.Append("<td>" + L1rdr[9] + "</td>");
L1table.Append("</tr>");
L1table.Append("</tbody>");
}
}
L1table.Append("</table>");
L1PlaceHolder.Controls.Add(new Literal {
Text = L1table.ToString()
});
L1rdr.Close();
#endregion
lblErrorMessage.Visible = false;
dbm.closeConnection();
}