public void InsertAddsConnectionToDb()
{
var db = new AppDbContext(appDbOptions);
var repo = new ConnectorRepo(db, factory, new IOperationResource[] { });
ConnectorViewModel model = new ConnectorViewModel
{
Name = "name1",
ResourceType = "type1",
RecordLimit = 12,
Port = 123,
InitialCatalog = "cat1",
DataSource = "src",
UserId = "id"
};
Guid id = repo.Insert(model);
Connector actual;
using (var db1 = new AppDbContext(appDbOptions))
{
actual = db1.Connector.First(c => c.Name == "name1");
}
Assert.AreEqual("type1", actual.ResourceType);
Assert.AreEqual(12, actual.RecordLimit);
Assert.AreEqual("cat1", connectionInformation.InitialCatalog);
Assert.AreEqual("src", connectionInformation.DataSource);
Assert.AreEqual("id", connectionInformation.UserId);
Assert.AreEqual(123, actual.Port);
Assert.AreEqual("conn1", actual.ConnectionString);
}
public void GetConnectorCountFromDb()
{
using (var db1 = new AppDbContext(appDbOptions))
{
db1.Connector.AddRange(new Connector
{
Id = Guid.NewGuid(),
Name = "name123",
},
new Connector
{
Id = Guid.NewGuid(),
Name = "aname123",
});
db1.SaveChanges();
}
var db = new AppDbContext(appDbOptions);
var repo = new ConnectorRepo(db, factory, new IOperationResource[] { });
var count = repo.ConnectorCount();
Assert.AreEqual(2, count);
}
public void DeleteConnectorRemovesFromDb()
{
using (var db1 = new AppDbContext(appDbOptions))
{
db1.Connector.AddRange(new Connector
{
Id = Guid.NewGuid(),
Name = "name123",
},
new Connector
{
Id = id,
Name = "aname123",
});
db1.SaveChanges();
}
var db = new AppDbContext(appDbOptions);
var repo = new ConnectorRepo(db, factory, new IOperationResource[] { });
repo.Delete(id);
using (var db1 = new AppDbContext(appDbOptions))
{
var results = db1.Connector.ToList();
Assert.AreEqual(1, results.Count());
Assert.AreEqual("name123", results.First().Name);
}
}
public void ListConnectorsOrdersByName()
{
using (var db1 = new AppDbContext(appDbOptions))
{
db1.Connector.AddRange(new Connector
{
Id = id,
Name = "name123",
},
new Connector
{
Id = Guid.NewGuid(),
Name = "aname123",
});
db1.SaveChanges();
}
var db = new AppDbContext(appDbOptions);
var repo = new ConnectorRepo(db, factory, new IOperationResource[] { });
var results = repo.ListConnectors();
Assert.AreEqual(2, results.Count());
Assert.AreEqual("aname123", results.First().Name);
}
public void GetConnectorById()
{
using (var db1 = new AppDbContext(appDbOptions))
{
db1.Connector.Add(new Connector
{
Id = id,
Name = "name123",
ResourceType = "type1",
ConnectionString = "conn1"
});
db1.SaveChanges();
}
var db = new AppDbContext(appDbOptions);
var resource = new Mock <IOperationResource>();
resource.Setup(c => c.ResourceType).Returns("type1");
var repo = new ConnectorRepo(db, factory, new IOperationResource[] { resource.Object });
var actual = repo.GetById(id);
Assert.AreEqual("name123", actual.Name);
}
public void Init()
{
var appDbOptions = new DbContextOptionsBuilder <AppDbContext>()
.UseInMemoryDatabase(databaseName: "appDb" + Guid.NewGuid().ToString())
.Options;
db = new AppDbContext(appDbOptions);
repo = new ConnectorRepo(db, Mock.Of <IConnectionStringFactory>(), new IOperationResource[] { });
errors = new Dictionary <string, string>();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (Convert.ToDouble(GamePrice) <= Convert.ToDouble(moneyValue))
{
try
{
Connector connector = new Connector(Assets.Scripts.Login.UserLogin, Convert.ToInt32(GameID));
ConnectorRepo.Insert(connector);
Users user = new Users(Assets.Scripts.Login.UserLogin, User.Money);
UsersRepo.Update(user, -1 * Convert.ToDouble(GamePrice));
MessageBox.Show("Game was added to your account!");
SetData();
}
catch
{
}
}
}