private void btnManageFunds_Click(object sender, EventArgs e)
{
OrderDataAccess ordersDA = new OrderDataAccess();
OrderDetailDataAccess detailsDA = new OrderDetailDataAccess();
mlvOrders.Items.Clear();
decimal loss = 0, profit = 0;
foreach (var order in ordersDA.GetList())
{
ListViewItem item = new ListViewItem(order.OrderID.ToString());
item.SubItems.Add(order.CustomerID.ToString());
item.SubItems.Add(order.OrderDate.ToLongTimeString());
item.SubItems.Add(order.OrderState.ToString());
if (detailsDA.GetList().Where(d => d.OrderID == order.OrderID).ToList().Count > 0)
{
foreach (var orderDetails in detailsDA.GetList().Where(d => d.OrderID == order.OrderID).ToList())
{
item.SubItems.Add(orderDetails.Loss + "$");
loss += orderDetails.Loss;
item.SubItems.Add(orderDetails.Profit + "$");
profit += orderDetails.Profit;
}
}
else
{
item.SubItems.Add("---- $");
item.SubItems.Add("---- $");
}
mlvOrders.Items.Add(item);
}
lblLoss.Text = loss.ToString() + "$";
lblProfit.Text = profit.ToString() + "$";
if ((profit - loss) > 0)
{
lblBalance.ForeColor = Color.SeaGreen;
lblBalance.Text = (profit - loss).ToString() + "$";
}
else
{
lblBalance.ForeColor = Color.Red;
lblBalance.Text = (loss - profit).ToString() + "$";
}
pnlManageFunds.Visible = true;
pnlManageFunds.BringToFront();
}
public int DeleteExistingOrder(int orderId)
{
int result = 0;
try
{
var orderDetail = dataDetailAccess.GetOrderDetailListByOrderId(orderId);
if (orderDetail.Count > 0)
{
dataDetailAccess = new OrderDetailDataAccess();
dataDetailAccess.DeleteOrderDetailByOrderId(orderId);
}
result = orderDataAccess.DeleteExistingOrder(orderId);
}
catch (Exception ex)
{
//
}
return(result);
}
public OrderManager()
{
orderDataAccess = new OrderDataAccess();
customerDataAccess = new CustomerDataAccess();
dataDetailAccess = new OrderDetailDataAccess();
}
public ActionResult Payment(string shipName, string mobile, string address, string email)
{
//Lấy data, kiểu data là Order
var order = new Order();
order.ShipName = shipName;
order.ShipMobile = mobile;
order.ShipAddress = address;
order.ShipEmail = email;
//Insert data vừa lấy vào bảng Order
var id = new OrderDataAccess().Insert(order);
////
var OrderDetail = new OrderDetailDataAccess();
//Lấy data từ session hiện tại
var cart = Session[CartSession];
var list = new List <CartItem>();
////
if (cart != null)
{
list = (List <CartItem>)cart;
}
decimal total = 0;
decimal totalAll = 0;
var listProduct = new List <string>();
string product = "";
//Them data vào bảng OrderDetail
foreach (var item in list)
{
var detail = new OrderDetail();
detail.ProductID = item.Product.ID;
detail.OrderID = id;
detail.Quantity = item.Quantity;
detail.Price = item.Product.Price;
OrderDetail.Insert(detail);
total = item.Product.Price.GetValueOrDefault(0) * item.Quantity;
product += "Sản phẩm:" + item.Product.Name + '\n' + "Số lượng:" + item.Quantity + Environment.NewLine + "Giá:" + item.Product.Price + Environment.NewLine + "Thành tiền:" + item.Product.Price * item.Quantity + Environment.NewLine;
listProduct.Add(product);
product = "";
totalAll += total;
}
//Tạo đơn hàng email
string content = System.IO.File.ReadAllText(Server.MapPath("~/Assets/Client/template/neworder.html"));
content = content.Replace("{{CustomerName}}", shipName);
content = content.Replace("{{Phone}}", mobile);
content = content.Replace("{{Email}}", email);
content = content.Replace("{{Address}}", address);
string listProductEmail = ListProductEmail(listProduct);
content = content.Replace("{{Product}}", listProductEmail);
content = content.Replace("{{Total}}", totalAll.ToString());
//content = content.Replace("{{Product}}", listProduct[0]);
//gửi đến Admin
var toEmailAdmin = ConfigurationManager.AppSettings["ToEmailAddress"].ToString();
new MailHelper().SendMail(toEmailAdmin, "Đơn hàng mới từ BookShop", content);
//gửi đến người mua
var toEmailCustomer = email;
new MailHelper().SendMail(toEmailCustomer, "Đơn hàng mới từ BookShop", content);
///
return(Redirect("/hoan-thanh"));
}
