public JsonResult GetInspiration() { var wishes = WAFContext.Session.GetContents<Wish>(); var count = wishes.Count(); var rand = new System.Random(); var randomWish = wishes.Skip(rand.Next(count)).FirstOrDefault(); var inspiration = new InspirationJSON { Title = randomWish.Name, Signature = "Brudepar", Link = randomWish.HyperLink.GetUrl() }; return Json(inspiration, JsonRequestBehavior.AllowGet); }
public static List<InspirationJSON> GetInspiration() { var q = WAFContext.Session.CreateQuery(); var aOccasion = new AqlAliasWishListOccasion(); var aWls = new AqlAliasWishList(); var aWish = new AqlAliasWish(); var join1 = new AqlAliasRelThemeWishList(aOccasion, aWls); var join2 = new AqlAliasRelWishListWishes(join1, aWish, aWls); q.From(join2); var rOccasion = q.Select(aOccasion.Name); var rGender = q.Select(aWls.Gender); var rBirthYear = q.Select(aWls.BirthYear); var rTitle = q.Select(aWish.Name); var rHyperLink = q.Select(aWish.HyperLink); var rs = q.Execute(); List<InspirationJSON> jsonList = new List<InspirationJSON>(); while (rs.Read()) { InspirationJSON ij = new InspirationJSON(); ij.Title = rTitle.Value; ij.Occasion = rOccasion.Value; if (2 == rGender) { ij.Gender = "Female"; } else { ij.Gender = "Male"; } if (rHyperLink.Value != null && rHyperLink.Value != "") { ij.Link = rHyperLink.Value; if (ij.Link.Length < 30) { ij.LinkShort = ij.Link; } else { ij.LinkShort = ij.Link.Substring(0, 27) + "..."; } } int thisYear = DateTime.Today.Year; int birthYear = 0; if (int.TryParse(rBirthYear.ToString(), out birthYear)) { birthYear = rBirthYear; } else { birthYear = thisYear - 30; } ij.Age = (thisYear - birthYear); if ("Bryllup" == ij.Occasion) { ij.Signature = "Brudepar"; } else if ("Dåp" == ij.Occasion) { ij.Signature = "Dåpsbarn"; } else if ("Babyshower" == ij.Occasion) { ij.Signature = "Babyshower"; } else if ("Konfirmasjon" == ij.Occasion) { ij.Signature = "Konfirmant"; } else { String outGender = ""; if ("Female" == ij.Gender && ij.Age < 17) { outGender = "Jente"; } else if ("Female" == ij.Gender) { outGender = "Kvinne"; } else if ("Male" == ij.Gender && ij.Age < 17) { outGender = "Gutt"; } else if ("Male" == ij.Gender) { outGender = "Mann"; } ij.Signature = outGender + ", " + ij.Age + " år"; } jsonList.Add(ij); } return jsonList; }