/// <summary>
/// <para>Adds a new instance of a <see cref="DbParameter"/> object to the command.</para>
/// </summary>
/// <param name="name"><para>The name of the parameter.</para></param>
/// <param name="direction"><para>One of the <see cref="ParameterDirection"/> values.</para></param>
/// <param name="value"><para>The value of the parameter.</para></param>
public void AddParameter(string name, ParameterDirection direction, object value)
{
var val = value as DBNull;
if (val != null)
{
value = null;
}
var key = name.ToLowerInvariant();
if (_params.ContainsKey(key))
{
_params.Remove(key);
}
_params.Add(name.ToLowerInvariant(), _dbconn.CreateParameter(name, direction, value));
}
public static T Get <T>(Container container, IEntityRequestContext context, IEntityInfo info, string primaryKey, IDBConnection database) where T : class, IEntityIdentity
{
using (Logger.CreateTrace(LoggingBoundaries.ServiceBoundary, typeof(SqlQuery), "Get"))
{
try
{
var view = $"[{info.Module}].[VW_{info.Entity.ToUpperInvariant()}]";
var keyValues = primaryKey.Split('|').ToList();
var keys = new List <string>();
var parameters = new List <DbParameter>();
var idx = 0;
foreach (var property in info.Properties)
{
idx++;
var val = property.Value;
if (!val.IsKey.HasValue || (val.IsKey.HasValue && !val.IsKey.Value))
{
continue;
}
keys.Add($"{property.Key} = @val{idx}");
parameters.Add(database.CreateParameter($"@val{idx}", keyValues[0]));
}
var where = string.Join(" AND ", keys);
using (database)
{
var command = database.CreateCommand($"SELECT * FROM {view} WHERE {where}", CommandType.Text);
foreach (var parameter in parameters)
{
command.AddParameter(parameter);
}
var entity = new Entity();
var factory = container.GetInstance <IEntityCreateFactory>();
T item = factory.CreateNew(info) as T;
command.ExecuteReader(dataReader =>
{
if (!PopulateEntity(item, info, dataReader, true))
{
item = null;
}
});
return(item);
}
}
catch (Exception ex)
{
if (Logger.HandleException(LoggingBoundaries.ServiceBoundary, ex))
{
throw;
}
}
}
return(null);
}