/// <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();
}
