private static void GenerateSPs()
{
//if (DataService.Provider == null)
SetProvider();
string lang = _language;
string fileExt = FileExtension.DOT_CS;
if (FileExtension.IsVB(lang))
{
language = new VBCodeLanguage();
fileExt = FileExtension.DOT_VB;
}
//loop the providers, and if there's more than one, output to their own folder
//for tidiness
foreach (DataProvider provider in DataService.Providers)
{
//string code = usings + CodeService.RunSPs(provider.Name, language);
string outDir = GetOutSubDir(provider);
if (outDir == string.Empty)
{
outDir = Directory.GetCurrentDirectory();
}
string outPath = Path.Combine(outDir, "StoredProcedures" + fileExt);
AddLogEntry(LogState.Information, "Generating SPs to " + outPath);
TurboTemplate tt = CodeService.BuildSPTemplate(language, provider);
tt.OutputPath = outPath;
turboCompiler.AddTemplate(tt);
}
AddLogEntry(LogState.Information, "Finished");
}
public void Acc_CodeGen2_VBRunSPTemplate()
{
DataProvider provider = DataService.GetInstance("NorthwindAccess");
TurboTemplate bits = CodeService.BuildSPTemplate(new VBCodeLanguage(), provider);
bits.Render();
Assert.IsTrue(bits.FinalCode.Length > 0);
}
protected void btnGo_Click(object sender, EventArgs e)
{
string sOutPath = txtOut.Text;
if (!Directory.Exists(sOutPath))
{
Directory.CreateDirectory(sOutPath);
}
try
{
ICodeLanguage language = CodeLanguageFactory.GetByShortName(languageSelect.SelectedValue);
string providerName = (string)Session[PROVIDER_NAME];
if (!String.IsNullOrEmpty(providerName))
{
DataProvider provider = DataService.GetInstance(providerName);
if (provider != null)
{
TurboCompiler turboCompiler = new TurboCompiler();
StringBuilder sbTableList = new StringBuilder();
foreach (ListItem item in chkTables.Items)
{
if (item.Selected)
{
sbTableList.AppendLine(item.Value);
}
}
foreach (ListItem item in chkTables.Items)
{
if (item.Selected)
{
TableSchema.Table t = DataService.GetTableSchema(item.Value, provider.Name, TableType.Table);
if (t.ForeignKeys.Count > 0)
{
//provider.GetManyToManyTables(t, evalTables);
}
string className = DataService.GetTableSchema(item.Value, providerName, TableType.Table).ClassName;
string filePath = Path.Combine(sOutPath, className + language.FileExtension);
TurboTemplate classTemplate = CodeService.BuildClassTemplate(item.Value, language, provider);
classTemplate.OutputPath = filePath;
turboCompiler.AddTemplate(classTemplate);
//SubSonic.Sugar.Files.CreateToFile(filePath, usings + CodeService.RunClass(item.Value, providerName, language));
if (chkODS.Checked)
{
filePath = Path.Combine(sOutPath, className + "Controller" + language.FileExtension);
TurboTemplate odsTemplate = CodeService.BuildODSTemplate(item.Value, language, provider);
odsTemplate.OutputPath = filePath;
turboCompiler.AddTemplate(odsTemplate);
//SubSonic.Sugar.Files.CreateToFile(filePath, usings + CodeService.RunODS(item.Value, providerName, language));
}
}
}
//output the Views
foreach (ListItem item in chkViews.Items)
{
if (item.Selected)
{
string className = DataService.GetTableSchema(item.Value, providerName, TableType.View).ClassName;
string filePath = Path.Combine(sOutPath, className + language.FileExtension);
TurboTemplate viewTemplate = CodeService.BuildViewTemplate(item.Value, language, provider);
viewTemplate.OutputPath = filePath;
turboCompiler.AddTemplate(viewTemplate);
//SubSonic.Sugar.Files.CreateToFile(filePath, usings + CodeService.RunReadOnly(item.Value, providerName, language));
}
}
//output the SPs
if (chkSP.Checked)
{
string filePath = Path.Combine(sOutPath, "StoredProcedures" + language.FileExtension);
TurboTemplate spTemplate = CodeService.BuildSPTemplate(language, provider);
spTemplate.OutputPath = filePath;
turboCompiler.AddTemplate(spTemplate);
//SubSonic.Sugar.Files.CreateToFile(filePath, usings + CodeService.RunSPs(providerName, language));
}
//structs
string structPath = Path.Combine(sOutPath, "AllStructs" + language.FileExtension);
TurboTemplate structsTemplate = CodeService.BuildStructsTemplate(language, provider);
structsTemplate.OutputPath = structPath;
turboCompiler.AddTemplate(structsTemplate);
//SubSonic.Sugar.Files.CreateToFile(structPath, usings + CodeService.RunStructs(language));
if (turboCompiler.Templates.Count > 0)
{
turboCompiler.Run();
foreach (TurboTemplate template in turboCompiler.Templates)
{
Utility.WriteTrace("Writing " + template.TemplateName + " as " + template.OutputPath.Substring(template.OutputPath.LastIndexOf("\\") + 1));
SubSonic.Sugar.Files.CreateToFile(template.OutputPath, template.FinalCode);
}
}
lblResult.Text = "View your files: <a href='file://" + sOutPath + "'>" + sOutPath + "</a>";
}
}
}
catch (Exception x)
{
lblResult.Text = "Error: " + x.Message;
}
}
