public bool GetSchool()
{
bool bReturn = false;
sqlite_cmd = new SQLiteCommand("Select * from ProgramConfig where id = 1", sqlite_conn);
// Now the SQLiteCommand object can give us a DataReader-Object:
sqlite_datareader = sqlite_cmd.ExecuteReader();
// The SQLiteDataReader allows us to run through the result lines:
while (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read
{
Console.WriteLine(sqlite_datareader["sLatitude"].ToString());
school = new School(sqlite_datareader["sPassword"].ToString(), sqlite_datareader["sEmail"].ToString(), sqlite_datareader["sSchoolName"].ToString(),
sqlite_datareader["sAddress"].ToString(), sqlite_datareader["sCity"].ToString(), sqlite_datareader["sState"].ToString(), sqlite_datareader["sZip"].ToString(),
sqlite_datareader["sLatitude"].ToString(), sqlite_datareader["sLongitude"].ToString(), sqlite_datareader["sImageFile"].ToString());
try
{
string sExistingDatabaseVersion = sqlite_datareader["sDatabaseVersion"].ToString();
if(OldDBVersion(sExistingDatabaseVersion,DatabaseVersion))
{
UpgradeDB(sExistingDatabaseVersion, DatabaseVersion);
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
Console.WriteLine("No database version available. Need to upgrade to DB Version 1.0 after backing things up.");
}
bReturn = true;
}
return bReturn;
}
public frmMain()
{
SoftwareVersion = "1.1";
DatabaseVersion = "1.0";
school = new School();
InitDatabase();
InitializeComponent();
//Used for when a person wants to remain logged in.
bStayAdmin = false;
GetSchool();
cReports = new Reports(this);
this.Icon = System.Drawing.Icon.ExtractAssociatedIcon(Application.ExecutablePath);
lblSchool.Text = String.Format("Welcome to {0}", school.name);
pbLeft.ImageLocation = school.ImageFile;
pbRight.ImageLocation = school.ImageFile;
menuDatabaseVersion.Text = "Database Version : " + DatabaseVersion;
menuSoftwareVersion.Text = "Software Version : " + SoftwareVersion;
}