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());
}
public string BuildInfoClassForMulitpleTables(ArrayList arrTableNameList, AdonaiBuildStructureInfo buildInfo)
{
StringBuilder strBuilder = new StringBuilder();
strBuilder.Append("\r\r");
strBuilder.Append("--------------------------------------------------\r");
strBuilder.Append("Note:\r");
strBuilder.Append(" The Data contained in this output folder will be ");
strBuilder.Append("\r overridden next time,Please do keep that in mind \r");
strBuilder.Append("--------------------------------------------------\r");
strBuilder.Append("\r\r");
for (int i = 0; i < arrTableNameList.Count; i++)
{
string infoHeader = buildInfo.TableName = arrTableNameList[i].ToString();
infoHeader += "Info";
buildInfo.InfoClassName = infoHeader;
strBuilder.Append(GetTableInfoByTableNameandClassName(buildInfo));
strBuilder.Append("\r\r");
}
return(strBuilder.ToString());
}
