public static void MarkContentRecordasDeleted(string id)
{
MySQLParameterList sqlParams = new MySQLParameterList();
sqlParams.AddParameter("p_idContentAd", id);
MySQLDatabaseManager.ExecuteNonQuery("spMarkContentRecordasDeleted", sqlParams);
}
public static void AdminApprovedContentAd(string id)
{
MySQLParameterList sqlParams = new MySQLParameterList();
sqlParams.AddParameter("p_idContentAd", id);
MySQLDatabaseManager.ExecuteNonQuery(" btvAdminapprovedContentAd", sqlParams);
}
public static void AdminDeleteContentAd(string id)
{
MySQLParameterList sqlParams = new MySQLParameterList();
sqlParams.AddParameter("p_idContentAd", id);
sqlParams.AddParameter("p_status", "deleted");
MySQLDatabaseManager.ExecuteNonQuery("btvAdminUpdateContentAdRecordStatus", sqlParams);
}
public static void RegisterUser(string name, string email, string pwd, string guidgen)
{
MySQLParameterList sqlParams = new MySQLParameterList();
sqlParams.AddParameter("p_name", name);
sqlParams.AddParameter("p_email", email);
sqlParams.AddParameter("p_pwd", pwd);
sqlParams.AddParameter("p_guid", guidgen);
MySQLDatabaseManager.ExecuteNonQuery("spRegisterBTVuser", sqlParams);
}
public static int CheckEmailGuid(string email, string confirmguid)
{
MySQLParameterList sqlParams = new MySQLParameterList();
sqlParams.AddParameter("p_email", email);
sqlParams.AddParameter("p_guid", confirmguid);
int rows = 0;
rows = MySQLDatabaseManager.ExecuteNonQuery("spCheckEmailGuid", sqlParams);
return(rows);
}
