protected override OpResult _Store(SupplierFinanceCharge _obj)
{
if (_obj == null)
{
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.ObjectIsNull, _obj, "SupplierFinanceCharge 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));
if (_obj.SupplierFinanceChargeID == null)
{
_obj.SupplierFinanceChargeID = DbMgr.GetLastInsertID();
}
_obj.FromDb = true;
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Created, _obj));
}
private DbUpdateStatement GetQuery_UpdateQuery(SupplierFinanceCharge _obj)
{
return(DbMgr.CreateUpdateClause("SupplierFinanceCharges", GetFields(_obj), "SupplierFinanceChargeID", _obj.SupplierFinanceChargeID));
}
private DbInsertStatement GetQuery_InsertQuery(SupplierFinanceCharge _obj)
{
Dictionary <string, DbFieldEntry> fields = GetFields(_obj);
return(DbMgr.CreateInsertClause("SupplierFinanceCharges", fields));
}
