public static string Format(string input)
{
try
{
string output = new SQLFormatter(input).Format();
return(output);
}
catch (Exception)
{
throw;
}
return("");
}
public List <ChangedItem> SaveToDisk(string rootFolder)
{
ReportProgress(0);
var sqlRoot = Path.Combine(rootFolder, "SQL Objects");
Directory.CreateDirectory(sqlRoot);
List <ChangedItem> changedItems = new List <ChangedItem>();
double total = _items.Count;
double current = 0;
if (total == 0)
{
ReportProgress(100);
}
foreach (var item in _items)
{
var fileName = GetFilePathForSQL(rootFolder, item.SQLID.CleanFileName(), item.SqlType);
Directory.CreateDirectory(new FileInfo(fileName).Directory.FullName);
var sqlText = item.GetContents(_conn);
try
{
var formattedText = new SQLFormatter(sqlText).Format();
File.WriteAllText(fileName, formattedText);
}catch (Exception ex)
{
File.WriteAllText(fileName, sqlText);
}
changedItems.Add(new ChangedItem(fileName, item.Oprid));
current++;
ReportProgress(((int)(((current / total) * 10000)) / (double)100));
}
return(changedItems);
}
