public void SuaDuLieu(EC_NhanPhong ec) { sql.SuaDuLieu(ec); }
public void XoaduLieu(EC_NhanPhong ec) { sql.XoaDulieu(ec); }
public void ThemDuLieu(EC_NhanPhong ec) { sql.Themdulieu(ec); }
public void SuaDuLieu(EC_NhanPhong ec) { cn.ThucHienCauLenh("UPDATE NhanPhong1 SET MaPhieuDky = '" + ec.MaDky + "', TenKhach = '" + ec.TenKhach + "', SDT = '" + ec.SDT + "',MaPhong='" + ec.MaPhong + "',CMND='" + ec.CMND + "',DiaChi='" + ec.DiaChi + "',NgayNhan='" + ec.NgayNhan + "',NgayTra='" + ec.NgayTra + "' WHERE MaPhieuDky = '" + ec.MaPhieu + "'"); }
public int XoaDulieu(EC_NhanPhong ec) { return(cn.Query("delete from NhanPhong1 where MaPhieuNhan = '" + ec.MaPhieu + "'")); }
public void Themdulieu(EC_NhanPhong ec) { cn.ThucHienCauLenh("INSERT INTO NhanPhong1 (MaPhieuDKy, MaPhieuNhan, MaPhong, TenKhach, SDT, CMND, DiaChi, NgayNhan, NgayTra)VALUES(N'" + ec.MaDky + "', N'" + ec.MaPhieu + "', N'" + ec.MaPhong + "', N'" + ec.TenKhach + "', N'" + ec.SDT + "', N'" + ec.CMND + "', N'" + ec.DiaChi + "', '" + ec.NgayNhan + "', '" + ec.NgayTra + "')"); }