Help with JSON file reading

Question

Hi

I have this jason file located in my Assets/Dec1.js how can i make it appear in my textblock
when i run it in the emulator it shows "This" instead of showing the content in the Assets/Dec1.js
Kindly help

see the code below

xaml
<ScrollViewer>
<TextBlock x:Name="textblock" TextWrapping="Wrap" Foreground="White"/>
</ScrollViewer>

xaml.cs
//JSON starts here
        public string ReadJsonFile(string JsonfilePath)
        {
            string strText = "This";

using (StreamReader r = new StreamReader("Assets/Dec1.js"))
{

                string json = r.ReadToEnd();
                dynamic array = JsonConvert.DeserializeObject(json);
                //... read text from json file

}

            return strText;

        }

        //Daily Devotion starts here
        protected override void OnNavigatedTo(NavigationEventArgs e)
        {

            AddDevotions();
            int index = DateTime.Now.DayOfYear;
            textblock.Text = devotions[index];
        }

        List<String> devotions = new List<string>();
        private void AddDevotions()
        {
  devotions.Add(ReadJsonFile("Assets/Dec1.js"));
            devotions.Add(ReadJsonFile("Assets/Dec1.js"));
            devotions.Add(ReadJsonFile("Assets/Dec1.js"));
   }

Thank you in advance and reply soon

Vulpes · Answer

You'll first need to add a ToString() method to the Devotion class: public class Devotion { public string Date {get; set;} public string Title {get; set;} public string Verse {get; set;} [JsonProperty(Read Chapter)] public string ReadChapter {get; set;} [JsonProperty(Read Text)] public string ReadText {get; set;} [JsonProperty(Bible In One Year)] public string BibleInOneYear {get; set;} public string Message {get; set;} public string Notes {get; set;} public override string ToString() { string[] props = new string[8]; props[0] = DATE -  + Date; props[1] = TITLE -  + Title; props[2] = VERSE -  + Verse; props[3] = READ CHAPTER -  + ReadChapter; props[4] = READ TEXT -  + ReadText; props[5] = BIBLE IN ONE YEAR -  + BibleInOneYear; props[6] = MESSAGE -  + Message; props[7] = NOTES -  + Notes; return String.Join(

 props); } } and then change this line: textblock.Text = devotions[index].Message; // or some other property to this: textblock.Text = devotions[index] .ToString() ;

Vulpes · Answer

Hmm looking back at your sample it's actually set up as an array (outer square brackets are used) even though there's only one object in it. Are all 366 files set up in this way? If they are then we'll need to change the ReadJsonFile method as follows: public Devotion ReadJsonFile(string JsonfilePath) { Devotion[] d = null; using (StreamReader r = new StreamReader(JsonfilePath)) { string json = r.ReadToEnd(); d = JsonConvert.DeserializeObject Devotion[] >(json); } return d[0] ; }

Vulpes · Answer

The program assumes that there are 366 files named: Dec1.js Dec2.js up to Dec366.js in the Assets folder one for each day of the year. The error message suggests that it can't find (at least) one of these files and may be you haven't created them all yet? Incidentally it's struck me that we are going to need some more code to deal with February 29 which will be day 60 in a leap year. However in a non-leap year day 60 will be 1 March. I think this revised code should do it: protected override void OnNavigatedTo(NavigationEventArgs e) { DateTime dt = DateTime.Now; int month = dt.Month; int year = dt.Year; int index; if(DateTime.IsLeapYear(year) || (month { index = dt.DayOfYear - 1; // list is indexed from 0 } else { index = dt.DayOfYear; // add a day } textblock.Text = devotions[index].Message; // or some other property }

Vulpes · Answer

