public static List <ChatMessageDetail> GetCurrentMessages()
{
using (var dc = new SolutionsOnlineSellingEntities())
{
return(dc.ChatMessageDetail.ToList());
}
}
public static List <PrivateChatMessage> GetPrivateMessage(string fromid, string toid, int take)
{
using (var dc = new SolutionsOnlineSellingEntities())
{
var msg = new List <PrivateChatMessage>();
var v = (from a in dc.ChatPrivateMessageMaster
join b in dc.ChatPrivateMessageDetails 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 static ChatUserDetail GetUser(string id)
{
using (var dc = new SolutionsOnlineSellingEntities())
{
return(dc.ChatUserDetail.FirstOrDefault(x => x.ConnectionId == id));
}
}
public static List <ChatUserDetail> GetConnectedUsers()
{
using (var dc = new SolutionsOnlineSellingEntities())
{
return(dc.ChatUserDetail.ToList());
}
}
public static void AddPrivateMessageinCache(string fromEmail, string chatToEmail, string userName, string message)
{
using (var dc = new SolutionsOnlineSellingEntities())
{
// Save master
var master = dc.ChatPrivateMessageMaster.ToList().Where(a => a.EmailID.Equals(fromEmail)).ToList();
if (master.Count == 0)
{
var result = new ChatPrivateMessageMaster
{
EmailID = fromEmail,
UserName = userName
};
dc.ChatPrivateMessageMaster.Add(result);
dc.SaveChanges();
}
// Save details
var resultDetails = new ChatPrivateMessageDetails
{
MasterEmailID = fromEmail,
ChatToEmailID = chatToEmail,
Message = message
};
dc.ChatPrivateMessageDetails.Add(resultDetails);
dc.SaveChanges();
}
}
public static ChatUserDetail GetUser(string userName, string email, string id)
{
using (var dc = new SolutionsOnlineSellingEntities())
{
var item = dc.ChatUserDetail.FirstOrDefault(x => x.EmailID == email);
if (item != null)
{
dc.ChatUserDetail.Remove(item);
dc.SaveChanges();
}
var Users = dc.ChatUserDetail.ToList();
if (Users.Where(x => x.EmailID == email).ToList().Count == 0)
{
var userdetails = new ChatUserDetail
{
ConnectionId = id,
UserName = userName,
EmailID = email
};
dc.ChatUserDetail.Add(userdetails);
dc.SaveChanges();
}
return(dc.ChatUserDetail.FirstOrDefault(x => x.EmailID == email));
}
}
public static void RemoveUser(string id)
{
using (var dc = new SolutionsOnlineSellingEntities())
{
var item = dc.ChatUserDetail.FirstOrDefault(x => x.ConnectionId == id);
if (item != null)
{
dc.ChatUserDetail.Remove(item);
dc.SaveChanges();
}
}
}
public static void AddAllMessageinCache(string userName, string message, string emailIDLoaded)
{
using (var dc = new SolutionsOnlineSellingEntities())
{
var messageDetail = new ChatMessageDetail
{
UserName = userName,
Message = message,
EmailID = emailIDLoaded
};
dc.ChatMessageDetail.Add(messageDetail);
dc.SaveChanges();
}
}
public bool RemoveCalendar(TblCalendar model)
{
try
{
using (var context = new SolutionsOnlineSellingEntities())
{
context.Entry(model).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Helpers.Logger.LogException(ex, true);
return(false);
}
}