public List <Contact> GetContacts(DateTime afterDate)
{
using (MyPushNotificationEntities dc = new MyPushNotificationEntities())
{
return(dc.Contacts.Where(a => a.AddedOn > afterDate).OrderByDescending(a => a.AddedOn).ToList());
}
}
public List <ProductList> GetContacts(DateTime afterDate)
{
using (MyPushNotificationEntities dc = new MyPushNotificationEntities())
{
return(dc.ProductLists.Where(a => a.DateTime > afterDate).OrderByDescending(a => a.DateTime).ToList());
}
}
public IPagedList getUltimaNotificacao(int id)
{
using (MyPushNotificationEntities dc = new MyPushNotificationEntities())
{
int tamanhopagina = 10;
int numeroPagina = 1;
var resultado = from a in dc.TbNotificacoes
join b in dc.TbNotificacoesUsuarios on a.cdNotificacao equals b.cdNotificacao
where (b.cdUsuario == id) && (b.stOcultarNotificacao == false)
orderby a.dtCriacao descending
select new
{
a.cdNotificacao,
b.cdNotificacaoUsuario,
a.dsNotificacao,
a.dtCriacao,
a.dsIcone,
b.cdUsuario,
b.dtLeitura,
b.dsURL
};
resultado.Take(1).AsEnumerable().ToList();
return(resultado.ToPagedList(numeroPagina, tamanhopagina));
}
}
public int getTotalNotifications(int id)
{
using (MyPushNotificationEntities dc = new MyPushNotificationEntities())
{
var resultado = from a in dc.TbNotificacoes
join b in dc.TbNotificacoesUsuarios on a.cdNotificacao equals b.cdNotificacao
where (b.cdUsuario == id) && (b.stOcultarNotificacao == false) && (!b.dtLeitura.HasValue)
select new
{
a.cdNotificacao,
b.cdNotificacaoUsuario,
b.dtLeitura
};
return(resultado.Count());
}
}
