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/"); } } }
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); } } }
public ActionResult XacNhanXoaCanHo(int id) { if (isLogin() == -1) { return Redirect("/DangNhap"); } else if (isLogin() == 2) { return Redirect("/"); } else { try { DataProvider dp = new DataProvider(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@macanho", SqlDbType.Int); param[0].Value = id; dp.ExecuteProcNonQuery("sp_XoaCanHo", ref param); ViewBag.ErrorMessage = ""; return Redirect("/Admin/CanHo/"); } catch (Exception ex) { ViewBag.ErrorMessage = ex.Message; return Redirect("/Admin/CanHo/"); } } }
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 ActionResult ChinhSuaCanHo(CanHo canho, string chkSuaLoi, string chkDirtyRead) { if (isLogin() == -1) { return Redirect("/DangNhap"); } else if (isLogin() == 2) { return Redirect("/"); } else { //*/ try { ViewBag.chkDirtyRead = chkDirtyRead; ViewBag.chkSuaLoi = chkSuaLoi; DataProvider dp = new DataProvider(); SqlParameter[] param = new SqlParameter[9]; param[0] = new SqlParameter("@macanho", SqlDbType.Int); param[0].Value = canho.MaCanHo; param[1] = new SqlParameter("@tencanho", SqlDbType.NVarChar); param[1].Value = canho.TenCanHo; param[2] = new SqlParameter("@maduong", SqlDbType.Int); param[2].Value = canho.MaDuong; param[3] = new SqlParameter("@diachi", SqlDbType.NVarChar); param[3].Value = canho.DiaChi; param[4] = new SqlParameter("@mieuta", SqlDbType.NVarChar); param[4].Value = canho.MieuTa; param[5] = new SqlParameter("@toado", SqlDbType.NVarChar); param[5].Value = canho.ToaDo; param[6] = new SqlParameter("@giathue", SqlDbType.Float); param[6].Value = canho.GiaThue; param[7] = new SqlParameter("@dientich", SqlDbType.Float); param[7].Value = canho.DienTich; param[8] = new SqlParameter("@matrangthaicanho", SqlDbType.Int); param[8].Value = canho.MaTrangThaiCanHo; if (chkSuaLoi != null) { //Set level = Serializable để giải quyết Unrepeatable Read dp.ExecuteProcNonQuery("sp_ChinhSuaCanHo_Fixed", ref param); } else if (chkDirtyRead != null) { //Set waitfor delay dp.ExecuteProcNonQuery("sp_ChinhSuaCanHo_DirtyRead", ref param); } else { //Set level = ReadCommitted mức mặc định dp.ExecuteProcNonQuery("sp_ChinhSuaCanHo", ref param); } ViewBag.ErrorMessage = "Cập nhật 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", canho.MaDuong); ViewBag.ErrorMessage = ex.Message; return View("~/Views/Admin/CanHo/ChinhSuaCanHo.cshtml", canho); } //*/ } }
public ActionResult Index(string txtNgayBatDauThue, int txtThoiGianThue, string txtNgayKetThuc, double txtTienThue, double txtGiamGia, double txtTienPhaiTra, double txtTienCoc, string txtHoTen, string txtEmail, string txtDiaChi, string txtDienThoai) { TaiKhoan tk = isLogin(); if (tk == null) { return Redirect("/DangNhap"); } int maCanHo = 0; CanHo ch = new CanHo(); if (!Int32.TryParse(Request.Params["id"], out maCanHo)) { ch.MaTrangThaiCanHo = -999; return null; } DateTime ngaybatdau = DateTime.ParseExact(txtNgayBatDauThue, "yyyy-M-d", null); DateTime ngayketthuc = DateTime.ParseExact(txtNgayKetThuc, "d/M/yyyy", null); DataProvider dp = new DataProvider(); SqlParameter[] param = new SqlParameter[9]; param[0] = new SqlParameter("@mataikhoan", SqlDbType.Int); param[0].Value = tk.MaTaiKhoan; param[1] = new SqlParameter("@macanho", SqlDbType.Int); param[1].Value = maCanHo; param[2] = new SqlParameter("@tiencoc", SqlDbType.Float); param[2].Value = txtTienCoc; param[3] = new SqlParameter("@thoigianthue", SqlDbType.DateTime); param[3].Value = ngaybatdau; param[4] = new SqlParameter("@thoigiankethuc", SqlDbType.DateTime); param[4].Value = ngayketthuc; param[5] = new SqlParameter("@thoigiangiaodich", SqlDbType.DateTime); param[5].Value = DateTime.Now; param[6] = new SqlParameter("@dienthoai", SqlDbType.NVarChar); param[6].Value = txtDienThoai; param[7] = new SqlParameter("@diachi", SqlDbType.NVarChar); param[7].Value = txtDiaChi; param[8] = new SqlParameter("@ghichu", SqlDbType.Text); param[8].Value = ""; ViewBag.taiKhoan = tk; ViewBag.ketQuaThueCanHo = dp.ExecuteProcNonQuery("sp_thuecanho", ref param); ViewBag.isThueCanHo = true; return View("~/Views/Shared/DatThueCanHo.cshtml", new CanHo()); }