public ActionResult BooksAdvanced(Book_Advanced model) { #region init Search BusinessLogicHandler myHandler = new BusinessLogicHandler(); SearchViewModel SModel = new SearchViewModel(); #endregion #region Execute Book Search if (model.Author == true) { if (model.RangeFrom != null && model.RangeTo == null) { //DUE TO MULTIPLE AUTHORS NOT WORKING AS EXPECTED ! } else if (model.RangeTo != null && model.RangeFrom == null) { //DUE TO MULTIPLE AUTHORS NOT WORKING AS EXPECTED ! } else if (model.RangeFrom != null && model.RangeTo != null) { //DUE TO MULTIPLE AUTHORS NOT WORKING AS EXPECTED ! } else { //DUE TO MULTIPLE AUTHORS NOT WORKING AS EXPECTED ! //SP_AUTHORBOOKSEARCH } } if(model.BookTitle == true) { if (model.RangeFrom != null && model.RangeTo == null) { if (model.Query == null) SModel.BookResults = myHandler.BookTitleFromQueryBookSearch("", model.RangeFrom.GetValueOrDefault()); else SModel.BookResults = myHandler.BookTitleFromQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault()); } else if (model.RangeTo != null && model.RangeFrom == null) { if (model.Query == null) SModel.BookResults = myHandler.BookTitleToQueryBookSearch("", model.RangeTo.GetValueOrDefault()); else SModel.BookResults = myHandler.BookTitleToQueryBookSearch(model.Query, model.RangeTo.GetValueOrDefault()); } else if (model.RangeFrom != null && model.RangeTo != null) { if (model.Query == null) SModel.BookResults = myHandler.BookTitleBETWEENQueryBookSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); else SModel.BookResults = myHandler.BookTitleBETWEENQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); } else { if (model.Query == null) SModel.BookResults = myHandler.BookTitleBookSearch(""); else SModel.BookResults = myHandler.BookTitleBookSearch(model.Query); } } if (model.Category == true) { if (model.RangeFrom != null && model.RangeTo == null) { if (model.Query == null) SModel.BookResults = myHandler.CategoryFromQueryBookSearch("", model.RangeFrom.GetValueOrDefault()); else SModel.BookResults = myHandler.CategoryFromQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault()); } else if (model.RangeTo != null && model.RangeFrom == null) { if (model.Query == null) SModel.BookResults = myHandler.CategoryToQueryBookSearch("", model.RangeTo.GetValueOrDefault()); else SModel.BookResults = myHandler.CategoryToQueryBookSearch(model.Query, model.RangeTo.GetValueOrDefault()); } else if (model.RangeFrom != null && model.RangeTo != null) { if (model.Query == null) SModel.BookResults = myHandler.CategoryBETWEENQueryBookSeach("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); else SModel.BookResults = myHandler.CategoryBETWEENQueryBookSeach(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); } else { if (model.Query == null) SModel.BookResults = myHandler.CategoryBookSearch(""); else SModel.BookResults = myHandler.BookTitleBookSearch(model.Query); } } if(model.ISBN == true) { if (model.RangeFrom != null && model.RangeTo == null) { if (model.Query == null) SModel.BookResults = myHandler.ISBNFromQueryBookSearch("", model.RangeFrom.GetValueOrDefault()); else SModel.BookResults = myHandler.ISBNFromQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault()); } else if (model.RangeTo != null && model.RangeFrom == null) { if (model.Query == null) SModel.BookResults = myHandler.ISBNToQueryBookSearch("", model.RangeTo.GetValueOrDefault()); else SModel.BookResults = myHandler.ISBNToQueryBookSearch(model.Query, model.RangeTo.GetValueOrDefault()); } else if (model.RangeFrom != null && model.RangeTo != null) { if (model.Query == null) SModel.BookResults = myHandler.ISBNBETWEENQueryBookSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); else SModel.BookResults = myHandler.ISBNBETWEENQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); } else { if (model.Query == null) SModel.BookResults = myHandler.ISBNBookSearch(""); else SModel.BookResults = myHandler.ISBNBookSearch(model.Query); } } if (model.Publisher == true) { if (model.RangeFrom != null && model.RangeTo == null) { if (model.Query == null) SModel.BookResults = myHandler.PublisherFromQueryBookSearch("", model.RangeFrom.GetValueOrDefault()); else SModel.BookResults = myHandler.PublisherFromQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault()); } else if (model.RangeTo != null && model.RangeFrom == null) { if (model.Query == null) SModel.BookResults = myHandler.PublisherToQueryBookSearch("", model.RangeTo.GetValueOrDefault()); else SModel.BookResults = myHandler.PublisherToQueryBookSearch(model.Query, model.RangeTo.GetValueOrDefault()); } else if (model.RangeFrom != null && model.RangeTo != null) { if (model.Query == null) SModel.BookResults = myHandler.PublisherBETWEENQueryBookSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); else SModel.BookResults = myHandler.PublisherBETWEENQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); } else { if (model.Query == null) SModel.BookResults = myHandler.PublisherBookSearch(""); else SModel.BookResults = myHandler.PublisherBookSearch(model.Query); } } if (model.RangeFrom != null && model.RangeTo == null && model.ISBN == false && model.Publisher == false && model.Author == false && model.BookTitle == false && model.Category == false && model.Query == null) { SModel.BookResults = myHandler.BookTitleFromQueryBookSearch("", model.RangeFrom.GetValueOrDefault()); } if (model.RangeTo != null && model.RangeFrom == null && model.ISBN == false && model.Publisher == false && model.Author == false && model.BookTitle == false && model.Category == false && model.Query == null) { SModel.BookResults = myHandler.BookTitleToQueryBookSearch("", model.RangeTo.GetValueOrDefault()); } if (model.RangeFrom != null && model.RangeTo != null && model.ISBN == false && model.Publisher == false && model.Author == false && model.BookTitle == false && model.Category == false && model.Query == null) { SModel.BookResults = myHandler.BookTitleBETWEENQueryBookSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); } #endregion return View(SModel); }