The Do() method creates a thread and that thread creates the following data for the HMI, So when we start the HMI it generates the data and stores those data in the database.

SQLConnecter class:

This version is different than what we have published in the zip file. The HMI in the zip file always creates 12 items when the HMI is created. In this version, we have adjusted it so that when the HMI starts then it checks if there are any items in the DB file. If it finds something then it uses those items. Otherwise, it will create 3 data items.

Also if the HMI finds the DB file then it does not create a new schema.

    private static ISessionFactory sessionFactory;
    private readonly log4net.ILog log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
    private string data = "";
    private static ISessionFactory SessionFactory {
      get {
        if (sessionFactory == null) CreateSessionFactory();
        return sessionFactory;
      }
    }
    public string MyData {
      get {
        return data;
      }
      set {
        if (data != value) {
          data = value;
        }
      }
    }
    public SQLConnecter() {
      sessionFactory = CreateSessionFactory();
    }
    public void Do() {
      Thread t = new Thread(DoInBackground);
      t.Start();
    }
    public void DoInBackground() {
      try {
        MainFN();
      }
      catch(Exception ex) {}
    }
    private static ISessionFactory CreateSessionFactory() {
      return Fluently.Configure().Database(SQLiteConfiguration.Standard.UsingFile("projectData.db")).Mappings(m =>m.FluentMappings.AddFromAssemblyOf < Data > ()).ExposeConfiguration(BuildSchema).BuildSessionFactory();
    }
    private static void BuildSchema(NHibernate.Cfg.Configuration config) {
      //new SchemaExport(config).Create(true, false);
      if (!File.Exists("projectData.db")) {
        new SchemaExport(config).Create(false, false);
        //new SchemaExport(config).Execute(false, false, false);
      }
    }
    private void MainFN() {
      using(var session = sessionFactory.OpenSession()) {
        using(var transaction = session.BeginTransaction()) {
          List < Data > myDataInstance = (List < Data > ) session.QueryOver < Data > ().List < Data > ();
          if (myDataInstance.Count <= 0) {
            for (int i = 0; i < 3; i++) {
              myDataInstance[i] = new Data();
              myDataInstance[i].Test1 = "Example Data " + (i + 1).ToString();
              myDataInstance[i].Test2 = i + 11;
              myDataInstance[i].Test3 = (i % 2 == 0);
              myDataInstance[i].CurrentTime = DateTime.Now.ToString();
              myDataInstance[i].ComboBox = i % 4;
              myDataInstance.Add(myDataInstance[i]);
              session.SaveOrUpdate(myDataInstance[i]);
            }
          }
          MyData = JsonConvert.SerializeObject(myDataInstance, Formatting.Indented, new JsonSerializerSettings {
            ReferenceLoopHandling = ReferenceLoopHandling.Ignore
          });
          transaction.Commit();
        }
      }
    }
    public void DeleteLine(int index) {
      using(var session = sessionFactory.OpenSession()) {
        using(var transaction = session.BeginTransaction()) {
          List < Data > storesAll = (List < Data > ) session.QueryOver < Data > ().List < Data > ();
          if (storesAll.Count > 0) {
            var sorefromlist = storesAll[index];
            var store = session.Get < Data > (sorefromlist.Id);
            session.Delete(store);
          }
          session.Flush();
          transaction.Commit();
        }
      }
      ReadData();
    }
    public void ReadData() {
      try {
        using(var session = sessionFactory.OpenSession()) {
          using(var transaction = session.BeginTransaction()) {
            var list = session.QueryOver < Data > ().List();
            MyData = JsonConvert.SerializeObject(list, Formatting.Indented, new JsonSerializerSettings {
              ReferenceLoopHandling = ReferenceLoopHandling.Ignore
            });
          }
        }
      }
      catch(Exception) {}
    }
    public void AddItem(string test1, int test2, bool truefalse, int comb) {
      try {
        using(var session = sessionFactory.OpenSession()) {
          using(var transaction = session.BeginTransaction()) {
            List < Data > list = (List < Data > ) session.QueryOver < Data > ().List();
            Data d = new Data();
            d.Test1 = test1;
            d.Test2 = test2;
            d.Test3 = truefalse;
            d.CurrentTime = DateTime.Now.ToString();
            d.ComboBox = comb;
            list.Add(d);
            session.SaveOrUpdate(d);
            session.Flush();
            transaction.Commit();
          }
        }
      }
      catch(Exception) {}
      ReadData();
    }