public async Task <Models.OrderDetail> CreateAsync(int OrderId, int ProductId, int Amount)
{
var product = await _context.Products.FindAsync(ProductId);
var orderDetail = new Models.OrderDetail
{
Amount = Amount,
Price = product.Price,
OrderId = OrderId,
ProductId = ProductId,
};
_context.OrderDetails.Add(orderDetail);
await _context.SaveChangesAsync();
return(orderDetail);
}
public ActionResult Insert(List <Orderses> _order)
{
var o = new Models.Orders()
{
Member_ID = MemberID,
OrderDate = DateTime.Now,
//ValueAddTax = System.Convert.ToInt32(T * 0.05),
ShippingFee = 50,
//Amount = System.Convert.ToInt32(T * 1.05 + 50),
ShipMethod_ID = 1,
PaymentMethod_ID = 1,
Status_ID = 2,
};
var od = new Models.OrderDetail()
{
};
return(View());
}
public void addItemsToShoppingCard(BaseController context, int itemId, long price, int amount)
{
List <Models.OrderDetail> shoppingCard = getShoppingCardInSession(context);
bool doesItemToAddExistInShoppingCard = false;
foreach (Models.OrderDetail record in shoppingCard)
{
if (record.idsp == itemId)
{
record.soluong = record.soluong + amount;
doesItemToAddExistInShoppingCard = true;
}
}
if (!doesItemToAddExistInShoppingCard)
{
Models.OrderDetail recordInShoppingCard = new Models.OrderDetail();
recordInShoppingCard.idsp = itemId;
recordInShoppingCard.dongia = price;
recordInShoppingCard.soluong = amount;
shoppingCard.Add(recordInShoppingCard);
}
}
public void UpdateOrderDetail(Models.OrderDetail orderdetail)
{
string sql = @"UPDATE [Sales].[OrderDetails]
SET [UnitPrice] = @unitprice
,[Qty] = @qty
WHERE [OrderID] = @orderid AND [ProductID] = @productid
";
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@orderid", orderdetail.OrderId));
cmd.Parameters.Add(new SqlParameter("@productid", orderdetail.ProductId));
cmd.Parameters.Add(new SqlParameter("@unitprice", orderdetail.UnitPrice));
cmd.Parameters.Add(new SqlParameter("@qty", orderdetail.Qty));
cmd.ExecuteNonQuery();
conn.Close();
}
}
//orderDetail
public static DTO.OrderDetail ToDTO(this Models.OrderDetail model)
{
return(model.ParseObject <Models.OrderDetail, DTO.OrderDetail>());
}
public IActionResult Update([FromBody] Models.OrderDetail orderDetail)
{
_unitOfWork.OrderDetailRepository.Update(orderDetail);
_unitOfWork.Complete();
return(new JsonResult(orderDetail));
}
public int createOrder(Order order)
{
double orderTotal = 0;
var CartItems = GetCartItems();
Product p = null;
Organization org = null;
OrderDetail orderDetail = new Models.OrderDetail();
double cartTotal = 0;
bool ISChargeSalesTax = false;
int totalQuantity = 0;
double ShippingAmount = 0, SalesTaxAmount = 0;
bool ShipToSchool = false;
var salesTax = storeDb.SalesTaxCharges.Where(x => x.Active == true).SingleOrDefault();
if (salesTax != null)
{
if (ShrdMaster.Instance.CheckState(order.SState, salesTax.State))
{
ISChargeSalesTax = true;
SalesTaxAmount = salesTax.TaxAmount;
}
}
foreach (var item in CartItems)
{
p = storeDb.Products.Find(item.productId);
if (item.ShipToSchool)
{
ShipToSchool = true;
}
if (p.InventoryAmount > 0 || p.InventoryAmount == -1)
{
orderDetail = new OrderDetail
{
itemNumber = item.itemNumber,
ProductID = item.productId,
OrderID = order.ID,
Quantity = item.Quantity,
unitPrice = item.Price,
ChargeShipping = item.chargeShipping,
ChargeSalesTax = item.chargeSalesTax
};
if (item.chargeShipping)
{
if (!ShipToSchool)
{
ShippingCharge charge = storeDb.ShippingCharges.Where(x => cartTotal >= x.LowerLimit && cartTotal <= x.UpperLimit).SingleOrDefault();
if (charge != null)
{
if (org != null)
{
if (org.FreeShippingAmount)
{
ShippingAmount = 0;
}
else
{
ShippingAmount += charge.Charge;
}
}
else
{
ShippingAmount += charge.Charge;
}
}
}
}
orderTotal += (item.Quantity * item.Price);
totalQuantity += item.Quantity;
storeDb.OrderDetails.Add(orderDetail);
if (p.Inventory)
{
p.InventoryAmount = p.InventoryAmount - item.Quantity;
}
storeDb.Entry(p).State = EntityState.Modified;
}
else
{
return(-1);
}
}
// order.Total = orderTotal;
//to save the order Summary
cartTotal = GetTotal();
// ISChargeSalesTax = IsSalesTaxChargable();
org = storeDb.Organizations.Find(order.SchoolID);
//if(!ShipToSchool)
//{
// ShippingCharge charge = storeDb.ShippingCharges.Where(x => cartTotal >= x.LowerLimit && cartTotal <= x.UpperLimit).SingleOrDefault();
// if (charge != null)
// {
// if (org != null)
// {
// if (org.FreeShippingAmount)
// {
// ShippingAmount = 0;
// }
// else
// {
// ShippingAmount = charge.Charge;
// }
// }
// else
// {
// ShippingAmount = charge.Charge;
// }
// }
//}
//SalesTaxCharge scharge = storeDb.SalesTaxCharges.Where(x => x.Active == true).SingleOrDefault();
//if (ISChargeSalesTax)
//{
// SalesTaxAmount = scharge.TaxAmount;
//}
OrderSummary ordersum = new OrderSummary();
ordersum.OrderID = order.ID;
ordersum.ShippingAmount = ShippingAmount;
ordersum.TotalAmount = cartTotal;
ordersum.SalesTax = SalesTaxAmount;
ordersum.TotalPayable = cartTotal + ShippingAmount + SalesTaxAmount;
ordersum.Quantity = totalQuantity;
storeDb.OrderSummaries.Add(ordersum);
EmptyCart();
storeDb.SaveChanges();
//HttpContext.Current.Session["OrderSummary"] = ordersum;
// EmptyCart();
return(order.ID);
}
/// <summary>
/// 更新訂單明細
/// </summary>
public void UpdateOrderDetail(Models.OrderDetail orderDetail)
{
//todo
}
