static void Main(string[] args) { var context = new PhonebookEntities(); var chanannels = context.Channels .Select(c => new { c.Name, ChannelMessages = c.ChannelMessages.Select(m => new { m.Content, m.DateTime, m.User.Username }) }) .ToList(); chanannels.ForEach(m => { Console.WriteLine("{0}\n--Messages--", m.Name); var messages = m.ChannelMessages; foreach (var channelMessage in messages) { Console.WriteLine("Content:{0},DateTime:{1:dd/MM/yyyy hh:mm:ss},User{2}", channelMessage.Content, channelMessage.DateTime, channelMessage.Username); } }); }
private static void ProcessMessage(PhonebookEntities context, JsonMessage messege) { if (messege.Content == null) { throw new ArgumentException("Content is required!"); } if (messege.DateTime == null) { throw new ArgumentException("DateTime is required!"); } if (messege.Recipient == null) { throw new ArgumentException("Recipient is required!"); } if (messege.Sender == null) { throw new ArgumentException("Sender is required!"); } var userMessage = new UserMessage() { Content = messege.Content, DateTime = (DateTime)messege.DateTime, Sender = context.Users.FirstOrDefault(u => u.Username == messege.Sender), Recipiant = context.Users.FirstOrDefault(u => u.Username == messege.Recipient), }; context.UserMessages.AddOrUpdate(userMessage); context.SaveChanges(); Console.WriteLine("Message \"{0}\" Imported", userMessage.Content); }
static void Main(string[] args) { var context = new PhonebookEntities(); var chanannels = context.Channels .Select(c => new { c.Name, ChannelMessages = c.ChannelMessages.Select(m => new { m.Content, m.DateTime, m.User.Username }) }) .ToList(); chanannels.ForEach(m => { Console.WriteLine("{0}\n--Messages--", m.Name); var messages = m.ChannelMessages; foreach (var channelMessage in messages) { Console.WriteLine("Content:{0},DateTime:{1:dd/MM/yyyy hh:mm:ss},User{2}", channelMessage.Content, channelMessage.DateTime, channelMessage.Username); } }); }
public static void Main(string[] args) { var context = new PhonebookEntities(); var serializer = new JavaScriptSerializer(); var json = File.ReadAllText("../../../messages.json"); var messeges = serializer.Deserialize<JsonMessage[]>(json); foreach (var messege in messeges) { try { ProcessMessage(context, messege); } catch (ArgumentException ex) { Console.Error.WriteLine("Error: {0}", ex.Message); } } }