public void ConnectionTest()
{
using (IceJamsDBContext context = new IceJamsDBContext(new DbContextOptionsBuilder <IceJamsDBContext>().UseNpgsql(this.connectionstring, x => x.UseNetTopologySuite()).Options))
{
try
{
if (!(context.GetService <IDatabaseCreator>() as RelationalDatabaseCreator).Exists())
{
throw new Exception("db does ont exist");
}
}
catch (Exception ex)
{
Assert.IsTrue(false, ex.Message);
}
}
}
public void QueryTest()
{
using (IceJamsDBContext context = new IceJamsDBContext(new DbContextOptionsBuilder <IceJamsDBContext>().UseNpgsql(this.connectionstring, x => x.UseNetTopologySuite()).Options))
{
try
{
var testQuery = context.IceJams.ToList();
Assert.IsNotNull(testQuery, testQuery.Count.ToString());
}
catch (Exception ex)
{
Assert.IsTrue(false, ex.Message);
}
finally
{
}
}
}
public void AddManagerTest()
{
using (IceJamsDBContext context = new IceJamsDBContext(new DbContextOptionsBuilder <IceJamsDBContext>().UseNpgsql(this.connectionstring, x => x.UseNetTopologySuite()).Options))
{
try
{
var salt = Cryptography.CreateSalt();
var password = "";
if (String.IsNullOrEmpty(password))
{
throw new Exception("password cannot be empty");
}
Observer observer = new Observer()
{
FirstName = "Test",
Email = "*****@*****.**",
LastName = "Administrator",
RoleID = 1,
Username = "******",
Password = Cryptography.GenerateSHA256Hash(password, salt),
Salt = salt
};
context.Observers.Add(observer);
context.SaveChanges();
Assert.IsTrue(Cryptography.VerifyPassword(password, observer.Salt, observer.Password));
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
finally
{
}
}
}
public IceJamsAgent(IceJamsDBContext context) : base(context)
{
//optimize query for disconnected databases.
this.context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
}
