public ActionResult ConvertToQuery(ContactSearchModel m)
{
var qb = DbUtil.Db.QueryBuilderScratchPad();
qb.CleanSlate(DbUtil.Db);
var comp = CompareType.Equal;
var clause = qb.AddNewClause(QueryType.MadeContactTypeAsOf, comp, "1,T");
clause.Program = m.Ministry ?? 0;
clause.StartDate = m.StartDate ?? DateTime.Parse("1/1/2000");
clause.EndDate = m.EndDate ?? DateTime.Today;
var cvc = new CodeValueModel();
var q = from v in cvc.ContactTypeCodes0()
where v.Id == m.ContactType
select v.IdCode;
var idvalue = q.Single();
clause.CodeIdValue = idvalue;
DbUtil.Db.SubmitChanges();
return Redirect("/QueryBuilder/Main/{0}".Fmt(qb.QueryId));
}
