public ActionResult Create(tbl_KhachHang khachHang) { bool result = false; using (HutechMartDbContext db = new HutechMartDbContext()) { using (var trans = db.Database.BeginTransaction()) { try { khachHang.ngaytao = DatetimeLocation.GetDate(); khachHang.tinhtrang = true; db.tbl_KhachHang.Add(khachHang); db.SaveChanges(); trans.Commit(); result = true; } catch { trans.Rollback(); } } } return(Json(result, JsonRequestBehavior.AllowGet)); }
//xu ly thanh toan public ActionResult XLTT() { if (Session["KH"] == null) { return(RedirectToAction("DangNhap", "KhachHang")); } else { tbl_HoaDon hd = new tbl_HoaDon(); hd.NgayTao = DateTime.Now; tbl_KhachHang kh = (tbl_KhachHang)Session["KH"]; hd.MaKH = kh.MaKhachHang; mk.tbl_HoaDons.InsertOnSubmit(hd); mk.SubmitChanges(); tbl_ChiTietHD ct; List <GioHang> GH = LayGioHang(); foreach (var i in GH) { ct = new tbl_ChiTietHD(); ct.MaHD = hd.MaHoaDon; ct.MaSP = i.Masp; ct.SoLuong = i.SL; mk.tbl_ChiTietHDs.InsertOnSubmit(ct); mk.SubmitChanges(); } } return(RedirectToAction("Index", "Home")); }
public ActionResult LuuDonHang(FormCollection c) { string ngaygiao = c["txtDate"]; GioHang gio = Session["gh"] as GioHang; tbl_KhachHang khach = Session["kh"] as tbl_KhachHang; tbl_HoaDon hd = new tbl_HoaDon(); hd.NgayHoaDon = DateTime.Now; hd.MaKH = khach.MaKhachHang; hd.NgayGiao = DateTime.Parse(ngaygiao); data.tbl_HoaDons.InsertOnSubmit(hd); data.SubmitChanges(); //Lưu nhiều dòng vào bảng chi tiết đơn hàng foreach (CartItem item in gio.dsSP) { tbl_ChiTiet ct = new tbl_ChiTiet(); ct.MaHD = hd.MaHoaDon; ct.MaSP = item.iMaSach; ct.SoLuong = item.iSoluong; data.tbl_ChiTiets.InsertOnSubmit(ct); data.SubmitChanges(); } Session["gh"] = null; return(View()); }
// GET: HistoryDetail public ActionResult HistoryDetail(string id) { if (Session["User"] == null) { Response.Redirect("/Login/Login"); } bool isNumeric = true; foreach (char c in id) { if (!Char.IsNumber(c)) { isNumeric = false; break; } } if (isNumeric == false) { Response.Redirect("/History/History"); } tbl_KhachHang kh = (tbl_KhachHang)Session["User"]; Code code = new Code(); List <tbl_ChiTietHoaDon> cthd = code.Get_ChiTietHoaDon(int.Parse(id)); return(View(cthd)); }
// GET: History public ActionResult History() { if (Session["User"] == null) { Response.Redirect("/Login/Login"); } tbl_KhachHang kh = (tbl_KhachHang)Session["User"]; Code code = new Code(); List <tbl_HoaDon> hd = code.Get_HoaDon(kh.MaKhachHang); return(View(hd)); }
public ActionResult XacNhanDonHang() { tbl_KhachHang khach = Session["kh"] as tbl_KhachHang; if (khach == null) { return(RedirectToAction("DangNhap", "Home")); } //Da Dang Nhap ViewBag.k = khach; GioHang gio = Session["gh"] as GioHang; return(View(gio)); }
public JsonResult JSPageHistory(FormCollection data) { if (Session["User"] == null) { Response.Redirect("/Login/Login"); } JsonResult js = new JsonResult(); int sotrang = int.Parse(data["sotrang"]); tbl_KhachHang kh = (tbl_KhachHang)Session["User"]; Code code = new Code(); List <tbl_HoaDon> hd = code.Get_HoaDon(kh.MaKhachHang); string context = ""; int dem = 0; foreach (tbl_HoaDon item in hd) { dem++; if (dem >= sotrang * 8 - 8 && dem <= sotrang * 8) { string sdt = "0" + item.SDT; context += "<tr><th class='text-center' scope='col'>" + item.NguoiNhan + "</th><th class='text-center' scope='col'>" + item.DiaChiNhan + "</th>"; context += "<th class='text-center' scope='col'>" + sdt + "</th><th class='text-center' scope='col'>" + item.NgayLap + "</th>"; if (item.TrangThaiThanhToan == 1) { context += "<th class='text-center' scope='col'>Đã thanh toán</th>"; } else { context += "<th class='text-center' scope='col'>Chưa thanh toán</th>"; } if (item.MaTrangThaiDonHang == 1) { context += "<th class='text-center' scope='col'>Đã nhận hàng</th>"; } else { context += "<th class='text-center' scope='col'>Đã đặt</th>"; } context += "<th class='text-center' scope='col'>" + item.TongTien.ToString("#,##0").Replace(",", ".") + "VNĐ</th>"; context += "<th><a href='/HistoryDetail/HistoryDetail/" + item.MaHoaDon + "' class='btn btn-primary'>Xem chi tiết</a></th></tr>"; } } js.Data = new { context = context }; return(Json(js, JsonRequestBehavior.AllowGet)); }
private void btnXoa_Click(object sender, EventArgs e) { if (dgvKH.SelectedRows.Count > 0) { if (XtraMessageBox.Show("Bạn có muốn xóa không ? ", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { string makh = txtMaKH.Text; tbl_KhachHang kh = db.tbl_KhachHang.Find(makh); db.tbl_KhachHang.Remove(kh); db.SaveChanges(); HienThiDSKhachHang(); setNull(); } } else { XtraMessageBox.Show("Vui lòng chọn dòng cần xóa"); } }
public ActionResult XL_DangKy(FormCollection col, tbl_KhachHang kh) { kh = mk.tbl_KhachHangs.FirstOrDefault(x => x.SoDienThoai == col["Txt_SDT"]); if (kh == null) { kh = new tbl_KhachHang(); kh.TenKhachHang = col["Txt_Ten"]; kh.SoDienThoai = col["Txt_SDT"]; kh.DiaChi = col["Txt_DC"]; kh.MatKhau = col["Txt_MK"]; kh.GioiTinh = col["rad_GT"]; mk.tbl_KhachHangs.InsertOnSubmit(kh); mk.SubmitChanges(); return(RedirectToAction("DN")); } else { return(RedirectToAction("DangKy", new { sdt = col["Txt_SDT"].ToString() })); } }
public ActionResult CustomerLogin(CustomerLoginViewModel model) { tbl_KhachHang UserLogin = new tbl_KhachHang(); if (Request.HttpMethod == "POST") { try { if (dB.tbl_KhachHang.Any(d => d.UserName == model.UserName)) { if (model.Password == dB.tbl_KhachHang.Where(d => d.UserName == model.UserName).FirstOrDefault().Password) { if (model.RememberMe) { Response.Cookies["CustomerLogin"].Value = model.UserName; } UserLogin = dB.tbl_KhachHang.Where(d => d.UserName == model.UserName).FirstOrDefault(); Session["CustomerLogin"] = model.UserName; CustomerLoginStatus.IsLogin = true; CustomerLoginStatus.CustomerUser = model.UserName; CustomerLoginStatus.CustomerUserId = UserLogin.Id; CustomerLoginStatus.CustomerName = UserLogin.FullName; return(RedirectToAction("Index", "Home")); } else { model.LoginError = "*Mật khẩu không chính xác"; } } else { model.LoginError = "*Tài khoản không chính xác"; } } catch { model.LoginError = "*Lỗi không xác định"; } } return(View(model)); }
public ActionResult DN(FormCollection col, tbl_KhachHang kh) { kh = mk.tbl_KhachHangs.FirstOrDefault(x => x.SoDienThoai == col["Txt_ID"] && x.MatKhau == col["Txt_MK"]); if (kh == null) { if (mk.tbl_KhachHangs.FirstOrDefault(x => x.SoDienThoai == col["Txt_ID"]) == null) { ViewData["ID"] = "Sai tên số điện thoại"; } if (mk.tbl_KhachHangs.FirstOrDefault(x => x.SoDienThoai == col["Txt_MK"]) == null) { ViewData["MK"] = "Sai mật khẩu"; } return(View()); } else { Session["KH"] = kh; return(RedirectToAction("Index", "Home")); } }
public ActionResult Update(tbl_KhachHang khachHang) { bool result = false; using (HutechMartDbContext db = new HutechMartDbContext()) { using (var trans = db.Database.BeginTransaction()) { try { var _khachHang = db.tbl_KhachHang.Find(khachHang.id); _khachHang.id_phanloai = khachHang.id_phanloai; _khachHang.tenkhachhang = khachHang.tenkhachhang; _khachHang.gioitinh = khachHang.gioitinh; _khachHang.ngaysinh = khachHang.ngaysinh; _khachHang.sochungminh = khachHang.sochungminh; _khachHang.sodienthoai = khachHang.sodienthoai; _khachHang.diachi_tentinh = khachHang.diachi_tentinh; _khachHang.diachi_tenquan = khachHang.diachi_tenquan; _khachHang.diachi_tenphuong = khachHang.diachi_tenphuong; _khachHang.diachi_sonha = khachHang.diachi_sonha; _khachHang.email = khachHang.email; _khachHang.facebook = khachHang.facebook; _khachHang.ghichu = khachHang.ghichu; _khachHang.id_nguoicapnhat = khachHang.id_nguoicapnhat; _khachHang.ngaycapnhat = DatetimeLocation.GetDate(); db.SaveChanges(); trans.Commit(); result = true; } catch { trans.Rollback(); } } return(Json(result, JsonRequestBehavior.AllowGet)); } }
protected void Page_Load(object sender, EventArgs e) { remenu.DataSource = NhomHangService.NhomHang_GetByTop("", " Active='True'", ""); remenu.DataBind(); tbl_KhachHang kh = new tbl_KhachHang(); GoogleConnect.ClientId = "520808312902-5al7h79mvjmk9jil2du85jenb6stla5q.apps.googleusercontent.com"; GoogleConnect.ClientSecret = "QF8LkNiAPNTvAvbJJvQqTR9E"; GoogleConnect.RedirectUri = Request.Url.AbsoluteUri.Split('?')[0]; if (!string.IsNullOrEmpty(Request.QueryString["code"])) { string code = Request.QueryString["code"]; string json = GoogleConnect.Fetch("me", code); GoogleProfile profile = new JavaScriptSerializer().Deserialize <GoogleProfile>(json); Session["TenDangNhap"] = profile.Id; Session["display_name"] = profile.DisplayName; Session["email"] = profile.Emails.Find(email => email.Type == "account").Value; kh.TaiKhoan = profile.Id; kh.Email = profile.Emails.Find(email => email.Type == "account").Value.ToString(); kh.tenKH = profile.DisplayName; var a = from i in db.tbl_KhachHangs where i.TaiKhoan == profile.Id select i; if (a.Count() <= 0) { db.tbl_KhachHangs.InsertOnSubmit(kh); db.SubmitChanges(); } Response.Redirect("TrangChu.aspx"); } if (Request.QueryString["error"] == "access_denied") { ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('Access denied.')", true); } }
public ActionResult CustomerRegister(CustomerRegisterViewModel model) { if (Request.HttpMethod == "POST") { if (!string.IsNullOrEmpty(model.Password) && !string.IsNullOrEmpty(model.ConfirmPassword) && (model.Password == model.ConfirmPassword)) { if (!dB.tbl_KhachHang.Any(d => d.UserName == model.UserName)) { tbl_KhachHang addKhachHang = new tbl_KhachHang(); addKhachHang.FullName = model.FullName; addKhachHang.UserName = model.UserName; addKhachHang.Password = model.Password; addKhachHang.PhoneNumber = model.PhoneNumber; addKhachHang.DiaChi = model.DiaChi; dB.tbl_KhachHang.Add(addKhachHang); dB.SaveChanges(); //redirect to Login CustomerLoginViewModel login = new CustomerLoginViewModel(); login.UserName = model.UserName; login.Password = model.Password; return(RedirectToAction("CustomerLogin", "Account", login)); } else { model.Error = "Tài khoản đã tồn tại"; } } else { return(View()); } } return(View(model)); }
//xem thong tin KH public ActionResult TTKH(int ma) { tbl_KhachHang kh = mk.tbl_KhachHangs.FirstOrDefault(x => x.MaKhachHang == ma); return(View(kh)); }
public JsonResult JSDangKi(FormCollection data) { if (data["rtk"] == null) { Response.Redirect("/Home/Index"); } Code code = new Code(); string tk = data["rtk"]; string mk = data["rmk"]; string rmk = data["remk"]; string email = data["remail"]; string ten = data["rten"]; JsonResult js = new JsonResult(); if (String.IsNullOrEmpty(tk) || String.IsNullOrEmpty(mk) || String.IsNullOrEmpty(rmk) || String.IsNullOrEmpty(email)) { js.Data = new { status = "ERR" }; } else { if (mk != rmk) { js.Data = new { status = "ERMK" }; } else { var RexPW = new Regex(@"^(?=.*\d)(?=.*[A-Z])(?=.*\W).{8,32}$"); var RexUID = new Regex(@"^[a-z_][a-z0-9_\.\s]{8,32}$"); var RexEmail = new Regex(@"^[a-z][a-z0-9_\.]{4,31}@[a-z0-9]{2,}(\.[a-z0-9]{2,4}){1,2}$"); if (!RexPW.IsMatch(mk)) { js.Data = new { status = "ER" }; } else if (!RexUID.IsMatch(tk)) { js.Data = new { status = "ER" }; } else if (!RexEmail.IsMatch(email)) { js.Data = new { status = "ER" }; } else if (ten.Length < 2) { js.Data = new { status = "ER" }; } else { if (code.Get_KhachHang(tk) != null) { js.Data = new { status = "ERTK" }; } else { tbl_KhachHang kh = new tbl_KhachHang(); kh.TaiKhoan = tk; kh.MatKhau = Encryptor.MD5Hash(mk); kh.Email = email; kh.Ten = ten; code.AddObject(kh); code.Save(); js.Data = new { status = "OK" }; } } } } return(Json(js, JsonRequestBehavior.AllowGet)); }
private void btnLuu_Click(object sender, EventArgs e) { try { string makh = txtMaKH.Text; string tenkh = txtTenKH.Text; string gioitinh; if (rdbNam.Checked == true) { gioitinh = "Nam"; } else { gioitinh = "Nữ"; } string diachi = txtDiaChi.Text; string cmnd = txtCMND.Text; string sdt = txtSDT.Text; if (Flag == true) { if (db.tbl_KhachHang.SqlQuery("select * from tbl_KhachHang").Where(m => m.MaKhachHang.Contains(txtMaKH.Text)).Count() > 0) { XtraMessageBox.Show("Mã khách hàng nhập sai hoặc bị trùng", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (txtTenKH.Text == "" || txtDiaChi.Text == "" || txtCMND.Text == "" || txtSDT.Text == "") { XtraMessageBox.Show("Vui lòng nhập đầy đủ thông tin!"); } else { tbl_KhachHang kh = new tbl_KhachHang(); kh.MaKhachHang = makh; kh.HoTenKhach = tenkh; kh.GioiTinh = gioitinh; kh.DiaChi = diachi; kh.CMND = cmnd; kh.SDT = sdt; db.tbl_KhachHang.Add(kh); db.SaveChanges(); HienThiDSKhachHang(); XtraMessageBox.Show("Thêm khách hàng thành công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); setNull(); setButton(true); setKhoa(true); } } } else { tbl_KhachHang kh = db.tbl_KhachHang.Where(m => m.MaKhachHang == makh).FirstOrDefault(); kh.HoTenKhach = tenkh; kh.GioiTinh = gioitinh; kh.DiaChi = diachi; kh.CMND = cmnd; kh.SDT = sdt; if (kh == null) { XtraMessageBox.Show("Khách hàng không tồn tại!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { db.Entry(kh).State = EntityState.Modified; db.SaveChanges(); HienThiDSKhachHang(); XtraMessageBox.Show("Cập nhật thành công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); setNull(); setButton(true); setKhoa(true); } } } catch { } }
public JsonResult JSPayCheck(FormCollection form) { JsonResult js = new JsonResult(); bool isNumeric = true; string finame = form["finame"]; string miname = form["miname"]; string laname = form["laname"]; string add1 = form["add1"]; string add2 = form["add2"]; string country = form["country"]; string state = form["state"]; string city = form["city"]; string phone = form["phone"]; if (string.IsNullOrEmpty(finame) || string.IsNullOrEmpty(laname) || string.IsNullOrEmpty(add1) || string.IsNullOrEmpty(country) || string.IsNullOrEmpty(state) || string.IsNullOrEmpty(city) || string.IsNullOrEmpty(phone)) { js.Data = new { status = "EMPTY" }; } else { foreach (char c in phone) { if (!Char.IsNumber(c)) { isNumeric = false; break; } } if (isNumeric == false) { js.Data = new { status = "ERRPHONE" }; } else { if (phone.Length != 10) { js.Data = new { status = "ERRPHONE" }; } else { string address = add1 + " " + add2 + " " + state + " " + city + " " + country; string name = finame + " " + miname + " " + laname; if (Session["Cart"] == null) { Response.Redirect("/Product/Product/1"); } Code code = new Code(); List <CartItem> giohang = Session["Cart"] as List <CartItem>; if (giohang.Count() == 0) { Response.Redirect("/Product/Product/1"); } bool status = true; foreach (CartItem item in giohang) { if (item.SoLuong > code.Get_ThietBi().FirstOrDefault(m => m.MaThietBi == item.SanPhamID).SoLuong) { status = false; item.SoLuong = code.Get_ThietBi().FirstOrDefault(m => m.MaThietBi == item.SanPhamID).SoLuong; } } if (status == true) { if (Session["User"] == null) { Response.Redirect("/Login/Login"); } else { tbl_KhachHang u = (tbl_KhachHang)Session["User"]; tbl_HoaDon hd = new tbl_HoaDon(); hd.MaKhachHang = u.MaKhachHang; hd.NgayLap = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year; hd.MaTrangThaiDonHang = 2; hd.DiaChiNhan = address; hd.NguoiNhan = name; hd.SDT = int.Parse(phone); hd.TongTien = giohang.Sum(m => m.ThanhTien); hd.TrangThaiThanhToan = 2; code.AddObject(hd); foreach (CartItem item in giohang) { tbl_ChiTietHoaDon cthd = new tbl_ChiTietHoaDon(); cthd.MaHoaDon = hd.MaHoaDon; cthd.MaThietBi = item.SanPhamID; cthd.SoLuong = item.SoLuong; cthd.ThanhTien = item.ThanhTien; cthd.DonGia = item.DonGia; code.AddObject(cthd); code.Save(); tbl_ThietBi tb = code.Get_ThietBi().FirstOrDefault(m => m.MaThietBi == item.SanPhamID); tb.SoLuong = tb.SoLuong - item.SoLuong; code.Save(); } code.Save(); Session.Remove("Cart"); js.Data = new { status = "OK" }; } } else { js.Data = new { status = "ER" }; } } } } return(Json(js, JsonRequestBehavior.AllowGet)); }