public bool RemoveUserFromChat(User user, Chat chat)
{
try
{
List <User> usersOfChat = GetUsersOfChat(chat);
if (usersOfChat.Count == 1)
{
RemoveChat(chat);
}
else
{
using (var context = new TitanNetworkContext())
{
Room room = context.Rooms.FirstOrDefault(g => g.UserId == user.Id && g.ChatId == chat.Id);
context.Entry(room).State = EntityState.Deleted;
context.SaveChanges();
}
}
return(true);
}
catch
{
return(false);
}
}
public BotCache GetBotCacheExistance(string title)
{
BotCache cacheFound;
using (var context = new TitanNetworkContext())
{
cacheFound = context.BotCaches.FirstOrDefault(g => g.Title == title);
}
return(cacheFound);
}
public Message GetMessageById(int id)
{
Message msg;
using (var context = new TitanNetworkContext())
{
msg = context.Messages.FirstOrDefault(g => g.Id == id);
}
return(msg);
}
public Chat GetChatById(int id)
{
Chat chat;
using (var context = new TitanNetworkContext())
{
chat = context.Chats.FirstOrDefault(g => g.Id == id);
}
return(chat);
}
public bool AddMessageLog(MessageLog log)
{
try
{
using (var context = new TitanNetworkContext())
{
context.Entry(log).State = EntityState.Added;
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool AddBotCache(BotCache cache)
{
try
{
using (var context = new TitanNetworkContext())
{
context.Entry(cache).State = EntityState.Added;
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool UpdateMessage(Message message)
{
try
{
using (var context = new TitanNetworkContext())
{
context.Entry(message).State = EntityState.Modified;
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool RemoveChat(Chat chat)
{
try
{
using (var context = new TitanNetworkContext())
{
context.Entry(chat).State = EntityState.Deleted;
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public List <Message> GetMessagesFromChat(Chat chat)
{
try
{
List <Message> chatMessages;
using (var context = new TitanNetworkContext())
{
chatMessages = context.Messages.Where(g => g.ChatId == chat.Id).ToList();
}
return(chatMessages);
}
catch
{
return(null);
}
}
public bool AddUserToChat(User user, Chat chat)
{
try
{
using (var context = new TitanNetworkContext())
{
Room room = new Room();
room.UserId = user.Id;
room.ChatId = chat.Id;
context.Rooms.Add(room);
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public List <User> GetUsersOfChat(Chat chat)
{
try
{
List <User> users;
using (var context = new TitanNetworkContext())
{
List <int> userIds = context.Rooms.Where(g => g.ChatId == chat.Id).Select(g => g.UserId).ToList();
users = context.Users.Where(g => userIds.Contains(g.Id
)).ToList();
}
return(users);
}
catch
{
return(null);
}
}
public BaseProvider()
{
Context = new TitanNetworkContext();
}
public CustomRoleStore(TitanNetworkContext context)
: base(context)
{
}
public CustomUserStore(TitanNetworkContext context)
: base(context)
{
}
