public ActionResult DatHang(FormCollection collection)
{
List <GioHang> gh = (List <GioHang>)Session[cartname];
hoadon dh = (hoadon)Session["dathang"];
DB.hoadons.Add(dh);
DB.SaveChanges();
int mahdMax = DB.hoadons.Max(u => u.mahd);
foreach (var item in gh)
{
cthd chitiet = new cthd();
chitiet.tensp = item.sanpham.tensp;
chitiet.mahd = mahdMax;
chitiet.masp = item.sanpham.masp;
chitiet.soluong = Convert.ToInt32(item.SoLuong);
chitiet.thanhtien = Convert.ToInt32(item.SoLuong) * Convert.ToInt32(item.sanpham.gia);
DB.cthds.Add(chitiet);
DB.SaveChanges();
}
Session.Remove("giohang");
return(RedirectToAction("ThongBao"));
}
public int getXoasanpham(int masp)
{
ctdh kiemtractdh = db.ctdhs.Where(x => x.masp == masp).FirstOrDefault();
cthd kiemtracthd = db.cthds.Where(x => x.masp == masp).FirstOrDefault();
if (kiemtractdh == null && kiemtracthd == null)
{
sanpham sp = db.sanphams.Where(x => x.masp == masp).FirstOrDefault();
db.sanphams.Attach(sp);
db.sanphams.Remove(sp);
return(db.SaveChanges());
}
else
{
return(0);
}
}
public int ThemHoaDon(int makh, int thanhtoan, List <CartItem> list, string ghichu)
{
hoadon a = new hoadon();
a.MAKH = null;
if (makh != 0)
{
a.MAKH = makh;
}
a.NGHD = DateTime.Now.Date;
a.THANHTOAN = thanhtoan;
a.TINHTRANG = "cho xu ly";
a.TRIGIA = 0;
a.GHICHU = ghichu;
context.hoadons.Add(a);
context.SaveChanges();
//a = layhoadonvuathem();
double thanhtien = 0;
foreach (var item in list)
{
cthd ct = new cthd();
ct.SOHD = a.SOHD;
ct.MASP = item.MASP;
ct.SL = item.SoLuong;
ct.HINHANH = item.HINHANH;
ct.THANHTIEN = item.ThanhTien;
thanhtien += ct.THANHTIEN;
context.cthds.Add(ct);
context.SaveChanges();
}
//context.hoadons.Where(hd => hd.SOHD == a.SOHD)
// .ToList().ForEach(x => x.TRIGIA = thanhtien);
context.hoadons.Where(x => x.SOHD == a.SOHD).FirstOrDefault().TRIGIA = thanhtien;
return(context.SaveChanges());
}
public bool Thanhtoandonhang(int madh)
{
DateTime date = DateTime.Now.Date;
date.ToString("yyyy-MM-dd");
var ctdh = db.ctdhs.Where(x => x.madh == madh);
int mahd;
Model.EF.donhang dh;
using (var context = new CoffeeHouseDbContext())
{
dh = context.donhangs.Where(x => x.madh == madh).FirstOrDefault();
hoadon hd = new hoadon();
hd.makh = (long)dh.makh;
hd.ngaythanhtoan = date;
hd.tongtien = dh.tongtien;
hd.httt = dh.httt;
context.hoadons.Add(hd);
context.SaveChanges();
mahd = (int)hd.mahd;
}
foreach (var ct in ctdh)
{
cthd cthd = new cthd();
cthd.mahd = mahd;
cthd.masp = ct.masp;
cthd.soluong = ct.soluong;
cthd.gia = ct.gia;
db.cthds.Add(cthd);
}
dh.tttt = 1;
db.donhangs.AddOrUpdate(dh);
db.SaveChanges();
return(true);
}
