public ActionResult Index(CustomerOrderItemMaster c)
{
obj.CreateOrder(c);
ViewBag.CustomerId = new SelectList(obj.GetCustomers(), "CustomerId", "CustomerName");
ViewBag.ItemId = new SelectList(obj.GetItems(), "ItemId", "ItemName");
return(View(c));
}
public void TestSubmitEmptyOrder()
{
//Arrange
var options = new DbContextOptionsBuilder <BaB_DbContext>()
.UseInMemoryDatabase(databaseName: "Test8Db")
.Options;
//Act
Customer testCustomer;
#region Test database seeding
using (var context = new BaB_DbContext(options))
{
#region Customers
//Add customers to database for sampling from
Customer testCustomer1 = new Customer
{
CustFirstName = "Annie",
CustLastName = "Admin",
CustUsername = "******",
CustPassword = "******"
};
Customer testCustomer2 = new Customer
{
CustFirstName = "Becky",
CustLastName = "Boss",
CustUsername = "******",
CustPassword = "******"
};
context.Add(testCustomer1);
context.Add(testCustomer2);
#endregion
#region LocationCountry
//Add Location Country to the test database
LocationCountry testLocationCountry = new LocationCountry
{
Country = "USA"
};
context.Add(testLocationCountry);
#endregion
#region LocationState
//Add Location State to the test database
LocationState testLocationState = new LocationState
{
State = "Illinois"
};
context.Add(testLocationState);
#endregion
#region Locations
//Add locations to the test database
Location testLocation1 = new Location
{
LocationAddress = "1 Street",
LocationState = testLocationState,
LocationCountry = testLocationCountry
};
Location testLocation2 = new Location
{
LocationAddress = "2 Street",
LocationState = testLocationState,
LocationCountry = testLocationCountry
};
context.Add(testLocation1);
context.Add(testLocation2);
#endregion
testCustomer = testCustomer1;
context.SaveChanges();
}
#endregion
PlaceOrder testPlaceOrder = new PlaceOrder();
using (var context = new BaB_DbContext(options))
{
testPlaceOrder.CreateOrder(new UnitTest8Inputs(), context, testCustomer);
}
//Assert
using (var context = new BaB_DbContext(options))
{
Assert.Equal(0, context.OrderLineItemsDB.Count());
}
}
public void TestRemoveItemFromOrder()
{
//Arrange
var options = new DbContextOptionsBuilder <BaB_DbContext>()
.UseInMemoryDatabase(databaseName: "Test10Db")
.Options;
//Act
Customer testCustomer;
#region Test database seeding
using (var context = new BaB_DbContext(options))
{
#region Customers
//Add customers to database for sampling from
Customer testCustomer1 = new Customer
{
CustFirstName = "Annie",
CustLastName = "Admin",
CustUsername = "******",
CustPassword = "******"
};
Customer testCustomer2 = new Customer
{
CustFirstName = "Becky",
CustLastName = "Boss",
CustUsername = "******",
CustPassword = "******"
};
context.Add(testCustomer1);
context.Add(testCustomer2);
#endregion
#region LocationCountry
//Add Location Country to the test database
LocationCountry testLocationCountry = new LocationCountry
{
Country = "USA"
};
context.Add(testLocationCountry);
#endregion
#region LocationState
//Add Location State to the test database
LocationState testLocationState = new LocationState
{
State = "Illinois"
};
context.Add(testLocationState);
#endregion
#region Products
//Add a product to the database for building with
Product testProduct1 = new Product
{
ProductName = "Test product 1",
ProductPrice = 1
};
Product testProduct2 = new Product
{
ProductName = "Test product 2",
ProductPrice = 1
};
Product testProduct3 = new Product
{
ProductName = "Test product 3",
ProductPrice = 1
};
context.Add(testProduct1);
context.Add(testProduct2);
context.Add(testProduct3);
#endregion
#region Locations
//Add locations to the test database
Location testLocation1 = new Location
{
LocationAddress = "1 Street",
LocationState = testLocationState,
LocationCountry = testLocationCountry
};
Location testLocation2 = new Location
{
LocationAddress = "2 Street",
LocationState = testLocationState,
LocationCountry = testLocationCountry
};
context.Add(testLocation1);
context.Add(testLocation2);
#endregion
#region Inventory
//Add inventory to locations
Inventory testInventory1 = new Inventory
{
InventoryLocation = testLocation1,
InventoryProduct = testProduct1,
QuantityAvailable = 15
};
Inventory testInventory2 = new Inventory
{
InventoryLocation = testLocation1,
InventoryProduct = testProduct2,
QuantityAvailable = 15
};
Inventory testInventory3 = new Inventory
{
InventoryLocation = testLocation1,
InventoryProduct = testProduct3,
QuantityAvailable = 15
};
Inventory testInventory4 = new Inventory
{
InventoryLocation = testLocation2,
InventoryProduct = testProduct1,
QuantityAvailable = 15
};
Inventory testInventory5 = new Inventory
{
InventoryLocation = testLocation2,
InventoryProduct = testProduct2,
QuantityAvailable = 15
};
Inventory testInventory6 = new Inventory
{
InventoryLocation = testLocation2,
InventoryProduct = testProduct3,
QuantityAvailable = 15
};
context.Add(testInventory1);
context.Add(testInventory2);
context.Add(testInventory3);
context.Add(testInventory4);
context.Add(testInventory5);
context.Add(testInventory6);
#endregion
testCustomer = testCustomer1;
context.SaveChanges();
}
#endregion
PlaceOrder testPlaceOrder = new PlaceOrder();
using (var context = new BaB_DbContext(options))
{
testPlaceOrder.CreateOrder(new UnitTest11Inputs(), context, testCustomer);
}
//Assert
using (var context = new BaB_DbContext(options))
{
Assert.Equal(0, context.OrderLineItemsDB.Count());
Assert.Equal(0, context.OrdersDB.Count());
}
}