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