public void loaduploads() { if (this.Controls.ContainsKey("hmw")) { this.Controls.RemoveByKey("hmw"); } if (this.Controls.ContainsKey("wthvid")) { this.Controls.RemoveByKey("wthvid"); } if (this.Controls.ContainsKey("channel")) { this.Controls.RemoveByKey("channel"); } homeview hmv = new homeview(this); hmv.Name = "hmw"; hmv.label4.BackColor = Color.Red; var connectionn = DBFunctions.OpenConnection(); if (connectionn == null) { return; } int x = 10; int y = 10; int arjau = 0; string sqlText1 = string.Format("SELECT videos.name,videos.views,videos.ChannelID,videos.videolink,videos.uploaddate,logins.username FROM videos JOIN logins ON videos.channelid = logins.ID ORDER BY uploaddate DESC limit 16;"); var readerr = DBFunctions.ExecuteSqlSelect(sqlText1, connectionn); if (readerr == null) { return; } while (readerr.Read()) { //string sqlText3 = string.Format("SELECT username from logins where ID = {0};", readerr[2] ); // string name = (string)DBFunctions.ExecuteSqlScalar(sqlText3, connectionn); vid vidd = new vid(); vidd.label1.Text = readerr[1].ToString(); vidd.linkLabel1.Text = readerr[0].ToString() + " views"; vidd.linkLabel2.Text = readerr[5].ToString(); vidd.linkLabel1.Name = readerr[3].ToString(); vidd.linkLabel2.Name = readerr[2].ToString(); if (active == true && Convert.ToUInt64(readerr[2]) == user.user_ID) { vidd.button1.Visible = true; vidd.button1.Name = readerr[2].ToString(); } else { vidd.button1.Visible = false; } vidd.button1.Click += Button1_Click; vidd.linkLabel2.Click += LinkLabel2_Click; vidd.linkLabel1.Click += LinkLabel1_Click; string a = getYouTubeThumbnail(readerr[3].ToString()); var request = WebRequest.Create(a); using (var response = request.GetResponse()) using (var stream = response.GetResponseStream()) { vidd.pictureBox1.Image = Bitmap.FromStream(stream); } vidd.Location = new Point(x, y); hmv.panel1.Controls.Add(vidd); arjau++; x += 220; if (arjau == 4) { x = 10; y += 200; arjau = 0; } } hmv.Location = new Point(259, 124); this.Controls.Add(hmv); readerr.Close(); readerr.Dispose(); connectionn.Close(); connectionn.Dispose(); }
public void loadchannel(long id) { var connectionn = DBFunctions.OpenConnection(); if (connectionn == null) { return; } channel chl = new channel(); int x = 10; int y = 10; int arjau = 0; string sqlTxt = string.Format("SELECT username from logins where id = {0}", id); var read = DBFunctions.ExecuteSqlSelect(sqlTxt, connectionn); if (read == null) { return; } while (read.Read()) { username = read[0].ToString(); } read.Close(); read.Dispose(); string sqlText1 = string.Format("SELECT videos.name,videos.views,videos.ChannelID,videos.videolink,videos.uploaddate FROM videos WHERE channelID = {0};", id); var readerr = DBFunctions.ExecuteSqlSelect(sqlText1, connectionn); if (readerr == null) { return; } while (readerr.Read()) { //string sqlText3 = string.Format("SELECT username from logins where ID = {0};", readerr[2] ); // string name = (string)DBFunctions.ExecuteSqlScalar(sqlText3, connectionn); vid vidd = new vid(); vidd.label1.Text = readerr[1].ToString(); vidd.linkLabel1.Text = readerr[0].ToString() + " views"; vidd.linkLabel2.Text = username; vidd.linkLabel1.Name = readerr[3].ToString(); vidd.linkLabel2.Name = readerr[2].ToString(); if (active == true && Convert.ToUInt64(readerr[2]) == user.user_ID) { vidd.button1.Visible = true; vidd.button1.Name = readerr[3].ToString(); } else { vidd.button1.Visible = false; } vidd.linkLabel1.Name = readerr[3].ToString(); vidd.linkLabel1.Click += LinkLabel1_Click; string a = getYouTubeThumbnail(readerr[3].ToString()); var request = WebRequest.Create(a); using (var response = request.GetResponse()) using (var stream = response.GetResponseStream()) { vidd.pictureBox1.Image = Bitmap.FromStream(stream); } vidd.Location = new Point(x, y); chl.panel1.Controls.Add(vidd); arjau++; x += 220; if (arjau == 4) { x = 10; y += 200; arjau = 0; } } readerr.Close(); readerr.Dispose(); connectionn.Close(); connectionn.Dispose(); }