/// <summary>
/// Returns all messages within the past 20 minutes
/// </summary>
public List <DTO.ChatMessage> GetRecentMessages()
{
using (var context = new LiveChatEntities())
{
var DTCutoff = DateTime.Now.AddMinutes(-20);
var items = (from item in context.ChatMessages
where item.SentDateTime >= DTCutoff
select item).ToList();
var newItems = items.ConvertAll <DTO.ChatMessage>(item => new DTO.ChatMessage(item.SentDateTime, item.SentUserName, item.MessageText));
return(newItems);
}
}
/// <summary>
/// Saves a new message to the database
/// </summary>
/// <param name="pUserDisplayName"></param>
/// <param name="pMessageText"></param>
public void SaveMessage(string pUserDisplayName, string pMessageText)
{
using (var context = new LiveChatEntities())
{
context.ChatMessages.Add(new ChatMessage()
{
SentDateTime = DateTime.Now,
Guid = Guid.NewGuid(),
SentUserName = pUserDisplayName,
MessageText = pMessageText
});
context.SaveChanges();
}
}
public JsonResult AppMsg()
{
string msgID = Request.Params["msgID"];
string fName = Request.Params["fName"];
string msgContent = "<li>" + fName + ": " + Request.Params["msgContent"] + "</li>";
LC_Msg msg = new LC_Msg();
Message message = new Message();
message.MsgID = msgID;
message.MsgContent = msgContent;
using (LiveChatEntities db = new LiveChatEntities())
{
msg = message.UserSave();
}
return(Json(new { msg = msg }, JsonRequestBehavior.DenyGet));
}
public JsonResult MsgUp(string msgID)
{
List <LC_Msg> msgList = new List <LC_Msg>();
LC_Msg msg = new LC_Msg();
string msgContent = "";
using (LiveChatEntities db = new LiveChatEntities())
{
msgList = db.sp_LC_SearchMsg(msgID).ToList();
if (msgList.Any())
{
msg = msgList.First();
msgContent = msg.MsgContent;
}
else
{
msgContent = "";
}
}
return(Json(new { msgContent = msgContent }, JsonRequestBehavior.DenyGet));
}
public JsonResult CreateMsg()
{
string fName = Request.Params["fName"];
string lName = Request.Params["lName"];
Message message = new Message();
LC_Msg msg = new LC_Msg();
using (LiveChatEntities db = new LiveChatEntities())
{
if (fName != "" && lName != "")
{
message.FName = fName;
message.LName = lName;
msg = message.Save();
}
else
{
msg = null;
}
}
return(Json(new { msg = msg }, JsonRequestBehavior.DenyGet));
}
