public void TestCreate()
{
var user = new PassOneUser(_service.GetNextIdValue(), TestUser2.FirstName, TestUser2.LastName,
TestUser2.Username,
TestUser2.Password, TestUser2.k, TestUser2.v);
_service.Create(user);
User actual;
using (var db = new PassOneContext())
{
db.Database.Connection.Open();
var query = from u in db.Users select u;
actual = query.ToList().FirstOrDefault(user1 => user1.Id == user.Id);
}
Assert.IsNotNull(actual);
using (var db = new PassOneContext())
{
db.Database.Connection.Open();
var userQuery = from u in db.Users select u;
var remove = userQuery.ToList().FirstOrDefault(user1 => user1.Id == user.Id);
db.Users.Remove(remove);
db.SaveChanges();
}
}
public void TestDelete()
{
_service.Delete(ConvertToDomainObject(TestCredentials));
using (var db = new PassOneContext())
{
var query = from u in db.Credentials select u;
var actual = query.ToList().FirstOrDefault(creds => creds.Id == TestCredentials.Id);
Assert.IsNull(actual);
}
}
public void TestDelete()
{
using (var db = new PassOneContext())
{
db.Database.Connection.Open();
var credsQuery = from c in db.Credentials select c;
var creds = credsQuery.ToList().FirstOrDefault((creds1 => creds1.Id == TestCredentials.Id));
db.Credentials.Remove(creds);
db.SaveChanges();
var user = new PassOneUser(TestUser.Id, TestUser.FirstName, TestUser.LastName, TestUser.Username,
TestUser.Password, TestUser.k, TestUser.v);
_service.Delete(user);
var userQuery = from u in db.Users select u;
var actual = userQuery.ToList().FirstOrDefault(user1 => user1.Id == user.Id);
Assert.IsNull(actual);
}
}
public void TestCreate()
{
var creds = ConvertToDomainObject(TestCredentials);
_service.Create(creds);
PassOneCredentials expected = creds;
PassOneCredentials actual;
using (var db = new PassOneContext())
{
db.Database.Connection.Open();
var query = from u in db.Credentials select u;
actual = ConvertToDomainObject(query.ToList().FirstOrDefault(creds1 => creds1.Id == creds.Id));
}
Assert.AreEqual(expected, actual);
using (var db = new PassOneContext())
{
db.Database.Connection.Open();
var credsQuery = from c in db.Credentials select c;
var remove = credsQuery.ToList().FirstOrDefault(creds1 => creds1.Id == creds.Id);
db.Credentials.Remove(remove);
db.SaveChanges();
}
}
public void Setup()
{
try
{
using (var db = new PassOneContext())
{
db.Database.Connection.Open();
TestCredentials.UserId = TestUser.Id;
TestUser.Credentials.Add(TestCredentials);
db.Users.Add(TestUser);
db.Credentials.Add(TestCredentials);
db.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
catch (Exception)
{
}
}
public void TearDown()
{
using (var db = new PassOneContext())
{
try
{
db.Database.Connection.Open();
var credsQuery = from c in db.Credentials select c;
var creds = credsQuery.ToList().FirstOrDefault((creds1 => creds1.Id == TestCredentials.Id));
db.Credentials.Remove(creds);
db.SaveChanges();
}
catch
{
}
try
{
var userQuery = from u in db.Users select u;
var user = userQuery.ToList().FirstOrDefault(user1 => user1.Id == TestUser.Id);
db.Users.Remove(user);
db.SaveChanges();
}
catch
{
}
}
TestUser.Credentials = null;
TestCredentials.UserId = 0;
}