protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
tourID.Text = Session["tourID"].ToString();
String reader = tg.getTourInfoForUpdate(Session["tourID"].ToString());
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
var startDate = Convert.ToDateTime(readerArr[0].ToString()).Date;
//tourStartDate.Text = startDate.ToString("dd/MM/yyyy");
var endDate = Convert.ToDateTime(readerArr[1].ToString()).Date;
tourStartDate.Attributes.Add("placeholder", startDate.ToString("dd/MM/yyyy"));
tourEndDate.Attributes.Add("placeholder", endDate.ToString("dd/MM/yyyy"));
tourStatus.Attributes.Add("placeholder", readerArr[2]);
tourName.Attributes.Add("placeholder", readerArr[3]);
tourDesc.Attributes.Add("placeholder", readerArr[4]);
tourPrice.Attributes.Add("placeholder", readerArr[5]);
tourCat.Attributes.Add("placeholder", readerArr[6]);
tourCityCountry.Attributes.Add("placeholder", readerArr[7]);
}
protected void Page_Load(object sender, EventArgs e)
{
//Message m = new Mesage();
// String tgid, String TID, String booking_id
//reply.Text = m.getCorrespondence();
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
String tgid = tg.getTGID();
String TID = Session["TID"].ToString();
String tour_id = Session["tourID"].ToString();
Booking b = new Booking();
String booking_id = b.getBookingIDByTID_tourID(TID, tour_id);
String[] readerArr = booking_id.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
String bk_id = readerArr[0];
System.Diagnostics.Debug.WriteLine("booking results " + booking_id);
System.Diagnostics.Debug.WriteLine("TID " + TID);
System.Diagnostics.Debug.WriteLine("tour_id " + tour_id);
System.Diagnostics.Debug.WriteLine("booking_id " + bk_id);
Session["booking_id"] = bk_id;
Message m = new Message();
int maxID = -1;
//(String sender_id, String receiver_id, String booking_id, String sender_type, String receiver_type)
maxID = m.getLatestMessageID(TID, tgid, bk_id, "TR", "TG");
//String highestMessageID = "";
//if (maxID.Length != 0)
//{
// String[] maxIDArr = maxID.Split(';');
// Array.Resize(ref maxIDArr, maxIDArr.Length - 1);
// highestMessageID = maxIDArr[0];
//}
if (maxID == -1)
{
reply.Text = "WRONG INDEX";
}
else
{
String msg = m.getCorrespondence(maxID);
reply.Text = msg;
if (msg.Length != 0)
{
String[] msgArr = msg.Split(';');
Array.Resize(ref msgArr, msgArr.Length - 1);
reply.Text = msgArr[0];
}
}
//reply.Text = m.getCorrespondence(tgid, TID, booking_id);
//reply.Text = " HLELO";
}
protected void submitMessage(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
String tgid = tg.getTGID();
Message m = new Message();
String TID = Session["TID"].ToString();
System.Diagnostics.Debug.WriteLine(TID);
String tour_id = Session["tourID"].ToString();
System.Diagnostics.Debug.WriteLine(tour_id);
Booking b = new Booking();
String reader = b.getBookingIDByTID_tourID(TID, tour_id);
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
String booking_id = readerArr[0];
DateTime dt = DateTime.Now;
String date = dt.ToString("dd/MM/yyyy");
String msg = TGmsg.Text;
m.sendMessageToTR(booking_id, tour_id, tgid, TID, date, msg);
Response.Redirect("~/viewTRList.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
Session["tourID"] = "";
Session["TID"] = "";
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
String tgid = tg.getTGID();
Booking b = new Booking();
// tourID, touristID, ratings
Tour t = new Tour();
String tour_ids = t.getTourID_completed(tgid); // tourIDs under this tg
if (tour_ids != "")
{
String[] tour_idsArr = tour_ids.Split(';');
Array.Resize(ref tour_idsArr, tour_idsArr.Length - 1);
for (int i = 0; i < tour_idsArr.Length; i++)
{
String tourID = tour_idsArr[i];
String reader = b.getTourID_TID_rating(tourID); // tourid, tid, rating
if (reader != "")
{
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
int loops = readerArr.Length / 3;
int count = 0;
for (int j = 0; j < loops; j++)
{
TableRow detailsRow = new TableRow();
TableCell tourIDCell = new TableCell();
tourIDCell.Text = readerArr[count]; // tour_id
detailsRow.Cells.Add(tourIDCell);
count += 1;
TableCell tidCell = new TableCell();
tidCell.Text = readerArr[count]; // tourist id
detailsRow.Cells.Add(tidCell);
count += 1;
TableCell countCell = new TableCell();
countCell.Text = readerArr[count]; // rating
detailsRow.Cells.Add(countCell);
viewRFTRTable.Rows.Add(detailsRow);
count += 1;
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
Tour t = new Tour();
String tgid = tg.getTGID();
String reader = t.viewTourHistoryList(tgid); // tour id and tour name
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
// int touristCount = tg.countTourists(readerArr[0].ToString());
//testing1.Text = readerArr[0].ToString();
//testing2.Text = readerArr[1].ToString();
//testing3.Text = readerArr[2].ToString();
//testing4.Text = readerArr[3].ToString();
//tourtotalTR.Text = touristCount.ToString();
Booking b = new Booking();
int loops = readerArr.Length / 2;
int count = 0;
int touristArrCounter = 0;
for (int i = 0; i < loops; i++)
{
LinkButton s = new LinkButton();
s.Text = readerArr[count].ToString();
s.Click += new EventHandler(setTourId);
TableRow detailsRow = new TableRow();
TableCell tgidCell = new TableCell();
//tgidCell.Controls.Add(link);
tgidCell.Controls.Add(s);
//tgidCell.Text = readerArr[count].ToString();
detailsRow.Cells.Add(tgidCell);
count += 1;
TableCell tidCell = new TableCell();
tidCell.Text = readerArr[count].ToString();
detailsRow.Cells.Add(tidCell);
TableCell countCell = new TableCell();
countCell.Text = b.countTourists(readerArr[touristArrCounter].ToString()).ToString();
detailsRow.Cells.Add(countCell);
TGTHistListTable.Rows.Add(detailsRow);
count += 1;
touristArrCounter += 2;
}
}
protected void submitTour(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
Tour t = new Tour();
String tgid = tg.getTGID();
t.create_Tour(tgid, tourName.Text, tourCat.Text, tourCityCountry.Text, tourStartDate.Text, tourEndDate.Text, tourDesc.Text, tourPrice.Text, "Upcoming");
Response.Redirect("~/homeTG.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
String tgid = tg.getTGID();
// select tourid from tour where tgid = tgid and status = completed --TOUR TABLE
Tour t = new Tour();
String reader = t.getTourID_completed(tgid);
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
Booking b = new Booking();
for (int i = 0; i < readerArr.Length; i++)
{
int count = 0;
String tourID = readerArr[i];
String tourID_TID_feedback = b.getTourID_TID_feedback(tourID); // tourid, touristid, feedback --BOOKING TABLE
if (tourID_TID_feedback != "")
{
String[] tourID_TID_feedbackArr = tourID_TID_feedback.Split(';');
Array.Resize(ref tourID_TID_feedbackArr, tourID_TID_feedbackArr.Length - 1);
int loops = tourID_TID_feedbackArr.Length / 3;
for (int j = 0; j < loops; j++)
{
TableRow detailsRow = new TableRow();
TableCell tourIDCell = new TableCell();
tourIDCell.Text = tourID_TID_feedbackArr[count].ToString();
detailsRow.Cells.Add(tourIDCell);
count += 1;
TableCell tidCell = new TableCell();
tidCell.Text = tourID_TID_feedbackArr[count].ToString();
detailsRow.Cells.Add(tidCell);
count += 1;
TableCell countCell = new TableCell();
countCell.Text = tourID_TID_feedbackArr[count].ToString();
detailsRow.Cells.Add(countCell);
viewFBFTRTable.Rows.Add(detailsRow);
count += 1;
}
}
}
}
protected void submitFeedback(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
Tour t = new Tour();
String tgid = tg.getTGID();
// tgid, bookingid, rating, feedback
String TID = Session["TID"].ToString();
String tour_id = Session["tourID"].ToString();
Booking b = new Booking();
String reader = b.getBookingIDByTID_tourID(TID, tour_id);
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
String booking_id = readerArr[0];
String ratings = "";
if (rating1.Checked)
{
ratings = rating1.Text;
}
else if (rating2.Checked)
{
ratings = rating2.Text;
}
else if (rating3.Checked)
{
ratings = rating3.Text;
}
else if (rating4.Checked)
{
ratings = rating4.Text;
}
else
{
ratings = rating5.Text;
}
String feedback = TRFB.Text;
TR_Ratings trr = new TR_Ratings();
trr.sendRatingsAndFeedback(tgid, booking_id, ratings, feedback);
Response.Redirect("~/viewTRofT.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
String tgid = tg.getTGID();
TR_Ratings trr = new TR_Ratings();
Booking b = new Booking();
String reader = trr.getBookingID(tgid); // booking_id
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
if (readerArr.Length != 0)
{
int count = 0;
for (int i = 0; i < readerArr.Length; i++)
{
String booking_id = readerArr[i];
String tid_tour_id = b.getTourID_TID(booking_id);
String[] tid_tour_idArr = tid_tour_id.Split(';'); // tid & tour_id
Array.Resize(ref tid_tour_idArr, tid_tour_idArr.Length - 1);
TableRow detailsRow = new TableRow();
TableCell tourIDCell = new TableCell();
tourIDCell.Text = tid_tour_idArr[1].ToString(); // tour_id
detailsRow.Cells.Add(tourIDCell);
TableCell tidCell = new TableCell();
tidCell.Text = tid_tour_idArr[0].ToString(); // tid
detailsRow.Cells.Add(tidCell);
String feedback = trr.getFeedback(tgid, booking_id);
String[] feedbackArr = feedback.Split(';');
Array.Resize(ref feedbackArr, feedbackArr.Length - 1);
TableCell countCell = new TableCell();
countCell.Text = feedbackArr[count];
detailsRow.Cells.Add(countCell);
viewFB2TRTable.Rows.Add(detailsRow);
count += 1;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
TID.Text = Session["tourID"].ToString();
String tourID = Session["tourID"].ToString();
Booking b = new Booking();
Tourist t = new Tourist();
String reader = b.getBookingTuples(tourID);
String[] readerArr = reader.Split(';'); // contains array of tourist IDs
// for each tourist ID, query the tourist database and return name and country
Array.Resize(ref readerArr, readerArr.Length - 1);
for (int i = 0; i < readerArr.Length; i++)
{
String touristID = readerArr[i].ToString();
String touristInfo = t.queryTourist(touristID);
String[] touristInfoArr = touristInfo.Split(';');
Array.Resize(ref touristInfoArr, touristInfoArr.Length - 1);
LinkButton s = new LinkButton();
s.Text = touristInfoArr[0].ToString();
s.Click += new EventHandler(goToTourist);
TableRow detailsRow = new TableRow();
TableCell tgidCell = new TableCell();
tgidCell.Controls.Add(s);
detailsRow.Cells.Add(tgidCell);
TableCell tidCell = new TableCell();
tidCell.Text = touristInfoArr[1].ToString();
detailsRow.Cells.Add(tidCell);
TableCell userCell = new TableCell();
userCell.Text = touristInfoArr[2].ToString();
detailsRow.Cells.Add(userCell);
viewTRListTable.Rows.Add(detailsRow);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
tourID.Text = Session["tourID"].ToString();
Booking b = new Booking();
String reader = b.getTIDbyTour(Session["tourID"].ToString()).ToString();
String[] readerArr = reader.Split(';'); // array of tourist IDs
Array.Resize(ref readerArr, readerArr.Length - 1);
Tourist t = new Tourist();
// for each tourist, get TID, first_name and last_name
for (int i = 0; i < readerArr.Length; i++)
{
String touristID = readerArr[i].ToString();
String touristInfo = t.getTouristName(touristID).ToString();
String[] touristInfoArr = touristInfo.Split(';'); // array of TID, fname, lname
Array.Resize(ref touristInfoArr, touristInfoArr.Length - 1);
LinkButton s = new LinkButton();
s.Text = touristInfoArr[0].ToString();
s.Click += new EventHandler(goToTourist);
TableRow detailsRow = new TableRow();
TableCell tgidCell = new TableCell();
tgidCell.Controls.Add(s);
detailsRow.Cells.Add(tgidCell);
TableCell tidCell = new TableCell();
tidCell.Text = touristInfoArr[1].ToString();
detailsRow.Cells.Add(tidCell);
TableCell userCell = new TableCell();
userCell.Text = touristInfoArr[2].ToString();
detailsRow.Cells.Add(userCell);
viewListTRTable.Rows.Add(detailsRow);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
String tgid = tg.getTGID();
// tourID, touristID, ratings
// select booking_id, rating FROM TR_Ratings where TGID = tgid AND rating IS NOT NULL
TR_Ratings trr = new TR_Ratings();
String reader = trr.getBookingID_rating(tgid); // booking_id, rating
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
int loops = readerArr.Length / 2;
int bookingCount = 0;
for (int i = 0; i < loops; i++)
{
String booking_id = readerArr[bookingCount]; // 2
String rating = readerArr[bookingCount + 1]; // 3
Booking b = new Booking();
String tourID_TID = b.getTourID_TID(booking_id); // tour_id, TID
String[] tourID_TIDArr = tourID_TID.Split(';');
Array.Resize(ref tourID_TIDArr, tourID_TIDArr.Length - 1);
TableRow detailsRow = new TableRow();
TableCell tourIDCell = new TableCell();
tourIDCell.Text = tourID_TIDArr[0]; // tour_id
detailsRow.Cells.Add(tourIDCell);
TableCell tidCell = new TableCell();
tidCell.Text = tourID_TIDArr[1]; // tourist id
detailsRow.Cells.Add(tidCell);
TableCell countCell = new TableCell();
countCell.Text = rating;
detailsRow.Cells.Add(countCell);
viewR2TRTable.Rows.Add(detailsRow);
bookingCount += 2;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
TID.Text = Session["tourID"].ToString();
Tourist t = new Tourist();
String reader = t.viewTourist(Session["TID"].ToString());
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
TRID.Text = readerArr[0].ToString();
TRfname.Text = readerArr[1].ToString();
TRlname.Text = readerArr[2].ToString();
TRemail.Text = readerArr[3].ToString();
TRcountry.Text = readerArr[4].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
String TID = Session["TID"].ToString();
TRID.Text = TID;
String tour_id = Session["tourID"].ToString();
tourID.Text = tour_id;
Booking b = new Booking();
String reader = b.getBookingIDByTID_tourID(TID, tour_id);
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
String booking_id = readerArr[0];
BID.Text = booking_id;
Tourist t = new Tourist();
String tourist = t.viewTourist(TID);
String[] touristArr = tourist.Split(';'); // TID, first_name, last_name, email, country
Array.Resize(ref touristArr, touristArr.Length - 1);
String fname = touristArr[1];
TRfname.Text = fname;
String lname = touristArr[2];
TRlname.Text = lname;
String email = touristArr[3];
TRemail.Text = email;
String country = touristArr[4];
TRcountry.Text = country;
}
protected void updateTourInfo(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
Tour t = new Tour();
//String name = tourName.Text;
//testing.Text = name;
//t.testUpdate(name);
//tourName.Attributes.Add("placeholder", tour_name);
int tourID = int.Parse(Session["tourID"].ToString());
//String status = tourStatusDropdown.SelectedValue;
t.updateTour(tourID, tourStartDate.Text, tourEndDate.Text, tourStatus.Text,
tourName.Text, tourDesc.Text, tourPrice.Text, tourCat.Text, tourCityCountry.Text);
Response.Redirect("~/homeTG.aspx");
//testing.Text = "WORLD";
//System.Diagnostics.Debug.WriteLine("hello world");
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
String TID = Session["TID"].ToString();
TRID.Text = TID;
String tour_id = Session["tourID"].ToString();
tourID.Text = tour_id;
Booking b = new Booking();
String reader = b.getBookingIDByTID_tourID(TID, tour_id);
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
String booking_id = readerArr[0];
BID.Text = booking_id;
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
tourID.Text = Session["tourID"].ToString();
String tgid = tg.getTGID();
String TID = Session["tourID"].ToString();
Tour t = new Tour();
String reader = t.ViewTourInfo(TID);
String[] readerArr = reader.Split(';');
var startDate = Convert.ToDateTime(readerArr[0].ToString()).Date;
tourStartDate.Text = startDate.ToString("dd/MM/yyyy");
var endDate = Convert.ToDateTime(readerArr[1].ToString()).Date;
tourEndDate.Text = endDate.ToString("dd/MM/yyyy");
int days = (int)(endDate - startDate).TotalDays;
tourDuration.Text = days.ToString();
tourStatus.Text = readerArr[2].ToString();
tourName.Text = readerArr[3].ToString();
tourDesc.Text = readerArr[4].ToString();
categoryText.Text = readerArr[5].ToString();
tourCityCountry.Text = readerArr[6].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
Tour_Guide tg = new Tour_Guide(Session["username"].ToString());
tg.setInfo();
String reader = tg.ViewUpcomingTours();
String[] readerArr = reader.Split(';');
Array.Resize(ref readerArr, readerArr.Length - 1);
int tuple_length = readerArr.Length + 1;
int loops = tuple_length / 3;
int count = 0;
for (int i = 0; i < loops; i++)
{
//HyperLink link = new HyperLink();
//String hyperlink = "~/viewUpTourList.aspx";
//link.NavigateUrl = hyperlink;
//link.Text = readerArr[count].ToString();
//link.Attributes.Add("onclick", "setTourId");
LinkButton s = new LinkButton();
s.Text = readerArr[count].ToString();
s.Click += new EventHandler(setTourId);
TableRow detailsRow = new TableRow();
TableCell tgidCell = new TableCell();
//tgidCell.Controls.Add(link);
tgidCell.Controls.Add(s);
//tgidCell.Text = readerArr[count].ToString();
detailsRow.Cells.Add(tgidCell);
count += 1;
TableCell tidCell = new TableCell();
tidCell.Text = readerArr[count].ToString();
detailsRow.Cells.Add(tidCell);
count += 1;
TableCell userCell = new TableCell();
userCell.Text = readerArr[count].ToString();
detailsRow.Cells.Add(userCell);
updateTListTable.Rows.Add(detailsRow);
count += 1;
}
/*
* for (int i = 0; i < 3; i++)
* {
* TableRow detailsRow = new TableRow();
* TableCell tgidCell = new TableCell();
* tgidCell.Text = readerArr[i].ToString();
* detailsRow.Cells.Add(tgidCell);
*
* //count += 1;
* TableCell tidCell = new TableCell();
* tidCell.Text = readerArr[i].ToString();
* detailsRow.Cells.Add(tidCell);
*
* //count += 1;
* TableCell userCell = new TableCell();
* userCell.Text = readerArr[i].ToString();
* detailsRow.Cells.Add(userCell);
*
* TGUpTourListTable.Rows.Add(detailsRow);
* //count = 0;
* }*/
}