void WriteUpdateByKeyMethod()
{
if (!TableInfo.IsSupportSelectByKey)
{
return;
}
var methodName = "Modify" + CamelCasedTableName;
var typeContractName = TableEntityClassNameForMethodParametersInRepositoryFiles;
var callerMemberPath = $"{FullClassName}.{methodName}";
var updateInfo = UpdateByPrimaryKeyInfoCreator.Create(TableInfo);
file.AppendLine();
file.AppendLine("/// <summary>");
file.AppendLine($"///{Padding.ForComment} Updates only one record by given primary keys.");
file.AppendLine("/// </summary>");
file.AppendLine($"public void {methodName}({typeContractName} {contractParameterName})");
file.OpenBracket();
file.AppendLine($"const string CallerMemberPath = \"{callerMemberPath}\";");
file.AppendLine();
file.AppendLine("if (contract == null)");
file.OpenBracket();
file.AppendLine($"throw new ArgumentNullException(nameof({contractParameterName}));");
file.CloseBracket();
if (updateInfo.SqlParameters.Any())
{
BoaRepositoryFileExporter.WriteDefaultValues(file, Config.DefaultValuesForUpdateByKeyMethod, updateInfo.SqlParameters);
}
var whereParameters = string.Join(", ", updateInfo.WhereParameters.Select(column => $"@{column.ColumnName}: {{contract.{column.ColumnName.ToContractName()}}}"));
file.AppendLine();
file.AppendLine($"var sqlInfo = {sharedRepositoryClassAccessPath}.Update({contractParameterName});");
file.AppendLine();
file.AppendLine("var effectedRowCount = unitOfWork.ExecuteNonQuery(CallerMemberPath, sqlInfo);");
file.AppendLine("if (effectedRowCount != 1)");
file.OpenBracket();
file.AppendLine($"throw new InvalidDataException($\"{{effectedRowCount}} row effected. Effected row count should be 1 when update table {TableInfo.SchemaName}.{TableInfo.TableName}. WhereParameters: {whereParameters} \");");
file.CloseBracket();
file.CloseBracket();
}
void WriteBulkInsertMethod()
{
var typeContractName = TableEntityClassNameForMethodParametersInRepositoryFiles;
var methodName = "Create" + CamelCasedTableName;
var callerMemberPath = $"{FullClassName}.{methodName}";
var insertInfo = new InsertInfoCreator {
ExcludedColumnNames = Config.ExcludedColumnNamesWhenInsertOperation
}.Create(TableInfo);
file.AppendLine("/// <summary>");
file.AppendLine($"///{Padding.ForComment} Inserts new record into table.");
foreach (var sequenceInfo in TableInfo.SequenceList)
{
file.AppendLine($"///{Padding.ForComment} <para>Automatically initialize '{sequenceInfo.TargetColumnName.ToContractName()}' property by using '{sequenceInfo.Name}' sequence.</para>");
}
file.AppendLine("/// </summary>");
file.AppendLine($"public void {methodName}(IList<{typeContractName}> contracts)");
file.OpenBracket();
file.AppendLine($"const string CallerMemberPath = \"{callerMemberPath}\";");
file.AppendLine();
file.AppendLine("if (contracts == null)");
file.OpenBracket();
file.AppendLine("throw new ArgumentNullException(nameof(contracts));");
file.CloseBracket();
foreach (var sequenceInfo in TableInfo.SequenceList)
{
file.AppendLine();
file.OpenBracket();
file.AppendLine($"// Init sequence for {sequenceInfo.TargetColumnName.ToContractName()}");
file.AppendLine($"const string callerMemberPath = \"{callerMemberPath} -> sqlNextSequence -> {sequenceInfo.Name}\";");
file.AppendLine();
file.AppendLine($"var sequenceList = unitOfWork.GetSequenceList(callerMemberPath, \"{sequenceInfo.Name}\", contracts.Count);");
file.AppendLine();
file.AppendLine("for(var i = 0; i < contracts.Count; i++)");
file.OpenBracket();
var columnInfo = TableInfo.Columns.First(x => x.ColumnName == sequenceInfo.TargetColumnName);
if (columnInfo.DotNetType == DotNetTypeName.DotNetInt32 || columnInfo.DotNetType == DotNetTypeName.DotNetInt32Nullable)
{
file.AppendLine($"contracts[i].{sequenceInfo.TargetColumnName.ToContractName()} = Convert.ToInt32(sequenceList[i]);");
}
else if (columnInfo.DotNetType == DotNetTypeName.DotNetStringName)
{
file.AppendLine($"contracts[i].{sequenceInfo.TargetColumnName.ToContractName()} = Convert.ToString(sequenceList[i]);");
}
else
{
file.AppendLine($"contracts[i].{sequenceInfo.TargetColumnName.ToContractName()} = Convert.ToInt64(sequenceList[i]);");
}
file.CloseBracket();
file.CloseBracket();
}
if (insertInfo.SqlParameters.Any())
{
file.AppendLine();
file.AppendLine("foreach( var contract in contracts)");
file.OpenBracket();
BoaRepositoryFileExporter.WriteDefaultValues(file, Config.DefaultValuesForInsertMethod, insertInfo.SqlParameters);
file.CloseBracket();
}
file.AppendLine();
file.AppendLine($"var dt = new DataTable(\"{TableInfo.SchemaName}.{TableInfo.TableName}\");");
foreach (var c in TableInfo.Columns)
{
var dataColumnName = $"\"{c.ColumnName}\"";
if (c.SqlReaderMethod == SqlReaderMethods.GetBooleanNullableValueFromChar)
{
file.AppendLine("dt.Columns.Add(new DataColumn(" + dataColumnName + ", typeof(string)) { AllowDBNull = true});");
}
else if (c.SqlReaderMethod == SqlReaderMethods.GetBooleanValueFromChar)
{
file.AppendLine("dt.Columns.Add(new DataColumn(" + dataColumnName + ", typeof(string)));");
}
else if (c.IsNullable)
{
file.AppendLine("dt.Columns.Add(new DataColumn(" + dataColumnName + ", typeof(" + c.DotNetType.RemoveFromEnd("?") + ")) { AllowDBNull = true});");
}
else
{
file.AppendLine($"dt.Columns.Add({dataColumnName}, typeof({c.DotNetType}));");
}
}
file.AppendLine();
file.AppendLine("foreach (var contract in contracts)");
file.OpenBracket();
file.AppendLine("var dataRow = dt.NewRow();");
file.AppendLine();
foreach (var c in TableInfo.Columns)
{
var propertyName = c.ColumnName.ToContractName();
var dataColumnName = $"\"{c.ColumnName}\"";
if (c.SqlReaderMethod == SqlReaderMethods.GetBooleanValueFromChar)
{
file.AppendLine($"dataRow[{dataColumnName}] = contract.{propertyName} ? \"1\" : \"0\";");
}
else if (c.SqlReaderMethod == SqlReaderMethods.GetBooleanNullableValueFromChar)
{
file.AppendLine($"if (contract.{propertyName} != null)");
file.OpenBracket();
file.AppendLine($"dataRow[{dataColumnName}] = contract.{propertyName}.Value ? \"1\" : \"0\";");
file.CloseBracket();
}
else if (c.IsNullable)
{
file.AppendLine($"if (contract.{propertyName} != null)");
file.OpenBracket();
file.AppendLine($"dataRow[{dataColumnName}] = contract.{propertyName};");
file.CloseBracket();
}
else
{
file.AppendLine($"dataRow[{dataColumnName}] = contract.{propertyName};");
}
}
file.AppendLine("dt.Rows.Add(dataRow);");
file.CloseBracket();
file.AppendLine();
file.AppendLine("unitOfWork.ExecuteBulkInsert(CallerMemberPath, dt);");
file.CloseBracket();
// make override
file.AppendLine();
file.AppendLine($"public void CreateBulk{CamelCasedTableName}(IList<{typeContractName}> contracts)");
file.OpenBracket();
file.AppendLine($"{methodName}(contracts);");
file.CloseBracket();
}
void WriteInsertMethod()
{
var typeContractName = TableEntityClassNameForMethodParametersInRepositoryFiles;
var methodName = "Create" + CamelCasedTableName;
var callerMemberPath = $"{FullClassName}.{methodName}";
var insertInfo = new InsertInfoCreator {
ExcludedColumnNames = Config.ExcludedColumnNamesWhenInsertOperation
}.Create(TableInfo);
file.AppendLine("/// <summary>");
file.AppendLine($"///{Padding.ForComment} Inserts new record into table.");
foreach (var sequenceInfo in TableInfo.SequenceList)
{
file.AppendLine($"///{Padding.ForComment} <para>Automatically initialize '{sequenceInfo.TargetColumnName.ToContractName()}' property by using '{sequenceInfo.Name}' sequence.</para>");
}
file.AppendLine("/// </summary>");
file.AppendLine($"public void {methodName}({typeContractName} {contractParameterName})");
file.OpenBracket();
file.AppendLine($"const string CallerMemberPath = \"{callerMemberPath}\";");
file.AppendLine();
file.AppendLine("if (contract == null)");
file.OpenBracket();
file.AppendLine("throw new ArgumentNullException(nameof(contract));");
file.CloseBracket();
foreach (var sequenceInfo in TableInfo.SequenceList)
{
file.AppendLine();
file.OpenBracket();
file.AppendLine($"// Init sequence for {sequenceInfo.TargetColumnName.ToContractName()}");
file.AppendLine();
file.AppendLine($"const string sqlNextSequence = @\"SELECT NEXT VALUE FOR {sequenceInfo.Name}\";");
file.AppendLine();
file.AppendLine($"const string callerMemberPath = \"{callerMemberPath} -> sqlNextSequence -> {sequenceInfo.Name}\";");
file.AppendLine();
file.AppendLine("var responseSequence = unitOfWork.ExecuteScalar<object>(callerMemberPath, new SqlInfo {CommandText = sqlNextSequence});");
file.AppendLine();
var columnInfo = TableInfo.Columns.First(x => x.ColumnName == sequenceInfo.TargetColumnName);
if (columnInfo.DotNetType == DotNetTypeName.DotNetInt32Nullable)
{
file.AppendLine($"if({contractParameterName}.{sequenceInfo.TargetColumnName.ToContractName()} == null)");
file.OpenBracket();
file.AppendLine($"{contractParameterName}.{sequenceInfo.TargetColumnName.ToContractName()} = Convert.ToInt32(responseSequence);");
file.CloseBracket();
}
else if (columnInfo.DotNetType == DotNetTypeName.DotNetInt32)
{
file.AppendLine($"if({contractParameterName}.{sequenceInfo.TargetColumnName.ToContractName()} == 0)");
file.OpenBracket();
file.AppendLine($"{contractParameterName}.{sequenceInfo.TargetColumnName.ToContractName()} = Convert.ToInt32(responseSequence);");
file.CloseBracket();
}
else if (columnInfo.DotNetType == DotNetTypeName.DotNetStringName)
{
file.AppendLine($"if({contractParameterName}.{sequenceInfo.TargetColumnName.ToContractName()} == null)");
file.OpenBracket();
file.AppendLine($"{contractParameterName}.{sequenceInfo.TargetColumnName.ToContractName()} = Convert.ToString(responseSequence);");
file.CloseBracket();
}
else if (columnInfo.DotNetType == DotNetTypeName.DotNetInt64Nullable)
{
file.AppendLine($"if({contractParameterName}.{sequenceInfo.TargetColumnName.ToContractName()} == null)");
file.OpenBracket();
file.AppendLine($"{contractParameterName}.{sequenceInfo.TargetColumnName.ToContractName()} = Convert.ToInt64(responseSequence);");
file.CloseBracket();
}
else
{
file.AppendLine($"if({contractParameterName}.{sequenceInfo.TargetColumnName.ToContractName()} == 0)");
file.OpenBracket();
file.AppendLine($"{contractParameterName}.{sequenceInfo.TargetColumnName.ToContractName()} = Convert.ToInt64(responseSequence);");
file.CloseBracket();
}
file.CloseBracket();
}
if (insertInfo.SqlParameters.Any())
{
BoaRepositoryFileExporter.WriteDefaultValues(file, Config.DefaultValuesForInsertMethod, insertInfo.SqlParameters);
}
file.AppendLine();
file.AppendLine($"var sqlInfo = {sharedRepositoryClassAccessPath}.Insert({contractParameterName});");
file.AppendLine();
if (TableInfo.HasIdentityColumn)
{
file.AppendLine("var identity = unitOfWork.ExecuteScalar<int>(CallerMemberPath, sqlInfo);");
file.AppendLine();
file.AppendLine($"{contractParameterName}.{TableInfo.IdentityColumn.ColumnName.ToContractName()} = identity;");
}
else
{
file.AppendLine("unitOfWork.ExecuteNonQuery(CallerMemberPath, sqlInfo);");
}
file.CloseBracket();
}
