public ActionResult Checkout(string name, string address, string phonenum, string email)
{
int id = 1;
try
{
var dt = db.DonDatHang.Select(s => new { s.MaDDH }).OrderByDescending(s => s.MaDDH).FirstOrDefault();
id = dt.MaDDH + 1;
}
catch (Exception)
{
}
DonDatHang thongtin = new DonDatHang();
thongtin.Name = name;
thongtin.PhoneNum = phonenum;
thongtin.Email = email;
thongtin.DiaChiGiaoHang = address;
thongtin.NgayDat = DateTime.Now;
thongtin.TrangThai = "Đã xác nhận";
float tongtien = 0;
thongtin.ThanhToan = false;
if (Session["GioHang"] != null)
{
var gh = (List <GioHang>)Session["GioHang"];
foreach (GioHang a in gh)
{
tongtien += a.SL * a.DonGia;
}
}
thongtin.MaDDH = id;
thongtin.TongTien = tongtien;
db.DonDatHang.Add(thongtin);
db.SaveChanges();
if (Session["GioHang"] != null)
{
var gh = (List <GioHang>)Session["GioHang"];
foreach (GioHang a in gh)
{
CT_DonDatHang ct = new CT_DonDatHang();
ct.MaSP = a.ID;
ct.MaDDH = id;
ct.DonGia = a.DonGia;
ct.SoLuong = a.SL;
ct.TongTien = a.SL * a.DonGia;
foreach (var i in db.Sanpham)
{
if (i.MaSP == ct.MaSP)
{
i.SoLuong = i.SoLuong - a.SL;
}
}
db.CT_DonDatHang.Add(ct);
db.SaveChanges();
}
}
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
public void LuuDH(int?id, string TrangThai)
{
var dh = db.DonDatHang.Find(id);
dh.TrangThai = TrangThai;
if (dh.TrangThai == "Đã thanh toán")
{
dh.ThanhToan = true;
}
if (dh.TrangThai == "Chưa thanh toán")
{
dh.ThanhToan = false;
}
db.SaveChanges();
}
public int Insert(ClientAccount entity)
{
db.ClientAccount.Add(entity);
db.SaveChanges();
return(entity.IDAcount);
}
public int Insert(Sanpham entity)
{
db.Sanpham.Add(entity);
db.SaveChanges();
return(entity.MaSP);
}
public int Insert(User entity)
{
db.User.Add(entity);
db.SaveChanges();
return(entity.MaUser);
}