public static String Generate(String FileName)
{
List<String> Messages = new List<String>();
try
{
//String FileName = Settings.GetValue("WebSpiderDB");
String ConnStr = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Persist Security Info=True", FileName);
WebSpiderTableGenerator gen = new WebSpiderTableGenerator(ConnStr);
Messages.Add(String.Format("Using File \'{0}\'", FileName));
Messages.Add(gen.GenerateAdiBrand());
Messages.Add(gen.GenerateAdiCategory());
Messages.Add(gen.GenerateFinalTable());
Messages.Add(gen.GenerateAdiChild());
Messages.Add(gen.GenerateAdiInventoryDetails());
Messages.Add(gen.GenerateAdiInventory());
Messages.Add(gen.GenerateSecLockManufacturer());
Messages.Add(gen.GenerateSecLockManufacturerSeries());
Messages.Add(gen.GenerateSecLockCategory());
}
catch (Exception ex)
{
Messages.Add(ex.ToString());
}
return String.Join("\n", Messages);
}
public static String Generate(String FileName)
{
List <String> Messages = new List <String>();
try
{
//String FileName = Settings.GetValue("WebSpiderDB");
String ConnStr = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Persist Security Info=True", FileName);
WebSpiderTableGenerator gen = new WebSpiderTableGenerator(ConnStr);
Messages.Add(String.Format("Using File \'{0}\'", FileName));
Messages.Add(gen.GenerateAdiBrand());
Messages.Add(gen.GenerateAdiCategory());
Messages.Add(gen.GenerateFinalTable());
Messages.Add(gen.GenerateAdiChild());
Messages.Add(gen.GenerateAdiInventoryDetails());
Messages.Add(gen.GenerateAdiInventory());
Messages.Add(gen.GenerateSecLockManufacturer());
Messages.Add(gen.GenerateSecLockManufacturerSeries());
Messages.Add(gen.GenerateSecLockCategory());
}
catch (Exception ex)
{
Messages.Add(ex.ToString());
}
return(String.Join("\n", Messages));
}