public ActionResult GetInforDetailOrder(string idDH)
{
var order = new DonHangDao().GetDonHang(idDH);
var listCT_DonHang = new DonHangDao().getListCTDH(idDH);
var customer = new CustomerModel();
decimal phiShip = 0;
decimal tong = 0;
foreach (var item in listCT_DonHang)
{
tong += item.SOLUONG * item.THANHTIEN;
}
if (tong < 300000)
{
phiShip = 30000;
}
if (order != null)
{
var cusdetail = new CustomerDao().ViewDetail(order.MAKHACHHANG);
var pttt = new OrdersDao().GetPhuongThucThanhToan(order.MAPHUONGTHUCTHANHTOAN);
customer.MAKH = cusdetail.MAKHACHHANG;
customer.TENKH = cusdetail.TENKHACHHANG;
customer.DIACHI = cusdetail.DIACHI;
customer.DIENTHOAI = cusdetail.DIENTHOAI;
customer.EMAIL = cusdetail.EMAIL;
customer.NgayTaoDon = order.NGAYLAP;
customer.PhuongThucThanhToan = pttt.TENPHUONGTHUCTHANHTOAN;
customer.Ship = phiShip;
}
return(Json(customer, JsonRequestBehavior.AllowGet));
}
public List <OrdersModel> GetOrders()
{
OrdersDao ordersDao = new OrdersDao();
List <OrdersModel> orders = ordersDao.GetOrders();
return(orders);
}
/// <summary>
/// 取得 Orders by 條件
/// </summary>
/// <returns></returns>
public IList <Order> GetOrders(OrderQueryArg arg)
{
CustomerService customerService = new CustomerService();
OrdersDao orderDao = new OrdersDao();
// 取得所有訂單後進行篩選 (注意: 此處應將查詢條件串入SQL中為較好之寫法)
IEnumerable <Order> currentOrders = orderDao.GetOrdersByArg(arg);
return(currentOrders.OrderBy(m => m.OrderID).ToList());
}
/// <summary>
/// 取得 Orders by 條件
/// </summary>
/// <returns></returns>
public IList <Order> GetOrders(OrderQueryArg arg)
{
CustomerService customerService = new CustomerService();
OrdersDao orderDao = new OrdersDao();
// 取得所有訂單後進行篩選 (注意: 此處應將查詢條件串入SQL中為較好之寫法)
IEnumerable <Order> currentOrders = orderDao.GetAllOrders();
// 訂單編號
if (arg.OrderID.HasValue)
{
currentOrders = currentOrders.Where(m => m.OrderID == arg.OrderID.Value);
}
// 客戶名稱 (like 查詢)
if (!string.IsNullOrWhiteSpace(arg.CompanyName))
{
currentOrders =
currentOrders.Where(
m => customerService.GetCompanyName(m.CustomerID).Contains(arg.CompanyName)
);
}
// 員工編號
if (arg.EmployeeID.HasValue)
{
currentOrders = currentOrders.Where(m => m.EmployeeID == arg.EmployeeID.Value);
}
// 出貨公司
if (arg.ShipperID.HasValue)
{
currentOrders = currentOrders.Where(m => m.ShipperID == arg.ShipperID.Value);
}
// 訂購日期
if (arg.OrderDate.HasValue)
{
currentOrders = currentOrders.Where(m => m.OrderDate == arg.OrderDate.Value);
}
// 需要日期
if (arg.RequiredDate.HasValue)
{
currentOrders = currentOrders.Where(m => m.RequiredDate == arg.RequiredDate.Value);
}
// 出貨日期
if (arg.ShipedDate.HasValue)
{
currentOrders = currentOrders.Where(m => m.ShippedDate == arg.ShipedDate.Value);
}
return(currentOrders.OrderBy(m => m.OrderID).ToList());
}
public ActionResult GetDataGridOrderSales(DateTime month)
{
var listDDH = new OrdersDao().GetListOrderForMonth(month);
var model = new List <OrdersModel>();
foreach (var item in listDDH)
{
if (item.TRANGTHAI == 1)
{
var infoCustomer = new CustomerDao().ViewDetail(item.MAKHACHHANG);
var ctDDH = new OrdersDao().GetOrderDetail(item.MAHOADON);
var NhanVien = new AdminDao().ViewDetail(item.NGUOICAPNHAT);
var TenNhanVien = "";
if (NhanVien != null)
{
TenNhanVien = NhanVien.TENNHANVIEN + " (" + NhanVien.MANHANVIEN + ")";
}
var dateUpdate = item.NGAYCAPNHAT;
decimal TongTien = 0;
//decimal ship = 0;
decimal totalIn = 0;
foreach (var i in ctDDH)
{
var product = new SanPhamDao().getProduct(i.MASANPHAM);
TongTien = TongTien + i.THANHTIEN * i.SOLUONG;
totalIn += i.SOLUONG * product.DONGIA;
}
//if (TongTien <= 300000)
//{
// ship = 30000;
// TongTien += ship;
//}
if (dateUpdate == null)
{
dateUpdate = item.NGAYLAP;
}
model.Add(new OrdersModel
{
MaDDH = item.MAHOADON,
TenKH = infoCustomer.TENKHACHHANG,
SDT = infoCustomer.DIENTHOAI,
DiaChi = infoCustomer.DIACHI,
TrangThai = item.TRANGTHAI,
NgayCapNhat = dateUpdate,
TenNguoiCapNhat = TenNhanVien,
TongTien = TongTien,
//PhiShip = ship,
TongNhap = totalIn,
HinhThucThanhToan = "",
});
}
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveChangeStatus(string id, int status)
{
string text = "";
var session = (UserLogin)Session[CommonConstants.USER_SEESION];
var nv = session.UserID;
if (status == 1)
{
var ctdh = new OrdersDao().GetOrderDetail(id);
foreach (var item in ctdh)
{
var product = new SanPhamDao().getProduct(item.MASANPHAM);
if (product.SOLUONG < item.SOLUONG)
{
text += product.TENSANPHAM + " (" + product.MASANPHAM + "), ";
}
}
if (text.Trim() == "")
{
foreach (var item in ctdh)
{
var product = new SanPhamDao().getProduct(item.MASANPHAM);
var updateSLProduct = new SanPhamDao().updateSLProduct(product.MASANPHAM, (int)product.SOLUONG - item.SOLUONG);
}
var oModel = new
{
model = new OrdersDao().SaveChangeStatus(id, status, nv),
text = text
};
return(Json(oModel, JsonRequestBehavior.AllowGet));
}
else
{
var oModel = new
{
model = 0,
text = text
};
return(Json(oModel, JsonRequestBehavior.AllowGet));
}
}
else
{
var oModel = new
{
model = new OrdersDao().SaveChangeStatus(id, status, nv),
text = text
};
return(Json(oModel, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetDataGridOrder(string keyword, int?status)
{
var listDDH = new OrdersDao().GetListDonHang(keyword, status);
var model = new List <OrdersModel>();
foreach (var item in listDDH)
{
var infoCustomer = new CustomerDao().ViewDetail(item.MAKHACHHANG);
var ctDDH = new OrdersDao().GetOrderDetail(item.MAHOADON);
var NhanVien = new AdminDao().ViewDetail(item.NGUOICAPNHAT);
var TenNhanVien = "";
if (NhanVien != null)
{
TenNhanVien = NhanVien.TENNHANVIEN + " (" + NhanVien.MANHANVIEN + ")";
}
var dateUpdate = item.NGAYCAPNHAT;
decimal TongTien = 0;
decimal ship = 0;
foreach (var i in ctDDH)
{
TongTien = TongTien + i.THANHTIEN * i.SOLUONG;
}
if (TongTien <= 300000)
{
ship = 30000;
TongTien += ship;
}
if (dateUpdate == null)
{
dateUpdate = item.NGAYLAP;
}
model.Add(new OrdersModel
{
MaDDH = item.MAHOADON,
TenKH = infoCustomer.TENKHACHHANG,
SDT = infoCustomer.DIENTHOAI,
DiaChi = infoCustomer.DIACHI,
TrangThai = item.TRANGTHAI,
NgayCapNhat = dateUpdate,
TenNguoiCapNhat = TenNhanVien,
TongTien = TongTien,
PhiShip = ship
});
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDataOrederSuccesss(DateTime month)
{
var list = new OrdersDao().GetListOrderForMonth(month);
int sumSuccess = 0, sumCancel = 0;
double[] datasuccess = new double[31];
for (int i = 1; i <= 31; i++)
{
int temp = 0;
foreach (var item in list)
{
if (item.NGAYCAPNHAT.Day == i && item.TRANGTHAI == 1)
{
temp += 1;
sumSuccess += 1;
}
datasuccess[i - 1] = temp;
}
}
double[] datacancel = new double[31];
for (int i = 1; i <= 31; i++)
{
int temp = 0;
foreach (var item in list)
{
if (item.NGAYCAPNHAT.Day == i && item.TRANGTHAI == -1)
{
temp += 1;
sumCancel += 1;
}
datacancel[i - 1] = temp;
}
}
var oModel = new
{
datasuccess = datasuccess,
datacancel = datacancel,
sumCancel = sumCancel,
sumSuccess = sumSuccess,
};
return(Json(oModel, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDataLineChartSalesReport(DateTime month)
{
double[] data = new double[DateTime.Now.Day];
var list = new OrdersDao().GetListOrderForMonth(month);
double sum = 0;
double totalIn = 0;
//for (int i = 1; i <= DateTime.Now.Day; i++)
//{
foreach (var item in list)
{
var ctDDH = new OrdersDao().GetOrderDetail(item.MAHOADON);
if (item.TRANGTHAI == 1)
{
double total = 0;
//double totaltemp = 0;
foreach (var k in ctDDH)
{
var product = new SanPhamDao().getProduct(k.MASANPHAM);
totalIn += k.SOLUONG * (double)product.DONGIA;
total += k.SOLUONG * (double)k.THANHTIEN;
}
//if (totaltemp < 300000)
//{
// total = totaltemp + 30000;
//}
//else
//{
// total = totaltemp;
//}
sum += total;
data[item.NGAYCAPNHAT.Day - 1] += total;
}
}
//}
var oModel = new
{
data = data,
sum = sum,
totalIn = totalIn
};
return(Json(oModel, JsonRequestBehavior.AllowGet));
}
public ActionResult PaymentWithCOD(Data.Models.Order orderInput)
{
try
{
var order = new Data.Models.Order()
{
CreatedDate = DateTime.Now,
PaymentMethod = "COD",
ShipAddress = orderInput.ShipAddress,
ShipEmail = orderInput.ShipEmail,
ShipMobile = orderInput.ShipMobile,
ShipDescription = orderInput.ShipDescription,
Status = 0,
ShipName = orderInput.ShipName
};
var insert = new OrdersDao().Insert(order);
var detailsDao = new OrderDetailsDao();
if (insert)
{
foreach (var cart in CommonConstants.listCart)
{
var orderDetail = new OrderDetails
{
ProductID = cart.Product.ID,
OrderID = order.ID,
Price = cart.Product.Price - cart.Product.Price * cart.Product.Discount / 100,
Quantity = cart.Quantity
};
detailsDao.Insert(orderDetail);
}
}
CommonConstants.listCart.Clear();
Session.Remove("CartSession");
return(RedirectToAction("Success", "Cart"));
}
catch
{
return(RedirectToAction("Index", "Cart"));
}
}
public ActionResult GetDataOrderDetail(string id)
{
var list = new OrdersDao().GetOrderDetail(id);
var model = new List <OrderDetailModel>();
foreach (var item in list)
{
var product = new SanPhamDao().getProduct(item.MASANPHAM);
var img = new SanPhamDao().getListImages(item.MASANPHAM);
model.Add(new OrderDetailModel
{
MaDDH = item.MAHOADON,
MaSanPham = item.MASANPHAM,
DonGiaBan = item.THANHTIEN,
SoLuong = item.SOLUONG,
MauSac = product.MAUSAC,
TenSanPham = product.TENSANPHAM,
Link = img[0].LINKHINHANH
});
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDataReportProduct(string keyword)
{
var list = new BookDao().GetDataBook(keyword);
var model = new List <SanPhamModel>();
//int nhap=0, xuat=0, ton = 0;
foreach (var item in list)
{
var order = new OrdersDao().GetOrderDetailByIDProduct(item.MASANPHAM);
int xuat = 0;
if (order != null)
{
foreach (var items in order)
{
xuat += items.SOLUONG;
}
}
var ncc = new SanPhamDao().GetItemNCC(item.NHACUNGCAP);
string tenNCC = "";
if (ncc != null)
{
tenNCC = ncc.TENNHACUNGCAP;
}
model.Add(new SanPhamModel
{
MASANPHAM = item.MASANPHAM,
TENSANPHAM = item.TENSANPHAM,
MAUSAC = item.MAUSAC,
TACGIA = item.TACGIA,
NGAYCAPNHAT = item.NGAYCAPNHAT,
NHASANXUAT = tenNCC,
XUAT = xuat,
TON = (int)item.SOLUONG,
NHAP = xuat + (int)item.SOLUONG
});
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 更新 Order
/// </summary>
/// <param name="order">欲更新的訂單資料</param>
public void UpdOrder(Order order)
{
OrdersDao orderDao = new OrdersDao();
orderDao.UpdateOrder(order);
}
/// <summary>
/// 新增 Order
/// </summary>
/// <param name="order">欲新增的訂單資料</param>
public void InsOrder(Order order)
{
OrdersDao orderDao = new OrdersDao();
orderDao.AddNewOrderReturnNewOrderId(order);
}
public ActionResult PaymentWithPaypal(Data.Models.Order orderInput)
{
APIContext apiContext = Configuration.GetAPIContext();
try
{
string payerId = Request.Params["PayerID"];
if (String.IsNullOrEmpty(payerId))
{
var profile = new WebProfile
{
name = Guid.NewGuid().ToString(),
presentation = new Presentation
{
brand_name = "ELEX Store",
locale_code = "US"
},
input_fields = new InputFields
{
no_shipping = 1
}
};
var createdProfile = profile.Create(apiContext);
string baseURI = Request.Url.Scheme + "://" + Request.Url.Authority +
"/Paypal/PaymentWithPayPal?";
var guid = Convert.ToString((new Random()).Next(100000));
baseURI += "guid=" + guid + "&webProfileId=" + createdProfile.id;
Session["webProfileId"] = createdProfile.id;
var createdPayment = this.CreatePayment(apiContext, baseURI + "guid=" + guid, createdProfile);
var links = createdPayment.links.GetEnumerator();
string paypalRedirectUrl = null;
while (links.MoveNext())
{
Links lnk = links.Current;
if (lnk.rel.ToLower().Trim().Equals("approval_url"))
{
//saving the payapalredirect URL to which user will be redirected for payment
paypalRedirectUrl = lnk.href;
}
}
Session.Add(guid, createdPayment.id);
Session["OrderInput"] = orderInput;
return(Redirect(paypalRedirectUrl));
}
else
{
// This section is executed when we have received all the payments parameters
// from the previous call to the function Create
// Executing a payment
var guid = Request.Params["guid"];
var webProfileId = Session["webProfileId"].ToString();
Data.Models.Order orderModel = (Data.Models.Order)Session["OrderInput"];
try
{
var order = new Data.Models.Order()
{
CreatedDate = DateTime.Now,
PaymentMethod = "PayPal",
ShipAddress = orderModel.ShipAddress,
ShipEmail = orderModel.ShipEmail,
ShipMobile = orderModel.ShipMobile,
ShipDescription = orderModel.ShipDescription,
Status = 0,
ShipName = orderModel.ShipName
};
var insert = new OrdersDao().Insert(order);
var detailsDao = new OrderDetailsDao();
if (insert)
{
foreach (var cart in CommonConstants.listCart)
{
var orderDetail = new OrderDetails
{
ProductID = cart.Product.ID,
OrderID = order.ID,
Price = cart.Product.Price - cart.Product.Price * cart.Product.Discount / 100,
Quantity = cart.Quantity
};
detailsDao.Insert(orderDetail);
}
}
var executedPayment = ExecutePayment(apiContext, payerId, Session[guid] as string);
WebProfile.Delete(apiContext, webProfileId);
Session.Remove("webProfileId");
CommonConstants.listCart.Clear();
Session["CartSession"] = CommonConstants.listCart;
if (executedPayment.state.ToLower() != "approved")
{
return(RedirectToAction("Index", "Home"));
}
}
catch (Exception)
{
return(RedirectToAction("Index", "Cart"));
}
}
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Home"));
}
return(RedirectToAction("Success", "Cart"));
}
/// <summary>
/// 取得 Order by 訂單編號
/// </summary>
/// <param name="orderID">訂單編號</param>
/// <returns></returns>
public Order GetOrder(int orderID)
{
OrdersDao dao = new OrdersDao();
return(dao.GetOrderById(orderID));
}
/// <summary>
/// 刪除 Order
/// </summary>
/// <param name="orderID">訂單編號</param>
public void DelOrder(int orderID)
{
OrdersDao orderDao = new OrdersDao();
orderDao.DeleteOrder(orderID);
}
