public static Guid ContactTypeQuery(int id) { var c = DbUtil.Db.ScratchPadCondition(); c.Reset(); var comp = CompareType.Equal; var clause = c.AddNewClause(QueryType.RecentContactType, comp, "1,True"); clause.Days = 10000; var cvc = new CodeValueModel(); var q = from v in cvc.ContactTypeList() where v.Id == id select v.IdValue; clause.CodeIdValue = q.Single(); c.Save(DbUtil.Db); return(c.Id); }
public Guid ConvertToQuery() { var c = DbUtil.Db.ScratchPadCondition(); c.Reset(); var clause = c.AddNewClause(QueryType.MadeContactTypeAsOf, CompareType.Equal, "1,True"); clause.Program = SearchParameters.Ministry.Value; clause.StartDate = SearchParameters.StartDate ?? DateTime.Parse("1/1/2000"); clause.EndDate = SearchParameters.EndDate ?? DateTime.Today; var cvc = new CodeValueModel(); var q = from v in cvc.ContactTypeList() where v.Id == SearchParameters.ContactType.Value.ToInt() select v.IdValue; var idvalue = q.Single(); clause.CodeIdValue = idvalue; c.Save(DbUtil.Db); return(c.Id); }