コード例 #1
0
        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);
        }