public ActionResult AjaxSelectList(int tableId, int searchSelectColumnId) { var vm = new SearchSelectControlViewModel(); vm.SearchId = System.Guid.NewGuid().ToString(); var input = new Models.Search.FetchTableColumnInfoInput(); input.ColumnId = searchSelectColumnId; var output = fetchTableInfoRepository.FetchTableColumnInfo(input); vm.SearchSelectName = output.ColumnInfo.ColumnName; vm.SearchDisplayName = output.ColumnInfo.ColumnDisplayName; return(PartialView("_SearchSelectControl", vm)); }
public ActionResult Search(int?tableId, int?settingId) { if (tableId.HasValue == false) { return(RedirectToAction("Index")); } var vm = new SearchViewModel(tableId.Value); var list = new List <SearchTableColumn>(); var input = new Models.Search.FetchTableAllColumnInfoInput(); input.TableId = tableId.Value; var output = fetchTableInfoRepository.FetchTableAllColumnInfo(input); foreach (var item in output.FetchTableColumnDetails) { var i = new SearchTableColumn(); i.ColumnId = item.ColumnId; i.ColumnName = item.ColumnName; i.ColumnDisplayName = item.ColumnDisplayName; list.Add(i); } vm.Columns = list; var wheres = new List <SearchWhereControlViewModel>(); var selects = new List <SearchSelectControlViewModel>(); if (settingId.HasValue) { var saveInput = new Models.Search.FetchSettingInput(); saveInput.SearchSettingId = settingId.Value; var saveOutput = saveSearchSettingRepository.FetchSetting(saveInput); foreach (var item in saveOutput.Wheres) { var where = new SearchWhereControlViewModel() { SearchId = System.Guid.NewGuid().ToString(), SearchDisplayName = item.WhereColumnDisplayName, SearchWhereName = item.WhereColumnName, SearchRange = (int)item.WhereRange, SearchValue = item.WhereValue }; wheres.Add(where); } foreach (var item in saveOutput.Selects) { var select = new SearchSelectControlViewModel() { SearchId = System.Guid.NewGuid().ToString(), SearchDisplayName = item.SelectColumnDisplayName, SearchSelectName = item.SelectColumnName, SearchSelectValue = (int)item.SearchSelectValue }; selects.Add(select); } } vm.WhereDetails = wheres; vm.SelectDetails = selects; return(View(vm)); }