private void senddatatohistory() { var connectionn = DBFunctions.OpenConnection(); if (connectionn == null) { return; } string sqlText = string.Format("SELECT cout(id) FROM historyvideo WHERE videoid = {0};", videoID); var connection = DBFunctions.OpenConnection(); if (connection == null) { return; } if ((ulong)DBFunctions.ExecuteSqlScalar(sqlText, connection) == 0) { sqlText = string.Format("INSERT INTO historyvideo VALUES(null, {0}, {1});", user.user_ID, videoID); DBFunctions.ExecuteSqlNoReturn(sqlText, connection); connection.Close(); connection.Dispose(); } else { sqlText = string.Format("UPDATE historyvideo SET id=null WHERE videoid='{0}';", videoID); DBFunctions.ExecuteSqlNoReturn(sqlText, connection); connection.Close(); connection.Dispose(); } }
private void label7_Click(object sender, EventArgs e) { if (active == false) { MessageBox.Show("You need to login first!"); return; } if (label7.ForeColor == Color.WhiteSmoke) { string sqlText = "SELECT DislikeCount from videos where videolink='" + axShockwaveFlash1.Movie + "';"; var connection = DBFunctions.OpenConnection(); if (connection == null) { return; } ulong dislikes = (ulong)DBFunctions.ExecuteSqlScalar(sqlText, connection); dislikes++; string sqlText2 = string.Format("UPDATE videos SET dislikecount='{0}' WHERE videolink='{1}';", dislikes, axShockwaveFlash1.Movie); DBFunctions.ExecuteSqlNoReturn(sqlText2, connection); connection.Close(); connection.Dispose(); label7.ForeColor = Color.Red; like.Enabled = false; connection.Close(); connection.Dispose(); updatelikesandviews(); addtodislikedvideos(); } else if (label7.ForeColor == Color.Red) { string sqlText = "select dislikecount from videos where videolink='" + axShockwaveFlash1.Movie + "';"; var connection = DBFunctions.OpenConnection(); if (connection == null) { return; } ulong dislikes = (ulong)DBFunctions.ExecuteSqlScalar(sqlText, connection); dislikes--; string sqlText2 = string.Format("UPDATE videos SET dislikecount='{0}' WHERE videolink='{1}';", dislikes, axShockwaveFlash1.Movie); DBFunctions.ExecuteSqlNoReturn(sqlText2, connection); connection.Close(); connection.Dispose(); label7.ForeColor = Color.WhiteSmoke; like.Enabled = true; connection.Close(); connection.Dispose(); updatelikesandviews(); deletefromdislikedvideos(); } }
private void sendRegInfoToDatabase(ulong channelID, string name, string videolink, ulong views, ulong likes, ulong dislikes, string discription, DateTime uploadtime) { string sqlText = string.Format("INSERT INTO videos VALUES(null,{0},'{1}','{2}',{3},{4},{5},'{6}','{7}');", channelID, name, videolink, views, likes, dislikes, discription, uploadtime.ToString()); var connection = DBFunctions.OpenConnection(); //get connection to server if (connection == null) { return; } DBFunctions.ExecuteSqlNoReturn(sqlText, connection); connection.Close(); connection.Dispose(); }
private void deletefromdislikedvideos() { var connection = DBFunctions.OpenConnection(); if (connection == null) { return; } string sqlText2 = string.Format("DELETE FROM dislikes WHERE videoID = {0} AND userID = {1};", videoID, user.user_ID); DBFunctions.ExecuteSqlNoReturn(sqlText2, connection); connection.Close(); connection.Dispose(); }
private void addtodislikedvideos() { var connection = DBFunctions.OpenConnection(); if (connection == null) { return; } string sqlText2 = string.Format("INSERT INTO dislikes VALUES(null, {0}, {1});", videoID, user.user_ID); DBFunctions.ExecuteSqlNoReturn(sqlText2, connection); connection.Close(); connection.Dispose(); }
private void sendRegInfoToDatabase(string username, string password, string email, string color, int subs) { string sqlText = string.Format("INSERT INTO logins VALUES(null,'{0}','{1}','{2}','{3}',{4});", username, PasswordClass.GetMD5hash(textBox3.Text), email, color, subs); var connection = DBFunctions.OpenConnection(); //get connection to server if (connection == null) { return; } DBFunctions.ExecuteSqlNoReturn(sqlText, connection); connection.Close(); connection.Dispose(); }
private void coutviews() { string sqlText = "select views from videos where videolink='" + axShockwaveFlash1.Movie + "';"; var connection = DBFunctions.OpenConnection(); if (connection == null) { return; } ulong views = (ulong)DBFunctions.ExecuteSqlScalar(sqlText, connection); views++; string sqlText2 = string.Format("UPDATE videos SET views='{0}' WHERE videolink='{1}';", views, axShockwaveFlash1.Movie); DBFunctions.ExecuteSqlNoReturn(sqlText2, connection); connection.Close(); connection.Dispose(); }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text == textBox2.Text) { string sqlText = string.Format("select password from logins where email='{0}';", emailas); var connection = DBFunctions.OpenConnection(); if (connection == null) { return; } OldPassword = (string)DBFunctions.ExecuteSqlScalar(sqlText, connection); sqlText = string.Format("UPDATE logins SET Password='******' WHERE Password='******';", PasswordClass.GetMD5hash(textBox2.Text), OldPassword); DBFunctions.ExecuteSqlNoReturn(sqlText, connection); connection.Close(); connection.Dispose(); } }
private void label10_Click(object sender, EventArgs e) { try { var connection = DBFunctions.OpenConnection(); if (connection == null) { return; } string sqlText = string.Format("UPDATE videos SET name='{0}',videolink = '{1}',description = '{2}' WHERE videolink='{3}';", textBox1.Text, textBox2.Text, textBox3.Text, link); DBFunctions.ExecuteSqlNoReturn(sqlText, connection); connection.Close(); connection.Dispose(); MessageBox.Show("Video was succsesfully updated!"); this.Hide(); } catch { MessageBox.Show("Failed while updating video!"); } }