private void CreateParameter()
{
var type = ProperCSTypeName.Get(datacolumn);
string name = ProperVarName.Get(datacolumn.ColumnName.ToLower());
this.MethodArgs.Add(new CSArgument(type, name));
}
private void ConstructParameter()
{
var type = datatable.TableName;
string name = ProperVarName.Get(datatable.TableName.ToLower());
this.MethodArgs.Add(new VBArgument(type, name));
}
private void ConstructBody()
{
CSBlock usingBlock = new CSBlock("using (SqlCommand sqlCommand = new SqlCommand())");
string sqlString = $"{Quotes}{SqlInsertBuilder.CreateInsertSql(datatable)} SELECT SCOPE_IDENTITY() AS INT;{Quotes};";
string parameterName = string.Empty;
string propertyName = string.Empty;
string parameterValue = string.Empty;
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}");
foreach (DataColumn clm in datatable.Columns)
{
if (clm.AutoIncrement)
{
continue;
}
parameterName = $"{Quotes}@{clm.ColumnName.Replace(" ", "")}{Quotes}";
propertyName = ProperVarName.Get(clm.ColumnName);
parameterValue = $"{ProperVarName.Get(datatable.TableName.ToLower())}.{propertyName}";
if (clm.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()
{
string className = datatable.TableName;
string instanceName = ProperVarName.Get(datatable.TableName.ToLower());
this.Statements.Add("Dim dt As DataTable = table.DbAccess.GetDataTable(sqlCommand)");
this.Statements.Add($"Dim list As List(Of {className}) = New List(Of {className})()");
VBBlock forEachBlock = new VBBlock(VBBlockStatement.ForEach, "For Each dataRow As DataRow In dt.Rows");
forEachBlock.Statements.Add($"Dim {instanceName} As {className} = New {className}()");
foreach (DataColumn clm in datatable.Columns)
{
string clmName = ProperVarName.Get(clm.ColumnName, false);
string propName = ProperVarName.Get(clm.ColumnName, true);
if (clm.AllowDBNull)
{
forEachBlock.Statements.Add($"{instanceName}.{propName} = CType(If(dataRow({Quotes}{clmName}{Quotes}) Is DBNull.Value, Nothing, dataRow({Quotes}{clmName}{Quotes})), {ProperVBTypeName.Get(clm)})");
}
else
{
forEachBlock.Statements.Add($"{instanceName}.{propName} = CType(dataRow({Quotes}{clmName}{Quotes}), {ProperVBTypeName.Get(clm)})");
}
}
forEachBlock.Statements.Add($"list.Add({instanceName})");
this.Statements.Add(forEachBlock.ToString());
this.Statements.Add("Return list");
}
private void ConstructBody()
{
string className = datatable.TableName;
string instanceName = ProperVarName.Get(datatable.TableName.ToLower());
this.Statements.Add("var dt = table.DbAccess.GetDataTable(sqlCommand);");
this.Statements.Add($"List<{className}> list = new List<{className}>();");
CSBlock forEachBlock = new CSBlock("foreach (DataRow dataRow in dt.Rows)");
forEachBlock.Statements.Add($"{className} {instanceName} = new {className}();");
foreach (DataColumn clm in datatable.Columns)
{
string clmName = ProperVarName.Get(clm.ColumnName, false);
string propName = ProperVarName.Get(clm.ColumnName, true);
if (clm.AllowDBNull)
{
forEachBlock.Statements.Add($"{instanceName}.{propName} = ({ProperCSTypeName.Get(clm)})(dataRow[{Quotes}{clmName}{Quotes}] == DBNull.Value ? null : dataRow[{Quotes}{clmName}{Quotes}]);");
}
else
{
forEachBlock.Statements.Add($"{instanceName}.{propName} = ({ProperCSTypeName.Get(clm)})dataRow[{Quotes}{clmName}{Quotes}];");
}
}
forEachBlock.Statements.Add($"list.Add({instanceName});");
this.Statements.Add(forEachBlock.ToString());
this.Statements.Add("return list;");
}
private void ConstructBody()
{
VBBlock usingBlock = new VBBlock(VBBlockStatement.Using, "Using sqlCommand As New SqlCommand()");
string sqlString = $"{Quotes}{SqlUpdateBuilder.UpdateByPrimaryKey(datatable)}{Quotes}";
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}");
usingBlock.Statements.Add($"SetSqlCommandParameter(sqlCommand, {ProperVarName.Get(datatable.TableName.ToLower())})");
usingBlock.Statements.Add($"table.DbAccess.Commands.Add(sqlCommand)");
this.Statements.Add(usingBlock.ToString());
}
private void ConstructBody()
{
CSBlock usingBlock = new CSBlock("using (SqlCommand sqlCommand = new SqlCommand())");
string sqlString = $"{Quotes}{SqlUpdateBuilder.UpdateByColumn(datatable, datacolumn)}{Quotes}";
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString};");
usingBlock.Statements.Add($"SetSqlCommandParameter(sqlCommand, {ProperVarName.Get(datatable.TableName.ToLower())});");
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 parameterName = $"{Quotes}@{datacolumn.ColumnName.Replace(" ","")}{Quotes}";
string parameterValue = ProperVarName.Get(datacolumn.ColumnName.ToLower());
string columnName = datacolumn.ColumnName.Contains(" ") ? $"[{datacolumn.ColumnName}]" : datacolumn.ColumnName;
string sqlString = $"{Quotes}{SqlSelectBuilder.CreateSelectAllWhere(datatable, $"{columnName} = @{datacolumn.ColumnName.Replace(" ", "")}")}{Quotes}";
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}");
usingBlock.Statements.Add($"sqlCommand.Parameters.AddWithValue({parameterName}, {parameterValue})");
usingBlock.Statements.Add($"Return ToList(sqlCommand)");
this.Statements.Add(usingBlock.ToString());
}
private void CreateProperties(DataTable dataTable)
{
CSProperty property;
List <CSProperty> properties = new List <CSProperty>();
foreach (DataColumn clm in dataTable.Columns)
{
string typeName = ProperCSTypeName.Get(clm);
string name = ProperVarName.Get(clm.ColumnName);
property = new CSProperty(typeName, name, CSMemberModifier.PublicVirtual);
properties.Add(property);
}
this.Properties = properties;
}
private void ConstructParameter()
{
var type = ProperVBTypeName.Get(datacolumn);
string name = ProperVarName.Get(datacolumn.ColumnName.ToLower());
this.MethodArgs.Add(new VBArgument(type, name));
foreach (DataColumn clm in this.datatable.PrimaryKey)
{
var keyType = ProperVBTypeName.Get(clm);
string keyName = ProperVarName.Get(clm.ColumnName.ToLower());
this.MethodArgs.Add(new VBArgument(keyType, keyName));
}
}
private void CreateProperties(DataTable dataTable)
{
VBProperty property;
List <VBProperty> properties = new List <VBProperty>();
foreach (DataColumn clm in dataTable.Columns)
{
string typeName = ProperVBTypeName.Get(clm);
string name = ProperVarName.Get(clm.ColumnName);
property = new VBProperty(typeName, name, VBMemberModifier.PublicOverridable);
properties.Add(property);
}
this.Properties = properties;
}
private void ConstructBody()
{
foreach (DataColumn clm in this.datatable.Columns)
{
string propName = ProperVarName.Get(clm.ColumnName);
string parameterName = $"{Quotes}@{clm.ColumnName.Replace(" ","")}{Quotes}";
string parameterValue = $"{ProperVarName.Get(datatable.TableName.ToLower())}.{propName}";
if (clm.AllowDBNull)
{
parameterValue += " ?? (object)DBNull.Value";
}
string sqlCommandParameter = $"sqlCommand.Parameters.AddWithValue({parameterName}, {parameterValue});";
Statements.Add(sqlCommandParameter);
}
}
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());
}
private void ConstructBody()
{
VBBlock usingBlock = new VBBlock(VBBlockStatement.Using, "Using sqlCommand As New SqlCommand()");
string sqlString = $"{Quotes}{SqlUpdateBuilder.UpdateColumnByPrimaryKey(datatable, datacolumn)}{Quotes}";
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}");
#region Updated Column
string parameterName = $"{Quotes}@{datacolumn.ColumnName.Replace(" ","")}{Quotes}";
string parameterValue = ProperVarName.Get(datacolumn.ColumnName.ToLower().Replace(" ", ""));
if (datacolumn.AllowDBNull)
{
parameterValue = $"If({parameterValue}, CType(DBNull.Value, Object))";
}
usingBlock.Statements.Add($"sqlCommand.Parameters.AddWithValue({parameterName}, {parameterValue})");
#endregion
#region Primary Key Column
string keyParameterName = string.Empty;
string keyParameterValue = string.Empty;
foreach (DataColumn clm in this.datatable.PrimaryKey)
{
keyParameterName = $"{Quotes}@{clm.ColumnName.Replace(" ", "")}{Quotes}";
keyParameterValue = ProperVarName.Get(clm.ColumnName.ToLower());
if (clm.AllowDBNull)
{
keyParameterValue += " ?? (object)DBNull.Value";
}
usingBlock.Statements.Add($"sqlCommand.Parameters.AddWithValue({keyParameterName}, {keyParameterValue})");
}
#endregion
usingBlock.Statements.Add($"table.DbAccess.Commands.Add(sqlCommand)");
this.Statements.Add(usingBlock.ToString());
}
private void ConstructParameter()
{
this.MethodArgs.Add(new CSArgument("SqlCommand", "sqlCommand"));
this.MethodArgs.Add(new CSArgument(datatable.TableName, ProperVarName.Get(datatable.TableName.ToLower())));
}
