private void WriteGetListBy(IEnumerable <DatabaseColumn> columns)
{
var methodParameters = CodeWriterUtils.GetMethodParametersForColumns(columns, codeWriterSettings);
WriteGetListByMethodSummary(methodParameters);
var methodSignature = CodeWriterUtils.GetGetListByMethodSignature(table, columns, codeWriterSettings, methodParameters);
using (classBuilder.BeginNest($"public {methodSignature}"))
{
CodeWriterUtils.WriteEntryLogging(classBuilder, methodSignature);
var sqlCommandText = ConstructSqlQuery(methodParameters, null, GetAllColumnNames(new List <DatabaseTable> {
table
}));
classBuilder.AppendLine($"var entities = new List<{table.NetName}>();");
WriteBeginCreateConnection();
WriteBeginCreateCommand();
classBuilder.AppendLine($"command.CommandText = {sqlCommandText};");
WriteAddParametersToCommand(methodParameters);
WriteBeginExecuteReader();
WriteBeginReadReaderMultiple();
classBuilder.AppendLine($"var entity = ({table.NetName}){_serviceProviderFieldName}.GetService(typeof({table.NetName}));");
WriteParseEntityFromReader("entity");
classBuilder.AppendLine("entities.Add(entity);");
classBuilder.EndNest();
classBuilder.EndNest();
classBuilder.EndNest();
classBuilder.EndNest();
classBuilder.AppendLine("");
classBuilder.AppendLine("return entities;");
CodeWriterUtils.WriteExitLogging(classBuilder, methodSignature);
}
}
private void WriteGetListCommon(IEnumerable <Parameter> methodParameters, string innerJoinClause, string columnsToReturn)
{
WriteGetListMethodSummary(methodParameters);
var methodSignature = CodeWriterUtils.GetGetListMethodSignature(table, codeWriterSettings, methodParameters);
using (classBuilder.BeginNest($"public {methodSignature}"))
{
CodeWriterUtils.WriteEntryLogging(classBuilder, methodSignature);
var sqlCommandText = ConstructSqlQuery(methodParameters, innerJoinClause, columnsToReturn);
classBuilder.AppendLine($"var entities = new List<{table.NetName}>();");
WriteBeginCreateConnection();
WriteBeginCreateCommand();
classBuilder.AppendLine($"command.CommandText = {sqlCommandText};");
WriteAddParametersToCommand(methodParameters);
WriteBeginExecuteReader();
WriteBeginReadReaderMultiple();
classBuilder.AppendLine($"var entity = ({table.NetName}){_serviceProviderFieldName}.GetService(typeof({table.NetName}));");
WriteParseEntityFromReader("entity");
classBuilder.AppendLine("entities.Add(entity);");
classBuilder.EndNest();
classBuilder.EndNest();
classBuilder.EndNest();
classBuilder.EndNest();
classBuilder.AppendLine("");
classBuilder.AppendLine("return entities;");
CodeWriterUtils.WriteExitLogging(classBuilder, methodSignature);
}
classBuilder.AppendLine("");
}
private void WriteUpdateCommon(IEnumerable <Parameter> methodParameters, string fromClause, string whereClause, string columnsToReturn)
{
var entityParameterSummary = "An entity with updated values.";
var methodParametersWithEntity = CodeWriterUtils.AddEntityParameter(methodParameters, table, entityParameterSummary);
WriteUpdateMethodSummary(methodParametersWithEntity);
var methodSignature = CodeWriterUtils.GetUpdateMethodSignature(table, codeWriterSettings, methodParametersWithEntity);
using (classBuilder.BeginNest($"public {methodSignature}"))
{
CodeWriterUtils.WriteEntryLogging(classBuilder, methodSignature);
WriteGetPropertyColumnPairs();
classBuilder.AppendLine("var setClause = string.Join(\", \", propertyColumnPairs.Select(pcp => $\"{pcp.Value} = @{pcp.Key.Name}\"));");
var thisTableAlias = codeWriterSettings.Namer.NameToAcronym(table.Name);
if (!string.IsNullOrEmpty(fromClause))
{
classBuilder.AppendLine($"var sqlCommandText = $\"UPDATE ONLY \\\"{table.Name}\\\" AS {thisTableAlias} SET {{setClause}} FROM {fromClause} WHERE {whereClause} RETURNING {columnsToReturn};\";");
}
else
{
classBuilder.AppendLine($"var sqlCommandText = $\"UPDATE ONLY \\\"{table.Name}\\\" AS {thisTableAlias} SET {{setClause}} WHERE {whereClause} RETURNING {columnsToReturn};\";");
}
var entityVariableName = "updatedEntity";
classBuilder.AppendLine($"{table.NetName} {entityVariableName} = null;");
WriteBeginCreateConnection();
WriteBeginCreateCommand();
classBuilder.AppendLine($"command.CommandText = sqlCommandText;");
WriteAddParametersToCommand(methodParameters);
WriteAddParametersToCommand();
classBuilder.BeginNest("try");
WriteBeginExecuteReader();
WriteBeginReadReaderSingle();
// TODO: KE - consider throwing here if multiple rows were modified! It should never be the case except for bad data even though the schema allows it
classBuilder.AppendLine($"{entityVariableName} = ({table.NetName}){_serviceProviderFieldName}.GetService(typeof({table.NetName}));");
WriteParseEntityFromReader(entityVariableName);
classBuilder.EndNest();
classBuilder.EndNest();
classBuilder.EndNest();
WriteCatchPostgresExceptions();
classBuilder.EndNest();
classBuilder.EndNest();
WriteReturnEntityIfNotNull(entityVariableName);
CodeWriterUtils.WriteExitLogging(classBuilder, methodSignature);
}
classBuilder.AppendLine("");
}
private void WriteGetCommon(IEnumerable <Parameter> methodParameters, string innerJoinClause, string columnsToReturn)
{
WriteGetMethodSummary(methodParameters);
var methodSignature = CodeWriterUtils.GetGetMethodSignature(table, codeWriterSettings, methodParameters);
using (classBuilder.BeginNest($"public {methodSignature}"))
{
CodeWriterUtils.WriteEntryLogging(classBuilder, methodSignature);
var sqlCommandText = ConstructSqlQuery(methodParameters, innerJoinClause, columnsToReturn);
var entityVariableName = "entity";
classBuilder.AppendLine($"{table.NetName} {entityVariableName} = null;");
WriteBeginCreateConnection();
WriteBeginCreateCommand();
classBuilder.AppendLine($"command.CommandText = {sqlCommandText};");
WriteAddParametersToCommand(methodParameters);
WriteBeginExecuteReader();
WriteBeginReadReaderSingle();
// TODO: KE - discuss the following commented block -- I think this is a good idea for us until our schema is made to match business rules
/*using (cb.BeginNest("if (reader.Read())"))
* {
* cb.AppendLine("throw new InvalidOperationException(\"Multiple rows match the specified criteria.\");");
* }
*
* cb.AppendLine("");*/
classBuilder.AppendLine($"{entityVariableName} = ({table.NetName}){_serviceProviderFieldName}.GetService(typeof({table.NetName}));");
WriteParseEntityFromReader(entityVariableName);
// TODO: KE - parse the org unit information coming back and populate the entity's org unit so that WithCustomerAssetOrganization does not have to be called at the service layer, also need to modify returned columns
classBuilder.EndNest();
classBuilder.EndNest();
classBuilder.EndNest();
classBuilder.EndNest();
WriteReturnEntityIfNotNull(entityVariableName);
CodeWriterUtils.WriteExitLogging(classBuilder, methodSignature);
}
classBuilder.AppendLine("");
}
private void WriteCreate()
{
var methodParameters = CodeWriterUtils.GetCreateMethodParameters(table).ToList();
WriteCreateMethodSummary(methodParameters);
var methodSignature = CodeWriterUtils.GetCreateMethodSignature(table, methodParameters);
using (classBuilder.BeginNest($"public {methodSignature}"))
{
CodeWriterUtils.WriteEntryLogging(classBuilder, methodSignature);
WriteGetPropertyColumnPairs();
classBuilder.AppendLine("var valuesClause = string.Join(\", \", propertyColumnPairs.Keys.Select(k => \"@\" + k.Name));");
var thisTableAlias = codeWriterSettings.Namer.NameToAcronym(table.Name);
classBuilder.AppendLine($"var sqlCommandText = $\"INSERT INTO \\\"{table.Name}\\\" AS {thisTableAlias} ({{string.Join(\", \", propertyColumnPairs.Values)}}) VALUES ({{valuesClause}}) RETURNING {GetAllColumnNames(new List<DatabaseTable> { table })};\";");
var entityVariableName = "createdEntity";
classBuilder.AppendLine($"{table.NetName} {entityVariableName} = null;");
WriteBeginCreateConnection();
WriteBeginCreateCommand();
classBuilder.AppendLine($"command.CommandText = sqlCommandText;");
WriteAddParametersToCommand();
classBuilder.BeginNest("try");
WriteBeginExecuteReader();
WriteBeginReadReaderSingle();
classBuilder.AppendLine($"{entityVariableName} = ({table.NetName}){_serviceProviderFieldName}.GetService(typeof({table.NetName}));");
WriteParseEntityFromReader(entityVariableName);
classBuilder.EndNest();
classBuilder.EndNest();
classBuilder.EndNest();
WriteCatchPostgresExceptions();
classBuilder.EndNest();
classBuilder.EndNest();
WriteReturnEntityIfNotNull(entityVariableName);
CodeWriterUtils.WriteExitLogging(classBuilder, methodSignature);
}
classBuilder.AppendLine("");
}
private void WriteDeleteCommon(IEnumerable <Parameter> methodParameters, bool isLogicalDelete)
{
var partialMethodName = CodeWriterUtils.ConvertParametersToMethodNameByPart(methodParameters, codeWriterSettings);
WriteDeleteMethodSummary(methodParameters);
var methodSignature = CodeWriterUtils.GetDeleteMethodSignature(table, codeWriterSettings, methodParameters);
using (classBuilder.BeginNest($"public {methodSignature}"))
{
CodeWriterUtils.WriteEntryLogging(classBuilder, methodSignature);
if (isLogicalDelete)
{
classBuilder.AppendLine($"var deletedEntity = {CodeWriterUtils.BaseMethodNameDelete}LogicalBy{partialMethodName}({PrintParametersForCall(methodParameters)});");
classBuilder.BeginNest($"if (deletedEntity == null)");
classBuilder.AppendLine($"throw new EntityNotFoundException();");
classBuilder.EndNest();
classBuilder.AppendLine("");
classBuilder.AppendLine("return deletedEntity;");
}
else
{
classBuilder.AppendLine($"int countRowsAffected = {CodeWriterUtils.BaseMethodNameDelete}PhysicalBy{partialMethodName}({PrintParametersForCall(methodParameters)});");
classBuilder.BeginNest("if (countRowsAffected == 0)");
classBuilder.AppendLine("throw new EntityNotFoundException();");
classBuilder.EndNest();
classBuilder.AppendLine("");
classBuilder.BeginNest("if (countRowsAffected != 1)");
classBuilder.AppendLine("throw new Exception(\"Delete affected more than one row.\");");
classBuilder.EndNest();
classBuilder.AppendLine("");
classBuilder.AppendLine("return null;");
}
CodeWriterUtils.WriteExitLogging(classBuilder, methodSignature);
}
}