public JsonResult DeleteBuild(int id)
{
ApiResult result = new ApiResult();
using (BDSEntities db = new BDSEntities())
{
var build = db.BUILDINGs.Where(x => x.idBuild == id).FirstOrDefault();
if (build is null)
{
result.Message = "Vui lòng thử lại";
return(Json(result));
}
try
{
db.Database.ExecuteSqlCommand("delete from IMAGE where IdBuild=" + id);
db.BUILDINGs.Remove(build);
db.SaveChanges();
result.Success = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Json(result));
}
public JsonResult SaveImg(int id, HttpPostedFileBase file)
{
if (file == null)
{
ViewBag.Error = "Vui lòng chọn ảnh!";
}
else
{
if (file != null)
{
var fileName = DateTime.Now.ToFileTimeUtc() + ".png";
var path = Path.Combine(Server.MapPath("~/Images/"), fileName);
file.SaveAs(path);
using (BDSEntities db = new BDSEntities())
{
db.Database.ExecuteSqlCommand("delete from IMAGE where IdBuild=" + id);
IMAGE img = new IMAGE();
img.nameImage = fileName;
img.idBuild = id;
db.IMAGEs.Add(img);
db.SaveChanges();
}
}
}
int response = 1;
return(Json(response, JsonRequestBehavior.AllowGet));
}
public JsonResult PostChangePassword(string oldPass, string newPass)
{
ApiResult result = new ApiResult();
if (String.IsNullOrEmpty(oldPass) || String.IsNullOrEmpty(newPass))
{
result.Message = "Vui lòng điền đầy đủ thông tin bên trên";
return(Json(result.Data));
}
using (BDSEntities db = new BDSEntities())
{
var user = (USER)Session["AdminLogin"];
var userDB = db.USERs.Where(x => x.idUser == user.idUser).FirstOrDefault();
if (userDB is null)
{
result.Message = "Vui lòng thử lại";
return(Json(result));
}
userDB.userPassword = newPass;
try
{
db.SaveChanges();
result.Success = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Json(result));
}
public JsonResult <List <TOANHA> > Building()
{
List <TOANHA> result = new List <TOANHA>();
using (BDSEntities db = new BDSEntities())
{
var lstBuild = db.BUILDINGs.ToList();
foreach (var build in lstBuild)
{
TOANHA b = new TOANHA();
b.idBuild = build.idBuild;
b.nameBuild = build.nameBuild;
b.nameManager = build.nameManager;
b.phoneManager = build.phoneManager;
b.price = (decimal)build.price;
b.street = build.street;
b.floor = (int)build.floor;
b.conent = build.conent;
b.depositDate = build.depositDate;
b.deposits = build.deposits;
b.floorarea = (decimal)build.floorarea;
b.HinhAnh = build.IMAGEs.FirstOrDefault().nameImage;
result.Add(b);
}
}
return(Json(result));
}
public JsonResult <List <TOANHA> > GetBuilding(int id)
{
List <TOANHA> result = new List <TOANHA>();
using (BDSEntities db = new BDSEntities())
{
var lstBuild = db.BUILDINGs.Where(x => x.idBuild == id).FirstOrDefault();
TOANHA b = new TOANHA();
b.idBuild = lstBuild.idBuild;
b.idWard = lstBuild.idWard;
b.idHuong = lstBuild.idHuong ?? 0;
b.idType = lstBuild.idType;
b.idUser = lstBuild.idUser;
b.idStatus = lstBuild.idStatus ?? 0;
b.nameBuild = lstBuild.nameBuild;
b.nameManager = lstBuild.nameManager;
b.phoneManager = lstBuild.phoneManager;
b.price = (decimal)lstBuild.price;
b.street = lstBuild.street;
b.floor = (int)lstBuild.floor;
b.conent = lstBuild.conent;
b.depositDate = lstBuild.depositDate;
b.deposits = lstBuild.deposits;
b.floorarea = (decimal)lstBuild.floorarea;
result.Add(b);
}
return(Json(result));
}
public JsonResult DeletePhieu(int id)
{
ApiResult result = new ApiResult();
using (BDSEntities db = new BDSEntities())
{
var phieu = db.PHIEUHENs.Where(x => x.idPhieu == id).FirstOrDefault();
if (phieu is null)
{
result.Message = "Vui lòng thử lại";
return(Json(result));
}
try
{
db.PHIEUHENs.Remove(phieu);
db.SaveChanges();
result.Success = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Json(result));
}
public JsonResult <ApiResult> Login(USER data)
{
ApiResult result = new ApiResult();
try
{
if (String.IsNullOrEmpty(data.userName) || String.IsNullOrEmpty(data.userPassword))
{
throw new Exception("Vui lòng nhập đầy đủ thông tin đăng nhập");
}
using (BDSEntities db = new BDSEntities())
{
data.userPassword = db.proc_CryptData(data.userPassword).FirstOrDefault();
if (!db.USERs.Any(x => x.userName.Equals(data.userName) && x.userPassword.Equals(data.userPassword)))
{
result.Message = "Tài khoản hoặc mật khẩu không chính xác, vui lòng kiểm tra lại";
return(Json(result));
}
var userDB = db.USERs.Where(x => x.userName.Equals(data.userName) && x.userPassword.Equals(data.userPassword)).FirstOrDefault();
if (data is null)
{
result.Message = "Tài khoản không tồn tại!";
}
result.Data = userDB.idUser.ToString();
result.Success = true;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(Json(result));
}
public JsonResult DeleteKH(int id)
{
ApiResult result = new ApiResult();
using (BDSEntities db = new BDSEntities())
{
var kh = db.CUSTOMERs.Where(x => x.idCustom == id).FirstOrDefault();
if (kh is null)
{
result.Message = "Vui lòng thử lại";
return(Json(result));
}
var phieuhen = db.PHIEUHENs.Where(x => x.idCustom == kh.idCustom).FirstOrDefault();
try
{
db.PHIEUHENs.Remove(phieuhen);
db.SaveChanges();
db.CUSTOMERs.Remove(kh);
db.SaveChanges();
result.Success = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Json(result));
}
public JsonResult DeleteNews(int id)
{
ApiResult result = new ApiResult();
using (BDSEntities db = new BDSEntities())
{
var news = db.NEWS.Where(x => x.idNews == id).FirstOrDefault();
if (news is null)
{
result.Message = "Vui lòng thử lại";
return(Json(result));
}
try
{
db.NEWS.Remove(news);
db.SaveChanges();
result.Success = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Json(result));
}
public string DeleteRole(int id)
{
if (Session["AdminLogin"] is null)
{
return(null);
}
using (BDSEntities db = new BDSEntities())
{
var role = db.ROLEs.Where(x => x.idRole == id).FirstOrDefault();
if (role is null)
{
return("Không tìm thấy đối tượng này");
}
db.ROLEs.Remove(role);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
}
return("ok");
}
public JsonResult DeleteUser(int id)
{
ApiResult result = new ApiResult();
using (BDSEntities db = new BDSEntities())
{
var user = db.USERs.Where(x => x.idUser == id).FirstOrDefault();
if (user is null)
{
result.Message = "Vui lòng thử lại";
return(Json(result));
}
try
{
db.USERs.Remove(user);
db.SaveChanges();
result.Success = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Json(result));
}
public ActionResult AdminLogin(USER user)
{
if (db is null)
{
return(HttpNotFound());
}
if (String.IsNullOrEmpty(user.userName) || String.IsNullOrEmpty(user.userPassword))
{
ViewBag.Error = "Vui lòng nhập thông tin";
return(View("AdminLogin"));
}
using (BDSEntities db = new BDSEntities())
{
user.userPassword = db.proc_CryptData(user.userPassword).FirstOrDefault();
var adlogin = db.USERs.Where(x => x.userName.Equals(user.userName.ToLower().Trim()) && x.userPassword.Equals(user.userPassword)).FirstOrDefault();
if (adlogin is null)
{
ViewBag.Error = "Sai thông tin đăng nhập";
return(View("AdminLogin"));
}
Session["AdminLogin"] = adlogin;
int idRole = ((USER)Session["AdminLogin"]).idRole;
if (idRole != 1 && idRole != 2)
{
ViewBag.Error2 = "Không đủ quyền truy cập !!!";
return(View("AdminLogin"));
}
return(RedirectToAction("Index", "Admin"));
}
}
public JsonResult PostBuild(BUILDING build)
{
ApiResult result = new ApiResult();
if (build is null)
{
result.Message = "Vui lòng điền đầy đủ thông tin bên trên";
return(Json(result.Data));
}
using (BDSEntities db = new BDSEntities())
{
BUILDING b = new BUILDING();
if (build.idBuild > 0)
{
b = db.BUILDINGs.Where(x => x.idBuild == build.idBuild).FirstOrDefault();
}
if (b is null)
{
result.Message = "Vui lòng thử lại";
return(Json(result));
}
var huong = db.HUONGs.Where(x => x.idHuong == build.idHuong).FirstOrDefault();
b.nameBuild = build.nameBuild;
b.floor = build.floor;
b.floorarea = build.floorarea;
b.idHuong = build.idHuong;
b.nameManager = build.nameManager;
b.phoneManager = build.phoneManager;
b.conent = build.conent;
b.street = build.street;
b.deposits = build.deposits;
b.depositDate = build.depositDate;
b.idUser = build.idUser;
b.idWard = build.idWard;
b.idType = build.idType;
b.idStatus = build.idStatus;
b.price = build.price;
b.idHuong = build.idHuong;
if (build.idBuild == 0)
{
db.BUILDINGs.Add(b);
}
try
{
db.SaveChanges();
result.Success = true;
result.Message = b.idBuild + "";
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Json(result));
}
public JsonResult PostPhieuHen2(PHIEUHEN ph, string phone, string cusname, string email)
{
ApiResult result = new ApiResult();
if (ph is null)
{
result.Message = "Vui lòng điền đầy đủ thông tin bên trên";
return(Json(result.Data));
}
using (BDSEntities db = new BDSEntities())
{
PHIEUHEN p = new PHIEUHEN();
if (ph.idPhieu > 0)
{
p = db.PHIEUHENs.Where(x => x.idPhieu == ph.idPhieu).FirstOrDefault();
}
if (p is null)
{
result.Message = "Vui lòng thử lại";
return(Json(result));
}
var kh = db.CUSTOMERs.Where(x => x.phoneCustom.Equals(phone)).FirstOrDefault();
if (kh == null)
{
kh = new CUSTOMER();
kh.nameCustom = cusname;
kh.phoneCustom = phone;
kh.emailCustom = email;
db.CUSTOMERs.Add(kh);
db.SaveChanges();
}
p.ngayhen = ph.ngayhen;
p.idBuild = ph.idBuild;
p.contentPhieu = ph.contentPhieu;
p.idUserNV = ph.idUserNV;
p.createPhieu = DateTime.Now;
p.idCustom = kh.idCustom;
if (ph.idPhieu == 0)
{
db.PHIEUHENs.Add(p);
}
try
{
db.SaveChanges();
result.Success = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Json(result));
}
public JsonResult GetUser(int id)
{
using (BDSEntities db = new BDSEntities())
{
var user = db.USERs.Where(x => x.idUser == id).FirstOrDefault();
if (user is null)
{
return(null);
}
return(new JsonResult()
{
Data = new { USERNAME = user.userName, PASSWORD = user.userPassword, FULLNAME = user.FullName, PHONE = user.Phone, EMAIL = user.Email, DIACHI = user.Address, ROLE = user.idRole },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult <List <CUSTOMER> > GetCustom(int id)
{
List <CUSTOMER> result = new List <CUSTOMER>();
using (BDSEntities db = new BDSEntities())
{
var khachhang = db.CUSTOMERs.Where(x => x.idCustom == id).FirstOrDefault();
CUSTOMER k = new CUSTOMER();
k.idCustom = khachhang.idCustom;
k.nameCustom = khachhang.nameCustom;
k.phoneCustom = khachhang.phoneCustom;
k.addressCustom = khachhang.addressCustom;
k.emailCustom = khachhang.emailCustom;
result.Add(k);
}
return(Json(result));
}
public JsonResult GetCustomer(string phone)
{
using (BDSEntities db = new BDSEntities())
{
var customer = db.CUSTOMERs.Where(x => x.phoneCustom.Equals(phone)).FirstOrDefault();
if (customer is null)
{
return(null);
}
return(new JsonResult()
{
Data = new { NAME = customer.nameCustom, SDT = customer.phoneCustom, EMAIL = customer.emailCustom },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult PostUser(USER user)
{
ApiResult result = new ApiResult();
if (user is null)
{
result.Message = "Vui lòng điền đầy đủ thông tin bên trên";
return(Json(result.Data));
}
using (BDSEntities db = new BDSEntities())
{
USER u = new USER();
if (user.idUser > 0)
{
u = db.USERs.Where(x => x.idUser == user.idUser).FirstOrDefault();
}
if (u is null)
{
result.Message = "Vui lòng thử lại";
return(Json(result));
}
u.FullName = user.FullName;
u.userName = user.userName;
u.userPassword = user.userPassword;
u.Phone = user.Phone;
u.Email = user.Email;
u.Address = user.Address;
u.idRole = user.idRole;
if (user.idUser == 0)
{
db.USERs.Add(u);
}
try
{
db.SaveChanges();
result.Success = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Json(result));
}
public JsonResult <List <NEWS> > GetNews(int id)
{
List <NEWS> result = new List <NEWS>();
using (BDSEntities db = new BDSEntities())
{
var tintuc = db.NEWS.Where(x => x.idNews == id).FirstOrDefault();
var nhanvien = db.USERs.Where(x => x.idUser == tintuc.idUser).FirstOrDefault();
NEWS n = new NEWS();
n.idNews = tintuc.idNews;
n.idUser = nhanvien.idUser;
n.Description = tintuc.Description;
n.titleNews = tintuc.titleNews;
n.Img = tintuc.Img;
n.createDate = tintuc.createDate;
result.Add(n);
}
return(Json(result));
}
public JsonResult PostKH(CUSTOMER kh)
{
ApiResult result = new ApiResult();
if (kh is null)
{
result.Message = "Vui lòng điền đầy đủ thông tin bên trên";
return(Json(result.Data));
}
using (BDSEntities db = new BDSEntities())
{
CUSTOMER k = new CUSTOMER();
if (kh.idCustom > 0)
{
k = db.CUSTOMERs.Where(x => x.idCustom == kh.idCustom).FirstOrDefault();
}
if (k is null)
{
result.Message = "Vui lòng thử lại";
return(Json(result));
}
k.nameCustom = kh.nameCustom;
k.phoneCustom = kh.phoneCustom;
k.addressCustom = kh.addressCustom;
k.emailCustom = kh.emailCustom;
if (kh.idCustom == 0)
{
db.CUSTOMERs.Add(k);
}
try
{
db.SaveChanges();
result.Success = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Json(result));
}
public JsonResult <List <CUSTOMER> > Custom()
{
List <CUSTOMER> result = new List <CUSTOMER>();
using (BDSEntities db = new BDSEntities())
{
var lstKH = db.CUSTOMERs.ToList();
foreach (var kh in lstKH)
{
CUSTOMER k = new CUSTOMER();
k.idCustom = kh.idCustom;
k.nameCustom = kh.nameCustom;
k.emailCustom = kh.emailCustom;
k.addressCustom = kh.addressCustom;
k.phoneCustom = kh.phoneCustom;
result.Add(k);
}
}
return(Json(result));
}
public JsonResult <List <NEWS> > News()
{
List <NEWS> result = new List <NEWS>();
using (BDSEntities db = new BDSEntities())
{
var lstnews = db.NEWS.ToList();
foreach (var news in lstnews)
{
NEWS n = new NEWS();
n.idNews = news.idNews;
n.Description = news.Description;
n.titleNews = news.titleNews;
n.Img = news.Img;
n.createDate = news.createDate;
result.Add(n);
}
}
return(Json(result));
}
public string EditPosition(ROLE role)
{
if (Session["AdminLogin"] is null)
{
return("");
}
var user = (USER)Session["AdminLogin"];
if (String.IsNullOrEmpty(user.userName))
{
return("Vui lòng không bỏ trống thông tin");
}
using (BDSEntities db = new BDSEntities())
{
ROLE r = new ROLE();
if (role.idRole > 0)
{
r = db.ROLEs.Where(x => x.idRole == role.idRole).FirstOrDefault();
}
if (r is null)
{
return("Dữ liệu bất thường vui lòng thử lại sau");
}
r.idRole = role.idRole;
r.nameRole = role.nameRole;
if (role.idRole == 0)
{
db.ROLEs.Add(r);
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
}
return("ok");
}
public JsonResult GetNews(int id)
{
if (Session["AdminLogin"] is null)
{
return(null);
}
using (BDSEntities db = new BDSEntities())
{
var news = db.NEWS.Where(x => x.idNews == id).FirstOrDefault();
if (news is null)
{
return(null);
}
return(new JsonResult()
{
Data = new { TITLE = news.titleNews, NOIDUNG = news.Description, HINH = news.Img },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult GetKH(int id)
{
if (Session["AdminLogin"] is null)
{
return(null);
}
using (BDSEntities db = new BDSEntities())
{
var kh = db.CUSTOMERs.Where(x => x.idCustom == id).FirstOrDefault();
if (kh is null)
{
return(null);
}
return(new JsonResult()
{
Data = new { NAME = kh.nameCustom, PHONE = kh.phoneCustom, EMAIL = kh.emailCustom, ADDRESS = kh.addressCustom },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult GetPosition(int id)
{
if (Session["AdminLogin"] is null)
{
return(null);
}
using (BDSEntities db = new BDSEntities())
{
var role = db.ROLEs.Where(x => x.idRole == id).FirstOrDefault();
if (role is null)
{
return(null);
}
return(new JsonResult()
{
Data = new { NAME = role.nameRole },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult <List <BILL> > Bill()
{
List <BILL> result = new List <BILL>();
using (BDSEntities db = new BDSEntities())
{
var lshopdong = db.BILLs.ToList();
foreach (var hopdong in lshopdong)
{
BILL bill = new BILL();
bill.idBill = hopdong.idBill;
bill.kyten = hopdong.kyten;
bill.totalPrice = hopdong.totalPrice;
bill.ngayKyTen = hopdong.ngayKyTen;
bill.idCustom = hopdong.idCustom;
bill.idUserNV = hopdong.idUserNV;
result.Add(bill);
}
}
return(Json(result));
}
public JsonResult GetBill(int id)
{
if (Session["AdminLogin"] is null)
{
return(null);
}
using (BDSEntities db = new BDSEntities())
{
var bill = db.BILLs.Where(x => x.idBill == id).FirstOrDefault();
string GiaTien = String.Format("{0:N0}", bill.totalPrice);
if (bill is null)
{
return(null);
}
return(new JsonResult()
{
Data = new { NAME = bill.CUSTOMER.nameCustom, PHONE = bill.CUSTOMER.phoneCustom, BUILD = bill.BUILDING.nameBuild, PRICE = GiaTien, NAMEQL = bill.BUILDING.nameManager, CREATEDATE = bill.createDate.Value.ToString("dd/MM/yyyy"), HINH = bill.cmndTruoc, MOTA = bill.content, DIACHI = bill.BUILDING.street, TANG = bill.BUILDING.floor, DIENTICH = bill.BUILDING.floorarea },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult GetPhieu(int id)
{
if (Session["AdminLogin"] is null)
{
return(null);
}
using (BDSEntities db = new BDSEntities())
{
var phieu = db.PHIEUHENs.Where(x => x.idPhieu == id).FirstOrDefault();
var build = db.BUILDINGs.Where(x => x.idBuild == phieu.idBuild).FirstOrDefault();
var idKH = db.CUSTOMERs.Where(x => x.idCustom == phieu.idCustom).FirstOrDefault();
if (phieu == null)
{
return(null);
}
return(new JsonResult()
{
Data = new { CONTENT = phieu.contentPhieu, NGAYHEN = phieu.ngayhen.Value.ToString(" HH:mm dd/MM/yyyy"), NGAYTAO = phieu.createPhieu.Value.ToString("HH:mm dd/MM/yyyy"), BUILD = build.nameBuild, SDT = idKH.nameCustom, EMAIL = idKH.emailCustom },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult GetBuild(int id)
{
using (BDSEntities db = new BDSEntities())
{
var build = db.BUILDINGs.Where(x => x.idBuild == id).FirstOrDefault();
var phuong = db.WARDs.Where(x => x.idWard == build.idWard).FirstOrDefault();
var quan = db.DISTRICTs.Where(x => x.idDistrict == phuong.idDistrict).FirstOrDefault();
var city = db.CITies.Where(x => x.idCity == quan.idCity).FirstOrDefault();
var huong = db.HUONGs.Where(x => x.idHuong == build.idHuong).FirstOrDefault();
var loai = db.TYPEs.Where(x => x.idType == build.idType).FirstOrDefault();
var nhanvien = db.USERs.Where(x => x.idUser == build.idUser).FirstOrDefault();
var hinh = db.IMAGEs.Where(x => x.idBuild == build.idBuild).FirstOrDefault();
//var hinh = db.IMAGEs.Where(x => x.idImage == id).FirstOrDefault();
if (build is null)
{
return(null);
}
return(new JsonResult()
{
Data = new { NAME = build.nameBuild, CITY = city.idCity, QUAN = quan.idDistrict, HINHANH = hinh.nameImage, PHUONG = phuong.idWard, DIACHI = build.street, MOTA = build.conent, TANG = build.floor, DIENTICH = build.floorarea, HUONG = huong.idHuong, MANAGER = build.nameManager, PHONE = build.phoneManager, LOAI = loai.idType, STATUS = build.idStatus, GIA = build.price, DATCOC = build.deposits, NHANVIEN = nhanvien.idUser, DATE = build.depositDate },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
