public void InsertBookTour(int mabook, int matour, string hotenkh,
string sdt, string email, int sonl, int sote, string ngaydat, string ghichu)
{
string sql = "INSERT INTO BookTour VALUES('" + mabook + "','" + matour + "',N'" + hotenkh + "','" +
sdt + "','" + email + "','" + sonl + "','" + sote + "','" + ngaydat + "',N'" + ghichu + "')";
cn.ExcuteNonQuery(sql);
}
public void InsertKhachSan(int mabook, int maks, string hotenkh,
string sdt, string email, DateTime ngaydat, string ghichu)
{
string sql = "INSERT INTO BookKhachSan VALUES('" + mabook + "','" + maks + "',N'" +
hotenkh + "','" + sdt + "','" + email + "','" + ngaydat + "',N'" + ghichu + "')";
cn.ExcuteNonQuery(sql);
}
public void UpdateSoCho(int maTour, int choNL, int choTE)
{
string sql = "Update SoChoCon SET SoChoNLCon='" + choNL + "', SoChoTCCon='" + choTE + "' WHERE MaTour='" + maTour + "'";
cn.ExcuteNonQuery(sql);
}