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