public ActionResult DatHang(FormCollection collection)
{
//Them Don hang
DonDatHang ddh = new DonDatHang();
Account kh = (Account)Session["Taikhoan"];
List <Giohang> gh = Laygiohang();
ddh.Dathanhtoan = false;
ddh.Tinhtranggiaohang = false;
ddh.Ngaydat = DateTime.Now;
var ngaygiao = String.Format("{0:MM/dd/yyyy}", collection["Ngaygiao"]);
ddh.Ngaygiao = DateTime.Parse(ngaygiao);
ddh.MaKH = kh.MaKH;
// db.DonDatHangs.InsertOnSubmit(ddh);
// db.SubmitChanges();
//Them chi tiet don hang
foreach (var item in gh)
{
CHITIETDONDATHANG ctdh = new CHITIETDONDATHANG();
ctdh.IdDDH = ddh.IdDDH;
ctdh.IdSP = item.idsp;
ctdh.Soluong = item.soluong;
ctdh.Dongia = (decimal)item.dongia;
//db.CHITIETDONDATHANGs.InsertOnSubmit(ctdh);
}
//db.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
public ActionResult ThanhToan(FormCollection collector)
{
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = Session["KhachHang"] as KHACHHANG;
List <SanPhamMua> cart = CreateCart();
ddh.MaKH = kh.MaKH;
ddh.NgayDat = DateTime.Now;
ddh.TinhTrangThanhToan = false;
ddh.TinhTrangGiao = false;
data.DONDATHANGs.InsertOnSubmit(ddh);
data.SubmitChanges();
foreach (var item in cart)
{
CHITIETDONDATHANG ctdh = new CHITIETDONDATHANG();
ctdh.MaDatHang = ddh.MaDatHang;
ctdh.MaSanPham = item.iMaDH;
ctdh.SoLuong = item.iSoLuong;
ctdh.ThanhTien = item.iThanhTien;
data.CHITIETDONDATHANGs.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["Cart"] = null;
return(RedirectToAction("XacNhanDatHang", "Cart"));
}
public ActionResult DeleteConfirmed(int id)
{
CHITIETDONDATHANG cHITIETDONDATHANG = db.CHITIETDONDATHANGs.Find(id);
db.CHITIETDONDATHANGs.Remove(cHITIETDONDATHANG);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "IdSP,IdDDH,Soluong,Dongia")] CHITIETDONDATHANG cHITIETDONDATHANG)
{
if (ModelState.IsValid)
{
db.Entry(cHITIETDONDATHANG).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IdDDH = new SelectList(db.DonDatHangs, "IdDDH", "IdDDH", cHITIETDONDATHANG.IdDDH);
ViewBag.IdSP = new SelectList(db.SanPhams, "IdSP", "TenSP", cHITIETDONDATHANG.IdSP);
return(View(cHITIETDONDATHANG));
}
// GET: Admin/CHITIETDONDATHANGs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHITIETDONDATHANG cHITIETDONDATHANG = db.CHITIETDONDATHANGs.Find(id);
if (cHITIETDONDATHANG == null)
{
return(HttpNotFound());
}
return(View(cHITIETDONDATHANG));
}
// GET: Admin/CHITIETDONDATHANGs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHITIETDONDATHANG cHITIETDONDATHANG = db.CHITIETDONDATHANGs.Find(id);
if (cHITIETDONDATHANG == null)
{
return(HttpNotFound());
}
ViewBag.IdDDH = new SelectList(db.DonDatHangs, "IdDDH", "IdDDH", cHITIETDONDATHANG.IdDDH);
ViewBag.IdSP = new SelectList(db.SanPhams, "IdSP", "TenSP", cHITIETDONDATHANG.IdSP);
return(View(cHITIETDONDATHANG));
}
public int addCTDonHang(string ma, string maSach, int soluong, float dongia)
{
try
{
CHITIETDONDATHANG ct = new CHITIETDONDATHANG();
ct.MADDH = ma;
ct.MASACH = maSach;
ct.SOLUONGNHAP = soluong;
ct.DONGIANHAP = dongia;
ct.GHICHU = "0";
linq.CHITIETDONDATHANGs.InsertOnSubmit(ct);
linq.SubmitChanges();
return(1);
}
catch
{
return(0);
}
}
public int nhapSach(string maDDH, string maSach)
{
try
{
CHITIETDONDATHANG ct = linq.CHITIETDONDATHANGs.Where(t => t.MADDH == maDDH && t.MASACH == maSach).Select(t => t).FirstOrDefault();
int soluong = ct.SOLUONGNHAP.Value;
ct.GHICHU = "1";
SACH sach = linq.SACHES.Where(t => t.MASACH == ct.MASACH).Select(t => t).FirstOrDefault();
sach.SOLUONG += soluong;
linq.SubmitChanges();
return(1);
}
catch
{
return(0);
}
}
public ActionResult DatHang(FormCollection collection)
{
DONDATHANG ddh = new DONDATHANG();
THANHVIEN kh = (THANHVIEN)Session["ThanhVien"];
List <CartItem> gh = (List <CartItem>)Session["ShoppingCart"];
ddh.MATHANHVIEN = kh.MATHANHVIEN;
var ngaydat = DateTime.Now;
ddh.NGAYDAT = DateTime.Now;
var ngaygiao = String.Format("{0:MM/dd/yyyy}", collection["Ngaygiao"]);
ddh.NGAYGIAO = DateTime.Parse(ngaygiao);
if (ddh.NGAYGIAO < DateTime.Now)
{
ViewData["Loi"] = "Ngày Giao hàng không đúng";
return(View());
}
else
{
ddh.TINHTRANGGIAO = 1;
ddh.DATHANHTOAN = 1;
db.DONDATHANGs.Add(ddh);
db.SaveChanges();
//Them chi tiet don hang
foreach (var item in gh)
{
CHITIETDONDATHANG ctdh = new CHITIETDONDATHANG();
ctdh.MADDH = ddh.MADDH;
ctdh.MASP = item.productOrder.MASP;
ctdh.SOLUONG = item.Quality;
ctdh.DONGIA = (long)item.productOrder.DONGIA;
db.CHITIETDONDATHANGs.Add(ctdh);
}
SendMail();
db.SaveChanges();
Session["ShoppingCart"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
}
public ActionResult DatHang()
{
if (Session["GioHang"] == null)
{
return(RedirectToAction("Index", "Home"));
}
THANHVIEN tv = Session["TaiKhoan"] as THANHVIEN;
if (tv == null)
{
return(RedirectToAction("XemGioHang"));
}
//Thêm đơn hàng
DONDATHANG ddh = new DONDATHANG();
ddh.NgayDat = DateTime.Now;
ddh.TinhTrangGiaoHang = "Đã đặt hàng";
ddh.TaiKhoanTV = tv.TaiKhoanTV;
ddh.DaGiao = false;
ddh.DaThanhToan = false;
db.DONDATHANGs.Add(ddh);
db.SaveChanges();
List <ItemGioHang> listGioHang = layGioHang();
foreach (var item in listGioHang)
{
CHITIETDONDATHANG ctdh = new CHITIETDONDATHANG();
ctdh.MaDDH = db.DONDATHANGs.Max(n => n.MaDDH);
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuong;
db.CHITIETDONDATHANGs.Add(ctdh);
db.SaveChanges();
}
listGioHang.Clear();
return(RedirectToAction("Index", "Home"));
}
