protected override void OnActionExecuting(ActionExecutingContext filterContext) { Entities db = new Entities(); ViewBag.Categories = db.Categories.ToList(); ViewBag.Countries = db.Countries.ToList(); ViewBag.HotSongs = db.Songs.Where(s => s.MusicFile != null).OrderByDescending(s => s.View).ThenByDescending(s => s.LikedUsers.Count).Take(10).ToList(); base.OnActionExecuting(filterContext); }
public static UserProfile GetCurrentUser() { if (Membership.GetUser() != null) { Entities db = new Entities(); string username = Membership.GetUser().UserName; UserProfile CurrentUser = db.UserProfile.Where(u => u.UserName == username).First(); return CurrentUser; } else return null; }