protected override OpResult _Delete(MiscNumber _obj)
{
if (Exists(_obj))
{
DbDeleteStatement clause = DbMgr.CreateDeleteClause();
clause.DeleteFrom("NumberGenerator").Criteria
.IsEqual("NumberGenerator", "signature", _obj.signature)
.IsEqual("NumberGenerator", "type", (int)_obj.type);
DbMgr.ExecuteNonQuery(clause);
return(OpResult.NotifyDeleteAction(OpResult.ResultStatus.ExistsAndDeleted, _obj));
}
return(OpResult.NotifyDeleteAction(OpResult.ResultStatus.NotExists, _obj, "MiscNumber object does not exists"));
}
protected override OpResult _Store(MiscNumber _obj)
{
if (_obj == null)
{
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.ObjectIsNull, _obj, "MiscNumber object cannot be created as it is null"));
}
if (Exists(_obj))
{
ExecuteNonQuery(GetQuery_UpdateQuery(_obj));
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Updated, _obj));
}
ExecuteNonQuery(GetQuery_InsertQuery(_obj));
_obj.FromDb = true;
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Created, _obj));
}
private DbUpdateStatement GetQuery_UpdateQuery(MiscNumber _obj)
{
return(DbMgr.CreateUpdateClause("NumberGenerator", GetFields(_obj), "ID", _obj.ID));
}
private DbInsertStatement GetQuery_InsertQuery(MiscNumber _obj)
{
Dictionary <string, DbFieldEntry> fields = GetFields(_obj);
return(DbMgr.CreateInsertClause("NumberGenerator", fields));
}
