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