public void Successful() { var userId = Guid.Empty; var user = new Core.Data.Model.User { Id = userId, UserName = "******", FirstName = "Test", LastName = "Tester", DisplayName = "Tester", Email = "*****@*****.**", Active = true, CreatedDate = DateTime.Parse("06/16/2013") }; var persistor = new Core.Data.Persistor.User(); persistor.Save(user); persistor.Commit(); Assert.NotEqual(Guid.Empty, user.Id); const string sqlFormatter = "IF NOT EXISTS (" + "SELECT COUNT(*) FROM Users WHERE Id = '{0}' HAVING COUNT(*) = 1" + ") RAISERROR ('Error creating user.',16,1);"; var sql = string.Format(sqlFormatter, user.Id); persistor.DbContext.Database.ExecuteSqlCommand(sql); }
private void VerifyDelete(string sql) { var persistor = new Core.Data.Persistor.User(); if (!string.IsNullOrEmpty(sql)) { persistor.DbContext.Database.ExecuteSqlCommand(sql); } persistor.Delete(_userId); persistor.Commit(); const string sqlFormatter = "IF EXISTS (" + "SELECT COUNT(*) FROM Users WHERE Id = '{0}' HAVING COUNT(*) > 0" + ") RAISERROR ('Error deleting user.',16,1);"; var deleteCheckSql = string.Format(sqlFormatter, _userId); persistor.DbContext.Database.ExecuteSqlCommand(deleteCheckSql); }
public void DuplicateEmail() { var persistor = new Core.Data.Persistor.User(); var sql = Utils.User.GetInsertScript(Guid.Parse("{5CEAD906-4825-4357-A60D-F0363B247CA6}"), "tester12", "*****@*****.**"); persistor.DbContext.Database.ExecuteSqlCommand(sql); sql = "IF NOT EXISTS (" + "SELECT COUNT(*) FROM Users WHERE Id = '{5CEAD906-4825-4357-A60D-F0363B247CA6}' " + "HAVING COUNT(*) = 1) RAISERROR ('Error creating user.',16,1); "; persistor.DbContext.Database.ExecuteSqlCommand(sql); var userId = Guid.Empty; var user = new Core.Data.Model.User { Id = userId, UserName = "******", FirstName = "Test", LastName = "Tester", DisplayName = "Tester", Active = true, Email = "*****@*****.**", CreatedDate = DateTime.Now }; persistor.Save(user); Exception ex = Assert.Throws <System.Data.Entity.Infrastructure.DbUpdateException>(() => persistor.Commit()); Assert.NotNull(ex.InnerException.InnerException); Assert.True(ex.InnerException.InnerException.Message.Contains("IX_User_Email")); Assert.True(ex.InnerException.InnerException.Message.Contains("*****@*****.**")); }