private async void btnCopyCouseTableToSharedFolder_Click(object sender, RoutedEventArgs e)
{
var COURSETABLE_xlsx = LocalizationUtils.ResourceValueByKey("COURSETABLE/xlsx");
StorageFile file = await StorageFile.GetFileFromApplicationUriAsync(new Uri("ms-appx:///Assets/" + COURSETABLE_xlsx));
StorageFolder storageFolder = await StorageFolder.GetFolderFromPathAsync(Settings.LocalDataFolder);
await file.CopyAsync(storageFolder, COURSETABLE_xlsx);
}
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"));
}
private async Task UpdateNobOgrIfXLSExistsAsync()
{
string res_SentinelsFN = LocalizationUtils.ResourceValueByKey("SENTINELS_xlsx");//determine whether file is SENTINELS.xlsx or NOBETCILER.xlsx etc.
if (!File.Exists(Path.Combine(App.WorkingPath, $"{res_SentinelsFN}.xlsx")))
{
return;
}
string res_SentinelFullNameTitle = LocalizationUtils.ResourceValueByKey("SENTINELS_xlsx_SENTINELFULLNAME_TITLE");
string res_SentryDateTitle = LocalizationUtils.ResourceValueByKey("SENTINELS_xlsx_SENTRYDATE_TITLE");
string res_SentryLocationTitle = LocalizationUtils.ResourceValueByKey("SENTINELS_xlsx_SENTRYLOCATION_TITLE");
ExcelReader a = ExcelReader.SharedReader();
List <string> ÖğretmenAdıSoyadıList = new List <string>();
List <string> NöbetGünüList = new List <string>();
List <string> NöbetAlanList = new List <string>();
StorageFile f = await StorageFile.GetFileFromPathAsync(Path.Combine(App.WorkingPath, $"{res_SentinelsFN}.xlsx"));
List <SheetData> x = await a.ParseSpreadSheetFile(f);
var conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), FileUtils.FullDataPath);
conn.DropTable <SentinelsDataset>();
conn.CreateTable <SentinelsDataset>();
foreach (var xx in x)
{
var data = xx.data;
foreach (var dd in data)
{
foreach (var ddc in dd)
{
if (ddc.Key == res_SentinelFullNameTitle)
{
ÖğretmenAdıSoyadıList.Add(ddc.Value.ToUpper());
}
else
if (ddc.Key == res_SentryDateTitle)
{
NöbetGünüList.Add(ddc.Value.ToUpper());
}
else
if (ddc.Key == res_SentryLocationTitle)
{
NöbetAlanList.Add(ddc.Value.ToUpper());
}
}
}
}
for (int i = 0; i < ÖğretmenAdıSoyadıList.Count; i++)
{
SentinelsDataset row = new SentinelsDataset
{
SentinelFullName = ÖğretmenAdıSoyadıList[i],
SentryDate = NöbetGünüList[i],
SentryLocation = NöbetAlanList[i]
};
conn.Insert(row);
}
File.Delete(Path.Combine(App.WorkingPath, $"{res_SentinelsFN}_OLD.xlsx"));
File.Move(Path.Combine(App.WorkingPath, $"{res_SentinelsFN}.xlsx"), Path.Combine(App.WorkingPath, $"{res_SentinelsFN}_OLD.xlsx"));
}
public static async void ImportDataFromCouseTableXlsx()
{
var COURSETABLE_xlsx = LocalizationUtils.ResourceValueByKey("COURSETABLE/xlsx");
schoolTimeSpans.Clear();
if (!File.Exists(Path.Combine(App.WorkingPath, COURSETABLE_xlsx)))
{
StorageFile file = await StorageFile.GetFileFromApplicationUriAsync(new Uri("ms-appx:///Assets/" + COURSETABLE_xlsx));
StorageFolder storageFolder = await StorageFolder.GetFolderFromPathAsync(Settings.LocalDataFolder);
await file.CopyAsync(storageFolder, COURSETABLE_xlsx);
}
ExcelReader a = ExcelReader.SharedReader();
StorageFile f = await StorageFile.GetFileFromPathAsync(Path.Combine(App.WorkingPath, COURSETABLE_xlsx));
List <SheetData> sheetdatas = await a.ParseSpreadSheetFile(f);
int hours, mins;
int mod4 = 0;
SchoolTimeSpan sts = new SchoolTimeSpan();;
var xx = sheetdatas[0];
var data = xx.data;
var datacount = data.Count;
//foreach (var dd in data)
for (int j = 0; j < datacount; j = j + 1)
{
var dd = data[j];
int ddcount = dd.Count;
for (int i = 0; i < ddcount; i = i + 1)
{
KeyValuePair <string, string> ddc = dd.ElementAt(i);
var splt = ddc.Key.Split('-');
if (splt.Length == 2)
{
if (splt[1] == "TITLE")
{
sts.Day = splt[0];
sts.Title = ddc.Value;
}
if ((splt[1] == "T1") && (!string.IsNullOrEmpty(ddc.Value)))
{
hours = int.Parse(ddc.Value.Split(":")[0]);
mins = int.Parse(ddc.Value.Split(":")[1]);
sts.TimeStart = new TimeSpan(hours, mins, 0);
}
if ((splt[1] == "T2") && (!string.IsNullOrEmpty(ddc.Value)))
{
hours = int.Parse(ddc.Value.Split(":")[0]);
mins = int.Parse(ddc.Value.Split(":")[1]);
sts.TimeEnd = new TimeSpan(hours, mins, 0);
}
}//end of if..
//listView1.Items.Add($"{ddc.Key},{ddc.Value}");
if ((mod4 == 3) && (!string.IsNullOrEmpty(ddc.Value)))
{
schoolTimeSpans.Add(sts);
sts = new SchoolTimeSpan();
}
mod4 = ((mod4 + 1) % 4);
}//end of for..
}
//File.Delete(Path.Combine(App.WorkingPath, "COURSETABLE_OLD.xlsx"));
//File.Move(Path.Combine(App.WorkingPath, "COURSETABLE.xlsx"), Path.Combine(App.WorkingPath, "COURSETABLE_OLD.xlsx"));
}