public static void DelT(string uid, int sid)
{
string deleteSQL;
uid = stringbuilder(uid);
deleteSQL = "DELETE * from " + TABEL + " where " + filed1 + "=" + uid + " AND " + filed2 + "=" + sid;
OleDbHelper.DoQuery(deleteSQL);
}
public static void UpdateAdminBySubID(string name, string pass, int subid)
{
// OleDbHelper.DoQuery("UPDATE UserTBL SET pass='******', MyAdmin='" + MyAdmin + "',sub='" + sub + "' , email='" + email + "' WHERE username='******'");
name = stringbuilder(name);
pass = stringbuilder(pass);
string id = stringbuilder(subid.ToString());
OleDbHelper.DoQuery("UPDATE " + TABEL + " SET " + filed2 + "=" + name + ", " + filed3 + "=" + pass + " WHERE " + filed1 + "=" + subid.ToString());
}
public static void UpdateRateByID(string Author, int stars, int EpiNun, int subid)
{
Author = stringbuilder(Author);
string stars11 = stringbuilder(stars.ToString());
string EpiNun1 = stringbuilder(EpiNun.ToString());
string id = stringbuilder(subid.ToString());
OleDbHelper.DoQuery("UPDATE " + TABEL + " SET " + filed2 + "=" + stars11 + ", " + filed3 + "=" + Author + "," + filed4 + "=" + EpiNun1 + " WHERE " + filed1 + "=" + subid.ToString());
}
public static void UpdatePlaylistByID(string user, int subid)
{
user = stringbuilder(user);
string id = stringbuilder(subid.ToString());
OleDbHelper.DoQuery("UPDATE " + TABEL + " SET " + filed2 + "=" + user + " WHERE " + filed1 + "=" + subid.ToString());
}
public static void UpdateUserBySubID(string des, int amount, int samonunt, int subid)
{
// OleDbHelper.DoQuery("UPDATE UserTBL SET pass='******', MyAdmin='" + MyAdmin + "',sub='" + sub + "' , email='" + email + "' WHERE username='******'");
des = stringbuilder(des);
string amount1 = stringbuilder(amount.ToString());
string samount1 = stringbuilder(samonunt.ToString());
string id = stringbuilder(subid.ToString());
OleDbHelper.DoQuery("UPDATE " + TABEL + " SET " + filed2 + "=" + amount1 + ", " + filed3 + "=" + samount1 + "," + filed4 + "=" + des + " WHERE " + filed1 + "=" + subid.ToString());
}
public static void UpdateUserByUsername(string username, string pass, int MyAdmin, int sub, string email)
{
pass = "******" + pass + "'";
string admin1 = "'" + MyAdmin.ToString() + "'";
string sub1 = "'" + sub.ToString() + "'";
email = "'" + email + "'";
username = "******" + username + "'";
OleDbHelper.DoQuery("UPDATE UserTBL SET pass="******", MyAdmin=" + admin1 + ", subscriptiontype=" + sub1 + ", email=" + email + " WHERE username=" + username);
}
public static void UpdateUserBySubID(string des, int admin, string name, int subid, string genre)
{
des = stringbuilder(des);
string admin1 = stringbuilder(admin.ToString());
name = stringbuilder(name);
string id = stringbuilder(subid.ToString());
genre = stringbuilder(genre);
OleDbHelper.DoQuery("UPDATE " + TABEL + " SET " + filed2 + "=" + name + ", " + filed3 + "=" + admin + ", " + filed4 + "=" + des + ", " + filed5 + "=" + genre + " WHERE " + filed1 + "=" + subid.ToString());
}
public static void Insert(string username, string pass, int MyAdmin, int sub, string email, string card)
{
username = "******"" + username + "\"";
pass = "******"" + pass + "\"";
string MyAdmin1 = "\"" + MyAdmin.ToString() + "\"";
string sub1 = "\"" + sub.ToString() + "\"";
email = "\"" + email + "\"";
card = "\"" + card + "\"";
OleDbHelper.DoQuery("INSERT INTO UserTBL (username,pass,MyAdmin,subscriptiontype,email,CreditCard) VALUES (" + username + "," + pass + "," + MyAdmin1 + "," + sub1 + "," + email + "," + card + ")");
}
public static void UpdateUserBySubID(string name, int length, int series, int seasnenum, int epinum, int subid, string url)
{
// OleDbHelper.DoQuery("UPDATE UserTBL SET pass='******', MyAdmin='" + MyAdmin + "',sub='" + sub + "' , email='" + email + "' WHERE username='******'");
name = stringbuilder(name);
string length1 = stringbuilder(length.ToString());
string series1 = stringbuilder(series.ToString());
string seannum1 = stringbuilder(seasnenum.ToString());
string epinum1 = stringbuilder(epinum.ToString());
string id = stringbuilder(subid.ToString());
url = stringbuilder(url);
OleDbHelper.DoQuery("UPDATE " + TABEL + " SET " + filed2 + "=" + name + ", " + filed3 + "=" + length1 + ", " + filed4 + "=" + series1 + ", " + filed5 + "=" + seannum1 + ", " + filed6 + "=" + epinum1 + ", " + filed7 + "=" + url + " WHERE " + filed1 + "=" + subid.ToString());
}