public int GetPageCount(MessageFolders messageFolder, Int32 RecipientAccountID)
{
int result = 0;
using (SPKTDataContext dc = conn.GetContext())
{
result = ((from r in dc.MessageRecipients
where r.AccountID == RecipientAccountID &&
r.MessageFolderID == (int)messageFolder
select r).Count());
}
if (result < 10)
{
result = 1;
}
else
{
if (result % 10 == 0)
{
result = result / 10;
}
else
{
result = (result / 10) + 1;
}
}
return(result);
}
public void DisplayPageNavigation(Int32 PageCount, MessageFolders folder, Int32 CurrentPage)
{
if (PageCount == CurrentPage)
{
linkNext.Visible = false;
HyperLink_BootomNext.Visible = false;
}
if (CurrentPage == 1)
{
linkPrevious.Visible = false;
HyperLink_BootomNPrev.Visible = false;
}
linkNext.NavigateUrl = "~/mail/default.aspx?folder=" + ((int)folder).ToString() + "&PageNumber=" +
(CurrentPage + 1).ToString();
linkPrevious.NavigateUrl = "~/mail/default.aspx?folder=" + ((int)folder).ToString() + "&PageNumber=" +
(CurrentPage - 1).ToString();
HyperLink_BootomNext.NavigateUrl = "~/mail/default.aspx?folder=" + ((int)folder).ToString() + "&PageNumber=" +
(CurrentPage + 1).ToString();
HyperLink_BootomNPrev.NavigateUrl = "~/mail/default.aspx?folder=" + ((int)folder).ToString() + "&PageNumber=" +
(CurrentPage - 1).ToString();
for (int i = 1; i <= PageCount; i++)
{
HyperLink link = new HyperLink();
link.Text = i.ToString();
link.NavigateUrl = "~/mail/default.aspx?folder=" + ((int)folder).ToString() + "&PageNumber=" + i.ToString();
//phPages.Controls.Add(link);
//phPages.Controls.Add(new LiteralControl(" "));
}
}
public static List<MessageWithRecipient> GetMessageByAccountID(Int64 AccountID, Int32 PageNumber, MessageFolders Folder)
{
var query = (from r in MessageRecipient.All()
join m in Messages.All() on r.MessageID equals m.MessageID
join a in Account.All() on m.SentByAccountID equals a.AccountID
where r.AccountID == AccountID && r.MessageFolderID == (int)Folder
orderby m.CreateDate descending
select new
{
Sender = a,
Message = m,
MessageRecipient = r
}).Skip((PageNumber - 1) * 10).Take(10);
List<MessageWithRecipient> list = new List<MessageWithRecipient>();
foreach (var item in query)
{
MessageWithRecipient m = new MessageWithRecipient();
m.Sender = item.Sender;
m.Message = item.Message;
m.MessageRecipient = item.MessageRecipient;
list.Add(m);
}
return list;
}
public List<MessageWithRecipient> GetMessagesByAccountID(Int32 AccountID, Int32 PageNumber, MessageFolders Folder)
{
List<MessageWithRecipient> result = new List<MessageWithRecipient>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable<MessageWithRecipient> messages = (from r in dc.MessageRecipients
join m in dc.Messages on r.MessageID equals m.MessageID
join a in dc.Accounts on m.SendByAccountID equals a.AccountID
where r.AccountID == AccountID && r.MessageFolderID == (int)Folder
orderby m.CreateDate descending
select new MessageWithRecipient()
{
Sender = a,
Message = m,
MessageRecipient = r
}).Skip((PageNumber - 1) * 10).Take(10);
result = messages.ToList();
}
return result;
}
public static int GetPageCount(MessageFolders messageFolder, Int32 RecipientAccountID)
{
int pagecount = 0;
int result = (from r in MessageRecipient.All()
where r.AccountID == RecipientAccountID && r.MessageFolderID == (int)messageFolder
select r).Count();
if (result < 10)
pagecount = 1;
else
{
if (result % 10 == 0)
pagecount = result / 10;
else
{
if ((result / 10) < 1)
pagecount = 1;
else
pagecount = (result / 10) + 1;
}
}
return pagecount;
}
public List <MessageWithRecipient> GetMessagesByAccountID(Int32 AccountID, Int32 PageNumber, MessageFolders Folder)
{
List <MessageWithRecipient> result = new List <MessageWithRecipient>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable <MessageWithRecipient> messages = (from r in dc.MessageRecipients
join m in dc.Messages on r.MessageID equals m.MessageID
join a in dc.Accounts on m.SendByAccountID equals a.AccountID
where r.AccountID == AccountID && r.MessageFolderID == (int)Folder
orderby m.CreateDate descending
select new MessageWithRecipient()
{
Sender = a,
Message = m,
MessageRecipient = r
}).Skip((PageNumber - 1) * 10).Take(10);
result = messages.ToList();
}
return(result);
}
public int GetPageCount(MessageFolders messageFolder, Int32 RecipientAccountID)
{
int result = 0;
using (SPKTDataContext dc = conn.GetContext())
{
result = ((from r in dc.MessageRecipients
where r.AccountID == RecipientAccountID &&
r.MessageFolderID == (int)messageFolder
select r).Count());
}
if (result < 10)
result = 1;
else
{
if (result % 10 == 0)
result = result / 10;
else
result = (result / 10) + 1;
}
return result;
}
