private void btnOBBack_Click(object sender, EventArgs e)
{
var ps = new PlanSearch(_plan);
_plan.Controls.Remove(this);
_plan.Controls.Add(ps);
}
private void button1_Click(object sender, EventArgs e)
{
//------add customers info
var query = "INSERT INTO Travellers VALUES(null, @fname, @lname, @addr, @phone, @email, @dob, @gender)";
for (var x = 0; x < _guestinfo.Count(); x++)
{
_temp.Clear();
_temp.Add(_guestinfo[x].FName);
_temp.Add(_guestinfo[x].LName);
_temp.Add(_guestinfo[x].Addr);
_temp.Add(_guestinfo[x].PNum);
_temp.Add(_guestinfo[x].Email);
_temp.Add(_guestinfo[x].ToDob());
_temp.Add(_guestinfo[x].Gender.ToString());
_cp.insertRec(query, _temp);
//------get customer autogenerated id
const string cid = "select TVL_ID from Travellers where TVL_FName=@fname and TVL_LName=@lname and TVL_Address=@addr and TVL_Phone_Number=@phone and TVL_Email=@email and TVL_DOB=@dob and TVL_Gender=@gender";
_custId.Add(_cp.getCId(cid, _temp));
}
//------add booking info
query = "INSERT INTO Booking VALUES(@cruise,@tvlr,@room)";
for (var y = 0; y < _guestinfo.Count(); y++)
{
_temp.Clear();
_temp.Add(_cruiseid.ToString());
_temp.Add(_custId[y]);
_temp.Add(_roomnum);
_cp.insertRec(query, _temp);
}
//------determine how many ppl reside in roomnum
//------determine whether to change isOccupied to '1'
query = "select Count(Traveller_Id) from Booking where Cruise_ID=@cruise and Room_Number=@room";
pplInRoom = _cp.getPplInRoom(query, _cruiseid.ToString(), _roomnum);
//find ship id given cruise id
query = "select Ship_id from Cruises where Cruise_id=@cruise";
shipid = _cp.getSId(query, _cruiseid);
query = "update Rooms set isOccupied='1' where Room_Number=@room and Ship_ID=@ship";
if (pplInRoom == 4)
{
_cp.updateRec(query, _roomnum, shipid);
}
MessageBox.Show(@"Payment successful, thank you for cruising with us");
var ps = new PlanSearch(_plan);
_plan.Controls.Add(ps);
_plan.Controls.Remove(this);
}
public PlanSearchResult(Plan p, PlanSearch ps, List <Cruise> c, int i = 0)
{
InitializeComponent();
plan = p;
plansearch = ps;
cruises = c;
index = i;
if (index == 0)
{
btnPrevResult.Enabled = false;
}
else if (index == cruises.Count() - 1)
{
btnNextResult.Enabled = false;
}
}
//pass this page and the established connection to the usercontrol
public void openSearch()
{
PlanSearch ps = new PlanSearch(this);
this.Controls.Add(ps);
}
