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);
}