public void CreateMessage(Message message) { using (var db = new AOEChatEntities()) { db.Messages.Add(message); db.SaveChanges(); } }
public void UpdateMessage(long messageId, string messageText) { using (var db = new AOEChatEntities()) { Message m = db.Messages.Where(i => i.MessageId == messageId).SingleOrDefault(); m.MessageText = messageText; db.SaveChanges(); } }
public static void DeleteAllMessages() { using (var db = new AOEChatEntities()) { List<Message> messages = db.Messages.ToList(); foreach (var t in messages) { db.Messages.Remove(t); } db.SaveChanges(); } }
public static void CreateMessage(int chatUserId, string messageText, float gpsXCoord, float gpsYCoord) { using (var db = new AOEChatEntities()) { Message m = new Message(); m.ChatUserId = chatUserId; m.MessageText = messageText; m.GpsXCoord = gpsXCoord; m.GpsYCoord = gpsYCoord; db.Messages.Add(m); db.SaveChanges(); } }
public static void DeletePastMessages() { DateTime startDateTime = DateTime.Now.AddDays(-2); using (var db = new AOEChatEntities()) { List<Message> messages = db.Messages.Where(i => i.TimeSent <= startDateTime).ToList(); //List<Message> messages = db.Messages.ToList(); foreach (var t in messages) { db.Messages.Remove(t); } db.SaveChanges(); } }