/// <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__utils.DBConnection_createInstance( DO__utils.DBServerType, DO__utils.DBConnectionstring, DO__utils.DBLogfile ) : dbConnection_in; IDbDataParameter[] _dataparameters = new IDbDataParameter[] { _connection.newDBDataParameter("IDLog_", DbType.Int64, ParameterDirection.InputOutput, IDLog_in, 0), _connection.newDBDataParameter("IFLogtype_", 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("IFErrortype_", 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("IFPermition_", 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.IFLogtype = 0; } else { _output.IFLogtype = (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.IFErrortype_isNull = true; } else { _output.IFErrortype = (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.IFPermition_isNull = true; } else { _output.IFPermition = (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; }
/// <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__utils.DBConnection_createInstance( DO__utils.DBServerType, DO__utils.DBConnectionstring, DO__utils.DBLogfile ) : dbConnection_in; IDbDataParameter[] _dataparameters = new IDbDataParameter[] { _connection.newDBDataParameter("IDLog_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IDLog, 0), _connection.newDBDataParameter("IFLogtype_", DbType.Int32, ParameterDirection.Input, LOG_Log_in.IFLogtype, 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("IFErrortype_", DbType.Int32, ParameterDirection.Input, LOG_Log_in.IFErrortype_isNull ? null : (object)LOG_Log_in.IFErrortype, 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("IFPermition_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IFPermition_isNull ? null : (object)LOG_Log_in.IFPermition, 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; } }
private static SO_LOG_Log[] getRecord( DataTable dataTable_in ) { DataColumn _dc_idlog = null; DataColumn _dc_iflogtype = null; DataColumn _dc_ifuser = null; DataColumn _dc_ifuser__read = null; DataColumn _dc_iferrortype = null; DataColumn _dc_stamp = null; DataColumn _dc_stamp__read = null; DataColumn _dc_message = null; DataColumn _dc_ifpermition = 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_iflogtype = dataTable_in.Columns["IFLogtype"]; _dc_ifuser = dataTable_in.Columns["IFUser"]; _dc_ifuser__read = dataTable_in.Columns["IFUser__read"]; _dc_iferrortype = dataTable_in.Columns["IFErrortype"]; _dc_stamp = dataTable_in.Columns["Stamp"]; _dc_stamp__read = dataTable_in.Columns["Stamp__read"]; _dc_message = dataTable_in.Columns["Message"]; _dc_ifpermition = dataTable_in.Columns["IFPermition"]; _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_iflogtype] == System.DBNull.Value) { _output[r].iflogtype_ = 0; } else { _output[r].iflogtype_ = (int)dataTable_in.Rows[r][_dc_iflogtype]; } 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_iferrortype] == System.DBNull.Value) { _output[r].IFErrortype_isNull = true; } else { _output[r].iferrortype_ = (int)dataTable_in.Rows[r][_dc_iferrortype]; } 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_ifpermition] == System.DBNull.Value) { _output[r].IFPermition_isNull = true; } else { _output[r].ifpermition_ = (long)dataTable_in.Rows[r][_dc_ifpermition]; } 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; }
/// <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> /// <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__utils.DBConnection_createInstance( DO__utils.DBServerType, DO__utils.DBConnectionstring, DO__utils.DBLogfile ) : dbConnection_in; IDbDataParameter[] _dataparameters = new IDbDataParameter[] { _connection.newDBDataParameter("IDLog_", DbType.Int64, ParameterDirection.Output, null, 0), _connection.newDBDataParameter("IFLogtype_", DbType.Int32, ParameterDirection.Input, LOG_Log_in.IFLogtype, 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("IFErrortype_", DbType.Int32, ParameterDirection.Input, LOG_Log_in.IFErrortype_isNull ? null : (object)LOG_Log_in.IFErrortype, 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("IFPermition_", DbType.Int64, ParameterDirection.Input, LOG_Log_in.IFPermition_isNull ? null : (object)LOG_Log_in.IFPermition, 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> /// 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 ); }
public static DataTable getDataTable( SO_LOG_Log[] serializableobjects_in ) { DataTable _output = new DataTable(); DataRow _dr; DataColumn _dc_idlog = new DataColumn("IDLog", typeof(long)); _output.Columns.Add(_dc_idlog); DataColumn _dc_iflogtype = new DataColumn("IFLogtype", typeof(int)); _output.Columns.Add(_dc_iflogtype); DataColumn _dc_ifuser = new DataColumn("IFUser", typeof(long)); _output.Columns.Add(_dc_ifuser); DataColumn _dc_ifuser__read = new DataColumn("IFUser__read", typeof(long)); _output.Columns.Add(_dc_ifuser__read); DataColumn _dc_iferrortype = new DataColumn("IFErrortype", typeof(int)); _output.Columns.Add(_dc_iferrortype); DataColumn _dc_stamp = new DataColumn("Stamp", typeof(DateTime)); _output.Columns.Add(_dc_stamp); DataColumn _dc_stamp__read = new DataColumn("Stamp__read", typeof(DateTime)); _output.Columns.Add(_dc_stamp__read); DataColumn _dc_message = new DataColumn("Message", typeof(string)); _output.Columns.Add(_dc_message); DataColumn _dc_ifpermition = new DataColumn("IFPermition", typeof(long)); _output.Columns.Add(_dc_ifpermition); DataColumn _dc_ifapplication = new DataColumn("IFApplication", typeof(int)); _output.Columns.Add(_dc_ifapplication); DataColumn _dc_ifbrowser__opt = new DataColumn("IFBrowser__OPT", typeof(long)); _output.Columns.Add(_dc_ifbrowser__opt); foreach (SO_LOG_Log _serializableobject in serializableobjects_in) { _dr = _output.NewRow(); _dr[_dc_idlog] = _serializableobject.IDLog; _dr[_dc_iflogtype] = _serializableobject.IFLogtype; _dr[_dc_ifuser] = _serializableobject.IFUser; _dr[_dc_ifuser__read] = _serializableobject.IFUser__read; _dr[_dc_iferrortype] = _serializableobject.IFErrortype; _dr[_dc_stamp] = _serializableobject.Stamp; _dr[_dc_stamp__read] = _serializableobject.Stamp__read; _dr[_dc_message] = _serializableobject.Message; _dr[_dc_ifpermition] = _serializableobject.IFPermition; _dr[_dc_ifapplication] = _serializableobject.IFApplication; _dr[_dc_ifbrowser__opt] = _serializableobject.IFBrowser__OPT; _output.Rows.Add(_dr); } return _output; }
internal static void log( Sessionuser usersession_in, int logtype_in, int errortype_in, long idPermition_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(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.IFLogtype = logtype_in; #region _log.IDErrortype = ...; if (errortype_in == ErrorType.no_error) { _log.IFErrortype_isNull = true; } else { _log.IFErrortype = errortype_in; } #endregion #region _log.IFPermition = ...; if (idPermition_in <= 0) { _log.IFPermition_isNull = true; } else { _log.IFPermition = idPermition_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( "|log type: {0}\n", LogType.Items[logtype_in].Name ) : "", ErrorType.Items.ContainsKey(errortype_in) ? string.Format( "|error type: {0}\n", ErrorType.Items[errortype_in].Name ) : "", !_log.IFUser_isNull ? string.Format( "|user: {0}\n", _log.IFUser.ToString() ) : "", _log.Message ); #endif }