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