C# (CSharp) OGen.NTier.UTs.lib.datalayer.DO_Group Examples

Example #1

        public HowTo_updObject()
        {
//<document>
            long _idgroup = 1L;

            OGen.NTier.UTs.lib.datalayer.DO_Group _group = new OGen.NTier.UTs.lib.datalayer.DO_Group();
            if (_group.getObject(_idgroup))
            {
                Console.Write(
                    "updating group name:\nName = {0}\nnew Name = {1} ... ",
                    _group.Fields.Name,
                    _group.Fields.Name = "whatever"
                    );

                // makes no update unless changes have been made,
                // you can force update by sending true parameter
                _group.updObject(false);

                Console.WriteLine("DONE!");
            }
            else
            {
                Console.WriteLine("group not found");
            }
            _group.Dispose(); _group = null;
//</document>
        }

Example #2

File: OGen-NTier__Docs__Develop_HowTo_insObject.cs Project: katshann/ogen

		public HowTo_insObject () {
//<document>
long _idgroup = 0L;

OGen.NTier.UTs.lib.datalayer.DO_Group _group = new OGen.NTier.UTs.lib.datalayer.DO_Group();
_group.Fields.Name = "someGroup";
// assigning selectIdentity parameter to true retrieves Sequence/Identity for IDUser
_idgroup = _group.insObject(true);
_group.Dispose(); _group = null;

Console.WriteLine(
  "group inserted, at:\nIDGroup = {0}", 
  _idgroup
);
//</document>
		}

Example #3

        public HowTo_insObject()
        {
//<document>
            long _idgroup = 0L;

            OGen.NTier.UTs.lib.datalayer.DO_Group _group = new OGen.NTier.UTs.lib.datalayer.DO_Group();
            _group.Fields.Name = "someGroup";
// assigning selectIdentity parameter to true retrieves Sequence/Identity for IDUser
            _idgroup = _group.insObject(true);
            _group.Dispose(); _group = null;

            Console.WriteLine(
                "group inserted, at:\nIDGroup = {0}",
                _idgroup
                );
//</document>
        }

Example #4

File: OGen-NTier__Docs__Develop_HowTo_updobject.cs Project: katshann/ogen

		public HowTo_updObject() {
//<document>
long _idgroup = 1L;

OGen.NTier.UTs.lib.datalayer.DO_Group _group = new OGen.NTier.UTs.lib.datalayer.DO_Group();
if (_group.getObject(_idgroup)) {
	Console.Write(
	  "updating group name:\nName = {0}\nnew Name = {1} ... ",
	  _group.Fields.Name,
	  _group.Fields.Name = "whatever"
	);

	// makes no update unless changes have been made, 
	// you can force update by sending true parameter
	_group.updObject(false);

	Console.WriteLine("DONE!");
} else {
	Console.WriteLine("group not found");
}
_group.Dispose(); _group = null;
//</document>
		}

Example #5

