private void ConstructBody()
{
CSBlock usingBlock = new CSBlock("using (SqlCommand sqlCommand = new SqlCommand())");
string sqlString = $"{Quotes}{SqlDeleteBuilder.DeleteByColumn(datatable, datacolumn)}{Quotes};";
string parameterName = $"{Quotes}@{datacolumn.ColumnName.Replace(" ","")}{Quotes}";
string parameterValue = ProperVarName.Get(datacolumn.ColumnName.ToLower());
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}");
if (datacolumn.AllowDBNull)
{
parameterValue += " ?? (object)DBNull.Value";
}
usingBlock.Statements.Add($"sqlCommand.Parameters.AddWithValue({parameterName}, {parameterValue});");
usingBlock.Statements.Add($"table.DbAccess.Commands.Add(sqlCommand);");
this.Statements.Add(usingBlock.ToString());
}
private void ConstructBody()
{
VBBlock usingBlock = new VBBlock(VBBlockStatement.Using, "Using sqlCommand As New SqlCommand()");
string sqlString = $"{Quotes}{SqlDeleteBuilder.DeleteByColumn(datatable, datacolumn)}{Quotes}";
string parameterName = $"{Quotes}@{datacolumn.ColumnName.Replace(" ", "")}{Quotes}";
string parameterValue = ProperVarName.Get(datacolumn.ColumnName.ToLower());
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}");
if (datacolumn.AllowDBNull)
{
parameterValue = $"If({parameterValue}, CType(DBNull.Value, Object))";
}
usingBlock.Statements.Add($"sqlCommand.Parameters.AddWithValue({parameterName}, {parameterValue})");
usingBlock.Statements.Add($"table.DbAccess.Commands.Add(sqlCommand)");
this.Statements.Add(usingBlock.ToString());
}
