/// <summary> /// Get a list of StoredProcedures from the database /// </summary> /// <param name="databaseName">The name of the database to query</param> /// <param name="connectionString">Connection parameters</param> /// <returns></returns> public static AutoCompleteStringCollection GetStoredProcedureList(string databaseName, string connectionString) { string strSelctTableQuery = SmartBuilder.Repository.MsSQL.QueryCollaborator.GenerateQuery_GetListOfStoredProceduresByDatabaseName(databaseName); AppUtilityDataProvider CtlUtility = new AppUtilityDataProvider(); DataTable dt = CtlUtility.GetTableListofDataBase(strSelctTableQuery, connectionString); AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection(); for (int i = 0; i < dt.Rows.Count; i++) { namesCollection.Add(dt.Rows[i]["ROUTINE_NAME"].ToString()); } return(namesCollection); }
public string GetTableInfoByTableNameandClassName(AdonaiBuildStructureInfo buildInfo) { string tableName = USUtil.CovertFirstLetterToCapital(buildInfo.TableName); string infoClassName = USUtil.CovertFirstLetterToCapital(buildInfo.InfoClassName); string strFinalinfoString = string.Empty; string strScript = SmartBuilder.Repository.MsSQL.QueryCollaborator.GenerateQuery_GetListOfColumnInfoByTableName(tableName); AppUtilityDataProvider objInfoDataProvider = new AppUtilityDataProvider(); DataTable dataTable = objInfoDataProvider.GetTableColumnsBySQLScritpt(strScript, buildInfo.ConnectionString); InfoClassGenerator infoClassGenerator = new InfoClassGenerator(GetSystemSettings()); strFinalinfoString = infoClassGenerator.BuildInfoClassforGivenDataTable(dataTable, infoClassName, buildInfo.IsNullableRequired, buildInfo.IsSerializable); //Process data of data table to build final string for the C# info class //strFinalinfoString = TableInfoGenerator.BuildInfoClassforGivenDataTable(dt, infoClassName, buildInfo.IsNullableRequired, buildInfo.IsSerializable); StringBuilder strBuilder = new StringBuilder(); strBuilder.Append(USUtil.LoadUsingCodex(buildInfo.InfoNameSpace, string.Empty)); strBuilder.Append(strFinalinfoString); strBuilder.Append(" \r }"); USUtil.CreateClassFileForGivenTypeClass(infoClassName, strBuilder.ToString(), ICD.Info); //Add Controller Class if (buildInfo.IsControllerRequired) { strBuilder.Append(AddContentHeader("Your Controller Class")); string txtControllerCode = USUtil.Initialize_UsingStatementAndClassHeader(buildInfo.InfoNameSpace, tableName, ICD.Controller); USUtil.CreateClassFileForGivenTypeClass(tableName + USUtil.Controller, txtControllerCode, ICD.Controller); strBuilder.Append(txtControllerCode); } //Add SQL DataProvider Class if (buildInfo.IsProviderRequired) { strBuilder.Append(AddContentHeader("Your SQL Data Provider Class")); string txtProviderCode = USUtil.Initialize_UsingStatementAndClassHeader(buildInfo.InfoNameSpace, tableName, ICD.DataProvider); USUtil.CreateClassFileForGivenTypeClass(tableName + USUtil.Provider, txtProviderCode, ICD.DataProvider); strBuilder.Append(txtProviderCode); } return(strBuilder.ToString()); }