Sorry I've put the type argument in the wrong place a potential hazard when you're writing code 'off the top' :( Instead of: d = JsonConvert .DeserializeObject(json); it should be: d = JsonConvert.DeserializeObject (json);

Vulpes · Answer

It sounds like you may have omitted to declare the Devotion class as public. By default it will be internal if you don't do this and you'll get the exception you're now getting.

Vulpes · Answer

OK what you first need to do here is to define a class into which the JSON can be deserialized: public class Devotion { public string Date {get; set;} public string Title {get; set;} public string Verse {get; set;} [JsonProperty(Read Chapter)] public string ReadChapter {get; set;} [JsonProperty(Read Text)] public string ReadText {get; set;} [JsonProperty(Bible In One Year)] public string BibleInOneYear {get; set;} public string Message {get; set;} public string Notes {get; set;} } Assuming there's one of these objects per file and there are 366 files one for each day of the year (including leap years) you can then do this: private List devotions; public App() { InitializeComponent(); // as this will be expensive to populate // you only want to do it once when the app starts devotions = new List (); AddDevotions(); } protected override void OnNavigatedTo(NavigationEventArgs e) { int index = DateTime.Now.DayOfYear - 1; // list is indexed from 0 textblock.Text = devotions[index].Message; // or some other property } private void AddDevotions() { for(int i = 1; i { string filePath = Assets/Dec + i.ToString() + .js; Devotion d = ReadJsonFile(filePath); devotions.Add(d); } } public Devotion ReadJsonFile(string JsonfilePath) { Devotion d = null; using (StreamReader r = new StreamReader(JsonfilePath)) { string json = r.ReadToEnd(); d = JsonConvert .DeserializeObject(json); } return d; }

Vulpes · Answer

OK I'm clear what you want to do now but what does the JSON file actually look like? Can you post the first few lines please so I can get an idea of how it's going to deserialize.

Vulpes · Answer

What does the file Assets/Dec1.js actually contain? The code suggests that you're trying to deserialize a JSON file to some kind of array but it's not then clear how this should be turned into a string. Also you seem to be calling the ReadJsonFile method repeatedly with the same filepath in the AddDevotions method. So all the elements in your devotions list will be the same.

Vulpes · Answer

Glad to hear it's working now ;) If you just click the Accepted Answer button on my last post  that gives me more points (not that I need them!) but more importantly indicates to anyone else reading the thread with a similar problem that there is an answer here to it.

JOHN JOHNNNY · Answer

Professor vulpes thank you sooooo much i am very grateful All the content of the page shows now. Is there a place apart from the thumb up that i can vote/give you stars? if there is let me know for me to show my appreciation Once again thank you

JOHN JOHNNNY · Answer

Vulpessssssssssssssssss you are the man.....no i mean you are the genius. Finally part of the content in json shows on the emulator But i will still have to ask you According to the json sample i pasted above it is only the message that shows others like date title memorise read chapter and note did not appear on the emulator page How can i make all the content to show kindly help

JOHN JOHNNNY · Answer

I corrected the file path it shows another error below +$exception{Newtonsoft.Json.JsonSerializationException: Cannot deserialize the current JSON array (e.g. [123]) into type 'DevotionJson.Devotion' because the type requires a JSON object (e.g. {name:value}) to deserialize correctly. To fix this error either change the JSON to a JSON object (e.g. {name:value}) or change the deserialized type to an array or a type that implements a collection interface (e.g. ICollection IList) like List that can be deserialized from a JSON array. JsonArrayAttribute can also be added to the type to force it to deserialize from a JSON array. Path '' line 1 position 1. at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.EnsureArrayContract(JsonReader reader Type objectType JsonContract contract) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateList(JsonReader reader Type objectType JsonContract contract JsonProperty member Object existingValue String id) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader Type objectType JsonContract contract JsonProperty member JsonContainerContract containerContract JsonProperty containerMember Object existingValue) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader Type objectType Boolean checkAdditionalContent) at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader Type objectType) at Newtonsoft.Json.JsonSerializer.Deserialize(JsonReader reader Type objectType) at Newtonsoft.Json.JsonConvert.DeserializeObject(String value Type type JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value) at DevotionJson.MainPage.ReadJsonFile(String JsonfilePath) at DevotionJson.MainPage.AddDevotions() at DevotionJson.MainPage..ctor()}System.Exception {Newtonsoft.Json.JsonSerializationException} What is the solution to this

JOHN JOHNNNY · Answer

I will try it and get back to you..........God bless you imensly for your help

JOHN JOHNNNY · Answer

I ran the build it was fine but when i try to test in the emulator it throws an excetion stating this An exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.ni.dll but was not handled in user code what does this mean Sorry for bothering you

