public static string GetTextForEnum_Sorting(GroupFilterSorting sort)
{
switch (sort)
{
case GroupFilterSorting.AniDBRating: return(Properties.Resources.GroupFilterSorting_AniDBRating);
case GroupFilterSorting.EpisodeAddedDate: return(Properties.Resources.GroupFilterSorting_EpisodeAddedDate);
case GroupFilterSorting.EpisodeAirDate: return(Properties.Resources.GroupFilterSorting_EpisodeAirDate);
case GroupFilterSorting.EpisodeWatchedDate: return(Properties.Resources.GroupFilterSorting_EpisodeWatchedDate);
case GroupFilterSorting.GroupName: return(Properties.Resources.GroupFilterSorting_GroupName);
case GroupFilterSorting.SortName: return(Properties.Resources.GroupFilterSorting_SortName);
case GroupFilterSorting.MissingEpisodeCount: return(Properties.Resources.GroupFilterSorting_MissingEpisodeCount);
case GroupFilterSorting.SeriesAddedDate: return(Properties.Resources.GroupFilterSorting_SeriesAddedDate);
case GroupFilterSorting.SeriesCount: return(Properties.Resources.GroupFilterSorting_SeriesCount);
case GroupFilterSorting.UnwatchedEpisodeCount: return(Properties.Resources.GroupFilterSorting_UnwatchedEpisodeCount);
case GroupFilterSorting.UserRating: return(Properties.Resources.GroupFilterSorting_UserRating);
case GroupFilterSorting.Year: return(Properties.Resources.GroupFilterSorting_Year);
default: return(Properties.Resources.GroupFilterSorting_AniDBRating);
}
}
public static string GetTextForEnum_Sorting(GroupFilterSorting sort)
{
switch (sort)
{
case GroupFilterSorting.AniDBRating: return(Translation.AniDBRating);
case GroupFilterSorting.EpisodeAddedDate: return(Translation.EpisodeAddedDate);
case GroupFilterSorting.EpisodeAirDate: return(Translation.EpisodeAirDate);
case GroupFilterSorting.EpisodeWatchedDate: return(Translation.EpisodeWatchedDate);
case GroupFilterSorting.GroupName: return(Translation.GroupName);
case GroupFilterSorting.GroupFilterName: return(Translation.FilterName);
case GroupFilterSorting.SortName: return(Translation.SortName);
case GroupFilterSorting.MissingEpisodeCount: return(Translation.MissingEpisodeCount);
case GroupFilterSorting.SeriesAddedDate: return(Translation.SeriesAddedDate);
case GroupFilterSorting.SeriesCount: return(Translation.SeriesCount);
case GroupFilterSorting.UnwatchedEpisodeCount: return(Translation.UnwatchedEpisodeCount);
case GroupFilterSorting.UserRating: return(Translation.UserRating);
case GroupFilterSorting.Year: return(Translation.Year);
default: return(Translation.AniDBRating);
}
}
public static string GetTextForEnum_Sorting(GroupFilterSorting sort)
{
switch (sort)
{
case GroupFilterSorting.AniDBRating: return("AniDB Rating");
case GroupFilterSorting.EpisodeAddedDate: return("Episode Added Date");
case GroupFilterSorting.EpisodeAirDate: return("Episode Air Date");
case GroupFilterSorting.EpisodeWatchedDate: return("Episode Watched Date");
case GroupFilterSorting.GroupName: return("Group Name");
case GroupFilterSorting.SortName: return("Sort Name");
case GroupFilterSorting.MissingEpisodeCount: return("Missing Episode Count");
case GroupFilterSorting.SeriesAddedDate: return("Series Added Date");
case GroupFilterSorting.SeriesCount: return("Series Count");
case GroupFilterSorting.UnwatchedEpisodeCount: return("Unwatched Episode Count");
case GroupFilterSorting.UserRating: return("User Rating");
case GroupFilterSorting.Year: return("Year");
default: return("AniDB Rating");
}
}
public static string GetTextForEnum_Sorting(GroupFilterSorting sort)
{
switch (sort)
{
case GroupFilterSorting.AniDBRating: return "AniDB Rating";
case GroupFilterSorting.EpisodeAddedDate: return "Episode Added Date";
case GroupFilterSorting.EpisodeAirDate: return "Episode Air Date";
case GroupFilterSorting.EpisodeWatchedDate: return "Episode Watched Date";
case GroupFilterSorting.GroupName: return "Group Name";
case GroupFilterSorting.SortName: return "Sort Name";
case GroupFilterSorting.MissingEpisodeCount: return "Missing Episode Count";
case GroupFilterSorting.SeriesAddedDate: return "Series Added Date";
case GroupFilterSorting.SeriesCount: return "Series Count";
case GroupFilterSorting.UnwatchedEpisodeCount: return "Unwatched Episode Count";
case GroupFilterSorting.UserRating: return "User Rating";
case GroupFilterSorting.Year: return "Year";
default: return "AniDB Rating";
}
}
public static SortPropOrFieldAndDirection GetSortDescription(GroupFilterSorting sortType, GroupFilterSortDirection sortDirection)
{
string sortColumn = "";
bool sortDescending = sortDirection == GroupFilterSortDirection.Desc;
SortType sortFieldType = SortType.eString;
switch (sortType)
{
case GroupFilterSorting.AniDBRating:
sortColumn = "AniDBRating"; sortFieldType = SortType.eDoubleOrFloat; break;
case GroupFilterSorting.EpisodeAddedDate:
sortColumn = "EpisodeAddedDate"; sortFieldType = SortType.eDateTime; break;
case GroupFilterSorting.EpisodeAirDate:
sortColumn = "AirDate"; sortFieldType = SortType.eDateTime; break;
case GroupFilterSorting.EpisodeWatchedDate:
sortColumn = "WatchedDate"; sortFieldType = SortType.eDateTime; break;
case GroupFilterSorting.GroupName:
sortColumn = "GroupName"; sortFieldType = SortType.eString; break;
case GroupFilterSorting.SortName:
sortColumn = "SortName"; sortFieldType = SortType.eString; break;
case GroupFilterSorting.MissingEpisodeCount:
sortColumn = "MissingEpisodeCount"; sortFieldType = SortType.eInteger; break;
case GroupFilterSorting.SeriesAddedDate:
sortColumn = "Stat_SeriesCreatedDate"; sortFieldType = SortType.eDateTime; break;
case GroupFilterSorting.SeriesCount:
sortColumn = "AllSeriesCount"; sortFieldType = SortType.eInteger; break;
case GroupFilterSorting.UnwatchedEpisodeCount:
sortColumn = "UnwatchedEpisodeCount"; sortFieldType = SortType.eInteger; break;
case GroupFilterSorting.UserRating:
sortColumn = "Stat_UserVoteOverall"; sortFieldType = SortType.eDoubleOrFloat; break;
case GroupFilterSorting.Year:
if (sortDirection == GroupFilterSortDirection.Asc)
sortColumn = "Stat_AirDate_Min";
else
sortColumn = "Stat_AirDate_Max";
sortFieldType = SortType.eDateTime;
break;
default:
sortColumn = "GroupName"; sortFieldType = SortType.eString; break;
}
return new SortPropOrFieldAndDirection(sortColumn, sortDescending, sortFieldType);
}
public static SortDescription GetSortDescription(GroupFilterSorting sortType, GroupFilterSortDirection sortDirection)
{
string sortColumn = "";
ListSortDirection sortd = ListSortDirection.Ascending;
switch (sortType)
{
case GroupFilterSorting.AniDBRating:
sortColumn = "AniDBRating"; break;
case GroupFilterSorting.EpisodeAddedDate:
sortColumn = "EpisodeAddedDate"; break;
case GroupFilterSorting.EpisodeAirDate:
sortColumn = "AirDate"; break;
case GroupFilterSorting.EpisodeWatchedDate:
sortColumn = "WatchedDate"; break;
case GroupFilterSorting.GroupName:
sortColumn = "GroupName"; break;
case GroupFilterSorting.SortName:
sortColumn = "SortName"; break;
case GroupFilterSorting.MissingEpisodeCount:
sortColumn = "MissingEpisodeCount"; break;
case GroupFilterSorting.SeriesAddedDate:
sortColumn = "Stat_SeriesCreatedDate"; break;
case GroupFilterSorting.SeriesCount:
sortColumn = "AllSeriesCount"; break;
case GroupFilterSorting.UnwatchedEpisodeCount:
sortColumn = "UnwatchedEpisodeCount"; break;
case GroupFilterSorting.UserRating:
sortColumn = "Stat_UserVoteOverall"; break;
case GroupFilterSorting.Year:
if (sortDirection == GroupFilterSortDirection.Asc)
{
sortColumn = "Stat_AirDate_Min";
}
else
{
sortColumn = "Stat_AirDate_Max";
}
break;
default:
sortColumn = "GroupName"; break;
}
if (sortDirection == GroupFilterSortDirection.Asc)
{
sortd = ListSortDirection.Ascending;
}
else
{
sortd = ListSortDirection.Descending;
}
return(new SortDescription(sortColumn, sortd));
}
public static SortPropOrFieldAndDirection GetSortDescription(GroupFilterSorting sortType, GroupFilterSortDirection sortDirection)
{
string sortColumn = "";
bool sortDescending = sortDirection == GroupFilterSortDirection.Desc;
SortType sortFieldType = SortType.eString;
switch (sortType)
{
case GroupFilterSorting.AniDBRating:
sortColumn = "AniDBRating"; sortFieldType = SortType.eDoubleOrFloat; break;
case GroupFilterSorting.EpisodeAddedDate:
sortColumn = "EpisodeAddedDate"; sortFieldType = SortType.eDateTime; break;
case GroupFilterSorting.EpisodeAirDate:
sortColumn = "AirDate"; sortFieldType = SortType.eDateTime; break;
case GroupFilterSorting.EpisodeWatchedDate:
sortColumn = "WatchedDate"; sortFieldType = SortType.eDateTime; break;
case GroupFilterSorting.GroupName:
sortColumn = "GroupName"; sortFieldType = SortType.eString; break;
case GroupFilterSorting.SortName:
sortColumn = "SortName"; sortFieldType = SortType.eString; break;
case GroupFilterSorting.MissingEpisodeCount:
sortColumn = "MissingEpisodeCount"; sortFieldType = SortType.eInteger; break;
case GroupFilterSorting.SeriesAddedDate:
sortColumn = "Stat_SeriesCreatedDate"; sortFieldType = SortType.eDateTime; break;
case GroupFilterSorting.SeriesCount:
sortColumn = "AllSeriesCount"; sortFieldType = SortType.eInteger; break;
case GroupFilterSorting.UnwatchedEpisodeCount:
sortColumn = "UnwatchedEpisodeCount"; sortFieldType = SortType.eInteger; break;
case GroupFilterSorting.UserRating:
sortColumn = "Stat_UserVoteOverall"; sortFieldType = SortType.eDoubleOrFloat; break;
case GroupFilterSorting.Year:
if (sortDirection == GroupFilterSortDirection.Asc)
{
sortColumn = "Stat_AirDate_Min";
}
else
{
sortColumn = "Stat_AirDate_Max";
}
sortFieldType = SortType.eDateTime;
break;
default:
sortColumn = "GroupName"; sortFieldType = SortType.eString; break;
}
return(new SortPropOrFieldAndDirection(sortColumn, sortDescending, sortFieldType));
}
public static IQueryable <T> GeneratePredicate <T>(this IQueryable <T> lst, GroupFilterSorting sortType, GroupFilterSortDirection sortDirection) where T : CL_AnimeGroup_User
{
Expression <Func <T, dynamic> > selector;
switch (sortType)
{
case GroupFilterSorting.AniDBRating:
selector = c => c.Stat_AniDBRating;
break;
case GroupFilterSorting.EpisodeAddedDate:
selector = c => c.EpisodeAddedDate;
break;
case GroupFilterSorting.EpisodeAirDate:
selector = c => c.LatestEpisodeAirDate;
break;
case GroupFilterSorting.EpisodeWatchedDate:
selector = c => c.WatchedDate;
break;
case GroupFilterSorting.GroupName:
selector = c => c.GroupName;
break;
case GroupFilterSorting.SortName:
selector = c => c.SortName;
break;
case GroupFilterSorting.MissingEpisodeCount:
selector = c => c.MissingEpisodeCount;
break;
case GroupFilterSorting.SeriesAddedDate:
selector = c => c.Stat_SeriesCreatedDate;
break;
case GroupFilterSorting.SeriesCount:
selector = c => c.Stat_SeriesCount;
break;
case GroupFilterSorting.UnwatchedEpisodeCount:
selector = c => c.UnwatchedEpisodeCount;
break;
case GroupFilterSorting.UserRating:
selector = c => c.Stat_UserVoteOverall;
break;
case GroupFilterSorting.Year:
if (sortDirection == GroupFilterSortDirection.Asc)
{
selector = c => c.Stat_AirDate_Min;
}
else
{
selector = c => c.Stat_AirDate_Max;
}
break;
default:
selector = c => c.GroupName;
break;
}
if (lst is IOrderedQueryable <T> )
{
IOrderedQueryable <T> n = (IOrderedQueryable <T>)lst;
if (sortDirection != GroupFilterSortDirection.Asc)
{
return(n.ThenByDescending(selector));
}
return(n.ThenBy(selector));
}
if (sortDirection != GroupFilterSortDirection.Asc)
{
return(lst.OrderByDescending(selector));
}
return(lst.OrderBy(selector));
}
public static KeyValuePair <string, bool> GetSortDescription(this GroupFilterSorting sortType, GroupFilterSortDirection sortDirection)
{
string sortColumn = "";
bool srt = false;
switch (sortType)
{
case GroupFilterSorting.AniDBRating:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, decimal> >)(c => c.Stat_AniDBRating)).ToName();
break;
case GroupFilterSorting.EpisodeAddedDate:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, DateTime?> >)(c => c.EpisodeAddedDate)).ToName();
break;
case GroupFilterSorting.EpisodeAirDate:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, DateTime?> >)(c => c.LatestEpisodeAirDate)).ToName();
break;
case GroupFilterSorting.EpisodeWatchedDate:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, DateTime?> >)(c => c.WatchedDate)).ToName();
break;
case GroupFilterSorting.GroupName:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, string> >)(c => c.GroupName)).ToName();
break;
case GroupFilterSorting.SortName:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, string> >)(c => c.SortName)).ToName();
break;
case GroupFilterSorting.MissingEpisodeCount:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, int> >)(c => c.MissingEpisodeCount)).ToName();
break;
case GroupFilterSorting.SeriesAddedDate:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, DateTime?> >)(c => c.Stat_SeriesCreatedDate)).ToName();
break;
case GroupFilterSorting.SeriesCount:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, int> >)(c => c.Stat_SeriesCount)).ToName();
break;
case GroupFilterSorting.UnwatchedEpisodeCount:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, int> >)(c => c.UnwatchedEpisodeCount)).ToName();
break;
case GroupFilterSorting.UserRating:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, decimal?> >)(c => c.Stat_UserVoteOverall)).ToName();
break;
case GroupFilterSorting.Year:
sortColumn = sortDirection == GroupFilterSortDirection.Asc ? ((Expression <Func <CL_AnimeGroup_User, DateTime?> >)(c => c.Stat_AirDate_Min)).ToName() : ((Expression <Func <CL_AnimeGroup_User, DateTime?> >)(c => c.Stat_AirDate_Max)).ToName();
break;
case GroupFilterSorting.GroupFilterName:
sortColumn = ((Expression <Func <CL_GroupFilter, string> >)(c => c.GroupFilterName)).ToName();
break;
default:
sortColumn = ((Expression <Func <CL_AnimeGroup_User, string> >)(c => c.GroupName)).ToName();
break;
}
if (sortDirection != GroupFilterSortDirection.Asc)
{
srt = true;
}
return(new KeyValuePair <string, bool>(sortColumn, srt));
}
public static string GetTextForEnum_Sorting(GroupFilterSorting sort)
{
switch (sort)
{
case GroupFilterSorting.AniDBRating: return Properties.Resources.GroupFilterSorting_AniDBRating;
case GroupFilterSorting.EpisodeAddedDate: return Properties.Resources.GroupFilterSorting_EpisodeAddedDate;
case GroupFilterSorting.EpisodeAirDate: return Properties.Resources.GroupFilterSorting_EpisodeAirDate;
case GroupFilterSorting.EpisodeWatchedDate: return Properties.Resources.GroupFilterSorting_EpisodeWatchedDate;
case GroupFilterSorting.GroupName: return Properties.Resources.GroupFilterSorting_GroupName;
case GroupFilterSorting.SortName: return Properties.Resources.GroupFilterSorting_SortName;
case GroupFilterSorting.MissingEpisodeCount: return Properties.Resources.GroupFilterSorting_MissingEpisodeCount;
case GroupFilterSorting.SeriesAddedDate: return Properties.Resources.GroupFilterSorting_SeriesAddedDate;
case GroupFilterSorting.SeriesCount: return Properties.Resources.GroupFilterSorting_SeriesCount;
case GroupFilterSorting.UnwatchedEpisodeCount: return Properties.Resources.GroupFilterSorting_UnwatchedEpisodeCount;
case GroupFilterSorting.UserRating: return Properties.Resources.GroupFilterSorting_UserRating;
case GroupFilterSorting.Year: return Properties.Resources.GroupFilterSorting_Year;
default: return Properties.Resources.GroupFilterSorting_AniDBRating;
}
}
public static SortDescription GetSortDescription(GroupFilterSorting sortType, GroupFilterSortDirection sortDirection)
{
string sortColumn = "";
ListSortDirection sortd = ListSortDirection.Ascending;
switch (sortType)
{
case GroupFilterSorting.AniDBRating:
sortColumn = "AniDBRating"; break;
case GroupFilterSorting.EpisodeAddedDate:
sortColumn = "EpisodeAddedDate"; break;
case GroupFilterSorting.EpisodeAirDate:
sortColumn = "AirDate"; break;
case GroupFilterSorting.EpisodeWatchedDate:
sortColumn = "WatchedDate"; break;
case GroupFilterSorting.GroupName:
sortColumn = "GroupName"; break;
case GroupFilterSorting.SortName:
sortColumn = "SortName"; break;
case GroupFilterSorting.MissingEpisodeCount:
sortColumn = "MissingEpisodeCount"; break;
case GroupFilterSorting.SeriesAddedDate:
sortColumn = "Stat_SeriesCreatedDate"; break;
case GroupFilterSorting.SeriesCount:
sortColumn = "AllSeriesCount"; break;
case GroupFilterSorting.UnwatchedEpisodeCount:
sortColumn = "UnwatchedEpisodeCount"; break;
case GroupFilterSorting.UserRating:
sortColumn = "Stat_UserVoteOverall"; break;
case GroupFilterSorting.Year:
if (sortDirection == GroupFilterSortDirection.Asc)
sortColumn = "Stat_AirDate_Min";
else
sortColumn = "Stat_AirDate_Max";
break;
default:
sortColumn = "GroupName"; break;
}
if (sortDirection == GroupFilterSortDirection.Asc)
sortd = ListSortDirection.Ascending;
else
sortd = ListSortDirection.Descending;
return new SortDescription(sortColumn, sortd);
}
public static string GetTextForEnum_Sorting(GroupFilterSorting sort)
{
switch (sort)
{
case GroupFilterSorting.AniDBRating: return Translation.AniDBRating;
case GroupFilterSorting.EpisodeAddedDate: return Translation.EpisodeAddedDate;
case GroupFilterSorting.EpisodeAirDate: return Translation.EpisodeAirDate;
case GroupFilterSorting.EpisodeWatchedDate: return Translation.EpisodeWatchedDate;
case GroupFilterSorting.GroupName: return Translation.GroupName;
case GroupFilterSorting.GroupFilterName: return Translation.FilterName;
case GroupFilterSorting.SortName: return Translation.SortName;
case GroupFilterSorting.MissingEpisodeCount: return Translation.MissingEpisodeCount;
case GroupFilterSorting.SeriesAddedDate: return Translation.SeriesAddedDate;
case GroupFilterSorting.SeriesCount: return Translation.SeriesCount;
case GroupFilterSorting.UnwatchedEpisodeCount: return Translation.UnwatchedEpisodeCount;
case GroupFilterSorting.UserRating: return Translation.UserRating;
case GroupFilterSorting.Year: return Translation.Year;
default: return Translation.AniDBRating;
}
}
