public AddToChatForm(ChatUser user, IChatDAL dal)
{
InitializeComponent();
this._dal = dal;
this.curUser = user;
}
public LeaveFromChatForm(ChatUser user, IChatDAL dal)
{
InitializeComponent();
curUser = user;
this._dal = dal;
}
public void AddChatUser(string name, string pass)
{
ChatUser newUser = new ChatUser();
newUser.UserName = name;
newUser.Password = pass;
newUser.IsMod = false;
newUser.IsOnline = false;
this._context.ChatUser.Add(newUser);
this._context.SaveChanges();
}
public void AddMessageToHistory(ChatUser user, string chatTitle, string msg)
{
History history = new History();
var chat = (from c in this._context.Chat
where c.ChatTitle == chatTitle
select c).First();
history.IdChat_Chat = chat.IdChat;
history.IdUser_ChatUser = user.IdUser;
history.Message = msg;
history.MessageDate = DateTime.Now;
this._context.History.Add(history);
this._context.SaveChanges();
}
public void AddUserToChat(ChatUser user, int idChat)
{
ChatMembership membership = new ChatMembership();
membership.IdUser_ChatUser = user.IdUser;
membership.IdChat_Chat = idChat;
this._context.ChatMembership.Add(membership);
this._context.SaveChanges();
}
public void SetUserOnlineOffline(ChatUser user, bool itLogin)
{
user.IsOnline = itLogin;
this._context.SaveChanges();
}
public void LeaveFromMembership(string chatname, ChatUser user)
{
Chat chat = this.GetChatFromTitle(chatname);
var membership = from cm in this._context.ChatMembership
where cm.IdChat_Chat == chat.IdChat && cm.IdUser_ChatUser == user.IdUser
select cm;
this._context.ChatMembership.RemoveRange(membership);
this._context.SaveChanges();
}
public List<string> GetListOfUsersWhatCanBeAddedToChat(string chattitle, ChatUser user)
{
List<string> userlist = new List<string>();
Chat chat = this.GetChatFromTitle(chattitle);
//var users = (from u in this._context.ChatUser
// join cm in this._context.ChatMembership on u.IdUser equals cm.IdUser_ChatUser
// join c in this._context.Chat on cm.IdChat_Chat equals c.IdChat
// where c.ChatTitle != chattitle
// select u.UserName).Distinct();
var users = (from u in this._context.ChatUser
where
!(from cm in this._context.ChatMembership
where cm.IdChat_Chat == chat.IdChat
select cm.IdUser_ChatUser).Contains(u.IdUser)
select u.UserName).Distinct();
userlist.AddRange(users);
return userlist;
}
public List<string> GetListOfUserChats(ChatUser user)
{
List<string> userChats = new List<string>();
var chats = from c in this._context.Chat
join cm in this._context.ChatMembership on c.IdChat equals cm.IdChat_Chat
where cm.IdUser_ChatUser == user.IdUser
select c.ChatTitle;
userChats.AddRange(chats);
return userChats;
}
private void MenuItem_Click_LogOut(object sender, RoutedEventArgs e)
{
this.curUser = null;
}
