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