Help with JSON file reading

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.

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

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?

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

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:

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

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);

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.

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

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 <= 366; 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; 
}

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. \n40  And when he was at the place, he said unto them, Pray that ye enter not into temptation. \n41  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:\n?And when he was at the place, he said unto them, Pray that ye enter not into temptation.?\nWhen 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.\n\nOne 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:\nFather, please give me the grace to pray like Jesus prayed while on earth."
  },
]

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.

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










 

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.