public ActionResult Json(string v = "", string q = "")
{
if (string.IsNullOrWhiteSpace(v) || string.IsNullOrWhiteSpace(q))
{
return null;
}
q = HttpUtility.HtmlDecode(q);
if (string.IsNullOrWhiteSpace(v))
v = "btt";
if (string.IsNullOrWhiteSpace(q)) return Json(null, JsonRequestBehavior.AllowGet);
v = v.ToLower();
var address = new BibleAddress(q);
var bookOrder = OrderBook(address.Book);
var r = db.Contents.Where(c => c.Book.Bible.Version.ToLower() == v.ToLower())
.Where(c=>c.Book.Order==bookOrder)
.Where(c => c.Chapter >= address.From.Chapter && c.Chapter <= address.To.Chapter)
.Where(c => !(c.Chapter == address.From.Chapter && c.Verse < address.From.Verse))
.Where(c => !(c.Chapter == address.To.Chapter && c.Verse > address.To.Verse))
.OrderBy(c => c.Chapter).ThenBy(c => c.Verse);
var book = r.First().Book.Name;
ViewBag.Title = book + " " + address.Adress;
return Json(r.Select(verse=>new {chapter = verse.Chapter,title =verse.Title, verse = verse.Verse, word = verse.Word}), JsonRequestBehavior.AllowGet);
}
public ActionResult Index(string v="", string q="")
{
if (string.IsNullOrWhiteSpace(v))
{
v = "btt";
}
v = v.ToLower();
ViewBag.Bible = new SelectList(db.Bibles, "Version", "Name", v);
if (string.IsNullOrWhiteSpace(q)||new Regex("/d+$").IsMatch(q))
{
return View();
}
var address = new BibleAddress(q);
var bookOrder = OrderBook(address.Book);
var r = db.Contents.Where(c => c.Book.Bible.Version.ToLower() == v.ToLower())
.Where(c => c.Book.Order == bookOrder)
.Where(c => c.Chapter >= address.From.Chapter && c.Chapter <= address.To.Chapter)
.Where(c => !(c.Chapter == address.From.Chapter && c.Verse < address.From.Verse))
.Where(c => !(c.Chapter == address.To.Chapter && c.Verse > address.To.Verse))
.OrderBy(c=>c.Chapter).ThenBy(c=>c.Verse);
var book = r.First().Book.Name;
ViewBag.Title = book + " " + address.Adress;
return View(r.ToList());
}
