private void btnTim_Click(object sender, EventArgs e)
{
DoanBUS dbus = new DoanBUS();
eDoan doan = new eDoan();
doan = dbus.getdoan_sdt(txtSdt.Text.Trim());
txtTruongDoan.Text = doan.MaTruongDoan;
txtTenDoan.Text = doan.TenDoan;
loadThuePhong_Doan();
}
private void btnTimDoan_Click(object sender, EventArgs e)
{
DoanBUS dbus = new DoanBUS();
eDoan doan = new eDoan();
doan = dbus.getdoan_sdt(txtSdtDoan.Text.Trim());
txtTenDoan.Text = doan.TenDoan;
txtDiaChi.Text = doan.DiaChi;
txtTruongDoan.Text = doan.MaTruongDoan;
}
public eDoan getdoan_ID(string id)
{
Doan item = (from x in db.Doans where x.maDoan.Equals(id) select x).SingleOrDefault();
eDoan d = new eDoan();
d.MaDoan = item.maDoan.Trim();
d.TenDoan = item.tenDoan.Trim();
d.Sdt = item.soDienThoai.Trim();
d.MaTruongDoan = item.maTruongDoan.Trim();
d.DiaChi = item.diaChi.Trim();
return(d);
}
public int insertDoan(eDoan newd)
{
Doan temd = new Doan();
temd.maDoan = "";
temd.soDienThoai = newd.Sdt;
temd.diaChi = newd.DiaChi;
temd.maTruongDoan = newd.MaTruongDoan;
temd.tenDoan = newd.TenDoan;
db.Doans.InsertOnSubmit(temd);
db.SubmitChanges();
return(1);
}
private void frmTraKhachDoan_Load(object sender, EventArgs e)
{
autoCompleteSource();
if (maDoan != null)
{
DoanBUS dbus = new DoanBUS();
eDoan doan = new eDoan();
doan = dbus.getdoan_ID(maDoan);
txtSdt.Text = doan.Sdt;
txtTruongDoan.Text = doan.MaTruongDoan;
txtTenDoan.Text = doan.TenDoan;
loadThuePhong_Doan();
}
}
public List <eDoan> getdoans()
{
var listd = (from x in db.Doans select x).ToList();
List <eDoan> ls = new List <eDoan>();
foreach (Doan item in listd)
{
eDoan d = new eDoan();
d.MaDoan = item.maDoan.Trim();
d.TenDoan = item.tenDoan.Trim();
d.Sdt = item.soDienThoai.Trim();
d.MaTruongDoan = item.maTruongDoan.Trim();
d.DiaChi = item.diaChi.Trim();
ls.Add(d);
}
return(ls);
}
public int insertDoan(eDoan newd)
{
return(ddal.insertDoan(newd));
}
private void btnLuu_Click(object sender, EventArgs e)
{
ThuePhongBUS tpbus = new ThuePhongBUS();
PhongBUS pbus = new PhongBUS();
LoaiPhongBUS lpbus = new LoaiPhongBUS();
eThuePhong tp = new eThuePhong();
NhanVienBUS nvbus = new NhanVienBUS();
DoanBUS dbus = new DoanBUS();
//Tao Doan
eDoan doan = new eDoan();
doan.DiaChi = txtDiaChi.Text.Trim();
doan.MaTruongDoan = txtTruongDoan.Text.Trim();
doan.TenDoan = txtTenDoan.Text.Trim();
doan.Sdt = txtSdtDoan.Text.Trim();
if (dbus.getdoan_sdt(txtSdtDoan.Text.Trim()) == null)
{
int kqTaoDoan = dbus.insertDoan(doan);
}
tp.MaNV = nvbus.getmaNV_byEmail(emailNV);
tp.MaDoan = dbus.getId_ByTenDoan(txtTenDoan.Text.Trim()); //ma doan
int soLuongP = 0;
for (int i = 0; i < gridViewLoaiPhong.RowCount; i++)
{
soLuongP += Convert.ToInt32(gridViewLoaiPhong.GetRowCellValue(i, gridViewLoaiPhong.Columns[3]));
}
tp.SoLuongPhong = soLuongP;
tp.TrangThai = false;
TimeSpan gioVao = new TimeSpan(DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
TimeSpan gioRa = new TimeSpan(14, 00, 00);
int a = tpbus.insertThuePhong(tp);
eChiTietThuePhong cttp = new eChiTietThuePhong();
if (a == 1)
{
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
foreach (eKhachHang item in ls)
{
cttp.MaThue = tpbus.getMaThueCuoi();
cttp.MaKhach = item.MaKH;
cttp.MaPhong = pbus.maPhong_byTen(item.SoPhong);
cttp.NgayRa = Convert.ToDateTime(dtmNgayRa.Text).Date;
cttp.NgayVao = DateTime.Now.Date;
cttp.GioRa = gioRa;
cttp.GioVao = gioVao;
cttp.TrangThai = false;
cttpbus.insertCTTP(cttp);
ePhong p = new ePhong();
p.MaPhong = pbus.maPhong_byTen(item.SoPhong);
p.TinhTrang = true;
int soPhong = 0;
foreach (var kh in ls)
{
if (kh.SoPhong.Equals(item.SoPhong))
{
soPhong++;
}
}
p.SoNgHienTai = soPhong;
pbus.updateTinhTrangPhong(p);
}
MessageBox.Show("Đặt phòng thành công");
this.Close();
}
else
{
MessageBox.Show("Không thành công");
return;
}
}