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