/// <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)); }