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 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);
}
//夜审
private void clearTool_Click(object sender, EventArgs e)
{
bool hasto = true;
DateTime now = GeneralClass.Now;
var cnt = db.ClearTable.FirstOrDefault(x => x.clearTime.Date == now.Date);
if (cnt != null)
{
ClearOptionsForm clearOptionsForm = new ClearOptionsForm(cnt.clearTime);
if (clearOptionsForm.ShowDialog() == DialogResult.OK)
{
db.ClearTable.DeleteOnSubmit(cnt);
db.SubmitChanges();
}
else
hasto = false;
}
if (!hasto)
return;
var seats = db.Seat.Where(x => x.status == 3);
foreach (Seat seat in seats)
{
BathClass.reset_seat(seat);
}
ClearTable ct = new ClearTable();
ct.clearTime = GeneralClass.Now;
db.ClearTable.InsertOnSubmit(ct);
db.SubmitChanges();
}
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 ErroneousArgumentSaveKeyFeatureClient()
{
KeyFeatureClient keyFeatureClient = CreateNew();
using (var db = new EntitesContext())
{
ClearTable.KeyFeatureClients(db);
keyFeatureClientL = Get(db);
keyFeatureClient.Initiator = null;
Assert.ThrowsException <ArgumentException>(() => keyFeatureClientL.Save(keyFeatureClient));
keyFeatureClient.Initiator = string.Empty;
Assert.ThrowsException <ArgumentException>(() => keyFeatureClientL.Save(keyFeatureClient));
keyFeatureClient.Initiator = "____";
keyFeatureClient.IdClient = 0;
Assert.ThrowsException <ArgumentException>(() => keyFeatureClientL.Save(keyFeatureClient));
keyFeatureClient.IdClient = -2;
Assert.ThrowsException <ArgumentException>(() => keyFeatureClientL.Save(keyFeatureClient));
keyFeatureClient.IdClient = 2;
keyFeatureClient.IdKeyFeature = 0;
Assert.ThrowsException <ArgumentException>(() => keyFeatureClientL.Save(keyFeatureClient));
keyFeatureClient.IdKeyFeature = -2;
Assert.ThrowsException <ArgumentException>(() => keyFeatureClientL.Save(keyFeatureClient));
}
}
public static string ConvertToJsonString(ClearTable clearTable)
{
return new JavaScriptSerializer().Serialize(new
{
id = clearTable.id,
clearTime = clearTable.clearTime.ToString("yyyy-MM-dd HH:mm:ss")
});
}
public static string ConvertToJsonString(ClearTable clearTable)
{
return(new JavaScriptSerializer().Serialize(new
{
id = clearTable.id,
clearTime = clearTable.clearTime.ToString("yyyy-MM-dd HH:mm:ss")
}));
}
public void GetByIdNoDBHaspKey()
{
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
haspKeyDAO = new DbHaspKeyDAO(db);
Assert.IsNull(haspKeyDAO.GetById(1));
}
}
public void GetByNumberKeyNoDBClient()
{
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
clientL = Get(db);
Assert.IsNull(clientL.GetByNumberKey(2));
}
}
public void RemoveNoDBHaspKey()
{
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
kfcDAO = new DbKeyFeatureClientDAO(db);
kfcDAO.Add(CreateNew());
Assert.IsFalse(kfcDAO.Remove(12));
}
}
public void AddDuplicateHaspKey()
{
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
haspKeyDAO = new DbHaspKeyDAO(db);
haspKeyDAO.Add(CreateNew());
Assert.AreEqual(haspKeyDAO.Add(CreateNew()), -1);
}
}
public void RemoveNoDBHaspKey()
{
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
keyFeatureClientL = Get(db);
keyFeatureClientL.Save(CreateNew());
Assert.IsFalse(keyFeatureClientL.Remove(12));
}
}
public void RemoveNoDBKeyFeature()
{
using (var db = new EntitesContext())
{
ClearTable.KeyFeatures(db);
keyFeatureL = Get(db);
keyFeatureL.Save(CreateNew());
Assert.IsFalse(keyFeatureL.Remove(123));
}
}
public void RemoveNoDBClient()
{
using (var db = new EntitesContext())
{
ClearTable.Clients(db);
clientDAO = new DbClientDAO(db);
clientDAO.Add(CreateNew());
Assert.IsFalse(clientDAO.Remove(123));
}
}
public void RemoveNoDBKeyFeature()
{
using (var db = new EntitesContext())
{
ClearTable.KeyFeatures(db);
kfDAO = new DbKeyFeatureDAO(db);
kfDAO.Add(CreateNew());
Assert.IsFalse(kfDAO.Remove(123));
}
}
public void RemoveNoDBHaspKey()
{
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
haspKeyDAO = new DbHaspKeyDAO(db);
haspKeyDAO.Add(CreateNew());
Assert.IsFalse(haspKeyDAO.Remove(123));
}
}
public void RemoveNoDBHaspKey()
{
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
haspKeyL = Get(db);
haspKeyL.Save(CreateNew());
Assert.IsFalse(haspKeyL.Remove(123));
}
}
public void RemoveNoDBClient()
{
using (var db = new EntitesContext())
{
ClearTable.Clients(db);
clientL = Get(db);
clientL.Save(CreateNew());
Assert.IsFalse(clientL.Remove(123));
}
}
/// <summary>
/// Отчистка словаря в базе данных
/// </summary>
public void ClearDictionary()
{
try
{
ClearTable.ExecuteNonQuery();
}
catch (Exception e)
{
Program.ConsoleWrite($"Ошибка: {e.Message}", 3);
}
}
public void ContainsDBKeyFeature()
{
var keyFeat = CreateNew();
using (var db = new EntitesContext())
{
ClearTable.KeyFeatures(db);
kfDAO = new DbKeyFeatureDAO(db);
kfDAO.Add(keyFeat);
Assert.IsTrue(kfDAO.ContainsDB(keyFeat));
}
}
public void SaveHaspKey()
{
bool add;
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
haspKeyL = Get(db);
add = haspKeyL.Save(CreateNew());
}
Assert.IsTrue(add);
}
public void ContainsDBKeyFeatureClient()
{
var keyFeatCl = CreateNew();
using (var db = new EntitesContext())
{
ClearTable.KeyFeatureClients(db);
kfcDAO = new DbKeyFeatureClientDAO(db);
kfcDAO.Add(keyFeatCl);
Assert.IsTrue(kfcDAO.ContainsDB(keyFeatCl));
}
}
public void ContainsDBHaspKey()
{
var key = CreateNew();
using (var db = new EntitesContext())
{
ClearTable.HaspKeys(db);
haspKeyDAO = new DbHaspKeyDAO(db);
haspKeyDAO.Add(key);
Assert.IsTrue(haspKeyDAO.ContainsDB(key));
}
}
public void SaveKeyFeature()
{
bool add;
using (var db = new EntitesContext())
{
ClearTable.KeyFeatures(db);
keyFeatureL = Get(db);
add = keyFeatureL.Save(CreateNew());
}
Assert.IsTrue(add);
}
public void ContainsDBFeature()
{
var feature = CreateNew();
using (var db = new EntitesContext())
{
ClearTable.Features(db);
featureDAO = new DbFeatureDAO(db);
featureDAO.Add(feature);
Assert.IsTrue(featureDAO.ContainsDB(feature));
}
}
public void GetByIdNoDBFeature()
{
Feature getById;
using (var db = new EntitesContext())
{
ClearTable.Features(db);
featureDAO = new DbFeatureDAO(db);
getById = featureDAO.GetById(1);
}
Assert.IsNull(getById);
}
public void ContainsDBClient()
{
var client = CreateNew();
using (var db = new EntitesContext())
{
ClearTable.Clients(db);
clientDAO = new DbClientDAO(db);
clientDAO.Add(client);
Assert.IsTrue(clientDAO.ContainsDB(client));
}
}
public void AddKeyFeature()
{
int idExpected = 1;
int add;
using (var db = new EntitesContext())
{
ClearTable.KeyFeatures(db);
kfDAO = new DbKeyFeatureDAO(db);
add = kfDAO.Add(CreateNew());
}
Assert.AreEqual(add, idExpected);
}
public void SaveClient()
{
bool add;
using (var db = new EntitesContext())
{
ClearTable.Clients(db);
clientL = Get(db);
add = clientL.Save(CreateNew());
}
Assert.IsTrue(add);
}
public void GetAllEmptyClient()
{
var getAll = new List <Client>();
var clientExpected = new List <Client>();
using (var db = new EntitesContext())
{
ClearTable.Clients(db);
clientL = Get(db);
getAll = clientL.GetAll();
}
CollectionAssert.AreEqual(getAll, clientExpected);
}
public void GetByIdNoDBClient()
{
Client getById;
using (var db = new EntitesContext())
{
ClearTable.Clients(db);
clientL = Get(db);
getById = clientL.GetById(1);
}
Assert.IsNull(getById);
}
