public ActionResult xoa(int id)
{
if (Session["Taikhoanadmin"] != null)
{
TRASUA ts = data.TRASUAs.SingleOrDefault(n => n.MaTS == id);
CHITIETDONTHANG ctdh = data.CHITIETDONTHANGs.Where(a => a.MaTS == ts.MaTS).Single();
ViewBag.MaTS = ts.MaTS;
if (ts == null)
{
Response.StatusCode = 404;
return(null);
}
if (ctdh != null)
{
ViewBag.ThongBao = "Không thể xoá sản phẩm này vì còn tồn tại ở chi tiết đặt hàng";
return(View());
}
else
{
data.TRASUAs.DeleteOnSubmit(ts);
data.SubmitChanges();
}
return(RedirectToAction("TraSua"));
}
else if (Session["Taikhoan"] != null)
{
return(RedirectToAction("Index", "TraSua"));
}
else
{
return(RedirectToAction("DangNhap", "NguoiDung"));
}
}
public ActionResult DatHang(FormCollection collection)
{
// Thêm đơn hàng
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["TaiKhoan"];
List <GioHang> gioHang = LayGioHang();
ddh.MaKH = kh.MaKH;
ddh.Ngaydat = DateTime.Now;
var ngaygiao = String.Format("{0:MM/dd/yyyy}", collection["NgayGiao"]);
ddh.Ngaygiao = DateTime.Parse(ngaygiao);
ddh.Tinhtranggiaohang = false;
ddh.Dathanhtoan = false;
data.DONDATHANGs.Add(ddh);
data.SaveChanges();
// Thêm chi tiết đơn hàng
foreach (var item in gioHang)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
ctdh.MaDonHang = ddh.MaDonHang;
ctdh.Masach = item.iMaSach;
ctdh.Soluong = item.iSoLuong;
ctdh.Dongia = (decimal)item.dDonGia;
data.CHITIETDONTHANGs.Add(ctdh);
}
data.SaveChanges();
Session["GioHang"] = null;
return(RedirectToAction("XacNhanDonHang", "GioHang"));
}
public ActionResult Dathang(FormCollection collection)
{
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["Taikhoan"];
ddh.MaKH = kh.MaKH;
ddh.Ngaydat = DateTime.Now;
ddh.Ngaygiao = DateTime.Now.AddHours(72);
ddh.Tinhtranggiaohang = false;
ddh.Dathanhtoan = false;
data.DONDATHANGs.InsertOnSubmit(ddh);
data.SubmitChanges();
List <Giohang> lstGiohang = Laygiohang();
foreach (var item in lstGiohang)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
ctdh.MaDH = ddh.MaDH;
ctdh.Maruou = item.iMaruou;
ctdh.Soluong = item.iSoluong;
ctdh.Dongia = (decimal)item.dDongia;
data.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
public ActionResult Order(FormCollection collection)
{
DONDATHANG ddh = new DONDATHANG();
NGUOIDUNG nd = (NGUOIDUNG)Session["NguoiDung"];
List <Cart> lstCart = GetTheCart();
ddh.MaND = nd.MaND;
ddh.NgayDat = DateTime.Now;
var NgayDD = String.Format("{0:dd/MM/yyyy}", DateTime.Now);
var NgayGiao = String.Format("{0:dd/MM/yyyy}", collection["NgayGiao"]);
if (DateTime.Compare(DateTime.Parse(NgayGiao), DateTime.Parse(NgayDD)) < 0)
{
ViewBag.Thongbao = "Wrong date time!!!";
return(View("Order"));
}
ddh.NgayGiao = DateTime.Parse(NgayGiao);
ddh.TinhTrangGiaoHang = false;
ddh.DaThanhToan = false;
db.DONDATHANGs.InsertOnSubmit(ddh);
db.SubmitChanges();
foreach (var item in lstCart)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
ctdh.MaDonHang = ddh.MaDonHang;
ctdh.MaNT = item.iMaNT;
ctdh.SoLuong = item.iSoLuong;
ctdh.DonGia = (decimal)item.dDonGia;
db.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
}
db.SubmitChanges();
Session["Cart"] = null;
return(RedirectToAction("ConfirmOrder", "Cart"));
}
public ActionResult Dathang(FormCollection collection)
{
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}", collection["Ngaygiao"]);
ddh.Ngaygiao = DateTime.Parse(ngaygiao);
ddh.Tinhtranggiaohang = false;
ddh.Dathanhtoan = false;
data.DONDATHANGs.InsertOnSubmit(ddh);
data.SubmitChanges();
foreach (var item in gh)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
ctdh.MaDonHang = ddh.MaDonHang;
ctdh.MaRuou = item.iMaRuou;
ctdh.Soluong = item.iSoluong;
ctdh.Dongia = (decimal)item.dGiaban;
data.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
public ActionResult Themmoichitietdonhang(CHITIETDONTHANG chitietdonhang)
{
ViewBag.MaDonHang = new SelectList(db.CHITIETDONTHANGs.ToList().OrderBy(n => n.Mabanh), "Mabanh", "MaDonHang");
db.CHITIETDONTHANGs.InsertOnSubmit(chitietdonhang);
db.SubmitChanges();
return(RedirectToAction("Chitietdonhang"));
}
public ActionResult DatHang(CHITIETDONTHANG id, FormCollection collection)
{
try
{
double iTongTien = 0;
List <Giohang> lstGiohang = Session["GioHang"] as List <Giohang>;
if (lstGiohang != null)
{
iTongTien = lstGiohang.Sum(n => n.dThanhtien);
}
//Them Don hang
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}", collection["NgayGiao"]);
ddh.Ngaygiao = DateTime.Parse(ngaygiao);
ddh.Tinhtranggiaohang = false;
ddh.Dathanhtoan = false;
data.DONDATHANGs.InsertOnSubmit(ddh);
data.SubmitChanges();
//Them chi tiet don hang
foreach (var item in gh)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
ctdh.MaDonHang = ddh.MaDonHang;
ctdh.MaNH = item.iMaNH;
ctdh.Soluong = item.iSoluong;
ctdh.Dongia = (decimal)item.dGiaBan;
data.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
}
////gửi mail----------------------------------------------------------------------------
string content = System.IO.File.ReadAllText(Server.MapPath("~/Mail/DonHang.html"));
content = content.Replace("{{CustomerName}}", kh.HoTen);
content = content.Replace("{{Phone}}", kh.DienthoaiKH);
content = content.Replace("{{Email}}", kh.Email);
content = content.Replace("{{Address}}", kh.DiachiKH);
content = content.Replace("{{NgayGiao}}", ngaygiao);
content = content.Replace("{{Total}}", iTongTien.ToString("N0"));
var toEmail = ConfigurationManager.AppSettings["ToEmailAddress"].ToString();
new MailHelper().SendMail(kh.Email, "Đơn hàng mới từ Tuấn-Phúc Hùng", content);
new MailHelper().SendMail(toEmail, "Đơn hàng mới từ Tuấn-Phúc Hùng", content);
//------------------------------------------------------------------------------------------
data.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
catch
{
Session["Giohang"] = null;
}
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
public ActionResult Xemchitietdonhang(int id)
{
CHITIETDONTHANG chitietdonhang = db.CHITIETDONTHANGs.SingleOrDefault(n => n.Mabanh == id);
ViewBag.Mamohinh = chitietdonhang.Mabanh;
if (chitietdonhang == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(chitietdonhang));
}
public ActionResult Chitietdonhang(int id)
{
//Lay ra doi tuong sach theo ma
CHITIETDONTHANG chitietdonhang = db.CHITIETDONTHANGs.SingleOrDefault(n => n.MaDonHang == id);
ViewBag.Madonhang = chitietdonhang.MaDonHang;
if (chitietdonhang == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(chitietdonhang));
}
public ActionResult Suachitietdonhang(CHITIETDONTHANG chitietdonhang)
{
//Dua du lieu vao Dropdownlist
ViewBag.MaDonHang = new SelectList(db.CHITIETDONTHANGs.ToList().OrderBy(n => n.Mabanh), "Mabanh", "MaDonHang");
CHITIETDONTHANG sa = db.CHITIETDONTHANGs.SingleOrDefault(n => n.MaDonHang == chitietdonhang.MaDonHang);
sa.Soluong = chitietdonhang.Soluong;
sa.Dongia = chitietdonhang.Dongia;
db.SubmitChanges();
return(RedirectToAction("Chitietdonhang"));
}
public ActionResult Xoadondathang2(int id)
{
CHITIETDONTHANG chitietdonhang = db.CHITIETDONTHANGs.SingleOrDefault(n => n.MaDonHang == id);
ViewBag.MaDonHang = chitietdonhang.MaDonHang;
if (chitietdonhang == null)
{
Response.StatusCode = 404;
return(null);
}
db.CHITIETDONTHANGs.DeleteOnSubmit(chitietdonhang);
db.SubmitChanges();
return(RedirectToAction("Chitietdonhang"));
}
public ActionResult Suachitietdonhang(int id)
{
CHITIETDONTHANG chitietdonhang = db.CHITIETDONTHANGs.SingleOrDefault(n => n.MaDonHang == id);
ViewBag.MaDonHang = chitietdonhang.MaDonHang;
if (chitietdonhang == null)
{
Response.StatusCode = 404;
return(null);
}
//Dua du lieu vao Dropdownlist
ViewBag.MaDonHang = new SelectList(db.CHITIETDONTHANGs.ToList().OrderBy(n => n.Mabanh), "Mabanh", "MaDonHang", chitietdonhang.MaDonHang);
return(View(chitietdonhang));
}
public int ThemGioHang(string khoahoc)
{
if (Session[SesHocVien] == null)
{
return -4;
}
HOCVIEN hocvien = (HOCVIEN)Session[SesHocVien];
int makhoahoc;
if (!int.TryParse(khoahoc, out makhoahoc))
{
return -3;
}
KHOAHOC khoaHoc = db.KHOAHOCs.SingleOrDefault(n => n.MaKH == makhoahoc);
if (khoaHoc == null)
{
return -3;
}
CHITIETDONTHANG chitiet = db.CHITIETDONTHANGs.SingleOrDefault(n => n.DONDATHANG.HOCVIEN.MaHV == hocvien.MaHV &&
n.KHOAHOC.MaKH == makhoahoc);
if (chitiet != null)
{
return -2;
}
if (Session["GioHang"] == null)
{
Session["GioHang"] = new List<KHOAHOC>();
}
List<KHOAHOC> giohang = (List<KHOAHOC>)Session["GioHang"];
if (giohang.SingleOrDefault(n => n.MaKH == makhoahoc) != null)
{
return -1;
}
giohang.Add(khoaHoc);
return giohang.Count;
}
public ActionResult datHang(FormCollection collection)
{
DONDATHANG ddh = new DONDATHANG();
List <Giohang> gh = getGioHang();
var hoten = collection["name"];
var diachi = collection["address"];
var sdt = collection["phone"];
var ghichu = collection["comment"];
if (String.IsNullOrEmpty(hoten))
{
ViewData["Loi1"] = "Họ tên khách hàng không được để trống";
}
else if (String.IsNullOrEmpty(diachi))
{
ViewData["Loi2"] = "Địa chỉ không được để trống";
}
else if (String.IsNullOrEmpty(sdt))
{
ViewData["Loi3"] = "Số điện thoại không được để trống";
}
else
{
ddh.HoTen = hoten;
ddh.DiachiKH = diachi;
ddh.DienthoaiKH = sdt;
ddh.GhiChu = ghichu;
ddh.Tinhtranggiaohang = false;
ddh.Dathanhtoan = false;
data.DONDATHANGs.InsertOnSubmit(ddh);
data.SubmitChanges();
foreach (var item in gh)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
ctdh.MaDonHang = ddh.MaDonHang;
ctdh.Masp = item.iMasp;
ctdh.Soluong = item.iSoluong;
ctdh.Dongia = (decimal)item.dDongia;
data.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("xacNhanDonHang", "GioHang"));
}
return(this.datHang());
}
public ActionResult DatHang(FormCollection collection)
{
var ngaygiao = collection["Ngaygiao"];
if (String.IsNullOrEmpty(ngaygiao))
{
ViewData["Loi9"] = "Phải nhập ngày giao";
ViewBag.Tongsoluong = TongSoLuong();
ViewBag.Tongtien = TongTien();
return(View(Laygiohang()));
}
KHACHHANG kh = (KHACHHANG)Session["Taikhoan"];
DONDATHANG ddh = new DONDATHANG();
ddh.MaKH = kh.MaKH;
ddh.Ngaydat = DateTime.Now;
if (ngaygiao != string.Empty)
{
ddh.Ngaygiao = DateTime.Parse(ngaygiao);
}
ddh.Tinhtranggiaohang = false;
ddh.Dathanhtoan = false;
data.DONDATHANGs.InsertOnSubmit(ddh);
data.SubmitChanges();
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
foreach (var item in Laygiohang())
{
ctdh.MaDonHang = ddh.MaDonHang;
ctdh.Masach = item.iMasach;
ctdh.Soluong = item.iSoluong;
ctdh.Dongia = (decimal)item.dDonggia;
data.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
public ActionResult ThongKhoaHoc(int khoahoc)
{
KHOAHOC khoaHoc = db.KHOAHOCs.SingleOrDefault(n => n.MaKH == khoahoc);
ViewBag.MuaHang = false;
if (khoaHoc == null)
{
return(View());
}
if (Session[SesHocVien] == null)
{
return(View(khoaHoc));
}
HOCVIEN hocvien = (HOCVIEN)Session[SesHocVien];
if (hocvien != null)
{
CHITIETDONTHANG chitiet = db.CHITIETDONTHANGs.SingleOrDefault(n => n.DONDATHANG.HOCVIEN.MaHV == hocvien.MaHV &&
n.KHOAHOC.MaKH == khoaHoc.MaKH);
if (chitiet != null)
{
ViewBag.MuaHang = true;
}
}
var baigiangs = khoaHoc.BaiGiangs;
if (baigiangs.Count != 0)
{
ViewBag.BaiGiangs = baigiangs.ToList();
}
return(View(khoaHoc));
}
public ActionResult DatHang(FormCollection collection)
{
TempData["Tongsoluong"] = TongSoLuong();
TempData["Tongtien"] = TongTien();
//Them Don hang
DONDATHANG ddh = new DONDATHANG();
KHACHHANG kh = (KHACHHANG)Session["Taikhoan"];
List <Giohang> gh = Laygiohang();
ddh.MaKH = kh.MaKH;
ddh.Ngaydat = DateTime.Now;
var ngaygiao = "";
ngaygiao = String.Format("{0:MM/dd/yyyy}", collection["Ngaygiao"]);
if (ngaygiao == "")
{
ngaygiao = DateTime.Now.AddDays(+1).ToString();
}
ddh.Ngaygiao = DateTime.Parse(ngaygiao);
ddh.Tinhtranggiaohang = false;
ddh.Dathanhtoan = false;
data.DONDATHANGs.InsertOnSubmit(ddh);
data.SubmitChanges();
//Them chi tiet don hang
foreach (var item in gh)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
ctdh.MaDonHang = ddh.MaDonHang;
ctdh.MaSP = item.iMaSP;
ctdh.Soluong = item.iSoluong;
ctdh.Dongia = (decimal)item.dDongia;
data.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
public ActionResult XacNhanDonHang(FormCollection f)
{
if (f["CMND"].Length != 9 && f["CMND"].Length != 12)
{
ViewData["L1"] = "Vui lòng nhập đúng CMND";
return(View());
}
List <GIOHANG> gh = LayGioHang();
DONDATHANG donhang = new DONDATHANG();
donhang.CMND = f["CMND"];
donhang.Ngaydat = DateTime.Now;
donhang.Ngaygiao = DateTime.Parse(f["NgayGiao"]);
donhang.DiaChiLienHe = f["DCGiaoHang"];
donhang.EmailLienHe = f["Email"];
donhang.SDTLienHe = f["SDT"];
donhang.Tinhtranggiaohang = false;
donhang.TongTien = TongTien();
donhang.Dathanhtoan = false;
donhang.TrangThai = true;
db.DONDATHANGs.InsertOnSubmit(donhang);
db.SubmitChanges();
string mathanhtoantructuyen = DateTime.Now.Ticks.ToString();
if (string.Compare(f["rbHinhThucThanhToan"], "Onepay") == 0)
{
string SECURE_SECRET = OnepayCode.SECURE_SECRET;// HAO : CAN THANH MA THAT TRONG APP CODE
//// KHOI TAO LOP THU VIEN VA GAN GIA TRI CAC THAM SO
VPCRequest conn = new VPCRequest(OnepayCode.VPCRequest);
conn.SetSecureSecret(SECURE_SECRET);
//add digital order field
conn.AddDigitalOrderField("Title", "onepay paygate");
conn.AddDigitalOrderField("vpc_Locale", "vn");
conn.AddDigitalOrderField("vpc_Version", "2");
conn.AddDigitalOrderField("vpc_Command", "pay");
conn.AddDigitalOrderField("vpc_Merchant", OnepayCode.Merchant);
conn.AddDigitalOrderField("vpc_AccessCode", OnepayCode.AccessCode);
conn.AddDigitalOrderField("vpc_MerchTxnRef", mathanhtoantructuyen);
conn.AddDigitalOrderField("vpc_OrderInfo", mathanhtoantructuyen);
conn.AddDigitalOrderField("vpc_Amount", (TongTien() * 100).ToString());
conn.AddDigitalOrderField("vpc_Currency", "VND");
conn.AddDigitalOrderField("vpc_ReturnURL", OnepayCode.ReturnURL);
conn.AddDigitalOrderField("vpc_SHIP_Street01", "");
conn.AddDigitalOrderField("vpc_SHIP_Provice", "");
conn.AddDigitalOrderField("vpc_SHIP_City", "");
conn.AddDigitalOrderField("vpc_SHIP_Country", "");
conn.AddDigitalOrderField("vpc_Customer_Phone", "");
conn.AddDigitalOrderField("vpc_Customer_Email", "");
conn.AddDigitalOrderField("vpc_Customer_Id", "");
conn.AddDigitalOrderField("vpc_TicketNo", Request.UserHostAddress);
string ketQua = "";
string url = conn.Create3PartyQueryString();
ketQua = url;
foreach (var item in gh)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
DONGHO dh = db.DONGHOs.SingleOrDefault(m => m.MaSP == item.iMaSP);
ctdh.MaDonHang = donhang.MaDonHang;
ctdh.MaSP = item.iMaSP;
ctdh.Soluong = item.iSoLuong;
ctdh.ThanhTien = item.fThanhTien;
ctdh.Dongia = item.fDonGia;
db.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
dh.Soluongton = dh.Soluongton - item.iSoLuong;
UpdateModel(dh);
}
Session["GIOHANG"] = null;
db.SubmitChanges();
ViewBag.Ma = donhang.MaDonHang;
return(Redirect(ketQua));
}
else
{
foreach (var item in gh)
{
CHITIETDONTHANG ctdh = new CHITIETDONTHANG();
DONGHO dh = db.DONGHOs.SingleOrDefault(m => m.MaSP == item.iMaSP);
ctdh.MaDonHang = donhang.MaDonHang;
ctdh.MaSP = item.iMaSP;
ctdh.Soluong = item.iSoLuong;
ctdh.ThanhTien = item.fThanhTien;
ctdh.Dongia = item.fDonGia;
db.CHITIETDONTHANGs.InsertOnSubmit(ctdh);
dh.Soluongton = dh.Soluongton - item.iSoLuong;
UpdateModel(dh);
}
Session["GIOHANG"] = null;
db.SubmitChanges();
return(View());
}
}
