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); }
public IsUserNameInUseFixture() : base() { var persistor = new Core.Data.Persistor.User(); persistor.DbContext.Database.ExecuteSqlCommand(Utils.User.GetInsertScript()); }
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("*****@*****.**")); }
public void Full() { var clientId = Guid.NewGuid(); var invoiceId = Guid.NewGuid(); var persistor = new Core.Data.Persistor.User(); // insert client persistor.DbContext.Database.ExecuteSqlCommand( Utils.Client.GetInsertScript(clientId, _userId)); // insert client contact persistor.DbContext.Database.ExecuteSqlCommand( Utils.ClientContact.GetInsertScript(Guid.NewGuid(), clientId)); // insert invoice persistor.DbContext.Database.ExecuteSqlCommand( Utils.Invoice.GetInsertScript(invoiceId, clientId, DateTime.Now, _userId)); // insert invoice item persistor.DbContext.Database.ExecuteSqlCommand( Utils.InvoiceItem.GetInsertScript(Guid.NewGuid(), invoiceId, 2, 320000)); // insert payment persistor.DbContext.Database.ExecuteSqlCommand( Utils.Payment.GetInsertScript(Guid.NewGuid(), invoiceId, 640000)); VerifyDelete(string.Empty); }
public DeleteFixture() { _userId = Guid.NewGuid(); var persistor = new Core.Data.Persistor.User(); persistor.DbContext.Database.ExecuteSqlCommand( Utils.User.GetInsertScript(_userId, "test-username", "*****@*****.**")); }
public SaveFixture() { _userId = Guid.NewGuid(); _clientId = Guid.NewGuid(); var repo = new Core.Data.Persistor.User(); repo.DbContext.Database.ExecuteSqlCommand( Utils.User.GetInsertScript(_userId, "test-username", "*****@*****.**")); repo.DbContext.Database.ExecuteSqlCommand( Utils.Client.GetInsertScript(_clientId, _userId, "client-company")); }
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 InUseWithUserIdProvided() { var isUse = new Core.Data.Persistor.User().IsUserNameInUse("tester", Guid.NewGuid()); Assert.True(isUse); }
public void NotInUseWithUserIdProvided() { var isUse = new Core.Data.Persistor.User().IsUserNameInUse("tester", Guid.Parse("{39E50EDC-AA66-42AB-9D92-858E628E2FAC}")); Assert.False(isUse); }
public void InUser() { var isUse = new Core.Data.Persistor.User().IsUserNameInUse("tester"); Assert.True(isUse); }
public void NotInUse() { var isUse = new Core.Data.Persistor.User().IsUserNameInUse("new-tester"); Assert.False(isUse); }