internal Expression RecentFlagAdded() { var codes0 = CodeValues.Split(',').Select(ff => ff.Trim()).ToList(); var q = db.ViewStatusFlagLists.ToList(); if (!db.FromBatch) { q = (from f in q where f.RoleName == null || db.CurrentRoles().Contains(f.RoleName) select f).ToList(); } var codes = (from f in q join c in codes0 on f.Flag equals c into j from c in j select c).ToList(); var now = Util.Now; var dt = now.AddDays(-Days).Date; Expression <Func <Person, bool> > pred = p => ( from t in p.Tags where codes.Contains(t.Tag.Name) where t.Tag.TypeId == DbUtil.TagTypeId_StatusFlags where t.DateCreated >= dt select t ).Any(); Expression expr = Expression.Invoke(pred, parm); // substitute parm for p if (op == CompareType.NotEqual || op == CompareType.NotOneOf) { expr = Expression.Not(expr); } return(expr); }
internal Expression FamHasStatusFlag() { var codes0 = CodeValues.Split(',').Select(ff => ff.Trim()).ToList(); var q = db.ViewStatusFlagLists.ToList(); if (!db.FromBatch) { q = (from f in q where f.RoleName == null || db.CurrentRoles().Contains(f.RoleName) select f).ToList(); } var codes = (from f in q join c in codes0 on f.Flag equals c into j from c in j select c).ToList(); Expression <Func <Person, bool> > pred = p => p.Family.People.Any(m => m.Tags.Any(tt => codes.Contains(tt.Tag.Name) && tt.Tag.TypeId == 100)); Expression expr = Expression.Invoke(pred, parm); // substitute parm for p if (op == CompareType.NotEqual || op == CompareType.NotOneOf) { expr = Expression.Not(expr); } return(expr); }
private List<SelectListItem> ConvertToSelect(object items, string valuefield, List<string> values = null) { var codeValueItems = items as IEnumerable<CodeValueItem>; if (codeValueItems == null) return new List<SelectListItem>(); var codeValueList = codeValueItems.ToList(); List<SelectListItem> list2; if (values == null) values = CodeValues?.ToList() ?? new List<string>(); switch (valuefield) { case "IdCode": list2 = codeValueList.Select(c => new SelectListItem { Text = c.Value, Value = c.IdCode, Selected = values.Contains(c.IdCode) }).ToList(); break; case "IdValue": list2 = codeValueList.Select(c => new SelectListItem { Text = c.Value, Value = c.IdValue, Selected = values.Any(vv => vv.StartsWith($"{c.Id},") || vv == $"{c.Id}") }).ToList(); break; case "Id": list2 = codeValueList.Select(c => new SelectListItem { Text = c.Value, Value = c.Id.ToString(), Selected = values.Contains(c.Id.ToString()) }).ToList(); break; case "CodeValue": list2 = codeValueList.Select(c => new SelectListItem { Text = c.Value, Value = c.CodeValue, Selected = values.Any(vv => vv.StartsWith($"{c.Code}:") || vv == c.Code)}).ToList(); break; case "Code": list2 = codeValueList.Select(c => new SelectListItem { Text = c.Value, Value = c.Code, Selected = values.Contains(c.Code) }).ToList(); break; default: list2 = codeValueList.Select(c => new SelectListItem { Text = c.Value, Value = c.Value, Selected = values.Contains(c.Value) }).ToList(); break; } return list2; }
public List <PayingGuestHouse> GetAllPgs() { var pgs = (from pg in _dbContext.tbl_pgsb_paying_guest_homestay select new PayingGuestHouse { PGFullName = pg.name, AddressLine1 = pg.address_line_1, AddressLine2 = pg.address_line_2, DetailedDescription = pg.incharge_person_details, IsInCharge = !string.IsNullOrEmpty(pg.incharge_id), OwnerName = pg.owner_name, PhoneNumber = pg.contact_phone_number, Email = pg.email_id, PGMasterId = Guid.Parse(pg.pg_id), //PointOfContact = pg.tbl_pgsb_users. Area = new Area(CodeValues.GetCodeValue("Area", pg.area_code), CodeValues.GetCodeValue("pincode", Convert.ToInt32(pg.pin_code))), PGType = new PGTypeGenderWise(CodeValues.GetCodeValue("pgtype", pg.pg_type_code)), //PointOfContact //pg.tbl_pgsb_pg_amenities.ToList().ForEach( //a => //{ // Amenities.Add(CodeValues.GetCodeValue("PGAmenity", a.amenity_code)); //}), } ); return(pgs.ToList()); }
public IEnumerable<SelectListItem> StatusFlags() { var q = from s in CodeValueModel.StatusFlags() select new SelectListItem { Value = $"{s.Code}:{s.Value}", Text = s.Value, Selected = CodeValues.Any(vv => vv == s.Code) }; return q; }
private IEnumerable<SelectListItem> SelectedList(IEnumerable<SelectListItem> items) { if (CodeValues != null) return items.Select(c => new SelectListItem { Text = c.Text, Value = c.Value, Selected = CodeValues.Contains(c.Value) }); return items; }
public List <SelectListItem> ConvertToSelect(object items, string valuefield) { var list = items as IEnumerable <CodeValueItem>; List <SelectListItem> list2; List <string> values; if (CodeValues != null) { values = CodeValues.ToList(); } else if (CodeValue != null) { values = new List <string> { CodeValue } } ; else { values = new List <string>(); } switch (valuefield) { case "IdCode": list2 = list.Select(c => new SelectListItem { Text = c.Value, Value = c.IdCode, Selected = values.Contains(c.IdCode) }).ToList(); break; case "Id": list2 = list.Select(c => new SelectListItem { Text = c.Value, Value = c.Id.ToString(), Selected = values.Contains(c.Id.ToString()) }).ToList(); break; case "Code": list2 = list.Select(c => new SelectListItem { Text = c.Value, Value = c.Code, Selected = values.Contains(c.Code) }).ToList(); break; default: list2 = list.Select(c => new SelectListItem { Text = c.Value, Value = c.Value, Selected = values.Contains(c.Value) }).ToList(); break; } return(list2); }
private void GetAllCodeValues() { if (CodeValues.IsLoaded) { return; } var cds = (from cd in _dbContext.tbl_pgsb_code_values select new CodeValue { Code = cd.code, CodeValueDesc = cd.code_value_desc, CodeValueDisplay = cd.code_value, CodeValueType = cd.code_value_type, CodeValueId = cd.code_value_id, ParentCode = cd.tbl_pgsb_code_values2.code, ParentCodeValueType = cd.tbl_pgsb_code_values2.code_value_type, }).ToList(); CodeValues.SetCodeValues(cds); }
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.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; }