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