public ActionResult Edit(string id)
{
var decode = Encryption.decrypt(id);
int x = int.Parse(decode);
if (decode == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ThuePhong thuePhong = db.ThuePhong.Find(x);
if (thuePhong == null)
{
return(HttpNotFound());
}
List <SelectListItem> tenPhong = new List <SelectListItem>();
foreach (var item in db.Phong)
{
if (item.TinhTrang == false)
{
tenPhong.Add(new SelectListItem
{
Text = item.TenPhong,
Value = item.MaPhong.ToString()
});
}
}
ViewBag.MaPhong = /*new SelectList(db.Phongs, "MaPhong", "MaPhong")*/ tenPhong;
return(View(thuePhong));
}
public ActionResult Edit([Bind(Include = "MaThuePhong,MaPhong,NgayBatDauThue")] ThuePhong thuePhong)
{
try {
if (ModelState.IsValid)
{
db.Entry(thuePhong).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(View("SửaThànhCông"));
}
}
catch
{
return(View("LỗiSửaTP"));
}
List <SelectListItem> tenPhong = new List <SelectListItem>();
foreach (var item in db.Phong)
{
if (item.TinhTrang == false)
{
tenPhong.Add(new SelectListItem
{
Text = item.TenPhong,
Value = item.MaPhong.ToString()
});
}
}
ViewBag.MaPhong = /*new SelectList(db.Phongs, "MaPhong", "MaPhong")*/ tenPhong;
return(View(thuePhong));
}
public ActionResult DeleteConfirmed(string id)
{
var decode = Encryption.decrypt(id);
int x = int.Parse(decode);
try
{
ThuePhong thuePhong = db.ThuePhong.Find(x);
db.ThuePhong.Remove(thuePhong);
db.SaveChanges();
return(View("XoáThànhCôngTP"));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
return(View("LỗiXoáThuêPhòng"));
}
}
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 = "TenPhong,ViTri,Loai,TinhTrang,Gia")] ThuePhong thuePhong)
{
if (ModelState.IsValid)
{
db.Entry(thuePhong).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thuePhong));
}
public ActionResult Create([Bind(Include = "TenPhong,ViTri,Loai,TinhTrang,Gia")] ThuePhong thuePhong)
{
if (ModelState.IsValid)
{
db.ThuePhongs.Add(thuePhong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thuePhong));
}
public int insertThuePhong(eThuePhong newtp)
{
ThuePhong temp = new ThuePhong();
temp.maThue = "";
temp.maNV = newtp.MaNV;
temp.maDoan = newtp.MaDoan;
temp.soLuongPhong = newtp.SoLuongPhong;
temp.trangThai = Convert.ToByte(newtp.TrangThai);
db.ThuePhongs.InsertOnSubmit(temp);
db.SubmitChanges();
return(1);
}
private void btnDatPhong_Click(object sender, EventArgs e)
{
try
{
KhachHang kh = new KhachHang
{
HoTen = txtHoTen.Text,
DiaChi = txtDiaChi.Text,
CMND = txtCMND.Text,
SDT = txtSDT.Text,
GioiTinh = cbbGioiTinh.SelectedItem.ToString(),
ThanhToan = "Chưa thanh toán"
};
PhongK ph = db.PhongKs.SingleOrDefault(p => p.MaPhong == txtMaPhong.Text.Trim());
ThuePhong tp = new ThuePhong
{
TenNV = txtTenNV.Text,
CMND = txtCMND.Text,
Ngayden = dtpNgayNhan.Value,
Ngaydi = null,
GiaPhong = ph.GiaPhong,
ThanhToan = "Chưa thanh toán",
MaPhong = txtMaPhong.Text,
HotenKH = txtHoTen.Text
};
if (txtSDT.Text == "" || txtHoTen.Text == "" || txtDiaChi.Text == "" || txtCMND.Text == "" || db.KhachHangs.Where(p => p.CMND == kh.CMND).SingleOrDefault() != null)
{
MessageBox.Show("Một số thông tin nhập còn thiếu hoặc CMND bị trùng. Xin kiểm tra lại.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
ph.TinhTrang = "Có khách";
db.ThuePhongs.InsertOnSubmit(tp);
db.KhachHangs.InsertOnSubmit(kh);
db.SubmitChanges();
LoadDSPT();
MessageBox.Show("Đặt phòng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtHoTen.Clear();
txtCMND.Clear();
txtDiaChi.Clear();
txtSDT.Clear();
}
}
catch (Exception)
{
MessageBox.Show("Lỗi dữ liệu! Xin vui lòng nhập lại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dgvKhach_RowEnter(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow dgvr = new DataGridViewRow();
ThuePhong ph = new ThuePhong();
dgvr = dgvKhach.Rows[e.RowIndex];
if (e.RowIndex >= 0)
{
txtCMND.Text = dgvr.Cells[0].Value.ToString();
txtMP.Text = dgvr.Cells[1].Value.ToString();
txtMaPhong.Text = dgvr.Cells[1].Value.ToString();
}
ph = db.ThuePhongs.FirstOrDefault(p => p.MaPhong == txtMaPhong.Text.Trim());
}
// 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));
}
private void btnTraP_Click(object sender, EventArgs e)
{
ThuePhong tp = db.ThuePhongs.SingleOrDefault(p => p.CMND == txtCMND.Text);
SDDVPhong sd = db.SDDVPhongs.FirstOrDefault(p => p.CMND == txtCMND.Text);
DialogResult dr = MessageBox.Show("Bạn có chắc muốn thanh toán cho khách hàng " + tp.HotenKH, "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (tp != null && dr == DialogResult.OK)
{
tp.Ngaydi = DateTime.Now;
tp.ThanhToan = "Đã thanh toán";
sd.ThanhToan = "Đã thanh toán";
PhongK ph = db.PhongKs.SingleOrDefault(p => p.MaPhong == txtMaPhong.Text.Trim());
ph.TinhTrang = "Trống";
ThemDT();
db.SubmitChanges();
LoadDST();
MessageBox.Show("Bạn đã thanh toán thành công mã phòng " + tp.MaPhong + " của khách hàng " + tp.HotenKH + " vào lúc " + DateTime.Now + " .", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void dgvPhongThue_RowEnter(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow dgvr = new DataGridViewRow();
ThuePhong ph = new ThuePhong();
dgvr = dgvPhongThue.Rows[e.RowIndex];
if (e.RowIndex >= 0)
{
txtCMND.Text = dgvr.Cells[0].Value.ToString();
txtHoTen.Text = dgvr.Cells[1].Value.ToString();
txtMaPhong.Text = dgvr.Cells[2].Value.ToString();
txtGiaPhong.Text = dgvr.Cells[3].Value.ToString() + " VNĐ";
dtpNgayden.Value = DateTime.Parse(dgvr.Cells[4].Value.ToString());
TimeSpan c = DateTime.Now.Subtract(dtpNgayden.Value);
PhongK pk = new PhongK();
pk = db.PhongKs.SingleOrDefault(p => p.MaPhong == txtMaPhong.Text);
double ThanhTien = c.Days * pk.GiaPhong + c.Hours * (pk.GiaPhong / 8);
txtTongTien.Text = ThanhTien.ToString() + " VNĐ";
tongtien = ThanhTien;
}
ph = db.ThuePhongs.SingleOrDefault(p => p.CMND == txtCMND.Text.Trim());
}
public ActionResult Index([Bind(Include = "MaPhong,NgayBatDauThue")] ThuePhong thuePhong)
{
List <SelectListItem> tenPhong = new List <SelectListItem>();
foreach (var item in db.Phong)
{
if (item.TinhTrang == false)
{
tenPhong.Add(new SelectListItem
{
Text = item.TenPhong,
Value = item.MaPhong.ToString()
});
}
}
ViewBag.MaPhong = /*new SelectList(db.Phongs, "MaPhong", "MaPhong")*/ tenPhong;
var tinhTrang = phong.TinhTrang.HasValue;
try
{
if (ModelState.IsValid)
{
if (tinhTrang == false)
{
db.ThuePhong.Add(thuePhong);
db.SaveChanges();
return(View("DatPhong"));
}
}
}
catch
{
return(View("CreateError"));
}
return(View("TrangChủ", thuePhong));
}
private void timer1_Tick(object sender, EventArgs e)
{
switch (btnName)
{
case "NhanVien":
if (poinChange >= mPanelContainer.Size.Width)
{
timer1.Stop();
templateNhanVien templateNhanVien = new templateNhanVien();
templateNhanVien.Dock = DockStyle.Fill;
frmMain.frmMain_.MetroContainer.Controls.Add(templateNhanVien);
frmMain.frmMain_.MetroContainer.Controls["templateNhanVien"].BringToFront();
foreach (ucManHinhChinh item in frmMain.frmMain_.MetroContainer.Controls.OfType <ucManHinhChinh>())
{
frmMain.frmMain_.MetroContainer.Controls.Remove(item);
}
}
else
{
poinChange += 80;
mPanelContainer.Location = new Point(poinChange, 0);
}
break;
case "HeThong":
if (poinChange >= mPanelContainer.Size.Width)
{
timer1.Stop();
HeThong HeThong = new HeThong();
HeThong.Dock = DockStyle.Fill;
frmMain.frmMain_.MetroContainer.Controls.Add(HeThong);
frmMain.frmMain_.MetroContainer.Controls["HeThong"].BringToFront();
foreach (ucManHinhChinh item in frmMain.frmMain_.MetroContainer.Controls.OfType <ucManHinhChinh>())
{
frmMain.frmMain_.MetroContainer.Controls.Remove(item);
}
}
else
{
poinChange += 80;
mPanelContainer.Location = new Point(poinChange, 0);
}
break;
case "Phong":
if (poinChange >= mPanelContainer.Size.Width)
{
timer1.Stop();
Phong Phong = new Phong();
Phong.Dock = DockStyle.Fill;
frmMain.frmMain_.MetroContainer.Controls.Add(Phong);
frmMain.frmMain_.MetroContainer.Controls["Phong"].BringToFront();
foreach (ucManHinhChinh item in frmMain.frmMain_.MetroContainer.Controls.OfType <ucManHinhChinh>())
{
frmMain.frmMain_.MetroContainer.Controls.Remove(item);
}
}
else
{
poinChange += 80;
mPanelContainer.Location = new Point(poinChange, 0);
}
break;
case "TienNghi":
if (poinChange >= mPanelContainer.Size.Width)
{
timer1.Stop();
TienNghi TienNghi = new TienNghi();
TienNghi.Dock = DockStyle.Fill;
frmMain.frmMain_.MetroContainer.Controls.Add(TienNghi);
frmMain.frmMain_.MetroContainer.Controls["TienNghi"].BringToFront();
foreach (ucManHinhChinh item in frmMain.frmMain_.MetroContainer.Controls.OfType <ucManHinhChinh>())
{
frmMain.frmMain_.MetroContainer.Controls.Remove(item);
}
}
else
{
poinChange += 80;
mPanelContainer.Location = new Point(poinChange, 0);
}
break;
case "DichVu":
if (poinChange >= mPanelContainer.Size.Width)
{
timer1.Stop();
DichVu DichVu = new DichVu();
DichVu.Dock = DockStyle.Fill;
frmMain.frmMain_.MetroContainer.Controls.Add(DichVu);
frmMain.frmMain_.MetroContainer.Controls["DichVu"].BringToFront();
foreach (ucManHinhChinh item in frmMain.frmMain_.MetroContainer.Controls.OfType <ucManHinhChinh>())
{
frmMain.frmMain_.MetroContainer.Controls.Remove(item);
}
}
else
{
poinChange += 80;
mPanelContainer.Location = new Point(poinChange, 0);
}
break;
case "ThuePhong":
if (poinChange >= mPanelContainer.Size.Width)
{
timer1.Stop();
ThuePhong ThuePhong = new ThuePhong();
ThuePhong.Dock = DockStyle.Fill;
frmMain.frmMain_.MetroContainer.Controls.Add(ThuePhong);
frmMain.frmMain_.MetroContainer.Controls["ThuePhong"].BringToFront();
foreach (ucManHinhChinh item in frmMain.frmMain_.MetroContainer.Controls.OfType <ucManHinhChinh>())
{
frmMain.frmMain_.MetroContainer.Controls.Remove(item);
}
}
else
{
poinChange += 80;
mPanelContainer.Location = new Point(poinChange, 0);
}
break;
case "TraPhong":
if (poinChange >= mPanelContainer.Size.Width)
{
timer1.Stop();
TraPhong TraPhong = new TraPhong();
TraPhong.Dock = DockStyle.Fill;
frmMain.frmMain_.MetroContainer.Controls.Add(TraPhong);
frmMain.frmMain_.MetroContainer.Controls["TraPhong"].BringToFront();
foreach (ucManHinhChinh item in frmMain.frmMain_.MetroContainer.Controls.OfType <ucManHinhChinh>())
{
frmMain.frmMain_.MetroContainer.Controls.Remove(item);
}
}
else
{
poinChange += 80;
mPanelContainer.Location = new Point(poinChange, 0);
}
break;
case "HoaDon":
if (poinChange >= mPanelContainer.Size.Width)
{
timer1.Stop();
HoaDon HoaDon = new HoaDon();
HoaDon.Dock = DockStyle.Fill;
frmMain.frmMain_.MetroContainer.Controls.Add(HoaDon);
frmMain.frmMain_.MetroContainer.Controls["HoaDon"].BringToFront();
foreach (ucManHinhChinh item in frmMain.frmMain_.MetroContainer.Controls.OfType <ucManHinhChinh>())
{
frmMain.frmMain_.MetroContainer.Controls.Remove(item);
}
}
else
{
poinChange += 80;
mPanelContainer.Location = new Point(poinChange, 0);
}
break;
}
}
public string getMaThue_ByMaDoan(string madoan, byte trangThai)
{
ThuePhong tp = db.ThuePhongs.Where(x => x.maDoan.Equals(madoan) && x.trangThai == trangThai).SingleOrDefault();
return(tp.maThue);
}
public string getMaDoan_ByMaThue(string maThue)
{
ThuePhong tp = db.ThuePhongs.Where(x => x.maThue.Equals(maThue)).SingleOrDefault();
return(tp.maDoan);
}
public string getMaThueCuoi()
{
ThuePhong tp = (from x in db.ThuePhongs orderby x.maThue descending select x).FirstOrDefault();
return(tp.maThue);
}
