public static DBView[] getAll(bool includeDisabled)
{
try
{
// make sure the table is created - create a dummy object
DBView dummy = new DBView();
// retrieve all fields in the table
String sqlQuery = "select * from " + cTableName +
(includeDisabled ? string.Empty : " where " + cEnabled + " = 1")
+ " order by " + cSort;
SQLiteResultSet results = DBTVSeries.Execute(sqlQuery);
if (results.Rows.Count > 0)
{
DBView[] views = new DBView[results.Rows.Count];
for (int index = 0; index < results.Rows.Count; index++)
{
views[index] = new DBView();
views[index].Read(ref results, index);
}
return(views);
}
}
catch (Exception ex)
{
MPTVSeriesLog.Write("Error in DBView.Get (" + ex.Message + ").");
}
return(new DBView[0]);
}
public static DBView[] getTaggedViews()
{
try {
// Make sure the table is created - create a dummy object
DBView dummy = new DBView();
// Only get Tagged Views
String sqlQuery = "select * from " + cTableName + " where " + cTaggedView + " = 1";
SQLiteResultSet results = DBTVSeries.Execute(sqlQuery);
if (results.Rows.Count > 0)
{
DBView[] views = new DBView[results.Rows.Count];
for (int index = 0; index < results.Rows.Count; index++)
{
views[index] = new DBView();
views[index].Read(ref results, index);
}
return(views);
}
}
catch (Exception ex) {
MPTVSeriesLog.Write("Error in retrieving Tagged Views (" + ex.Message + ").");
}
return(new DBView[0]);
}
public static List <logicalView> getAll(bool includeDisabled)
{
List <logicalView> views = new List <logicalView>();
foreach (DBView view in DBView.getAll(includeDisabled))
{
views.Add(new logicalView(view));
}
return(views);
}
/// <summary>
/// Get a list of views in users database that skin can present for menu
/// Returns a list of keyvaluepairs, where
/// Key: is the view name used in the buttons hyperlinkparameter property
/// Val: can be used as a default display name for the menu item
/// </summary>
public static List <KeyValuePair <string, string> > GetSkinViews()
{
List <KeyValuePair <string, string> > viewList = new List <KeyValuePair <string, string> >();
foreach (DBView view in DBView.getAll(false))
{
string viewName = view[DBView.cTransToken];
string viewDisplayName = string.IsNullOrEmpty(Translation.GetByName(viewName)) ? viewName : Translation.GetByName(viewName);
KeyValuePair <string, string> skinview = new KeyValuePair <string, string>(viewName, viewDisplayName);
viewList.Add(skinview);
}
return(viewList);
}
public static void AddView(int index, string name, string prettyname, string config, bool tagview)
{
DBView view = new DBView();
view[cIndex] = index;
view[cEnabled] = "1";
view[cSort] = index + 1;
view[cTransToken] = name;
view[cPrettyName] = prettyname;
view[cViewConfig] = config;
view[cTaggedView] = tagview;
view[cParentalControl] = "0";
view.Commit();
return;
}
public logicalView(DBView fromDB)
{
string[] steps = System.Text.RegularExpressions.Regex.Split(fromDB[DBView.cViewConfig], logicalViewStep.s_stepSeperator);
bool hasSeriesBeforeIt = false;
this.m_name = fromDB[DBView.cTransToken];
this.m_prettyName = fromDB[DBView.cPrettyName].ToString().Length == 0 ? Translation.GetByName(this.m_name) : (String)fromDB[DBView.cPrettyName];
this.m_uniqueID = fromDB[DBView.cIndex];
this.m_Enabled = fromDB[DBView.cEnabled];
this.IsTaggedView = fromDB[DBView.cTaggedView];
this.ParentalControl = fromDB[DBView.cParentalControl];
if (Settings.isConfig)
{
m_toUpdateForConfig = fromDB;
}
//steps[0] = steps[0].Split(new string[] { "<name>" }, StringSplitOptions.RemoveEmptyEntries)[1];
for (int i = 0; i < steps.Length; i++)
{
this.m_steps.Add(logicalViewStep.parseFromDB(steps[i], hasSeriesBeforeIt));
//if (this.steps[i].Type == logicalViewStep.type.group) isGroupType = true;
// inherit the conditions, so each step will always have all the conditions from steps before it!
if (i > 0)
{
foreach (string condsToInh in this.m_steps[i - 1].conditionsToInherit)
{
// Don't inherit series conditions in season/episode view
// 50 Times slower getting episode list if you do!!
// There is no need to inherit at the Episode step if Series step exists
if (!(condsToInh.Contains("<Series") && hasSeriesBeforeIt))
{
this.m_steps[i].addInheritedConditions(condsToInh);
}
}
}
// so lists can query if they'll have to append the seriesname in episode view (when no series was selected, eg. Flat View
if (this.m_steps[i].Type == logicalViewStep.type.series)
{
hasSeriesBeforeIt = true;
}
}
}
public logicalView(DBView fromDB)
{
string[] steps = System.Text.RegularExpressions.Regex.Split(fromDB[DBView.cViewConfig], logicalViewStep.s_stepSeperator);
bool hasSeriesBeforeIt = false;
this.m_name = fromDB[DBView.cTransToken];
this.m_prettyName = fromDB[DBView.cPrettyName].ToString().Length == 0 ? Translation.GetByName(this.m_name) : (String)fromDB[DBView.cPrettyName];
this.m_uniqueID = fromDB[DBView.cIndex];
this.m_Enabled = fromDB[DBView.cEnabled];
this.IsTaggedView = fromDB[DBView.cTaggedView];
this.ParentalControl = fromDB[DBView.cParentalControl];
if (Settings.isConfig) m_toUpdateForConfig = fromDB;
//steps[0] = steps[0].Split(new string[] { "<name>" }, StringSplitOptions.RemoveEmptyEntries)[1];
for (int i = 0; i < steps.Length; i++)
{
this.m_steps.Add(logicalViewStep.parseFromDB(steps[i], hasSeriesBeforeIt));
//if (this.steps[i].Type == logicalViewStep.type.group) isGroupType = true;
// inherit the conditions, so each step will always have all the conditions from steps before it!
if (i > 0)
{
foreach (string condsToInh in this.m_steps[i - 1].conditionsToInherit)
{
// Don't inherit series conditions in season/episode view
// 50 Times slower getting episode list if you do!!
// There is no need to inherit at the Episode step if Series step exists
if (!(condsToInh.Contains("<Series") && hasSeriesBeforeIt)) {
this.m_steps[i].addInheritedConditions(condsToInh);
}
}
}
// so lists can query if they'll have to append the seriesname in episode view (when no series was selected, eg. Flat View
if (this.m_steps[i].Type == logicalViewStep.type.series)
hasSeriesBeforeIt = true;
}
}
private void btnRemoveView_Click(object sender, EventArgs e) {
if (availViews.Count == 0)
return;
// Get Selected View from list
selectedView = Helper.getElementFromList<logicalView, string>((string)_availViews.SelectedItem, "Name", 0, availViews);
// Confirm Delete
string message = string.Format("Are you sure you want to delete view \"{0}\"?",selectedView.prettyName);
DialogResult result = MessageBox.Show(message, "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.No)
return;
// if view is a tagged view, remove series attached to view
if (selectedView.IsTaggedView)
{
// Get list of series in view
SQLCondition conditions = new SQLCondition();
conditions.Add(new DBOnlineSeries(), DBOnlineSeries.cViewTags, selectedView.Name, SQLConditionType.Like);
List<DBSeries> series = DBSeries.Get(conditions);
foreach (DBSeries s in series)
{
s[DBOnlineSeries.cViewTags] = Helper.GetSeriesViewTags(s, false, selectedView.Name);
s.Commit();
// Remove from online database
if (selectedView.Name == DBView.cTranslateTokenOnlineFavourite)
Online_Parsing_Classes.OnlineAPI.ConfigureFavourites(false, DBOption.GetOptions(DBOption.cOnlineUserID), s[DBOnlineSeries.cID]);
}
}
// Get All current Views
DBView[] views = DBView.getAll(true);
// Remove all Rows from Database
DBView.ClearAll();
int index = 0;
// Add Rows back excluding deleted one
foreach (DBView view in views) {
if (view[DBView.cIndex] != int.Parse(selectedView.m_uniqueID)) {
DBView newView = new DBView();
newView[DBView.cIndex] = index;
newView[DBView.cEnabled] = view[DBView.cEnabled];
newView[DBView.cSort] = view[DBView.cSort];
newView[DBView.cTransToken] = view[DBView.cTransToken];
newView[DBView.cPrettyName] = view[DBView.cPrettyName];
newView[DBView.cViewConfig] = view[DBView.cViewConfig];
newView[DBView.cTaggedView] = view[DBView.cTaggedView];
newView[DBView.cParentalControl] = view[DBView.cParentalControl];
newView.Commit();
index++;
}
}
// Reload List and available Views
LoadViews();
// Select First Item in list
if (_availViews.Items.Count > 0)
_availViews.SelectedIndex = 0;
}
public static void fillDefaults()
{
DBView dummy = new DBView();
DBView[] views = DBView.getAll(true);
if (views == null || views.Length == 0)
{
// no views in the db => put the default ones
DBView view = new DBView();
view[cIndex] = "0";
view[cEnabled] = "1";
view[cSort] = "1";
view[cTransToken] = cTranslateTokenAll;
view[cPrettyName] = "";
view[cViewConfig] = @"series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "1";
view[cEnabled] = "1";
view[cSort] = "2";
view[cTransToken] = cTranslateTokenFavourite;
view[cPrettyName] = "";
view[cViewConfig] = GetTaggedViewConfigString(cTranslateTokenFavourite);
view[cTaggedView] = "1";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "2";
view[cEnabled] = "1";
view[cSort] = "3";
view[cTransToken] = cTranslateTokenOnlineFavourite;
view[cPrettyName] = "";
view[cViewConfig] = GetTaggedViewConfigString(cTranslateTokenOnlineFavourite);
view[cTaggedView] = "1";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "3";
view[cEnabled] = "1";
view[cSort] = "4";
view[cTransToken] = cTranslateTokenUnwatched;
view[cPrettyName] = "";
view[cViewConfig] = @"series<;><Episode.Watched>;=;0<;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "4";
view[cEnabled] = "1";
view[cSort] = "5";
view[cTransToken] = cTranslateTokenChannels;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.Network><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "5";
view[cEnabled] = "1";
view[cSort] = "6";
view[cTransToken] = cTranslateTokenGenres;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.Genre><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "6";
view[cEnabled] = "1";
view[cSort] = "7";
view[cTransToken] = cTranslateTokenContentRating;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.ContentRating><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "7";
view[cEnabled] = "1";
view[cSort] = "8";
view[cTransToken] = cTranslateTokenViewTags;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.ViewTags><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "8";
view[cEnabled] = "1";
view[cSort] = "9";
view[cTransToken] = cTranslateTokenLatest;
view[cPrettyName] = "";
view[cViewConfig] = @"episode<;><Episode.FirstAired>;<=;<today><cond><Episode.FirstAired>;>=;<today-30><;><Episode.FirstAired>;desc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "9";
view[cEnabled] = "1";
view[cSort] = "10";
view[cTransToken] = cTranslateTokenRecentlyAdded;
view[cPrettyName] = "";
view[cViewConfig] = @"episode<;><Episode.FileDateCreated>;>=;<today-7><;><Episode.FileDateCreated>;desc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
}
int nCurrentDBVersion = cDBVersion;
int nUpgradeDBVersion = DBOption.GetOptions(DBOption.cDBViewsVersion);
while (nUpgradeDBVersion != nCurrentDBVersion)
{
// WARNING: as of version 4, we can now remove and add views.
// Be particularly carefull if adding/Removing/Updating
// take care of the upgrade in the table
switch (nUpgradeDBVersion)
{
case 1:
//Upgrade to version 2; 'Latest' view doesn't show anything from the future, and shows only from the last 30 days
DBView view = new DBView(5);
view[cViewConfig] = @"episode<;><Episode.FirstAired>;<=;<today><cond><Episode.FirstAired>;>=;<today-30><;><Episode.FirstAired>;desc<;>";
view.Commit();
nUpgradeDBVersion++;
break;
case 2:
// Upgrade to version 3, new view 'Recently Added'
view = new DBView();
view[cIndex] = "6";
view[cEnabled] = "1";
view[cSort] = "7";
view[cTransToken] = cTranslateTokenRecentlyAdded;
view[cPrettyName] = "";
view[cViewConfig] = @"episode<;><Episode.FileDateCreated>;>=;<today-7><;><Episode.FileDateCreated>;desc<;>";
view.Commit();
nUpgradeDBVersion++;
break;
case 3:
// Upgrade to version 4, new view 'Content Rating'
view = new DBView();
view[cIndex] = "7";
view[cEnabled] = "1";
view[cSort] = "8";
view[cTransToken] = cTranslateTokenContentRating;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.ContentRating><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cParentalControl] = "0";
view.Commit();
// New view 'View Tags'
view = new DBView();
view[cIndex] = "8";
view[cEnabled] = "1";
view[cSort] = "9";
view[cTransToken] = cTranslateTokenViewTags;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.ViewTags><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cParentalControl] = "0";
view.Commit();
nUpgradeDBVersion++;
break;
case 4:
// Get All current Views
DBView[] viewList = DBView.getAll(true);
// Update old Favourite View to Tagged View
foreach (DBView v in viewList)
{
if (v[DBView.cTransToken] == cTranslateTokenFavourite)
{
v[cTaggedView] = "1";
v[cTransToken] = cTranslateTokenFavourite;
v[cPrettyName] = "";
v[cViewConfig] = GetTaggedViewConfigString(cTranslateTokenFavourite);
v.Commit();
}
}
// Add Online Favourites as Taqged View
view = new DBView();
view[cIndex] = viewList.Length;
view[cEnabled] = "1";
view[cSort] = viewList.Length + 1;
view[cTransToken] = cTranslateTokenOnlineFavourite;
view[cPrettyName] = "";
view[cViewConfig] = GetTaggedViewConfigString(cTranslateTokenOnlineFavourite);
view[cParentalControl] = "0";
view[cTaggedView] = "1";
view.Commit();
nUpgradeDBVersion++;
break;
default:
nUpgradeDBVersion = nCurrentDBVersion;
break;
}
}
DBOption.SetOptions(DBOption.cDBViewsVersion, nCurrentDBVersion);
}
public static void fillDefaults()
{
DBView dummy = new DBView();
DBView[] views = DBView.getAll(true);
if (views == null || views.Length == 0)
{
// no views in the db => put the default ones
DBView view = new DBView();
view[cIndex] = "0";
view[cEnabled] = "1";
view[cSort] = "1";
view[cTransToken] = cTranslateTokenAll;
view[cPrettyName] = "";
view[cViewConfig] = @"series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "1";
view[cEnabled] = "1";
view[cSort] = "2";
view[cTransToken] = cTranslateTokenFavourite;
view[cPrettyName] = "";
view[cViewConfig] = GetTaggedViewConfigString(cTranslateTokenFavourite);
view[cTaggedView] = "1";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "2";
view[cEnabled] = "1";
view[cSort] = "3";
view[cTransToken] = cTranslateTokenOnlineFavourite;
view[cPrettyName] = "";
view[cViewConfig] = GetTaggedViewConfigString(cTranslateTokenOnlineFavourite);
view[cTaggedView] = "1";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "3";
view[cEnabled] = "1";
view[cSort] = "4";
view[cTransToken] = cTranslateTokenUnwatched;
view[cPrettyName] = "";
view[cViewConfig] = @"series<;><Episode.Watched>;=;0<;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "4";
view[cEnabled] = "1";
view[cSort] = "5";
view[cTransToken] = cTranslateTokenChannels;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.Network><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "5";
view[cEnabled] = "1";
view[cSort] = "6";
view[cTransToken] = cTranslateTokenGenres;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.Genre><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "6";
view[cEnabled] = "1";
view[cSort] = "7";
view[cTransToken] = cTranslateTokenContentRating;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.ContentRating><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "7";
view[cEnabled] = "1";
view[cSort] = "8";
view[cTransToken] = cTranslateTokenViewTags;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.ViewTags><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "8";
view[cEnabled] = "1";
view[cSort] = "9";
view[cTransToken] = cTranslateTokenLatest;
view[cPrettyName] = "";
view[cViewConfig] = @"episode<;><Episode.FirstAired>;<=;<today><cond><Episode.FirstAired>;>=;<today-30><;><Episode.FirstAired>;desc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
view = new DBView();
view[cIndex] = "9";
view[cEnabled] = "1";
view[cSort] = "10";
view[cTransToken] = cTranslateTokenRecentlyAdded;
view[cPrettyName] = "";
view[cViewConfig] = @"episode<;><Episode.FileDateCreated>;>=;<today-7><;><Episode.FileDateCreated>;desc<;>";
view[cTaggedView] = "0";
view[cParentalControl] = "0";
view.Commit();
}
int nCurrentDBVersion = cDBVersion;
int nUpgradeDBVersion = DBOption.GetOptions(DBOption.cDBViewsVersion);
while (nUpgradeDBVersion != nCurrentDBVersion)
{
// WARNING: as of version 4, we can now remove and add views.
// Be particularly carefull if adding/Removing/Updating
// take care of the upgrade in the table
switch (nUpgradeDBVersion)
{
case 1:
//Upgrade to version 2; 'Latest' view doesn't show anything from the future, and shows only from the last 30 days
DBView view = new DBView(5);
view[cViewConfig] = @"episode<;><Episode.FirstAired>;<=;<today><cond><Episode.FirstAired>;>=;<today-30><;><Episode.FirstAired>;desc<;>";
view.Commit();
nUpgradeDBVersion++;
break;
case 2:
// Upgrade to version 3, new view 'Recently Added'
view = new DBView();
view[cIndex] = "6";
view[cEnabled] = "1";
view[cSort] = "7";
view[cTransToken] = cTranslateTokenRecentlyAdded;
view[cPrettyName] = "";
view[cViewConfig] = @"episode<;><Episode.FileDateCreated>;>=;<today-7><;><Episode.FileDateCreated>;desc<;>";
view.Commit();
nUpgradeDBVersion++;
break;
case 3:
// Upgrade to version 4, new view 'Content Rating'
view = new DBView();
view[cIndex] = "7";
view[cEnabled] = "1";
view[cSort] = "8";
view[cTransToken] = cTranslateTokenContentRating;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.ContentRating><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cParentalControl] = "0";
view.Commit();
// New view 'View Tags'
view = new DBView();
view[cIndex] = "8";
view[cEnabled] = "1";
view[cSort] = "9";
view[cTransToken] = cTranslateTokenViewTags;
view[cPrettyName] = "";
view[cViewConfig] = @"group:<Series.ViewTags><;><;><;>" +
"<nextStep>series<;><;><;>" +
"<nextStep>season<;><;><Season.seasonIndex>;asc<;>" +
"<nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>";
view[cParentalControl] = "0";
view.Commit();
nUpgradeDBVersion++;
break;
case 4:
// Get All current Views
DBView[] viewList = DBView.getAll(true);
// Update old Favourite View to Tagged View
foreach (DBView v in viewList) {
if (v[DBView.cTransToken] == cTranslateTokenFavourite) {
v[cTaggedView] = "1";
v[cTransToken] = cTranslateTokenFavourite;
v[cPrettyName] = "";
v[cViewConfig] = GetTaggedViewConfigString(cTranslateTokenFavourite);
v.Commit();
}
}
// Add Online Favourites as Taqged View
view = new DBView();
view[cIndex] = viewList.Length;
view[cEnabled] = "1";
view[cSort] = viewList.Length + 1;
view[cTransToken] = cTranslateTokenOnlineFavourite;
view[cPrettyName] = "";
view[cViewConfig] = GetTaggedViewConfigString(cTranslateTokenOnlineFavourite);
view[cParentalControl] = "0";
view[cTaggedView] = "1";
view.Commit();
nUpgradeDBVersion++;
break;
default:
nUpgradeDBVersion = nCurrentDBVersion;
break;
}
}
DBOption.SetOptions(DBOption.cDBViewsVersion, nCurrentDBVersion);
}
public static void AddView(int index, string name, string prettyname, string config, bool tagview) {
DBView view = new DBView();
view[cIndex] = index;
view[cEnabled] = "1";
view[cSort] = index + 1;
view[cTransToken] = name;
view[cPrettyName] = prettyname;
view[cViewConfig] = config;
view[cTaggedView] = tagview;
view[cParentalControl] = "0";
view.Commit();
return;
}
public static DBView[] getTaggedViews() {
try {
// Make sure the table is created - create a dummy object
DBView dummy = new DBView();
// Only get Tagged Views
String sqlQuery = "select * from " + cTableName + " where " + cTaggedView + " = 1";
SQLiteResultSet results = DBTVSeries.Execute(sqlQuery);
if (results.Rows.Count > 0) {
DBView[] views = new DBView[results.Rows.Count];
for (int index = 0; index < results.Rows.Count; index++) {
views[index] = new DBView();
views[index].Read(ref results, index);
}
return views;
}
}
catch (Exception ex) {
MPTVSeriesLog.Write("Error in retrieving Tagged Views (" + ex.Message + ").");
}
return new DBView[0];
}
public static DBView[] getAll(bool includeDisabled)
{
try
{
// make sure the table is created - create a dummy object
DBView dummy = new DBView();
// retrieve all fields in the table
String sqlQuery = "select * from " + cTableName +
(includeDisabled ? string.Empty : " where " + cEnabled + " = 1")
+ " order by " + cSort;
SQLiteResultSet results = DBTVSeries.Execute(sqlQuery);
if (results.Rows.Count > 0)
{
DBView[] views = new DBView[results.Rows.Count];
for (int index = 0; index < results.Rows.Count; index++)
{
views[index] = new DBView();
views[index].Read(ref results, index);
}
return views;
}
}
catch (Exception ex)
{
MPTVSeriesLog.Write("Error in DBView.Get (" + ex.Message + ").");
}
return new DBView[0];
}
