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();
}
