public static RegDatabase LoadLocal() { regDb = new RegDatabase(); if (File.Exists(fileName)) { XmlSerializer xml = new XmlSerializer(regDb.GetType()); TextReader rdr = new StreamReader(fileName); regDb = (RegDatabase)xml.Deserialize(rdr); log.InfoFormat("Data loaded from local file:{0}", fileName); } else { log.Info("Could not load from local, file does not exist"); } return(regDb); }
public static RegDatabase LoadDatabase() { regDb = new RegDatabase(); MySqlConnectionStringBuilder conn_string = new MySqlConnectionStringBuilder(); conn_string.Server = "enki"; //conn_string.Server = "rowantree.org"; conn_string.UserID = "rowan_RosReg"; conn_string.Password = "******"; conn_string.Database = "rowan_RitesRegistration"; //conn_string.SslMode = MySqlSslMode.Required; log.InfoFormat("Loading data from MySql Server:{0} ", conn_string.Server); using (MySqlConnection conn = new MySqlConnection(conn_string.ToString())) { conn.Open(); using (MySqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "SELECT (SELECT count(*) FROM registration) RegCnt, (SELECT count(*) FROM person) PeopleCnt"; using (MySqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { regDb.RegCount = rdr.GetInt32(0); regDb.PersonCount = rdr.GetInt32(1); } } } using (MySqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "SELECT * FROM registration"; using (MySqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { regDb.regData.Add(new Registration(rdr)); } } } using (MySqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "SELECT * FROM person"; using (MySqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { Person person = new Person(rdr); regDb.personData.Add(person); Registration reg = regDb.regData.FirstOrDefault(x => x.RegId == person.regID); reg.personList.Add(person); //regDb.regData.First(x => x.RegId == person.regID).personList.Add(person); } } } using (MySqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "SELECT * FROM merchant"; using (MySqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { Merchant merchant = new Merchant(rdr); regDb.merchantData.Add(merchant); Registration reg = regDb.regData.FirstOrDefault(x => x.RegId == merchant.regID); if (reg != null) { reg.merchantInfo = merchant; } else { // this is an error } } } } } log.InfoFormat("Loaded {0} Registration {1} Person {2} Merchant Records", regDb.regData.Count, regDb.personData.Count, regDb.merchantData.Count); return(regDb); }