private void SaveToSession(ContactSearchModel m)
{
Session[STR_ContactSearch] = new ContactSearchInfo
{
EndDate = m.EndDate,
StartDate = m.StartDate,
MinistryId = m.Ministry,
ContactTypeId = m.ContactType,
ContactorName = m.ContactorName,
ContacteeName = m.ContacteeName,
ContactReasonId = m.ContactReason,
StatusId = m.Status
};
}
public ActionResult Results(ContactSearchModel m)
{
SaveToSession(m);
return View(m);
}
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));
}
public ActionResult Index()
{
Response.NoCache();
var m = new ContactSearchModel();
var os = Session[STR_ContactSearch] as ContactSearchInfo;
if (os != null)
{
m.ContactReason = os.ContactReasonId;
m.ContacteeName = os.ContacteeName;
m.ContactorName = os.ContactorName;
m.ContactType = os.ContactTypeId;
m.Ministry = os.MinistryId;
m.StartDate = os.StartDate;
m.EndDate = os.EndDate;
m.Status = os.StatusId;
}
return View(m);
}
public ActionResult ConvertToQuery(ContactSearchModel m)
{
var cc = DbUtil.Db.ScratchPadCondition();
cc.Reset(DbUtil.Db);
var comp = CompareType.Equal;
var clause = cc.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.ContactTypeList()
where v.Id == m.ContactType
select v.IdCode;
var idvalue = q.Single();
clause.CodeIdValue = idvalue;
cc.Save(DbUtil.Db);
if (ViewExtensions2.UseNewLook())
return Redirect("/Query/" + cc.Id);
return Redirect("/QueryBuilder2/Main/{0}".Fmt(cc.Id));
}
