public static DataSet GetSystems(string id)
{
MySQLParameterList sqlParams = new MySQLParameterList();
sqlParams.AddParameter("p_systemId", id);
return(MySQLDatabaseManager.GetDataSet("spGetSystem", sqlParams));
}
// admin only view
public static DataSet GetAdminAds()
{
// MySQLParameterList sqlParams = new MySQLParameterList();
//sqlParams.AddParameter("p_systemid", 0);
//sqlParams.AddParameter("p_userid", 0);
return(MySQLDatabaseManager.GetDataSet("spGetContentAdList"));
}
public static DataSet GetMyAdContentGrid(string btvuser)
{
MySQLParameterList sqlParams = new MySQLParameterList();
sqlParams.AddParameter("p_systemid", 0);
sqlParams.AddParameter("p_btvuserid", btvuser);
return(MySQLDatabaseManager.GetDataSet("spGetMyContentGrid", sqlParams));
}
public static DataSet GetTemplateList()
{
return(MySQLDatabaseManager.GetDataSet("spGetTemplateList"));
}
public static DataSet GetAllSystems()
{
return(MySQLDatabaseManager.GetDataSet("spGetAllSystems"));
}
public static DataSet GetcontentadList()
{
return(MySQLDatabaseManager.GetDataSet("spGetContentAdList"));
}