public void It_Should_Be_Possible_To_Update_A_CheckpointOrder_To_The_Database()
{
CheckpointOrder origCheckpointOrder = new CheckpointOrder();
origCheckpointOrder.CheckpointID = 1;
origCheckpointOrder.StartingNumber = 1;
CheckpointOrder updatedCheckpointOrder = origCheckpointOrder;
Given("we have a checkpointOrder", () =>
{
checkpointOrderModel.AddCheckpointOrderDB((int)origCheckpointOrder.CheckpointID, (int)origCheckpointOrder.StartingNumber);
});
When("we update the checkpointOrder", () =>
{
updatedCheckpointOrder.CheckpointID = 1;
updatedCheckpointOrder.StartingNumber = 2;
checkpointOrderModel.UpdateCheckpointOrderDB((int)updatedCheckpointOrder.CheckpointID, (int)updatedCheckpointOrder.StartingNumber);
});
Then("the values should be different", () =>
{
updatedCheckpointOrder.StartingNumber.ShouldNotBe(origCheckpointOrder.StartingNumber);
});
}
private static CheckpointOrder CreateCheckpointOrder(int checkpointId, int startingNumber, Entities entities)
{
var checkpointOrder = new CheckpointOrder();
checkpointOrder.CheckpointID = checkpointId;
checkpointOrder.StartingNumber = startingNumber;
if ((ExistsAnyCheckpointOrdersInDb(entities)) && (CheckpointExistsInDb(checkpointId, entities)))
checkpointOrder.OrderNumber = GetHighestExistingOrderNumberForCheckpoint(checkpointId, entities) + 1;
else
checkpointOrder.OrderNumber = 1;
checkpointOrder.IsDeleted = false;
return checkpointOrder;
}
public static CheckpointOrderModel Create(int checkpointId, int startingNumber, int orderNumber)
{
CheckpointOrderModel checkpointOrderModel = new CheckpointOrderModel();
using (var ctx = new Entities())
{
CheckpointOrder checkpointOrder = new CheckpointOrder();
checkpointOrder.CheckpointID = checkpointId;
checkpointOrder.StartingNumber = startingNumber;
checkpointOrder.StartingNumber = (ctx.CheckpointOrders.OrderByDescending(chkpnt => chkpnt.CheckpointID).First().CheckpointID) + 1;
ctx.CheckpointOrders.AddObject(checkpointOrder);
ctx.SaveChanges();
checkpointOrder.ID = (int)ctx.CheckpointOrders.OrderByDescending(chkpnt => chkpnt.CheckpointID).First().CheckpointID;
}
return checkpointOrderModel;
}
/// <summary>
/// Create a new CheckpointOrder object.
/// </summary>
/// <param name="id">Initial value of the ID property.</param>
public static CheckpointOrder CreateCheckpointOrder(global::System.Int32 id)
{
CheckpointOrder checkpointOrder = new CheckpointOrder();
checkpointOrder.ID = id;
return checkpointOrder;
}
/// <summary>
/// Deprecated Method for adding a new object to the CheckpointOrders EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToCheckpointOrders(CheckpointOrder checkpointOrder)
{
base.AddObject("CheckpointOrders", checkpointOrder);
}
public ActionResult Create(CheckpointOrder CheckpointOrderToInsert)
{
return View("Index");
}
public void It_Should_Be_Possible_To_Update_A_CheckpointOrder_To_The_Database()
{
CheckpointOrder origCheckpointOrder = new CheckpointOrder();
origCheckpointOrder.CheckpointID = 1;
origCheckpointOrder.StartingNumber = 1;
var id = 0;
var startnumber = 0;
using (var ctxTest = new Entities())
{
if (ctxTest.CheckpointOrders.Any(chkpnt => (chkpnt.StartingNumber == origCheckpointOrder.StartingNumber && chkpnt.CheckpointID == origCheckpointOrder.CheckpointID)))
{
var checkpointOrderToDelete = ctxTest.CheckpointOrders.Where(checkpointOrder => (checkpointOrder.StartingNumber == origCheckpointOrder.StartingNumber && checkpointOrder.CheckpointID == origCheckpointOrder.CheckpointID)).Single();
ctxTest.CheckpointOrders.DeleteObject(checkpointOrderToDelete);
ctxTest.SaveChanges();
}
}
CheckpointOrder updatedCheckpointOrder = origCheckpointOrder;
Given("we have a checkpointOrder", () =>
{
checkpointOrderModel.AddCheckpointOrderDB((int)origCheckpointOrder.CheckpointID, (int)origCheckpointOrder.StartingNumber);
var ctxTest = new Entities();
id = ctxTest.CheckpointOrders.Where(checkpointOrder => (checkpointOrder.StartingNumber == origCheckpointOrder.StartingNumber && checkpointOrder.CheckpointID == origCheckpointOrder.CheckpointID)).Single().ID;
});
When("we update the checkpointOrder", () =>
{
updatedCheckpointOrder.CheckpointID = 1;
updatedCheckpointOrder.StartingNumber = 2;
checkpointOrderModel.UpdateCheckpointOrderDB((int)id, (int)updatedCheckpointOrder.StartingNumber);
var ctxTest = new Entities();
startnumber = (int)(ctxTest.CheckpointOrders.Where(checkpointOrder => (checkpointOrder.StartingNumber == origCheckpointOrder.StartingNumber && checkpointOrder.ID == id)).Single().StartingNumber);
});
Then("the values should be different", () =>
{
updatedCheckpointOrder.StartingNumber.ShouldBe(startnumber);
});
}
/// <summary>
/// Create a new CheckpointOrder object.
/// </summary>
/// <param name="id">Initial value of the ID property.</param>
/// <param name="isDeleted">Initial value of the IsDeleted property.</param>
/// <param name="isMerged">Initial value of the IsMerged property.</param>
public static CheckpointOrder CreateCheckpointOrder(global::System.Int32 id, global::System.Boolean isDeleted, global::System.Boolean isMerged)
{
CheckpointOrder checkpointOrder = new CheckpointOrder();
checkpointOrder.ID = id;
checkpointOrder.IsDeleted = isDeleted;
checkpointOrder.IsMerged = isMerged;
return checkpointOrder;
}
private static void SaveCheckpointOrder(CheckpointOrder checkpointOrder, Entities entities)
{
entities.CheckpointOrders.AddObject(checkpointOrder);
entities.SaveChanges();
}