private string GetLogMessages() { string returnMessages = string.Empty; returnMessages += "<table border=1><tr><th>User</th><th>Message</th><th>PostDate</th></tr>"; using (DAL.LCDMessageDBEntities db = new DAL.LCDMessageDBEntities()) { var messages = ( from p in db.MessageLogs orderby p.messageID descending select p).Take(20); foreach (var item in messages) { returnMessages += "<tr>"; returnMessages += "<td>" + item.username + "</td>"; string msg = item.message; if (msg.Length > 1000) { msg = msg.Substring(0, 1000) + "...."; } msg = FormatDisplayString(msg, "</br>"); returnMessages += "<td nowrap='nowrap'>" + msg + "</td>"; returnMessages += "<td>" + item.messageDate + "</td>"; returnMessages += "</tr>"; } } returnMessages += "</table>"; return(returnMessages); }
private void LogMessage(string inputMessage) { DAL.LCDMessageDBEntities ent = new DAL.LCDMessageDBEntities(); DAL.MessageLog mess = DAL.MessageLog.CreateMessageLog(0, inputMessage, lblUser.Text, DateTime.Now); ent.AddToMessageLogs(mess); ent.SaveChanges(); }