private void DeleteAll <T>(CriteriaNode criteriaNode) where T : new()
{
var deleteSql = ClassConfigContainer.FindDeleteSql(typeof(T));
try
{
Command.Start();
var criterias = criteriaNode.SearchAll();
if (criterias.Count > 0)
{
UpdateCriteria <T>(criterias);
}
if (Shared.IsAuditable <T>())
{
var originalObjects = RetrieveAll <T>(criteriaNode);
var dict = new Dictionary <T, string>();
foreach (var original in originalObjects)
{
string updateSql = ClassConfigContainer.FindUpdateSql1(typeof(T));
var propertyParameters =
ParametersCreator.CreatePropertyParameters(ParameterPrefix,
original, ref updateSql);
string auditText = Auditor.AuditDelete(original, propertyParameters);
dict[original] = auditText;
}
ExecuteNonQuery(deleteSql, criteriaNode);
foreach (var original in originalObjects)
{
InsertAuditRecord(original, DbOperation.Delete, dict[original]);
}
}
else
{
ExecuteNonQuery(deleteSql, criteriaNode);
}
}
catch (Exception ex)
{
throw CreateEasylinkException(deleteSql, ex);
}
}
public void Delete(object obj)
{
if (obj == null)
{
return;
}
var deleteSql = ClassConfigContainer.FindDeleteSql1(obj.GetType());
try
{
Command.Start();
var propertyParameters =
ParametersCreator.CreatePropertyParameters(ParameterPrefix, obj, ref deleteSql);
var sqlParameters = ConvertPropertyParametersToSqlParameters(propertyParameters);
var original = GetOriginal(obj);
ExecuteNonQuery(deleteSql, sqlParameters);
var businessBase = obj as BusinessBase;
if (businessBase != null)
{
businessBase.MarkAsDeleted();
}
if (Shared.IsAuditable(obj))
{
string updateSql = ClassConfigContainer.FindUpdateSql1(obj.GetType());
propertyParameters = ParametersCreator.CreatePropertyParameters(ParameterPrefix,
original, ref updateSql);
string auditText = Auditor.AuditDelete(original, propertyParameters);
InsertAuditRecord(original, DbOperation.Delete, auditText);
}
NullifyIdProperty(obj);
}
catch (Exception ex)
{
throw CreateEasylinkException(deleteSql, ex);
}
}
public void Update(object obj)
{
var id = GetObjectId(obj);
if (id == null || id.ToString() == "0")
{
return;
}
var updateSql = ClassConfigContainer.FindUpdateSql1(obj.GetType());
try
{
Command.Start();
var propertyParameters =
ParametersCreator.CreatePropertyParameters(ParameterPrefix, obj, ref updateSql);
var sqlParameters = ConvertPropertyParametersToSqlParameters(propertyParameters);
var changes = CompareToOriginal(obj, propertyParameters);
if (changes.Keys.Count > 0)
{
ExecuteNonQuery(updateSql, sqlParameters);
if (Shared.IsAuditable(obj))
{
var auditText = Auditor.AuditUpdate(obj, changes);
InsertAuditRecord(obj, DbOperation.Update, auditText);
}
}
}
catch (Exception ex)
{
throw CreateEasylinkException(updateSql, ex);
}
}
