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]);
}
}
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);
}
