public Boolean ThemHDV(HDV_DTO HDV) { string sql = "INSERT INTO HuongDanVien VALUES(N'" + HDV.IDHDV + "', N'" + HDV.TenHDV + "', N'" + HDV.GioiTinh + "', '" + HDV.NgaySinh.ToString("yyyy-MM-dd") + "')"; return(new ExecuteDB().ExecuteData(sql)); }
public Boolean SuaHDV(HDV_DTO HDV) { string sql = "UPDATE HuongDanVien SET TenHDV = N'" + HDV.TenHDV + "', GioiTinh = '" + HDV.GioiTinh + "', NgaySinh = '" + HDV.NgaySinh.ToString("yyyy-MM-dd") + "'WHERE IDHDV = N'" + HDV.IDHDV + "'"; return(new ExecuteDB().ExecuteData(sql)); }