public void GetSeries()
{
ObservableCollection<MySerie> a = new ObservableCollection<MySerie>();
using(MySerieDataContext SeriesDB=new MySerieDataContext(MySerieDataContext.DBConnectionString))
{
var query = from c in SeriesDB.MySeries select c;
MySeries = new ObservableCollection<MySerie>(query);
}
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
using(MySerieDataContext context=new MySerieDataContext(MySerieDataContext.DBConnectionString))
{
MySerie serie = new MySerie();
serie.title = txtTitle.Text;
context.MySeries.InsertOnSubmit(serie);
context.SubmitChanges();
}
NavigationService.Navigate(new Uri("/PivotPage1.xaml",UriKind.Relative));
}
public void Delete(MySerie s)
{
MySeries.Remove(s);
using (MySerieDataContext SeriesDB = new MySerieDataContext(MySerieDataContext.DBConnectionString))
{
IQueryable<MySerie> seriequery = from c in SeriesDB.MySeries where c.title == s.title select c;
MySerie ds = seriequery.FirstOrDefault();
SeriesDB.MySeries.DeleteOnSubmit(ds);
SeriesDB.SubmitChanges();
}
}
/// <summary>
/// Constructor for the Application object.
/// </summary>
public App()
{
// Global handler for uncaught exceptions.
UnhandledException += Application_UnhandledException;
// Standard XAML initialization
InitializeComponent();
// Phone-specific initialization
InitializePhoneApplication();
// Language display initialization
InitializeLanguage();
// Show graphics profiling information while debugging.
if (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;
// Prevent the screen from turning off while under the debugger by disabling
// the application's idle detection.
// 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;
}
// Create the database if it does not exist.
using (MySerieDataContext db = new MySerieDataContext(MySerieDataContext.DBConnectionString))
{
if (db.DatabaseExists() == false)
{
//Create the database
db.CreateDatabase();
}
}
}