/// <summary> /// Selects vNET_User values from Database (based on the search condition) and assigns them to the appropriate DO0_vNET_User property. /// </summary> /// <param name="IDUser_search_in">IDUser search condition</param> /// <param name="dbConnection_in">Database connection, making the use of Database Transactions possible on a sequence of operations across the same or multiple DataObjects</param> /// <returns>null if vNET_User doesn't exists at Database</returns> public static SO_vNET_User getObject_byUser( long IDUser_search_in, DBConnection dbConnection_in ) { SO_vNET_User _output = null; DBConnection _connection = (dbConnection_in == null) ? DO__utils.DBConnection_createInstance( DO__utils.DBServerType, DO__utils.DBConnectionstring, DO__utils.DBLogfile ) : dbConnection_in; IDbDataParameter[] _dataparameters = new IDbDataParameter[] { _connection.newDBDataParameter("IDUser_search_", DbType.Int64, ParameterDirection.Input, IDUser_search_in, 0), _connection.newDBDataParameter("IDUser", DbType.Int64, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("IFApplication", DbType.Int32, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("Login", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("Name", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("EMail", DbType.AnsiString, ParameterDirection.Output, null, 255) }; _connection.Execute_SQLFunction( "sp0_vNET_User_getObject_byUser", _dataparameters ); if (dbConnection_in == null) { _connection.Dispose(); } if (_dataparameters[1].Value != DBNull.Value) { _output = new SO_vNET_User(); if (_dataparameters[1].Value == System.DBNull.Value) { _output.IDUser = 0L; } else { _output.IDUser = (long)_dataparameters[1].Value; } if (_dataparameters[2].Value == System.DBNull.Value) { _output.IFApplication_isNull = true; } else { _output.IFApplication = (int)_dataparameters[2].Value; } if (_dataparameters[3].Value == System.DBNull.Value) { _output.Login_isNull = true; } else { _output.Login = (string)_dataparameters[3].Value; } if (_dataparameters[4].Value == System.DBNull.Value) { _output.Name_isNull = true; } else { _output.Name = (string)_dataparameters[4].Value; } if (_dataparameters[5].Value == System.DBNull.Value) { _output.EMail_isNull = true; } else { _output.EMail = (string)_dataparameters[5].Value; } return _output; } return null; }
private static SO_vNET_User[] getRecord( DataTable dataTable_in ) { DataColumn _dc_iduser = null; DataColumn _dc_ifapplication = null; DataColumn _dc_login = null; DataColumn _dc_name = null; DataColumn _dc_email = null; SO_vNET_User[] _output = new SO_vNET_User[dataTable_in.Rows.Count]; for (int r = 0; r < dataTable_in.Rows.Count; r++) { if (r == 0) { _dc_iduser = dataTable_in.Columns["IDUser"]; _dc_ifapplication = dataTable_in.Columns["IFApplication"]; _dc_login = dataTable_in.Columns["Login"]; _dc_name = dataTable_in.Columns["Name"]; _dc_email = dataTable_in.Columns["EMail"]; } _output[r] = new SO_vNET_User(); if (dataTable_in.Rows[r][_dc_iduser] == System.DBNull.Value) { _output[r].iduser_ = 0L; } else { _output[r].iduser_ = (long)dataTable_in.Rows[r][_dc_iduser]; } if (dataTable_in.Rows[r][_dc_ifapplication] == System.DBNull.Value) { _output[r].IFApplication_isNull = true; } else { _output[r].ifapplication_ = (int)dataTable_in.Rows[r][_dc_ifapplication]; } if (dataTable_in.Rows[r][_dc_login] == System.DBNull.Value) { _output[r].Login_isNull = true; } else { _output[r].login_ = (string)dataTable_in.Rows[r][_dc_login]; } if (dataTable_in.Rows[r][_dc_name] == System.DBNull.Value) { _output[r].Name_isNull = true; } else { _output[r].name_ = (string)dataTable_in.Rows[r][_dc_name]; } if (dataTable_in.Rows[r][_dc_email] == System.DBNull.Value) { _output[r].EMail_isNull = true; } else { _output[r].email_ = (string)dataTable_in.Rows[r][_dc_email]; } _output[r].haschanges_ = false; } return _output; }
/// <summary> /// Selects vNET_User values from Database (based on the search condition) and assigns them to the appropriate DO0_vNET_User property. /// </summary> /// <param name="IDUser_search_in">IDUser search condition</param> /// <param name="dbConnection_in">Database connection, making the use of Database Transactions possible on a sequence of operations across the same or multiple DataObjects</param> /// <returns>null if vNET_User doesn't exists at Database</returns> public static SO_vNET_User getObject_byUser( long IDUser_search_in, DBConnection dbConnection_in ) { SO_vNET_User _output = null; DBConnection _connection = (dbConnection_in == null) ? DO__Utilities.DBConnection_createInstance( DO__Utilities.DBServerType, DO__Utilities.DBConnectionstring, DO__Utilities.DBLogfile ) : dbConnection_in; IDbDataParameter[] _dataparameters = new IDbDataParameter[] { _connection.newDBDataParameter("IDUser_search_", DbType.Int64, ParameterDirection.Input, IDUser_search_in, 0), _connection.newDBDataParameter("IDUser", DbType.Int64, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("IFApplication", DbType.Int32, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("Login", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("Name", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("Email", DbType.AnsiString, ParameterDirection.Output, null, 255) }; _connection.Execute_SQLFunction( "sp0_vNET_User_getObject_byUser", _dataparameters ); if (dbConnection_in == null) { _connection.Dispose(); } if (_dataparameters[1].Value != DBNull.Value) { _output = new SO_vNET_User(); if (_dataparameters[1].Value == System.DBNull.Value) { _output.IDUser = 0L; } else { _output.IDUser = (long)_dataparameters[1].Value; } if (_dataparameters[2].Value == System.DBNull.Value) { _output.IFApplication_isNull = true; } else { _output.IFApplication = (int)_dataparameters[2].Value; } if (_dataparameters[3].Value == System.DBNull.Value) { _output.Login = string.Empty; } else { _output.Login = (string)_dataparameters[3].Value; } if (_dataparameters[4].Value == System.DBNull.Value) { _output.Name_isNull = true; } else { _output.Name = (string)_dataparameters[4].Value; } if (_dataparameters[5].Value == System.DBNull.Value) { _output.Email_isNull = true; } else { _output.Email = (string)_dataparameters[5].Value; } return(_output); } return(null); }
public void Bind() { int[] _errors; long _count; SO_vNET_User _user = BusinessInstances.WEB_User.InstanceClient.getObject_details( Utilities.User.SessionGuid, Utilities.ClientIPAddress, this.IDUser, out _errors ); if (!this.Master__base.Error_add(_errors)) { if (_user == null) { Response.Redirect( "CRD_User-list.aspx", true ); return; } this.TXT_Name.Text = _user.Name; this.TXT_LogOn.Text = _user.Login; this.TXT_Email.Text = _user.Email; } SO_vCRD_UserProfile[] _profiles = BusinessInstances.CRD_Profile.InstanceClient.getRecord_ofUserProfile_byUser( Utilities.User.SessionGuid, Utilities.ClientIPAddress, this.IDUser, 0, 0, 0, out _count, out _errors ); if (!this.Master__base.Error_add(_errors)) { Array.Sort( _profiles, delegate( SO_vCRD_UserProfile arg1_in, SO_vCRD_UserProfile arg2_in ) { return(string.Compare( arg1_in.ProfileName, arg2_in.ProfileName, false, System.Globalization.CultureInfo.CurrentCulture )); } ); this.CBL_Profiles.Kick.Bind__arrayOf <long, string>( "", false, _profiles ); this.CBL_Profiles.Kick.SelectedValues__set_arrayOf <long, string, SO_vCRD_UserProfile>( _profiles, delegate( SO_vCRD_UserProfile item_in ) { return(item_in.hasProfile); } ); } }
private static SO_vNET_User[] getRecord( DataTable dataTable_in ) { DataColumn _dc_iduser = null; DataColumn _dc_ifapplication = null; DataColumn _dc_login = null; DataColumn _dc_name = null; DataColumn _dc_email = null; SO_vNET_User[] _output = new SO_vNET_User[dataTable_in.Rows.Count]; for (int r = 0; r < dataTable_in.Rows.Count; r++) { if (r == 0) { _dc_iduser = dataTable_in.Columns["IDUser"]; _dc_ifapplication = dataTable_in.Columns["IFApplication"]; _dc_login = dataTable_in.Columns["Login"]; _dc_name = dataTable_in.Columns["Name"]; _dc_email = dataTable_in.Columns["Email"]; } _output[r] = new SO_vNET_User(); if (dataTable_in.Rows[r][_dc_iduser] == System.DBNull.Value) { _output[r].IDUser = 0L; } else { _output[r].IDUser = (long)dataTable_in.Rows[r][_dc_iduser]; } if (dataTable_in.Rows[r][_dc_ifapplication] == System.DBNull.Value) { _output[r].IFApplication_isNull = true; } else { _output[r].IFApplication = (int)dataTable_in.Rows[r][_dc_ifapplication]; } if (dataTable_in.Rows[r][_dc_login] == System.DBNull.Value) { _output[r].Login = string.Empty; } else { _output[r].Login = (string)dataTable_in.Rows[r][_dc_login]; } if (dataTable_in.Rows[r][_dc_name] == System.DBNull.Value) { _output[r].Name_isNull = true; } else { _output[r].Name = (string)dataTable_in.Rows[r][_dc_name]; } if (dataTable_in.Rows[r][_dc_email] == System.DBNull.Value) { _output[r].Email_isNull = true; } else { _output[r].Email = (string)dataTable_in.Rows[r][_dc_email]; } _output[r].HasChanges = false; } return(_output); }