Example #1
0
        static void Main(string[] args)
        {
            var storage = new SqlReminderStorage(
                @"Data Source=localhost\SQLEXPRESS;Initial Catalog=Reminder;Integrated Security=true;");

            //test add
            Guid id = storage.Add(
                DateTimeOffset.Now.AddMinutes(1),
                "Test message",
                "012345",
                Core.ReminderItemStatus.Failed);

            Console.WriteLine(id);

            //test get(id)
            var reminderItem = storage.Get(id);

            Console.WriteLine(JsonConvert.SerializeObject(reminderItem));


            //test get(status)
            storage.Add(
                DateTimeOffset.Now.AddMinutes(1),
                "Test message",
                "012345",
                Core.ReminderItemStatus.Failed);

            var list = storage.Get(ReminderItemStatus.Failed);

            Console.WriteLine(list.Count);

            list = storage.Get(ReminderItemStatus.Ready);              //проверка на  нулевую ссылку
            Console.WriteLine(list.Count);

            //test update
            storage.Update(id, ReminderItemStatus.Sent);
            list = storage.Get(ReminderItemStatus.Sent);
            Console.WriteLine(list.Count);

            Console.ReadKey();
        }