protected override void SaveUserSession(UserSession session)
{
using (var cn = new SqlConnection(ConnectionStringAudit))
{
cn.Open();
using (var cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandType = System.Data.CommandType.Text;
if (session.SessionID == 0)
{
cmd.CommandText = @"insert into Security.UserSession
(UserID, RenewalToken, ExpirationDate)
Values (@UserID, @RenewalToken, @ExpirationDate)";
cmd.Parameters.AddWithValue("UserID", session.UserID);
cmd.Parameters.AddWithValue("RenewalToken", session.RenewalToken);
cmd.Parameters.AddWithValue("ExpirationDate", session.ExpirationDate);
}
else
{
cmd.CommandText = @"update Security.UserSession
set ExpirationDate = @ExpirationDate,
RenewedDate = @RenewedDate
where SessionID = @SessionID";
cmd.Parameters.AddWithValue("ExpirationDate", session.ExpirationDate);
cmd.Parameters.AddWithValue("RenewedDate", session.RenewedDate);
cmd.Parameters.AddWithValue("SessionID", session.SessionID);
}
cmd.ExecuteNonQuery();
}
}
}