public void XoaCTDH(string madh, string madv)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh = qltg.CTDONHANGs.Where(t => t.MaDH == madh && t.MaDV == madv).FirstOrDefault();
qltg.CTDONHANGs.DeleteOnSubmit(ctdh);
qltg.SubmitChanges();
}
public void SuaCTDH(int sl, string madh, string madv, float thanhtien)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh = qltg.CTDONHANGs.Where(t => t.MaDH == madh && t.MaDV == madv).FirstOrDefault();
ctdh.SoLuong = sl;
ctdh.ThanhTien = thanhtien;
qltg.SubmitChanges();
}
public void themchitietdonhang(int soluong, string mahd, string madv, float thanhtien)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoLuong = soluong;
ctdh.MaDH = mahd;
ctdh.MaDV = madv;
ctdh.ThanhTien = thanhtien;
qltg.CTDONHANGs.InsertOnSubmit(ctdh);
qltg.SubmitChanges();
}
public int Delete(CTDONHANG model)
{
CTDONHANG dbEntry = context.CTDONHANGs.Find(model.ID_CTDH);
if (dbEntry == null)
{
return(0);
}
context.CTDONHANGs.Remove(dbEntry);
context.SaveChanges();
return(1);
}
public ActionResult Delete(CTDONHANG pr)
{
CTDONHANG cTDONHANG = new CTDONHANG();
cTDONHANG = db.CTDONHANGs.Find(pr.IDDONHANG);
if (cTDONHANG != null)
{
db.CTDONHANGs.Remove(pr);
db.SaveChanges();
}
return(RedirectToAction("List"));
}
public int Insert(CTDONHANG model)
{
CTDONHANG dbEntry = context.CTDONHANGs.Find(model.ID_CTDH);
if (dbEntry != null)
{
return(0);
}
context.CTDONHANGs.Add(model);
context.SaveChanges();
return(1);
}
public ActionResult Edit(CTDONHANG pr)
{
CTDONHANG cTDONHANG = new CTDONHANG();
cTDONHANG = db.CTDONHANGs.Find(pr.IDDONHANG);
if (cTDONHANG != null)
{
cTDONHANG.IDMAY = pr.IDMAY;
cTDONHANG.DONGIA = pr.DONGIA;
cTDONHANG.SOLUONG = pr.SOLUONG;
}
return(RedirectToAction("List"));
}
public ActionResult Edit(int id, CTDONHANG model)
{
try
{
model.ID_CTDH = id;
var result = new CTDONHANGFunction.CTDonHangFunction().Update(model);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult InsertData()
{
string name = Request.Form["billing_last_name"];
string street = Request.Form["billing_address_1"];
string apartment = Request.Form["billing_address_2"];
string city = Request.Form["billing_city"];
string email = Request.Form["billing_email"];
int phone = Int32.Parse(Request.Form["billing_phone"]);
ShoppingCart cart = (ShoppingCart)Session["cart"];
List <Item> lst = new List <Item>();
if (cart != null)
{
lst = cart.lst;
if (db.KHACHHANGs.Where(q => q.TENKH == name && q.SDT == phone && q.EMAIL == email).FirstOrDefault() == null)
{
KHACHHANG khachhang = new KHACHHANG();
khachhang.TENKH = name;
khachhang.DIACHI = street + " - " + apartment + " - " + city;
khachhang.EMAIL = email;
khachhang.SDT = phone;
db.KHACHHANGs.Add(khachhang);
db.SaveChanges();
}
DONHANG donHang = new DONHANG();
var x = db.KHACHHANGs.Where(q => q.TENKH == name && q.SDT == phone && q.EMAIL == email).FirstOrDefault();
donHang.IDKH = x.IDKH;
donHang.NGAYLAP = DateTime.Today;
donHang.TRANGTHAI = "chưa được xử lý";
db.DONHANGs.Add(donHang);
db.SaveChanges();
// var y = db.DonHangs.Where(q => q.IDKH == x.IDKH && q.NgayLap == DateTime.Today && q.TrangThai == "Chua du?c x? lý").FirstOrDefault();
foreach (var item in lst)
{
CTDONHANG cTDonHang = new CTDONHANG();
cTDonHang.IDDONHANG = donHang.IDDONHANG;
cTDonHang.IDMAY = item.id;
cTDonHang.SOLUONG = item.amount;
cTDonHang.DONGIA = (int)item.price;
db.CTDONHANGs.Add(cTDonHang);
db.SaveChanges();
}
cart.lst = null;
}
return(RedirectToAction("Index"));
}
public int Update(CTDONHANG model)
{
CTDONHANG dbEntry = context.CTDONHANGs.Find(model.ID_CTDH);
if (dbEntry == null)
{
return(0);
}
dbEntry.ID_DH = model.ID_DH;
dbEntry.ID_SP = model.ID_SP;
dbEntry.soluong = model.soluong;
dbEntry.dongia = model.dongia;
context.SaveChanges();
return(1);
}
public ActionResult ThanhToan([Bind(Include = "MADH,TENKH,DIACHI,DIENTHOAI,EMAIL,TRANGTHAI,NGAYTAO,GHICHU")] DONHANG donhang, string tenkh, string diachi, string sdt, string email, string ghichu, bool trangthai)
{
donhang.TENKH = tenkh;
donhang.DIACHI = diachi;
donhang.DIENTHOAI = sdt;
donhang.EMAIL = email;
donhang.TRANGTHAI = trangthai;
donhang.NGAYTAO = DateTime.Now;
donhang.GHICHU = ghichu;
var cart = (Cart)Session[CartSession];
decimal tong = 0;
try
{
if (cart != null)
{
if (ModelState.IsValid)
{
db.DONHANGs.Add(donhang);
db.SaveChanges();
var ID = (from x in db.DONHANGs orderby x.MADH descending select x.MADH).Take(1).Single();
foreach (var item in cart.Lines)
{
var CTDonHang = new CTDONHANG();
CTDonHang.MASP = item.SANPHAM.MASP;
CTDonHang.MADH = ID;
CTDonHang.GIA = item.SANPHAM.GIA - item.SANPHAM.GIAMGIA * item.SANPHAM.GIA / 100;
CTDonHang.SL = item.Quantity;
db.CTDONHANGs.Add(CTDonHang);
tong += (item.SANPHAM.GIA - item.SANPHAM.GIAMGIA * item.SANPHAM.GIA / 100).GetValueOrDefault(0) * item.Quantity;
db.SaveChanges();
}
}
}
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
var fullErrorMessages = string.Join(";", errorMessages);
var exceptionMessages = string.Concat(ex.Message, "The validation errors are: ", fullErrorMessages);
throw new DbEntityValidationException(exceptionMessages, ex.EntityValidationErrors);
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Edit(int id)
{
if (Session["us"] == null)
{
return(RedirectToAction("Login", "MayAnh"));
}
else
{
CTDONHANG pr = new CTDONHANG();
pr = db.CTDONHANGs.Find(id);
List <DONHANG> cateDonHang = db.DONHANGs.ToList();
SelectList cateListDonHang = new SelectList(cateDonHang, "IDDONHANG", "IDDONHANG");
ViewBag.IDDONHANG = cateListDonHang;
List <MAYANH> cate = db.MAYANHs.ToList();
SelectList cateList = new SelectList(cate, "IDMAY", "TENMAY");
ViewBag.IDMAY = cateList;
return(View(pr));
}
}
public ActionResult DatHang()
{
//Kiểm tra đăng đăng nhập
if (Session["TaiKhoan"] == null || Session["TaiKhoan"].ToString() == "")
{
return(RedirectToAction("DangNhap", "User"));
}
//Kiểm tra giỏ hàng
if (Session["GioHang"] == null)
{
RedirectToAction("Index", "NongSan");
}
//Thêm đơn hàng
DONHANG dh = new DONHANG();
KHACHHANG kh = (KHACHHANG)Session["TaiKhoan"];
List <GioHang> gh = LayGioHang();
dh.MaKhachHang = kh.MaKhachHang;
dh.NgayDat = DateTime.Now;
db.DONHANGs.Add(dh);
db.SaveChanges();
//Thêm chi tiết đơn hàng
foreach (var item in gh)
{
CTDONHANG ctDH = new CTDONHANG();
//NONGSAN ns = new NONGSAN();
ctDH.MaHoaDon = dh.MaHoaDon;
ctDH.MaNongSan = item.idMaQua;
ctDH.SoLuong = item.iSoLuong;
ctDH.DonGia = (int)item.iDonGia;
db.CTDONHANGs.Add(ctDH);
//db.NONGSANs.Add(ns);
}
db.SaveChanges();
return(RedirectToAction("Index", "NongSan"));
}
public ActionResult ThanhToan([Bind(Include = "MADH,TENKH,DIACHI,DIENTHOAI,EMAIL,TRANGTHAI,NGAYTAO,GHICHU")]
DONHANG donhang, string tenkh, string diachi, string sdt, string email, string ghichu, string trangthai)
{
donhang.TENKH = tenkh;
donhang.DIACHI = diachi;
donhang.DIENTHOAI = sdt;
donhang.EMAIL = email;
donhang.NGAYTAO = DateTime.Now;
donhang.GHICHU = ghichu;
if (trangthai == "0")
{
donhang.TRANGTHAI = false;
}
else
{
donhang.TRANGTHAI = true;
}
var cart = (Cart)Session[CartSession];
decimal tong = 0;
try
{
if (cart != null)
{
db.DONHANGs.Add(donhang);
db.SaveChanges();
var ID = (from x in db.DONHANGs orderby x.MADH descending select x.MADH).Take(1).Single();
foreach (var item in cart.Lines)
{
var CTDonHang = new CTDONHANG();
CTDonHang.MASP = item.SANPHAM.MASP;
CTDonHang.MADH = ID;
CTDonHang.GIA = item.SANPHAM.GIA - item.SANPHAM.GIAMGIA * item.SANPHAM.GIA / 100;
CTDonHang.SL = item.Quantity;
db.CTDONHANGs.Add(CTDonHang);
tong += (item.SANPHAM.GIA - item.SANPHAM.GIAMGIA * item.SANPHAM.GIA / 100).GetValueOrDefault(0) * item.Quantity;
SANPHAM sp = db.SANPHAMs.SingleOrDefault(n => n.MASP == CTDonHang.MASP);
int sl1 = (int)sp.SOLUONG;
int sl2 = item.Quantity;
int conlai = sl1 - sl2;
sp.SOLUONG = conlai;
db.Entry(sp).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
var fullErrorMessages = string.Join(";", errorMessages);
var exceptionMessages = string.Concat(ex.Message, "The validation errors are: ", fullErrorMessages);
throw new DbEntityValidationException(exceptionMessages, ex.EntityValidationErrors);
}
cart = null;
Session[CartSession] = cart;
return(RedirectToAction("ThanhCong"));
}
public ActionResult Create(CTDONHANG pr)
{
db.CTDONHANGs.Add(pr);
db.SaveChanges();
return(RedirectToAction("List"));
}
public ActionResult GioHang(FormCollection frm, DONDATHANG donhang)
{
int x = 0;
string danggiao = "Đang giao";
if (Session["Email"] == null && Session["username"] == null)
{
return(RedirectToAction("LoginSSO", "Account"));
}
else
{
if (Session["username"] != null)
{
x = int.Parse(Session["makh"].ToString());
}
else
{
x = int.Parse(Session["MaKH"].ToString());
}
var user = db.KHACHHANGs.FirstOrDefault(n => n.MaKH == x);
if (user.DiaChiKH == null || user.DienThoaiKH == null)
{
user = db.KHACHHANGs.Find(x);
{
user.DienThoaiKH = frm["dienthoainhanhang"];
user.DiaChiKH = frm["diachinhanhang"];
};
if (Session["username"] != null)
{
db.Entry(user);
donhang.MaKH = int.Parse(Session["makh"].ToString());
donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString());
donhang.TriGia = decimal.Parse(Session["TongTien"].ToString());
donhang.TrangThai = danggiao;
donhang.TenNguoiNhan = frm["tennguoinhan"];
donhang.DienThoaiNhan = frm["dienthoainhanhang"];
donhang.DiaChiNhan = frm["diachinhanhang"];
donhang.EmailNhanHang = frm["email"];
db.DONDATHANGs.Add(donhang);
db.SaveChanges();
List <SanPhamGH> listSP = LayGioHang();
foreach (var item in listSP)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoDH = donhang.SoDH;
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuongMua;
ctdh.DonGia = (decimal)item.DonGia;
db.CTDONHANGs.Add(ctdh);
SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP);
sp.SoLuong--;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
foreach (var item in listSP)
{
SANPHAM sp = db.SANPHAMs.Find(item.MaSP);
if (sp.YeuThich == null)
{
sp.YeuThich = 1;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
else
{
sp.YeuThich += item.SoLuongMua;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
}
Session["GioHang"] = null;
return(RedirectToAction("ThanhToanThanhCong", "GioHang"));
}
else
{
db.Entry(user);
donhang.MaKH = int.Parse(Session["MaKH"].ToString());
donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString());
donhang.TriGia = decimal.Parse(Session["TongTien"].ToString());
donhang.TrangThai = danggiao;
donhang.TenNguoiNhan = frm["tennguoinhan"];
donhang.DienThoaiNhan = frm["dienthoainhanhang"];
donhang.DiaChiNhan = frm["diachinhanhang"];
donhang.EmailNhanHang = frm["email"];
db.DONDATHANGs.Add(donhang);
db.SaveChanges();
List <SanPhamGH> listSP = LayGioHang();
foreach (var item in listSP)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoDH = donhang.SoDH;
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuongMua;
ctdh.DonGia = (decimal)item.DonGia;
db.CTDONHANGs.Add(ctdh);
SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP);
sp.SoLuong--;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
foreach (var item in listSP)
{
SANPHAM sp = db.SANPHAMs.Find(item.MaSP);
if (sp.YeuThich == null)
{
sp.YeuThich = 1;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
else
{
sp.YeuThich += item.SoLuongMua;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
}
Session["GioHang"] = null;
return(RedirectToAction("ThanhToanThanhCong", "GioHang"));
}
}
else
{
if (Session["username"] != null)
{
donhang.MaKH = int.Parse(Session["makh"].ToString());
donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString());
donhang.TriGia = decimal.Parse(Session["TongTien"].ToString());
donhang.TrangThai = danggiao;
donhang.TenNguoiNhan = frm["tennguoinhan"];
donhang.DienThoaiNhan = frm["dienthoainhanhang"];
donhang.DiaChiNhan = frm["diachinhanhang"];
donhang.EmailNhanHang = frm["email"];
db.DONDATHANGs.Add(donhang);
db.SaveChanges();
List <SanPhamGH> listSP = LayGioHang();
foreach (var item in listSP)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoDH = donhang.SoDH;
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuongMua;
ctdh.DonGia = (decimal)item.DonGia;
db.CTDONHANGs.Add(ctdh);
SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP);
sp.SoLuong--;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
foreach (var item in listSP)
{
SANPHAM sp = db.SANPHAMs.Find(item.MaSP);
if (sp.YeuThich == null)
{
sp.YeuThich = 1;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
else
{
sp.YeuThich += item.SoLuongMua;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
}
Session["Madh"] = donhang.SoDH;
return(RedirectToAction("ThanhToanThanhCong", "GioHang"));
}
else
{
donhang.MaKH = int.Parse(Session["MaKH"].ToString());
donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString());
donhang.TriGia = decimal.Parse(Session["TongTien"].ToString());
donhang.TrangThai = danggiao;
donhang.TenNguoiNhan = frm["tennguoinhan"];
donhang.DienThoaiNhan = frm["dienthoainhanhang"];
donhang.DiaChiNhan = frm["diachinhanhang"];
donhang.EmailNhanHang = frm["email"];
db.DONDATHANGs.Add(donhang);
db.SaveChanges();
List <SanPhamGH> listSP = LayGioHang();
foreach (var item in listSP)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoDH = donhang.SoDH;
ctdh.MaSP = item.MaSP;
ctdh.SoLuong = item.SoLuongMua;
ctdh.DonGia = (decimal)item.DonGia;
db.CTDONHANGs.Add(ctdh);
SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP);
sp.SoLuong--;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
foreach (var item in listSP)
{
SANPHAM sp = db.SANPHAMs.Find(item.MaSP);
if (sp.YeuThich == null)
{
sp.YeuThich = 1;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
else
{
sp.YeuThich += item.SoLuongMua;
db.Entry(sp).State = EntityState.Modified;
db.SaveChanges();
}
}
Session["Madh"] = donhang.SoDH;
return(RedirectToAction("ThanhToanThanhCong", "GioHang"));
}
}
}
}
public ActionResult GioHang(FormCollection frm, DONDATHANG donhang)
{
if (Session["makh"] == null)
{
return(RedirectToAction("Index", "SSO"));
}
else
{
int x = int.Parse(Session["makh"].ToString());
var user = db.Users.FirstOrDefault(n => n.MaKH == x);
if (user.DiaChi == null || user.DienThoaiKH == null)
{
user = db.Users.Find(x);
{
user.DienThoaiKH = frm["dienthoainhanhang"];
user.DiaChi = frm["diachinhanhang"];
};
db.Entry(user);
bool am = false;
donhang.MaKH = int.Parse(Session["makh"].ToString());
donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString());
//donhang.NgayGiaoHang = DateTime.Parse(frm["ngaynhanhang"].ToString());
donhang.TriGia = decimal.Parse(Session["TongTien"].ToString());
donhang.TrangThai = am;
donhang.TenNguoiNhan = frm["tennguoinhan"];
donhang.DienThoaiNhan = int.Parse(frm["dienthoainhanhang"]);
donhang.DiaChiNhan = frm["diachinhanhang"];
db.DONDATHANGs.Add(donhang);
db.SaveChanges();
List <SamPhamGH> listSP = LayGioHang();
foreach (var item in listSP)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoDH = donhang.SoHD;
ctdh.MaSP = item.BookId;
ctdh.SoLuong = item.SoLuongMua;
ctdh.DonGia = (decimal)item.Price;
db.CTDONHANGs.Add(ctdh);
db.SaveChanges();
}
Session["GioHang"] = null;
return(RedirectToAction("ThanhToanThanhCong", "GioHang"));
}
else
{
bool a = false;
donhang.MaKH = int.Parse(Session["makh"].ToString());
donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString());
//donhang.NgayGiaoHang = DateTime.Parse(frm["ngaynhanhang"].ToString());
donhang.TriGia = decimal.Parse(Session["TongTien"].ToString());
donhang.TrangThai = a;
donhang.TenNguoiNhan = frm["tennguoinhan"];
donhang.DienThoaiNhan = int.Parse(frm["dienthoainhanhang"]);
donhang.DiaChiNhan = frm["diachinhanhang"];
db.DONDATHANGs.Add(donhang);
db.SaveChanges();
List <SamPhamGH> listSP = LayGioHang();
foreach (var item in listSP)
{
CTDONHANG ctdh = new CTDONHANG();
ctdh.SoDH = donhang.SoHD;
ctdh.MaSP = item.BookId;
ctdh.SoLuong = item.SoLuongMua;
ctdh.DonGia = (decimal)item.Price;
db.CTDONHANGs.Add(ctdh);
db.SaveChanges();
}
Session["Madh"] = donhang.SoHD;
return(RedirectToAction("ThanhToanThanhCong", "GioHang"));
}
}
}
public CTDONHANG FindEntity(int ID_CTDH)
{
CTDONHANG dbEntry = context.CTDONHANGs.Find(ID_CTDH);
return(dbEntry);
}
public ActionResult Payment(string name, string mobileadd, string diachiadd, string dateout)
{
// A
var order = new DONHANG();
order.ngaylap = DateTime.Now;
order.hotenkh = name;
order.diachigiaohang = diachiadd;
order.phone = mobileadd;
DateTime?date = null;
DateTime temp;
if (DateTime.TryParse(dateout, out temp))
{
if (temp != null)
{
date = temp;
}
}
if (date != null)
{
order.ngaynhanhang = date.Value;
}
// B
//nếu login
if (SessionPersister.UserName != null)
{
order.ngaynhanhang = DateTime.Now;
order.ID_TK = SessionPersister.UserName.ID_TK;
var account = new TAIKHOANFunction.TaiKhoanFunction().FindEntity(order.ID_TK.Value);
order.hotenkh = account.tentk;
order.diachigiaohang = account.diachi;
order.phone = account.phone;
}
try
{
var id = new DONHANGFunction.DonHangFunction().Insert(order);
var cart = (Cart)Session["CartSession"];
var detailDao = new CTDONHANGFunction.CTDonHangFunction();
foreach (var item in cart.Lines)
{
var orderDetail = new CTDONHANG();
orderDetail.ID_SP = item.Sanpham.ID_SP;
orderDetail.ID_DH = id;
orderDetail.soluong = item.Quantity;
orderDetail.dongia = (item.Sanpham.giabd * item.Quantity);
detailDao.Insert(orderDetail);
}
Session["CartSession"] = null;
}
catch (Exception ex)
{
//ghi log
return(RedirectToAction("Loi")); // action Loi ở đâu?
}
return(RedirectToAction("MuaHangThanhCong", "Cart"));
}
