protected void Button1_Click1(object sender, EventArgs e)
{
String searchName = TextBox1.Text;
try
{
String URL = "http://localhost:55923/CDRestService.svc/GetSearchResults/" + searchName;
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL);
request.KeepAlive = false;
WebResponse response = request.GetResponse();
StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
string json = reader.ReadToEnd();
DataTable table = JsonConvert.DeserializeObject <DataTable>(json);
//Console.WriteLine(json);
RepeaterAlbums.DataSource = table;
RepeaterAlbums.DataBind();
System.Diagnostics.Debug.WriteLine(json);
if (table != null)
{
if (table.Rows.Count <= 0)
{
System.Diagnostics.Debug.WriteLine("empty");
PanelWarning.Visible = true;
}
}
}
catch (Exception)
{
}
}
protected void LinkButton_OrderBy_Newest_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("SELECT TOP (5) Albums.Album_id, Genre.Genre_name, Albums.Album_artist, Albums.Album_img, Albums.Album_price, Albums.Album_name, Genre.Genre_id, Albums.Album_postdate FROM Albums INNER JOIN Genre ON Albums.fk_genre_id = Genre.Genre_id ORDER BY Album_postdate DESC", conn);
conn.Open();
RepeaterAlbums.DataSource = cmd.ExecuteReader();
RepeaterAlbums.DataBind();
conn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("SELECT Albums.Album_id, Genre.Genre_name, Albums.Album_artist, Albums.Album_img, Albums.Album_price, Albums.Album_name, Genre.Genre_id, Albums.Album_postdate FROM Albums INNER JOIN Genre ON Albums.fk_genre_id = Genre.Genre_id", conn);
conn.Open();
RepeaterAlbums.DataSource = cmd.ExecuteReader();
RepeaterAlbums.DataBind();
conn.Close();
GetAlbums();
}
private void GetAlbums()
{
int news_pr_side = 5;
int current_page = 1;
if (Request.QueryString["pagenr"] != null)
{
if (!int.TryParse(Request.QueryString["pagenr"].ToString(), out current_page))
{
current_page = 1;
}
}
int total_pages = (int)Math.Ceiling(AntalAlbums() / (double)news_pr_side);
string links = "<ul class='pagination'>";
for (int i = 1; i <= total_pages; i++)
{
links += "<li " + (current_page == i ? "class='active'" : "") + ">";
links += "<a href='MusicShop.aspx?pagenr=" + i + "'>" + i + "</a>";
links += "</li>";
}
links += "</ul>";
Literal_Pager.Text = links;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = @"SELECT * FROM Albums INNER JOIN Genre ON Genre_id = Albums.fk_genre_id ORDER BY Album_postdate DESC OFFSET @offset ROWS FETCH NEXT @news_per_page ROWS ONLY";
cmd.Parameters.Add("@news_per_page", SqlDbType.Int).Value = news_pr_side;
int offset = (current_page - 1) * news_pr_side;
cmd.Parameters.Add("@offset", SqlDbType.Int).Value = offset;
conn.Open();
RepeaterAlbums.DataSource = cmd.ExecuteReader();
RepeaterAlbums.DataBind();
conn.Close();
}
private void getResults()
{
try
{
String URL = "http://localhost:55923/CDRestService.svc/GetData";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL);
request.KeepAlive = false;
WebResponse response = request.GetResponse();
StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
string json = reader.ReadToEnd();
DataTable table = JsonConvert.DeserializeObject <DataTable>(json);
//Console.WriteLine(json);
RepeaterAlbums.DataSource = table;
RepeaterAlbums.DataBind();
}
catch (Exception)
{
}
}