public ActionResult DeleteConfirmed(string id) { THUEPHONG tHUEPHONG = db.THUEPHONGS.Find(id); db.THUEPHONGS.Remove(tHUEPHONG); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MaKH,NgayDen,NgayDi,ThanhToan")] THUEPHONG tHUEPHONG) { if (ModelState.IsValid) { db.Entry(tHUEPHONG).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tHUEPHONG)); }
public THUEPHONG GetId(int maTP) { THUEPHONG tp = new THUEPHONG(); using (SqlConnection connection = con()) { tp = (THUEPHONG)connection.Query <THUEPHONG>($"SELECT MaSoThue,KHACHHANG.maKH,PHONGTRO.MaPhongTro,KHACHHANG.TenKH,NgayThue,THUEPHONG.trangThai,PHONGTRO.TenPhongTro,TienCoc,PHONGTRO.GiaPhong From THUEPHONG,PHONGTRO,KHACHHANG where THUEPHONG.MaPhongTro=PHONGTRO.MaPhongTro and THUEPHONG.maKH=KHACHHANG.maKH and MaSoThue={maTP}").FirstOrDefault(); return(tp); } }
public int Update(THUEPHONG tp) { int count = 0; using (SqlConnection connection = con()) { count = connection.Execute("UPDATE THUEPHONG SET maKH =@maKH, NgayThue= @NgayThue, trangThai=@trangThai,MaPhongTro=@MaPhongTro,TienCoc=@TienCoc WHERE MaSoThue=@MaSoThue", tp); } return(count); }
public THUEPHONG LoadPhieu(int?id) { if (id == null) { return(null); } DataTable data = DataProvider.Instance.ExcuteQuery("pSearchThuePhong @id ", new object[] { id }); THUEPHONG tam = new THUEPHONG(data.Rows[0]); return(null); }
public ActionResult Create([Bind(Include = "MaKH,NgayDen,NgayDi,ThanhToan")] THUEPHONG tHUEPHONG) { if (ModelState.IsValid) { db.THUEPHONGS.Add(tHUEPHONG); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tHUEPHONG)); }
public List <THUEPHONG> LoadDSPhieu() { List <THUEPHONG> tam = new List <THUEPHONG>(); DataTable data = DataProvider.Instance.ExcuteQuery("select * from dbo.THUEPHONG"); foreach (DataRow row in data.Rows) { THUEPHONG temp = new THUEPHONG(row); tam.Add(temp); } return(null); }
public IActionResult Post(THUEPHONG tp) { if (unitOfWork.ThuePhong.Add(tp) == 0) { return(StatusCode(StatusCodes.Status500InternalServerError, new Reponse { Status = "error", Massage = "error" })); } return(Ok(new Reponse { Status = "succes", Massage = "succes" })); }
public ActionResult DatPhong(FormCollection collection, KHACHHANG kh, THUEPHONG th, DATPHONG dp, PHONG p) { ViewBag.MaPhong = new SelectList(db.PHONGs.ToList().OrderBy(n => n.TenPhong), "MaPhong", "TenPhong"); string spdt = ""; string sptp = ""; Random rnd = new Random(); var makh = rnd.Next(1, 10000000); var tenkh = collection["TenKH"]; var sdt = collection["SDT"]; var cmnd = collection["CMND"]; var passport = collection["PassPort"]; var ngaydat = string.Format("{0:dd/MM/yyyy}", collection["NgayDat"]); var maphong = collection["MaPhong"]; var ngayden = string.Format("{0:dd/MM/yyyy}", collection["NgayDen"]); var ngaydi = string.Format("{0:dd/MM/yyyy}", collection["NgayDi"]); kh.MaKH = makh.ToString(); kh.HoTen = tenkh; int sdt1 = int.Parse(sdt); kh.SDT = sdt1; int cmnd1 = int.Parse(cmnd); kh.CMND = cmnd1; kh.Passport = passport; kh.PhanLoaiKH = "ThuePhong"; dp.SoPhieuDP = RandomSPDT(spdt); dp.MaKH = makh.ToString(); dp.NgayDat = DateTime.Parse(ngaydat).ToShortDateString(); dp.TienDat = 5000000; th.SoPhieuTP = RandomSPTP(sptp); th.SoPhieuDP = dp.SoPhieuDP; th.MaKH = makh.ToString(); th.MaPhong = maphong; th.Ngayden = DateTime.Parse(ngayden).ToShortDateString(); th.Ngaydi = DateTime.Parse(ngaydi).ToShortDateString(); if (maphong == p.MaPhong) { p.Tinhtrang = "Đã Thuê"; } db.KHACHHANGs.InsertOnSubmit(kh); db.DATPHONGs.InsertOnSubmit(dp); db.THUEPHONGs.InsertOnSubmit(th); UpdateModel(p); db.SubmitChanges(); ViewBag.ThongBao = "Đã đặt phòng thành công"; return(View()); }
public int addPT(THUEPHONG tp) { try { connectQLKS.THUEPHONGs.Add(tp); connectQLKS.SaveChanges(); return(tp.MaThue); } catch (Exception ex) { Console.Write("Loi!!" + ex); return(-1); } }
// GET: THUEPHONGs/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } THUEPHONG tHUEPHONG = db.THUEPHONGS.Find(id); if (tHUEPHONG == null) { return(HttpNotFound()); } return(View(tHUEPHONG)); }
// GET: ThuePhongs/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } THUEPHONG thuephong = cc.SearchThuePhong(id); if (thuephong == null) { return(HttpNotFound()); } return(View(thuephong)); }
public int Add(THUEPHONG tp) { int x; using (SqlConnection connection = con()) { connection.Open(); x = connection.Query <THUEPHONG>($"SELECT MaSoThue From THUEPHONG Where maKH=@maKH and MaPhongTro=@MaPhongTro", tp, commandType: CommandType.Text).Count(); if (x <= 0) { connection.Execute("insert THUEPHONG values(@maKH ,@NgayThue,@trangThai,@MaPhongTro,@TienCoc)", tp); return(1); } return(0); } }
public IActionResult Put(THUEPHONG tp) { unitOfWork.ThuePhong.Update(tp); return(Ok()); }
public int addPT(THUEPHONG tp) { mydb.THUEPHONGs.Add(tp); mydb.SaveChanges(); return(tp.MaThue); }
public ActionResult Create(ThuePhongModel model) { var fromCheckIn = Int32.Parse(model.fromCheckIn); if (!ModelState.IsValid) { if (fromCheckIn == 0) { model.DanhSachLoaiPhong = _loaiPhongServices.PrepareSelectListLoaiPhong(0); model.fromCheckIn = "0"; model.fromEdit = "0"; model.KHACHHANG_ID = 0; } else { model.fromEdit = "0"; model.DanhSachLoaiPhong = _loaiPhongServices.PrepareSelectListLoaiPhong(fromCheckIn); } TempData["Message"] = "Có lỗi xảy ra! Vui lòng kiểm tra lại thông tin."; TempData["NotiType"] = "danger"; //success là class trong bootstrap return(View("Create", model)); } if (fromCheckIn == 0) { model.fromEdit = "0"; var khachhangItem = new KHACHHANG(); var nguoidung = db.NGUOIDUNGs.Find((int)Session["ID"]); khachhangItem.Ma = _khachHangServices.GenMaKhachHang(); khachhangItem.Ten = model.tenkhachhang; khachhangItem.SoCMT = model.socmt; khachhangItem.SoDienThoai = model.sdt; db.KHACHHANGs.Add(khachhangItem); db.SaveChanges(); var newThuePhongItem = new THUEPHONG(); newThuePhongItem.KHACHHANG = khachhangItem; newThuePhongItem.Ma = model.ma; newThuePhongItem.NgayDen = model.NgayDen; newThuePhongItem.NgayDi = model.NgayDi; newThuePhongItem.NGUOIDUNG = nguoidung; newThuePhongItem.ThoiGianThue = DateTime.Now; newThuePhongItem.LOAITINHTRANG_ID = (int)EnumLoaiTinhTrang.CHUATHANHTOAN; db.THUEPHONGs.Add(newThuePhongItem); db.SaveChanges(); foreach (var p in model.SelectedPhongs) { var newChiTietThuePhong = new CHITIETTHUEPHONG(); var phong = db.PHONGs.Find(p); newChiTietThuePhong.PHONG = phong; newThuePhongItem.CHITIETTHUEPHONGs.Add(newChiTietThuePhong); } db.SaveChanges(); } else { //check additional errors model.fromEdit = "0"; var datphongItem = db.DATPHONGs.Find(fromCheckIn); var khachHang = db.KHACHHANGs.Find(datphongItem.KHACHHANG.ID); var nguoidung = db.NGUOIDUNGs.Find((int)Session["ID"]); khachHang.Ten = model.tenkhachhang; khachHang.SoCMT = model.socmt; khachHang.SoDienThoai = model.sdt; db.SaveChanges(); var newThuePhongItem = new THUEPHONG(); newThuePhongItem.KHACHHANG = datphongItem.KHACHHANG; newThuePhongItem.Ma = model.ma; newThuePhongItem.NgayDen = model.NgayDen; newThuePhongItem.NgayDi = model.NgayDi; newThuePhongItem.NGUOIDUNG = nguoidung; newThuePhongItem.ThoiGianThue = DateTime.Now; newThuePhongItem.LOAITINHTRANG_ID = (int)EnumLoaiTinhTrang.CHUATHANHTOAN; db.THUEPHONGs.Add(newThuePhongItem); db.SaveChanges(); int temp = datphongItem.SoPhong.Value; //migrate temp rooms from reservation var selectedPhongsCopy = model.SelectedPhongs; foreach (var p in selectedPhongsCopy.ToList()) { if (temp > 0) { var phong = db.PHONGs.Find(p); if (phong.LOAIPHONG.ID == datphongItem.LOAIPHONG.ID) { var newChiTietThuePhong = new CHITIETTHUEPHONG(); newChiTietThuePhong.PHONG = phong; newThuePhongItem.CHITIETTHUEPHONGs.Add(newChiTietThuePhong); selectedPhongsCopy.Remove(p); temp--; } } } datphongItem.LOAITINHTRANG_ID = (int)EnumLoaiTinhTrang.DACHECKIN; foreach (var p in newThuePhongItem.CHITIETTHUEPHONGs) { p.PHONG.LOAITINHTRANG_ID = (int)EnumLoaiTinhTrang.DATHUE; } db.SaveChanges(); if (selectedPhongsCopy.Count() > 0) { foreach (var p in selectedPhongsCopy) { var phong = db.PHONGs.Find(p); var result = db.Database.SqlQuery <sp_Result_ThongKePhong>("exec ThongKePhong @tungay, @denngay", new SqlParameter("@tungay", newThuePhongItem.NgayDen), new SqlParameter("@denngay", newThuePhongItem.NgayDi)).Where(c => c.ID == phong.LOAIPHONG.ID).FirstOrDefault(); if (result != null) { if (result.SoPhongTrong > 0) { var newChiTietThuePhong = new CHITIETTHUEPHONG(); var phongThue = db.PHONGs.Find(p); newChiTietThuePhong.PHONG = phongThue; newThuePhongItem.CHITIETTHUEPHONGs.Add(newChiTietThuePhong); db.SaveChanges(); } else { model.DanhSachLoaiPhong = _loaiPhongServices.PrepareSelectListLoaiPhong(fromCheckIn); TempData["Message"] = "Không đủ phòng đặt thêm"; TempData["NotiType"] = "danger"; //success là class trong bootstrap return(View("Create", model)); } } } } //Lưu lịch sử hệ thống TempData["Message"] = "Thêm mới thành công"; TempData["NotiType"] = "success"; _lichSuServices.LuuLichSu((int)Session["ID"], (int)EnumLoaiHanhDong.THEM, newThuePhongItem.GetType().ToString()); //add new chitietthuephong } return(RedirectToAction("List", "ThuePhong")); }