C# (CSharp) OGen.NTier.UTs.lib.datalayer.DO_User Beispiele

Beispiel #1

        public HowTo_delObject()
        {
//<document>
            long _iduser = 1L;

            OGen.NTier.UTs.lib.datalayer.DO_User _user = new OGen.NTier.UTs.lib.datalayer.DO_User();
            if (_user.getObject(_iduser))
            {
                Console.Write(
                    "deleting user {0} ... ",
                    _user.Fields.Login
                    );

                //--- if parameter not specified uses object property _user.IDUser
                //_user.delObject(_iduser);

                //-- so in the case no need to provide IDUser
                _user.delObject();

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

Beispiel #2

Datei: OGen-NTier__Docs__Develop_HowTo_Read_and_Write_to_DataObject_Properties.cs Projekt: katshann/ogen

		public HowTo_Read_and_Write_to_DataObject_Properties() {
//<document>
OGen.NTier.UTs.lib.datalayer.DO_User _user = new OGen.NTier.UTs.lib.datalayer.DO_User();
_user.Fields.IDUser = 123;
_user.Fields.Login = "******";
_user.Fields.Password = "******";

System.Reflection.PropertyInfo[] _properties
	= typeof(OGen.NTier.UTs.lib.datalayer.proxy.SO_User).GetProperties(
		System.Reflection.BindingFlags.Public |
		System.Reflection.BindingFlags.Instance
	);
for (int _prop = 0; _prop < _properties.Length; _prop++) {
	if (Attribute.IsDefined(
		_properties[_prop],
		typeof(OGen.NTier.lib.datalayer.DOPropertyAttribute)
	)) {
		Console.Write(
			"{0}: ", 
			_properties[_prop].Name
		);
		Attribute[] _attributes = Attribute.GetCustomAttributes(
			_properties[_prop],
			typeof(OGen.NTier.lib.datalayer.DOPropertyAttribute), 
			true
		);
		for (int _att = 0; _att < _attributes.Length; _att++) {
			//if (_attributes[_att].GetType() == typeof(DOPropertyAttribute)) {
			OGen.NTier.lib.datalayer.DOPropertyAttribute _attribute
					= (OGen.NTier.lib.datalayer.DOPropertyAttribute)_attributes[_att];
				Console.Write(
					"name:{0};  isPK:{1};  isIdentity:{2};  DefaultValue:{3};  ",
					_attribute.Name,
					_attribute.isPK,
					_attribute.isIdentity,
					_attribute.DefaultValue
				);
			//}
		}
		Console.Write(
			"value: {0}; ", 
			_properties[_prop].GetValue(_user.Fields, null)
		);
		_properties[_prop].SetValue(
			_user.Fields, 
			Convert.ChangeType(
				456, 
				_properties[_prop].PropertyType
			), 
			null
		);
		Console.WriteLine(
			"new value: {0}", 
			_properties[_prop].GetValue(_user.Fields, null)
		);
	}
}
//</document>
		}

Beispiel #3

Datei: OGen-NTier__Docs__Develop_HowTo_getobject.cs Projekt: katshann/ogen

		public HowTo_getObject() {
//<document>
long _iduser = 1L;

OGen.NTier.UTs.lib.datalayer.DO_User _user = new OGen.NTier.UTs.lib.datalayer.DO_User();
if (_user.getObject(_iduser))
	Console.WriteLine(
	  "user found:\nIDUser = {0}\nLogin = {1}", 
	  _iduser, 
	  _user.Fields.Login
	);
else
	Console.WriteLine("user not found");
_user.Dispose(); _user = null;
//</document>
		}

Beispiel #4

        public HowTo_getObject()
        {
//<document>
            long _iduser = 1L;

            OGen.NTier.UTs.lib.datalayer.DO_User _user = new OGen.NTier.UTs.lib.datalayer.DO_User();
            if (_user.getObject(_iduser))
            {
                Console.WriteLine(
                    "user found:\nIDUser = {0}\nLogin = {1}",
                    _iduser,
                    _user.Fields.Login
                    );
            }
            else
            {
                Console.WriteLine("user not found");
            }
            _user.Dispose(); _user = null;
//</document>
        }

Beispiel #5

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

            OGen.NTier.UTs.lib.datalayer.DO_User _user
                = new OGen.NTier.UTs.lib.datalayer.DO_User();

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

                // 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

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

Beispiel #6

Datei: OGen-NTier__Docs__Develop_HowTo_UseTransactions_inDOs.cs Projekt: katshann/ogen

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

OGen.NTier.UTs.lib.datalayer.DO_User _user 
	= new OGen.NTier.UTs.lib.datalayer.DO_User();

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

	// 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

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

Beispiel #7

Datei: OGen-NTier__Docs__Develop_HowTo_delobject.cs Projekt: katshann/ogen

		public HowTo_delObject() {
//<document>
long _iduser = 1L;

OGen.NTier.UTs.lib.datalayer.DO_User _user = new OGen.NTier.UTs.lib.datalayer.DO_User();
if (_user.getObject(_iduser)) {
	Console.Write(
	  "deleting user {0} ... ",
	  _user.Fields.Login
	);

	//--- if parameter not specified uses object property _user.IDUser
	//_user.delObject(_iduser);

	//-- so in the case no need to provide IDUser
	_user.delObject();

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

Beispiel #8

Datei: OGen-NTier__Docs__Develop_HowTo_UseTransactions_betweenDOs_operations.cs Projekt: 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>
		}

Beispiel #9

        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>
        }

Beispiel #10

        public HowTo_Read_and_Write_to_DataObject_Properties()
        {
//<document>
            OGen.NTier.UTs.lib.datalayer.DO_User _user = new OGen.NTier.UTs.lib.datalayer.DO_User();
            _user.Fields.IDUser   = 123;
            _user.Fields.Login    = "******";
            _user.Fields.Password = "******";

            System.Reflection.PropertyInfo[] _properties
                = typeof(OGen.NTier.UTs.lib.datalayer.proxy.SO_User).GetProperties(
                      System.Reflection.BindingFlags.Public |
                      System.Reflection.BindingFlags.Instance
                      );
            for (int _prop = 0; _prop < _properties.Length; _prop++)
            {
                if (Attribute.IsDefined(
                        _properties[_prop],
                        typeof(OGen.NTier.lib.datalayer.DOPropertyAttribute)
                        ))
                {
                    Console.Write(
                        "{0}: ",
                        _properties[_prop].Name
                        );
                    Attribute[] _attributes = Attribute.GetCustomAttributes(
                        _properties[_prop],
                        typeof(OGen.NTier.lib.datalayer.DOPropertyAttribute),
                        true
                        );
                    for (int _att = 0; _att < _attributes.Length; _att++)
                    {
                        //if (_attributes[_att].GetType() == typeof(DOPropertyAttribute)) {
                        OGen.NTier.lib.datalayer.DOPropertyAttribute _attribute
                            = (OGen.NTier.lib.datalayer.DOPropertyAttribute)_attributes[_att];
                        Console.Write(
                            "name:{0};  isPK:{1};  isIdentity:{2};  DefaultValue:{3};  ",
                            _attribute.Name,
                            _attribute.isPK,
                            _attribute.isIdentity,
                            _attribute.DefaultValue
                            );
                        //}
                    }
                    Console.Write(
                        "value: {0}; ",
                        _properties[_prop].GetValue(_user.Fields, null)
                        );
                    _properties[_prop].SetValue(
                        _user.Fields,
                        Convert.ChangeType(
                            456,
                            _properties[_prop].PropertyType
                            ),
                        null
                        );
                    Console.WriteLine(
                        "new value: {0}",
                        _properties[_prop].GetValue(_user.Fields, null)
                        );
                }
            }
//</document>
        }