public void confirmDatPhong(string maDP)
{
DatPhong datPhong = db.DatPhongs.Find(maDP);
datPhong.tinhTrang = "xác nhận";
db.SaveChanges();
}
private void btOK_Click(object sender, EventArgs e)
{
string check = tbMa.Text;
KetNoi.openketnoi();
dtgvKH.DataSource = KetNoi.gettable("select * from KHACHHANG where MaKH='" + check + "'");
KetNoi.dongketnoi();
if (check == "")
{
return;
}
try
{
if (dtgvKH.Rows[0].Cells[0].Value.ToString() == "")
{
return;
}
}
catch (Exception)
{
MessageBox.Show("Chưa có khách hàng", "Thông báo", MessageBoxButtons.OK);
return;
}
DatPhong dat = new DatPhong();
dat.MaKH = getMaKH;
dat.Show();
this.Hide();
}
public ActionResult them_hoa_don(string maDP)
{
DatPhong datPhong = ivivuDB.timPhieuDatPhong(maDP);
ivivuDB.confirmDatPhong(maDP);
if (datPhong != null)
{
DateTime endDay = DateTime.Now, StartDay = DateTime.Now;
DateTime.TryParse(datPhong.ngayTraPhong.ToString(), out endDay);
DateTime.TryParse(datPhong.ngayBatDau.ToString(), out StartDay);
HoaDon hoaDon = new HoaDon()
{
ngayThanhToan = DateTime.Now,
tongTien = datPhong.donGia * (endDay - StartDay).Days,
maDP = maDP,
maHD = DateTime.Now.Ticks.ToString()
};
bool success = ivivuDB.themHoaDon(hoaDon);
if (success)
{
return(RedirectToAction("thong_ke_hoa_don"));
}
}
return(RedirectToAction("thong_ke_dat_phong"));
}
private void btnXoaLS_Click(object sender, EventArgs e)
{
if (dgvLichSu.SelectedCells == null)
{
return;
}
if (MessageBox.Show("Bạn thực sự muốn xóa?", "Xóa lịch sử", MessageBoxButtons.OKCancel, MessageBoxIcon.Question)
== System.Windows.Forms.DialogResult.OK)
{
DatPhong dp = (from n in db.DatPhongs
where n.MaDatPhong == dgvLichSu.CurrentRow.Cells[0].Value.ToString()
select n).SingleOrDefault();
if (dp != null)
{
db.DatPhongs.DeleteOnSubmit(dp);
db.SubmitChanges();
List <DatPhong> list = new List <DatPhong>();
var query = (from n in db.DatPhongs
select n);
list = query.ToList <DatPhong>();
dgvLichSu.DataSource = list;
MessageBox.Show("Xóa thành công!");
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,TenNguoiDat,Address,Cmnd,Sdt,TienDatCoc,ThoiGianNhanPhongDuKien,ThoiGianTraPhongDuKien,TongTien,AccoutId")] DatPhong datPhong)
{
if (id != datPhong.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(datPhong);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DatPhongExists(datPhong.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(datPhong));
}
public IHttpActionResult PutDatPhong(int id, DatPhong datPhong)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != datPhong.MaDatPhong)
{
return(BadRequest());
}
db.Entry(datPhong).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DatPhongExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private void btnDatPhong_ItemClick(object sender, ItemClickEventArgs e)
{
DatPhong f = new DatPhong();
f.MdiParent = this;
f.Show();
}
private void ThanhToanPhong()
{
foreach (DataRow dr in dtDP.Rows)
{
DatPhong dp = new DatPhong(Convert.ToInt32(dr[0]), Convert.ToInt64(dr[1]), Convert.ToInt32(dr[2]),
Convert.ToDateTime(dr[3]), Convert.ToDecimal(dr[4]), Convert.ToDecimal(dr[5]), dr[6].ToString(),
false);
try
{
new DatPhongBLL().Change(dtDP, dp);
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "Chú ý!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
try
{
new DatPhongBLL().SaveData(ref dtDP);
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "Chú ý!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult DeleteConfirmed(Guid id)
{
DatPhong datPhong = db.DatPhongs.Find(id);
db.DatPhongs.Remove(datPhong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult GoFinish(DatPhong obj, string firstName, string lastName)
{
obj.Phong = db.Phongs.Find(obj.IDPhong);
obj.HoTen = firstName + " " + lastName;
db.DatPhongs.Add(obj);
db.SaveChanges();
return(RedirectToAction("Finish", new { id = obj.IDDatPhong }));
}
public void Edit(DatPhong dp)
{
var model = _context.DatPhongs.First(f => f.Id == dp.Id);
_context.Entry <DatPhong>(model).State = EntityState.Detached;
_context.Update(dp);
_context.SaveChangesAsync();
}
public int New(DatPhong dp)
{
_context.Add(dp);
_context.SaveChangesAsync();
int id = dp.Id;
return(id);
}
public ActionResult Edit([Bind(Include = "IDPhieuDat,Username,NgayDat,TinhTrangThanhToan,HoTen,SoDienThoai,Mail,YeuCauKhac,TinhTrangXuLy")] DatPhong datPhong)
{
if (ModelState.IsValid)
{
db.Entry(datPhong).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(datPhong));
}
public Boolean Change(DataTable dt, DatPhong dp)
{
try
{
return(new DatPhongDAL().Change(dt, dp));
}
catch (SqlException ex)
{
throw ex;
}
}
public IHttpActionResult GetDatPhong(string id)
{
DatPhong datPhong = db.DatPhongs.Find(id);
if (datPhong == null)
{
return(NotFound());
}
return(Ok(datPhong));
}
public void TestXoaCoMoiMaHoaDon()
{
string MaHoaDon = "E72G4TC5";
QuanLyHomestayEntities db = new QuanLyHomestayEntities();
HOADON hd = (from i in db.HOADONs where i.MaHoaDon.Equals(MaHoaDon) select i).FirstOrDefault();
bool expected = true;
bool actual = DatPhong.deletePhong(db, hd);
Assert.AreEqual(expected, actual);
}
static public int Insert(DatPhong dp)
{
if (IsExist(dp))
{
return(0);
}
string sql = string.Format("Insert into DatPhong(MaPhong, MaKhach, NgayThue) " +
"Values({0}, {1}, '{2}')", dp.MaPhong, dp.MaKhach, dp.NgayThue.ToString("MM-dd-yyyy HH:mm:ss.fff"));
return(xldulieu.Execute(sql));
}
public async Task <IActionResult> Create([Bind("Id,TenNguoiDat,Address,Cmnd,Sdt,TienDatCoc,ThoiGianNhanPhongDuKien,ThoiGianTraPhongDuKien,TongTien,AccoutId")] DatPhong datPhong)
{
if (ModelState.IsValid)
{
_context.Add(datPhong);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(datPhong));
}
public Boolean Change(DataTable dt, DatPhong dp)
{
foreach (DataRow dr in dt.Rows)
{
if (Convert.ToInt32(dr["IDDatPhong"]) == dp.iD)
{
dr["TrangThai"] = dp.trangThai;
return(true);
}
}
throw new Exception("Không tìm thấy IDDatPhong cần sửa!");
}
public IHttpActionResult PostDatPhong(DatPhong datPhong)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.DatPhong.Add(datPhong);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = datPhong.MaDatPhong }, datPhong));
}
public ActionResult Create([Bind(Include = "IDPhieuDat,Username,NgayDat,TinhTrangThanhToan,HoTen,SoDienThoai,Mail,YeuCauKhac,TinhTrangXuLy")] DatPhong datPhong)
{
if (ModelState.IsValid)
{
datPhong.IDPhieuDat = Guid.NewGuid();
db.DatPhongs.Add(datPhong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(datPhong));
}
static public bool IsExist(DatPhong dp)
{
string sql = "select * from DatPhong where MaPhong = " + dp.MaPhong + " and MaKhach = " + dp.MaKhach +
" and NgayThue = '" + dp.NgayThue.ToString("MM-dd-yyyy HH:mm:ss.fff") + "'";
DataTable table = xldulieu.LoadData(sql);
if (table.Rows.Count < 1)
{
return(false);
}
return(true);
}
private void grVDatPhong_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
List <DatPhong> danhsachdatphong = DatPhongDAO.Instances.HienThiDanhSachDatPhong();
int i = 0;
foreach (var item in danhsachdatphong)
{
grVDatPhong.Rows[i].Tag = item;
i++;
}
foreach (DataGridViewRow item in grVDatPhong.Rows)
{
DatPhong datPhong = item.Tag as DatPhong;
if (item.Selected)
{
foreach (var item1 in cbbMaDatPhong.Items)
{
if (datPhong.MaDatPhong == (item1 as DatPhong).MaDatPhong)
{
cbbMaDatPhong.SelectedItem = item1;
}
}
if (datPhong.NgayDi.ToString() == "")
{
dtpNgayDi.Value = dtpNgayDi.MaxDate;
}
else
{
dtpNgayDi.Value = (DateTime)datPhong.NgayDi;
}
dtpNgayO.Value = datPhong.NgayO;
maphong = datPhong.MaPhong;
Phong phong = PhongDAO.Instances.LoadPhongTheoMaPhong(datPhong.MaPhong);
int IndexLoaiPhong = TimKiemLoaiPhongVuaChon(phong.MA, phong.MaLoaiPhong);
int IndexPhong = TimKiemPhongVuaChon(phong.MA, phong.MaLoaiPhong);
LoadLoaiPhongVaocbbLoaiPhong(IndexLoaiPhong);
LoadPhongVaocbbPhong(IndexPhong, phong.MaLoaiPhong);
txtTraTruoc.Text = datPhong.TraTruoc.ToString();
//for (int b = 0; b < cbbDichVu.Items.Count; b++)
//{
// DichVu dichVu = cbbDichVu.Items[b] as DichVu;
// if (dichVu.MaDV == datPhong.MaDV)
// cbbDichVu.SelectedIndex = b;
//}
//txtSoPhan.Text = datPhong.SoLuong.ToString();
KhachHang_huy khachHang_Huy = KhachHangDAO_huy.Instances.TimKHTheoMAKH(datPhong.MaKH);
txtBChungMinhThu.Text = khachHang_Huy.ChungMinhThu;
}
}
}
public void Insert(int RoomID, int TVNguoiDungID)
{
QLPhongTroDBContext db = new QLPhongTroDBContext();
DatPhong dp = new DatPhong();
dp.idDatPhong = 0;
dp.idPhong = RoomID;
dp.idUser = TVNguoiDungID;
dp.TenPhong = new ModifyPhong().GetTenPhongByID(RoomID);
dp.NgayDangKy = DateTime.Now;
db.DatPhongs.Add(dp);
db.SaveChanges();
}
public IHttpActionResult DeleteDatPhong(int id)
{
DatPhong datPhong = db.DatPhong.Find(id);
if (datPhong == null)
{
return(NotFound());
}
db.DatPhong.Remove(datPhong);
db.SaveChanges();
return(Ok(datPhong));
}
// GET: Admin/Orders/Delete/5
public ActionResult Delete(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DatPhong datPhong = db.DatPhongs.Find(id);
if (datPhong == null)
{
return(HttpNotFound());
}
return(View(datPhong));
}
static public DatPhong LoadOne(int maPhong)
{
string sql = "select * from DatPhong where MaPhong = " + maPhong;
DataTable table = xldulieu.LoadData(sql);
if (table.Rows.Count < 1)
{
return(null);
}
DatPhong dp = new DatPhong(table.Rows[0].Field <int>(0), table.Rows[0].Field <int>(1),
table.Rows[0].Field <DateTime>(2));
return(dp);
}
private void bthoanthanhgiatien_Click(object sender, EventArgs e)
{
DatPhong datphong = db.DatPhongs.FirstOrDefault(s => s.MaDatPhong == dp.MaDatPhong);
datphong.TinhTrangThanhToan = "Da thanh toan";
datphong.ThanhTien = int.Parse(txtTongTienTT.Text);
db.SubmitChanges();
Phong phong = db.Phongs.FirstOrDefault(s => s.MaPhong == dp.MaPhong);
phong.Available = "Trong";
db.SubmitChanges();
MessageBox.Show("Trả phòng thành công!");
frmChonPhong f = new frmChonPhong(nhanVien);
this.Close();
f.ShowDialog();
}
public ActionResult Finish(DatPhong datPhong)
{
var obj = db.DatPhongs.Find(datPhong.IDDatPhong);
string message = "Lỗi";
switch (obj.TrangThai)
{
case "Vetified":
message = "Đơn đặt phòng đã xác minh thành công trước đó.";
break;
case "TimeOut":
message = "Đơn đặt phòng đã hết thời gian kiệu lực";
break;
case "Success":
message = "Đã được xử lí";
break;
default:
if (obj.HSD < DateTime.Now)
{
obj.TrangThai = "TimeOut";
message = "Đơn đặt phòng đã hết thời gian kiệu lực";
}
else if (obj.Vetify == datPhong.Vetify)
{
obj.TrangThai = "Vetified";
message = "Đơn đặt phòng xác minh thành công.";
}
else
{
message = "Mã xác minh không chính xác";
}
db.SaveChanges();
break;
}
ModelState.AddModelError("", message);
datPhong.Phong = obj.Phong;
datPhong.TrangThai = obj.TrangThai;
datPhong.NgayTao = DateTime.Now;
return(View(datPhong));
}
public void TestXoaDayDuThongTin()
{
QuanLyHomestayEntities db = new QuanLyHomestayEntities();
HOADON hd = new HOADON();
hd.NgayDen = DateTime.Parse("5/20/2019");
hd.NgayDi = DateTime.Parse("5/25/2019");
hd.MaLoaiPhong = "NC1";
hd.GiaTien = "299000";
hd.DonVi = "VND";
hd.SoTienDatTruoc = null;
hd.MaHoaDon = "E72G4TC7";
hd.NgayThanhToan = DateTime.Parse("5/20/2019");
bool expected = true;
bool actual = DatPhong.deletePhong(db, hd);
Assert.AreEqual(expected, actual);
}