JOHN JOHNNNY · Answer

Hi Vulpes Yes i omitted it and i have included it by making it public but when i ran the build it shows the following error Error 1 The non-generic type 'Newtonsoft.Json.JsonConvert' cannot be used with type arguments What does this mean kindly help Thank you and reply soon

JOHN JOHNNNY · Answer

Hi Vulpes Thank you for the piece of code and going through all the stress i am very grateful. After following your procedure and i ran the build it shows the following error Inconsistent accessibility: return type 'DevotionJson.Devotion' is less accessible than method 'DevotionJson.MainPage.ReadJsonFile(string)'  Kindly help and reply soon

JOHN JOHNNNY · Answer

Ok this is a sample below [ { Date:Tuesday December 1 Title:OVERCOMING BY PRAYER Memorise:And when he was at the place he said unto them Pray that ye enter not into temptation. Verse:Luke 22:40 Read Chapter:Luke 22:39-41 Read Text:39 And he came out and went as he was wont to the mount of Olives; and his disciples also followed him. 
40 And when he was at the place he said unto them Pray that ye enter not into temptation. 
41 And he was withdrawn from them about a stone's cast and kneeled down and prayed  Bible In One Year:Psalm 57-63; Hebrews 6:13-7:10 Message:The moment you gave your life to Jesus Christ a battle line was drawn between you and the kingdom of darkness. Unhappy that he has lost you to God?s kingdom Satan?s main goal is to secure your return to his kingdom. One major tool he tries to use in accomplishing this mission is temptation. The devil and his agents will bring temptations your way to make you to do things that would break your relationship with God. This is where prayer comes in. Prayer is one veritable tool that prevents you from falling into Satan?s traps. This is why Jesus urged His disciples at the Garden of Gethsemane to pray. Luke 22:40 says:
?And when he was at the place he said unto them Pray that ye enter not into temptation.?
When you pray the strength to overcome temptations is released to you. A Christian who fails to pray will sooner or later become a victim of the tempter. The extent to which you will overcome temptations is determined by how robust your prayer life is. If you have been rising and falling so often check your prayer life and the way you study God?s word. If you can improve on both you will experience more stability in your faith.

One of the modus operandi of Satan is to show you dazzling sights that could tempt you to follow him. In other words he presents an object of temptation in a bright and attractive way; repainting an evil thing in brilliant and attractive colours. For instance a prostitute is labelled a commercial sex worker in order to support the excuse that he or she is simply trying to earn a living whereas the essence of prostitution is fornication and adultery. In tempting people the devil and his agents make sin look attractive and inviting almost with an air of irresistibility. Prayer deadens these illusions by painting sin in its real colours. Every time you pray over an object of temptation it becomes less inviting and less attractive. As you pray the desire to sin is brought under subjection. Through prayer we obtain grace to walk in the reality of the truth that our flesh has been crucified (Galatians 5:24). Prayer strengthens our spirit man and keeps the flesh where it belongs: crucified and dead on the cross of Calvary (Romans 6:6). It connects your spirit with the Holy Spirit and separates you from the devil by moving your focus towards Heaven and away from the allure of the world. How prayerful are you? No believer in Christ can triumph without using the weapon of prayer. Notes:Prayer Point:
Father please give me the grace to pray like Jesus prayed while on earth. } ]

JOHN JOHNNNY · Answer

Hi Vulpes Let me tell you what i wanted to acheive. I am developing a daily devotional that has different devotion for each day. Instead of hard coding it i.e copy pasting for each day in the code i want to store everything in json file in my project folder and refference it to appear in the textblock. Kiindly help this is my code without json reader or stream reader and how am i going to add json file into this code below xaml xaml xaml.cs protected override void OnNavigatedTo(NavigationEventArgs e) { AddDevotions(); int index = DateTime.Now.DayOfYear; textblock.Text = devotions[index]; } List devotions = new List (); private void AddDevotions() { devotions.Add(4 Faith works miracles); devotions.Add(5 Faith works miracles); devotions.Add(6 Faith works miracles); devotions.Add(7 Faith works miracles); devotions.Add(8 Faith works miracles); } Thank you in advance and reply soon