public MiscNumber FindBySignatureAndType(string signature, MiscNumber.NumberType type)
{
MiscNumber _obj = null;
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectAll()
.From("NumberGenerator")
.Criteria
.IsEqual("NumberGenerator", "signature", signature)
.IsEqual("NumberGenerator", "type", (int)type);
DbCommand _cmd = CreateDbCommand(clause);
DbDataReader _reader = _cmd.ExecuteReader();
if (_reader.Read())
{
_obj = CreateDbEntity();
LoadFromReader(_obj, _reader);
}
_reader.Close();
_cmd.Dispose();
return(_obj);
}
private OpResult Delete(string signature, MiscNumber.NumberType type)
{
if (!Exists(signature, type))
{
return(OpResult.NotifyDeleteAction(OpResult.ResultStatus.NotExists, null, string.Format("{0} with value {1} does not exist", type, signature)));
}
MiscNumber _obj = FindBySignatureAndType(signature, type);
return(Delete(_obj));
}
public OpResult Store(string signature, MiscNumber.NumberType type)
{
if (Exists(signature, type))
{
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.NotCreatedDue2Exists, null, string.Format("{0} with value {1} is not created as it is already created", type, signature)));
}
MiscNumber _obj = CreateEntity();
_obj.signature = signature;
_obj.type = type;
return(Store(_obj));
}
public bool Exists(string signature, MiscNumber.NumberType type)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("NumberGenerator")
.Criteria
.IsEqual("NumberGenerator", "signature", signature)
.IsEqual("NumberGenerator", "type", (int)type);
return(DbMgr.ExecuteScalarInt(clause) != 0);
}
