public List <SP_PropertyInfo> GetAllStoreprocedureDescription(string istrdbName, bool iblnSearchInSSISPackages)
{
var storeprocedure = SrvDatabaseStoreProc.GetStoreProceduresWithDescription(istrdbName);
var serverName = SrvServerInfo.GetServerName().FirstOrDefault();
//var SSRS_package = new List<PackageJsonHandler>();
//SSISPackageInfoHandlerController.GetAllSSISPackages(_hostingEnv.WebRootPath);
//SSISPackageInfoHandlerController.SSISPkgeCache.Cache.TryGetValue(serverName, out SSRS_package);
//if (SSRS_package != null) FillSSISPackageDetails(AllStoreprocedure, SSRS_package);
if (iblnSearchInSSISPackages)
{
storeprocedure = storeprocedure.Where(x => x.lstSSISpackageReferance.IsNotNull()).ToList();
}
return(storeprocedure);
}
public Ms_Description GetStoreProcMsDescription(string istrdbName, string StoreprocName)
{
return(SrvDatabaseStoreProc.GetStoreProcedureDescription(istrdbName, StoreprocName));
}
public List <SP_Parameters> GetStoreProcParameters(string istrdbName, string StoreprocName)
{
return(SrvDatabaseStoreProc.GetStoreProceduresParametersWithDescription(istrdbName, StoreprocName));
}
public List <SP_Depencancy> GetStoreProcDependancy(string istrdbName, string StoreprocName)
{
return(SrvDatabaseStoreProc.GetStoreProceduresDependency(istrdbName, StoreprocName));
}
public Ms_Description GetCreateScriptOfStoreProc(string istrdbName, string StoreprocName)
{
return(SrvDatabaseStoreProc.GetStoreProcedureCreateScript(istrdbName, StoreprocName));
}
public void CreateOrUpdateStoreProcDescription(string istrdbName, string astrDescription_Value,
string astrSP_Name)
{
SrvDatabaseStoreProc.CreateOrUpdateStoreProcedureDescription(istrdbName, astrDescription_Value,
astrSP_Name.Split(".")[0], astrSP_Name);
}
public object GetDependancyTree(string istrdbName, string StoreprocName)
{
return(JsonConvert.DeserializeObject(
SrvDatabaseStoreProc.CreatorOrGetStoreProcedureDependencyTree(istrdbName, StoreprocName)));
}
public List <ExecutionPlanInfo> GetCachedExecutionPlan(string istrdbName, string StoreprocName)
{
return(SrvDatabaseStoreProc.GetStoreProcedureExecutionPlan(istrdbName, StoreprocName));
}
