public ChiTietDonHangDTO(ChiTietDonHang ct)
{
SOLUONGMUA = ct.SOLUONGMUA;
TRANGTHAIGIAOHANG = ct.TRANGTHAIGIAOHANG;
TRANGTHAISUDUNG = ct.TRANGTHAISUDUNG;
LANGIAOHANGTHU = ct.LANGIAOHANGTHU;
NGAYGIAOHANG = ct.NGAYGIAOHANG;
MADH = ct.MADH;
VOUCHERDH = ct.VOUCHERDH;
}
public ActionResult Create([Bind(Include = "SoHieuDonHang,MaDonHang,MaSanPham,SoLuongSanPham,GiaSanPham,GhiChu")] ChiTietDonHang chiTietDonHang)
{
if (ModelState.IsValid)
{
db.ChiTietDonHangs.Add(chiTietDonHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaDonHang = new SelectList(db.DonHangs, "MaDonHang", "MaNhanVien", chiTietDonHang.MaDonHang);
ViewBag.MaSanPham = new SelectList(db.SanPhams, "MaSanPham", "MaDMSP", chiTietDonHang.MaSanPham);
return(View(chiTietDonHang));
}
public ActionResult Create([Bind(Include = "MaDonHang,MaSP,SoLuong")] ChiTietDonHang chiTietDonHang)
{
if (ModelState.IsValid)
{
db.ChiTietDonHangs.Add(chiTietDonHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaDonHang = new SelectList(db.DonHangs, "MaDonHang", "Email", chiTietDonHang.MaDonHang);
ViewBag.MaSP = new SelectList(db.SanPhams, "MaSP", "TenSP", chiTietDonHang.MaSP);
return(View(chiTietDonHang));
}
public bool Insert(ChiTietDonHang orderDetail)
{
try
{
db.ChiTietDonHangs.Add(orderDetail);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Insert(ChiTietDonHang cthd)
{
try
{
db.ChiTietDonHangs.Add(cthd);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public ActionResult XacNhanXoa(int madonhang, string maSP)
{
ChiTietDonHang ct = db.ChiTietDonHang.Find(madonhang, maSP);
if (ct == null)
{
Response.StatusCode = 404;
return(null);
}
db.ChiTietDonHang.Remove(ct);
db.SaveChanges();
return(RedirectToAction("Index", "QuanLyChiTietDonHang", new { @madonhang = madonhang }));
}
public ActionResult Edit([Bind(Include = "MaCTDH,MaDH,MaSP,SoLuong")] ChiTietDonHang chiTietDonHang)
{
ValidateProduct(chiTietDonHang);
if (ModelState.IsValid)
{
db.Entry(chiTietDonHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaDH = new SelectList(db.DonHangs, "MaDH", "Email", chiTietDonHang.MaDH);
ViewBag.TenSP = new SelectList(db.SanPhams, "MaSP", "TenSP", chiTietDonHang.SanPham.TenSP);
return(View(chiTietDonHang));
}
//Hiển thị sản phẩm
public ActionResult HienThi(int MaDonHang)
{
//Lấy ra đối tượng sách theo mã
ChiTietDonHang chitietdonhang = db.ChiTietDonHangs.SingleOrDefault(n => n.MaDonHang == MaDonHang);
if (chitietdonhang == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(chitietdonhang));
}
public ActionResult Edit([Bind(Include = "MaDH,MaSP,SoLuong,DonGia")] ChiTietDonHang chiTietDonHang)
{
if (ModelState.IsValid)
{
db.Entry(chiTietDonHang).State = EntityState.Modified;
db.SaveChanges();
Url.Action("TongTienDH", "DonHang", new { maDH = chiTietDonHang.MaDH });
return(RedirectToAction("Details", "DonHang", new { id = chiTietDonHang.MaDH }));
}
ViewBag.MaDH = new SelectList(db.DonHang, "MaDH", "LuuY", chiTietDonHang.MaDH);
ViewBag.MaSP = new SelectList(db.SanPham, "MaSP", "TenSP", chiTietDonHang.MaSP);
return(View(chiTietDonHang));
}
public IEnumerable <ChiTietDonHang> Get(ChiTietDonHang chitiet)
{
List <ChiTietDonHang> chitietdonhang = new List <ChiTietDonHang>();
List <ChiTietDonHang> dbchitiet = dbContext.ChiTietDonHangs.ToList();
foreach (ChiTietDonHang item in dbchitiet)
{
if (item.ID_DonHang == chitiet.ID_DonHang)
{
chitietdonhang.Add(item);
}
}
return(chitietdonhang);
}
public ActionResult XacNhanXoa(int MaDonHang)
{
DonHang donhang = db.DonHangs.SingleOrDefault(n => n.MaDonHang == MaDonHang);
ChiTietDonHang chitietdonhang = db.ChiTietDonHangs.SingleOrDefault(n => n.MaDonHang == MaDonHang);
if (donhang == null || chitietdonhang != null)
{
Response.StatusCode = 404;
return(null);
}
db.DonHangs.Remove(donhang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Admin/CTDH/Details/5
public ActionResult Details(int?idDH, int?idSP)
{
if (idDH == null || idSP == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietDonHang chiTietDonHang = db.ChiTietDonHang.Where(x => x.MaDH == idDH && x.MaSP == idSP).SingleOrDefault();
if (chiTietDonHang == null)
{
return(HttpNotFound());
}
return(View(chiTietDonHang));
}
public bool Insert(ChiTietDonHang chitiet)
{
try
{
db.ChiTietDonHangs.Add(chitiet);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
Console.WriteLine("Error here" + ex.Message);
return(false);
}
}
public ActionResult XacNhanXoa(int MaDonHang, int MaSach)
{
ChiTietDonHang ctdh = db.ChiTietDonHangs.Where(n => n.MaDH == MaDonHang && n.MaSach == MaSach).FirstOrDefault();
DonHang dh = db.DonHangs.FirstOrDefault(n => n.MaDH == MaDonHang);
if (ctdh == null && dh == null)
{
Response.StatusCode = 404;
return(null);
}
db.ChiTietDonHangs.Remove(ctdh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult DeleteChiTietDonHang(int id)
{
ChiTietDonHang chiTietDonHang = db.ChiTietDonHangs.Find(id);
if (chiTietDonHang == null)
{
return(NotFound());
}
db.ChiTietDonHangs.Remove(chiTietDonHang);
db.SaveChanges();
return(Ok(chiTietDonHang));
}
// GET: ChiTietDonHang/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietDonHang chiTietDonHang = db.ChiTietDonHangs.Find(id);
if (chiTietDonHang == null)
{
return(HttpNotFound());
}
return(View(chiTietDonHang));
}
public ActionResult DatHang(NguoiDung ng)
{
var gioHang = Session["GioHang"] as Cart;
if (gioHang == null || gioHang.TongSanPham == 0)
{
return(RedirectToAction("Index", "Home"));
}
int soHDTonTai = db.DonHangs.Count();
int soCTDHTonTai = db.ChiTietDonHangs.Count();
int soNgDung = db.NguoiDungs.Count();
try
{
ng.IdNguoiDung = soNgDung++;
ng.IdKieuNguoiDung = 1;
ng.TenDangNhap = "nguoiDung";
ng.MatKhau = "matkhau";
db.NguoiDungs.Add(ng);
DonHang dh = new DonHang();
dh.IdDonHang = soHDTonTai + 1;
dh.IdNguoiDung = ng.IdNguoiDung;
dh.IdTinhTrangDonHang = 1;
dh.NgayTaoDonHang = DateTime.Now;
dh.NgayXuLyDonHang = DateTime.Now;
dh.TrackingNumber = (soHDTonTai + 1).ToString();
dh.IdGiaoDich = dh.TrackingNumber;
db.DonHangs.Add(dh);
for (int i = 0; i < gioHang.getLsCart.Count; i++)
{
ChiTietDonHang ct = new ChiTietDonHang();
ct.IdChiTietDonHang = soCTDHTonTai + i;
ct.IdSanPham = gioHang.getLsCart[i].sanPham.IdSanPham;
ct.IdDonHang = dh.IdDonHang;
ct.SoLuongSanPham = gioHang.getLsCart[i].soLuong;
db.ChiTietDonHangs.Add(ct);
}
db.SaveChanges();
gioHang.clear();
return(RedirectToAction("Index", "Home"));
}
catch (Exception ex)
{
string a = "Error" + ex;
return(RedirectToAction("Index"));
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBoxCustomerID.Text == "" || textBoxCustomerID.Text == null)
{
MessageBox.Show("Hãy nhập thông tin khách hàng !");
}
else
{
GioHangDao dao = new GioHangDao();
// thêm id khách hàng vào trong bảng GioHang
dao.addIdCustomerToAllRecord(int.Parse(textBoxCustomerID.Text));
// Tạo Record trong bảng DonHang
DonHang d = new DonHang();
d.MaKH = int.Parse(dao.getIdCustomer());
d.TongTien = dao.netAmount();
DonHangDao donhangDao = new DonHangDao();
var idDonHang = donhangDao.insertDonHang(d);
// Tạo Record trong bảng ChiTietDonHang
foreach (var item in dao.listGioHang())
{
var tensach = item.BookTitle;
var soluong = item.Qty;
var dongia = item.Price;
SachDao sachDao = new SachDao();
// Tạo 1 ChiTietDonHang và thêm các thuộc tính vào
ChiTietDonHang ctdh = new ChiTietDonHang();
ctdh.MaDH = int.Parse(idDonHang);
ctdh.MaSach = sachDao.getIdBookByName(tensach);
ctdh.SoLuong = soluong;
ctdh.DonGia = dongia;
// Insert record vào ChiTietDonHang
ChiTietDonHangDao ctdhDao = new ChiTietDonHangDao();
ctdhDao.insertChiTietDonHang(ctdh);
// Update lại số lượng tồn của Sach
sachDao.updateStock(ctdh.MaSach, (int)ctdh.SoLuong);
}
// Clear all
clearAll();
// Xóa hết bảng GioHang
dao.deleteAllCartRecord();
MessageBox.Show("Thành công !");
}
}
// GET: ChiTietDonHang/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietDonHang chiTietDonHang = db.ChiTietDonHangs.Find(id);
if (chiTietDonHang == null)
{
return(HttpNotFound());
}
ViewBag.Ma_PDH = new SelectList(db.PhieuDonHangs, "Ma_PDH", "MaHoaDon", chiTietDonHang.Ma_PDH);
return(View(chiTietDonHang));
}
private void Luuchitietdonhang(Giohang giohang, MainContext db, int maDH)
{
foreach (var temp in giohang.getGiohang())
{
var chiTiet = new ChiTietDonHang()
{
DonHangId = maDH,
SanPhamId = temp.sanPham.Id,
SoLuong = temp.Soluong,
ThanhTien = (decimal)temp.Thanhtien
};
db.ChiTietDonHangs.Add(chiTiet);
}
db.SaveChanges();
}
private void luuChiTietDonHang(int maDH)
{
foreach (var item in (List <Cart>)Session["Cart"])
{
ChiTietDonHang chiTietDon = new ChiTietDonHang()
{
MaSP = item.SanPham.MaSP,
MaDonHang = maDH,
SoLuong = item.Quantity,
TongTien = item.Quantity * item.SanPham.GiaSP
};
db.ChiTietDonHangs.Add(chiTietDon);
db.SaveChanges();
}
}
public ActionResult Create(string TenNguoiNhan, string SDTNguoiNhan, string Email, string DiaChiNhan, string GhiChu)
{
var dao = new DonHangDao();
var productDao = new ProductDao();
var chitietDao = new ChiTietDonHangDao();
DonHang don = new DonHang();
var user = (UserLogin)Session[Common.CommonConstants.USER_SESSION];
don.IdUser = user.UserID;
don.NgayDat = DateTime.Now;
don.TrangThai = 0;
don.TenNguoiNhan = TenNguoiNhan;
don.SDTNguoiNhan = SDTNguoiNhan;
don.Email = Email;
don.DiaChiNhan = DiaChiNhan;
don.GhiChu = GhiChu;
don.TongTien = 0;
var list = (List <CartItem>)Session[Common.CommonConstants.CartSession];
var maDonHang = dao.insert(don);
if (maDonHang >= 0)
{
long tongtien = 0;
foreach (var item in list)
{
ChiTietDonHang entity = new ChiTietDonHang();
entity.MaDonHang = maDonHang;
entity.MaSach = item.SanPham.MaSach;
entity.SoLuong = item.SoLuong;
entity.DonGia = (int)item.SanPham.DonGia;
entity.ThanhTien = entity.SoLuong * entity.DonGia;
chitietDao.insert(entity);
productDao.UpdateSoLuong(item.SoLuong, entity.MaSach);
tongtien += (long)entity.ThanhTien;
}
dao.UpdateTongTien(tongtien, maDonHang);
Session[Common.CommonConstants.CartSession] = null;
string s = "Bạn đã đặt hàng thành công. Vui lòng xem chi tiết trong tài khoản cá nhân ";
List <string> overList = new List <string>();
overList.Add(s);
Session[Common.CommonConstants.OverSoLuong] = overList;
}
return(RedirectToAction("Index", "Cart"));
}
public ActionResult DatHang(FormCollection f)
{
string ten = "";
int gia = 0;
int sl = 0;
DonDatHang ddh = new DonDatHang();
KhachHang kh = (KhachHang)Session["Taikhoan"];
List <GioHang> gh = layGioHang();
ddh.MaKH = kh.MaKH;
ddh.NgayDat = DateTime.Now;
var ngaygiao = String.Format("{0:MM/dd/yyyy}", f["NgayGiao"].ToString());
ddh.NgayGiao = DateTime.Parse(ngaygiao);
ddh.TinhTrangGiaoHang = false;
ddh.DaThanhToan = false;
db.DonDatHangs.InsertOnSubmit(ddh);
db.SubmitChanges();
foreach (var item in gh)
{
ChiTietDonHang ctdh = new ChiTietDonHang();
ctdh.MaDonHang = ddh.MaDonHang;
ctdh.MaHang = item.maHang;
ctdh.Soluong = item.soLuong;
ctdh.DonGia = (decimal)item.donGia;
db.ChiTietDonHangs.InsertOnSubmit(ctdh);
foreach (MatHang g in db.MatHangs.ToList())
{
if (g.MaHang == ctdh.MaHang)
{
ten += g.TenHang + ",";
}
}
}
db.SubmitChanges();
foreach (ChiTietDonHang a in db.ChiTietDonHangs.Where(n => n.MaDonHang == ddh.MaDonHang).ToList())
{
sl += (int)a.Soluong;
gia += (int)(a.DonGia * a.Soluong);
}
string url = "https://www.baokim.vn/payment/product/[email protected]&id=&order_description=ABC" + "&product_name=" + ten.Substring(0, (ten.Length - 1)) + "&product_price=" + gia + "&product_quantity=" + sl + "&total_amount=" + gia + "&url_cancel=&url_detail=&url_success=" + Url.Action("XacNhanDonHang", "GioHang", new { idDH = ddh.MaDonHang, kt = 1 });
Session["GioHang"] = null;
return(Redirect(url));
}
public bool Update(ChiTietDonHang entity)
{
try
{
var bill = db.ChiTietDonHangs.Find(entity.MaDH);
bill.SoLuong = entity.SoLuong;
bill.DonGia = entity.DonGia;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
// GET: ChiTietDonHangs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietDonHang chiTietDonHang = db.ChiTietDonHang.Find(id);
if (chiTietDonHang == null)
{
return(HttpNotFound());
}
ViewBag.SerialNumber = new SelectList(db.SanPham, "SerialNumber", "MaLoaiSP", chiTietDonHang.SerialNumber);
ViewBag.MaDonHang = new SelectList(db.DonHang, "MaDonHang", "MaDonHang", chiTietDonHang.MaDonHang);
return(View(chiTietDonHang));
}
public ActionResult LuuDiemDanhGia(int id, int diem)
{
ChiTietDonHang chiTietDonHang = db.ChiTietDonHangs.Find(id);
Album album = db.Albums.Find(chiTietDonHang.AlbumID);
DiemDanhGia diemDanhGia = new DiemDanhGia();
diemDanhGia.Diem = diem;
diemDanhGia.ChiTietDonHangID = id;
Decimal diemTB = Convert.ToDecimal((album.DiemDanhGia + diem) / 2);
album.DiemDanhGia = diemTB;
db.Entry(album).State = EntityState.Modified;
db.DiemDanhGias.Add(diemDanhGia);
db.SaveChanges();
return(RedirectToAction("ThongTinDonHang", new { id = chiTietDonHang.DonHangID }));
}
// GET: Admin/CTDH/Edit/5
public ActionResult Edit(int?idDH, int?idSP)
{
if (idDH == null || idSP == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietDonHang chiTietDonHang = db.ChiTietDonHang.Where(x => x.MaDH == idDH && x.MaSP == idSP).SingleOrDefault();
if (chiTietDonHang == null)
{
return(HttpNotFound());
}
ViewBag.MaDH = new SelectList(db.DonHang, "MaDH", "LuuY", chiTietDonHang.MaDH);
ViewBag.MaSP = new SelectList(db.SanPham, "MaSP", "TenSP", chiTietDonHang.MaSP);
return(View(chiTietDonHang));
}
// GET: Admin/ChiTietDonHangs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietDonHang chiTietDonHang = db.ChiTietDonHangs.Find(id);
if (chiTietDonHang == null)
{
return(HttpNotFound());
}
ViewBag.MaDonHang = new SelectList(db.DonHangs, "MaDonHang", "Email", chiTietDonHang.MaDonHang);
ViewBag.MaSP = new SelectList(db.SanPhams, "MaSP", "TenSP", chiTietDonHang.MaSP);
return(View(chiTietDonHang));
}
public ActionResult ChinhSua(int?madonhang, string maSP)
{
if (madonhang == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietDonHang ct = db.ChiTietDonHang.Find(madonhang, maSP);
if (ct == null)
{
Response.StatusCode = 404;
return(null);
}
ViewBag.maSP = new SelectList(db.SanPham.ToList().OrderBy(n => n.tenSP), "maSP", "tenSP");
return(View(ct));
}
public ActionResult DatHangTaiCuaHang()
{
//Kiểm tra đăng nhập
if ((Session["TaiKhoan"] == null) || (Session["TaiKhoan"].ToString() == ""))
{
return(RedirectToAction("DangNhap", "NguoiDung"));
}
//Kiểm tra giỏ hàng
if (Session["GioHang"] == null)
{
RedirectToAction("Index", "Home");
}
//thêm đơn hàng
DonHang dh = new DonHang();
KhachHang kh = (KhachHang)Session["TaiKhoan"];
List <GioHang> gh = LayGioHang();
dh.MaKH = kh.MaKH;
dh.HoTen = kh.HoTen;
dh.TaiKhoan = kh.TaiKhoan;
dh.DaThanhToan = Convert.ToInt32(TongTien());
dh.TinhTrangGiaoHang = 0;
dh.DuyetDonHang = 0;
dh.NgayDat = DateTime.Now;
dh.NgayGiao = DateTime.Now;
db.DonHangs.Add(dh);
db.SaveChanges();
//Thêm chi tiết đơn hàng
foreach (var item in gh)
{
ChiTietDonHang ctdh = new ChiTietDonHang();
ctdh.MaDonHang = dh.MaDonHang;
ctdh.MaDienThoai = item._MaDienThoai;
ctdh.SoLuong = item._SoLuong;
ctdh.DonGia = item._DonGia.ToString();
DienThoai dienthoai = db.DienThoais.SingleOrDefault(n => n.MaDienThoai == item._MaDienThoai);
dienthoai.SoLuongTon -= item._SoLuong;
db.ChiTietDonHangs.Add(ctdh);
db.SaveChanges();
Session["GioHang"] = null;
}
db.SaveChanges();
Session["GioHang"] = null;
return(RedirectToAction("Camonquykhach", "GioHang"));
}
public ActionResult AddOrEditCTDH(ChiTietDonHang ct)
{
using (DBNoiThat db = new DBNoiThat())
{
if (ct.IDCT == 0)
{
if (db.ChiTietDonHangs.Where(p => p.IDSanPham == ct.IDSanPham && p.IDDonHang == ct.IDDonHang).FirstOrDefault() != null)
{
return(Json(new { success = false, message = "Sản phẩm đã tồn tại trong đơn hàng!" }, JsonRequestBehavior.AllowGet));
}
ct.DonGia = db.SanPhams.Where(p => p.ID == ct.IDSanPham).FirstOrDefault().Gia;
ct.ThanhTien = ct.SoLuong * ct.DonGia;
db.ChiTietDonHangs.Add(ct);
DonHang dh = db.DonHangs.Where(p => p.ID == ct.IDDonHang).FirstOrDefault();
dh.TongTien = dh.TongTien + ct.ThanhTien - dh.DaGiamGia;
db.SaveChanges();
return(Json(new { success = true, message = "Thêm mới thành công!" }, JsonRequestBehavior.AllowGet));
}
else
{
try
{
ChiTietDonHang ct2 = db.ChiTietDonHangs.Where(p => p.IDCT == ct.IDCT).FirstOrDefault();
DonHang dh = db.DonHangs.Where(p => p.ID == ct.IDDonHang).FirstOrDefault();
dh.TongTien = dh.TongTien - ct2.ThanhTien;
ct2.IDSanPham = ct.IDSanPham;
ct2.SoLuong = ct.SoLuong;
ct2.ThanhTien = ct2.SoLuong * ct2.DonGia;
dh.TongTien = dh.TongTien + ct2.ThanhTien - dh.DaGiamGia;
db.SaveChanges();
return(Json(new { success = true, message = "Cập nhật thành công!" }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { success = false, message = "Cập nhật thất bại!" }, JsonRequestBehavior.AllowGet));
}
}
}
}
public static int ThemChiTietDonHang(ChiTietDonHang ct)
{
string query = String.Format("INSERT INTO ChiTietDonHang(MaDH, MaSP, SoLuong, DonGia, ThanhTien) VALUES (" + ct.MaDH + ", '" + ct.MaSP + "', " + ct.SoLuong + ", " + ct.DonGia + ", " + ct.ThanhTien + ")");
try
{
conn.Open();
command.CommandText = query;
return command.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return 0;
}
private void AddDonHangToDB(DataRowView dr, int dhid, int chid, string tench)
{
ChiTietDonHang ctdh = new ChiTietDonHang();
ctdh.InsertFields(dhid, int.Parse(dr["SanPhamID"].ToString()), dr["TenSanPham"].ToString(),
decimal.Parse(dr["GiaSanPham"].ToString()),
int.Parse(dr["SoSanPham"].ToString()), decimal.Parse(dr["TongTien"].ToString()), chid, tench);
}
