public void LogUserSessionRecord(typeModulo Modulo, typeUserActions UserAction, int iduser, string description)
{
string qryIns = "INSERT INTO UserSessionRecords(userID,moduleID,useractionID,timestamp,description) VALUES (@userID,@moduleID, @useractionID, @timestamp, @description)";
SqlConnection conGaribay = new SqlConnection(myConfig.ConnectionInfo);
SqlCommand cmdIns = new SqlCommand(qryIns, conGaribay);
try
{
cmdIns.Parameters.Add("@userID", SqlDbType.Int).Value = iduser;
cmdIns.Parameters.Add("@moduleID", SqlDbType.Int).Value = (int)Modulo;
cmdIns.Parameters.Add("@useractionID", SqlDbType.Int).Value = (int)UserAction;
cmdIns.Parameters.Add("@timestamp", SqlDbType.DateTime).Value = Utils.getNowFormattedDate();
cmdIns.Parameters.Add("@description", SqlDbType.Text).Value = description;
conGaribay.Open();
int numregistros = cmdIns.ExecuteNonQuery();
if (numregistros != 1)
{
throw new Exception(myConfig.StrFromMessages("LOGGERACTIONFAILED"));
}
}
catch (Exception err3)
{
this.LogMessage(Logger.typeLogMessage.CRITICAL, UserAction, iduser, err3.Message, "Error enviado desde LogUserSessionRecords");
}
finally
{
conGaribay.Close();
}
}
public void LogUserSessionRecord(typeModulo Modulo, typeUserActions UserAction, string description)
{
LogUserSessionRecord(Modulo, UserAction, new BasePage().UserID, description);
}
