private void btnGenrate_Click(object sender, EventArgs e)
{
try
{
string RootlibraryPath = USUtil.SavePath;
FileManager.DeleteDirectory(RootlibraryPath);
string defaultNameSpace = tbxDefaultNamespace.Text.Trim();
if (defaultNameSpace == string.Empty)
{
defaultNameSpace = USUtil.DefaultNameSpace;
}
if (ddlType.SelectedValue.ToString().Trim() == USUtil.Tbl || ddlType.SelectedValue.ToString().Trim() == string.Empty)
{
AdonaiBuildStructureInfo buildInfo = new AdonaiBuildStructureInfo();
buildInfo.TableName = txtTableName.Text.Trim();
buildInfo.InfoClassName = txtClassName.Text.Trim();
buildInfo.ConnectionString = ConnectionString;
buildInfo.IsNullableRequired = chkIsNullableRequred.Checked;
buildInfo.IsSerializable = chklsSerializable.Checked;
buildInfo.IsControllerRequired = chkIsController.Checked;
buildInfo.IsProviderRequired = chkIsProviderRequred.Checked;
buildInfo.InfoNameSpace = defaultNameSpace;
BELLBuilderController ctlBELL = new BELLBuilderController();
string output = ctlBELL.GetTableInfoByTableNameandClassName(buildInfo);
AddToFastNote(output);
}
else
{
AppUtilityDataProvider dataProvider = new AppUtilityDataProvider();
IList <KeyValuePair <string, object> > inputParamList = dataProvider.GetSpPrametersBySpName(txtTableName.Text.Trim(), ConnectionString);
if (inputParamList.Count > 0)
{
IList <KeyValuePair <string, object> > listColl = new List <KeyValuePair <string, object> >();
ArrayList arrColl = BuildSQLParameter(inputParamList);
for (int i = 0; i < arrColl.Count; i++)
{
listColl.Add(new KeyValuePair <string, object>(arrColl[i].ToString(), "1"));
}
string strInfoText = dataProvider.ExecuteGivenProcedureBuildInfoClass(txtTableName.Text, tbxDefaultNamespace.Text.Trim(), txtClassName.Text.Trim(), listColl, ConnectionString);
AddToFastNote(strInfoText);
}
else
{
USUtil.DisplayMessage(USUtil.msg_SPHasNoParam, USUtil.msg_ErrorCaption, false);
}
}
}
catch (Exception ex)
{
USUtil.DisplayMessage(ex.Message, USUtil.msg_ErrorCaption, false);
}
}
public string GenerateTableInfo(AdonaiBuildStructureInfo buildInfo, SystemSettingsInfo systemSettings)
{
string tableName = Helper.CovertFirstLetterToCapital(buildInfo.TableName);
string infoClassName = Helper.CovertFirstLetterToCapital(buildInfo.InfoClassName);
string strFinalinfoString = string.Empty;
string strScript = QueryCollaborator.GenerateQuery_GetListOfColumnInfoByTableName(tableName);
QueryExecutor objInfoDataProvider = new QueryExecutor();
DataTable dataTable = objInfoDataProvider.GetTableColumnsBySQLScritpt(strScript, buildInfo.ConnectionString);
InfoClassGenerator infoClassGenerator = new InfoClassGenerator(systemSettings);
strFinalinfoString = infoClassGenerator.BuildInfoClassforGivenDataTable(dataTable, 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);
//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();
return(string.Empty);
}
private void GetCheckedItemFromList()
{
ArrayList arrColl = new ArrayList();
foreach (object itemChecked in chkList.CheckedItems)
{
RandomClass obj = (RandomClass)itemChecked;
arrColl.Add(obj.Name);
}
if (arrColl.Count > 0)
{
AdonaiBuildStructureInfo buildInfo = new AdonaiBuildStructureInfo();
buildInfo.IsSerializable = chklsSerializable.Checked;
buildInfo.IsControllerRequired = chkIsController.Checked;
buildInfo.IsProviderRequired = chkIsProviderRequred.Checked;
buildInfo.IsNullableRequired = false;
buildInfo.ConnectionString = ConnectionString;
BELLBuilderController ctl = new BELLBuilderController();
string message = ctl.BuildInfoClassForMulitpleTables(arrColl, buildInfo);
AddToFastNote(message);
}
}
