/// <summary> /// Updates LOG_Log values on Database. /// </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> public static void updObject( SO_LOG_Log LOG_Log_in, bool forceUpdate_in ) { updObject( LOG_Log_in, forceUpdate_in, null ); }
/// <summary> /// Inserts LOG_Log values into Database. /// </summary> /// <param name="selectIdentity_in">assign with True if you wish to retrieve insertion sequence/identity seed and with False if not</param> /// <returns>insertion sequence/identity seed</returns> public static long insObject( SO_LOG_Log LOG_Log_in, bool selectIdentity_in ) { return(insObject( LOG_Log_in, selectIdentity_in, null )); }
/// <summary> /// Inserts LOG_Log values into Database. /// </summary> /// <param name="selectIdentity_in">assign with True if you wish to retrieve insertion sequence/identity seed and with 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>insertion sequence/identity seed</returns> public static long insObject( SO_LOG_Log LOG_Log_in, bool selectIdentity_in, DBConnection dbConnection_in ) { 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("IDLog_", DbType.Int64, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("IFType_", DbType.Int32, ParameterDirection.Input, LOG_Log_in.IFType, 0), _connection.newDBDataParameter("IFUser_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IFUser_isNull ? null : (object)LOG_Log_in.IFUser, 0), _connection.newDBDataParameter("IFUser__read_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IFUser__read_isNull ? null : (object)LOG_Log_in.IFUser__read, 0), _connection.newDBDataParameter("IFError_", DbType.Int32, ParameterDirection.Input, LOG_Log_in.IFError_isNull ? null : (object)LOG_Log_in.IFError, 0), _connection.newDBDataParameter("Stamp_", DbType.DateTime, ParameterDirection.Input, LOG_Log_in.Stamp, 0), _connection.newDBDataParameter("Stamp__read_", DbType.DateTime, ParameterDirection.Input, LOG_Log_in.Stamp__read_isNull ? null : (object)LOG_Log_in.Stamp__read, 0), _connection.newDBDataParameter("Message_", DbType.AnsiString, ParameterDirection.Input, LOG_Log_in.Message, 4000), _connection.newDBDataParameter("IFPermission_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IFPermission_isNull ? null : (object)LOG_Log_in.IFPermission, 0), _connection.newDBDataParameter("IFApplication_", DbType.Int32, ParameterDirection.Input, LOG_Log_in.IFApplication_isNull ? null : (object)LOG_Log_in.IFApplication, 0), _connection.newDBDataParameter("IFBrowser__OPT_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IFBrowser__OPT_isNull ? null : (object)LOG_Log_in.IFBrowser__OPT, 0), _connection.newDBDataParameter("SelectIdentity_", DbType.Boolean, ParameterDirection.Input, selectIdentity_in, 1) }; _connection.Execute_SQLFunction( "sp0_LOG_Log_insObject", _dataparameters ); if (dbConnection_in == null) { _connection.Dispose(); } LOG_Log_in.IDLog = (long)_dataparameters[0].Value; LOG_Log_in.HasChanges = false; return(LOG_Log_in.IDLog); }
/// <summary> /// Updates LOG_Log values on Database. /// </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> public static void updObject( SO_LOG_Log LOG_Log_in, bool forceUpdate_in, DBConnection dbConnection_in ) { if (forceUpdate_in || LOG_Log_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("IDLog_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IDLog, 0), _connection.newDBDataParameter("IFType_", DbType.Int32, ParameterDirection.Input, LOG_Log_in.IFType, 0), _connection.newDBDataParameter("IFUser_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IFUser_isNull ? null : (object)LOG_Log_in.IFUser, 0), _connection.newDBDataParameter("IFUser__read_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IFUser__read_isNull ? null : (object)LOG_Log_in.IFUser__read, 0), _connection.newDBDataParameter("IFError_", DbType.Int32, ParameterDirection.Input, LOG_Log_in.IFError_isNull ? null : (object)LOG_Log_in.IFError, 0), _connection.newDBDataParameter("Stamp_", DbType.DateTime, ParameterDirection.Input, LOG_Log_in.Stamp, 0), _connection.newDBDataParameter("Stamp__read_", DbType.DateTime, ParameterDirection.Input, LOG_Log_in.Stamp__read_isNull ? null : (object)LOG_Log_in.Stamp__read, 0), _connection.newDBDataParameter("Message_", DbType.AnsiString, ParameterDirection.Input, LOG_Log_in.Message, 4000), _connection.newDBDataParameter("IFPermission_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IFPermission_isNull ? null : (object)LOG_Log_in.IFPermission, 0), _connection.newDBDataParameter("IFApplication_", DbType.Int32, ParameterDirection.Input, LOG_Log_in.IFApplication_isNull ? null : (object)LOG_Log_in.IFApplication, 0), _connection.newDBDataParameter("IFBrowser__OPT_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IFBrowser__OPT_isNull ? null : (object)LOG_Log_in.IFBrowser__OPT, 0) }; _connection.Execute_SQLFunction( "sp0_LOG_Log_updObject", _dataparameters ); if (dbConnection_in == null) { _connection.Dispose(); } LOG_Log_in.HasChanges = false; } }
/// <summary> /// Selects LOG_Log values from Database and assigns them to the appropriate DO_LOG_Log property. /// </summary> /// <param name="IDLog_in">IDLog</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 LOG_Log doesn't exists at Database</returns> public static SO_LOG_Log getObject( long IDLog_in, DBConnection dbConnection_in ) { SO_LOG_Log _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("IDLog_", DbType.Int64, ParameterDirection.InputOutput, IDLog_in, 0), _connection.newDBDataParameter("IFType_", DbType.Int32, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("IFUser_", DbType.Int64, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("IFUser__read_", DbType.Int64, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("IFError_", DbType.Int32, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("Stamp_", DbType.DateTime, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("Stamp__read_", DbType.DateTime, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("Message_", DbType.AnsiString, ParameterDirection.Output, null, 4000), _connection.newDBDataParameter("IFPermission_", DbType.Int64, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("IFApplication_", DbType.Int32, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("IFBrowser__OPT_", DbType.Int64, ParameterDirection.Output, null, 0) }; _connection.Execute_SQLFunction("sp0_LOG_Log_getObject", _dataparameters); if (dbConnection_in == null) { _connection.Dispose(); } if (_dataparameters[0].Value != DBNull.Value) { _output = new SO_LOG_Log(); if (_dataparameters[0].Value == System.DBNull.Value) { _output.IDLog = 0L; } else { _output.IDLog = (long)_dataparameters[0].Value; } if (_dataparameters[1].Value == System.DBNull.Value) { _output.IFType = 0; } else { _output.IFType = (int)_dataparameters[1].Value; } if (_dataparameters[2].Value == System.DBNull.Value) { _output.IFUser_isNull = true; } else { _output.IFUser = (long)_dataparameters[2].Value; } if (_dataparameters[3].Value == System.DBNull.Value) { _output.IFUser__read_isNull = true; } else { _output.IFUser__read = (long)_dataparameters[3].Value; } if (_dataparameters[4].Value == System.DBNull.Value) { _output.IFError_isNull = true; } else { _output.IFError = (int)_dataparameters[4].Value; } if (_dataparameters[5].Value == System.DBNull.Value) { _output.Stamp = new DateTime(1900, 1, 1); } else { _output.Stamp = (DateTime)_dataparameters[5].Value; } if (_dataparameters[6].Value == System.DBNull.Value) { _output.Stamp__read_isNull = true; } else { _output.Stamp__read = (DateTime)_dataparameters[6].Value; } if (_dataparameters[7].Value == System.DBNull.Value) { _output.Message = string.Empty; } else { _output.Message = (string)_dataparameters[7].Value; } if (_dataparameters[8].Value == System.DBNull.Value) { _output.IFPermission_isNull = true; } else { _output.IFPermission = (long)_dataparameters[8].Value; } if (_dataparameters[9].Value == System.DBNull.Value) { _output.IFApplication_isNull = true; } else { _output.IFApplication = (int)_dataparameters[9].Value; } if (_dataparameters[10].Value == System.DBNull.Value) { _output.IFBrowser__OPT_isNull = true; } else { _output.IFBrowser__OPT = (long)_dataparameters[10].Value; } _output.HasChanges = false; return(_output); } return(null); }
private static SO_LOG_Log[] getRecord( DataTable dataTable_in ) { DataColumn _dc_idlog = null; DataColumn _dc_iftype = null; DataColumn _dc_ifuser = null; DataColumn _dc_ifuser__read = null; DataColumn _dc_iferror = null; DataColumn _dc_stamp = null; DataColumn _dc_stamp__read = null; DataColumn _dc_message = null; DataColumn _dc_ifpermission = null; DataColumn _dc_ifapplication = null; DataColumn _dc_ifbrowser__opt = null; SO_LOG_Log[] _output = new SO_LOG_Log[dataTable_in.Rows.Count]; for (int r = 0; r < dataTable_in.Rows.Count; r++) { if (r == 0) { _dc_idlog = dataTable_in.Columns["IDLog"]; _dc_iftype = dataTable_in.Columns["IFType"]; _dc_ifuser = dataTable_in.Columns["IFUser"]; _dc_ifuser__read = dataTable_in.Columns["IFUser__read"]; _dc_iferror = dataTable_in.Columns["IFError"]; _dc_stamp = dataTable_in.Columns["Stamp"]; _dc_stamp__read = dataTable_in.Columns["Stamp__read"]; _dc_message = dataTable_in.Columns["Message"]; _dc_ifpermission = dataTable_in.Columns["IFPermission"]; _dc_ifapplication = dataTable_in.Columns["IFApplication"]; _dc_ifbrowser__opt = dataTable_in.Columns["IFBrowser__OPT"]; } _output[r] = new SO_LOG_Log(); if (dataTable_in.Rows[r][_dc_idlog] == System.DBNull.Value) { _output[r].IDLog = 0L; } else { _output[r].IDLog = (long)dataTable_in.Rows[r][_dc_idlog]; } if (dataTable_in.Rows[r][_dc_iftype] == System.DBNull.Value) { _output[r].IFType = 0; } else { _output[r].IFType = (int)dataTable_in.Rows[r][_dc_iftype]; } if (dataTable_in.Rows[r][_dc_ifuser] == System.DBNull.Value) { _output[r].IFUser_isNull = true; } else { _output[r].IFUser = (long)dataTable_in.Rows[r][_dc_ifuser]; } if (dataTable_in.Rows[r][_dc_ifuser__read] == System.DBNull.Value) { _output[r].IFUser__read_isNull = true; } else { _output[r].IFUser__read = (long)dataTable_in.Rows[r][_dc_ifuser__read]; } if (dataTable_in.Rows[r][_dc_iferror] == System.DBNull.Value) { _output[r].IFError_isNull = true; } else { _output[r].IFError = (int)dataTable_in.Rows[r][_dc_iferror]; } if (dataTable_in.Rows[r][_dc_stamp] == System.DBNull.Value) { _output[r].Stamp = new DateTime(1900, 1, 1); } else { _output[r].Stamp = (DateTime)dataTable_in.Rows[r][_dc_stamp]; } if (dataTable_in.Rows[r][_dc_stamp__read] == System.DBNull.Value) { _output[r].Stamp__read_isNull = true; } else { _output[r].Stamp__read = (DateTime)dataTable_in.Rows[r][_dc_stamp__read]; } if (dataTable_in.Rows[r][_dc_message] == System.DBNull.Value) { _output[r].Message = string.Empty; } else { _output[r].Message = (string)dataTable_in.Rows[r][_dc_message]; } if (dataTable_in.Rows[r][_dc_ifpermission] == System.DBNull.Value) { _output[r].IFPermission_isNull = true; } else { _output[r].IFPermission = (long)dataTable_in.Rows[r][_dc_ifpermission]; } 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_ifbrowser__opt] == System.DBNull.Value) { _output[r].IFBrowser__OPT_isNull = true; } else { _output[r].IFBrowser__OPT = (long)dataTable_in.Rows[r][_dc_ifbrowser__opt]; } _output[r].HasChanges = false; } return(_output); }
internal static void log( Sessionuser usersession_in, int logtype_in, int errortype_in, long idPermission_in, int idApplication_in, string format_in, params string[] args_in ) { SO_LOG_Log _log = new SO_LOG_Log(); #region _log.Message = ...; _log.Message = string.Format( System.Globalization.CultureInfo.CurrentCulture, format_in, args_in ); if (_log.Message.Length > MessageSize) { _log.Message = _log.Message.Substring(0, MessageSize); } #endregion #region _log.IDUser = ...; if ( (usersession_in == null) || (usersession_in.IDUser <= 0) ) { _log.IFUser_isNull = true; } else { _log.IFUser = usersession_in.IDUser; } #endregion _log.IFType = logtype_in; #region _log.IDError = ...; if (errortype_in == ErrorType.no_error) { _log.IFError_isNull = true; } else { _log.IFError = errortype_in; } #endregion #region _log.IFPermission = ...; if (idPermission_in <= 0) { _log.IFPermission_isNull = true; } else { _log.IFPermission = idPermission_in; } #endregion _log.Stamp = DateTime.Now; _log.IFUser__read_isNull = true; _log.Stamp__read_isNull = true; #region _log.IFApplication = ...; if (idApplication_in <= 0) { _log.IFApplication_isNull = true; } else { _log.IFApplication = idApplication_in; } #endregion DO_LOG_Log.insObject( _log, false, null ); #if DEBUG Console.WriteLine( ".--- Log ---\n{0}{1}{2}|message: {3}\n'-----------", LogType.Items.ContainsKey(logtype_in) ? string.Format( System.Globalization.CultureInfo.CurrentCulture, "|log type: {0}\n", LogType.Items[logtype_in].Name ) : "", ErrorType.Items.ContainsKey(errortype_in) ? string.Format( System.Globalization.CultureInfo.CurrentCulture, "|error type: {0}\n", ErrorType.Items[errortype_in].Name ) : "", !_log.IFUser_isNull ? string.Format( System.Globalization.CultureInfo.CurrentCulture, "|user: {0}\n", _log.IFUser.ToString(System.Globalization.CultureInfo.CurrentCulture) ) : "", _log.Message ); #endif }
public static void MarkRead( string sessionGuid_in, string ip_forLogPurposes_in, int idLog_in, out int[] errors_out ) { List <int> _errorlist = new List <int>(); Guid _sessionguid; Sessionuser _sessionuser; #region check... if (!SBO_CRD_Authentication.isSessionGuid_valid( sessionGuid_in, ip_forLogPurposes_in, out _sessionguid, out _sessionuser, out _errorlist, out errors_out )) { //// no need! //errors_out = _errors.ToArray(); return; } #endregion #region check permissions... if ( !_sessionuser.hasPermission(PermissionType.Log__mark_read) ) { _errorlist.Add(ErrorType.lack_of_permissions); errors_out = _errorlist.ToArray(); return; } #endregion SO_LOG_Log _log = DO_LOG_Log.getObject( idLog_in, null ); if (_log == null) { _errorlist.Add(ErrorType.data__not_found); errors_out = _errorlist.ToArray(); return; } else if ( !_log.IFUser__read_isNull || !_log.Stamp__read_isNull ) { _errorlist.Add(ErrorType.log__already_marked_read); errors_out = _errorlist.ToArray(); return; } else { _log.IFUser__read = _sessionuser.IDUser; _log.Stamp__read = DateTime.Now; DO_LOG_Log.updObject( _log, true, null ); _errorlist.Add(ErrorType.log__marked_read__WARNING); } errors_out = _errorlist.ToArray(); }