public bool create_hoa_don(donhangkemct donhang)
{
try
{
int s = 0;
for (int i = 0; i < donhang.ctdhs.Count(); i++)
{
s = donhang.ctdhs[i].soluong * donhang.ctdhs[i].gia;
}
donhang.dh.tinhtrang = 0;
donhang.dh.tongtien = s;
if (this.create(donhang.dh))
{
List <donhang> ds = _context.donhangs.ToList();
int id = ds[ds.Count() - 1].id;
for (int i = 0; i < donhang.ctdhs.Count(); i++)
{
chitietdonhang ct = new chitietdonhang();
ct.iddh = ct.iddh;
ct.idmon = ct.idmon;
ct.soluong = ct.soluong;
ct.gia = ct.gia;
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public List <chitietdonhang> getChitietdonhang(int madh)
{
List <chitietdonhang> chitietdonhangs = new List <chitietdonhang>();
var truyvan = (from dh in db.donhangs join
ct in db.ctdhs on dh.madh equals ct.madh join
sp in db.sanphams on ct.masp equals sp.masp
where dh.madh == madh
select new
{
sp.tensp,
sp.hinhanh,
ct.soluong,
ct.gia,
dh.ngaydat,
dh.tongtien,
dh.tttt,
dh.httt
});
foreach (var dulieu in truyvan)
{
chitietdonhang ct = new chitietdonhang();
ct.tensp = dulieu.tensp;
ct.hinhanh = dulieu.hinhanh;
ct.soluong = dulieu.soluong;
ct.dongia = dulieu.gia;
ct.thanhtien = (double)dulieu.tongtien;
ct.tttt = dulieu.tttt;
ct.ngaydat = dulieu.ngaydat.ToString();
ct.httt = dulieu.httt;
chitietdonhangs.Add(ct);
}
return(chitietdonhangs);
}
public ActionResult ThanhToan(FormCollection formCollection, dondathang dondathang)
{
var noigiao = formCollection["Item1.diachikh"];
List <GioHang> gh = LayGioHang();
dondathang.ngaydat = DateTime.Now;
dondathang.noigiao = noigiao;
dondathang.makh = int.Parse(Session["makh"].ToString());
dondathang.thanhtien = (decimal)TongTien();
dondathang.dathanhtoan = "no";
dondathang.tinhtranggiaohang = false;
db.dondathangs.InsertOnSubmit(dondathang);
db.SubmitChanges();
foreach (var item in gh)
{
chitietdonhang chitietdonhang = new chitietdonhang();
chitietdonhang.madh = dondathang.madh;
chitietdonhang.masp = item.sMaSP;
chitietdonhang.soluong = item.iSoLuong;
chitietdonhang.dongia = item.iDonGia;
db.chitietdonhangs.InsertOnSubmit(chitietdonhang);
}
db.SubmitChanges();
Session["GioHang"] = null;
return(RedirectToAction("XacNhanDonHang", "GioHang"));
}
public ActionResult TienHanhDatHang(string tenKH, string diachi, string sodienthoai, string ghichu)
{
try
{
List <SanPhamGioHang> listSPGH = Session["GioHang"] as List <SanPhamGioHang>;;
if (listSPGH == null)
{
return(RedirectToAction("Purchase", "Cart"));
}
else
{
banhang objBanhang = new banhang();
int tongtien = 0;
if (listSPGH != null)
{
foreach (var item in listSPGH)
{
int thanhtien = item.gia * item.soluong;
tongtien = tongtien + thanhtien;
}
}
objBanhang.tongtien = tongtien;
objBanhang.tenKH = tenKH;
objBanhang.diachiKH = diachi;
objBanhang.dienthoaiKH = sodienthoai;
objBanhang.ghichu = ghichu;
objBanhang.ngaydathang = DateTime.Now;
objBanhang.ngaycapnhat = DateTime.Now;
objBanhang.trangthaidonhang = Convert.ToInt32(TrangThaiDonHang.DonHangmoi);
try
{
db.banhangs.Add(objBanhang);
db.SaveChanges();
foreach (var item in listSPGH)
{
chitietdonhang objCTDH = new chitietdonhang();
objCTDH.idsp = item.id;
objCTDH.soluong = item.soluong;
objCTDH.giaban = item.gia;
objCTDH.iddonbanhang = objBanhang.id;
try
{
db.chitietdonhangs.Add(objCTDH);
db.SaveChanges();
}
catch { }
}
}
catch { }
}
return(RedirectToAction("Index", "XacNhanDonHangThanhCong"));
}
catch (Exception ex)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
public ActionResult DeleteConfirmed(int id)
{
chitietdonhang chitietdonhang = db.chitietdonhangs.Find(id);
db.chitietdonhangs.Remove(chitietdonhang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult StepEnd()
{
//Nhận reqest từ trang index
string phone = Request.Form["phone"];
string fullname = Request.Form["fullname"];
string email = Request.Form["email"];
string address = Request.Form["address"];
string note = Request.Form["note"];
//kiểm tra xem có customer chưa và cập nhật lại
khachhang newCus = new khachhang();
var cus = db.khachhang.FirstOrDefault(p => p.sdtkh.Equals(phone));
if (cus != null)
{
//nếu có số điện thoại trong db rồi
//cập nhật thông tin và lưu
cus.hovaten = fullname;
cus.email = email;
cus.diachi = address;
db.Entry(cus).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
//nếu chưa có sđt trong db
//thêm thông tin và lưu
return(RedirectToAction("Register", "User"));
}
//Thêm thông tin vào order và orderdetail
List <CartItem> giohang = Session["giohang"] as List <CartItem>;
//thêm order mới
donhang newOrder = new donhang();
int newIDOrder = db.donhang.OrderByDescending(p => p.ngaydat).FirstOrDefault().iddh;
newOrder.iddh = newIDOrder;
newOrder.sdtkh = phone;
newOrder.ghichu = note;
newOrder.ngaydat = DateTime.Now.ToString();
newOrder.trangthai = "0";
db.donhang.Add(newOrder);
db.SaveChanges();
//thêm details
for (int i = 0; i < giohang.Count; i++)
{
chitietdonhang newOrdts = new chitietdonhang();
newOrdts.iddh = newOrder.iddh;
newOrdts.idta = giohang.ElementAtOrDefault(i).thucanID;
newOrdts.soluong = giohang.ElementAtOrDefault(i).SoLuong;
newOrdts.dongia = giohang.ElementAtOrDefault(i).ThanhTien.ToString();
db.chitietdonhang.Add(newOrdts);
db.SaveChanges();
}
Session["MDH"] = newOrder.iddh;
Session["Phone"] = phone;
//xoá sạch giỏ hàng
giohang.Clear();
return(RedirectToAction("HoaDon", "ThanhToan"));
}
public ActionResult Edit([Bind(Include = "id,iddonbanhang,idsp,soluong,giaban,tensanpham")] chitietdonhang chitietdonhang)
{
if (ModelState.IsValid)
{
db.Entry(chitietdonhang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.iddonbanhang = new SelectList(db.banhangs, "id", "madonbanhang", chitietdonhang.iddonbanhang);
ViewBag.idsp = new SelectList(db.sanphams, "id", "ten", chitietdonhang.idsp);
return(View(chitietdonhang));
}
public ActionResult Edit([Bind(Include = "iddh,idta,soluong,dongia")] chitietdonhang chitietdonhang)
{
if (ModelState.IsValid)
{
db.Entry(chitietdonhang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.iddh = new SelectList(db.donhang, "iddh", "sdtkh", chitietdonhang.iddh);
ViewBag.idta = new SelectList(db.thucan, "idta", "tenta", chitietdonhang.idta);
return(View(chitietdonhang));
}
public ActionResult Edit([Bind(Include = "machitietdonhang,masanpham,madonhang,soluongmua,dongia,tongtien,tensanpham")] chitietdonhang chitietdonhang)
{
if (ModelState.IsValid)
{
db.Entry(chitietdonhang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.madonhang = new SelectList(db.donhang, "madonhang", "tenkhachhang", chitietdonhang.madonhang);
ViewBag.masanpham = new SelectList(db.sanpham, "masanpham", "tensanpham", chitietdonhang.masanpham);
return(View(chitietdonhang));
}
// GET: Admin/chitietdonhangss/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
chitietdonhang chitietdonhang = db.chitietdonhangs.Find(id);
if (chitietdonhang == null)
{
return(HttpNotFound());
}
return(View(chitietdonhang));
}
// GET: Admin/chitietdonhangss/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
chitietdonhang chitietdonhang = db.chitietdonhangs.Find(id);
if (chitietdonhang == null)
{
return(HttpNotFound());
}
ViewBag.iddonbanhang = new SelectList(db.banhangs, "id", "madonbanhang", chitietdonhang.iddonbanhang);
ViewBag.idsp = new SelectList(db.sanphams, "id", "ten", chitietdonhang.idsp);
return(View(chitietdonhang));
}
// GET: admin/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.iddh = new SelectList(db.donhang, "iddh", "sdtkh", chitietdonhang.iddh);
ViewBag.idta = new SelectList(db.thucan, "idta", "tenta", chitietdonhang.idta);
return(View(chitietdonhang));
}
// GET: Areas/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.madonhang = new SelectList(db.donhang, "madonhang", "tenkhachhang", chitietdonhang.madonhang);
ViewBag.masanpham = new SelectList(db.sanpham, "masanpham", "tensanpham", chitietdonhang.masanpham);
return(View(chitietdonhang));
}
public bool them(int masodh, int mahang, int soluong, int gia1sp)
{
try
{
banhangDataContext context = new banhangDataContext();
chitietdonhang themvaodh = new chitietdonhang();
themvaodh.masodh = masodh;
themvaodh.mahang = mahang;
themvaodh.soluong = soluong;
themvaodh.giadathang1sp = gia1sp;
context.chitietdonhangs.InsertOnSubmit(themvaodh);
context.SubmitChanges();
return(true);
}
catch { };
return(false);
}
public ActionResult Datmua()
{
List <CartItem> giohang = Session["giohang"] as List <CartItem>;
List <sanpham> lisp = db.sanpham.ToList();
var donhang = db.donhang.ToList();
var chitietdonhang = db.chitietdonhang.ToList();
donhang dh = new donhang();
dh.email = Request.Form["email"];
dh.diachi = Request.Form["diachi"];
dh.ghichu = Request.Form["ghichu"];
dh.ngaydathang = DateTime.Now;
dh.maphuongthucthanhtoan = int.Parse(Request.Form["phuongthuc"].ToString());
dh.tenkhachhang = Request.Form["hoten"];
dh.tinhtrang = "Đang chờ";
dh.tongtienthanhtoan = Convert.ToDecimal(Request.Form["tongtienthanhtoan"]);
db.donhang.Add(dh);
db.SaveChanges();
for (int i = 0; i < giohang.Count; i++)
{
chitietdonhang ctdh = new chitietdonhang();
ctdh.madonhang = dh.madonhang;
ctdh.masanpham = giohang[i].masanpham;
ctdh.soluongmua = giohang[i].soluong;
ctdh.tensanpham = giohang[i].tensanpham;
ctdh.dongia = (decimal)giohang[i].dongia;
ctdh.tongtien = (decimal)giohang[i].thanhtien;
db.chitietdonhang.Add(ctdh);
// sửa lại số lượng sản phẩm trong csdl sau khi đặt mua
sanpham sp = db.sanpham.Find(giohang[i].masanpham);
sp.soluong = sp.soluong - giohang[i].soluong;
db.SaveChanges();
}
for (int i = 0; i < giohang.Count; i++)
{
giohang.RemoveAt(i);
i--;
}
return(RedirectToAction("Datmuathanhcong", "Home"));
}
