internal object GetOthers(string id, string catName, int TakeCount) { WallDataContext dc = new WallDataContext(); //var r = new Random(); //IQueryable<Wallpaper> Result = dc.Wallpapers; //return Result.Where(p => !p.ID.Equals(id) && p.CatName.Equals(catName)).OrderBy(qu => Guid.NewGuid()).Take(TakeCount); return(dc.spGetRandomWalls(id, catName)); }
internal Wallpaper GetDetailsByID(string iD) { try { WallDataContext dc = new WallDataContext(); return(dc.Wallpapers.SingleOrDefault(p => p.ID.Equals(iD))); } catch { return(null); } }
internal int GetCount(string Keyword, string CatName) { WallDataContext dc = new WallDataContext(); IQueryable <Wallpaper> Result = dc.Wallpapers; if (!string.IsNullOrEmpty(CatName)) { Result = Result.Where(p => p.CatName.Equals(CatName)); } if (!string.IsNullOrEmpty(Keyword)) { Result = Result.Where(p => p.Title.Contains(Keyword)); } return(Result.Count()); }
internal IQueryable <Wallpaper> GetWallpapers(string Keyword, string CatName, int pageNo, int pageSize) { int SkipCount = (pageNo - 1) * pageSize; WallDataContext dc = new WallDataContext(); IQueryable <Wallpaper> Result = dc.Wallpapers.OrderBy(p => p.OrderNum); if (!string.IsNullOrEmpty(CatName)) { Result = Result.Where(p => p.CatName.Equals(CatName)); } if (!string.IsNullOrEmpty(Keyword)) { Result = Result.Where(p => p.Title.Contains(Keyword)); } Result = Result.Skip(SkipCount).Take(pageSize); return(Result); }
internal object GetAll(int StartIndex, int PageSize) { WallDataContext dc = new WallDataContext(); return(dc.Wallpapers.Skip(StartIndex).Take(PageSize)); }