// Add a to-do item to the database and collections.
public void AddToDoItem(ToDoItem newToDoItem)
{
// Add a to-do item to the data context.
toDoDB.Items.InsertOnSubmit(newToDoItem);
// Save changes to the database.
toDoDB.SubmitChanges();
// Add a to-do item to the "all" observable collection.
AllToDoItems.Add(newToDoItem);
// Add a to-do item to the appropriate filtered collection.
switch (newToDoItem.Category.Name)
{
case "Home":
HomeToDoItems.Add(newToDoItem);
break;
case "Work":
WorkToDoItems.Add(newToDoItem);
break;
case "Hobbies":
HobbiesToDoItems.Add(newToDoItem);
break;
default:
break;
}
}
// Add a to-do item to the database and collections.
public void AddToDoItem(ToDoItem newToDoItem, string group)
{
// Add a to-do item to the data context.
toDoDBContext.Items.InsertOnSubmit(newToDoItem);
// Save changes to the database.
toDoDBContext.SubmitChanges();
if (group == null)
{
return;
}
if (group.Equals(CreateItemControl.TOMORROW))
{
TomorrowToDoItems.Insert(0, newToDoItem);
}
else if (group.Equals(CreateItemControl.LATER))
{
LaterToDoItems.Insert(0, newToDoItem);
}
else // add to today as default
{
// Add a to-do item to the "all" observable collection.
TodayToDoItems.Insert(0, newToDoItem);
}
}
private void btnaddcat_Click(object sender, RoutedEventArgs e)
{
using (ToDoDataContext db = new ToDoDataContext(DBConnectionString))
{
if (db.DatabaseExists() == true)
{
// Create the local database.
// db.CreateDatabase();
//MessageBox.Show("EXISTs");
// Prepopulate the categories.
if (newcatname.Text.Length > 0)
{
db.Categories.InsertOnSubmit(new ToDoCategory {
Name = newcatname.Text
});
// Save categories to the database.
db.SubmitChanges();
App.ViewModel.LoadCatonNavigation();
}
else
{
MessageBox.Show("Name field is empty.");
}
// Create the ViewModel object.
// viewModel = new ToDoViewModel(DBConnectionString);
// Query the local database and load observable collections.
//viewModel.LoadCollectionsFromDatabase();
}
}
// Return to the main page.
if (NavigationService.CanGoBack)
{
NavigationService.GoBack();
}
}
/// <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;
}
// Specify the local database connection string.
//string DBConnectionString = "Data Source=isostore:/ToDo.sdf";
//ToDoDataContext db = new ToDoDataContext(DBConnectionString);
ToDoDataContext db = new ToDoDataContext();
if (db.DatabaseExists() == false)
{
ToDoCategory homeCat = new ToDoCategory {
Name = "Home"
};
ToDoCategory workCat = new ToDoCategory {
Name = "Work"
};
ToDoCategory hobbiesCat = new ToDoCategory {
Name = "Hobbies"
};
db.CreateDatabase();
db.Categories.InsertOnSubmit(homeCat);
db.Categories.InsertOnSubmit(workCat);
db.Categories.InsertOnSubmit(hobbiesCat);
db.SubmitChanges();
db.Items.InsertOnSubmit(new ToDoItem {
ItemName = "Finish App", Category = hobbiesCat
});
db.Items.InsertOnSubmit(new ToDoItem {
ItemName = "Teste 1", Category = hobbiesCat
});
db.Items.InsertOnSubmit(new ToDoItem {
ItemName = "Teste 2", Category = homeCat
});
db.Items.InsertOnSubmit(new ToDoItem {
ItemName = "Teste 3", Category = workCat
});
db.Items.InsertOnSubmit(new ToDoItem {
ItemName = "Teste 4", Category = homeCat
});
db.Items.InsertOnSubmit(new ToDoItem {
ItemName = "Teste 5", Category = workCat
});
db.SubmitChanges();
}
ToDoItemDataService itemDataService = new ToDoItemDataService(db);
//PhoneApplicationFrame phoneApplicationFrame = Application.Current.RootVisual as PhoneApplicationFrame;
//AppNavigationService navigationService = new AppNavigationService(phoneApplicationFrame);
AllItemsViewModel = new AllToDoItemsViewModel(itemDataService);
NewItemViewModel = new NewToDoItemViewModel(itemDataService);
}
// Write changes in the data context to the database.
public void SaveChangesToDB()
{
toDoDB.SubmitChanges();
}
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;
}
// Specify the local database connection string.
string DBConnectionString = "Data Source=isostore:/ToDo.sdf";
// Create the database if it does not exist.
using (ToDoDataContext db = new ToDoDataContext(DBConnectionString))
{
if (db.DatabaseExists() == false)
{
// Create the local database.
db.CreateDatabase();
// Prepopulate the categories.
db.Categories.InsertOnSubmit(new ToDoCategory {
Name = "Home"
});
db.Categories.InsertOnSubmit(new ToDoCategory {
Name = "Work"
});
db.Categories.InsertOnSubmit(new ToDoCategory {
Name = "Hobbies"
});
// Save categories to the database.
db.SubmitChanges();
}
}
// Create the ViewModel object.
viewModel = new ToDoViewModel(DBConnectionString);
// Query the local database and load observable collections.
viewModel.LoadCollectionsFromDatabase();
}
/// <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;
}
// Specify the local database connection string.
string DBConnectionString = "Data Source=isostore:/ToDo.sdf";
// Create the database if it does not exist.
using (ToDoDataContext db = new ToDoDataContext(DBConnectionString))
{
if (db.DatabaseExists() == false)
{
// Create the local database.
db.CreateDatabase();
// Prepopulate the categories.
db.Categories.InsertOnSubmit(new ToDoCategory {
Name = "Vegetables"
});
db.Categories.InsertOnSubmit(new ToDoCategory {
Name = "Fish"
});
db.Categories.InsertOnSubmit(new ToDoCategory {
Name = "Medicine"
});
// Save categories to the database.
db.SubmitChanges();
//vegetables
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 1, ItemName = "Asparagus"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 1, ItemName = "Onion"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 1, ItemName = "Potato"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 1, ItemName = "Carrot"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 1, ItemName = "Tomato"
});
//fish
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 2, ItemName = "Common carp"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 2, ItemName = "Silver carp"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 2, ItemName = "Grass carp"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 2, ItemName = "Hilsa shad"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 2, ItemName = "Catla"
});
//medecine
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 3, ItemName = "Paracetamol"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 3, ItemName = "Ranitidine"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 3, ItemName = "Loratadine"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 3, ItemName = "Aceclofenac"
});
db.Items.InsertOnSubmit(new ToDoItem {
_categoryId = 3, ItemName = "Ciprofloxacin"
});
db.SubmitChanges();
}
}
// Create the ViewModel object.
viewModel = new ToDoViewModel(DBConnectionString);
// Query the local database and load observable collections.
viewModel.LoadCollectionsFromDatabase();
}
public App()
{
// Global handler for uncaught exceptions.
UnhandledException += Application_UnhandledException;
// Standard Silverlight initialization
InitializeComponent();
// 特定于电话的初始化
InitializePhoneApplication();
setting abc = new setting();
switch (abc.ListBoxSetting)
{
case 0:
System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("zh-CN");
txtnote.Resources.StringLibrary.Culture = ci;
break;
case 1:
System.Globalization.CultureInfo en = new System.Globalization.CultureInfo("en-US");
txtnote.Resources.StringLibrary.Culture = en;
break;
case 2:
System.Globalization.CultureInfo ciJA = new System.Globalization.CultureInfo("ja");
txtnote.Resources.StringLibrary.Culture = ciJA;
break;
default:
break;
}
// 调试时显示图形分析信息。
if (System.Diagnostics.Debugger.IsAttached)
{
// 显示当前帧速率计数器。
Application.Current.Host.Settings.EnableFrameRateCounter = true;
// 显示在每个帧中重绘的应用程序区域。
//Application.Current.Host.Settings.EnableRedrawRegions = true；
// Enable non-production analysis visualization mode,
// 该模式显示递交给 GPU 的包含彩色重叠区的页面区域。
//Application.Current.Host.Settings.EnableCacheVisualization = true；
// Disable the application idle detection by setting the UserIdleDetectionMode property of the
// application's PhoneApplicationService object to Disabled.
// 注意: 仅在调试模式下使用此设置。禁用用户空闲检测的应用程序在用户不使用电话时将继续运行
// 并且消耗电池电量。
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
}
// Specify the local database connection string.
string DBConnectionString = "Data Source=isostore:/ToDo.sdf";
// Create the database if it does not exist.
using (ToDoDataContext db = new ToDoDataContext(DBConnectionString))
{
if (db.DatabaseExists() == false)
{
// Create the local database.
db.CreateDatabase();
// Prepopulate the categories.
db.Categories.InsertOnSubmit(new ToDoCategory {
Name = txtnote.Resources.StringLibrary.richang
});
db.Categories.InsertOnSubmit(new ToDoCategory {
Name = txtnote.Resources.StringLibrary.gongzuo
});
db.Categories.InsertOnSubmit(new ToDoCategory {
Name = txtnote.Resources.StringLibrary.xingqu
});
// Save categories to the database.
db.SubmitChanges();
}
}
// Create the ViewModel object.
viewModel = new ToDoViewModel(DBConnectionString);
// Query the local database and load observable collections.
viewModel.LoadCollectionsFromDatabase();
}
public void InsertToDoItem(ToDoItem newToDoItem)
{
_context.Items.InsertOnSubmit(newToDoItem);
_context.SubmitChanges();
}
public void SaveChangesToDb()
{
toDoDb.SubmitChanges();
}
public void InsertToDoItem(ToDoItem item)
{
db.ToDoItems.InsertOnSubmit(item);
_toDoItems.Add(item);
db.SubmitChanges();
}