public ActionResult ByCategory(string name, int CategoryID) { #region Init BusinessLogicHandler myHandler = new BusinessLogicHandler(); SearchViewModel model = new SearchViewModel(); Technology helper = new Technology(); #endregion #region Get Devices By Category if (name != null) { try { model.GadgetResults = myHandler.CategoryDeviceSearch(name); model.TCategory = new TechCategory(); helper = (Technology)model.GadgetResults.Take(1).FirstOrDefault(); model.TCategory = myHandler.GetTechnologyType(helper.TechCategoryID); } catch { model.GadgetResults = myHandler.DevicesByCategory(CategoryID);//Replace model.TCategory = new TechCategory(); model.TCategory = myHandler.GetTechnologyType(CategoryID); } } if (CategoryID != 0) { model.GadgetResults = myHandler.DevicesByCategory(CategoryID);//Replace model.TCategory = new TechCategory(); model.TCategory = myHandler.GetTechnologyType(CategoryID); } #endregion return View(model); }
public ActionResult DevicesAdvanced(Device_Advanced model) { #region init Search BusinessLogicHandler myHandler = new BusinessLogicHandler(); SearchViewModel SModel = new SearchViewModel(); #endregion #region Execute Device Search if(model.Category == true) { if (model.RangeFrom != null && model.RangeTo == null) { if (model.Query == null) SModel.GadgetResults = myHandler.CategoryFromQueryDeviceSeach("", model.RangeFrom.GetValueOrDefault()); else SModel.GadgetResults = myHandler.CategoryFromQueryDeviceSeach(model.Query, model.RangeFrom.GetValueOrDefault()); } if (model.RangeTo != null && model.RangeFrom == null) { if (model.Query == null) SModel.GadgetResults = myHandler.CategoryToQueryDeviceSearch("", model.RangeTo.GetValueOrDefault()); else SModel.GadgetResults = myHandler.CategoryToQueryDeviceSearch(model.Query, model.RangeTo.GetValueOrDefault()); } if (model.RangeFrom != null && model.RangeTo != null) { if (model.Query == null) SModel.GadgetResults = myHandler.CategoryBETWEENQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); else SModel.GadgetResults = myHandler.CategoryBETWEENQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); } else { if (model.Query == null) SModel.GadgetResults = myHandler.CategoryDeviceSearch(""); else SModel.GadgetResults = myHandler.CategoryDeviceSearch(model.Query); } } if (model.Manufacturer == true) { if (model.RangeFrom != null && model.RangeTo == null) { if (model.Query == null) SModel.GadgetResults = myHandler.ManufacturerFromQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault()); else SModel.GadgetResults = myHandler.ManufacturerFromQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault()); } if (model.RangeTo != null && model.RangeFrom == null) { if (model.Query == null) SModel.GadgetResults = myHandler.ManufacturerToQueryDeviceSearch("", model.RangeTo.GetValueOrDefault()); else SModel.GadgetResults = myHandler.ManufacturerToQueryDeviceSearch(model.Query, model.RangeTo.GetValueOrDefault()); } if (model.RangeFrom != null && model.RangeTo != null) { if (model.Query == null) SModel.GadgetResults = myHandler.ManufacturerBETWEENQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); else SModel.GadgetResults = myHandler.ManufacturerBETWEENQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); } else { if (model.Query == null) SModel.GadgetResults = myHandler.ManufacturerDeviceSearch(""); else SModel.GadgetResults = myHandler.ManufacturerDeviceSearch(model.Query); } } if(model.ModelName == true) { if (model.RangeFrom != null && model.RangeTo == null) { if (model.Query == null) SModel.GadgetResults = myHandler.ModelNameFromQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault()); else SModel.GadgetResults = myHandler.ModelNameFromQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault()); } if (model.RangeTo != null && model.RangeFrom == null) { if (model.Query == null) SModel.GadgetResults = myHandler.ModelNameToQueryDeviceSearch("", model.RangeTo.GetValueOrDefault()); else SModel.GadgetResults = myHandler.ModelNameToQueryDeviceSearch(model.Query, model.RangeTo.GetValueOrDefault()); } if (model.RangeFrom != null && model.RangeTo != null) { if (model.Query == null) SModel.GadgetResults = myHandler.ModelNameBETWEENQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); else SModel.GadgetResults = myHandler.ModelNameBETWEENQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); } else { if (model.Query == null) SModel.GadgetResults = myHandler.ModelNameDeviceSearch(""); else SModel.GadgetResults = myHandler.ModelNameDeviceSearch(model.Query); } } if(model.ModelNumber == true) { if (model.RangeFrom != null && model.RangeTo == null) { if (model.Query == null) SModel.GadgetResults = myHandler.ModelNumberFromQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault()); else SModel.GadgetResults = myHandler.ModelNumberFromQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault()); } if (model.RangeTo != null && model.RangeFrom == null) { if (model.Query == null) SModel.GadgetResults = myHandler.ModelNumberToQueryDeviceSearch("", model.RangeTo.GetValueOrDefault()); else SModel.GadgetResults = myHandler.ModelNumberToQueryDeviceSearch(model.Query, model.RangeTo.GetValueOrDefault()); } if (model.RangeFrom != null && model.RangeTo != null) { if (model.Query == null) SModel.GadgetResults = myHandler.ModelNumberBETWEENQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); else SModel.GadgetResults = myHandler.ModelNumberBETWEENQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); } else { if (model.Query == null) SModel.GadgetResults = myHandler.ModelNumberSearch(""); else SModel.GadgetResults = myHandler.ModelNumberSearch(model.Query); } } if(model.RangeFrom != null && model.RangeTo == null && model.ModelNumber == false && model.Manufacturer == false && model.ModelName == false && model.Category == false && model.Query == null) { SModel.GadgetResults = myHandler.ModelNumberFromQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault()); } if (model.RangeTo != null && model.RangeFrom == null && model.ModelNumber == false && model.Manufacturer == false && model.ModelName == false && model.Category == false && model.Query == null) { SModel.GadgetResults = myHandler.ModelNumberToQueryDeviceSearch("", model.RangeTo.GetValueOrDefault()); } if (model.RangeFrom != null && model.RangeTo != null && model.ModelNumber == false && model.Manufacturer == false && model.ModelName == false && model.Category == false && model.Query == null) { SModel.GadgetResults = myHandler.ModelNumberBETWEENQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault()); } #endregion return View(SModel); }