public List <Classes.SSOMessage> GetMessages(int fromIndex, int maxRecords)
{
if (SSOHelper.CurrentIdentity != null)
{
using (Data.DataContext dataContext = SSOHelper.GetDataContext())
{
List <Classes.SSOMessage> messages;
DateTime?timeStamp = dataContext.hsp_Common_LastUpdated("SSO_Messages_States"); /* Consulta esta tabla porque cambia más frecuentemente que SSO_Messages */
if (HttpContext.Current.Cache[String.Format("SSO_Messages_Timestamp_{0}", SSOHelper.CurrentIdentity.Id)] as DateTime? != timeStamp)
{
messages = (from r in dataContext.SSO_Messages
join t in dataContext.SSO_Messages_Targets on r.id equals t.idMessage
where (!r.expiresOn.HasValue || (r.expiresOn.HasValue && r.expiresOn >= DateTime.Now.Date)) &&
r.SSO_Messages_Notifications.Count(n => n.notificationType == (int)SSOMessageNotification.Intranet) > 0 &&
((t.targetType == (int)SSOMessageTarget.User && t.target == SSOHelper.CurrentIdentity.Id) ||
(t.targetType == (int)SSOMessageTarget.Role && dataContext.SSO_UserInRole(SSOHelper.CurrentIdentity.Id, t.target) > 0)) &&
((from s in dataContext.SSO_Messages_States where s.idMessage == r.id && s.idUser == SSOHelper.CurrentIdentity.Id && s.idState == (int)SSOMessageState.Sent || (s.idState == (int)SSOMessageState.RememberOn && s.rememberOn <= DateTime.Now) select s).Count() > 0)
orderby r.date descending
select new Classes.SSOMessage {
id = r.id, message = r.message, type = r.type, date = r.date
}).Distinct().Take(2).ToList(); /* Guarda en caché sólo 10. Este número debe ser siempre >= al número esperado de mensajes 'maxRecords'. */
HttpContext.Current.Cache[String.Format("SSO_Messages_List_{0}", SSOHelper.CurrentIdentity.Id)] = messages;
HttpContext.Current.Cache[String.Format("SSO_Messages_Timestamp_{0}", SSOHelper.CurrentIdentity.Id)] = timeStamp;
}
else
{
messages = HttpContext.Current.Cache[String.Format("SSO_Messages_List_{0}", SSOHelper.CurrentIdentity.Id)] as List <Classes.SSOMessage>;
}
if (maxRecords == 0)
{
return(messages.Where(m => m.id > fromIndex).ToList());
}
else
{
return(messages.Where(m => m.id > fromIndex).Take(maxRecords).ToList());
}
//return (from m in messages where m.id > fromIndex select m).Take(maxRecords);
}
}
else
{
return(null);
}
}