public void SuaDuLieu(EC_Dangky ec) { cn.ThucHienCauLenh("UPDATE DangKy SET MaPhong = '" + ec.Maphong + "', TenKhach = '" + ec.Tenkhach + "', SDT = '" + ec.SDT + "',NgayDky='" + ec.Ngaydky + "',NgayNhan='" + ec.Ngaynhan + "' WHERE MaPhieuDky = '" + ec.Maphieu + "'"); }
public int XoaDulieu(EC_Dangky ec) { return(cn.Query("delete from DangKy where MaPhieuDky = '" + ec.Maphieu + "'")); }
public void ThemPhieu(EC_Dangky ec) { cn.ThucHienCauLenh("INSERT INTO DangKy (MaPhieuDky, MaPhong, TenKhach, SDT, NgayDky, NgayNhan)VALUES(N'" + ec.Maphieu + "', N'" + ec.Maphong + "', N'" + ec.Tenkhach + "', N'" + ec.SDT + "', CONVERT(DATETIME, '" + ec.Ngaydky + "', 102), CONVERT(DATETIME, '" + ec.Ngaynhan + "', 102))"); }
public void SuaDuLieu(EC_Dangky ec) { sql.SuaDuLieu(ec); }
public void XoaduLieu(EC_Dangky ec) { sql.XoaDulieu(ec); }
public void ThemDuLieu(EC_Dangky ec) { sql.ThemPhieu(ec); }