public void InsertData()
{
// string path = await FileUtils.CreateDefaultFolder();//await Windows.Storage.ApplicationData.Current.LocalFolder.CreateFolderAsync("PortoSchool", CreationCollisionOption.OpenIfExists);
//path = Path.Combine(path, "settings.sqlite");
// bool a1 = comboBoxNobetAlan.SelectedItem == null;
// bool a3=comboBoxNobetGunu.sele
//if (a1) return;
bool a2 = string.IsNullOrWhiteSpace(textBoxNobOgrAdSoyad.Text.Trim());
if (a2)
{
return;
}
SQLiteConnection conn = new SQLiteConnection(new SQLitePlatformWinRT(), FileUtils.FullDataPath);
SentryLocationDataset nobalan = new SentryLocationDataset
{
SentryLocation = (comboBoxNobetAlan.SelectedItem as SentryLocationDataset).SentryLocation ?? ""
};
string nobetGunu = (string)comboBoxNobetGunu.SelectedItem ?? "";
conn.Insert(new Models.SentinelsDataset {
SentryLocation = nobalan.SentryLocation, SentinelFullName = textBoxNobOgrAdSoyad.Text, SentryDate = nobetGunu
});
//listViewNobetAlanlari.ItemsSource = NobetAlanManager.GetNobetAlanlari();
}
private async Task UpdateNobAlanIfXLSExistsAsync()
{
var res_SentryLocationFN = LocalizationUtils.ResourceValueByKey("SENTRYLOCATION_xlsx");
var res_SENTRYLOCATION_xlsx_SENTRYLOCATION_TITLE = LocalizationUtils.ResourceValueByKey("SENTRYLOCATION_xlsx_SENTRYLOCATION_TITLE");
if (!File.Exists(Path.Combine(App.WorkingPath, $"{res_SentryLocationFN}.xlsx")))
{
return;
}
ExcelReader a = ExcelReader.SharedReader();
List <string> NöbetAlanList = new List <string>();
StorageFile f = await StorageFile.GetFileFromPathAsync(Path.Combine(App.WorkingPath, $"{res_SentryLocationFN}.xlsx"));
List <SheetData> x = await a.ParseSpreadSheetFile(f);
var conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), FileUtils.FullDataPath);
conn.DropTable <SentryLocationDataset>();
conn.CreateTable <SentryLocationDataset>();
foreach (var xx in x)
{
var data = xx.data;
foreach (var dd in data)
{
foreach (var ddc in dd)
{
if (ddc.Key == res_SENTRYLOCATION_xlsx_SENTRYLOCATION_TITLE)
{
NöbetAlanList.Add(ddc.Value.ToUpper());
}
}
}
}
for (int i = 0; i < NöbetAlanList.Count; i++)
{
SentryLocationDataset row = new SentryLocationDataset
{
SentryLocation = NöbetAlanList[i],
};
conn.Insert(row);
}
File.Delete(Path.Combine(App.WorkingPath, $"{res_SentryLocationFN}_OLD.xlsx"));
File.Move(Path.Combine(App.WorkingPath, $"{res_SentryLocationFN}.xlsx"), Path.Combine(App.WorkingPath, $"{res_SentryLocationFN}_OLD.xlsx"));
}