// GET: SANPHAMs public ActionResult Index(string searchTerm, int page = 1, int pageSize = 11) { var SanPhams = new SANPHAMsController(); var mode = SanPhams.ListAllPaging(searchTerm, page, pageSize); ViewBag.SearchTerm = searchTerm; return(View(mode)); }
public ActionResult CreateDH(string id1, string id2, string id3, string id4) { if (id4.Length <= 9 || string.IsNullOrEmpty(id3)) { ModelState.AddModelError("", "Vui lòng điền đầy đủ thông tin !"); } else { SANPHAMsController sANPHAM = new SANPHAMsController(); DONHANG dONHANG = new DONHANG(); if (ModelState.IsValid) { //dONHANG.NV_ID = Session["NV_ID"].ToString(); dONHANG.DN_ID = db.autottang("DonHang", "DN_ID", db.DONHANGs.Count()); dONHANG.DN_SDT = id4; dONHANG.TTDH_ID = 4; if (Session["KH_ID"] != null) { string KH_ID = Session["KH_ID"].ToString(); dONHANG.KH_ID = KH_ID; } dONHANG.DN_NGALAPDON = DateTime.Now; dONHANG.DN_GHICHU = "Khách đặc Online"; dONHANG.HTTT_ID = Convert.ToInt16(id1); //dONHANG.DN_SL = Convert.ToInt32(id2); db.DONHANGs.Add(dONHANG); db.SaveChanges(); int DN_ID = Convert.ToInt32(dONHANG.DN_ID); CHITIETDONHANG cHITIETDONHANG = new CHITIETDONHANG(); var giohang = Session["giohang"] as List <CartItem>; foreach (var i in giohang) { string CTDH_ID = db.autottang("CHITIETDONHANG", "CTDH_ID", db.CHITIETDONHANGs.Count()).ToString(); string SP_ID = i.SanPhamID; short TT = db.Database.SqlQuery <short>("select SP_TRANGTHAI from SanPham where SP_ID ='" + SP_ID + "'").SingleOrDefault(); if (TT == 1) { db.Database.ExecuteSqlCommand("Insert into ChiTietDonHang (CTDH_ID,DN_ID,SP_ID,CTDH_DIACHIGIAO) values('" + CTDH_ID + "','" + DN_ID + "','" + SP_ID + "',N'" + id3 + "')"); db.Database.ExecuteSqlCommand("update sanpham set SP_TRANGTHAI =0 where SP_ID ='" + SP_ID + "'"); ModelState.AddModelError("", "Xạc nhận mua " + i.SanPhamID + " thành công"); } CartItem itemXoa = giohang.FirstOrDefault(m => m.SanPhamID == i.SanPhamID); giohang.Remove(itemXoa); } ModelState.AddModelError("", "Đã thêm chờ hàng vui lòng chờ duyệt đơn !"); } } return(View()); }
public ActionResult Index(string HTTT_ID, string TXTSL, string DN_DIACHI, string DN_EMAIL, string DN_SDT, string DN_MATHE, string DN_CHUTHE, string DN_NGAYCAP) { ViewBag.sdt = DN_SDT; ViewBag.diachi = DN_DIACHI; ViewBag.email = DN_EMAIL; ViewBag.HTTT_ID = new SelectList(db.HINHTHUCTHANHTOANs, "HTTT_ID", "HTTT_TEN"); List <CartItem> giohang = Session["giohang"] as List <CartItem>; ViewBag.diachi = db.Database.SqlQuery <string>("select dn.DN_DIACHI from CHITIETDONHANG ctdn inner join DONHANG dn on ctdn.DN_ID = dn.DN_ID and dn.KH_ID ='" + Session["KH_ID"] + "' group by dn.DN_DIACHI").LastOrDefault(); if (ModelState.IsValid) { if (DN_SDT.Length <= 9 || !DN_SDT.StartsWith("09") && !DN_SDT.StartsWith("08") && !DN_SDT.StartsWith("03") && !DN_SDT.StartsWith("05") && !DN_SDT.StartsWith("07")) { ModelState.AddModelError("", "Vui lòng điền nhập đúng SĐT !"); } else if (string.IsNullOrEmpty(DN_DIACHI)) { ModelState.AddModelError("", "Vui lòng điền nhập địa chỉ !"); } else if (string.IsNullOrEmpty(DN_EMAIL)) { ModelState.AddModelError("", "Vui lòng điền nhập email !"); } else { SANPHAMsController sANPHAM = new SANPHAMsController(); DONHANG dONHANG = new DONHANG(); //Session["DN_ID"] = db.autottang("DonHang", "DN_ID", db.DONHANGs.Count()); //dONHANG.NV_ID = Session["NV_ID"].ToString(); int DN_ID = db.autottang("DonHang", "DN_ID", db.DONHANGs.Count()); dONHANG.DN_ID = DN_ID; dONHANG.DN_SDT = DN_SDT; dONHANG.TTDH_ID = 4; if (Session["KH_ID"] != null) { string KH_ID = Session["KH_ID"].ToString(); dONHANG.KH_ID = KH_ID; } dONHANG.DN_NGALAPDON = DateTime.Now; dONHANG.DN_GHICHU = "Khách đặc Online"; dONHANG.HTTT_ID = Convert.ToInt16(HTTT_ID); //dONHANG.DN_SL = Convert.ToInt32(TXTSL); dONHANG.DN_DIACHI = DN_DIACHI; dONHANG.DN_MATHE = DN_MATHE; dONHANG.DN_CHUTHE = DN_CHUTHE; dONHANG.DN_NGAYCAP = DN_NGAYCAP; dONHANG.DN_EMAIL = DN_EMAIL; db.DONHANGs.Add(dONHANG); db.SaveChanges(); //string DN_ID = Session["DN_ID"].ToString(); CHITIETDONHANG cHITIETDONHANG = new CHITIETDONHANG(); List <string> XoaItem = new List <string>(); foreach (var i in giohang) { XoaItem.Add(i.SanPhamID); string SP_ID = i.SanPhamID; for (int y = 1; y <= i.SoLuong; y++) { string CTDH_ID = db.autottang("CHITIETDONHANG", "CTDH_ID", db.CHITIETDONHANGs.Count()).ToString(); string TT = db.Database.SqlQuery <string>("select CTSP_ID from ChiTietSanPham where SP_ID ='" + i.SP_ID + "' and CTSP_TRANGTHAI =1").FirstOrDefault(); if (!string.IsNullOrEmpty(TT)) { if (HTTT_ID == "1") { db.Database.ExecuteSqlCommand("Insert into ChiTietDonHang (CTDH_ID,DN_ID,CTSP_ID) values('" + CTDH_ID + "','" + DN_ID + "','" + TT + "')"); } else { db.Database.ExecuteSqlCommand("Insert into ChiTietDonHang (CTDH_ID,DN_ID,CTSP_ID) values('" + CTDH_ID + "','" + DN_ID + "','" + TT + "')"); } db.Database.ExecuteSqlCommand("update ChiTietSanPham set CTSP_TRANGTHAI = 0 where CTSP_ID ='" + TT + "'"); ModelState.AddModelError("", "Xạc nhận mua " + i.TenSanPham + " thành công"); } } //CartItem itemXoa = giohang.FirstOrDefault(m => m.SanPhamID == i.SanPhamID); //giohang.Remove(itemXoa); } ModelState.AddModelError("", "Đã thêm chờ hàng vui lòng chờ duyệt đơn !"); Session["muathanhcong"] = 1; foreach (var i in XoaItem) { CartItem itemXoa = giohang.FirstOrDefault(m => m.SanPhamID == i); giohang.Remove(itemXoa); } } } return(View(giohang)); }