public ActionResult GetOrderCount(string queryId)
{
var o2Cv1Business = new O2CV1Business(_dbConnectionString);
var SqlQueryBuilder = o2Cv1Business.BuildSqlFromQuery(queryId);
return(null);
}
private string SqlFromQueryBuilder(string queryId)
{
var o2Cv1Business = new O2CV1Business(_dbConnectionString);
var sqlFromQueryBuilder = o2Cv1Business.BuildSqlFromQuery(queryId);
return(sqlFromQueryBuilder);
}
private void SaveQuerySqlChanges(string queryId, O2CV1QueryDto queryDto)
{
var sqlFromQueryBuilder = SqlFromQueryBuilder(queryId);
O2CV1Business o2Cv1Business = new O2CV1Business(_dbConnectionString);
queryDto.QuerySql = sqlFromQueryBuilder;
o2Cv1Business.SaveQuery(queryDto);
}
public void TestJoinMortgateToPersonTableFromOneCriteriFromDaBase()
{
var criteriaBusiness = new O2CV1Business(_sqlConnectionString);
var sqlFromQueryBuilder = criteriaBusiness.BuildSqlFromQuery("19");
Assert.IsTrue(sqlFromQueryBuilder.Trim().Contains(@"SELECT Mortgages.* FROM Mortgages INNER JOIN BackBone ON BackBone.MortgageId = BackBone.MortgageId INNER JOIN Persons ON BackBone.PersonId = Persons.PersonId WHERE ((dbo.Mortgages.LenderName LIKE '%lend%') AND (dbo.Persons.State = 'AK'))"));
Assert.IsTrue(ExecuteQuery(sqlFromQueryBuilder));
}
public void TestSimpleOneTableFromOneCriteriFromDaBase()
{
var criteriaBusiness = new O2CV1Business(_sqlConnectionString);
var sqlFromQueryBuilder = criteriaBusiness.BuildSqlFromQuery("17");
Assert.IsTrue(sqlFromQueryBuilder.Trim().Contains(@"SELECT Mortgages.* FROM Mortgages WHERE ((dbo.Mortgages.LenderName LIKE '%lend%') AND (dbo.Mortgages.LoanAmountRange = '$175K - $209K'))"));
Assert.IsTrue(ExecuteQuery(sqlFromQueryBuilder));
}
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));
}
public ActionResult SyncQuery(CountsQueryModel model)
{
if (ModelState.IsValid)
{
O2CV1QueryDto queryDto;
CriteriaDto criteriaDto;
BuildDtosForCriteriaAdd(model, out queryDto, out criteriaDto);
var criteriaBusiness = new O2CV1Business(_dbConnectionString);
var queryId = criteriaBusiness.CreateNextCriteriaForQuery(queryDto, criteriaDto);
model.QueryId = queryId;
queryDto.QueryId = queryId;
SaveQuerySqlChanges(queryId, queryDto);
ModelState.Clear();
ResetCountsQueryModel(criteriaDto, queryDto, model);
return(View("Criteria", model));
}
return(Redirect("Index"));
}
