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