public void ShouldAddUser()
{
// arrange
var user = new User
{
NickName = "Test"
};
var dataLayer = new DataLayer.SQL.DataLayer(_connectionString);
// act
user = dataLayer.AddUser(user);
// asserts
var resultUser = dataLayer.GetUser(user.Id);
Assert.AreEqual(user.NickName, resultUser.NickName);
}
public void ShouldAddHashtag()
{
//arrange
var hashtag = new Hashtags
{
Name = Guid.NewGuid().ToString().Substring(10)
};
var dataLayer = new DataLayer.SQL.DataLayer(ConnectionString);
//act
hashtag = dataLayer.AddHashtag(hashtag);
//asserts
var resultHashtag = dataLayer.GetHashtag(hashtag.Id);
Assert.AreEqual(hashtag.Name, resultHashtag.Name);
}
public void ShouldAddUser()
{
//arrange
var user = new Users
{
Name = Guid.NewGuid().ToString().Substring(10)
};
var dataLayer = new DataLayer.SQL.DataLayer(ConnectionString);
//act
user = dataLayer.AddUser(user);
//asserts
var resultUser = dataLayer.GetUser(user.Id);
Assert.AreEqual(user.Name, resultUser.Name);
}
public void ShouldGetCommentsToImage()
{
// arrange
var comment = new Comment
{
Text = Guid.NewGuid().ToString(),
UserId = Guid.Parse("F94A87D3-BBB1-46C9-A487-57FDE39FB38B")
};
var dataLayer = new DataLayer.SQL.DataLayer(_connectionString);
// act
dataLayer.AddCommentToImage(Guid.Parse("176DCFA9-FDB7-4FAF-91CB-7E38D0C5F77C"), comment);
List <Comment> comments = dataLayer.GetImageComments(Guid.Parse("176DCFA9-FDB7-4FAF-91CB-7E38D0C5F77C"));
// asserts
Assert.IsTrue(comments.Exists(x => x.Text == comment.Text));
}
public void ShouldAddComment()
{
//arrange
var comment = new Comments
{
// PostId = Guid.NewGuid(),
PostId = Guid.Parse("4668F815-3D93-4D09-B6EB-1EA46F294F6F"),
Text = Guid.NewGuid().ToString().Substring(10)
};
//act
var dataLayer = new DataLayer.SQL.DataLayer(ConnectionString);
comment = dataLayer.AddComment(comment);
//asserts
var resultComment = dataLayer.GetComment(comment.Id);
Assert.AreEqual(comment.Text, resultComment.Text);
}
public void ShouldAddPost()
{
//arrange
var post = new Posts
{
// UserId = Guid.NewGuid(),
UserId = Guid.Parse("4448B3E0-21E0-4E48-90D4-B494226949FA"),
};
//act
var dataLayer = new DataLayer.SQL.DataLayer(ConnectionString);
post = dataLayer.AddPost(post);
//asserts
var resultPost = dataLayer.GetPost(post.Id);
Assert.AreEqual(post.UserId, resultPost.UserId);
}
public void ShouldAddComment()
{
// arrange
var comment = new Comment
{
Text = "AddTest",
UserId = Guid.Parse("F94A87D3-BBB1-46C9-A487-57FDE39FB38B")
};
var dataLayer = new DataLayer.SQL.DataLayer(_connectionString);
// act
var image = dataLayer.GetImage(Guid.Parse("176DCFA9-FDB7-4FAF-91CB-7E38D0C5F77C"));
comment = dataLayer.AddCommentToImage(image.Id, comment);
// asserts
var resultComment = dataLayer.GetComment(comment.Id);
Assert.AreEqual(comment.Text, resultComment.Text);
}
public void ShouldDeleteComment()
{
// arrange
var comment = new Comment
{
Text = Guid.NewGuid().ToString(),
UserId = Guid.Parse("F94A87D3-BBB1-46C9-A487-57FDE39FB38B")
};
var dataLayer = new DataLayer.SQL.DataLayer(_connectionString);
// act
var image = dataLayer.GetImage(Guid.Parse("176DCFA9-FDB7-4FAF-91CB-7E38D0C5F77C"));
comment = dataLayer.AddCommentToImage(image.Id, comment);
dataLayer.DeleteComment(comment.Id);
// asserts
List <Comment> resultComments = dataLayer.GetImageComments(image.Id);
Assert.IsFalse(resultComments.Exists(x => x.Text == comment.Text));
}
public void ShouldAddImage()
{
// arrange
var image = new Image
{
Picture = new byte[1],
UserId = Guid.Parse("F94A87D3-BBB1-46C9-A487-57FDE39FB38B"),
Time = DateTime.Now
};
image.Time = new DateTime(image.Time.Year, image.Time.Month, image.Time.Day, image.Time.Hour, image.Time.Minute, image.Time.Second, image.Time.Kind);
var dataLayer = new DataLayer.SQL.DataLayer(_connectionString);
// act
image = dataLayer.AddImage(image);
// asserts
var resultImage = dataLayer.GetImage(image.Id);
Assert.AreEqual(image.Time, resultImage.Time);
}
public void ShouldGetLastImages()
{
// arrange
var image = new Image
{
Picture = new byte[1],
UserId = Guid.Parse("F94A87D3-BBB1-46C9-A487-57FDE39FB38B"),
Time = DateTime.Now
};
image.Time = new DateTime(image.Time.Year, image.Time.Month, image.Time.Day, image.Time.Hour, image.Time.Minute, image.Time.Second, image.Time.Kind);
var dataLayer = new DataLayer.SQL.DataLayer(_connectionString);
// act
image = dataLayer.AddImage(image);
List <Image> lastImages = dataLayer.GetLastImages();
// asserts
Assert.IsTrue(lastImages.Count > 0);
}
