public void Get_By_Id_Method_Returns_Just_Added_Item() { var storage = new SqlReminderStorage(_connectionString); DateTimeOffset expectedDate = DateTimeOffset.Now; string expectedContactId = "TEST_CONTACT_ID"; string expectedMessage = "TEST_MESSAGE_TEXT"; ReminderItemStatus expectedStatus = ReminderItemStatus.Awaiting; Guid id = storage.Add(new ReminderItemRestricted { ContactId = expectedContactId, Date = expectedDate, Message = expectedMessage, Status = expectedStatus }); Assert.AreNotEqual(Guid.Empty, id); var actualItem = storage.Get(id); Assert.IsNotNull(actualItem); Assert.AreEqual(id, actualItem.Id); Assert.AreEqual(expectedDate, actualItem.Date); Assert.AreEqual(expectedContactId, actualItem.ContactId); Assert.AreEqual(expectedMessage, actualItem.Message); Assert.AreEqual(expectedStatus, actualItem.Status); }
public void Method_Add_return() { var storage = new SqlReminderStorage(_connectionString); Guid actual = storage.Add(new Core.ReminderItemRestricted()) { } Assert.AreEqual(Guid.Empty, actual); }
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(); }
public void Method_Add_Returns_Not_Empty_Guid() { var storage = new SqlReminderStorage(_connectionString); Guid actual = storage.Add(new Core.ReminderItemRestricted { ContactId = "TestContactId", Date = DateTimeOffset.Now.AddHours(1), Message = "Test Message", Status = Core.ReminderItemStatus.Awaiting }); Assert.AreNotEqual(Guid.Empty, actual); }
public void Get_By_Id_Method_Returns_Russian_Message_After_Adding() { DateTimeOffset expectedDate = DateTimeOffset.Parse("2020-01-01 00:00:00 +00:00"); string expectedContactId = "ContactId_1"; string expectedMessage = "Сообщение на русском языке :)"; ReminderItemStatus expectedStatus = ReminderItemStatus.Awaiting; var storage = new SqlReminderStorage(_connectionString); Guid justAddedReminderId = storage.Add(new ReminderItemRestricted { ContactId = expectedContactId, Date = expectedDate, Message = expectedMessage, Status = expectedStatus }); var actualItem = storage.Get(justAddedReminderId); Assert.IsNotNull(actualItem); Assert.AreEqual(justAddedReminderId, actualItem.Id); Assert.AreEqual(expectedContactId, actualItem.ContactId); Assert.AreEqual(expectedDate, actualItem.Date); Assert.AreEqual(expectedMessage, actualItem.Message); Assert.AreEqual(expectedStatus, actualItem.Status); }