public SessionData CreateOrRenewSession(string sessionId,string userName, string fullName, string ipAddress, string hostName)
{
int timeoutMinutes = SessionSettings.GetServiceSetting().SessionTimeout;
DbHelper dbHelper = new DbHelper();
DbCommand command = dbHelper.BuildDbCommand("P_IC_SESSIONS_CREATE_OR_RENEW");
dbHelper.AssignParameterValues(command, sessionId, userName, fullName, DateTime.Now,
DateTime.Now, ipAddress, hostName, timeoutMinutes, DateTime.Now);
dbHelper.ExecuteNonQuery(command);
TimeSpan refreshInterval = new TimeSpan(0, 0, (int)(SessionSettings.GetServiceSetting().RefreshInterval * 60));
TimeSpan timeoutInterval = new TimeSpan(0, 0, (SessionSettings.GetServiceSetting().SessionTimeout * 60));
return new SessionData { SessionID = sessionId, RefreshInterval = refreshInterval, SessionTimeoutInterval = timeoutInterval };
}
public SessionData CheckSessionID(string sessionID, string userName)
{
int timeoutMinutes = SessionSettings.GetServiceSetting().SessionTimeout;
DbHelper dbHelper = new DbHelper();
DbCommand comannd = dbHelper.BuildDbCommand("P_IC_SESSIONS_CHECK_USER_NAME");
dbHelper.AssignParameterValues(comannd, sessionID, userName, timeoutMinutes,DateTime.Now);
dbHelper.ExecuteNonQuery(comannd);
SessionData sessionData = new SessionData();
sessionData.IsKilled = (bool)dbHelper.GetParameterValue(comannd, "p_is_killed");
sessionData.IsSessionMatched = (bool)dbHelper.GetParameterValue(comannd, "p_user_session_matched");
sessionData.IsTimeoutOrInvalid = (bool)dbHelper.GetParameterValue(comannd, "p_is_timeout");
return sessionData;
}
public int InsertarUnElemento(RegistroDeEntidadDeVerificacionProcesado registro)
{
try
{
string sql = string.Empty;
sql = @"INSERT INTO [RegistroEVAutoProcesado]
([Pep]
,[TipoEV]
,[FechaAlta])
VALUES
(@Pep
,@TipoEV
,@FechaAlta)";
DbHelper helper = new DbHelper(NombreCadenaConexion);
DbCommand comando = helper.GetSqlStringCommond(sql);
helper.AddInParameter(comando, "@Pep", registro.Pep);
helper.AddInParameter(comando, "@TipoEV", registro.TipoDeElementoDeVerificacion);
helper.AddInParameter(comando, "@FechaAlta", registro.FechaAlta);
return helper.ExecuteNonQuery(comando);
}
catch (Exception ex)
{
throw _gestorDeError.TratarExcepcion(ex,
ex.ToString(),
"InsertarUnRegistroDeEntidadDeVerificacionProcesado");
}
}
