private void CorrectStructuredMaterialDataBase ()
{
WCFStandardsNS.WCFStandards DataBase = new WCFStandardsNS.WCFStandards ();
DataSet MaterialTypenDataSet = DataBase.GetCommonDataSet ("Select TechnicalTyp from MaterialType");
DataTable MaterialTable = MaterialTypenDataSet.Tables ["MaterialType"];
DataSet FileIDsDataSet = DataBase.GetCommonDataSet ("Select Distinct FileID from "
+ "StructuredMaterialDataBase");
foreach (DataRow FileIDRow in FileIDsDataSet.Tables ["StructuredMaterialDataBase"].Rows)
{
DataSet EntriesForOneFileID = DataBase.GetCommonDataSet
(String.Format ("Select * from StructuredMaterialDataBase where FileID = '{0}' order by FoldedArchivePath",
FileIDRow ["FileID"].ToString ()));
bool ErrorFound = false;
List<String> FoldedNames = new List<string> ();
List<String> FoundIDs = new List<string> ();
foreach (DataRow MaterialRow in EntriesForOneFileID.Tables ["StructuredMaterialDataBase"].Rows)
{
String FoldedArchivePath = MaterialRow ["FoldedArchivePath"].ToString ();
FoldedNames.Add (FoldedArchivePath);
foreach (DataRow MaterialTypenRow in MaterialTable.Rows)
{
String Replacement = "_" + MaterialTypenRow [0].ToString ().ToUpper () + "_";
if (FoldedArchivePath.IndexOf (Replacement, StringComparison.InvariantCultureIgnoreCase) != -1)
{
ErrorFound = true;
String NewSearchName = FoldedArchivePath.Replace (Replacement, "");
MaterialRow ["FoldedArchivePath"] = NewSearchName;
}
}
}
if (ErrorFound == true)
{
//MessageBox.Show ("Fehler bei ID\r\n" + FileIDRow ["FileID"].ToString ()
// + "\r\n" + String.Join ("\r\n", FoldedNames.ToArray()));
DataBase.SetCommonDataSet (EntriesForOneFileID);
}
}
}
