public static void NewMessage(Message message) { MessengerDataContext dc = new MessengerDataContext(); dc.Messages.InsertOnSubmit(message); dc.SubmitChanges(); }
public static List <MQTTMessage> GetUnreadMessagesByGmail(string gmail) { MessengerDataContext dc = new MessengerDataContext(); List <MQTTMessage> mqttMessageList = new List <MQTTMessage>(); IQueryable <Message> messageList = from messages in dc.Messages join users in dc.Users on messages.ToID equals users.ID where users.gmail == gmail && messages.SendingPending select messages; foreach (Message message in messageList) { MQTTMessage mqttMessage = new MQTTMessage(); mqttMessage.gmail = GetGmailByID(message.FromID); mqttMessage.message = message.Text; mqttMessage.time = message.Time.ToString(); mqttMessageList.Add(mqttMessage); } return(mqttMessageList); }
public static string GetGmailByID(int id) { MessengerDataContext dc = new MessengerDataContext(); return((from users in dc.Users where users.ID == id select users.gmail).Single()); }
public MessagesController(MessengerDataContext db) { _db = db; }