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()))); }