public JsonResult SaveData(khach_hang model) { string r = "fail";//result using (BikeStoreShoppingEntities db = new BikeStoreShoppingEntities()) { khach_hang kh = db.khach_hang.FirstOrDefault(x => x.Email == model.Email); if (kh != null) { r = "fail"; } else { db.Database.ExecuteSqlCommand("insert_customer @ten_khach_hang,@SDT,@dia_chi,@email,@password,@username", new SqlParameter("@ten_khach_hang", model.ten_khach_hang), new SqlParameter("@SDT", model.SDT), new SqlParameter("@dia_chi", model.dia_chi), new SqlParameter("@email", model.Email), new SqlParameter("@password", model.Password), new SqlParameter("@username", model.UserName) ); r = "success"; } } return(Json(r, JsonRequestBehavior.AllowGet)); }
public ActionResult InsertOrderIntoDatabase() { using (BikeStoreShoppingEntities db = new BikeStoreShoppingEntities()) { khach_hang cus = (khach_hang)Session["user"]; List <Items> li_items = (List <Items>)Session["cart"]; db.Database.ExecuteSqlCommand("insert_dh @id_khach_hang,@ngay_dat_hang,@tien_ship,@is_dang_giao_hang,@is_da_giao_hang,@is_huy_don_hang", new SqlParameter("@id_khach_hang", cus.id_khach_hang), new SqlParameter("@ngay_dat_hang", DateTime.Now), new SqlParameter("@tien_ship", 20), new SqlParameter("@is_dang_giao_hang", true), new SqlParameter("@is_da_giao_hang", false), new SqlParameter("@is_huy_don_hang", false) ); string orderId = (from s in db.dat_hang where s.id_khach_hang == cus.id_khach_hang orderby s.ngay_dat_hang descending select s.id_don_dat_hang).FirstOrDefault(); for (int i = 0; i < li_items.Count; ++i) { db.Database.ExecuteSqlCommand("insert_ctddh @id_don_dat_hang,@id_muc,@id_xe,@so_luong", new SqlParameter("@id_don_dat_hang", orderId), new SqlParameter("@id_muc", i + 1), new SqlParameter("@id_xe", li_items[i].product.id_xe), new SqlParameter("@so_luong", li_items[i].quantity) ); } Session["cart"] = null; return(RedirectToAction("OrderHistory")); } }
public ActionResult DeleteConfirmed(int id) { khach_hang khach_hang = db.khach_hang.Find(id); db.khach_hang.Remove(khach_hang); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult MyInformation() { if (Session["user"] != null) { khach_hang kh = (khach_hang)Session["user"]; return(View(kh)); } return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ma_khach_hang,ten_khach_hang,phai,dia_chi,dien_thoai,email,ghi_chu")] khach_hang khach_hang) { if (ModelState.IsValid) { db.Entry(khach_hang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(khach_hang)); }
public ActionResult OrderHistory() { using (BikeStoreShoppingEntities db = new BikeStoreShoppingEntities()) { khach_hang cus = (khach_hang)Session["user"]; //List<chi_tiet_don_dat_hang> order_items = db.Database.SqlQuery<chi_tiet_don_dat_hang>("find_order @id_khach_hang", new SqlParameter("@id_khach_hang", cus.id_khach_hang)).ToList(); List <dat_hang> orders = (from s in db.dat_hang where s.id_khach_hang == cus.id_khach_hang orderby s.ngay_dat_hang descending select s).ToList(); return(View(orders)); } }
public ActionResult Create([Bind(Include = "ma_khach_hang,ten_khach_hang,phai,dia_chi,dien_thoai,email,ghi_chu")] khach_hang khach_hang) { if (ModelState.IsValid) { db.khach_hang.Add(khach_hang); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(khach_hang)); }
public ActionResult Login(khach_hang khachHang) { var currentUser = database.khach_hang.Where(user => user.email == khachHang.email && user.mat_khau == khachHang.mat_khau).FirstOrDefault(); if (currentUser != null) { Session["Username"] = currentUser.ho_ten.ToString(); Session["Id"] = currentUser.id.ToString(); return(RedirectToAction("Index")); } return(View(khachHang)); }
public JsonResult Login(khach_hang model) { using (BikeStoreShoppingEntities db = new BikeStoreShoppingEntities()) { string result = "fail"; khach_hang data_match = db.khach_hang.FirstOrDefault(x => x.Email == model.Email && x.Password == model.Password); if (data_match != null) { Session["user"] = data_match; result = "succcess"; } return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult Register(khach_hang khachHang) { try { database.khach_hang.Add(khachHang); khachHang.ngay_dang_ky = DateTime.Today; database.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception e) { return(Content(e.ToString())); } }
// GET: /c_khach_hang/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } khach_hang khach_hang = db.khach_hang.Find(id); if (khach_hang == null) { return(HttpNotFound()); } return(View(khach_hang)); }
public JsonResult EditInfor(khach_hang kh) { using (BikeStoreShoppingEntities db = new BikeStoreShoppingEntities()) { khach_hang k = (khach_hang)Session["user"]; db.Database.ExecuteSqlCommand("edit_information @id_khach_hang,@ten_khach_hang,@sdt,@dia_chi,@username", new SqlParameter("@id_khach_hang", k.id_khach_hang), new SqlParameter("@ten_khach_hang", kh.ten_khach_hang), new SqlParameter("@sdt", kh.SDT), new SqlParameter("@dia_chi", kh.dia_chi), new SqlParameter("@username", kh.UserName) ); Session["user"] = db.khach_hang.FirstOrDefault(x => x.id_khach_hang == k.id_khach_hang); return(Json("success", JsonRequestBehavior.AllowGet)); } }
public ActionResult ConfirmOrder() { khach_hang cus = (khach_hang)Session["user"]; return(View(cus)); }