public static List <GroupFilter> InitCache()
{
string t = "GroupFilter";
ServerState.Instance.CurrentSetupStatus = string.Format(JMMServer.Properties.Resources.Database_Cache, t, string.Empty);
GroupFilterConditionRepository repConds = new GroupFilterConditionRepository();
GroupFilterRepository repo = new GroupFilterRepository();
List <GroupFilter> filters = repo.InternalGetAll();
Cache = new PocoCache <int, GroupFilter>(filters, a => a.GroupFilterID);
Changes.AddOrUpdateRange(Cache.Keys);
Parents = Cache.CreateIndex(a => a.ParentGroupFilterID ?? 0);
Types =
new BiDictionaryManyToMany <int, GroupFilterConditionType>(Cache.Values.ToDictionary(
a => a.GroupFilterID,
a => a.Types));
List <GroupFilter> recalc = new List <GroupFilter>();
foreach (GroupFilter g in Cache.Values.ToList())
{
if (g.GroupFilterID != 0 && g.GroupsIdsVersion < GroupFilter.GROUPFILTER_VERSION ||
g.GroupConditionsVersion < GroupFilter.GROUPCONDITIONS_VERSION)
{
if (g.GroupConditionsVersion == 0)
{
g.Conditions = repConds.GetByGroupFilterID(g.GroupFilterID);
}
repo.Save(g, true);
recalc.Add(g);
}
}
return(recalc);
}
public static void InitCacheSecondPart(List <GroupFilter> recalc)
{
string t = "GroupFilter";
ServerState.Instance.CurrentSetupStatus = string.Format(JMMServer.Properties.Resources.Database_Cache, t, string.Empty);
GroupFilterRepository repo = new GroupFilterRepository();
foreach (GroupFilter g in Cache.Values.ToList())
{
if (g.GroupsIdsVersion < GroupFilter.GROUPFILTER_VERSION ||
g.GroupConditionsVersion < GroupFilter.GROUPCONDITIONS_VERSION ||
g.SeriesIdsVersion < GroupFilter.SERIEFILTER_VERSION)
{
if (!recalc.Contains(g))
{
recalc.Add(g);
}
}
}
int max = recalc.Count;
int cnt = 0;
foreach (GroupFilter gf in recalc)
{
cnt++;
ServerState.Instance.CurrentSetupStatus = string.Format(JMMServer.Properties.Resources.Database_Cache, t,
Properties.Resources.Filter_Recalc + " " + gf.GroupFilterName + " - " + cnt + "/" + max);
if (gf.GroupsIdsVersion < GroupFilter.GROUPFILTER_VERSION ||
gf.GroupConditionsVersion < GroupFilter.GROUPCONDITIONS_VERSION)
{
gf.EvaluateAnimeGroups();
}
if (gf.SeriesIdsVersion < GroupFilter.SERIEFILTER_VERSION ||
gf.GroupConditionsVersion < GroupFilter.GROUPCONDITIONS_VERSION)
{
gf.EvaluateAnimeSeries();
}
repo.Save(gf);
}
}
public Contract_GroupFilter_SaveResponse SaveGroupFilter(Contract_GroupFilter contract)
{
Contract_GroupFilter_SaveResponse response = new Contract_GroupFilter_SaveResponse();
response.ErrorMessage = string.Empty;
response.GroupFilter = null;
GroupFilterRepository repGF = new GroupFilterRepository();
GroupFilterConditionRepository repGFC = new GroupFilterConditionRepository();
// Process the group
GroupFilter gf = null;
if (contract.GroupFilterID.HasValue)
{
gf = repGF.GetByID(contract.GroupFilterID.Value);
if (gf == null)
{
response.ErrorMessage = "Could not find existing Group Filter with ID: " + contract.GroupFilterID.Value.ToString();
return response;
}
}
else
gf = new GroupFilter();
gf.GroupFilterName = contract.GroupFilterName;
gf.ApplyToSeries = contract.ApplyToSeries;
gf.BaseCondition = contract.BaseCondition;
gf.SortingCriteria = contract.SortingCriteria;
if (string.IsNullOrEmpty(gf.GroupFilterName))
{
response.ErrorMessage = "Must specify a group filter name";
return response;
}
repGF.Save(gf);
// Process the filter conditions
// check for any that have been deleted
foreach (GroupFilterCondition gfc in gf.FilterConditions)
{
bool gfcExists = false;
foreach (Contract_GroupFilterCondition gfc_con in contract.FilterConditions)
{
if (gfc_con.GroupFilterConditionID.HasValue && gfc_con.GroupFilterConditionID.Value == gfc.GroupFilterConditionID)
{
gfcExists = true;
break;
}
}
if (!gfcExists)
repGFC.Delete(gfc.GroupFilterConditionID);
}
// save newly added or modified ones
foreach (Contract_GroupFilterCondition gfc_con in contract.FilterConditions)
{
GroupFilterCondition gfc = null;
if (gfc_con.GroupFilterConditionID.HasValue)
{
gfc = repGFC.GetByID(gfc_con.GroupFilterConditionID.Value);
if (gfc == null)
{
response.ErrorMessage = "Could not find existing Group Filter Condition with ID: " + gfc_con.GroupFilterConditionID.ToString();
return response;
}
}
else
gfc = new GroupFilterCondition();
gfc.ConditionOperator = gfc_con.ConditionOperator;
gfc.ConditionParameter = gfc_con.ConditionParameter;
gfc.ConditionType = gfc_con.ConditionType;
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
}
response.GroupFilter = gf.ToContract();
return response;
}
private static void CreateContinueWatchingGroupFilter()
{
// group filters
GroupFilterRepository repFilters = new GroupFilterRepository();
GroupFilterConditionRepository repGFC = new GroupFilterConditionRepository();
using (var session = JMMService.SessionFactory.OpenSession())
{
// check if it already exists
List<GroupFilter> lockedGFs = repFilters.GetLockedGroupFilters(session);
if (lockedGFs != null)
{
// if it already exists we can leave
foreach (GroupFilter gfTemp in lockedGFs)
if (gfTemp.GroupFilterName.Equals(Constants.GroupFilterName.ContinueWatching, StringComparison.InvariantCultureIgnoreCase)) return;
}
GroupFilter gf = new GroupFilter();
gf.GroupFilterName = Constants.GroupFilterName.ContinueWatching;
gf.Locked = 1;
gf.SortingCriteria = "4;2"; // by last watched episode desc
gf.ApplyToSeries = 0;
gf.BaseCondition = 1; // all
repFilters.Save(gf);
GroupFilterCondition gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.HasWatchedEpisodes;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.HasUnwatchedEpisodes;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
}
}
private static void CreateInitialGroupFilters()
{
// group filters
GroupFilterRepository repFilters = new GroupFilterRepository();
GroupFilterConditionRepository repGFC = new GroupFilterConditionRepository();
if (repFilters.GetAll().Count() > 0) return;
// Favorites
GroupFilter gf = new GroupFilter();
gf.GroupFilterName = "Favorites";
gf.ApplyToSeries = 0;
gf.BaseCondition = 1;
repFilters.Save(gf);
GroupFilterCondition gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.Favourite;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
// Missing Episodes
gf = new GroupFilter();
gf.GroupFilterName = "Missing Episodes";
gf.ApplyToSeries = 0;
gf.BaseCondition = 1;
repFilters.Save(gf);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.MissingEpisodesCollecting;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
// Newly Added Series
gf = new GroupFilter();
gf.GroupFilterName = "Newly Added Series";
gf.ApplyToSeries = 0;
gf.BaseCondition = 1;
repFilters.Save(gf);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.SeriesCreatedDate;
gfc.ConditionOperator = (int)GroupFilterOperator.LastXDays;
gfc.ConditionParameter = "10";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
// Newly Airing Series
gf = new GroupFilter();
gf.GroupFilterName = "Newly Airing Series";
gf.ApplyToSeries = 0;
gf.BaseCondition = 1;
repFilters.Save(gf);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.AirDate;
gfc.ConditionOperator = (int)GroupFilterOperator.LastXDays;
gfc.ConditionParameter = "30";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
// Votes Needed
gf = new GroupFilter();
gf.GroupFilterName = "Votes Needed";
gf.ApplyToSeries = 0;
gf.BaseCondition = 1;
repFilters.Save(gf);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.CompletedSeries;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.HasUnwatchedEpisodes;
gfc.ConditionOperator = (int)GroupFilterOperator.Exclude;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.UserVotedAny;
gfc.ConditionOperator = (int)GroupFilterOperator.Exclude;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
// Recently Watched
gf = new GroupFilter();
gf.GroupFilterName = "Recently Watched";
gf.ApplyToSeries = 0;
gf.BaseCondition = 1;
repFilters.Save(gf);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.EpisodeWatchedDate;
gfc.ConditionOperator = (int)GroupFilterOperator.LastXDays;
gfc.ConditionParameter = "10";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
// TvDB/MovieDB Link Missing
gf = new GroupFilter();
gf.GroupFilterName = "TvDB/MovieDB Link Missing";
gf.ApplyToSeries = 0;
gf.BaseCondition = 1;
repFilters.Save(gf);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.AssignedTvDBOrMovieDBInfo;
gfc.ConditionOperator = (int)GroupFilterOperator.Exclude;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
}
private static void CreateContinueWatchingGroupFilter()
{
// group filters
GroupFilterRepository repFilters = new GroupFilterRepository();
GroupFilterConditionRepository repGFC = new GroupFilterConditionRepository();
using (var session = JMMService.SessionFactory.OpenSession())
{
// check if it already exists
List<GroupFilter> lockedGFs = repFilters.GetLockedGroupFilters(session);
if (lockedGFs != null)
{
// if it already exists we can leave
foreach (GroupFilter gfTemp in lockedGFs)
{
if (gfTemp.FilterType == (int)GroupFilterType.ContinueWatching)
return;
}
// the default value when the column was added to the database was '1'
// this is only needed for users of a migrated database
foreach (GroupFilter gfTemp in lockedGFs)
{
if (gfTemp.GroupFilterName.Equals(Constants.GroupFilterName.ContinueWatching, StringComparison.InvariantCultureIgnoreCase) &&
gfTemp.FilterType != (int)GroupFilterType.ContinueWatching)
{
FixContinueWatchingGroupFilter_20160406();
return;
}
}
}
GroupFilter gf = new GroupFilter();
gf.GroupFilterName = Constants.GroupFilterName.ContinueWatching;
gf.Locked = 1;
gf.SortingCriteria = "4;2"; // by last watched episode desc
gf.ApplyToSeries = 0;
gf.BaseCondition = 1; // all
gf.FilterType = (int)GroupFilterType.ContinueWatching;
repFilters.Save(gf);
GroupFilterCondition gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.HasWatchedEpisodes;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.HasUnwatchedEpisodes;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
repGFC.Save(gfc);
}
}
public static void FixContinueWatchingGroupFilter_20160406()
{
// group filters
GroupFilterRepository repFilters = new GroupFilterRepository();
GroupFilterConditionRepository repGFC = new GroupFilterConditionRepository();
using (var session = JMMService.SessionFactory.OpenSession())
{
// check if it already exists
List<GroupFilter> lockedGFs = repFilters.GetLockedGroupFilters(session);
if (lockedGFs != null)
{
// if it already exists we can leave
foreach (GroupFilter gf in lockedGFs)
{
if (gf.GroupFilterName.Equals(Constants.GroupFilterName.ContinueWatching, StringComparison.InvariantCultureIgnoreCase))
{
gf.FilterType = (int)GroupFilterType.ContinueWatching;
repFilters.Save(gf);
}
}
}
}
}
public static void CreateOrVerifyTagsAndYearsFilters(bool frominit = false, HashSet <string> tags = null, DateTime?airdate = null)
{
GroupFilterRepository repFilters = new GroupFilterRepository();
using (var session = JMMService.SessionFactory.OpenSession())
{
string t = "GroupFilter";
List <GroupFilter> lockedGFs = repFilters.GetLockedGroupFilters(session);
AniDB_TagRepository tagsrepo = new AniDB_TagRepository();
AnimeGroupRepository grouprepo = new AnimeGroupRepository();
GroupFilter tagsdirec = lockedGFs.FirstOrDefault(a => a.FilterType == (int)(GroupFilterType.Directory | GroupFilterType.Tag));
if (tagsdirec != null)
{
HashSet <string> alltags;
if (tags == null)
{
alltags = new HashSet <string>(tagsrepo.GetAll(session).Select(a => a.TagName).Distinct(StringComparer.InvariantCultureIgnoreCase), StringComparer.InvariantCultureIgnoreCase);
}
else
{
alltags = new HashSet <string>(tags.Distinct(StringComparer.InvariantCultureIgnoreCase), StringComparer.InvariantCultureIgnoreCase);
}
HashSet <string> notin = new HashSet <string>(lockedGFs.Where(a => a.FilterType == (int)GroupFilterType.Tag).Select(a => a.Conditions.FirstOrDefault()?.ConditionParameter), StringComparer.InvariantCultureIgnoreCase);
alltags.ExceptWith(notin);
int max = alltags.Count;
int cnt = 0;
//AniDB Tags are in english so we use en-us culture
TextInfo tinfo = new CultureInfo("en-US", false).TextInfo;
foreach (string s in alltags)
{
cnt++;
if (frominit)
{
ServerState.Instance.CurrentSetupStatus = string.Format(JMMServer.Properties.Resources.Database_Cache, t,
Properties.Resources.Filter_CreatingTag + " '" + s + "'" + Properties.Resources.Filter_Filter + cnt + "/" + max);
}
GroupFilter yf = new GroupFilter
{
ParentGroupFilterID = tagsdirec.GroupFilterID,
InvisibleInClients = 0,
GroupFilterName = tinfo.ToTitleCase(s.Replace("`", "'")),
BaseCondition = 1,
Locked = 1,
SortingCriteria = "5;1",
FilterType = (int)GroupFilterType.Tag
};
GroupFilterCondition gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.Tag;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = s;
gfc.GroupFilterID = yf.GroupFilterID;
yf.Conditions.Add(gfc);
yf.EvaluateAnimeGroups();
yf.EvaluateAnimeSeries();
repFilters.Save(yf);
}
}
GroupFilter yearsdirec = lockedGFs.FirstOrDefault(a => a.FilterType == (int)(GroupFilterType.Directory | GroupFilterType.Year));
if (yearsdirec != null)
{
HashSet <string> allyears;
if (airdate == null)
{
List <Contract_AnimeGroup> grps =
grouprepo.GetAll().Select(a => a.Contract).Where(a => a != null).ToList();
if (grps.Any(a => a.Stat_AirDate_Min.HasValue && a.Stat_AirDate_Max.HasValue))
{
DateTime maxtime =
grps.Where(a => a.Stat_AirDate_Max.HasValue).Max(a => a.Stat_AirDate_Max.Value);
DateTime mintime =
grps.Where(a => a.Stat_AirDate_Min.HasValue).Min(a => a.Stat_AirDate_Min.Value);
allyears =
new HashSet <string>(
Enumerable.Range(mintime.Year, maxtime.Year - mintime.Year + 1)
.Select(a => a.ToString()), StringComparer.InvariantCultureIgnoreCase);
}
else
{
allyears = new HashSet <string>();
}
}
else
{
allyears = new HashSet <string>(new string[] { airdate.Value.Year.ToString() });
}
HashSet <string> notin =
new HashSet <string>(
lockedGFs.Where(a => a.FilterType == (int)GroupFilterType.Year)
.Select(a => a.Conditions.FirstOrDefault()?.ConditionParameter),
StringComparer.InvariantCultureIgnoreCase);
allyears.ExceptWith(notin);
int max = allyears.Count;
int cnt = 0;
foreach (string s in allyears)
{
cnt++;
if (frominit)
{
ServerState.Instance.CurrentSetupStatus = string.Format(JMMServer.Properties.Resources.Database_Cache, t,
Properties.Resources.Filter_CreatingYear + " '" + s + "' " + Properties.Resources.Filter_Filter + cnt + "/" + max);
}
GroupFilter yf = new GroupFilter
{
ParentGroupFilterID = yearsdirec.GroupFilterID,
InvisibleInClients = 0,
GroupFilterName = s,
BaseCondition = 1,
Locked = 1,
SortingCriteria = "5;1",
FilterType = (int)GroupFilterType.Year
};
GroupFilterCondition gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.Year;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = s;
gfc.GroupFilterID = yf.GroupFilterID;
yf.Conditions.Add(gfc);
yf.EvaluateAnimeGroups();
yf.EvaluateAnimeSeries();
repFilters.Save(yf);
}
}
}
}
//TODO Cleanup function for Empty Tags and Empty Years
public static void CreateOrVerifyLockedFilters()
{
GroupFilterRepository repFilters = new GroupFilterRepository();
using (var session = JMMService.SessionFactory.OpenSession())
{
string t = "GroupFilter";
List <GroupFilter> lockedGFs = repFilters.GetLockedGroupFilters(session);
//Continue Watching
// check if it already exists
ServerState.Instance.CurrentSetupStatus = string.Format(JMMServer.Properties.Resources.Database_Cache, t, " " + Properties.Resources.Filter_CreateContinueWatching);
GroupFilter cwatching =
lockedGFs.FirstOrDefault(
a =>
a.FilterType == (int)GroupFilterType.ContinueWatching);
if (cwatching != null && cwatching.FilterType != (int)GroupFilterType.ContinueWatching)
{
ServerState.Instance.CurrentSetupStatus = string.Format(JMMServer.Properties.Resources.Database_Cache, t, " " + Properties.Resources.Filter_CreateContinueWatching);
cwatching.FilterType = (int)GroupFilterType.ContinueWatching;
repFilters.Save(cwatching);
}
else if (cwatching == null)
{
ServerState.Instance.CurrentSetupStatus = string.Format(JMMServer.Properties.Resources.Database_Cache, t, " " + Properties.Resources.Filter_CreateContinueWatching);
GroupFilter gf = new GroupFilter();
gf.GroupFilterName = Constants.GroupFilterName.ContinueWatching;
gf.Locked = 1;
gf.SortingCriteria = "4;2"; // by last watched episode desc
gf.ApplyToSeries = 0;
gf.BaseCondition = 1; // all
gf.FilterType = (int)GroupFilterType.ContinueWatching;
gf.InvisibleInClients = 0;
gf.Conditions = new List <GroupFilterCondition>();
GroupFilterCondition gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.HasWatchedEpisodes;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
gf.Conditions.Add(gfc);
gfc = new GroupFilterCondition();
gfc.ConditionType = (int)GroupFilterConditionType.HasUnwatchedEpisodes;
gfc.ConditionOperator = (int)GroupFilterOperator.Include;
gfc.ConditionParameter = "";
gfc.GroupFilterID = gf.GroupFilterID;
gf.Conditions.Add(gfc);
gf.EvaluateAnimeGroups();
gf.EvaluateAnimeSeries();
repFilters.Save(gf); //Get ID
}
//Create All filter
GroupFilter allfilter = lockedGFs.FirstOrDefault(a => a.FilterType == (int)GroupFilterType.All);
if (allfilter == null)
{
ServerState.Instance.CurrentSetupStatus = string.Format(JMMServer.Properties.Resources.Database_Cache, t, " " + Properties.Resources.Filter_CreateAll);
GroupFilter gf = new GroupFilter
{
GroupFilterName = Properties.Resources.Filter_All,
Locked = 1,
InvisibleInClients = 0,
FilterType = (int)GroupFilterType.All,
BaseCondition = 1,
SortingCriteria = "5;1"
};
gf.EvaluateAnimeGroups();
gf.EvaluateAnimeSeries();
repFilters.Save(gf);
}
GroupFilter tagsdirec =
lockedGFs.FirstOrDefault(
a => a.FilterType == (int)(GroupFilterType.Directory | GroupFilterType.Tag));
if (tagsdirec == null)
{
tagsdirec = new GroupFilter
{
GroupFilterName = Properties.Resources.Filter_Tags,
InvisibleInClients = 0,
FilterType = (int)(GroupFilterType.Directory | GroupFilterType.Tag),
BaseCondition = 1,
Locked = 1,
SortingCriteria = "13;1"
};
repFilters.Save(tagsdirec);
}
GroupFilter yearsdirec =
lockedGFs.FirstOrDefault(
a => a.FilterType == (int)(GroupFilterType.Directory | GroupFilterType.Year));
if (yearsdirec == null)
{
yearsdirec = new GroupFilter
{
GroupFilterName = Properties.Resources.Filter_Years,
InvisibleInClients = 0,
FilterType = (int)(GroupFilterType.Directory | GroupFilterType.Year),
BaseCondition = 1,
Locked = 1,
SortingCriteria = "13;1"
};
repFilters.Save(yearsdirec);
}
}
CreateOrVerifyTagsAndYearsFilters(true);
}
