/// <summary> /// Selects NET_User values from Database and assigns them to the appropriate DO_NET_User property. /// </summary> /// <param name="IFUser_in">IFUser</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 NET_User doesn't exists at Database</returns> public static SO_NET_User getObject( long IFUser_in, DBConnection dbConnection_in ) { SO_NET_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("IFUser_", DbType.Int64, ParameterDirection.InputOutput, IFUser_in, 0), _connection.newDBDataParameter("Name_", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("EMail_", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("EMail_verify_", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("IFApplication_", DbType.Int32, ParameterDirection.Output, null, 0) }; _connection.Execute_SQLFunction("sp0_NET_User_getObject", _dataparameters); if (dbConnection_in == null) { _connection.Dispose(); } if (_dataparameters[0].Value != DBNull.Value) { _output = new SO_NET_User(); if (_dataparameters[0].Value == System.DBNull.Value) { _output.IFUser = 0L; } else { _output.IFUser = (long)_dataparameters[0].Value; } if (_dataparameters[1].Value == System.DBNull.Value) { _output.Name_isNull = true; } else { _output.Name = (string)_dataparameters[1].Value; } if (_dataparameters[2].Value == System.DBNull.Value) { _output.EMail = string.Empty; } else { _output.EMail = (string)_dataparameters[2].Value; } if (_dataparameters[3].Value == System.DBNull.Value) { _output.EMail_verify_isNull = true; } else { _output.EMail_verify = (string)_dataparameters[3].Value; } if (_dataparameters[4].Value == System.DBNull.Value) { _output.IFApplication_isNull = true; } else { _output.IFApplication = (int)_dataparameters[4].Value; } _output.haschanges_ = false; return _output; } return null; }
/// <summary> /// Inserts/Updates NET_User values into/on Database. Inserts if NET_User doesn't exist or Updates if NET_User already exists. /// </summary> /// <param name="forceUpdate_in">assign with True if you wish to force an Update (even if no changes have been made since last time getObject method was run) and False if not</param> /// <returns>True if it didn't exist (INSERT), and False if it did exist (UPDATE)</returns> public static bool setObject( SO_NET_User NET_User_in, bool forceUpdate_in, out bool ConstraintExist_out ) { return(setObject( NET_User_in, forceUpdate_in, out ConstraintExist_out, null )); }
/// <summary> /// Inserts/Updates NET_User values into/on Database. Inserts if NET_User doesn't exist or Updates if NET_User already exists. /// </summary> /// <param name="forceUpdate_in">assign with True if you wish to force an Update (even if no changes have been made since last time getObject method was run) and False if not</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>True if it didn't exist (INSERT), and False if it did exist (UPDATE)</returns> public static bool setObject( SO_NET_User NET_User_in, bool forceUpdate_in, out bool ConstraintExist_out, DBConnection dbConnection_in ) { if (forceUpdate_in || NET_User_in.HasChanges) { 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("IFUser_", DbType.Int64, ParameterDirection.Input, NET_User_in.IFUser, 0), _connection.newDBDataParameter("Name_", DbType.AnsiString, ParameterDirection.Input, NET_User_in.Name_isNull ? null : (object)NET_User_in.Name, 255), _connection.newDBDataParameter("Email_", DbType.AnsiString, ParameterDirection.Input, NET_User_in.Email, 255), _connection.newDBDataParameter("Email_verify_", DbType.AnsiString, ParameterDirection.Input, NET_User_in.Email_verify_isNull ? null : (object)NET_User_in.Email_verify, 255), _connection.newDBDataParameter("IFApplication_", DbType.Int32, ParameterDirection.Input, NET_User_in.IFApplication_isNull ? null : (object)NET_User_in.IFApplication, 0), //_connection.newDBDataParameter("Exists", DbType.Boolean, ParameterDirection.Output, 0, 1), //_connection.newDBDataParameter("ConstraintExist", DbType.Boolean, ParameterDirection.Output, 0, 1) _connection.newDBDataParameter("Output_", DbType.Int32, ParameterDirection.Output, null, 0) }; _connection.Execute_SQLFunction( "sp0_NET_User_setObject", _dataparameters ); if (dbConnection_in == null) { _connection.Dispose(); } ConstraintExist_out = (((int)_dataparameters[5].Value & 2) == 1); if (!ConstraintExist_out) { NET_User_in.HasChanges = false; } return(((int)_dataparameters[5].Value & 1) != 1); } else { ConstraintExist_out = false; return(false); } }
public void Bind() { if (!Utilities.User.IsLoggedIn) { Response.Redirect( "~/Registration.aspx", true ); return; } int[] _errors; SO_NET_User _user = WEB_User.InstanceClient.getObject( Utilities.User.SessionGuid, Utilities.ClientIPAddress, Utilities.User.IDUser, out _errors ); if (!this.Master__base.Error_add(_errors)) { this.TXT_Name.Text = this.HFI_Name.Value = _user.Name; this.TXT_LogOn.Text = this.HFI_LogOn.Value = Utilities.User.Login; this.TXT_Email.Text = this.HFI_Email.Value = _user.Email; } else { this.TXT_Name.Text = this.HFI_Name.Value = ""; this.TXT_LogOn.Text = this.HFI_LogOn.Value = ""; this.TXT_Email.Text = this.HFI_Email.Value = ""; } }
private static SO_NET_User[] getRecord( DataTable dataTable_in ) { DataColumn _dc_ifuser = null; DataColumn _dc_name = null; DataColumn _dc_email = null; DataColumn _dc_email_verify = null; DataColumn _dc_ifapplication = null; SO_NET_User[] _output = new SO_NET_User[dataTable_in.Rows.Count]; for (int r = 0; r < dataTable_in.Rows.Count; r++) { if (r == 0) { _dc_ifuser = dataTable_in.Columns["IFUser"]; _dc_name = dataTable_in.Columns["Name"]; _dc_email = dataTable_in.Columns["EMail"]; _dc_email_verify = dataTable_in.Columns["EMail_verify"]; _dc_ifapplication = dataTable_in.Columns["IFApplication"]; } _output[r] = new SO_NET_User(); if (dataTable_in.Rows[r][_dc_ifuser] == System.DBNull.Value) { _output[r].ifuser_ = 0L; } else { _output[r].ifuser_ = (long)dataTable_in.Rows[r][_dc_ifuser]; } 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_ = string.Empty; } else { _output[r].email_ = (string)dataTable_in.Rows[r][_dc_email]; } if (dataTable_in.Rows[r][_dc_email_verify] == System.DBNull.Value) { _output[r].EMail_verify_isNull = true; } else { _output[r].email_verify_ = (string)dataTable_in.Rows[r][_dc_email_verify]; } 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]; } _output[r].haschanges_ = false; } return _output; }
/// <summary> /// Inserts/Updates NET_User values into/on Database. Inserts if NET_User doesn't exist or Updates if NET_User already exists. /// </summary> /// <param name="forceUpdate_in">assign with True if you wish to force an Update (even if no changes have been made since last time getObject method was run) and False if not</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>True if it didn't exist (INSERT), and False if it did exist (UPDATE)</returns> public static bool setObject( SO_NET_User NET_User_in, bool forceUpdate_in, out bool ConstraintExist_out, DBConnection dbConnection_in ) { if (forceUpdate_in || NET_User_in.haschanges_) { 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("IFUser_", DbType.Int64, ParameterDirection.Input, NET_User_in.IFUser, 0), _connection.newDBDataParameter("Name_", DbType.AnsiString, ParameterDirection.Input, NET_User_in.Name_isNull ? null : (object)NET_User_in.Name, 255), _connection.newDBDataParameter("EMail_", DbType.AnsiString, ParameterDirection.Input, NET_User_in.EMail, 255), _connection.newDBDataParameter("EMail_verify_", DbType.AnsiString, ParameterDirection.Input, NET_User_in.EMail_verify_isNull ? null : (object)NET_User_in.EMail_verify, 255), _connection.newDBDataParameter("IFApplication_", DbType.Int32, ParameterDirection.Input, NET_User_in.IFApplication_isNull ? null : (object)NET_User_in.IFApplication, 0), //_connection.newDBDataParameter("Exists", DbType.Boolean, ParameterDirection.Output, 0, 1), //_connection.newDBDataParameter("ConstraintExist", DbType.Boolean, ParameterDirection.Output, 0, 1) _connection.newDBDataParameter("Output_", DbType.Int32, ParameterDirection.Output, null, 0) }; _connection.Execute_SQLFunction( "sp0_NET_User_setObject", _dataparameters ); if (dbConnection_in == null) { _connection.Dispose(); } ConstraintExist_out = (((int)_dataparameters[5].Value & 2) == 1); if (!ConstraintExist_out) { NET_User_in.haschanges_ = false; } return (((int)_dataparameters[5].Value & 1) != 1); } else { ConstraintExist_out = false; return false; } }
/// <summary> /// Inserts/Updates NET_User values into/on Database. Inserts if NET_User doesn't exist or Updates if NET_User already exists. /// </summary> /// <param name="forceUpdate_in">assign with True if you wish to force an Update (even if no changes have been made since last time getObject method was run) and False if not</param> /// <returns>True if it didn't exist (INSERT), and False if it did exist (UPDATE)</returns> public static bool setObject( SO_NET_User NET_User_in, bool forceUpdate_in, out bool ConstraintExist_out ) { return setObject( NET_User_in, forceUpdate_in, out ConstraintExist_out, null ); }
/// <summary> /// Selects NET_User values from Database (based on the search condition) and assigns them to the appropriate DO0_NET_User property. /// </summary> /// <param name="Email_verify_search_in">Email_verify search condition</param> /// <param name="IDApplication_search_in">IDApplication 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 NET_User doesn't exists at Database</returns> public static SO_NET_User getObject_byEmail_verify( string Email_verify_search_in, int IDApplication_search_in, DBConnection dbConnection_in ) { SO_NET_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("Email_verify_search_", DbType.AnsiString, ParameterDirection.Input, Email_verify_search_in, 255), _connection.newDBDataParameter("IDApplication_search_", DbType.Int32, ParameterDirection.Input, IDApplication_search_in, 0), _connection.newDBDataParameter("IFUser", DbType.Int64, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("Name", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("Email", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("Email_verify", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("IFApplication", DbType.Int32, ParameterDirection.Output, null, 0) }; _connection.Execute_SQLFunction( "sp0_NET_User_getObject_byEmail_verify", _dataparameters ); if (dbConnection_in == null) { _connection.Dispose(); } if (_dataparameters[2].Value != DBNull.Value) { _output = new SO_NET_User(); if (_dataparameters[2].Value == System.DBNull.Value) { _output.IFUser = 0L; } else { _output.IFUser = (long)_dataparameters[2].Value; } if (_dataparameters[3].Value == System.DBNull.Value) { _output.Name_isNull = true; } else { _output.Name = (string)_dataparameters[3].Value; } if (_dataparameters[4].Value == System.DBNull.Value) { _output.Email = string.Empty; } else { _output.Email = (string)_dataparameters[4].Value; } if (_dataparameters[5].Value == System.DBNull.Value) { _output.Email_verify_isNull = true; } else { _output.Email_verify = (string)_dataparameters[5].Value; } if (_dataparameters[6].Value == System.DBNull.Value) { _output.IFApplication_isNull = true; } else { _output.IFApplication = (int)_dataparameters[6].Value; } return _output; } return null; }
private static SO_NET_User[] getRecord( DataTable dataTable_in ) { DataColumn _dc_ifuser = null; DataColumn _dc_name = null; DataColumn _dc_email = null; DataColumn _dc_email_verify = null; DataColumn _dc_ifapplication = null; SO_NET_User[] _output = new SO_NET_User[dataTable_in.Rows.Count]; for (int r = 0; r < dataTable_in.Rows.Count; r++) { if (r == 0) { _dc_ifuser = dataTable_in.Columns["IFUser"]; _dc_name = dataTable_in.Columns["Name"]; _dc_email = dataTable_in.Columns["Email"]; _dc_email_verify = dataTable_in.Columns["Email_verify"]; _dc_ifapplication = dataTable_in.Columns["IFApplication"]; } _output[r] = new SO_NET_User(); if (dataTable_in.Rows[r][_dc_ifuser] == System.DBNull.Value) { _output[r].IFUser = 0L; } else { _output[r].IFUser = (long)dataTable_in.Rows[r][_dc_ifuser]; } 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 = string.Empty; } else { _output[r].Email = (string)dataTable_in.Rows[r][_dc_email]; } if (dataTable_in.Rows[r][_dc_email_verify] == System.DBNull.Value) { _output[r].Email_verify_isNull = true; } else { _output[r].Email_verify = (string)dataTable_in.Rows[r][_dc_email_verify]; } 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]; } _output[r].HasChanges = false; } return(_output); }
/// <summary> /// Selects NET_User values from Database and assigns them to the appropriate DO_NET_User property. /// </summary> /// <param name="IFUser_in">IFUser</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 NET_User doesn't exists at Database</returns> public static SO_NET_User getObject( long IFUser_in, DBConnection dbConnection_in ) { SO_NET_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("IFUser_", DbType.Int64, ParameterDirection.InputOutput, IFUser_in, 0), _connection.newDBDataParameter("Name_", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("Email_", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("Email_verify_", DbType.AnsiString, ParameterDirection.Output, null, 255), _connection.newDBDataParameter("IFApplication_", DbType.Int32, ParameterDirection.Output, null, 0) }; _connection.Execute_SQLFunction("sp0_NET_User_getObject", _dataparameters); if (dbConnection_in == null) { _connection.Dispose(); } if (_dataparameters[0].Value != DBNull.Value) { _output = new SO_NET_User(); if (_dataparameters[0].Value == System.DBNull.Value) { _output.IFUser = 0L; } else { _output.IFUser = (long)_dataparameters[0].Value; } if (_dataparameters[1].Value == System.DBNull.Value) { _output.Name_isNull = true; } else { _output.Name = (string)_dataparameters[1].Value; } if (_dataparameters[2].Value == System.DBNull.Value) { _output.Email = string.Empty; } else { _output.Email = (string)_dataparameters[2].Value; } if (_dataparameters[3].Value == System.DBNull.Value) { _output.Email_verify_isNull = true; } else { _output.Email_verify = (string)_dataparameters[3].Value; } if (_dataparameters[4].Value == System.DBNull.Value) { _output.IFApplication_isNull = true; } else { _output.IFApplication = (int)_dataparameters[4].Value; } _output.HasChanges = false; return(_output); } return(null); }