public ActionResult XemLaiDonHang()
{
long idorder = long.Parse(Request.QueryString["idorder"]);
int tongtien = 0;
var odao = new DonHangDAO();
var model = odao.ViewByID(idorder);
ViewBag.vbCustomer = model;
var cart = Session[CartSession];
var list = new List <CartItem>();
if (cart != null)
{
list = (List <CartItem>)cart;
}
foreach (var item1 in list)
{
//Kiểm tra nếu có giá khuyến mãi
if (item1.Product.GiaKhuyenMai != null)
{
tongtien = tongtien + (int.Parse(item1.Product.GiaKhuyenMai.Value.ToString()) * item1.Quantity);
}
else
{
tongtien = tongtien + (int.Parse(item1.Product.Gia.Value.ToString()) * item1.Quantity);
}
//Lay tong so luong sp cua moi sp de ham js chay
}
ViewBag.vb_tongtien = tongtien;
return(View(list));
}
public ActionResult dathang()
{
var DAO = new DonHangDAO();
var dao1 = new SachDAO();
DonHang newDH = new DonHang();
newDH.masach = donhang.masach;
newDH.mataikhoan = donhang.mataikhoan;
newDH.ngaygiao = donhang.ngaygiao;
newDH.tinhtrang = donhang.tinhtrang;
if (donhang == null)
{
return(View("Index"));
}
DAO.Insert(newDH);
dao1.SaledBook(donhang.masach);
TaiKhoan tk = null;
UserLogin user = (UserLogin)Session[Common.CommonConstrants.USER_SESSION];
if (user != null)
{
tk = db.TaiKhoans.SingleOrDefault(x => x.ma == user.ID ? true : false);
}
return(View("kiemtradonhang", getdonhang(tk)));
}
public ActionResult HoanThanhDonHang(long id)
{
var dao = new DonHangDAO();
dao.HoanThanhDongHang(id);
return(RedirectToAction("DonHangHoanThanh", "QuanLyDonHang"));
}
public int changeGiaoHang(int id)
{
var user = ((UserLogin)Session[CommonStants.USER_SESSION]).userName;
var dao = new DonHangDAO();
return(dao.ChangeStatus(id, user, 6));
}
public ActionResult ChiTietDonHang(int ID_DONHANG)
{
var model = DonHangDAO.getHoaDon_Full(ID_DONHANG);
ViewData["chitiet"] = DonHangDAO.getChiTietHoaDon_byID(ID_DONHANG);
return(View(model.Single()));
}
public ActionResult HuyDonHang(long id)
{
var dao = new DonHangDAO();
dao.HuyDonHang(id);
return(RedirectToAction("DonHangDaHuy", "QuanLyDonHang"));
}
//
// GET: /Admin/DonHang/
public ActionResult DanhSachDonHang()
{
var model = DonHangDAO.getHoaDon();
ViewBag.TongHD = model.Count();
return(View(model));
}
// GET: Admin/DonHang
public ActionResult Index()
{
var dao = new DonHangDAO();
var model = dao.GetListDonHang();
return(View(model));
}
public JsonResult GetListDonHang()
{
var dao = new DonHangDAO();
var result = dao.GetListDonHang();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DonHangDaHuy(string searchString, int page = 1, int pageSize = 5)
{
var dao = new DonHangDAO();
var model = dao.DonHangDaHuy(searchString, page, pageSize);
ViewBag.searchstring = searchString;
return(View(model));
}
public void setUp()
{
donhangDAO = new DonHangDAO();
this.dh1 = new DonHangDTO("1", "1651010034", "18/11/2018", "KH01");
this.dh2 = new DonHangDTO("2", "1651010144", "17/11/2018", "KH02");
this.dh3 = new DonHangDTO("3", "1651010034", "16/11/2018", "KH03");
this.dh4 = new DonHangDTO("4", "1651010144", "15/11/2018", "KH04");
}
public JsonResult loadDonHang()
{
var listDonHang = new DonHangDAO().getDanhSach();
return(Json(new
{
data = listDonHang
}, JsonRequestBehavior.AllowGet));
}
public JsonResult DetailOrder(int id)
{
var dao = new DonHangDAO();
List <OrderDetailModel> model = new List <OrderDetailModel>();
model = dao.GetDetailDonHang(id);
return(Json(model, JsonRequestBehavior.AllowGet));
}
public JsonResult Export(int id)
{
bool kq = false;
try
{
var app = new Microsoft.Office.Interop.Excel.Application();
Workbook workbook = app.Workbooks.Add(System.Reflection.Missing.Value);
Worksheet worksheet = workbook.ActiveSheet;
var oder = new DonHangDAO().GetDetailDonHang(id);
worksheet.Cells[1, 1] = "Số hóa đơn";
worksheet.Cells[1, 2] = id;
worksheet.Cells[1, 4] = "Hóa đơn Mobile Shop";
worksheet.Cells[3, 1] = "STT";
worksheet.Cells[3, 2] = "Tên hàng hóa";
worksheet.Cells[3, 3] = "ĐVT";
worksheet.Cells[3, 4] = "Số lượng";
worksheet.Cells[3, 5] = "Đơn giá";
worksheet.Cells[3, 6] = "Giảm giá";
worksheet.Cells[3, 7] = "Thành tiền";
int row = 4;
foreach (var item in oder)
{
worksheet.Cells[row, 1] = row - 3;
worksheet.Cells[row, 2] = item.NameProduct;
worksheet.Cells[row, 3] = "VNĐ";
worksheet.Cells[row, 4] = item.Quantity;
worksheet.Cells[row, 5] = item.Quantity * item.Price;
worksheet.Cells[row, 6] = item.Promotion;
worksheet.Cells[row, 7] = item.Quantity * item.Price - (item.Quantity * item.Price) * (item.Promotion / 100);
row++;
}
worksheet.Cells[row + 1, 1] = "Người nhân(Ký và ghi rõ họ tên)";
worksheet.Cells[row + 2, 5] = "Ngày ... Tháng ... Năm ...";
worksheet.Cells[row + 1, 5] = "Người bán hàng(Ký và ghi rõ họ tên)";
workbook.SaveAs("C:\\Users\\GALAXY\\Desktop\\da\\bandienthoai\\bandienthoai\\Data\\Content\\HoaDon_" + id + ".xls");
workbook.Close();
Marshal.ReleaseComObject(workbook);
app.Quit();
Marshal.FinalReleaseComObject(app);
kq = true;
}
catch
{
}
return(Json(new { status = kq }, JsonRequestBehavior.AllowGet));
}
public JsonResult DanhSachDonHang_select(DateTime date)
{
var result = DonHangDAO.getHoaDon_ByDate(date);
ViewBag.TongHD = result.Count();
return(Json(new
{
status = result
}, JsonRequestBehavior.AllowGet));
}
public static int InsetOrder(DON_HANG_DTO dh)
{
try
{
return(DonHangDAO.InsertOrder(dh));
}
catch (Exception e)
{
throw e;
}
}
public static void InsertCTOrder(CHI_TIET_DON_HANG_DTO ct)
{
try
{
DonHangDAO.InsertCTOrder(ct);
}
catch (Exception e)
{
throw e;
}
}
public static int InsertPackage(PACKAGEINFO_DTO pac, int madh)
{
try
{
return(DonHangDAO.InsertPackage(pac, madh));
}
catch (Exception e)
{
throw e;
}
}
public static List <DON_HANG_DTO> GetAllOrderKH(string username)
{
try
{
return(DonHangDAO.GetAllOrderKH(username));
}
catch (Exception e)
{
throw e;
}
}
public static List <CHI_TIET_DON_HANG_DTO> ViewOrderDetailsByOrderCode(int maDonHang)
{
try
{
return(DonHangDAO.ViewOrderDetailsByOrderCode(maDonHang));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static DataTable GetOrderInformationByCode(int maDonHang)
{
try
{
return(DonHangDAO.GetOrderInformationByCode(maDonHang));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public JsonResult ChuaThanhToan(int id)
{
var dao = new DonHangDAO();
var result = false;
dao.ThanhToan(id, false);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult ThongTinKhachHang(string txtName, string txtPhone, string txtAddress, string txtEmail)
{
//Tạo và lấy thông tin của order
var od = new DONHANG();
DonHangDAO ODAO = new DonHangDAO();
long idorder = 0;
od.NgayTao = DateTime.Now;
od.TenKhachHang = txtName;
od.DiaChiKhachHang = txtAddress;
od.DienThoaiKhachHang = txtPhone;
od.EmailKhachHang = txtEmail;
od.TrangThai = 0;
try
{
idorder = ODAO.Insert(od);
//Thêm order vào chi tiết
var list = (List <CartItem>)Session[CartSession];;
if (list != null)
{
foreach (var item in list)
{
CHITIETDONHANG od1 = new CHITIETDONHANG();
CoDAO ccc = new CoDAO();
od1.IDDonHang = idorder;
od1.IDCo = ccc.LayIDCoGiayTheoIDSPVaCo(item.Product.ID, item.CoGiay);
od1.SoLuong = item.Quantity;
int giatien = 0;
if (item.Product.GiaKhuyenMai != null && item.Product.GiaKhuyenMai > 0)
{
giatien = (int.Parse(item.Product.GiaKhuyenMai.Value.ToString()) * item.Quantity);
}
else
{
giatien = (int.Parse(item.Product.Gia.Value.ToString()) * item.Quantity);
}
od1.Gia = giatien;
ChiTietDonHangDAO ODDAO = new ChiTietDonHangDAO();
ODDAO.Add(od1);
}
}
}
catch (Exception)
{
throw;
}
return(Redirect("/GioHang/XemLaiDonHang?idorder=" + idorder + ""));
}
protected void data_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Sua")
{
id = (string)e.CommandArgument;
Response.Redirect("suadonhang.aspx?id=" + id);
}
else
{
id = (string)e.CommandArgument;
DonHangDAO DAO = new DonHangDAO();
DAO.XoaDH(id);
LoadDuLieu();
}
}
public JsonResult DatHang(string listProduct, string orderDetail)
{
//Chuyển chuỗi json thành object
var listSanPham = JsonConvert.DeserializeObject <List <SanPhamGioHang> >(listProduct);
//Chuyển chuỗi json thành object
var donHang = JsonConvert.DeserializeObject <DonHang>(orderDetail);
var status = new DonHangDAO().insert(listSanPham, donHang);
return(Json(new
{
status = status
}));
}
public ActionResult Payment(ICollection <ChiTietDonHang> list)
{
DonHang dh = new DonHang();
DonHangDAO dhDAO = new DonHangDAO();
dh.userId = Convert.ToInt32(System.Web.HttpContext.Current.Session["USER_ID"]);
dh.address = Convert.ToString(System.Web.HttpContext.Current.Session["ADDRESS"]);
dh.ChiTietDonHangs = list;
dh.status = "pending";
dh.createdAt = DateTime.Now;
dhDAO.them(dh);
DiscountDAO dc = new DiscountDAO();
ViewBag.discountList = dc.GetAll();
return(Content("ok na"));
}
// set chờ duyệt
public int changeChoDuyet(int id)
{
var user = ((UserLogin)Session[CommonStants.USER_SESSION]).userName;
var dao = new DonHangDAO();
var check = dao.GetOrderByID(id);
if (check.STATUS == 2)
{
return(dao.ChangeStatus(id, user, 1));
}
else
{
return(-1);
}
}
public JsonResult ThanhToan(int id)
{
var dao = new DonHangDAO();
var result = false;
result = dao.ThanhToan(id, true);
if (result)
{
SetAlert("Thanh toán thành công", "success");
}
else
{
ModelState.AddModelError("", "Thanh toán Thất Bại!");
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult Delete(int id)
{
var dao = new DonHangDAO();
var result = false;
result = dao.Delete(id);
if (result)
{
SetAlert("Xóa thành công", "success");
}
else
{
ModelState.AddModelError("", "Xóa Thất Bại!");
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult Order(string nguoinhan, string sdt, string diachi, int?idKH, string listIdSP, string listsoluong)
{
try
{
int[] idSP = new DonHangDAO().ConvertStringToArray(listIdSP);
int[] soluong = new DonHangDAO().ConvertStringToArray(listsoluong);
DONHANG dh = new DONHANG(nguoinhan, sdt, diachi, idKH);
int idDH = DH_DAO.InsertDonHang(dh);
for (int i = 0; i < idSP.Length; i++)
{
CHITIETDONHANG CTDH = new CHITIETDONHANG(idSP[i], dh.ID, soluong[i], (int)new SANPHAM_DAO().GetPriceBySanPham(idSP[i]).GIABAN);
new ChiTietDH_DAO().InsertCHITIETDH(CTDH);
}
return(Ok(1));
}
catch
{
return(Ok(0));
}
}
