// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
//实例化上下文类
TeaContext db = new TeaContext();
//将上下文类 装载到服务中
services.AddSingleton <TeaContext>(db);
/*
* 配置跨域处理
*/
// 获取appsettings.json配置信息
//配置跨域处理
services.AddCors(options =>
{
options.AddPolicy("cors", builder =>
{
builder.WithOrigins("http://localhost:6321") //允许指定域名访问
.AllowAnyMethod()
.AllowAnyHeader()
.AllowCredentials();//指定处理cookie
});
});
services.AddControllers();
}
public void CreateNewBasketShouldCreateNewBasket()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("CreateNewBasketShouldCreateNewBasket").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
OrderModel order = new OrderModel()
{
locationId = 1,
customerId = 1,
totalPrice = Convert.ToDecimal(0.00),
complete = false
};
//Act
repo.CreateNewBasket(order);
//Assert
using var assertContext = new TeaContext(options);
Assert.NotNull(assertContext.Orders.First(h => h.Locationid == 1 && h.Customerid == 1));
}
public void DecreaseStockShouldDecreaseStock()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("DecreaseStockShouldDecreaseStock").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
Seed(testContext);
InventoryModel invenotry = new InventoryModel()
{
locationId = 1,
productId = 1,
stock = 1
};
//Act
repo.DecreaseStock(invenotry);
//Assert
using var assertContext = new TeaContext(options);
Assert.True(assertContext.Inventory.First(h => h.Locationid == 1 && h.Productid == 1).Stock == 1);
}
private void Seed(TeaContext testcontext)
{
testcontext.Products.AddRange(testProducts);
testcontext.Customers.AddRange(testCustomers);
testcontext.Locations.AddRange(testLocations);
testcontext.Locations.AddRange(testLocations2);
testcontext.Orders.AddRange(testOrders);
testcontext.Orders.AddRange(testOrderHistory1);
testcontext.Orders.AddRange(testOrderHistory1);
testcontext.Orderitems.AddRange(testOrderItems);
testcontext.Inventory.AddRange(testInventory);
testcontext.SaveChanges();
}
public void GetCustomerOrdersFromMostToLeastShouldGetCustomerOrders()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("GetCustomerOrdersFromMostToLeastShouldGetCustomerOrders").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
Seed(testContext);
//Act
var result = repo.GetCustomerOrderMostToLeast(1);
//Assert
using var assertContext = new TeaContext(options);
Assert.True(result.Count == 1);
}
public void GetLocationOrderHistoryMostToLeastShouldGetLocationOrder()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("GetLocationOrderHistoryMostToLeastShouldGetLocationOrder").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
Seed(testContext);
//Act
var result = repo.GetOrderHistoryLocationByMostExpensive(1);
//Assert
using var assertContext = new TeaContext(options);
Assert.True(result.Count == 1);
}
public void NewOrderItemShouldCreateNewOrderItem()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("NewOrderItemShouldCreateNewOrderItem").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
//Act
repo.AddToBasket(testOrderItemModel);
//Assert
using var assertContext = new TeaContext(options);
Assert.NotNull(assertContext.Orderitems.First(h => h.Orderid == testOrderItemModel.orderId));
}
public void GetOrderIdShouldGetOrderId()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("GetOrderIdShouldGetOrderId").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
Seed(testContext);
//Act
var result = repo.GetCurrentOrder(testCustomerModel.id, 1);
//Assert
using var assertContext = new TeaContext(options);
Assert.Equal(result.customerId, testCustomerModel.id);
}
public void CreateNewProductShouldCreateNewProduct()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("CreateNewProductShouldCreateNewProduct").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
//Act
repo.CreateNewProduct(productModel);
//Assert
using var assertContext = new TeaContext(options);
Assert.NotNull(assertContext.Products.First(p => p.Productname == productModel.name));
}
public void GetProductShouldGetProduct()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("GetProductShouldGetProduct").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
Seed(testContext);
//Act
var result = repo.GetProduct(1);
//Assert
using var assertContext = new TeaContext(options);
Assert.Equal(result.id, testProducts.Productid);
}
public void GetItemsInBasketShouldGetItemsInBasket()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("GetItemsInBasketShouldGetItemsInBasket").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
Seed(testContext);
//Act
var result = repo.GetCurrentOrder(1, 1);
//Assert
using var assertContext = new TeaContext(options);
Assert.Equal(result.orderItems.Count, 1);
}
public void GetAllProductsShouldGetAllProducts()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("GetAllProductsShouldGetAllProducts").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
Seed(testContext);
//Act
var result = repo.GetAllProducts();
//Assert
using var assertContext = new TeaContext(options);
Assert.True(result.Count == 1);
}
public void GetCustomerShouldGetCustomer()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("GetCustomerShouldGetCustomer").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
Seed(testContext);
//Act
var result = repo.GetCustomerInfo("*****@*****.**");
//Assert
using var assertContext = new TeaContext(options);
Assert.Equal(result.email, "*****@*****.**");
}
public void IncreaseTotalPriceShouldIncreaseTotalPrice()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("IncreaseTotalPriceShouldIncreaseTotalPrice").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
Seed(testContext);
//Act
repo.IncreaseTotalPrice(1, Convert.ToDecimal(1.00));
//Assert
using var assertContext = new TeaContext(options);
Assert.True(assertContext.Orders.First(h => h.Orderid == 1).Totalprice == Convert.ToDecimal(5.99));
}
public void NewCustomerShouldAddCustomer()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("NewCustomerShouldAddCustomer").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
//Act
repo.NewCustomer(testCustomerModel);
//Assert
using var assertContext = new TeaContext(options);
Assert.NotNull(assertContext.Customers.Single(h => h.Customeremail == testCustomerModel.email));
}
public void AddItemToInventoryShouldAddItemToInventory()
{
var options = new DbContextOptionsBuilder <TeaContext>().UseInMemoryDatabase("AddItemToInventoryShouldAddItemToInventory").Options;
using var testContext = new TeaContext(options);
repo = new DBRepo()
{
context = testContext,
mapper = mapper
};
InventoryModel inventory = new InventoryModel()
{
locationId = 1,
productId = 1,
stock = 1
};
//Act
repo.AddItemToInventory(inventory);
//Assert
using var assertContext = new TeaContext(options);
Assert.NotNull(assertContext.Inventory.First(i => i.Locationid == 1));
}
public GoodsController(TeaContext db)
{
this.db = db;
}
public HomeController(TeaContext context) => this.context = context;
public static void Initialize(TeaContext context)
{
if (!context.Products.Any() || !context.Employees.Any())
{
context.Employees.AddRange(
new Employee {
Login = "******",
Password = "******"
}
);
context.Products.AddRange(
new Product {
Title = "Ассам FBOP",
Description = "fbop.txt",
Weight = 0.05,
Dimensions = "12 x 5 x 3",
Quantity = 5,
Price = 75,
Image = "fbop.jpg"
},
new Product {
Title = "Те Гуань Инь в.к.",
Description = "teguan.txt",
Weight = 0.05,
Dimensions = "12 x 3 x 2",
Quantity = 3,
Price = 350,
Image = "teguan.jpg"
},
new Product {
Title = "Хун Му Дань",
Description = "hunmudan.txt",
Weight = 0.05,
Dimensions = "12 x 4 x 5",
Quantity = 0,
Price = 200,
Image = "hunmudan.jpg"
},
new Product {
Title = "Кения FOP",
Description = "fop.txt",
Weight = 0.05,
Dimensions = "10 x 7 x 3",
Quantity = 9,
Price = 150,
Image = "fop.jpg"
},
new Product {
Title = "Лун Цзин в.к.",
Description = "lunzin.txt",
Weight = 0.05,
Dimensions = "12 x 5 x 3",
Quantity = 42,
Price = 200,
Image = "lunzin.jpg"
},
new Product {
Title = "Бай Хуа Сянь Цзы",
Description = "buyhia.txt",
Weight = 0.05,
Dimensions = "12 x 5 x 3",
Quantity = 22,
Price = 467,
Image = "buyhia.jpg"
},
new Product {
Title = "Дянь Хун Мао Фэн",
Description = "dyanhun.txt",
Weight = 0.05,
Dimensions = "12 x 5 x 3",
Quantity = 15,
Price = 210,
Image = "dyanhun.jpg"
},
new Product {
Title = "Шу Сян Люй",
Description = "shusyan.txt",
Weight = 0.05,
Dimensions = "12 x 5 x 3",
Quantity = 11,
Price = 100,
Image = "shusyan.jpg"
},
new Product {
Title = "Дарджилинг FTGFOP1",
Description = "dardzhil.txt",
Weight = 0.05,
Dimensions = "12 x 5 x 3",
Quantity = 43,
Price = 7530,
Image = "dardzhil.jpg"
},
new Product {
Title = "Цзинь Ло",
Description = "zinlo.txt",
Weight = 0.05,
Dimensions = "12 x 5 x 3",
Quantity = 228,
Price = 10,
Image = "zinlo.jpg"
}
);
context.SaveChanges();
}
}
public UsersController(TeaContext db)
{
this.db = db;
}
public DataStore(TeaContext context, IPasswordHasher passwordHasher, ILogger <DataStore> log)
{
_context = context;
_passwordHasher = passwordHasher;
_log = log;
}
public AccountController(TeaContext context) => this.context = context;
public DataStore(TeaContext context)
{
_context = context;
}
public ClientController(TeaContext db)
{
this.db = db;
}
