private List<ToDoItem> BuildList(List<ToDoItem> todoItems, JArray y) { foreach (var item in y.Children()) { var itemProperties = item.Children<JProperty>(); var element = itemProperties.FirstOrDefault(xx => xx.Name == "values"); JProperty index = itemProperties.FirstOrDefault(xxx => xxx.Name == "index"); JToken values = element.Value; var stringValues = from stringValue in values select stringValue; foreach (JToken thing in stringValues) { IEnumerable<string> rowValues = thing.Values<string>(); string[] stringArray = rowValues.Cast<string>().ToArray(); try { ToDoItem todoItem = new ToDoItem( Convert.ToInt32(index.Value), stringArray[1], stringArray[3], stringArray[4], stringArray[2], stringArray[5], stringArray[6], stringArray[7]); todoItems.Add(todoItem); } catch (FormatException f) { Console.WriteLine(f.Message); } } } return todoItems; }
/// <summary> /// Создать список объектов из json массива /// </summary> /// <param name="array"></param> /// <returns></returns> public static List<AbstractStorable> restoreArray(JArray array) { List<AbstractStorable> list = new List<AbstractStorable>(); foreach (JObject obj in array.Children<JObject>()) { list.Add(AbstractStorable.newInstance(obj)); } return list; }
/// <summary> /// Восстановить матрицу /// </summary> /// <param name="array"></param> /// <returns></returns> public static double[][] restoreMatrix(JArray array) { double[][] matrix = new double[array.Count][]; int i = 0; foreach (JArray obj in array.Children<JArray>()) { matrix[i] = restoreVector(obj); i++; } return matrix; }
static void Main(string[] args) { string query = "select count(id) Enero from [apiDashboard].[dbo].[maFlow] where DATEPART(month, payDatetime) = 01; select count(id) Febrero from [apiDashboard].[dbo].[maFlow] where DATEPART(month, payDatetime) = 02"; var client = new RestClient("http://localhost:64412/apiV1/"); // client.Authenticator = new HttpBasicAuthenticator(username, password); var request = new RestRequest(string.Format("select?query={0}", query.Trim()), Method.GET); request.AddHeader("Accept", "application/json"); request.AddHeader("CnnString", "RGF0YSBTb3VyY2U9Llxtc3NxbDIwMTQ7SW5pdGlhbCBDYXRhbG9nPWFwaURhc2hib2FyZDtQZXJzaXN0IFNlY3VyaXR5IEluZm89VHJ1ZTtVc2VyIElEPXNhO1Bhc3N3b3JkPWFz"); request.AddHeader("Provider", "sqlserver"); try { RestResponse response = client.Execute(request) as RestResponse; if (response.StatusCode == System.Net.HttpStatusCode.OK) { dynamic data = JValue.Parse(response.Content); if (data.REST_Service.Status_code.ToString() == "1") { foreach (dynamic item in data.Response) { Console.WriteLine("Command : {0}", item.Command.ToString()); JArray result = new JArray(item.Result); foreach (JObject content in result.Children<JObject>()) { foreach (JProperty prop in content.Properties()) { Console.WriteLine("{0} : {1}", prop.Name.ToString().Trim(), prop.Value.ToString().Trim()); } } } } else { throw new Exception(data.REST_Service.Message.ToString()); } } else { throw new Exception(response.StatusDescription); } } catch (Exception ex) { Console.WriteLine(string.Format("Ocurrió un error [ {0} ]", ex.Message)); } Console.ReadKey(); }
public static PatchDocument Load(JArray document) { var root = new PatchDocument(); if (document == null) return root; foreach (var jOperation in document.Children().Cast<JObject>()) { var op = Operation.Build(jOperation); root.AddOperation(op); } return root; }
/// <summary> /// Populates <paramref name="target"/> with values from <paramref name="source"/> and <paramref name="response"/> /// as defined by <paramref name="fieldMap"/>. It also returns a new <see cref="Newtonsoft.Json.Linq.JArray"/> with mapped values. /// </summary> /// <param name="source">The response body from which to get values.</param> /// <param name="response">The response object from which to get values.</param> /// <param name="fieldMap">A definition of field mappings.</param> /// <param name="target">The target object to populate with mapped key/values.</param> /// <param name="maxResults">The maximum number of results to return.</param> /// <returns>A new <see cref="Newtonsoft.Json.Linq.JArray"/> with mapped values.</returns> public JArray MapArray(JArray source, HttpWebResponse response, MappedFieldList fieldMap, ApplicationData target, int? maxResults = null) { int max = maxResults ?? int.MaxValue; JArray outArray = new JArray(); IEnumerator<JObject> enumerator = source.Children<JObject>().GetEnumerator(); int i = 0; while (enumerator.MoveNext() && i < max) { outArray.Add(this.MapObject(enumerator.Current, response, fieldMap, target)); i++; } return outArray; }
public static string GetFoxBoxscoreUrl(JArray scheduleJson, int awayTeamId, int homeTeamId) { var boxscoreUrl = string.Empty; foreach (var game in scheduleJson.Children()) { if (game["AwayTeamId"].Value<int>() == awayTeamId && game["HomeTeamId"].Value<int>() == homeTeamId) { var linksObj = game["Links"]; boxscoreUrl = linksObj["boxscore"].Value<string>(); break; } } return boxscoreUrl; }
public MockedResultSet(JArray data, Func<JObject, bool> predicate = null, IEnumerable<JProperty> schema = null) { if (data == null) { Data = new JObject[0]; } else { Data = data.Children().Cast<JObject>(); if (predicate != null) Data = Data.Where(predicate); } if (schema == null && Data != null) { var list = Data.ToList(); var first = list.FirstOrDefault(); if (first != null) schema = first.Properties(); Data = list; } Schema = schema; }
public List<Forecast> ForecastsDataMapper(JObject jsonObject) { List<Forecast> forecasts = new List<Forecast>(); JArray dataArray = new JArray(jsonObject["data"].Children()); foreach (var item in dataArray.Children()) { JObject itemJSON = JObject.Parse(item.ToString()); Forecast forecast = new Forecast(); forecast.ForecastDate = FieldMapperDateTime(itemJSON, "time"); forecast.ForecastDateDisplay = forecast.ForecastDate.ToShortDateString(); forecast.ForecastWeather = WeatherDataMapper(itemJSON, "summary", "temperatureMax"); forecasts.Add(forecast); } return forecasts; }
public List<Forecast> ForecastsDataMapper(JObject jsonObject) { List<Forecast> forecasts = new List<Forecast>(); JArray dataArray = new JArray(jsonObject["forecastday"].Children()); foreach (var item in dataArray.Children()) { JObject itemJSON = JObject.Parse(item.ToString()); Forecast forecast = new Forecast(); forecast.ForecastDate = FieldMapperDateTime(JObject.Parse(itemJSON["date"].ToString()), "epoch"); forecast.ForecastDateDisplay = forecast.ForecastDate.ToShortDateString(); forecast.ForecastWeather = WeatherDataMapper(itemJSON, "conditions", "high", "fahrenheit"); forecasts.Add(forecast); } return forecasts; }
private void ReportInvalidStepValues( AnnotatedCodeLocation[] locations, JArray annotatedCodeLocationArray, string annotatedCodeLocationsPointer) { JObject[] annotatedCodeLocationObjects = annotatedCodeLocationArray.Children<JObject>().ToArray(); for (int i = 0; i < locations.Length; ++i) { // Only report "invalid step value" for locations that actually specify // the "step" property (the value of the Step property in the object // model will be 0 for such steps, which is never valid), because we // already reported the missing "step" properties. if (LocationHasStep(annotatedCodeLocationObjects[i]) && locations[i].Step != i + 1) { string invalidStepPointer = annotatedCodeLocationsPointer .AtIndex(i).AtProperty(SarifPropertyName.Step); LogResult( invalidStepPointer, nameof(RuleResources.SARIF009_InvalidStepValue), (i + 1).ToInvariantString(), (locations[i].Step).ToInvariantString()); } } }
/// <summary> /// Get specified properties from an feed payload. /// </summary> /// <param name="feed">A feed.</param> /// <param name="elementName">An element name which is expected to get.</param> /// <returns>Returns a list of properties.</returns> public static List<JProperty> GetSpecifiedPropertiesFromFeedPayload(JArray feed, string elementName) { if (feed == null || elementName == null || elementName == string.Empty) { return props; } if (feed != null && feed.Type == JTokenType.Array) { foreach (JObject entry in feed.Children()) { props = GetSpecifiedPropertiesFromEntryPayload(entry, elementName); } } return props; }
private static string GetStringFromArray(JArray array) { if (array.Count == 0) return ""; bool isOneLine = array.Children() .All(t => t.Type == JTokenType.Integer || t.Type == JTokenType.Float || t.Type == JTokenType.Boolean); if (isOneLine) { return string.Join(", ", array.Children().Select(c => c.ToString(Formatting.None)).ToArray()); } else { return string.Join("\n", array.Children().Select(c => c.ToString(Formatting.None)).ToArray()); } }
public JArray translateToDisplayName(JArray array, string type) { var displayNames = crmService.GetAttributeDisplayName(type); var contactsWithDisplayNames = new JArray(); foreach (var contact in array.Children<JObject>()) { var newContact = new JObject(); foreach (var keyValue in contact.Properties()) { if (displayNames.ContainsKey(keyValue.Name.ToString().ToLower())) { string displayName; displayNames.TryGetValue(keyValue.Name.ToString().ToLower(), out displayName); if (newContact.Property(displayName) == null) { newContact.Add(displayName, keyValue.Value); } else { newContact.Add(displayName + " 2", keyValue.Value); } } } contactsWithDisplayNames.Add(newContact); } return contactsWithDisplayNames; }
/// <summary> /// Merge zweier Arrays /// </summary> /// <param name="iTarget"></param> /// <param name="iTemplate"></param> private void MergeTemplate(JArray iTarget, JArray iTemplate) { JsonMergeSettings lMergeSettings = new JsonMergeSettings(); lMergeSettings.MergeArrayHandling = MergeArrayHandling.Union; if (iTemplate.First.Type == JTokenType.Array) { for (int i = 0; i < iTemplate.Count && i < iTarget.Count; i++) { //(iTarget[i] as JArray).Merge(iTemplate[i], lMergeSettings); //iTemplate[i].Remove(); (iTemplate[i] as JArray).Merge(iTarget[i], lMergeSettings); iTarget[i].Remove(); } } //iTarget.Merge(iTemplate, lMergeSettings); iTemplate.Merge(iTarget, lMergeSettings); iTarget.RemoveAll(); iTarget.Add(iTemplate.Children()); }
// Assign price class to items public dynamic PostsalesdetailsPrice(JArray pPostedData) { var fitem = ""; var fclass = ""; foreach (JObject item in pPostedData.Children<JObject>()) { fitem = item["fitem"].ToString(); fclass = item["fpriceclass"].ToString(); item["fprice"] = _db.itemsalesprices.Where(t => t.fitem == fitem && t.fclass == fclass).FirstOrDefault().fsaleprice; } return new { plist = pPostedData }; }
private IEnumerable<object[]> EnumerableOfArrays(JArray jarray) { foreach (var jtoken in jarray.Children()) { if (jtoken.Type == JTokenType.Array) { yield return jtoken.Children().Select(t => t.ToObject<object>()).ToArray(); } else { yield return new[] { jtoken.ToObject<object>() }; } } }
/// <summary> /// Parses a union token. /// </summary> /// <param name="unionToken">The union token.</param> /// <param name="parent">The parent.</param> /// <param name="namedSchemas">The named schemas.</param> /// <returns> /// Schema internal representation. /// </returns> /// <exception cref="System.Runtime.Serialization.SerializationException">Thrown when union schema type is invalid.</exception> private TypeSchema ParseUnionType(JArray unionToken, NamedSchema parent, Dictionary<string, NamedSchema> namedSchemas) { var types = new HashSet<string>(); var schemas = new List<TypeSchema>(); foreach (var typeAlternative in unionToken.Children()) { var schema = this.Parse(typeAlternative, parent, namedSchemas); if (schema.Type == Token.Union) { throw new SerializationException( string.Format(CultureInfo.InvariantCulture, "Union schemas cannot be nested:'{0}'.", unionToken)); } if (types.Contains(schema.Type)) { throw new SerializationException( string.Format(CultureInfo.InvariantCulture, "Unions cannot contains schemas of the same type: '{0}'.", schema.Type)); } types.Add(schema.Type); schemas.Add(schema); } return new UnionSchema(schemas, typeof(object)); }
public JArray TranslatePropertiesToDisplayName(JArray array, string type) { var displayNames = crmService.GetAttributeDisplayName(type).ToList(); var contactsWithDisplayNames = new JArray(); foreach (var contact in array.Children<JObject>()) { var newContact = new JObject(); foreach (var property in contact.Properties()) { var displayName = displayNames.SingleOrDefault(d => d.LogicalName == property.Name.ToLower()); if(displayName == null) continue; if (newContact.Property(displayName.DisplayName) == null) { newContact.Add(displayName.DisplayName, property.Value); } else { var suffix = 2; while (newContact.Property(displayName.DisplayName + ' ' + suffix) != null) suffix++; newContact.Add(displayName.DisplayName + ' ' + suffix, property.Value); } } contactsWithDisplayNames.Add(newContact); } return contactsWithDisplayNames; }
private void ReportMissingStepProperty( JArray annotatedCodeLocationArray, string annotatedCodeLocationsPointer) { JObject[] annotatedCodeLocationObjects = annotatedCodeLocationArray.Children<JObject>().ToArray(); if (annotatedCodeLocationObjects.Length > 0) { JObject[] locationsWithStep = GetLocationsWithStep(annotatedCodeLocationObjects); // It's ok if there are no steps, but if any location has a step property, // all locations must have it. if (locationsWithStep.Length > 0 && locationsWithStep.Length < annotatedCodeLocationObjects.Length) { int missingStepIndex = FindFirstLocationWithMissingStep(annotatedCodeLocationObjects); Debug.Assert(missingStepIndex != -1, "Couldn't find location with missing step."); string missingStepPointer = annotatedCodeLocationsPointer.AtIndex(missingStepIndex); LogResult(missingStepPointer, nameof(RuleResources.SARIF009_StepNotPresentOnAllLocations)); } } }
public void Children() { JArray a = new JArray( 5, new JArray(1), new JArray(1, 2), new JArray(1, 2, 3) ); Assert.AreEqual(4, a.Count()); Assert.AreEqual(3, a.Children<JArray>().Count()); }
public static QueryEntityVersionsRequest FromJArray(JArray jArray) { var constraints = jArray.Children().Select(child => JsonConvert.DeserializeObject<WireConstraint>(child.ToString())).ToList(); return new QueryEntityVersionsRequest(constraints); }