public MasterDataSet ReadData()
{
MasterDataSet dataSet = new MasterDataSet();
AddList(dataSet, DataType.CHARACTER, TextFileHelper.Read(Const.Path.MasterData.character));
AddList(dataSet, DataType.ESCAPE_INPUT, TextFileHelper.Read(Const.Path.MasterData.escapeInput));
AddList(dataSet, DataType.ESCAPE_SCENE, TextFileHelper.Read(Const.Path.MasterData.escapeScene));
AddList(dataSet, DataType.ITEM, TextFileHelper.Read(Const.Path.MasterData.item));
AddList(dataSet, DataType.LAYER, TextFileHelper.Read(Const.Path.MasterData.layer));
AddList(dataSet, DataType.PARAMETER, TextFileHelper.Read(Const.Path.MasterData.parameter));
AddList(dataSet, DataType.SCENARIO, TextFileHelper.Read(Const.Path.MasterData.scenario));
return(dataSet);
}
public void DownloadData()
{
MasterDataSet dataSet = new MasterDataSet();
Action <DataType, string> OnDownloadComplete = (dataType, response) =>
{
AddList(dataSet, dataType, response);
SaveData(dataSet, dataType);
};
DownloadHelper.CallDownloadCsv(DataType.CHARACTER, Const.Url.character, OnDownloadComplete);
DownloadHelper.CallDownloadCsv(DataType.ESCAPE_INPUT, Const.Url.escapeInput, OnDownloadComplete);
DownloadHelper.CallDownloadCsv(DataType.ESCAPE_SCENE, Const.Url.escapeScene, OnDownloadComplete);
DownloadHelper.CallDownloadCsv(DataType.ITEM, Const.Url.item, OnDownloadComplete);
DownloadHelper.CallDownloadCsv(DataType.LAYER, Const.Url.layer, OnDownloadComplete);
DownloadHelper.CallDownloadCsv(DataType.PARAMETER, Const.Url.parameter, OnDownloadComplete);
DownloadHelper.CallDownloadCsv(DataType.SCENARIO, Const.Url.scenario, OnDownloadComplete);
}
public void WriteConfig(DataBase db)
{
MasterDataSet masterDataSet = new MasterDataSet();
MasterTableAdapter ta = new MasterTableAdapter(db);
ta.Fill(masterDataSet.Master);
SetValue(masterDataSet.Master, "DateName", "", DateName);
SetValue(masterDataSet.Master, "DateType", "", ((int)DateType).ToString());
for (int i = 0; i < MaximumNumberOfUserFields; i++)
{
string cdField = string.Format("CD{0}", i + 1);
SetValue(masterDataSet.Master, "UserFieldName", cdField, UserCDFields[i].Name);
SetValue(masterDataSet.Master, "UserFieldType", cdField, ((int)UserCDFields[i].Type).ToString());
string trackField = string.Format("Track{0}", i + 1);
SetValue(masterDataSet.Master, "UserFieldName", trackField, UserTrackFields[i].Name);
SetValue(masterDataSet.Master, "UserFieldType", trackField, ((int)UserTrackFields[i].Type).ToString());
}
ta.Update(masterDataSet);
// Alte Einträge löschen
foreach (MasterDataSet.MasterRow row in masterDataSet.Master)
{
if (row.Code.StartsWith("MonitorDir"))
{
ta.Delete(row.Code, row.CodeSub);
}
}
for (int i = 0; i < MonitoredDirectories.Count; i++)
{
ta.Insert("MonitorDir", i.ToString(), MonitoredDirectories[i]);
}
}
private void SaveData(MasterDataSet dataSet, DataType type)
{
switch (type)
{
case DataType.CHARACTER:
TextFileHelper.Write(Const.Path.MasterData.character, CsvHelper.FormatListToCsv(dataSet.CharacterList));
break;
case DataType.ESCAPE_INPUT:
TextFileHelper.Write(Const.Path.MasterData.escapeInput, CsvHelper.FormatListToCsv(dataSet.EscapeInputList));
break;
case DataType.ESCAPE_SCENE:
TextFileHelper.Write(Const.Path.MasterData.escapeScene, CsvHelper.FormatListToCsv(dataSet.EscapeSceneList));
break;
case DataType.ITEM:
TextFileHelper.Write(Const.Path.MasterData.item, CsvHelper.FormatListToCsv(dataSet.ItemList));
break;
case DataType.LAYER:
TextFileHelper.Write(Const.Path.MasterData.layer, CsvHelper.FormatListToCsv(dataSet.LayerList));
break;
case DataType.PARAMETER:
TextFileHelper.Write(Const.Path.MasterData.parameter, CsvHelper.FormatListToCsv(dataSet.ParameterList));
break;
case DataType.SCENARIO:
TextFileHelper.Write(Const.Path.MasterData.scenario, CsvHelper.FormatListToCsv(dataSet.ScenarioList));
break;
default:
break;
}
}
public void ReadConfig(DataBase db)
{
MasterDataSet masterDataSet = new MasterDataSet();
MasterTableAdapter ta = new MasterTableAdapter(db);
ta.Fill(masterDataSet.Master);
int version = 0;
if (Int32.TryParse(GetValue(masterDataSet.Master, "Version", "", ""), out version))
{
Version = version;
}
DateName = GetValue(masterDataSet.Master, "DateName", "", "");
int dateType = 0;
if (Int32.TryParse(GetValue(masterDataSet.Master, "DateType", "", ""), out dateType))
{
DateType = (DateType)dateType;
}
UserCDFields = new List <UserField>();
UserTrackFields = new List <UserField>();
for (int i = 0; i < MaximumNumberOfUserFields; i++)
{
string cdField = string.Format("CD{0}", i + 1);
UserField uf = new UserField();
uf.Name = GetValue(masterDataSet.Master, "UserFieldName", cdField, "");
int fieldType = 0;
if (Int32.TryParse(GetValue(masterDataSet.Master, "UserFieldType", cdField, ""), out fieldType))
{
uf.Type = (UserFieldType)fieldType;
}
UserCDFields.Add(uf);
string trackField = string.Format("Track{0}", i + 1);
UserField ufTrack = new UserField();
ufTrack.Name = GetValue(masterDataSet.Master, "UserFieldName", trackField, "");
int fieldTypeTrack = 0;
if (Int32.TryParse(GetValue(masterDataSet.Master, "UserFieldType", trackField, ""), out fieldTypeTrack))
{
ufTrack.Type = (UserFieldType)fieldTypeTrack;
}
UserTrackFields.Add(ufTrack);
}
MonitoredDirectories = new List <string>();
int count = 0;
while (true)
{
string directory = GetValue(masterDataSet.Master, "MonitorDir", count.ToString(), "");
if (string.IsNullOrEmpty(directory))
{
break;
}
MonitoredDirectories.Add(directory);
count++;
}
}
private void ConvertMasterTable()
{
string cmdHdb = "SELECT * from [Master]";
OleDbCommand comm = new OleDbCommand(cmdHdb, hdbConnection);
OleDbDataReader reader = comm.ExecuteReader();
reader.Read();
short version = (short)GetValue(reader, "wVersion", (short)0);
string dateName = (string)GetValue(reader, "szNameDatum", "");
byte dateType = (byte)GetValue(reader, "cTypDatum", (byte)0);
string userFieldCD1 = (string)GetValue(reader, "szCDbFeld1", "");
string userFieldCD2 = (string)GetValue(reader, "szCDbFeld2", "");
string userFieldCD3 = (string)GetValue(reader, "szCDbFeld3", "");
string userFieldCD4 = (string)GetValue(reader, "szCDbFeld4", "");
string userFieldCD5 = (string)GetValue(reader, "szCDbFeld5", "");
string userFieldTrack1 = (string)GetValue(reader, "szTrackbFeld1", "");
string userFieldTrack2 = (string)GetValue(reader, "szTrackbFeld2", "");
string userFieldTrack3 = (string)GetValue(reader, "szTrackbFeld3", "");
string userFieldTrack4 = (string)GetValue(reader, "szTrackbFeld4", "");
string userFieldTrack5 = (string)GetValue(reader, "szTrackbFeld5", "");
byte userFieldTypeCD1 = (byte)GetValue(reader, "cTypCDbFeld1", (byte)0);
byte userFieldTypeCD2 = (byte)GetValue(reader, "cTypCDbFeld2", (byte)0);
byte userFieldTypeCD3 = (byte)GetValue(reader, "cTypCDbFeld3", (byte)0);
byte userFieldTypeCD4 = (byte)GetValue(reader, "cTypCDbFeld4", (byte)0);
byte userFieldTypeCD5 = (byte)GetValue(reader, "cTypCDbFeld5", (byte)0);
byte userFieldTypeTrack1 = (byte)GetValue(reader, "cTypTrackbFeld1", (byte)0);
byte userFieldTypeTrack2 = (byte)GetValue(reader, "cTypTrackbFeld2", (byte)0);
byte userFieldTypeTrack3 = (byte)GetValue(reader, "cTypTrackbFeld3", (byte)0);
byte userFieldTypeTrack4 = (byte)GetValue(reader, "cTypTrackbFeld4", (byte)0);
byte userFieldTypeTrack5 = (byte)GetValue(reader, "cTypTrackbFeld5", (byte)0);
MasterDataSet masterDataSet = new MasterDataSet();
MasterTableAdapter ta = new MasterTableAdapter(sdfDatabase);
masterDataSet.Master.AddMasterRow("Version", "", version.ToString());
masterDataSet.Master.AddMasterRow("DateName", "", dateName);
masterDataSet.Master.AddMasterRow("DateType", "", dateType.ToString());
masterDataSet.Master.AddMasterRow("UserFieldName", "CD1", userFieldCD1);
masterDataSet.Master.AddMasterRow("UserFieldName", "CD2", userFieldCD2);
masterDataSet.Master.AddMasterRow("UserFieldName", "CD3", userFieldCD3);
masterDataSet.Master.AddMasterRow("UserFieldName", "CD4", userFieldCD4);
masterDataSet.Master.AddMasterRow("UserFieldName", "CD5", userFieldCD5);
masterDataSet.Master.AddMasterRow("UserFieldName", "Track1", userFieldTrack1);
masterDataSet.Master.AddMasterRow("UserFieldName", "Track2", userFieldTrack2);
masterDataSet.Master.AddMasterRow("UserFieldName", "Track3", userFieldTrack3);
masterDataSet.Master.AddMasterRow("UserFieldName", "Track4", userFieldTrack4);
masterDataSet.Master.AddMasterRow("UserFieldName", "Track5", userFieldTrack5);
masterDataSet.Master.AddMasterRow("UserFieldType", "CD1", userFieldTypeCD1.ToString());
masterDataSet.Master.AddMasterRow("UserFieldType", "CD2", userFieldTypeCD2.ToString());
masterDataSet.Master.AddMasterRow("UserFieldType", "CD3", userFieldTypeCD3.ToString());
masterDataSet.Master.AddMasterRow("UserFieldType", "CD4", userFieldTypeCD4.ToString());
masterDataSet.Master.AddMasterRow("UserFieldType", "CD5", userFieldTypeCD5.ToString());
masterDataSet.Master.AddMasterRow("UserFieldType", "Track1", userFieldTypeTrack1.ToString());
masterDataSet.Master.AddMasterRow("UserFieldType", "Track2", userFieldTypeTrack2.ToString());
masterDataSet.Master.AddMasterRow("UserFieldType", "Track3", userFieldTypeTrack3.ToString());
masterDataSet.Master.AddMasterRow("UserFieldType", "Track4", userFieldTypeTrack4.ToString());
masterDataSet.Master.AddMasterRow("UserFieldType", "Track5", userFieldTypeTrack5.ToString());
ta.Update(masterDataSet);
}
private void AddList(MasterDataSet dataSet, DataType dataType, string csvString)
{
List <string[]> csvDataList = CsvHelper.FormatCsvToStringArrayList(csvString);
switch (dataType)
{
case DataType.CHARACTER:
foreach (string[] data in csvDataList)
{
if (data == csvDataList[0])
{
continue;
}
dataSet.CharacterList.Add(new Character(int.Parse(data[0]), data[1], data[2], data[3], data[4], int.Parse(data[5]), int.Parse(data[6])));
}
break;
case DataType.ESCAPE_INPUT:
foreach (string[] data in csvDataList)
{
if (data == csvDataList[0])
{
continue;
}
dataSet.EscapeInputList.Add(new EscapeInput(int.Parse(data[0]), data[1], data[2], int.Parse(data[3]), int.Parse(data[4]), int.Parse(data[5]), int.Parse(data[6]), data[7]));
}
break;
case DataType.ESCAPE_SCENE:
foreach (string[] data in csvDataList)
{
if (data == csvDataList[0])
{
continue;
}
dataSet.EscapeSceneList.Add(new EscapeScene(int.Parse(data[0]), data[1], data[2], data[3], data[4], data[5]));
}
break;
case DataType.ITEM:
foreach (string[] data in csvDataList)
{
if (data == csvDataList[0])
{
continue;
}
dataSet.ItemList.Add(new Item(int.Parse(data[0]), data[1], data[2], data[3], Convert.ToBoolean(data[4])));
}
break;
case DataType.LAYER:
foreach (string[] data in csvDataList)
{
if (data == csvDataList[0])
{
continue;
}
dataSet.LayerList.Add(new Layer(
int.Parse(data[0]),
data[1],
data[2],
int.Parse(data[3]),
int.Parse(data[4]),
int.Parse(data[5]),
int.Parse(data[6]),
Convert.ToBoolean(data[7]),
Convert.ToBoolean(data[8]),
int.Parse(data[9])
));
}
break;
case DataType.PARAMETER:
foreach (string[] data in csvDataList)
{
if (data == csvDataList[0])
{
continue;
}
dataSet.ParameterList.Add(new Parameter(int.Parse(data[0]), data[1], data[2], data[3]));
}
break;
case DataType.SCENARIO:
foreach (string[] data in csvDataList)
{
if (data == csvDataList[0])
{
continue;
}
dataSet.ScenarioList.Add(new Scenario(int.Parse(data[0]), data[1], data[2], data[3], data[4], data[5], data[6], data[7], data[8]));
}
break;
default:
break;
}
}
public void UpdateData()
{
MasterDataLoader dataLoader = new MasterDataLoader();
MasterDataSet = dataLoader.ReadData();
}
