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)); }