public List <PrivateChatMessage> GetPrivateMessage(string fromid, string toid, int take)
{
ChatPrivateMessageMasterRepository <ChatPrivateMessageMaster> chpmm = new ChatPrivateMessageMasterRepository <ChatPrivateMessageMaster>();
ChatPrivateMessageDetailsRepository <ChatPrivateMessageDetails> chpmd = new ChatPrivateMessageDetailsRepository <ChatPrivateMessageDetails>();
//using (Surajit_TestEntities dc = new Surajit_TestEntities())
//{
List <PrivateChatMessage> msg = new List <PrivateChatMessage>();
var v = (from a in chpmm.GetList().ToList()
join b in chpmd.GetList().ToList() on a.EmailID equals b.MasterEmailID into cc
from c in cc
where (c.MasterEmailID.Equals(fromid) && c.ChatToEmailID.Equals(toid)) || (c.MasterEmailID.Equals(toid) && c.ChatToEmailID.Equals(fromid))
orderby c.Id descending
select new
{
UserName = a.UserName,
Message = c.Message,
ID = c.Id
}).Take(take).ToList();
v = v.OrderBy(s => s.ID).ToList();
foreach (var a in v)
{
var res = new PrivateChatMessage()
{
userName = a.UserName,
message = a.Message
};
msg.Add(res);
}
return(msg);
//}
}
public List <PrivateChatMessage> GetScrollingChatData(string fromid, string toid, int start = 10, int length = 1)
{
takeCounter = (length * start); // 20
skipCounter = ((length - 1) * start); // 10
ChatPrivateMessageMasterRepository <ChatPrivateMessageMaster> chpmm = new ChatPrivateMessageMasterRepository <ChatPrivateMessageMaster>();
ChatPrivateMessageDetailsRepository <ChatPrivateMessageDetails> chpmd = new ChatPrivateMessageDetailsRepository <ChatPrivateMessageDetails>();
//using (Surajit_TestEntities dc = new Surajit_TestEntities())
//{
List <PrivateChatMessage> msg = new List <PrivateChatMessage>();
var v = (from a in chpmm.GetList().ToList()
join b in chpmd.GetList().ToList() on a.EmailID equals b.MasterEmailID into cc
from c in cc
where (c.MasterEmailID.Equals(fromid) && c.ChatToEmailID.Equals(toid)) || (c.MasterEmailID.Equals(toid) && c.ChatToEmailID.Equals(fromid))
orderby c.Id descending
select new
{
UserName = a.UserName,
Message = c.Message,
ID = c.Id
}).Take(takeCounter).Skip(skipCounter).ToList();
foreach (var a in v)
{
var res = new PrivateChatMessage()
{
userName = a.UserName,
message = a.Message
};
msg.Add(res);
}
return(msg);
// }
}
