public void Add(ecom_OrderDetails orderDetails)
{
context.ecom_OrderDetails.Add(orderDetails);
}
public void DeleteOrderDetails(ecom_OrderDetails orderDetails)
{
context.ecom_OrderDetails.Remove(orderDetails);
}
public void ProsessOrder(ShippingDetailsViewModel shippingDetails, Cart cart)
{
var customer = context.ecom_Customer.FirstOrDefault(x => x.Phone == shippingDetails.Phone);
if (customer == null)
{
customer = new ecom_Customer()
{
Name = shippingDetails.Name,
Email = shippingDetails.Email,
Address = shippingDetails.Address,
Phone = shippingDetails.Phone,
//NoiDung = shippingDetails.NoiDung
};
context.ecom_Customer.Add(customer);
}
else
{
customer.Name = shippingDetails.Name;
customer.Address = shippingDetails.Address;
customer.Email = shippingDetails.Email;
}
context.SaveChanges();
ecom_Orders order = new ecom_Orders()
{
CreatedDate = DateTime.Now,
Status = (int)Define.OrderStatus.Waiting,
CustomerId = customer.Id,
AddressOfRecipient = customer.Address,
NameOfRecipient = customer.Name,
PhoneOfRecipient = customer.Phone,
EmailOfRecipient = shippingDetails.Email,
OrderNote = shippingDetails.Note,
};
context.ecom_Orders.Add(order);
context.SaveChanges();
foreach (var item in cart.LineCollection)
{
ecom_OrderDetails orderDetaisl = new ecom_OrderDetails()
{
OrderID = order.Id,
ProductID = item.Product.Id,
Quantity = item.Quantity,
PriceOfUnit = item.Product.Price,
CreatedDate = DateTime.Now,
CreatedByTy = customer.Name,
Status = (int)Define.OrderStatus.Waiting
};
context.ecom_OrderDetails.Add(orderDetaisl);
}
context.SaveChanges();
foreach (var item in cart.LineCollection)
{
var model = context.ecom_Products.Where(x => x.Id == item.Product.Id).FirstOrDefault();
if (model.TotalBuy == null)
{
model.TotalBuy = 0;
}
model.Quantity -= item.Quantity;
model.TotalBuy += item.Quantity;
}
context.SaveChanges();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<ol>");
foreach (var line in cart.LineCollection)
{
stringBuilder.Append("<li>");
stringBuilder.Append(line.Product.Name);
stringBuilder.Append("<span>" + line.Quantity + "x" + line.Product.Price);
stringBuilder.Append("= " + line.Quantity * line.Product.Price);
stringBuilder.Append("</span>");
stringBuilder.Append("</ol>");
stringBuilder.Append("<h3>Tổng Tiền : <strong>" + cart.ComputerTotal() + "</strong></h3>");
}
MailHelper emailHelper = new MailHelper();
emailHelper.Send(
"Đơn Hàng" + order.Id,
shippingDetails.Email,
stringBuilder.ToString(),
null,
null);
}
