public void GetByPastDueHaspKey()
{
List <HaspKey> GetByActive;
var GetByActiveExpected = new List <HaspKey>
{
new HaspKey
{
Id = 2,
InnerId = 2,
Number = "uz-3",
IsHome = true,
TypeKey = TypeKey.Pro,
}
};
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
ClearTable.KeyFeatures(db);
haspKeyDAO = new DbHaspKeyDAO(db);
db.HaspKeys.AddRange(CreateListEntities.HaspKeys());
db.KeyFeatures.AddRange(CreateListEntities.KeyFeatures());
db.SaveChanges();
GetByActive = haspKeyDAO.GetByPastDue();
}
CollectionAssert.AreEqual(GetByActive, GetByActiveExpected);
}
public void GetByFeatureClient()
{
List <Client> getByFeature;
using (var db = new EntitesContext())
{
ClearTable.Features(db);
ClearTable.KeyFeatures(db);
ClearTable.Clients(db);
ClearTable.KeyFeatureClients(db);
clientL = Get(db);
db.Features.AddRange(CreateListEntities.Features());
db.KeyFeatures.AddRange(CreateListEntities.KeyFeatures());
db.Clients.AddRange(CreateListEntities.Clients());
db.KeyFeatureClients.AddRange(CreateListEntities.KeyFeatureClients());
db.SaveChanges();
getByFeature = clientL.GetByFeature(new Feature
{
Id = 1,
Number = 1,
Name = "qwe",
});
}
CollectionAssert.AreEqual(getByFeature, CreateListEntities.Clients());
}
public void GetByClientHaspKey()
{
List <HaspKey> getByClient;
var getByClientExpected = new List <HaspKey>
{
CreateNew(1),
};
var client = new Client
{
Id = 1,
Name = "Ivanov Ivan",
};
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
ClearTable.KeyFeatures(db);
ClearTable.KeyFeatureClients(db);
haspKeyDAO = new DbHaspKeyDAO(db);
db.HaspKeys.AddRange(CreateListEntities.HaspKeys());
db.KeyFeatures.AddRange(CreateListEntities.KeyFeatures());
db.KeyFeatureClients.AddRange(CreateListEntities.KeyFeatureClients());
db.SaveChanges();
getByClient = haspKeyDAO.GetByClient(client);
}
CollectionAssert.AreEqual(getByClient, getByClientExpected);
}
public void RemoveKeyFeatureClient()
{
bool remove;
using (var db = new EntitesContext())
{
ClearTable.KeyFeatureClients(db);
keyFeatureClientL = Get(db);
db.KeyFeatureClients.AddRange(CreateListEntities.KeyFeatureClients());
db.SaveChanges();
remove = keyFeatureClientL.Remove(1);
}
Assert.IsTrue(remove);
}
public void GetAllKeyFeatureClient()
{
var getAll = new List <KeyFeatureClient>();;
var keyFeatCls = CreateListEntities.KeyFeatureClients();
using (var db = new EntitesContext())
{
ClearTable.KeyFeatureClients(db);
keyFeatureClientL = Get(db);
foreach (var kfc in keyFeatCls)
{
keyFeatureClientL.Save(kfc);
}
getAll = keyFeatureClientL.GetAll();
}
CollectionAssert.AreEqual(getAll, keyFeatCls);
}
public void GetAllClient()
{
List <Client> getAll;
var clients = CreateListEntities.Clients();
using (var db = new EntitesContext())
{
ClearTable.Clients(db);
clientL = Get(db);
foreach (var cl in clients)
{
clientL.Save(cl);
}
getAll = clientL.GetAll();
}
CollectionAssert.AreEqual(getAll, clients);
}
public void GetAllKeyFeature()
{
var getAll = new List <KeyFeature>();
var keyFeats = CreateListEntities.KeyFeatures();
using (var db = new EntitesContext())
{
ClearTable.KeyFeatures(db);
kfDAO = new DbKeyFeatureDAO(db);
foreach (var kf in keyFeats)
{
kfDAO.Add(kf);
}
getAll = kfDAO.GetAll();
}
CollectionAssert.AreEqual(getAll, keyFeats);
}
public void GetAllHaspKey()
{
var getAll = new List <HaspKey>();;
var haspKeys = CreateListEntities.HaspKeys();
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
haspKeyDAO = new DbHaspKeyDAO(db);
foreach (var key in haspKeys)
{
haspKeyDAO.Add(key);
}
getAll = haspKeyDAO.GetAll();
}
CollectionAssert.AreEqual(getAll, haspKeys);
}
public void GetAllFeature()
{
var getAll = new List <Feature>();
var features = CreateListEntities.Features();
using (var db = new EntitesContext())
{
ClearTable.Features(db);
featureDAO = new DbFeatureDAO(db);
foreach (var feat in features)
{
featureDAO.Add(feat);
}
getAll = featureDAO.GetAll();
}
CollectionAssert.AreEqual(getAll, features);
}
public void RemoveHaspKey()
{
bool remove;
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
ClearTable.KeyFeatures(db);
ClearTable.KeyFeatureClients(db);
haspKeyDAO = new DbHaspKeyDAO(db);
db.HaspKeys.AddRange(CreateListEntities.HaspKeys());
db.KeyFeatures.AddRange(CreateListEntities.KeyFeatures());
db.KeyFeatureClients.AddRange(CreateListEntities.KeyFeatureClients());
db.SaveChanges();
remove = haspKeyDAO.Remove(1);
}
Assert.IsTrue(remove);
}
public void GetAllKeyFeature()
{
var getAll = new List <KeyFeature>();
var keyFeats = CreateListEntities.KeyFeatures();
using (var db = new EntitesContext())
{
ClearTable.KeyFeatures(db);
keyFeatureL = Get(db);
// Добавляем на прямую, чтобы избежать проверки логики.
foreach (var kf in keyFeats)
{
db.KeyFeatures.Add(kf);
}
db.SaveChanges();
getAll = keyFeatureL.GetAll();
}
CollectionAssert.AreEqual(getAll, keyFeats);
}
public void GetByNumberKeyClient()
{
Client getByNumberKey;
Client actual = CreateListEntities.Clients()[0];
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
ClearTable.KeyFeatures(db);
ClearTable.Clients(db);
ClearTable.KeyFeatureClients(db);
clientL = Get(db);
db.HaspKeys.AddRange(CreateListEntities.HaspKeys());
db.KeyFeatures.AddRange(CreateListEntities.KeyFeatures());
db.Clients.AddRange(CreateListEntities.Clients());
db.KeyFeatureClients.AddRange(CreateListEntities.KeyFeatureClients());
db.SaveChanges();
getByNumberKey = clientL.GetByNumberKey(1);
}
Assert.AreEqual(getByNumberKey, actual);
}
public void GetByActiveHaspKey()
{
List <HaspKey> GetByActive;
var GetByActiveExpected = new List <HaspKey>
{
CreateNew(1),
};
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
ClearTable.KeyFeatures(db);
haspKeyDAO = new DbHaspKeyDAO(db);
db.HaspKeys.AddRange(CreateListEntities.HaspKeys());
db.KeyFeatures.AddRange(CreateListEntities.KeyFeatures());
db.SaveChanges();
GetByActive = haspKeyDAO.GetByActive();
}
CollectionAssert.AreEqual(GetByActive, GetByActiveExpected);
}
