private void ConstructBody()
{
CSBlock usingBlock = new CSBlock("using (SqlCommand sqlCommand = new SqlCommand())");
string sqlString = $"{Quotes}{SqlSelectBuilder.SelectByPrimaryKey(datatable)}{Quotes};";
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}");
foreach (DataColumn clm in datatable.PrimaryKey)
{
string parameterName = $"{Quotes}@{clm.ColumnName}{Quotes}";
string parameterValue = clm.ColumnName.ToLower();
usingBlock.Statements.Add($"sqlCommand.Parameters.AddWithValue({parameterName}, {parameterValue});");
}
usingBlock.Statements.Add($"var list = ToList(sqlCommand);");
var ifBlock = new CSBlock("if (list.Count > 0)");
ifBlock.Statements.Add("return list[0];");
usingBlock.Statements.Add(ifBlock.ToString());
usingBlock.Statements.Add($"return null;");
this.Statements.Add(usingBlock.ToString());
}
private void ConstructBody()
{
VBBlock usingBlock = new VBBlock(VBBlockStatement.Using, "Using sqlCommand As New SqlCommand()");
string sqlString = $"{Quotes}{SqlSelectBuilder.SelectByPrimaryKey(datatable)}{Quotes}";
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}");
foreach (DataColumn clm in datatable.PrimaryKey)
{
string parameterName = $"{Quotes}@{clm.ColumnName}{Quotes}";
string parameterValue = clm.ColumnName.ToLower();
usingBlock.Statements.Add($"sqlCommand.Parameters.AddWithValue({parameterName}, {parameterValue})");
}
usingBlock.Statements.Add($"Dim list As List(Of {datatable.TableName}) = ToList(sqlCommand)");
var ifBlock = new VBBlock(VBBlockStatement.If, "If list.Count > 0 Then");
ifBlock.Statements.Add("Return list(0)");
usingBlock.Statements.Add(ifBlock.ToString());
usingBlock.Statements.Add($"Return Nothing");
this.Statements.Add(usingBlock.ToString());
}
