private void detach_LoggedInUsers(LoggedInUser entity) { this.SendPropertyChanging(); entity.Room = null; }
private void attach_LoggedInUsers(LoggedInUser entity) { this.SendPropertyChanging(); entity.User = this; }
partial void DeleteLoggedInUser(LoggedInUser instance);
partial void UpdateLoggedInUser(LoggedInUser instance);
partial void InsertLoggedInUser(LoggedInUser instance);
//pobierz zalogowanych użytkowników private void GetLoggedUsers() { ChatDataContext db = new ChatDataContext(); //sprawdź, czy bieżący użytkownik jest na liście zalogowanych w tym pokoju var usr = (from user in db.LoggedInUsers where user.UserID == Convert.ToInt32(Session["ChatUserID"]) && user.RoomID == Convert.ToInt32(Session["roomID"]) select user).SingleOrDefault(); //jeśli nie, to go dodaj if (usr == null) { LoggedInUser loggedUser = new LoggedInUser(); int id = (from user in db.LoggedInUsers orderby user.LoggedInUserId descending select user.LoggedInUserId ).FirstOrDefault(); loggedUser.LoggedInUserId = id + 1; loggedUser.UserID = Convert.ToInt32(Session["ChatUserID"]); loggedUser.RoomID = Convert.ToInt32(Session["roomID"]); db.LoggedInUsers.InsertOnSubmit(loggedUser); db.SubmitChanges(); } StringBuilder sb = new StringBuilder(); //wyświetl zalogowanych użytkowników w tym pokoju var loggedUsers = from users in db.LoggedInUsers where users.RoomID == Convert.ToInt32(Session["roomID"]) select users; foreach (var loggedOne in loggedUsers) { //ikonka var thisOne = (from users in db.Users where users.UserID == loggedOne.UserID select new { users.Sex, users.Username }).SingleOrDefault(); if (thisOne.Sex.ToLower() == "m") { sb.Append("<img src='man-icon.gif' style='vertical-align:middle;'/>"); } else { sb.Append("<img src='female-icon.gif' style='vertical-align:middle;'/>"); } //do wszystkich uzytkownikow oprocz biezacego beda linki (do prywatnej rozmowy) if (thisOne.Username != (string)Session["ChatUsername"]) { sb.Append("<a href=# onclick=\"window.open('ChatWindow.aspx?FromUserID=" + Session["ChatUserID"] + "&ToUserID=" + loggedOne.UserID + "&Username="******"&isReply=no" + "'," + "'','width=400,height=200,scrollbars=no,toolbars=no,titlebar=no,menubar=no'); isLostFocus='true';\">" + thisOne.Username + "</a><br>"); } else { sb.Append("<b>" + thisOne.Username + "</b><br>"); } } litUsers.Text = sb.ToString(); }