public void InsertSP(SanPham model) { int maxIdSP = db.SanPhams.Select(x => x.MaSP).Max(); model.MaSP = maxIdSP + 1; model.SLTon = 0; model.SoLanMua = 0; db.SanPhams.Add(model); db.SaveChanges(); }
public ActionResult Create([Bind(Include = "MaNguoiDung,HoTen,TaiKhoan,MatKhau,DiaChi,Email,SDT,MaLND,GioiTinh,HinhAnh")] NguoiDung nguoiDung) { if (ModelState.IsValid) { db.NguoiDungs.Add(nguoiDung); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaLND = new SelectList(db.LoaiNguoiDungs, "MaLND", "TenLoaiND", nguoiDung.MaLND); return(View(nguoiDung)); }
public ActionResult ThanhToan(DonDatHang ddh) { var listGH = (List <GioHangModel>)Session["GIOHANG"]; var item = db.DonDatHangs.Find(ddh.MaDDH); item.DiaChiGiao = ddh.DiaChiGiao; item.MaTrangThai = 1; item.NgayDat = DateTime.Now; db.SaveChanges(); //chua fix dk //foreach(var a in listGH) //{ // SanPham sp = db.SanPhams.Find(a.MaSP); // sp.SLTon -= a.SoLuong; // sp.SoLanMua += a.SoLuong; // db.SaveChanges(); //} return(RedirectToAction("Index")); }
public ActionResult Edit(NguoiDung nguoiDung) { if (ModelState.IsValid) { var ndDAO = new NguoiDungDAO(); var nd = db.NguoiDungs.Find(nguoiDung.MaNguoiDung); if (nguoiDung.UploadHinhAnh != null) { string fileName = Path.GetFileName(nguoiDung.UploadHinhAnh.FileName); string filePath = "~/Assets/Admin/img/" + fileName; nguoiDung.UploadHinhAnh.SaveAs(Server.MapPath(filePath)); nd.HinhAnh = fileName; } ndDAO.Edit(nguoiDung); db.SaveChanges(); return(RedirectToAction("Profile")); } return(View(nguoiDung)); }
public void InsertAdmin(SignupModel nd) { NguoiDung nguoiDung = new NguoiDung(); int maxID = db.NguoiDungs.Select(x => x.MaNguoiDung).Max(); nguoiDung.MaNguoiDung = maxID + 1; nguoiDung.HoTen = nd.HoTen; nguoiDung.TaiKhoan = nd.TaiKhoan; nguoiDung.MatKhau = nd.MatKhau; nguoiDung.DiaChi = nd.DiaChi; nguoiDung.Email = nd.Email; nguoiDung.SDT = nd.SDT; nguoiDung.MaLND = 1; nguoiDung.GioiTinh = nd.GioiTinh; nguoiDung.NgaySinh = nd.NgaySinh; nguoiDung.HinhAnh = "icon-profile-cgv.png"; db.NguoiDungs.Add(nguoiDung); db.SaveChanges(); }
public void deleteGH(int idSP, int idDDH, List <GioHangModel> gh) { var ctDDH = db.ChiTietDonDatHangs.SingleOrDefault(x => x.MaSP == idSP && x.MaDDH == idDDH); var ddh = db.DonDatHangs.Find(idDDH); if (gh.Count == 1) { db.ChiTietDonDatHangs.Remove(ctDDH); db.SaveChanges(); db.DonDatHangs.Remove(ddh); } else { db.ChiTietDonDatHangs.Remove(ctDDH); } db.SaveChanges(); }