public static void AddSkrbnik(Skrbnik s)
{
using (var db = DbConnection)
{
db.Insert(s);
}
}
public static void UpdateSkrbnik(Skrbnik s)
{
using (var db = DbConnection)
{
Skrbnik query = db.Table <Skrbnik>().FirstOrDefault(x => x.TelStevilka == s.TelStevilka);
if (query != null)
{
AddSkrbnik(s);
db.Delete <Skrbnik>(query.Id);
}
}
}
/// <summary>
/// Invoked when the application is launched normally by the end user. Other entry points
/// will be used such as when the application is launched to open a specific file.
/// </summary>
/// <param name="e">Details about the launch request and process.</param>
async protected override void OnLaunched(LaunchActivatedEventArgs e)
{
Baza b = new Baza();
if (b.CreateDb())
{
Skrbnik s1 = new Skrbnik("Ime", "Priimek", "031111222", 1234);
// ZapolniBazo();
var localSettings = Windows.Storage.ApplicationData.Current.LocalSettings;
localSettings.Values["DefaultMelodie"] = defaultMelodie;
Baza.AddSkrbnik(s1);
}
else
{
Windows.Storage.StorageFolder storageFolder = Windows.Storage.ApplicationData.Current.LocalFolder;
try
{
Windows.Storage.StorageFile novo = await storageFolder.GetFileAsync("SQLITEV3.sqlite");
Windows.Storage.StorageFile staro = await storageFolder.GetFileAsync("SQLITEV2.sqlite");
if (novo != null)
{
await staro.DeleteAsync();
await novo.RenameAsync("SQLITEV2.sqlite");
}
}
catch (Exception)
{
}
await UploadDB();
}
#if DEBUG
if (System.Diagnostics.Debugger.IsAttached)
{
this.DebugSettings.EnableFrameRateCounter = true;
}
#endif
Frame rootFrame = Window.Current.Content as Frame;
// Do not repeat app initialization when the Window already has content,
// just ensure that the window is active
if (rootFrame == null)
{
// Create a Frame to act as the navigation context and navigate to the first page
rootFrame = new Frame();
rootFrame.NavigationFailed += OnNavigationFailed;
rootFrame.Navigated += OnNavigated;
if (e.PreviousExecutionState == ApplicationExecutionState.Terminated)
{
//TODO: Load state from previously suspended application
}
// Place the frame in the current Window
Window.Current.Content = rootFrame;
SystemNavigationManager.GetForCurrentView().BackRequested += OnBackRequested;
SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility =
rootFrame.CanGoBack ?
AppViewBackButtonVisibility.Visible :
AppViewBackButtonVisibility.Collapsed;
}
if (rootFrame.Content == null)
{
// When the navigation stack isn't restored navigate to the first page,
// configuring the new page by passing required information as a navigation
// parameter
rootFrame.Navigate(typeof(MainPage), e.Arguments);
}
// Ensure the current window is active
Window.Current.Activate();
}
/// <summary>
/// Invoked when the application is launched normally by the end user. Other entry points
/// will be used such as when the application is launched to open a specific file.
/// </summary>
/// <param name="e">Details about the launch request and process.</param>
async protected override void OnLaunched(LaunchActivatedEventArgs e)
{
Baza b = new Baza();
if (b.CreateDb())
{
Skrbnik s1 = new Skrbnik("Ime", "Priimek", "031111222", 1234);
// ZapolniBazo();
var localSettings = Windows.Storage.ApplicationData.Current.LocalSettings;
localSettings.Values["DefaultMelodie"] = defaultMelodie;
Baza.AddSkrbnik(s1);
}
else
{
Windows.Storage.StorageFolder storageFolder = Windows.Storage.ApplicationData.Current.LocalFolder;
try
{
Windows.Storage.StorageFile novo = await storageFolder.GetFileAsync("SQLITEV3.sqlite");
Windows.Storage.StorageFile staro = await storageFolder.GetFileAsync("SQLITEV2.sqlite");
if (novo != null)
{
await staro.DeleteAsync();
await novo.RenameAsync("SQLITEV2.sqlite");
}
}
catch (Exception)
{
}
await UploadDB();
}
#if DEBUG
if (System.Diagnostics.Debugger.IsAttached)
{
this.DebugSettings.EnableFrameRateCounter = true;
}
#endif
Frame rootFrame = Window.Current.Content as Frame;
// Do not repeat app initialization when the Window already has content,
// just ensure that the window is active
if (rootFrame == null)
{
// Create a Frame to act as the navigation context and navigate to the first page
rootFrame = new Frame();
rootFrame.NavigationFailed += OnNavigationFailed;
rootFrame.Navigated += OnNavigated;
if (e.PreviousExecutionState == ApplicationExecutionState.Terminated)
{
//TODO: Load state from previously suspended application
}
// Place the frame in the current Window
Window.Current.Content = rootFrame;
SystemNavigationManager.GetForCurrentView().BackRequested += OnBackRequested;
SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility =
rootFrame.CanGoBack ?
AppViewBackButtonVisibility.Visible :
AppViewBackButtonVisibility.Collapsed;
}
if (rootFrame.Content == null)
{
// When the navigation stack isn't restored navigate to the first page,
// configuring the new page by passing required information as a navigation
// parameter
rootFrame.Navigate(typeof(MainPage), e.Arguments);
}
// Ensure the current window is active
Window.Current.Activate();
}
public static void UpdateSkrbnik(Skrbnik s)
{
using (var db = DbConnection)
{
Skrbnik query = db.Table<Skrbnik>().FirstOrDefault(x => x.TelStevilka == s.TelStevilka);
if (query != null)
{
AddSkrbnik(s);
db.Delete<Skrbnik>(query.Id);
}
}
}
public static void AddSkrbnik(Skrbnik s)
{
using (var db = DbConnection)
{
db.Insert(s);
}
}