public static void MakeDB()
{
using (ScoreDB newDB = new ScoreDB("Data Source=isostore:/Sample.sdf"))
{
if (!newDB.DatabaseExists())
{
newDB.CreateDatabase();
}
}
}
public void addScore(String nick, double score)
{
using (ScoreDB newDB = new ScoreDB("Data Source=isostore:/Sample.sdf"))
{
Storage newScore = new Storage();
newScore.Nick = nick;
newScore.Score = Convert.ToInt32(score);
newScore.Date = DateTime.Now;
newDB.ScoresTable.InsertOnSubmit(newScore);
newDB.SubmitChanges();
}
}
public List <Storage> getScores()
{
using (ScoreDB newDB = new ScoreDB("Data Source=isostore:/Sample.sdf"))
{
var allScores = from Storage storage
in newDB.ScoresTable
select storage;
List <Storage> scoresList = allScores.ToList <Storage>();
App thisApp = Application.Current as App;
scoresList.Sort(sortByScores);
return(scoresList);
}
}
/// <summary>
/// Constructor for the Application object.
/// </summary>
public App()
{
setData = new SettingsData();
// Global handler for uncaught exceptions.
UnhandledException += Application_UnhandledException;
// Standard Silverlight initialization
InitializeComponent();
// Phone-specific initialization
InitializePhoneApplication();
// Show graphics profiling information while debugging.
if (System.Diagnostics.Debugger.IsAttached)
{
// Display the current frame rate counters.
//Application.Current.Host.Settings.EnableFrameRateCounter = true;
// Show the areas of the app that are being redrawn in each frame.
//Application.Current.Host.Settings.EnableRedrawRegions = true;
// Enable non-production analysis visualization mode,
// which shows areas of a page that are handed off to GPU with a colored overlay.
//Application.Current.Host.Settings.EnableCacheVisualization = true;
// Disable the application idle detection by setting the UserIdleDetectionMode property of the
// application's PhoneApplicationService object to Disabled.
// Caution:- Use this under debug mode only. Application that disables user idle detection will continue to run
// and consume battery power when the user is not using the phone.
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
}
ScoreDB.MakeDB();
ActiveDB = new ScoreDB("Data Source=isostore:/Sample.sdf");
}
/// <summary>
/// Constructor for the Application object.
/// </summary>
public App()
{
setData = new SettingsData();
// Global handler for uncaught exceptions.
UnhandledException += Application_UnhandledException;
// Standard Silverlight initialization
InitializeComponent();
// Phone-specific initialization
InitializePhoneApplication();
// Show graphics profiling information while debugging.
if (System.Diagnostics.Debugger.IsAttached)
{
// Display the current frame rate counters.
//Application.Current.Host.Settings.EnableFrameRateCounter = true;
// Show the areas of the app that are being redrawn in each frame.
//Application.Current.Host.Settings.EnableRedrawRegions = true;
// Enable non-production analysis visualization mode,
// which shows areas of a page that are handed off to GPU with a colored overlay.
//Application.Current.Host.Settings.EnableCacheVisualization = true;
// Disable the application idle detection by setting the UserIdleDetectionMode property of the
// application's PhoneApplicationService object to Disabled.
// Caution:- Use this under debug mode only. Application that disables user idle detection will continue to run
// and consume battery power when the user is not using the phone.
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
}
ScoreDB.MakeDB();
ActiveDB = new ScoreDB("Data Source=isostore:/Sample.sdf");
}
public List<Storage> getScores()
{
using (ScoreDB newDB = new ScoreDB("Data Source=isostore:/Sample.sdf"))
{
var allScores = from Storage storage
in newDB.ScoresTable
select storage;
List<Storage> scoresList = allScores.ToList<Storage>();
App thisApp = Application.Current as App;
scoresList.Sort(sortByScores);
return scoresList;
}
}
public void addScore(String nick, double score)
{
using (ScoreDB newDB = new ScoreDB("Data Source=isostore:/Sample.sdf"))
{
Storage newScore = new Storage();
newScore.Nick = nick;
newScore.Score = Convert.ToInt32(score);
newScore.Date = DateTime.Now;
newDB.ScoresTable.InsertOnSubmit(newScore);
newDB.SubmitChanges();
}
}
public static void MakeDB()
{
using (ScoreDB newDB = new ScoreDB("Data Source=isostore:/Sample.sdf"))
{
if (!newDB.DatabaseExists())
{
newDB.CreateDatabase();
}
}
}