public static GiaoDich DanhSachGiaoDichThueCanHo(int mathuecanho) { try { GiaoDich item = new GiaoDich(); DataProvider dp = new DataProvider(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@mathuecanho", SqlDbType.Int); param[0].Value = mathuecanho; DataTable dt = new DataTable(); dt = dp.ExecuteProcQuery("sp_DanhSachNhanGiaoDichThueCanHo", ref param); if (dt.Rows.Count > 0) { item.MaGiaoDich = (int)dt.Rows[0]["magiaodich"]; item.MaTaiKhoan = (int)dt.Rows[0]["mataikhoan"]; item.TenTaiKhoan = (String)dt.Rows[0]["ten"]; item.MaLoaiTaiKhoan = (int)dt.Rows[0]["maloaitaikhoan"]; item.MaThueCanHo = (int)dt.Rows[0]["mathuecanho"]; item.MaTrangThaiGiaoDich = (int)dt.Rows[0]["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; } return item; } else return null; } catch (Exception ex) { throw ex; } }
// // GET: /ThueCanHo/ 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; //Chua biet gia tri param[2].Direction = ParameterDirection.Output; DataTable dt = new DataTable(); dt = dp.ExecuteProcQuery("sp_DanhSachThueCanHo", ref param); List<ThueCanHo> ls = new List<ThueCanHo>(); for (int i = 0; i < dt.Rows.Count; i++) { ThueCanHo item = new ThueCanHo(); item.MaThueCanHo = (int)dt.Rows[i]["mathuecanho"]; item.MaTaiKhoan = (int)dt.Rows[i]["mataikhoan"]; item.TenTaiKhoan = (string)dt.Rows[i]["ten"]; item.MaCanHo = (int)dt.Rows[i]["macanho"]; item.TenCanHo = (string)dt.Rows[i]["tencanho"]; item.TienCoc = (double)dt.Rows[i]["tiencoc"]; item.ThoiGianThue = (DateTime)dt.Rows[i]["thoigianthue"]; item.ThoiGianKetThuc = (DateTime)dt.Rows[i]["thoigianketthuc"]; item.ThoiGianGiaoDich = (DateTime)dt.Rows[i]["thoigiangiaodich"]; if (dt.Rows[i]["dienthoai"] != DBNull.Value) { item.DienThoai = (string)dt.Rows[i]["dienthoai"]; } if (dt.Rows[i]["diachi"] != DBNull.Value) { item.DiaChi = (string)dt.Rows[i]["diachi"]; } if (dt.Rows[i]["ghichu"] != DBNull.Value) { item.GhiChu = (string)dt.Rows[i]["ghichu"]; } item.KichHoat = (int)dt.Rows[i]["kichhoat"]; ls.Add(item); } ViewBag.RowPerPage = RowPerPage; ViewBag.Page = page; ViewBag.Count = (int)param[2].Value; return View("~/Views/Admin/ThueCanHo/Index.cshtml", ls); } catch (Exception ex) { ViewBag.ErrorMessage = ex.Message; return null; } //*/ } }
public ActionResult ChiTietThueCanHo(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("@mathuecanho", SqlDbType.Int); param[0].Value = id; DataTable dt = new DataTable(); dt = dp.ExecuteProcQuery("sp_ChiTietThueCanHo", ref param); ThueCanHo item = new ThueCanHo(); if (dt.Rows.Count > 0) { item.MaThueCanHo = (int)dt.Rows[0]["mathuecanho"]; item.MaTaiKhoan = (int)dt.Rows[0]["mataikhoan"]; item.TenTaiKhoan = (string)dt.Rows[0]["ten"]; item.MaCanHo = (int)dt.Rows[0]["macanho"]; item.TenCanHo = (string)dt.Rows[0]["tencanho"]; item.TienCoc = (double)dt.Rows[0]["tiencoc"]; item.ThoiGianThue = (DateTime)dt.Rows[0]["thoigianthue"]; item.ThoiGianKetThuc = (DateTime)dt.Rows[0]["thoigianketthuc"]; item.ThoiGianGiaoDich = (DateTime)dt.Rows[0]["thoigiangiaodich"]; if (dt.Rows[0]["dienthoai"] != DBNull.Value) { item.DienThoai = (string)dt.Rows[0]["dienthoai"]; } if (dt.Rows[0]["diachi"] != DBNull.Value) { item.DiaChi = (string)dt.Rows[0]["diachi"]; } if (dt.Rows[0]["ghichu"] != DBNull.Value) { item.GhiChu = (string)dt.Rows[0]["ghichu"]; } item.KichHoat = (int)dt.Rows[0]["kichhoat"]; } GiaoDich gd = GiaoDichController.DanhSachGiaoDichThueCanHo(item.MaThueCanHo); if (gd != null) { ViewBag.DanhSachGiaoDich = gd; } return View("~/Views/Admin/ThueCanHo/ChiTietThueCanHo.cshtml", item); } 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); }
// // 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/"); } //*/ } }
// // GET: /CanHo/ 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; param[2].Direction = ParameterDirection.Output; DataTable dt = new DataTable(); dt = dp.ExecuteProcQuery("sp_DanhSachCanHo", ref param); List<CanHo> ls = new List<CanHo>(); for (int i = 0; i < dt.Rows.Count; i++) { CanHo item = new CanHo(); item.MaCanHo = (int)dt.Rows[i]["macanho"]; item.TenCanHo = (string)dt.Rows[i]["tencanho"]; item.MaDuong = (int)dt.Rows[i]["maduong"]; item.DiaChi = (string)dt.Rows[i]["diachi"]; if (dt.Rows[i]["mieuta"] != DBNull.Value) { item.MieuTa = (string)dt.Rows[i]["mieuta"]; } item.ToaDo = (string)dt.Rows[i]["toado"]; item.GiaThue = (double)dt.Rows[i]["giathue"]; item.DienTich = (double)dt.Rows[i]["dientich"]; switch ((int)dt.Rows[i]["matrangthaicanho"]) { case 1: item.TrangThaiCanHo = TrangThaiCanHo.Da_Duoc_Thue; break; case 2: item.TrangThaiCanHo = TrangThaiCanHo.Chua_Duoc_Thue; break; case 3: item.TrangThaiCanHo = TrangThaiCanHo.Dang_Xay_Dung; break; } item.NgayDang = (DateTime)dt.Rows[i]["ngaydang"]; item.NguoiDang = (int)dt.Rows[i]["nguoidang"]; if (dt.Rows[i]["ghichu"] != DBNull.Value) { item.GhiChu = (string)dt.Rows[i]["ghichu"]; } item.KichHoat = (int)dt.Rows[i]["kichhoat"]; ls.Add(item); } ViewBag.RowPerPage = RowPerPage; ViewBag.Page = page; //Console.Write(param[3].Value.ToString()); ViewBag.Count = (int)param[2].Value; return View("~/Views/Admin/CanHo/Index.cshtml", ls); } catch (Exception ex) { ViewBag.ErrorMessage = ex.Message; return Redirect("/Admin/"); } } }