public void FindByCustomerTest()
{
ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository();
var shoppingcar = repository.FindByCustomer(1);
Assert.IsTrue(shoppingcar.Count() > 0);
}
public void FindByIdTest()
{
ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository();
var shoppingcar = repository.FindById(1, 3);
Assert.IsTrue(shoppingcar == null);
}
public void GetAllTest()
{
ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository();
var shoppingcar = repository.GetAll();
Assert.IsTrue(shoppingcar.Count() > 0);
}
public void GetProductTotalTest()
{
ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository();
var shoppingcar = repository.GetProductTotal(1);
Assert.IsTrue(shoppingcar > 0);
}
public bool AddProducttoShoppingcar(ShoppingcartDetails model)
{
var shoppingcarRepository = new ShoppingcartDetailsRepository();
var productsRepository = new ProductsRepository();
var stock = productsRepository.CheckStock(model.ProductID, model.Quantity);
if (stock)
{
var product = shoppingcarRepository.FindById(model.CustomerID, model.ProductID);
if (product == null)
{
shoppingcarRepository.Create(model);
}
else
{
shoppingcarRepository.Update(model);
}
return(true);
}
else
{
return(false);
}
}
public void DeleteOneForUserTest()
{
ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository();
ShoppingcartDetails model = new ShoppingcartDetails
{
CustomerID = 1,
ProductID = 1
};
var shoppingcar = repository.GetAll();
Assert.IsTrue(shoppingcar.Count() > 0);
}
public void UpdateminusTest()
{
ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository();
ShoppingcartDetails model = new ShoppingcartDetails
{
CustomerID = 1,
ProductID = 1,
Quantity = 1
};
repository.Updateminus(model);
var shoppingcar = repository.GetAll();
Assert.IsTrue(shoppingcar.Count() > 0);
}
public string ConfirmOrders(List <ShoppingcartDetails> shoppingcar, Order order)//新增訂單
{
var shoppingcarRepository = new ShoppingcartDetailsRepository();
var productsRepository = new ProductsRepository();
var orderRepository = new OrderRepository();
var orderDetailsRepository = new OrderDetailsRepository();
SqlConnection connection = new SqlConnection(sqlstr);
connection.Open();
var transactition = connection.BeginTransaction();
try
{
foreach (var item in shoppingcar)//每一件是否都有庫存
{
var stock = productsRepository.CheckStock(item.ProductID, item.Quantity);
if (!stock)
{
return($"{item.ProductID}");
}
}
orderRepository.Create(order);//新增訂單
var orderid = orderRepository.FindLastOrderByCustomerID(order.CustomerID);
foreach (var item in shoppingcar)//新增訂單明細
{
var orderDetails = new OrderDetails()
{
OrderID = orderid,
ProductID = item.ProductID,
Quantity = item.Quantity
};
orderDetailsRepository.Create(orderDetails);
}
//扣庫存
foreach (var item in shoppingcar)
{
var product = new Products()
{
ProductID = item.ProductID
};
productsRepository.UpdateStockPminus(product, item.Quantity);
}
//刪購物車內容
//先判斷購物車商品數量與訂單商品數量
shoppingcarRepository.DeleteAllForUser(order.CustomerID);
transactition.Commit();
}
catch (SqlException e)
{
transactition.Rollback();
return(e.Message);
}
connection.Close();
return("OrderSuccess");
}
public IEnumerable <ShoppingcartDetails> FindByCustomer(int CustomerID)
{
var shoppingcarRepository = new ShoppingcartDetailsRepository();
return(shoppingcarRepository.FindByCustomer(CustomerID));
}
public decimal GetProductTotal(int Cid)
{
var shoppingcarRepository = new ShoppingcartDetailsRepository();
return(shoppingcarRepository.GetProductTotal(Cid));
}
public IEnumerable <ShoppingcartDetails> GetAll()
{
var shoppingcarRepository = new ShoppingcartDetailsRepository();
return(shoppingcarRepository.GetAll());
}
public ShoppingcartDetails FindById(int CustomerID, int ProductID)
{
var shoppingcarRepository = new ShoppingcartDetailsRepository();
return(shoppingcarRepository.FindById(CustomerID, ProductID));
}
public void DeleteOneForUser(ShoppingcartDetails model)
{
var shoppingcarRepository = new ShoppingcartDetailsRepository();
shoppingcarRepository.DeleteOneForUser(model);
}
public void DeleteAllForUser(int CustomerID)
{
var shoppingcarRepository = new ShoppingcartDetailsRepository();
shoppingcarRepository.DeleteAllForUser(CustomerID);
}
public void Update(ShoppingcartDetails model)
{
var shoppingcarRepository = new ShoppingcartDetailsRepository();
shoppingcarRepository.Update(model);
}
