public IEnumerable<SelectListItem> Tags() { var cv = new CodeValueModel(); var tg = CodeValueModel.ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Id").ToList(); tg.Insert(0, new SelectListItem { Value = "0", Text = "(not specified)" }); return tg; }
public static IEnumerable <SelectListItem> Tags() { var cv = new CodeValueModel(); var tg = ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Id").ToList(); if (HttpContextFactory.Current.User.IsInRole("Edit")) { tg.Insert(0, new SelectListItem { Value = "-1", Text = "(last query)" }); } tg.Insert(0, new SelectListItem { Value = "0", Text = "(not specified)" }); return(tg); }
public SelectList Tags() { var cv = new CodeValueModel(); var tg = cv.UserTags(Util.UserPeopleId); tg = tg.Select(tt => new CodeValueItem {Value = $"tag: {tt.Id}:{tt.Value}"}).ToList(); var q = from e in DbUtil.Db.PeopleExtras where e.StrValue != null group e by e.FieldValue into g select new CodeValueItem {Value = "exval: " + g.Key}; tg.AddRange(q); if (HttpContext.Current.User.IsInRole("Admin")) tg.Insert(0, new CodeValueItem {Value = "last query"}); tg.Insert(0, new CodeValueItem {Value = "(not specified)"}); var list = tg.ToSelect("Value"); var sel = list.SingleOrDefault(mm => mm.Value == Tag); if (sel != null) sel.Selected = true; return list; }
public static IEnumerable<SelectListItem> Tags() { var cv = new CodeValueModel(); var tg = ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Id").ToList(); if (HttpContext.Current.User.IsInRole("Edit")) tg.Insert(0, new SelectListItem {Value = "-1", Text = "(last query)"}); tg.Insert(0, new SelectListItem {Value = "0", Text = "(not specified)"}); return tg; }
public IEnumerable<CodeValueItem> Tags() { var up = DbUtil.Db.CurrentUserPerson; if (up == null) return new List<CodeValueItem>(); var ctl = new CodeValueModel(); var pid = DbUtil.Db.CurrentUser.PeopleId; var list = ctl.UserTags(pid); return list; }
public IEnumerable<CodeValueItem> Tags() { if (Util.UserPeopleId == null) return new List<CodeValueItem>(); var ctl = new CodeValueModel(); var list = ctl.UserTags(Util.UserPeopleId); return list; }
public void SetVisibility() { CodeData = null; ConditionName = ConditionName; CompareData = Comparisons().ToList(); if (QuartersVisible) QuartersLabel = fieldMap.QuartersTitle; if (TagsVisible) { var cv = new CodeValueModel(); TagData = CodeValueModel.ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Code"); } if (PmmLabelsVisible) { var cv = new CodeValueModel(); PmmLabelData = CodeValueModel.ConvertToSelect(CodeValueModel.PmmLabels(), "Code"); } var cvctl = new CodeValueModel(); switch (fieldMap.Type) { case FieldType.Bit: case FieldType.NullBit: CodeData = CodeValueModel.ConvertToSelect(BitCodes, fieldMap.DataValueField); break; case FieldType.NullCode: case FieldType.Code: case FieldType.CodeStr: if (fieldMap.DataSource == "ExtraValues") CodeData = StandardExtraValues.ExtraValueCodes(); else if (fieldMap.DataSource == "Campuses") CodeData = Campuses(); else if( fieldMap.DataSource == "Activities" ) { var ret = ( from e in DbUtil.Db.CheckInActivities select e.Activity ).Distinct(); CodeData = from e in ret select new SelectListItem() {Text = e, Value = e}; } else CodeData = CodeValueModel.ConvertToSelect( Util.CallMethod( cvctl, fieldMap.DataSource ), fieldMap.DataValueField ); break; case FieldType.DateField: CodeData = CodeValueModel.ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField); break; } var cc = Selected; if (cc == null) return; if (fieldMap.Type == FieldType.Group) { CompareData = Comparisons().ToList(); UpdateEnabled = cc.IsGroup; return; } UpdateEnabled = !cc.IsGroup && !cc.IsFirst; AddToGroupEnabled = cc.IsGroup; AddEnabled = !cc.IsFirst; RemoveEnabled = !cc.IsFirst; }
public void EditCondition() { var c = Selected; if (c == null) return; SetVisibility(); ConditionName = c.FieldInfo.Name; CompareData = Comparisons().ToList(); Comparison = c.Comparison; if (QuartersVisible) QuartersLabel = fieldMap.QuartersTitle; if (TagsVisible) { var cv = new CodeValueModel(); TagData = CodeValueModel.ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Code"); } if (PmmLabelsVisible) { PmmLabelData = CodeValueModel.ConvertToSelect(CodeValueModel.PmmLabels(), "Code"); } var cvctl = new CodeValueModel(); switch (fieldMap.Type) { case FieldType.Bit: case FieldType.NullBit: CodeData = CodeValueModel.ConvertToSelect(BitCodes, fieldMap.DataValueField); break; case FieldType.NullCode: case FieldType.Code: case FieldType.CodeStr: if (fieldMap.DataSource == "ExtraValues") { CodeData = StandardExtraValues.ExtraValueCodes(); } else if (fieldMap.DataSource == "FamilyExtraValues") CodeData = StandardExtraValues.FamilyExtraValueCodes(); else if (fieldMap.DataSource == "Campuses") CodeData = Campuses(); else if (fieldMap.DataSource == "Activities") { var ret = (from e in DbUtil.Db.CheckInActivities select e.Activity).Distinct(); CodeData = from e in ret select new SelectListItem() { Text = e, Value = e }; } else CodeData = CodeValueModel.ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField); break; case FieldType.DateField: CodeData = CodeValueModel.ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField); break; } if (fieldMap.Type == FieldType.Group) { CompareData = Comparisons().ToList(); UpdateEnabled = c.IsGroup; } else { UpdateEnabled = !c.IsGroup && !c.IsFirst; AddToGroupEnabled = c.IsGroup; AddEnabled = !c.IsFirst; RemoveEnabled = !c.IsFirst; } switch (c.FieldInfo.Type) { case FieldType.String: case FieldType.StringEqual: case FieldType.StringEqualOrStartsWith: TextValue = c.TextValue; break; case FieldType.Integer: case FieldType.IntegerSimple: case FieldType.IntegerEqual: case FieldType.NullInteger: IntegerValue = c.TextValue; break; case FieldType.Number: case FieldType.NumberLG: case FieldType.NullNumber: NumberValue = c.TextValue; break; case FieldType.Date: case FieldType.DateSimple: DateValue = DateString(c.DateValue); break; case FieldType.Code: case FieldType.NullCode: case FieldType.CodeStr: case FieldType.DateField: case FieldType.Bit: case FieldType.NullBit: CodeValue = c.CodeIdValue; if (c.HasMultipleCodes && CodeValue.HasValue()) { CodeValues = c.CodeIdValue.Split(';'); foreach (var i in CodeData) i.Selected = CodeValues.Contains(i.Value); } break; } Program = c.Program; DivisionData = Divisions(Program).ToList(); Division = c.Division; OrganizationData = Organizations(Division).ToList(); Organization = c.Organization; Schedule = c.Schedule; Campus = c.Campus; OrgType = c.OrgType; StartDate = DateString(c.StartDate); EndDate = DateString(c.EndDate); AddToGroupEnabled = c.IsGroup; AddEnabled = !c.IsFirst; RemoveEnabled = !c.IsFirst; Days = c.Days.ToString(); Age = c.Age.ToString(); Quarters = c.Quarters; if (TagsVisible) { if (c.Tags != null) Tags = c.Tags.Split(';'); var cv = new CodeValueModel(); TagData = CodeValueModel.ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Code"); foreach (var i in TagData) i.Selected = Tags.Contains(i.Value); } if (PmmLabelsVisible) { if (c.Tags != null) PmmLabels = c.Tags.Split(',').Select(vv => vv).ToArray(); var cv = new CodeValueModel(); PmmLabelData = CodeValueModel.ConvertToSelect(CodeValueModel.PmmLabels(), "Id"); if (PmmLabels != null) foreach (var i in PmmLabelData) i.Selected = PmmLabels.Contains(i.Value); } if (MinistryVisible) Ministry = c.Program; //SavedQueryDesc = c.SavedQueryIdDesc; }
public void EditCondition() { var c = Db.LoadQueryById(SelectedId); if (c == null) return; ConditionName = c.FieldInfo.Name; SetVisibility(); Comparison = c.Comparison; switch (c.FieldInfo.Type) { case FieldType.String: case FieldType.StringEqual: case FieldType.StringEqualOrStartsWith: TextValue = c.TextValue; break; case FieldType.Integer: case FieldType.IntegerSimple: case FieldType.IntegerEqual: case FieldType.NullInteger: IntegerValue = c.TextValue; break; case FieldType.Number: case FieldType.NumberLG: case FieldType.NullNumber: NumberValue = c.TextValue; break; case FieldType.Date: case FieldType.DateSimple: DateValue = DateString(c.DateValue); break; case FieldType.Code: case FieldType.NullCode: case FieldType.CodeStr: case FieldType.DateField: case FieldType.Bit: case FieldType.NullBit: CodeValue = c.CodeIdValue; if (c.HasMultipleCodes && CodeValue.HasValue()) { CodeValues = c.CodeIdValue.Split(';'); foreach (var i in CodeData) i.Selected = CodeValues.Contains(i.Value); } break; } Program = c.Program; DivisionData = Divisions(Program).ToList(); Division = c.Division; OrganizationData = Organizations(Division).ToList(); Organization = c.Organization; Schedule = c.Schedule; Campus = c.Campus; OrgType = c.OrgType; StartDate = DateString(c.StartDate); EndDate = DateString(c.EndDate); SelectMultiple = c.HasMultipleCodes; AddToGroupEnabled = c.IsGroup; AddEnabled = !c.IsFirst; RemoveEnabled = !c.IsFirst; Days = c.Days.ToString(); Age = c.Age.ToString(); Quarters = c.Quarters; if (TagsVisible) { if (c.Tags != null) Tags = c.Tags.Split(';'); var cv = new CodeValueModel(); TagData = CodeValueModel.ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Code"); foreach (var i in TagData) i.Selected = Tags.Contains(i.Value); } if (PmmLabelsVisible) { if (c.Tags != null) PmmLabels = c.Tags.Split(',').Select(vv => vv).ToArray(); var cv = new CodeValueModel(); PmmLabelData = CodeValueModel.ConvertToSelect(cv.PmmLabels(), "Id"); if(PmmLabels != null) foreach (var i in PmmLabelData) i.Selected = PmmLabels.Contains(i.Value); } if (MinistryVisible) Ministry = c.Program; SavedQueryDesc = c.SavedQueryIdDesc; }
public void SetVisibility() { RightPanelVisible = true; TextVisible = false; NumberVisible = false; CodeVisible = false; CodesVisible = false; DateVisible = false; CodeData = null; ConditionName = ConditionName; CompareData = Comparisons().ToList(); DivisionVisible = fieldMap.HasParam("Division"); ProgramVisible = fieldMap.HasParam("Program"); OrganizationVisible = fieldMap.HasParam("Organization"); ScheduleVisible = fieldMap.HasParam("Schedule"); CampusVisible = fieldMap.HasParam("Campus"); OrgTypeVisible = fieldMap.HasParam("OrgType"); DaysVisible = fieldMap.HasParam("Days"); AgeVisible = fieldMap.HasParam("Age"); SavedQueryVisible = fieldMap.HasParam("SavedQueryIdDesc"); MinistryVisible = fieldMap.HasParam("Ministry"); QuartersVisible = fieldMap.HasParam("Quarters"); if (QuartersVisible) QuartersLabel = fieldMap.QuartersTitle; TagsVisible = fieldMap.HasParam("Tags"); if (TagsVisible) { var cv = new CodeValueModel(); TagData = CodeValueModel.ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Code"); } PmmLabelsVisible = fieldMap.HasParam("PmmLabels"); if (PmmLabelsVisible) { var cv = new CodeValueModel(); PmmLabelData = CodeValueModel.ConvertToSelect(cv.PmmLabels(), "Code"); } StartDateVisible = fieldMap.HasParam("StartDate"); EndDateVisible = fieldMap.HasParam("EndDate"); var cvctl = new CodeValueModel(); switch (fieldMap.Type) { case FieldType.Bit: case FieldType.NullBit: CodeVisible = true; CodeData = CodeValueModel.ConvertToSelect(BitCodes, fieldMap.DataValueField); break; case FieldType.String: case FieldType.StringEqual: case FieldType.StringEqualOrStartsWith: TextVisible = true; break; case FieldType.NullNumber: case FieldType.Number: case FieldType.NumberLG: NumberVisible = true; break; case FieldType.NullInteger: case FieldType.Integer: case FieldType.IntegerSimple: case FieldType.IntegerEqual: IntegerVisible = true; break; case FieldType.NullCode: case FieldType.Code: case FieldType.CodeStr: CodeVisible = true; if (fieldMap.DataSource == "ExtraValues") CodeData = StandardExtraValues.ExtraValueCodes(); else if (fieldMap.DataSource == "Campuses") CodeData = Campuses(); else CodeData = CodeValueModel.ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField); break; case FieldType.Date: case FieldType.DateSimple: DateVisible = true; break; case FieldType.DateField: CodeVisible = true; CodeData = CodeValueModel.ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField); break; } var cc = Db.LoadQueryById(SelectedId); if (cc == null) return; if (fieldMap.Type == FieldType.Group) { CompareData = Comparisons().ToList(); RightPanelVisible = false; UpdateEnabled = cc.IsGroup; return; } UpdateEnabled = !cc.IsGroup && !cc.IsFirst; AddToGroupEnabled = cc.IsGroup; AddEnabled = !cc.IsFirst; RemoveEnabled = !cc.IsFirst; }
public List<SelectListItem> Tags() { var cv = new CodeValueModel(); var tg = CodeValueModel.ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Id"); tg = tg.Select(tt => new SelectListItem { Text = "tag: {0}:{1}".Fmt(tt.Value, tt.Text) }).ToList(); var q = from e in DbUtil.Db.PeopleExtras where e.StrValue != null group e by e.FieldValue into g select new SelectListItem { Text = "exval: " + g.Key }; tg.AddRange(q); if (HttpContext.Current.User.IsInRole("Admin")) tg.Insert(0, new SelectListItem { Text = "last query" }); tg.Insert(0, new SelectListItem { Text = "(not specified)" }); var sel = tg.SingleOrDefault(mm => mm.Text == Tag); if(sel != null) sel.Selected = true; return tg.ToList(); }