public static void InsertChannels(string path)
{
using (var dbContext = new SlackHistoryViewerDbContext())
{
var data = GetData <Channel>(path, AppSettings.Instance.ChannelsFile);
dbContext.Channels.AddRange(data.Select(c => new Channels(c.Id, c.Name)));
dbContext.SaveChanges();
}
}
public static void InsertChannelsWithoutDuplicates(IEnumerable <Channel> channels)
{
using (var dbContext = new SlackHistoryViewerDbContext())
{
var newChannels = channels
.Where(c => !CheckDuplicateUser(dbContext, c.Id))
.Select(c => new Channels(c.Id, c.Name));
dbContext.Channels.AddRange(newChannels);
dbContext.SaveChanges();
}
}
public static void InsertUsersWithoutDuplicates(IEnumerable <Member> users)
{
using (var dbContext = new SlackHistoryViewerDbContext())
{
var newUsers = users
.Where(u => !CheckDuplicateUser(dbContext, u.Id))
.Select(u => new Users(u.Id, u.Name));
dbContext.Users.AddRange(newUsers);
dbContext.SaveChanges();
}
}
public static void InsertUsers(string path)
{
using (var dbContext = new SlackHistoryViewerDbContext())
{
var data = GetData <Member>(path, AppSettings.Instance.UsersFile);
dbContext.Users.AddRange(data.Select(u => new Users(u.Id, u.Name)));
dbContext.Users.Add(new Users(AppSettings.Instance.SlackBotId, AppSettings.Instance.SlackBotName));
dbContext.Users.Add(new Users(AppSettings.Instance.UnknownBotId, AppSettings.Instance.UnknownBotName));
dbContext.SaveChanges();
}
}
public static void InsertMessagesWithoutDuplicates(IEnumerable <Message> messages, string channelId)
{
using (var dbContext = new SlackHistoryViewerDbContext())
{
foreach (Message message in messages)
{
var key = message.User + message.TimeStamp;
var hash = MD5Hasher.GetMd5Hash(key);
if (!CheckDuplicateMessage(dbContext, hash))
{
AddMessage(dbContext, message, channelId);
}
}
dbContext.SaveChanges();
}
}
public static void InsertMessages(string path)
{
using (var dbContext = new SlackHistoryViewerDbContext())
{
var files = Directory.GetFiles(@path, "*.*", SearchOption.AllDirectories);
foreach (string file in files)
{
if (IsFileIgnored(file))
{
continue;
}
var words = file.Split('\\');
var channel = words[words.Length - 2];
var channelId = dbContext.Channels
.Where(c => c.Name == channel)
.Select(c => c.ChannelId)
.FirstOrDefault();
var text = File.ReadAllText(file);
var data = JsonConvert.DeserializeObject <List <Message> >(text);
foreach (var message in data)
{
if (IsAttachment(message))
{
continue;
}
AddMessage(dbContext, message, channelId);
}
dbContext.SaveChanges();
}
}
}