File: OGen-NTier__Docs__Develop_HowTo_UseTransactions_betweenDOs_operations.cs Project: katshann/ogen

		public HowTo_UseTransactions_betweenDOs_operations() {
//<document>
string _testid = DateTime.Now.Ticks.ToString();
bool _constraint;
long _iduser;
long _idgroup;

// we need a shared connection between Data Objects
OGen.lib.datalayer.DBConnection _con = OGen.NTier.UTs.lib.datalayer.DO__utils.DBConnection_createInstance(
	OGen.NTier.UTs.lib.datalayer.DO__utils.DBServerType,
	OGen.NTier.UTs.lib.datalayer.DO__utils.DBConnectionstring, 
	string.Empty
);

// before beginning a transaction we need to open the connection
_con.Open();
try {
	// beginning transaction
	_con.Transaction.Begin();

	// sharing connection with User Data Object
	OGen.NTier.UTs.lib.datalayer.DO_User _user 
		= new OGen.NTier.UTs.lib.datalayer.DO_User(_con);
	// performing some operations on User Data Object
	_user.Fields.Login = _testid;
	_user.Fields.Password = _testid;
	_iduser = _user.insObject(true, out _constraint);
	// handling constraint code should be added here
	_user.Dispose(); _user = null;

	// sharing connection with Group Data Object
	OGen.NTier.UTs.lib.datalayer.DO_Group _group 
		= new OGen.NTier.UTs.lib.datalayer.DO_Group(_con);
	// performing some operations on User Data Object
	_group.Fields.Name = _testid;
	_idgroup = _group.insObject(true);
	_group.Dispose(); _group = null;

	// sharing connection with Group Data Object
	OGen.NTier.UTs.lib.datalayer.DO_UserGroup _usergroup
		= new OGen.NTier.UTs.lib.datalayer.DO_UserGroup(_con);
	// performing some operations on User Data Object
	_usergroup.Fields.IDGroup = _idgroup;
	_usergroup.Fields.IDUser = _iduser;
	_usergroup.Fields.Relationdate = DateTime.Now;
	_usergroup.Fields.Defaultrelation = false;
	_usergroup.setObject(false);
	_usergroup.Dispose(); _usergroup = null;

	// commit transaction
	_con.Transaction.Commit();
} catch (Exception _ex) {
	// rollback transaction
	_con.Transaction.Rollback();
} finally {
	// terminate transaction
	_con.Transaction.Terminate();
}
// closing connection
_con.Close();
_con.Dispose(); _con = null;
//</document>
		}

Example #6

        public HowTo_UseTransactions_betweenDOs_operations()
        {
//<document>
            string _testid = DateTime.Now.Ticks.ToString();
            bool   _constraint;
            long   _iduser;
            long   _idgroup;

// we need a shared connection between Data Objects
            OGen.lib.datalayer.DBConnection _con = OGen.NTier.UTs.lib.datalayer.DO__utils.DBConnection_createInstance(
                OGen.NTier.UTs.lib.datalayer.DO__utils.DBServerType,
                OGen.NTier.UTs.lib.datalayer.DO__utils.DBConnectionstring,
                string.Empty
                );

// before beginning a transaction we need to open the connection
            _con.Open();
            try {
                // beginning transaction
                _con.Transaction.Begin();

                // sharing connection with User Data Object
                OGen.NTier.UTs.lib.datalayer.DO_User _user
                    = new OGen.NTier.UTs.lib.datalayer.DO_User(_con);
                // performing some operations on User Data Object
                _user.Fields.Login    = _testid;
                _user.Fields.Password = _testid;
                _iduser = _user.insObject(true, out _constraint);
                // handling constraint code should be added here
                _user.Dispose(); _user = null;

                // sharing connection with Group Data Object
                OGen.NTier.UTs.lib.datalayer.DO_Group _group
                    = new OGen.NTier.UTs.lib.datalayer.DO_Group(_con);
                // performing some operations on User Data Object
                _group.Fields.Name       = _testid;
                _idgroup                 = _group.insObject(true);
                _group.Dispose(); _group = null;

                // sharing connection with Group Data Object
                OGen.NTier.UTs.lib.datalayer.DO_UserGroup _usergroup
                    = new OGen.NTier.UTs.lib.datalayer.DO_UserGroup(_con);
                // performing some operations on User Data Object
                _usergroup.Fields.IDGroup         = _idgroup;
                _usergroup.Fields.IDUser          = _iduser;
                _usergroup.Fields.Relationdate    = DateTime.Now;
                _usergroup.Fields.Defaultrelation = false;
                _usergroup.setObject(false);
                _usergroup.Dispose(); _usergroup = null;

                // commit transaction
                _con.Transaction.Commit();
            } catch (Exception _ex) {
                // rollback transaction
                _con.Transaction.Rollback();
            } finally {
                // terminate transaction
                _con.Transaction.Terminate();
            }
// closing connection
            _con.Close();
            _con.Dispose(); _con = null;
//</document>
        }