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");
}
