private string GenerateVariableDeclarationList(DataTable dtColumns)
{
string strVariablesList = string.Empty;
CodeGeneration objCodeGen = new CodeGeneration();
foreach (DataRow dr in dtColumns.Rows)
{
strVariablesList += "Dim " + objCodeGen.GetVariableName(dr["DATA_TYPE"].ToString(), dr["COLUMN_NAME"].ToString()) + " As " + GetVBDataType(dr["DATA_TYPE"].ToString()) + "\n";
}
return(strVariablesList);
}
private string GenerateFunctionParametersList(DataTable dtColumns)
{
string strList = string.Empty;
CodeGeneration objCodeGen = new CodeGeneration();
foreach (DataRow dr in dtColumns.Rows)
{
strList += "ByVal " + objCodeGen.GetVariableName(dr["DATA_TYPE"].ToString(), dr["COLUMN_NAME"].ToString()) + " As " + GetVBDataType(dr["DATA_TYPE"].ToString()) + ", ";
}
strList = strList.Remove(strList.LastIndexOf(","));
return(strList);
}
private string GenerateVBPropertyList(DataTable dtColumns)
{
string strPropertyList = string.Empty;
CodeGeneration objCodeGen = new CodeGeneration();
foreach (DataRow dr in dtColumns.Rows)
{
string strVariableName = objCodeGen.GetVariableName(dr["DATA_TYPE"].ToString(), dr["COLUMN_NAME"].ToString());
string strPropertyTemplate = objCodeGen.ReadTemplate(PublicEnums.TemplateName.VBProperty);
string strVBDataType = GetVBDataType(dr["DATA_TYPE"].ToString());
strPropertyTemplate = strPropertyTemplate.Replace("__PropertyName", dr["COLUMN_NAME"].ToString());
strPropertyTemplate = strPropertyTemplate.Replace("__VariableName", strVariableName);
strPropertyTemplate = strPropertyTemplate.Replace("__DataType", strVBDataType);
strPropertyList += strPropertyTemplate;
}
return(strPropertyList);
}//end function
} //end function
private string GenerateSPParametersList(DataTable dtColumns)
{
string strParametersList = string.Empty;
CodeGeneration objCodeGen = new CodeGeneration();
foreach (DataRow dr in dtColumns.Rows)
{
strParametersList += @"objCommand.Parameters.AddWithValue(""@" + dr["COLUMN_NAME"].ToString() + @""", " + objCodeGen.GetVariableName(dr["DATA_TYPE"].ToString(), dr["COLUMN_NAME"].ToString()) + ")\n";
}
return(strParametersList);
}