public static void UpdateAfterLoading(SQL_XML_IOSystem.XML_Element element,short version,bool IsItUpdate)
{
/*
s
witch (element.Name)
{
case Language
case FrequencyDictionary.TableName:
Language lang = EFDbContext.DataBase.Language.Find(Guid.Parse(element.GetAttibute("Language_id")));
lang.FrequencyDictionary = EFDbContext.DataBase.FrequencyDictionary.Find(element.guid);
break;
}
*/
}
public static void UpdateBeforeLoading(SQL_XML_IOSystem.XML_Element element,short version)
{
string value;
switch (element.Name)
{
case Dictionary.TableName:
if (version == Data_Versions.version_1_0)
{
//value = element.GetAttibute("Date");
//value = value.Substring(6,4)+"-"+value.Substring(3,2)+value.Subst
version = Data_Versions.version_1_1;
}
break;
case LearningItem.TableName:
element.Attributes.Add("AppSetting_id",ViewModelLocator.Instance.AppSetting.id.ToString());
break;
}
}
public void CmdDispatcher(string cmd)
{
string filename = "";
//string path = "";
Guid guid;
SQL_XML_IO_statuses res = SQL_XML_IO_statuses.Ok;
SQL_XML_IOSystem SQL_XML_IOSystem = new SQL_XML_IOSystem();
switch (cmd)
{
case "Backup":
case "BackupToFile":
switch (cmd)
{
case "Backup":
filename = path + "\\" + DateTime.Now.ToString("yyyy_MM_dd__HH_mm_ss") + ".xml";
break;
case "BackupToFile":
filename = DialogService.SaveFile("xml (*.xml)|*.xml");
break;
}
if (filename == null) return;
if(BackupCommentary != null && BackupCommentary.Length > 0)
{
filename = filename.Replace(".xml", " " + BackupCommentary + ".xml");
}
switch (Params.mode)
{
case Backup_parameters.Mode.AppSetting:
res = SQL_XML_IOSystem.Save(filename,AppSetting.TableName,Params.appsetting.id);
break;
case Backup_parameters.Mode.LearningItem:
res = SQL_XML_IOSystem.Save(filename, Params.learningitem);
//res = SQL_XML_IOSystem.Save(filename,LearningItem.TableName,Params.learningitem.id);
break;
}
if (res != SQL_XML_IO_statuses.Ok) DialogService.Message(Tx.T("EditLearningItem.Messages.UnknownSaveError"));
if (cmd == "Backup") FindFiles(path);
break;
case "Load":
case "LoadFromFile":
switch (cmd)
{
case "Load":
filename = currentpath;
break;
case "BackupToFile":
filename = DialogService.OpenFile(FileService.GetPathToGlobalBackup(),"xml (*.xml)|*.xml");
break;
}
if (!FileService.FileExists(filename)) return;
switch (Params.mode)
{
case Backup_parameters.Mode.AppSetting:
res = SQL_XML_IOSystem.Load(filename,out guid);
if(res == SQL_XML_IO_statuses.Ok)
{
AppSetting aps = ViewModelLocator.Instance.DataBase.AppSetting.Find(guid);
ViewModelLocator.Instance.AppSetting = aps;
EFDbContext.SaveChgs();
}
break;
case Backup_parameters.Mode.LearningItem:
res = SQL_XML_IOSystem.Load(filename,out guid);
if(res == SQL_XML_IO_statuses.Ok)
{
LearningItem li = ViewModelLocator.Instance.DataBase.LearingItem.Find(guid);
if(!ViewModelLocator.Instance.AppSetting.LearningItems.Contains(li)) ViewModelLocator.Instance.AppSetting.LearningItems.Add(li);
EFDbContext.SaveChgs();
}
break;
}
if (res != SQL_XML_IO_statuses.Ok) DialogService.Message(Tx.T("EditLearningItem.Messages.UnknownSaveError"));
if(res != SQL_XML_IO_statuses.Ok)
{
switch (res)
{
case SQL_XML_IO_statuses.GUIDdoestMatches:
DialogService.Message(Tx.T("EditLearningItem.Messages.GuidDoesntMatches"));
break;
default:
throw new NotImplementedException();
}
}
EFDbContext.SaveChgs();
break;
default:
throw new NotImplementedException();
}
}
