static void Main(string[] args)
{
const string connectionStringTemplate =
"Data Source={0};" +
"Initial Catalog={1};" +
"Integrated Security=true";
string conenctionString = string.Format(connectionStringTemplate, @"localhost\SQLEXPRESS", "Storage");
var repository = new SqlStorage(conenctionString);
#region testing
var reminder1 = new ReminderItemRestricted
{
ContactId = "Tom",
Date = DateTimeOffset.Now,
Message = "hi tommy",
Status = (ReminderItemStatus)1
};
var newid = repository.Add(reminder1);
Console.WriteLine(newid);
ReminderItem reminder = repository.Get(newid);
Console.WriteLine(reminder.ContactId);
var list = repository.Get(ReminderItemStatus.Ready);
int m = 0;
foreach (var rem in list)
{
++m;
}
Console.WriteLine(m);
repository.UpdateStatus(newid, ReminderItemStatus.Failed);
reminder = repository.Get(newid);
Console.WriteLine(reminder.Status);
List <Guid> ids = new List <Guid>
{
Guid.Parse("D19F4EF4-3C36-453C-8384-76B27ACF8C92"),
Guid.Parse("67E41C35-B81E-4CC4-9BE3-77B34AE4865F"),
Guid.Parse("27283CA6-295E-42F3-B6D6-7C2003B6CA9A"),
Guid.Parse("A31EA458-43B0-47E6-850D-7C36ADC40EB1"),
Guid.Parse("D8D495B9-D907-4456-8E47-8FB270F48060"),
};
repository.UpdateStatus(ids, ReminderItemStatus.Awaiting);
#endregion
}
public void Update_Status_Storage_Sql_Tests_Method()
{
SqlStorage.Clear();
var date = DateTimeOffset.Now;
Guid guid = Guid.NewGuid();
UserItem user = new UserItem()
{
ChatId = 12345678,
DateOfRegistration = date,
FirstName = "Null",
Id = guid,
Message = "Null",
Status = StatusEnum.Null
};
SqlStorage.AddUser(user);
Assert.AreEqual(SqlStorage.Count, 1);
UserItem user2 = new UserItem()
{
ChatId = 12345678,
DateOfRegistration = date,
FirstName = "Null",
Id = guid,
Message = "Null",
Status = StatusEnum.Admin
};
SqlStorage.UpdateStatus(user2);
UserItem item = SqlStorage.GetUser(guid);
Assert.AreEqual(SqlStorage.Count, 1);
Assert.AreEqual(item.ChatId, user.ChatId);
Assert.AreEqual(item.DateOfRegistration, user.DateOfRegistration);
Assert.AreEqual(item.FirstName, user.FirstName);
Assert.AreEqual(item.Id, user.Id);
Assert.AreEqual(item.Message, user.Message);
Assert.AreEqual(item.Status, StatusEnum.Admin);
SqlStorage.Clear();
}
