private void AddInsertUpdateStoredProcedures(CProject dataProject, List <CTable> tables)
{
//merge version of stored procs
//update stored procedures
foreach (var table in tables)
{
var converter3 = new CTableToSqlServerStoredProcedureAddUpdateConverter();
var storedProcedure = converter3.Convert(table);
AddSchema(dataProject, $"{storedProcedure.Schema.SchemaName}");
var fileName = $"{storedProcedure.StoredProcedureName}.sql";
//var filePath = System.IO.Path.Combine(System.IO.Path.Combine(OutputRootPath, dataProject.ProjectFolder), fileName);
dataProject.ProjectContent.Add(new CProjectContent
{
Content = storedProcedure,
BuildAction = CBuildAction.Build,
File = new CFile
{
Folder = $"{storedProcedure.Schema.SchemaName}\\Stored Procedures",
FileName = fileName
}
});
}
}
private void AddInsertUpdateStoredProcedures(KDataStoreProject mDatabaseProject)
{
//merge version of stored procs
//update stored procedures
var addUpdateStoredProcedures = new List <KStoredProcedure>();
foreach (var table in mDatabaseProject.Table)
{
var converter3 = new CTableToSqlServerStoredProcedureAddUpdateConverter();
var storedProcedure = converter3.Convert(table.GeneratedTable);
addUpdateStoredProcedures.Add(new KStoredProcedure
{
StoredProcedureName = storedProcedure.StoredProcedureName,
ParameterSetName = storedProcedure.ParameterSetName,
ResultSetName = storedProcedure.ResultSetName,
GeneratedStoredProcedure = storedProcedure
});
}
mDatabaseProject.StoredProcedure.AddRange(addUpdateStoredProcedures);
}
