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);
}
