public void Load_Videos()
{
DataTable dt = new DataTable();
dt = GetVideos("LatestVideos", 0);
VideosRepeater.DataSource = dt;
VideosRepeater.DataBind();
dt = GetVideos("LatestVideo", 0);
// vTitle.Text = rs.Rows(0)("title").ToString
Description.Text = dt.Rows[0]["description"].ToString();
EU.Text = dt.Rows[0]["eu"].ToString();
ED.Text = DateTime.Parse(dt.Rows[0]["ed"].ToString()).ToString("dd MMM yyyy");
I1.Src = dt.Rows[0]["embed"].ToString();
}
public void Load_Video()
{
rs = GetVideos("Watch", int.Parse(id_video.Value));
vTitle.Text = rs.Rows[0]["title"].ToString();
Description.Text = rs.Rows[0]["description"].ToString();
EU.Text = rs.Rows[0]["eu"].ToString();
ED.Text = rs.Rows[0]["ed"].ToString();
I1.Src = rs.Rows[0]["embed"].ToString();
titlebanner.Src = rs.Rows[0]["thumbnail"].ToString();
// Response.Redirect(getduration(I1.Src))
rs = GetSearchVideos(vTitle.Text + " " + Description.Text, "Related", int.Parse(id_video.Value));
VideosRepeater.DataSource = rs;
VideosRepeater.DataBind();
rs = null;
}
public void Load_Videos()
{
// If Search_Query.Value = String.Empty Then
// rs = Database.Fetch.GenericRS("FMjr", "Get_Videos", 0, "", "", "", "", "", "")
// Else
// Results.Visible = True
// rs = Database.Fetch.GenericRS("FMjr", "Get_Search_Videos", 0, "", Search_Query.Value + "*", "", "", "", "")
// If rs.Rows.Count = 0 Then
// Results.Text = "No Results Found for the search term """ & Search_Query.Value & """"
// ElseIf rs.Rows.Count = 1 Then
// Results.Text = "1 Result Found for the search term """ & Search_Query.Value & """"
// Else
// Results.Text = rs.Rows.Count & " results found for the search term """ & Search_Query.Value & """"
// End If
// End If
if (Search_Query.Value == string.Empty)
{
rs = GetVideos("All", 0);
// Results.Text = "There are " + rs.Rows.Count.ToString() + " videos";
}
else
{
try
{
// Response.Redirect(Search_Query.Value);
rs = GetSearchVideos(Search_Query.Value, "Search", 0);
if (rs.Rows.Count == 0)
{
Results.Text = "No Results Found for the search term '" + Search_Query.Value + "'.";
}
else if (rs.Rows.Count == 1)
{
Results.Text = "1 Result Found for the search term '" + Search_Query.Value + "'.";
}
else
{
Results.Text = rs.Rows.Count + " results found for the search term '" + Search_Query.Value + "'.";
}
}
catch
{
Results.Text = "There are invalid characters in the search term. please try again.";
rs = new DataTable();
}
}
if (rs.Rows.Count > 0)
{
PagedDataSource page = new PagedDataSource();
page.DataSource = rs.DefaultView;
page.AllowPaging = true;
page.PageSize = 24;
page.CurrentPageIndex = PageNumber;
if (page.PageCount > 1)
{
rptPaging.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i <= page.PageCount - 1; i++)
{
pages.Add((i + 1).ToString());
}
rptPaging.DataSource = pages;
rptPaging.DataBind();
foreach (RepeaterItem item in rptPaging.Items)
{
LinkButton pagebtn = (LinkButton)item.FindControl("btnPage");
if (int.Parse(pagebtn.CommandArgument.ToString()) == PageNumber + 1)
{
pagebtn.BackColor = System.Drawing.Color.Transparent;
pagebtn.BorderColor = System.Drawing.Color.Black;
pagebtn.ForeColor = System.Drawing.Color.Black;
pagebtn.BorderWidth = 3;
}
}
}
else
{
rptPaging.Visible = false;
}
VideosRepeater.DataSource = page;
VideosRepeater.DataBind();
}
}
