public int isLogin() { if (Session["taikhoan"] != null) { TaiKhoan tk = new TaiKhoan(); tk = (TaiKhoan)Session["taikhoan"]; switch (tk.LoaiTaiKhoan) { case LoaiTaiKhoan.Admin: return 1; case LoaiTaiKhoan.Member: return 2; case LoaiTaiKhoan.Sales: return 3; }; } return -1; }
public ActionResult NhanGiaoDichThueCanHo(ThueCanHo thuecanho, string chkSuaLoi) { if (isLogin() == -1) { return Redirect("/DangNhap"); } else if (isLogin() == 2) { return Redirect("/"); } else { try { TaiKhoan tk = new TaiKhoan(); tk = (TaiKhoan)Session["taikhoan"]; ViewBag.chkSuaLoi = chkSuaLoi; DataProvider dp = new DataProvider(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@mataikhoan", SqlDbType.Int); param[0].Value = tk.MaTaiKhoan; param[1] = new SqlParameter("@mathuecanho", SqlDbType.Int); param[1].Value = thuecanho.MaThueCanHo; if (chkSuaLoi != null) { //Set level = Serializable để giải quyết Unrepeatable Read dp.ExecuteProcNonQuery("sp_NhanGiaoDich_Fixed", ref param); } else { //Set level = ReadCommitted mức mặc định dp.ExecuteProcNonQuery("sp_NhanGiaoDich", ref param); } return Redirect("/Admin/ThueCanHo/ChiTietThueCanHo/" + thuecanho.MaThueCanHo.ToString()); } catch (Exception ex) { ViewBag.ErrorMessage = ex.Message; return Redirect("/Admin/ThueCanHo/"); } } }
// // GET: /CanHo/ public ActionResult Index() { bool fixDirtyRead = true; Boolean.TryParse(Request.Params["dirtyread"], out fixDirtyRead); int canHoID = 0; CanHo ch = new CanHo(); if (!Int32.TryParse(Request.Params["id"], out canHoID)) { ch.MaTrangThaiCanHo = -999; } else { DataProvider dp = new DataProvider(); string sql = ""; //Load danh sach thanh pho /*string sql = @"SELECT ch.*, d.tenduong, q.tenquan, tp.tenthanhpho FROM canho ch, duong d, quan q, thanhpho tp WHERE ch.kichhoat = 1 AND ch.matrangthaicanho = 2 AND ch.maduong = d.maduong AND d.maquan = q.maquan AND q.mathanhpho = tp.mathanhpho AND ch.macanho = " + canHoID.ToString() + @" ORDER BY ch.ngaydang DESC ";*/ SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@macanho", SqlDbType.Int); param[0].Value = canHoID.ToString(); DataTable dt = new DataTable(); if (fixDirtyRead == true) { dt = dp.ExecuteProcQuery("sp_XemCanHo_Fixed", ref param); } else { dt = dp.ExecuteProcQuery("sp_XemCanHo", ref param); } if (dt.Rows.Count > 0) { ch.MaCanHo = (int)dt.Rows[0]["macanho"]; ch.TenCanHo = dt.Rows[0]["tencanho"].ToString(); ch.MaDuong = (int)dt.Rows[0]["maduong"]; ch.DiaChi = dt.Rows[0]["diachi"].ToString() + " " + dt.Rows[0]["tenduong"].ToString() + ", " + dt.Rows[0]["tenquan"].ToString() + ", " + dt.Rows[0]["tenthanhpho"].ToString(); ch.MieuTa = dt.Rows[0]["mieuta"].ToString(); ch.ToaDo = dt.Rows[0]["toado"].ToString(); ch.GiaThue = (double)dt.Rows[0]["giathue"]; ch.DienTich = (double)dt.Rows[0]["dientich"]; ch.MaTrangThaiCanHo = (int)dt.Rows[0]["matrangthaicanho"]; ch.TrangThaiCanHo = (TrangThaiCanHo)dt.Rows[0]["matrangthaicanho"]; ch.NgayDang = DateTime.Parse(dt.Rows[0]["ngaydang"].ToString()); ch.NguoiDang = (int)dt.Rows[0]["nguoidang"]; ch.GhiChu = dt.Rows[0]["ghichu"].ToString(); ch.KichHoat = (int)dt.Rows[0]["kichhoat"]; //Lay hinh anh sql = @"SELECT * FROM hinhanhcanho WHERE macanho = " + canHoID.ToString(); dt = new DataTable(); dt = dp.ExecuteQuery(sql); List<HinhAnhCanHo> dsHinhAnhCanHo = new List<HinhAnhCanHo>(); for (int i = 0; i < dt.Rows.Count; i++) { HinhAnhCanHo h = new HinhAnhCanHo(); h.MaHinhAnh = (int)dt.Rows[i]["mahinhanh"]; h.LienKet = dt.Rows[i]["lienket"].ToString(); h.MaCanHo = canHoID; dsHinhAnhCanHo.Add(h); } ViewBag.dsHinhAnhCanHo = dsHinhAnhCanHo; //Lay thong tin nguoi dang tin sql = @"SELECT * FROM taikhoan WHERE mataikhoan = " + ch.NguoiDang.ToString(); dt = new DataTable(); dt = dp.ExecuteQuery(sql); TaiKhoan tk = new TaiKhoan(); tk.MaTaiKhoan = (int)dt.Rows[0]["mataikhoan"]; tk.Email = dt.Rows[0]["email"].ToString(); tk.MaLoaiTaiKhoan = (int)dt.Rows[0]["maloaitaikhoan"]; tk.LoaiTaiKhoan = (LoaiTaiKhoan)dt.Rows[0]["maloaitaikhoan"]; tk.Ten = dt.Rows[0]["ten"].ToString(); tk.NgaySinh = (DateTime)dt.Rows[0]["ngaysinh"]; tk.DiaChi = dt.Rows[0]["diachi"].ToString(); tk.DienThoai = dt.Rows[0]["dienthoai"].ToString(); tk.NgayDangKy = (DateTime)dt.Rows[0]["ngaydangky"]; tk.MaTrangThai = (int)dt.Rows[0]["trangthai"]; tk.TrangThai = (TrangThaiTaiKhoan)dt.Rows[0]["trangthai"]; ViewBag.taiKhoan = tk; } else { ch.MaTrangThaiCanHo = -999; } } return View("~/Views/Shared/ChiTietCanHo.cshtml", ch); }
public ActionResult Index(TaiKhoan taikhoan, string chkSuaLoi) { try { ViewBag.chkSuaLoi = chkSuaLoi; if (taikhoan.Email != null && taikhoan.MatKhau != null) { DataProvider dp = new DataProvider(); using (MD5 md5hash = MD5.Create()) { string hash = GetMd5Hash(md5hash, taikhoan.MatKhau); taikhoan.MatKhau = hash; } SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@email", SqlDbType.NVarChar); param[0].Value = taikhoan.Email; param[1] = new SqlParameter("@matkhau", SqlDbType.NVarChar); param[1].Value = taikhoan.MatKhau; DataTable dt = null; if (chkSuaLoi != null) { //Set level = Repeatable Read để giải quyết Unrepeatable Read dt = dp.ExecuteProcQuery("sp_DangNhapTaiKhoan_Fixed", ref param); } else { //Set level = ReadCommitted mức mặc định dt = dp.ExecuteProcQuery("sp_DangNhapTaiKhoan", ref param); } if (dt.Rows.Count > 0) { ViewBag.Result = true; ViewBag.ErrorMessage = "Đăng nhập thành công"; TaiKhoan tk = new TaiKhoan(); tk.MaTaiKhoan = (int)dt.Rows[0]["mataikhoan"]; tk.Email = (string)dt.Rows[0]["email"]; tk.Ten = (string)dt.Rows[0]["ten"]; if (dt.Rows[0]["ngaysinh"] != DBNull.Value) tk.NgaySinh = (DateTime)dt.Rows[0]["ngaysinh"]; if (dt.Rows[0]["diachi"] != DBNull.Value) tk.DiaChi = (string)dt.Rows[0]["diachi"]; if (dt.Rows[0]["dienthoai"] != DBNull.Value) tk.DienThoai = (string)dt.Rows[0]["dienthoai"]; tk.MaLoaiTaiKhoan = (int)dt.Rows[0]["maloaitaikhoan"]; switch (tk.MaLoaiTaiKhoan) { case 1: tk.LoaiTaiKhoan = LoaiTaiKhoan.Admin; Session.Add("taikhoan", tk); return Redirect("/Admin/CanHo"); case 2: tk.LoaiTaiKhoan = LoaiTaiKhoan.Member; Session.Add("taikhoan", tk); break; case 3: tk.LoaiTaiKhoan = LoaiTaiKhoan.Sales; Session.Add("taikhoan", tk); return Redirect("/Admin/"); }; switch ((int)dt.Rows[0]["trangthai"]) { case 0: tk.TrangThai = TrangThaiTaiKhoan.Deactive; break; case 1: tk.TrangThai = TrangThaiTaiKhoan.Active; break; } } else { ViewBag.Result = false; ViewBag.ErrorMessage = "Đăng nhập thất bại"; } } } catch (Exception ex) { ViewBag.Result = false; ViewBag.ErrorMessage = ex.Message; } return View("~/Views/Login/DangNhap.cshtml"); }
// hiển thị thông tin tài khoản // // POST/TaiKhoan/ChinhSuaTaiKhoan public ActionResult ChinhSuaTaiKhoan(int id) { if (isLogin() == -1) { return Redirect("/DangNhap"); } else if (isLogin() == 2) { return Redirect("/"); } else { try { string sql = @"SELECT * FROM taikhoan tk WHERE tk.mataikhoan = " + id.ToString(); DataProvider dp = new DataProvider(); DataTable dt = new DataTable(); dt = dp.ExecuteQuery(sql); TaiKhoan tk = new TaiKhoan(); if (dt.Rows.Count == 1) { tk.MaTaiKhoan = (int)dt.Rows[0]["mataikhoan"]; tk.Email = (string)dt.Rows[0]["email"]; tk.Ten = (string)dt.Rows[0]["ten"]; tk.NgaySinh = (DateTime)dt.Rows[0]["ngaysinh"]; tk.DiaChi = (string)dt.Rows[0]["diachi"]; tk.DienThoai = (string)dt.Rows[0]["dienthoai"]; tk.NgayDangKy = (DateTime)dt.Rows[0]["ngaydangky"]; tk.MaLoaiTaiKhoan = (int)dt.Rows[0]["maloaitaikhoan"]; switch (tk.MaLoaiTaiKhoan) { case 1: tk.LoaiTaiKhoan = LoaiTaiKhoan.Admin; break; case 2: tk.LoaiTaiKhoan = LoaiTaiKhoan.Member; break; case 3: tk.LoaiTaiKhoan = LoaiTaiKhoan.Sales; break; } tk.MaTrangThai = (int)dt.Rows[0]["trangthai"]; switch ((int)dt.Rows[0]["trangthai"]) { case 1: tk.TrangThai = TrangThaiTaiKhoan.Active; break; case 0: tk.TrangThai = TrangThaiTaiKhoan.Deactive; break; } return View("~/Views/Admin/TaiKhoan/ChinhSuaTaiKhoan.cshtml", tk); } return Redirect("/Admin/TaiKhoan/"); } catch (Exception ex) { return Redirect("/Admin/TaiKhoan/"); } } }
public ActionResult ChinhSuaTaiKhoan(TaiKhoan taikhoan) { if (isLogin() == -1) { return Redirect("/DangNhap"); } else if (isLogin() == 2) { return Redirect("/"); } else { try { DataProvider dp = new DataProvider(); SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@mataikhoan", SqlDbType.Int); param[0].Value = taikhoan.MaTaiKhoan; param[1] = new SqlParameter("@maloaitaikhoan", SqlDbType.Int); param[1].Value = taikhoan.MaLoaiTaiKhoan; param[2] = new SqlParameter("@trangthai", SqlDbType.Int); param[2].Value = taikhoan.MaTrangThai; dp.ExecuteProcNonQuery("sp_ChinhSuaTaiKhoan", ref param); ViewBag.ErrorMessage = "Cập nhật thành công!"; return Redirect("/Admin/TaiKhoan/"); } catch(Exception ex) { ViewBag.ErrorMessage = ""; return View("~/Views/Admin/TaiKhoan/ChinhSuaTaiKhoan.cshtml", taikhoan); } } }
// // GET: /TaiKhoan_/ public ActionResult Index() { if (isLogin() == -1) { return Redirect("/DangNhap"); } else if (isLogin() == 2) { return Redirect("/"); } else { try { DataProvider dp = new DataProvider(); int page = 1; if (Request.QueryString["page"] != null) { page = int.Parse(Request.QueryString["page"]); } SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@page", SqlDbType.Int); param[0].Value = page; param[1] = new SqlParameter("@pagesize", SqlDbType.Int); param[1].Value = RowPerPage; param[2] = new SqlParameter("@count", SqlDbType.Int); param[2].Value = DBNull.Value; // chưa biết giá trị nên cho nó bằng rỗng (= null) param[2].Direction = ParameterDirection.Output; DataTable dt = new DataTable(); dt = dp.ExecuteProcQuery("sp_DanhSachTaiKhoan", ref param); List<TaiKhoan> ls = new List<TaiKhoan>(); for (int i = 0; i < dt.Rows.Count; i++) { TaiKhoan tk = new TaiKhoan(); tk.MaTaiKhoan = (int)dt.Rows[i]["mataikhoan"]; tk.Email = (string)dt.Rows[i]["email"]; tk.MatKhau = (string)dt.Rows[i]["matkhau"]; switch((int)dt.Rows[i]["maloaitaikhoan"]) { case 1: tk.LoaiTaiKhoan = LoaiTaiKhoan.Admin; break; case 2: tk.LoaiTaiKhoan = LoaiTaiKhoan.Member; break; case 3: tk.LoaiTaiKhoan = LoaiTaiKhoan.Sales; break; } tk.Ten = (string)dt.Rows[i]["ten"]; tk.NgaySinh = (DateTime)dt.Rows[i]["ngaysinh"]; if (dt.Rows[i]["diachi"] != DBNull.Value) { tk.DiaChi = (string)dt.Rows[i]["diachi"]; } if (dt.Rows[i]["dienthoai"] != DBNull.Value) { tk.DienThoai = (string)dt.Rows[i]["dienthoai"]; } tk.NgayDangKy = (DateTime)dt.Rows[i]["ngaydangky"]; switch ((int)dt.Rows[i]["trangthai"]) { case 0: tk.TrangThai = TrangThaiTaiKhoan.Deactive; break; case 1: tk.TrangThai = TrangThaiTaiKhoan.Active; break; } ls.Add(tk); } ViewBag.RowPerPage = RowPerPage; ViewBag.Page = page; ViewBag.Count = (int)param[2].Value; return View("~/Views/Admin/TaiKhoan/Index.cshtml", ls); } catch(Exception ex) { ViewBag.ErrorMessage = ex.Message; return null; } } }
// // GET: /NhanGiaoDich_/ public ActionResult Index() { if (isLogin() == -1) { return Redirect("/DangNhap"); } else if (isLogin() == 2) { return Redirect("/"); } else { //*/ try { TaiKhoan tk = new TaiKhoan(); tk = (TaiKhoan)Session["taikhoan"]; DataProvider dp = new DataProvider(); int page = 1; if (Request.QueryString["page"] != null) { page = int.Parse(Request.QueryString["page"]); } SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@mataikhoan", SqlDbType.Int); param[0].Value = tk.MaTaiKhoan; param[1] = new SqlParameter("@page", SqlDbType.Int); param[1].Value = page; param[2] = new SqlParameter("@pagesize", SqlDbType.Int); param[2].Value = RowPerPage; param[3] = new SqlParameter("@count", SqlDbType.Int); param[3].Value = DBNull.Value; //Chua biet gia tri param[3].Direction = ParameterDirection.Output; DataTable dt = new DataTable(); dt = dp.ExecuteProcQuery("sp_DanhSachGiaoDich", ref param); List<GiaoDich> ls = new List<GiaoDich>(); for (int i = 0; i < dt.Rows.Count; i++) { GiaoDich item = new GiaoDich(); item.MaGiaoDich = (int)dt.Rows[i]["magiaodich"]; item.MaTaiKhoan = (int)dt.Rows[i]["mataikhoan"]; item.TenTaiKhoan = (String)dt.Rows[i]["ten"]; item.MaThueCanHo = (int)dt.Rows[i]["mathuecanho"]; item.MaTrangThaiGiaoDich = (int)dt.Rows[i]["matrangthaigiaodich"]; switch (item.MaTrangThaiGiaoDich) { case 1: item.TrangThaiGiaoDich = TrangThaiGiaoDich.Cho_Xac_Nhan; break; case 2: item.TrangThaiGiaoDich = TrangThaiGiaoDich.Dang_Giao_Dich; break; case 3: item.TrangThaiGiaoDich = TrangThaiGiaoDich.Da_Giao_Dich; break; case 4: item.TrangThaiGiaoDich = TrangThaiGiaoDich.Thanh_Toan_Hoan_Tat; break; case 5: item.TrangThaiGiaoDich = TrangThaiGiaoDich.Giao_Dich_Huy_Bo; break; } ls.Add(item); } ViewBag.RowPerPage = RowPerPage; ViewBag.Page = page; //Console.Write(param[3].Value.ToString()); ViewBag.Count = (int)param[3].Value; return View("~/Views/Admin/GiaoDich/Index.cshtml", ls); } catch (Exception ex) { ViewBag.ErrorMessage = ex.Message; return Redirect("/Admin/"); } //*/ } }
public ActionResult TaoCanHo(CanHo canho) { if (isLogin() == -1) { return Redirect("/DangNhap"); } else if (isLogin() == 2) { return Redirect("/"); } else { try { TaiKhoan tk = new TaiKhoan(); tk = (TaiKhoan)Session["taikhoan"]; canho.NguoiDang = tk.MaTaiKhoan; canho.NgayDang = DateTime.Now; SqlParameter[] param = new SqlParameter[10]; param[0] = new SqlParameter("@tencanho", SqlDbType.NVarChar); param[0].Value = canho.TenCanHo; param[1] = new SqlParameter("@maduong", SqlDbType.Int); param[1].Value = canho.MaDuong; param[2] = new SqlParameter("@diachi", SqlDbType.NVarChar); param[2].Value = canho.DiaChi; param[3] = new SqlParameter("@mieuta", SqlDbType.NVarChar); param[3].Value = canho.MieuTa; param[4] = new SqlParameter("@toado", SqlDbType.NVarChar); param[4].Value = canho.ToaDo; param[5] = new SqlParameter("@giathue", SqlDbType.Float); param[5].Value = canho.GiaThue; param[6] = new SqlParameter("@dientich", SqlDbType.Float); param[6].Value = canho.DienTich; param[7] = new SqlParameter("@matrangthaicanho", SqlDbType.Int); param[7].Value = canho.MaTrangThaiCanHo; param[8] = new SqlParameter("@ngaydang", SqlDbType.DateTime); param[8].Value = canho.NgayDang; param[9] = new SqlParameter("@nguoidang", SqlDbType.Int); param[9].Value = canho.NguoiDang; DataProvider dp = new DataProvider(); dp.ExecuteProcNonQuery("sp_TaoCanHo", ref param); ViewBag.ErrorMessage = "Đăng tin căn hộ thành công"; return Redirect("/Admin/CanHo/"); } catch (Exception ex) { List<ThanhPho> lsThanhPho = new List<ThanhPho>(); lsThanhPho = ThanhPhoController.ListThanhPho(); ViewBag.MaThanhPho = new SelectList(lsThanhPho, "mathanhpho", "tenthanhpho"); List<Quan> lsQuan = new List<Quan>(); lsQuan = QuanController.ListQuan(); ViewBag.MaQuan = new SelectList(lsQuan, "maquan", "tenquan"); List<Duong> lsDuong = new List<Duong>(); lsDuong = DuongController.ListDuong(); ViewBag.MaDuong = new SelectList(lsDuong, "maduong", "tenduong"); ViewBag.ErrorMessage = "Khởi tạo không thành công"; return View("~/Views/Admin/CanHo/TaoCanHo.cshtml"); } } }
public TaiKhoan isLogin() { if (Session["taikhoan"] != null) { TaiKhoan tk = new TaiKhoan(); tk = (TaiKhoan)Session["taikhoan"]; return tk; } return null; }
public ActionResult Index(TaiKhoan taikhoan) { try { if (taikhoan.MatKhau.Equals(taikhoan.XacNhanMatKhau)) { taikhoan.NgayDangKy = DateTime.Now; taikhoan.LoaiTaiKhoan = LoaiTaiKhoan.Member; taikhoan.TrangThai = TrangThaiTaiKhoan.Active; using (MD5 md5hash = MD5.Create()) { string hash = GetMd5Hash(md5hash, taikhoan.MatKhau); taikhoan.MatKhau = hash; } DataProvider dp = new DataProvider(); SqlParameter[] param = new SqlParameter[9]; param[0] = new SqlParameter("@email", SqlDbType.NVarChar); param[0].Value = taikhoan.Email; param[1] = new SqlParameter("@matkhau", SqlDbType.NVarChar); param[1].Value = taikhoan.MatKhau; param[2] = new SqlParameter("@maloaitaikhoan", SqlDbType.Int); param[2].Value = taikhoan.LoaiTaiKhoan; param[3] = new SqlParameter("@ten", SqlDbType.NVarChar); param[3].Value = taikhoan.Ten; param[4] = new SqlParameter("@ngaysinh", SqlDbType.DateTime); if (taikhoan.NgaySinh == null ) param[4].Value = DBNull.Value; else param[4].Value = taikhoan.NgaySinh; param[5] = new SqlParameter("@diachi", SqlDbType.NVarChar); if (taikhoan.DiaChi == null) { param[5].Value = DBNull.Value; } else { param[5].Value = taikhoan.DiaChi; } param[6] = new SqlParameter("@dienthoai", SqlDbType.NVarChar); if (taikhoan.DienThoai == null) { param[6].Value = DBNull.Value; } else { param[6].Value = taikhoan.DienThoai; } param[7] = new SqlParameter("@ngaydangky", SqlDbType.DateTime); param[7].Value = taikhoan.NgayDangKy; param[8] = new SqlParameter("@trangthai", SqlDbType.Int); param[8].Value = (int)taikhoan.TrangThai; dp.ExecuteProcNonQuery("sp_DangKyTaiKhoan",ref param); ViewBag.Result = true; ViewBag.ErrorMessage = ""; } else { ViewBag.Result = false; ViewBag.ErrorMessage = "Xác nhận mật khẩu không trùng khớp"; } } catch (Exception ex) { ViewBag.Result = false; ViewBag.ErrorMessage = ex.Message; } return View("~/Views/Login/DangKy.cshtml"); }