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