static string GenerateApplicationMenuScopeScript(Options options)
{
GenericSqlCommand command = new GenericSqlCommand("ConnectionString");
DataTable table = command.ExecuteQueryForDataTable(" SELECT * FROM tb_Application_Menu_Scope WHERE EntityId IN ( SELECT Id FROM tb_Application_Menu WHERE ApplicationId IN ( SELECT Id FROM tb_Application WHERE ApplicationName = '" + options.ApplicationName + "' ) ) ORDER BY EntityId, AuthorizationObjectType ");
return(SqlScriptHelper.GenerateDateTableScript("", "tb_Application_Menu_Scope", table));
}
static string GenerateApplicationErrorScript(Options options)
{
GenericSqlCommand command = new GenericSqlCommand("ConnectionString");
DataTable table = command.ExecuteQueryForDataTable(" SELECT * FROM tb_Application_Error WHERE ApplicationId IN ( SELECT Id FROM tb_Application WHERE ApplicationName = '" + options.ApplicationName + "' ) ORDER BY ParentId, OrderId ");
return(SqlScriptHelper.GenerateDateTableScript("", "tb_Application_Error", table));
}
static string GenerateApplicationScript(Options options)
{
GenericSqlCommand command = new GenericSqlCommand("ConnectionString");
DataTable table = command.ExecuteQueryForDataTable(" SELECT * FROM tb_Application WHERE ApplicationName = '" + options.ApplicationName + "' ");
return(SqlScriptHelper.GenerateDateTableScript("", "tb_Application", table));
}