// Constructor, currently fetches all current data every time ... later may try to cache some in Session etc. public HumansController() { config = new cConfig(); gcs = config.GetConnectionString(); SqlConnection db_conn; SqlCommand db_cmd = new SqlCommand(); SqlDataAdapter db_adapter; ds = new DataSet(); humans = new List <Human>(); try { String cs = gcs; db_conn = new SqlConnection(cs); db_conn.Open(); db_cmd.Connection = db_conn; db_cmd.CommandType = CommandType.StoredProcedure; db_cmd.CommandText = "[Humans].[GetAllHumanData]"; db_cmd.Parameters.Clear(); db_adapter = new SqlDataAdapter(db_cmd); db_adapter.TableMappings.Clear(); db_adapter.TableMappings.Add("Table", "Humans"); db_adapter.TableMappings.Add("Table1", "Children"); db_adapter.Fill(ds); } catch (Exception theError) { throw new Exception("DB Lookup failed", theError); } int theCount = ds.Tables["Humans"].Rows.Count; if (theCount != 0) { int ndx, lastNdx; lastNdx = theCount - 1; for (ndx = 0; ndx <= lastNdx; ndx++) { humans.Add(buildHumanObjectFromData(ndx)); } } }
public void LoadConfig() { if (!File.Exists("config.json")) { NewConfig(); } else { try { Config = JsonConvert.DeserializeObject <cConfig>(File.ReadAllText("config.json")); } catch { NewConfig(); } } if (Config == null || Config.MaxItens > 10) { NewConfig(); } }
public void NewConfig() { Config = new cConfig(); File.WriteAllText("config.json", JsonConvert.SerializeObject(Config)); }