public ActionResult UserTranslations(string username) { var userTranslations = (from item in db.GetAllSubtitles() where item.Author == username orderby item.DateCreated descending select item); return(PartialView(userTranslations)); }
public ActionResult SubtitleSearch(int?page, string title, string language) { IEnumerable <Subtitle> sub; // If media with that exact name exists // you get redirected to the existing profile if (db.GetMediaByName(title) != null) { var med = db.GetMediaByName(title); return(RedirectToAction("MediaProfile", "Media", new { id = med.ID })); } if (language == "" || language == null) { sub = (from item in db.GetAllSubtitles() where item.Title.ToLower().Contains(title.ToLower()) orderby item.DateCreated descending select item); } else { sub = (from item in db.GetAllSubtitles() where (item.Title.ToLower().Contains(title.ToLower()) && (item.Language == language)) orderby item.DateCreated descending select item); } if (!page.HasValue) { page = 1; } int pageSize = 15; int pageNumber = (page ?? 1); // Gets language dropdown ViewBag.Languages = db.GetLanguageListItems(); return(View(sub.ToPagedList(pageNumber, pageSize))); }
public ActionResult Index(int?page) { var subs = (from item in db.GetAllSubtitles() orderby item.DateCreated descending select item); if (!page.HasValue) { page = 1; } int pageSize = 15; int pageNumber = (page ?? 1); ViewBag.Languages = db.GetLanguageListItems(); return(View(subs.ToPagedList(pageNumber, pageSize))); }