public void IntegrationTest()
{
var connection = TestSession.GetConnection();
connection.Open();
#region good insertion and select by id test
BillOfMaterialsModel inserted = new BillOfMaterialsModel();
inserted.ProductAssemblyID = TestSession.Random.Next();
inserted.ComponentID = TestSession.Random.Next();
inserted.StartDate = TestSession.Random.RandomDateTime();
inserted.EndDate = TestSession.Random.RandomDateTime();
inserted.UnitMeasureCode = TestSession.Random.RandomString(3);
inserted.BOMLevel = TestSession.Random.RandomShort();
inserted.PerAssemblyQty = TestSession.Random.RandomDecimal(8, 2);
inserted.ModifiedDate = TestSession.Random.RandomDateTime();
_tested.Insert(connection, new[] { inserted });
var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new BillOfMaterialsModelPrimaryKey()
{
BillOfMaterialsID = inserted.BillOfMaterialsID,
});
CollectionAssert.IsNotEmpty(selectedAfterInsertion);
var selectedAfterInsert = selectedAfterInsertion.Single();
Assert.AreEqual(inserted.BillOfMaterialsID, selectedAfterInsert.BillOfMaterialsID);
Assert.AreEqual(inserted.ProductAssemblyID, selectedAfterInsert.ProductAssemblyID);
Assert.AreEqual(inserted.ComponentID, selectedAfterInsert.ComponentID);
Assert.AreEqual(inserted.StartDate, selectedAfterInsert.StartDate);
Assert.AreEqual(inserted.EndDate, selectedAfterInsert.EndDate);
Assert.AreEqual(inserted.UnitMeasureCode, selectedAfterInsert.UnitMeasureCode);
Assert.AreEqual(inserted.BOMLevel, selectedAfterInsert.BOMLevel);
Assert.AreEqual(inserted.PerAssemblyQty, selectedAfterInsert.PerAssemblyQty);
Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate);
#endregion
#region update and select by id test
inserted.ProductAssemblyID = TestSession.Random.Next();
inserted.ComponentID = TestSession.Random.Next();
inserted.StartDate = TestSession.Random.RandomDateTime();
inserted.EndDate = TestSession.Random.RandomDateTime();
inserted.UnitMeasureCode = TestSession.Random.RandomString(3);
inserted.BOMLevel = TestSession.Random.RandomShort();
inserted.PerAssemblyQty = TestSession.Random.RandomDecimal(8, 2);
inserted.ModifiedDate = TestSession.Random.RandomDateTime();
_tested.Update(connection, new[] { inserted });
var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new BillOfMaterialsModelPrimaryKey()
{
BillOfMaterialsID = inserted.BillOfMaterialsID,
});
CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss);
var selectedAfterUpdate = selectedAfterUpdateAddresss.Single();
Assert.AreEqual(inserted.BillOfMaterialsID, selectedAfterUpdate.BillOfMaterialsID);
Assert.AreEqual(inserted.ProductAssemblyID, selectedAfterUpdate.ProductAssemblyID);
Assert.AreEqual(inserted.ComponentID, selectedAfterUpdate.ComponentID);
Assert.AreEqual(inserted.StartDate, selectedAfterUpdate.StartDate);
Assert.AreEqual(inserted.EndDate, selectedAfterUpdate.EndDate);
Assert.AreEqual(inserted.UnitMeasureCode, selectedAfterUpdate.UnitMeasureCode);
Assert.AreEqual(inserted.BOMLevel, selectedAfterUpdate.BOMLevel);
Assert.AreEqual(inserted.PerAssemblyQty, selectedAfterUpdate.PerAssemblyQty);
Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate);
#endregion
#region delete test
_tested.Delete(connection, new[] { inserted });
var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new BillOfMaterialsModelPrimaryKey()
{
BillOfMaterialsID = inserted.BillOfMaterialsID,
});
CollectionAssert.IsEmpty(selectedAfterDeleteAddresss);
#endregion
connection.Close();
}
public static void BillOfMaterials(BillOfMaterialsModel table)
{
string update = SqliteQuery.Update("BillOfMaterials", table.Headers, table.ID);
SqliteDataAccess.ExecuteQuery(update, table);
}
public static void BillOfMaterials(BillOfMaterialsModel table)
{
string Delete = SqliteQuery.Delete("BillOfMaterials", table.ID);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public static void BillOfMaterials(BillOfMaterialsModel table)
{
string insert = SqliteQuery.Create("BillOfMaterials", table.Headers);
SqliteDataAccess.ExecuteQuery(insert, table);
}