public List <Message> GetMessages(string chatName)
{
using (ChatAppContext db = new ChatAppContext())
{
List <Message> currentChat = new List <Message>();
List <Message> messages = db.Messages.Where(m => m.ChatName == chatName).ToList();
return(messages);
}
}
public void LoginOrLogout(User user, string status)
{
using (ChatAppContext db = new ChatAppContext())
{
User changedUser = db.Users.FirstOrDefault(u => u.Name == user.Name && u.Password == user.Password);
changedUser.Status = status;
db.Users.Update(changedUser);
db.SaveChanges();
}
}
public void Register(User user, string role, string status)
{
using (ChatAppContext db = new ChatAppContext())
{
User newUser = new User {
Name = user.Name, Password = user.Password, Role = role, Status = status
};
db.Users.Add(newUser);
db.SaveChanges();
}
}
public void Create(Chat chat)
{
using (ChatAppContext db = new ChatAppContext())
{
Chat newChat = new Chat {
Name = chat.Name, Creator = chat.Creator
};
db.Chats.Add(newChat);
db.SaveChanges();
}
}
public void BanUserToChat(UserChat userChatBanned, double time)
{
using (ChatAppContext db = new ChatAppContext())
{
User userBanned = db.Users.Include(s => s.UserChats).FirstOrDefault(s => s.Name == userChatBanned.User.Name);
Chat chat = db.Chats.Include(s => s.UserChats).FirstOrDefault(s => s.Name == userChatBanned.Chat.Name);
UserChat userChat = userBanned.UserChats.Where(uc => uc.ChatId == chat.Id && uc.UserId == userBanned.Id).FirstOrDefault();
userChat.BanEndDate = DateTime.Now.AddMinutes(time);
db.SaveChanges();
}
}
public void RemoveUserFromChat(string chatName, string userName)
{
using (ChatAppContext db = new ChatAppContext())
{
User user = db.Users.Include(s => s.UserChats).FirstOrDefault(s => s.Name == userName);
Chat chat = db.Chats.Include(s => s.UserChats).FirstOrDefault(s => s.Name == chatName);
UserChat userChat = user.UserChats.Where(uc => uc.ChatId == chat.Id && uc.UserId == user.Id).FirstOrDefault();
chat.UserChats.Remove(userChat);
user.UserChats.Remove(userChat);
db.SaveChanges();
}
}
public bool IsUserExists(string userName)
{
using (ChatAppContext db = new ChatAppContext())
{
User user = db.Users.Where(u => u.Name == userName).FirstOrDefault();
if (user != null)
{
return(true);
}
return(false);
}
}
public bool IsChatExists(string chatName)
{
using (ChatAppContext db = new ChatAppContext())
{
Chat chat = db.Chats.Where(u => u.Name == chatName).FirstOrDefault();
if (chat != null)
{
return(true);
}
return(false);
}
}
public bool IsRegistred(string name, string password)
{
using (ChatAppContext db = new ChatAppContext())
{
User checkedUser = db.Users.FirstOrDefault(u => u.Name == name && u.Password == password);
if (checkedUser == null)
{
return(false);
}
return(true);
}
}
public bool IsTrueUser(string userName, string userPassword)
{
using (ChatAppContext db = new ChatAppContext())
{
User userChanged = db.Users.Where(u => u.Name == userName).FirstOrDefault();
User user = db.Users.Where(u => u.Password == userPassword).FirstOrDefault();
if (user.Role == "administrator" || userChanged.Password == userPassword)
{
return(true);
}
return(false);
}
}
public bool HasHighRightInChat(string chatName, string userName)
{
using (ChatAppContext db = new ChatAppContext())
{
User user = db.Users.Where(u => u.Name == userName).FirstOrDefault();
Chat chat = db.Chats.Where(u => u.Name == chatName).FirstOrDefault();
if (chat.Creator == user.Name || user.Role == "administrator")
{
return(true);
}
return(false);
}
}
public void BanUser(User user, double time)
{
using (ChatAppContext db = new ChatAppContext())
{
User userBanned = db.Users.Include(s => s.UserChats).FirstOrDefault(s => s.Name == user.Name);
List <UserChat> userChats = userBanned.UserChats.Where(uc => uc.UserId == userBanned.Id).ToList();
for (int i = 0; i < userChats.Count; i++)
{
userChats[i].BanEndDate = DateTime.Now.AddMinutes(time);
}
db.SaveChanges();
}
}
public bool IsUserBanned(string chatName, string userName)
{
using (ChatAppContext db = new ChatAppContext())
{
Chat chat = db.Chats.Include(u => u.UserChats).FirstOrDefault(c => c.Name == chatName);
User user = db.Users.Include(u => u.UserChats).FirstOrDefault(c => c.Name == userName);
UserChat userChat = chat.UserChats.Where(uc => uc.ChatId == chat.Id && uc.UserId == user.Id).FirstOrDefault();
if (userChat != null && userChat.BanEndDate > DateTime.Now)
{
return(true);
}
return(false);
}
}
public string GetStatusUser(string chatName, string userName)
{
using (ChatAppContext db = new ChatAppContext())
{
User user = db.Users.Include(u => u.UserChats).FirstOrDefault(u => u.Name == userName);
Chat chat = db.Chats.Include(c => c.UserChats).FirstOrDefault(c => c.Name == chatName);
UserChat userChats = chat.UserChats.Where(c => c.Chat.Name == chatName && c.User.Name == userName).FirstOrDefault();
if (chat.Creator == userName)
{
return("creator");
}
return(user.Role);
}
}
public void RenameChat(Chat chat, string newChatName)
{
using (ChatAppContext db = new ChatAppContext())
{
Chat chatChanged = db.Chats.Where(c => c.Name == chat.Name).FirstOrDefault();
List <Message> messages = db.Messages.Where(c => c.ChatName == chat.Name).ToList();
chatChanged.Name = newChatName;
for (int i = 0; i < messages.Count; i++)
{
messages[i].ChatName = newChatName;
}
db.SaveChanges();
}
}
public void AddMessageToChat(Message message)
{
if (IsUserInChat(message.ChatName, message.Author))
{
using (ChatAppContext db = new ChatAppContext())
{
Chat chat = db.Chats.Include(s => s.Messages).FirstOrDefault(s => s.Name == message.ChatName);
Message newMessage = new Message {
ChatName = message.ChatName, Author = message.Author, Text = message.Text
};
chat.Messages.Add(newMessage);
db.SaveChanges();
}
}
}
public void ChangeModerator(User user, bool isModerator)
{
using (ChatAppContext db = new ChatAppContext())
{
User userChanged = db.Users.Where(u => u.Name == user.Name).FirstOrDefault();
if (isModerator)
{
userChanged.Role = "moderator";
}
else
{
userChanged.Role = "user";
}
db.SaveChanges();
}
}
public void AddUserToChat(UserChat userChat)
{
using (ChatAppContext db = new ChatAppContext())
{
Chat chat = db.Chats.Include(s => s.UserChats).FirstOrDefault(s => s.Name == userChat.Chat.Name);
User user = db.Users.Include(s => s.UserChats).FirstOrDefault(s => s.Name == userChat.User.Name);
UserChat newUserChat = new UserChat {
ChatId = chat.Id, UserId = user.Id, BanEndDate = new DateTime()
};
if (user.UserChats.Select(uc => uc.ChatId).FirstOrDefault() != newUserChat.ChatId)
{
chat.UserChats.Add(newUserChat);
user.UserChats.Add(newUserChat);
db.SaveChanges();
}
}
}
public void Delete(string chatName, string userName)
{
using (ChatAppContext db = new ChatAppContext())
{
User user = db.Users.Include(s => s.UserChats).FirstOrDefault(s => s.Name == userName);
Chat chat = db.Chats.Include(s => s.UserChats).FirstOrDefault(s => s.Name == chatName);
List <Message> messages = db.Messages.Where(m => m.ChatId == chat.Id).ToList();
UserChat newUserChat = new UserChat {
ChatId = chat.Id, UserId = user.Id
};
chat.UserChats.Remove(newUserChat);
user.UserChats.Remove(newUserChat);
Messages.RemoveRange(messages);
db.Remove(chat);
db.SaveChanges();
}
}
public void RenameUser(User user, string newUserName)
{
using (ChatAppContext db = new ChatAppContext())
{
User userChanged = db.Users.Where(u => u.Name == user.Name).FirstOrDefault();
List <Chat> chats = db.Chats.Where(c => c.Creator == user.Name).ToList();
List <Message> messages = db.Messages.Where(m => m.Author == user.Name).ToList();
userChanged.Name = newUserName;
for (int i = 0; i < chats.Count; i++)
{
chats[i].Creator = newUserName;
}
for (int i = 0; i < messages.Count; i++)
{
messages[i].Author = newUserName;
}
db.SaveChanges();
}
}
public List <User> GetUsers(string chatName)
{
using (ChatAppContext db = new ChatAppContext())
{
List <User> users = new List <User>();
Chat chat = db.Chats.Include(u => u.UserChats).FirstOrDefault(c => c.Name == chatName);
List <UserChat> userChats = chat.UserChats.Where(c => c.Chat.Name == chatName).ToList();
if (userChats.Count != 0)
{
foreach (UserChat userChat in userChats)
{
User user = db.Users.Include(s => s.UserChats).FirstOrDefault(s => s.Id == userChat.UserId);
users.Add(new User {
Name = user.Name, Role = user.Role, Status = user.Status
});
}
}
return(users);
}
}
public List <Chat> GetChats(string userName)
{
using (ChatAppContext db = new ChatAppContext())
{
List <Chat> chats = db.Chats.ToList();
User user = db.Users.Include(s => s.UserChats).FirstOrDefault(s => s.Name == userName);
List <Chat> userChats = new List <Chat>();
foreach (Chat chat in chats)
{
UserChat userChat = user.UserChats.Where(uc => uc.ChatId == chat.Id && uc.UserId == user.Id).FirstOrDefault();
if (userChat != null)
{
userChats.Add(new Chat {
Name = chat.Name
});
}
}
return(userChats);
}
}
