//method: if user picks spirit, display random drink based on user's preference public string RandomDrink(string username) { var User = _drinkRepo.GetUserByUsername(username); int num = (int)DateTime.Today.ToBinary(); Random random = new Random(num); int DrinkCount = (from d in _drinkRepo.List() select d).Count(); var userFaction = _profileRepo.List().Where(p => p.UserId == User.Id).Select(p => p.Faction).FirstOrDefault(); if (DrinkCount == 0) { return("No drinks in Database"); } List <string> drinkList = _drinkRepo.List().Where(d => d.Type == userFaction).Select(d => d.Name).ToList(); if (drinkList.Count == 0) { return("No drinks found with same faction."); } int randomDrink = random.Next(DrinkCount - 1); return(drinkList[randomDrink]); }