private void ResetCountsQueryModel(CriteriaDto criteriaDto, O2CV1QueryDto queryDto, CountsQueryModel model) { var tableNames = _schemaRepository.GetSchemaTables(); IEnumerable <DropDownItem> temptablelist = tableNames.Select(name => new DropDownItem { DropDownDisplay = name, DropDownValue = name }).OrderBy(x => x.DropDownDisplay).ToList(); model.SelectedTable = criteriaDto.TableName; model.QueryId = queryDto.QueryId; model.QueryName = queryDto.QueryName; model._tables = GetSelectListItems(temptablelist); model.QueryId = queryDto.QueryId; model.CriteriaModel = new CriteriaModel { _criteria = BuildModelCriteria() }; ViewBag.temptablelist = temptablelist; var tableSchemaModels = _schemaRepository.GetSchemaTableColumns(criteriaDto.TableName); IEnumerable <DropDownItem> tempColumnList = tableSchemaModels.MetaData.Select(col => new DropDownItem { DropDownDisplay = col.Name, DropDownValue = $"{criteriaDto.TableName}.{col.Name}" }).OrderBy(x => x.DropDownDisplay).ToList(); model._columns = tempColumnList.ToList(); CriteriaRepository criteriaRepository = new CriteriaRepository(_dbConnectionString); var criteriaThisQuery = criteriaRepository.GetCriteriaForQuery(Convert.ToInt64(queryDto.QueryId)); model.QueryCriteria = CriteriaMapper.MapCriteriaDtoToCriteriaGridViewModel(criteriaThisQuery); }
private void GetQueryCriteriaIntoModel(string queryId, CountsQueryModel model) { var tableNames = _schemaRepository.GetSchemaTables(); CriteriaRepository criteriaRepository = new CriteriaRepository(_dbConnectionString); var criteriaThisQuery = criteriaRepository.GetCriteriaForQuery(Convert.ToInt64(queryId)); model.QueryCriteria = CriteriaMapper.MapCriteriaDtoToCriteriaGridViewModel(criteriaThisQuery); }
public ActionResult ExecuteOrder(string queryId) { var o2V1Business = new O2CV1Business(_dbConnectionString); var sql = o2V1Business.BuildSqlFromQuery(queryId); o2V1Business.SaveQuery(queryId, sql); var queryFieldsDto = o2V1Business.CreateOrderModel(queryId); var queryFieldsViewModel = CriteriaMapper.MapCriteriaDtoToCriteriaGridViewModel(queryFieldsDto); ViewBag.Message = "This is a partial view."; return(PartialView("_PlaceOrder", queryFieldsViewModel)); }