private void chat_FormClosing(object sender, FormClosingEventArgs e) { timer.Stop(); //gets the datacontext. ChatUsersDataContext users = new ChatUsersDataContext(); var z = from y in users.ConnectedChatusers select y; foreach (var x in z) { if (x.ConnectedChatUser1.Equals(username, StringComparison.InvariantCultureIgnoreCase)) { users.ConnectedChatusers.DeleteOnSubmit(x); } } try { users.SubmitChanges(); } catch { Console.WriteLine("Unable to log out of chat"); // Provide for exceptions. } }
private void checkstatus(InternalChat test) { //if (test.MikeConnection == true && test.SageConnection==false) //{ // label4.Text = "Mike is Connected"; // label3.Text = "Sage is not Connected"; //} //if (test.SageConnection == true && test.MikeConnection==false) //{ // label4.Text = "Mike is not Connected"; // label3.Text = "Sage is Connected"; //} //if(test.MikeConnection==true && test.SageConnection==true) //{ // label3.Text = "Sage is Connected"; // label4.Text = "Mike is Connected"; //} listView1.Items.Clear(); bool alreadyentered = false; ChatUsersDataContext users = new ChatUsersDataContext(); var z = from y in users.ConnectedChatusers where y.Id != 0 select y; foreach (var x in z) { if (x.ConnectedChatUser1.Equals(username, StringComparison.InvariantCultureIgnoreCase)) { alreadyentered = true; } string[] row = { x.ConnectedChatUser1, "" }; listView1.Items.Add(System.Convert.ToString("")).SubItems.AddRange(row); } if (!alreadyentered) { using (ChatUsersDataContext newuser = new ChatUsersDataContext()) { ConnectedChatuser newusers = new ConnectedChatuser() { ConnectedChatUser1 = username }; newuser.ConnectedChatusers.InsertOnSubmit(newusers); newuser.SubmitChanges(); } } ChaterDataContext messages = new ChaterDataContext(); var r = from p in messages.InternalChats where p.Id != 1 select p; messageadded = 0; Messages.Rtf = ""; foreach (var x in r) { DateTime dissue = new DateTime(); dissue = Convert.ToDateTime(x.Datetime); DateTime dnow = new DateTime(); dnow = DateTime.Now; TimeSpan duration = dnow - dissue; if (duration.TotalHours > 1) { messages.InternalChats.DeleteOnSubmit(x); messages.SubmitChanges(); } else { messageadded += 1; //insertion of string here Messages.SelectedRtf = PlainTextToRtf("\r\n\r\n" + x.Sender); Messages.SelectedRtf = PlainTextToRtf(" " + x.Datetime.ToString() + ": "); try { Messages.SelectedRtf = @x.Message; } catch { Messages.SelectedRtf = PlainTextToRtf(x.Message + "\r\n"); } if (firstload == false) { currentmessagecount += 1; } } } Messages.SelectionStart = Messages.Text.Length; Messages.ScrollToCaret(); if (messageadded > currentmessagecount) { FlashWindow.Flash(this); currentmessagecount = messageadded; } firstload = true; Messages.Resume(); }