private void LoadUsers()
{
using (var db = new Model.UserDataContext(Model.UserDataContext.connString))
{
var users = from Model.User u in db.Users select u;
userList.ItemsSource = users;
userList.DisplayMemberPath = "FullName";
}
}
protected override void OnNavigatedTo(System.Windows.Navigation.NavigationEventArgs e)
{
base.OnNavigatedTo(e);
using (
var db = new Model.UserDataContext(Model.UserDataContext.connString))
{
var users = from Model.User u in db.Users select u;
userList.ItemsSource = users;
userList.DisplayMemberPath = "FullName";
}
}
private void userList_Tap(object sender, GestureEventArgs e)
{
if (e.OriginalSource is TextBlock)
{
Model.User u = userList.SelectedItem as Model.User;
using (var db = new Model.UserDataContext(Model.UserDataContext.connString))
{
db.Users.Attach(u);
db.Users.DeleteOnSubmit(u);
db.SubmitChanges();
}
status.Text = string.Concat(u.FullName, " deleted");
}
LoadUsers();
}
private void addUser_Click(object sender, RoutedEventArgs e)
{
Model.User u = new Model.User
{
FirstName = firstName.Text,
LastName = lastName.Text,
CreatedOn = DateTime.Now
};
using (var db = new Model.UserDataContext(Model.UserDataContext.connString))
{
db.Users.InsertOnSubmit(u);
db.SubmitChanges();
status.Text = string.Concat("User ", u.FullName, " added");
firstName.Text = "";
lastName.Text = "";
}
}
/// <summary>
/// Constructor for the Application object.
/// </summary>
public App()
{
// 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;
}
using (Model.UserDataContext db =
new Model.UserDataContext(Model.UserDataContext.connString))
{
if (!db.DatabaseExists())
{
db.CreateDatabase();
}
}
}
