public static VideoListItem GetVideo(Guid videoId) { using (Entities context = new Entities()) { var Query = context.Media.Where(v => v.MediaId == videoId); var Result = QueryVideoListItem(Query, null); return Result.FirstOrDefault(); } }
public static Dbo.Comment Get(long commentId) { try { using (Entities bdd = new Entities()) { return bdd.T_Comment .Where(cmmnt => cmmnt.Id == commentId) .Select(c => new Dbo.Comment() { Id = c.Id, UserId = c.UserId, ArticleId = c.ArticleId, Content = c.Comment, CreationDate = c.CreationDate }) .FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
//public static Version GetVersionInfo() { // using (Entities context = new Entities()) { // DbVersion Result = context.DbVersions.Single(); // return new Version(Result.Major, Result.Minor, Result.Build, Result.Revision); // } //} public static Version GetVersionInfo() { using (Entities context = new Entities()) { // We must query manually because querying entity objects would fail on outdated databases. DbVersion Result = context.Database.SqlQuery<DbVersion>("SELECT Major, Minor, Build, Revision FROM Version").FirstOrDefault(); return new Version(Result.Major, Result.Minor, Result.Build, Result.Revision); } }
/// <summary> /// Inserts specified media into the database, or updates an existing entry. /// </summary> /// <param name="item">The media item to merge into the database.</param> /// <param name="context">The database context.</param> public static void InsertOrMerge(Media item, Entities context) { // Try to find matching element already within the database. List<Media> DbMatch = (from m in context.Media where m.MediaId == item.MediaId || (m.Artist == item.Artist && m.Title == item.Title) select m).ToList(); Media DbItem; if (DbMatch.Count > 1) // If both matches happen simultaneously, Artist/Title must take priority to avoid creating duplicate. DbItem = DbMatch.Single(m => m.Artist == item.Artist && m.Title == item.Title); else DbItem = DbMatch.FirstOrDefault(); // If merging, delete existing entry and we'll create a new one and merge the fields. if (DbItem != null) context.Media.Remove(DbItem); // Insert new data. context.Media.Add(item); // Merge fields. if (DbItem != null) { item.FileName = DbItem.FileName; item.MediaId = DbItem.MediaId; // If matching by Artist/Title, we keep the same ID to avoid creating duplicate ID. } // Commit changes. context.SaveChanges(); }
public static Media GetVideoByFileName(string fileName) { using (Entities context = new Entities()) { Media Result = (from v in context.Media.Include("MediaRatings.RatingCategory") where v.FileName == fileName select v).FirstOrDefault(); return Result; } }
public static Media GetVideoByTitle(string artist, string title) { using (Entities context = new Entities()) { Media Result = (from v in context.Media.Include("MediaRatings.RatingCategory") where v.Artist == artist && v.Title == title select v).FirstOrDefault(); return Result; } }
public static Media GetVideoById(Guid videoId) { using (Entities context = new Entities()) { Media Result = (from v in context.Media.Include("MediaRatings.RatingCategory") where v.MediaId == videoId select v).FirstOrDefault(); return Result; } }
public static int GetMediaCount(MediaType mediaType, RatingCategory ratingCategory, float[] minMax, double ratio) { using (Entities context = new Entities()) { if (ratingCategory.Name != "Intensity") return GetMediaQuery(context, mediaType, ratingCategory, minMax[0], minMax[1], ratio).Count(); else return GetIntensityQuery(context, mediaType, ratingCategory, minMax[0], minMax[1], ratio).Count(); } }
public static List<RatingCategory> GetCustomRatingCategories() { using (Entities context = new Entities()) { var Query = (from c in context.RatingCategories where c.Custom orderby c.Name select c); return Query.ToList(); } }
public static List<string> GetAllFileNames() { using (Entities context = new Entities()) { var Query = (from v in context.Media where v.FileName != null orderby v.FileName select v.FileName); return Query.ToList(); } }
public static void UpdateVersionInfo(Version version) { using (Entities context = new Entities()) { DbVersion Row = context.DbVersions.Single(); Row.Major = version.Major; Row.Minor = version.Minor; Row.Build = version.Build; Row.Revision = version.Revision; context.SaveChanges(); } }
public static List<Media> GetMediaListById(List<Guid> exportList) { using (Entities context = new Entities()) { var MediaData = (from v in context.Media .Include(t => t.MediaRatings.Select(r => r.RatingCategory)) .Include(t => t.MediaCategory) where exportList.Contains(v.MediaId) orderby v.Artist, v.Title select v).ToList(); return MediaData; } }
public static IQueryable<Media> GetMediaQuery(Entities context, MediaType mediaType, RatingCategory ratingCategory, double min, double max, double ratio) { var Query = (from m in context.Media let val = (from r in m.MediaRatings where r.RatingCategory.Name == ratingCategory.Name select r.DbGetValue(r.Height, r.Depth, ratio)).FirstOrDefault() where (mediaType == MediaType.None || m.MediaTypeId == (int)mediaType) && val != null && val > min && val <= max orderby m.Artist, m.Title select m); return Query; }
public static IQueryable<Media> GetIntensityQuery(Entities context, MediaType mediaType, RatingCategory ratingCategory, double min, double max, double ratio) { var Query = (from m in context.Media let val = (from r in m.MediaRatings let val = r.DbGetValue(r.Height, r.Depth, ratio) orderby val descending select val).Take(5).Average() where (mediaType == MediaType.None || m.MediaTypeId == (int)mediaType) && val > min && val <= max orderby m.Artist, m.Title select m); return Query; }
/// <summary> /// Returns the list of elements. /// </summary> /// <returns>A list of SearchCategoryItem objects.</returns> public static List<SearchCategoryItem> GetCategoryElements(SearchSettings settings) { using (Entities context = new Entities()) { var Query = (from c in context.RatingCategories where (settings.Search == "" || c.Name.Contains(settings.Search)) orderby c.Name select new SearchCategoryItem() { FilterType = SearchFilterEnum.Element, FilterValue = c.Name, Text = c.Name }); return Query.ToList(); } }
public static void CreateAndAddTags(T_Article article, List<T_Tag> tags) { try { using (Entities bdd = new Entities()) { using (TransactionScope scope = new TransactionScope()) { bdd.T_Article.Add(article); bdd.SaveChanges(); foreach (T_Tag tag in tags) { T_Tag oldTag = bdd.T_Tag.Where(tg => tg.Name == tag.Name).FirstOrDefault(); if (oldTag == null) { bdd.T_Tag.Add(tag); bdd.SaveChanges(); T_ArticleTag at = new T_ArticleTag() { ArticleId = article.Id, TagId = tag.Id }; bdd.T_ArticleTag.Add(at); bdd.SaveChanges(); } else { T_ArticleTag at = new T_ArticleTag() { ArticleId = article.Id, TagId = oldTag.Id }; bdd.T_ArticleTag.Add(at); bdd.SaveChanges(); } } scope.Complete(); } } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static List<T_Blog> SearchByTheme(string theme) { try { using (Entities bdd = new Entities()) { return bdd.T_Blog.Include("T_Theme").Where(blg => blg.T_Theme.Description.Equals(theme)).ToList(); } } catch (Exception e) { Trace.WriteLine(e.Message); return new List<T_Blog>(); } }
public static T_Blog Get(long blogId) { try { using (Entities bdd = new Entities()) { return bdd.T_Blog.Where(bl => bl.Id == blogId).FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static T_Blog Get(string login, string blogName) { try { using (Entities bdd = new Entities()) { return bdd.T_Blog.Include("T_User").Where(bl => bl.T_User.Login == login && bl.Name == blogName).FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static T_Tag GetByName(string name) { try { using (Entities bdd = new Entities()) { return bdd.T_Tag.Where(tg => tg.Name.Equals(name, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static List<T_Blog> SearchBlogFromUser(long userId) { try { using (Entities bdd = new Entities()) { return bdd.T_Blog.Include("T_User").Where(blg => blg.T_User.Id == userId).ToList(); } } catch (Exception e) { Trace.WriteLine(e.Message); return new List<T_Blog>(); } }
public static T_MediaType Get(long mediaTypeId) { try { using (Entities bdd = new Entities()) { return bdd.T_MediaType.Where(mdType => mdType.Id == mediaTypeId).FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static T_Style GetDefault() { try { using (Entities bdd = new Entities()) { return bdd.T_Style.FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static bool DoesLoginExists(string login) { try { using (Entities bdd = new Entities()) { return bdd.T_User.Where(usr => usr.Login == login).FirstOrDefault() != null; } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static T_Theme Get(long themeId) { try { using (Entities bdd = new Entities()) { return bdd.T_Theme.Where(thm => thm.Id == themeId).FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static T_ArticleTag Get(long articleTagId) { try { using (Entities bdd = new Entities()) { return bdd.T_ArticleTag.Where(art => art.Id == articleTagId).FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static List<T_Theme> GetAll() { try { using (Entities bdd = new Entities()) { return bdd.T_Theme.ToList(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static T_Follow Get(long followId) { try { using (Entities bdd = new Entities()) { return bdd.T_Follow.Where(fllw => fllw.Id == followId).FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static T_Style Get(long styleId) { try { using (Entities bdd = new Entities()) { return bdd.T_Style.Where(stl => stl.Id == styleId).FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }
public static T_User Get(long userId) { try { using (Entities bdd = new Entities()) { return bdd.T_User.Where(usr => usr.Id == userId).FirstOrDefault(); } } catch (Exception e) { Trace.WriteLine(e.Message); throw; } }