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));
}
