public IHttpActionResult InitializeDB()
{
var data = new Dbobjects();
var db = data.LiteDb;
var clients = db.GetCollection <DBClient>("clients");
var clientList = clients.FindAll();
//db.DropCollection("clients");
//db.DropCollection("cards");
//db.DropCollection("accesspoints");
//db.DropCollection("accesspointDetails");
db.DropCollection("customerEvents");
//var accesspointsList = db.GetCollection<DBAccessPoint>("accesspoints");
//var accesspointDetailsList = db.GetCollection<DBAccessPointDetail>("accesspointDetails");
//for (var i = 1; i < 21; i++)
//{
// var accesspoint = new DBAccessPoint()
// {
// accesspointguid = Guid.NewGuid().ToString(),
// installationid = "0",
// accesspointid = i.ToString(),
// name = $"AccessPoint {i}"
// };
// accesspointsList.Insert(accesspoint);
// var accesspointDetail = new DBAccessPointDetail()
// {
// accesspointguid = accesspoint.accesspointguid,
// installationid = "0",
// accesspointid = accesspoint.accesspointid,
// serial = Guid.NewGuid().ToString()
// };
// accesspointDetailsList.Insert(accesspointDetail);
//}
//// Get card collection
//var cards = db.GetCollection<DBCard>("cards");
//for (int i = 1; i < 201; i++)
//{
// var card = new DBCard()
// {
// RFID = GetRandomHexNumber(14)
// };
// cards.Insert(card);
//}
//var cards = db.GetCollection<DBCard>("cards");
//var cardsAvaileable = cards.FindAll().Select(x => x.RFID).ToArray();
var events = db.GetCollection <DBEvents>("customerEvents");
for (var i = 1; i < 1001; i++)
{
var customerEvent = new DBEvents()
{
installationid = "0",
accesspointid = VendorDL.GetRandomAccessPoint().accesspointid,
customerkey = VendorDL.GetRandomClient(),
eventtype = new Random().Next(0, 4).ToString(),
rfid = VendorDL.GetRandomCard(),
EventDate = VendorDL.GetRandomEventDate(),
unit = "kilo",
value = new Random().Next(1, 100).ToString(),
vendorid = "0",
size = "N",
wpn = "Rest"
};
events.Insert(customerEvent);
}
return(Ok());
}
private static void InitializeTestData()
{
/**************************************************
* Testparameters spesific to current test
**************************************************/
Type = TestType.REST;
_installationID = "123";
//Add accesspoints - at least 3
AvailableAccessPoints = new List <AccessPoint>();
var ap1 = new AccessPoint {
accesspointid = "1718", tag = "", name = "1"
};
AvailableAccessPoints.Add(ap1);
var ap2 = new AccessPoint {
accesspointid = "1719", tag = "", name = "2"
};
AvailableAccessPoints.Add(ap2);
var ap3 = new AccessPoint {
accesspointid = "1720", tag = "", name = "3"
};
AvailableAccessPoints.Add(ap3);
/**************************************************
* Generic testparameters - no need to touch.....
**************************************************/
_allAccessPoints = new AccessPointData {
InstallationID = InstallationID, Type = AccessPointData.AccessPointType.ALL
};
_accessPointsByID = new AccessPointData {
InstallationID = InstallationID, Type = AccessPointData.AccessPointType.ID, AccessPoint = ap1.accesspointid
};
_accessPointsByName = new AccessPointData {
InstallationID = InstallationID, Type = AccessPointData.AccessPointType.NAME, AccessPoint = ap2.name
};
_accessPointsByTag = new AccessPointData {
InstallationID = InstallationID, Type = AccessPointData.AccessPointType.TAG, AccessPoint = ap3.tag
};
_apOutOfOrder = new AccessPointOutOfOrderData {
InstallationID = TestSetup.InstallationID, AccessPoint = ap1.name, Message = "Out of Order", Type = AccessPointData.AccessPointType.NAME
};
if (Type == TestType.LiteDB)
{
AvailableAccessPoints.Add(VendorDL.GetRandomAccessPoint());
AvailableAccessPoints.Add(VendorDL.GetRandomAccessPoint());
AvailableAccessPoints.Add(VendorDL.GetRandomAccessPoint());
}
_availableCards = new Stack <string>();
// Generate RFID cards
for (var i = 0; i < 50; i++)
{
_availableCards.Push(Utils.GetRandomHexString());
}
HouseHoldClient = new HouseHoldClientData
{
Customerguid = Guid.NewGuid().ToString(),
Customerid = Utils.GetRandomNumber(1001, 1000000).ToString(),
Description = "sample client description",
Primary = AvailableAccessPoints[0].accesspointid,
Secondary1 = AvailableAccessPoints[1].accesspointid,
Propertyunit = "Propertyunitstring",
Streetaddress = "Customer address",
RFID = _availableCards.Pop() + ";" + _availableCards.Pop(),
InstallationID = InstallationID
};
HouseHoldClient2 = new HouseHoldClientData
{
Customerguid = Guid.NewGuid().ToString(),
Customerid = Utils.GetRandomNumber(1001, 1000000).ToString(),
Description = "testclient - to be deleted during test",
Primary = AvailableAccessPoints[0].accesspointid,
Secondary1 = AvailableAccessPoints[1].accesspointid,
Propertyunit = "Propertyunitstring",
Streetaddress = "Customer address",
RFID = _availableCards.Pop() + ";" + _availableCards.Pop(),
InstallationID = InstallationID
};
CommercialClient = new CommercialClientData
{
Name = "Commercial name",
Customerguid = Guid.NewGuid().ToString(),
Customerid = new Random().Next(1001, 1000000).ToString(),
Description = "sample client description",
Primary = AvailableAccessPoints[0].accesspointid,
Secondary1 = AvailableAccessPoints[1].accesspointid,
Propertyunit = "Propertyunitstring",
Streetaddress = "Customer address",
RFID = _availableCards.Pop() + ";" + _availableCards.Pop(),
InstallationID = InstallationID
};
RequestAllEvents = new EventsData
{
Customerkey = "ALL",
FromDate = DateTime.Now.AddDays(-100),
ToDate = DateTime.Now,
InstallationID = InstallationID
};
if (Client1 == null)
{
var c1 = JsonConvert.DeserializeObject <Client>(Utils.GetSetting("Client1"));
if (c1 != null)
{
Client1 = c1;
}
var c2 = JsonConvert.DeserializeObject <Client>(Utils.GetSetting("Client2"));
if (c2 != null)
{
Client2 = c2;
}
}
}
