コード例 #1
0
        public static void LoadMessages(List<Message> dialogs)
        {
            for (int i = 0; i < dialogs.Count; i++)
            {
                Message msg = dialogs[i];
                HttpRequestsHandler.GetUserByID(msg.uid, (x) =>
                {
                    using (VKDataContext context = new VKDataContext(VKDataContext.DBConnectionString))
                    {
                        VKMessage vm = new VKMessage();
                        vm.Body = msg.body;
                        vm.Date = DateConverter.DateTimeFromUnixTimestampSeconds(msg.date);
                        vm.VKMessageID = msg.mid;
                        VKUser user = new VKUser();

                        user.FirstName = x.first_name;
                        user.LastName = x.last_name;
                        user.IsOnline = (x.online == 1);
                        user.VKUserID = x.uid;

                        context.VKUser.InsertOnSubmit(user);
                        context.SubmitChanges();

                        context.VKMessage.InsertOnSubmit(vm);
                        context.SubmitChanges();

                        UserMessage um = new UserMessage();
                        um.VKMessageID = user.VKUserID;
                        um.VKUserID = vm.VKMessageID;

                        context.UserMessage.InsertOnSubmit(um);
                        context.SubmitChanges();
                    }
                }, (error) =>
                {
                });
            }
        }
コード例 #2
0
        private void createTestData()
        {
            using (VKDataContext context = new VKDataContext(VKDataContext.DBConnectionString))
            {
                //context.DeleteDatabase();
                //context.CreateDatabase();

                IList<String> firstnames = new List<String>();
                firstnames.Add("Александр");
                firstnames.Add("Андрей");
                firstnames.Add("Bob");
                firstnames.Add("Willy");
                firstnames.Add("John");
                firstnames.Add("Akakij");

                IList<String> lastnames = new List<String>();
                lastnames.Add("Семирухин");
                lastnames.Add("White");
                lastnames.Add("Green");
                lastnames.Add("Joke");
                lastnames.Add("Smith");
                lastnames.Add("Васильев");

                IList<String> messageBodies = new List<String>();
                messageBodies.Add("Hi! How are you?");
                messageBodies.Add("Привет! Как дела?");
                messageBodies.Add("Merhaba! Nasilsin?");
                messageBodies.Add("What's up?");
                messageBodies.Add("Йоххо!");
                messageBodies.Add("London is capital of Great Britain");

                for (int i = 0; i < 6; i++)
                {
                    VKUser user = new VKUser();
                    user.LastName = lastnames[i];
                    user.FirstName = firstnames[i];
                    user.Photo = "http://photo.jpg";
                    user.IsOnline = true;
                    context.VKUser.InsertOnSubmit(user);
                    context.SubmitChanges();

                    VKMessage message = new VKMessage();
                    message.Body = messageBodies[i];
                    context.VKMessage.InsertOnSubmit(message);
                    context.SubmitChanges();

                    UserMessage um = new UserMessage();
                    um.VKMessageID = user.VKUserID;
                    um.VKUserID = message.VKMessageID;
                    context.UserMessage.InsertOnSubmit(um);
                    context.SubmitChanges();
                }
            }
        }