private void loadRepeater()
{
touristbookingList = TouristBooking.GetAllToursOfTourist(int.Parse(Session["tourist_id"].ToString()));
RepeaterBookings.DataSource = touristbookingList;
RepeaterBookings.DataBind();
}
protected void RepeaterBookings_ItemCommand(object source, RepeaterCommandEventArgs e)
{
RepeaterItem item1 = e.Item;
Label theTourId = (Label)item1.FindControl("LbName");
string statusput = "Rejected";
TouristBooking tg = new TouristBooking(int.Parse(theTourId.Text), statusput);
TouristBooking.UpdateTourGuideBooking(tg);
}
protected void BtnConfirm_Click(object sender, EventArgs e)
{
if (DateTime.Parse(TourDate.Text) < DateTime.Now)
{
Response.Write("Date Is Not Valid!");
}
else
{
string timeanddate = TourDate.Text + " " + TourTime.Text;
string statuscheck = "-";
TouristBooking obj = new TouristBooking(int.Parse(gettouristid.Text), gettourguidename.Text, tourguidetitleLabel.Text, timeanddate, statuscheck, int.Parse(gettourguideid.Text));
TouristBookingDAO.InsertBooking(obj);
}
}
public static void InsertBooking(TouristBooking tb)
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlStmt = "INSERT INTO TouristBooking (tourist_id, name, tourtitle, timing, status, tourguide_id)" +
"VALUES (@paraTouristId, @paraName, @paraTourTitle, @paraTiming, @paraStatus, @paraTourGuideId)";
SqlCommand sqlCmd = new SqlCommand(sqlStmt, myConn);
sqlCmd.Parameters.AddWithValue("@paraTouristId", tb.TouristId);
sqlCmd.Parameters.AddWithValue("@paraName", tb.Name);
sqlCmd.Parameters.AddWithValue("@paraTourTitle", tb.TourTitle);
sqlCmd.Parameters.AddWithValue("@paraTiming", tb.Timing);
sqlCmd.Parameters.AddWithValue("@paraStatus", tb.Status);
sqlCmd.Parameters.AddWithValue("@paraTourGuideId", tb.TourGuideId);
myConn.Open();
sqlCmd.ExecuteNonQuery();
myConn.Close();
}
public static void UpdateTourBooking(TouristBooking tg)
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlStmt = "Update TouristBooking Set status = @paraStatus Where tour_id = @paraId;";
SqlCommand cmd = new SqlCommand(sqlStmt, myConn);
cmd.Parameters.AddWithValue("@paraStatus", tg.Status);
cmd.Parameters.AddWithValue("@paraId", tg.TourId);
try
{
myConn.Open();
cmd.ExecuteNonQuery();
myConn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public static List <TouristBooking> SelectTourByTourGuideId(int id)
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlStmt = "Select * from TouristBooking where tourguide_id = @paraId and status = '-'";
SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn);
da.SelectCommand.Parameters.AddWithValue("@paraId", id);
DataSet ds = new DataSet();
da.Fill(ds);
List <TouristBooking> personalTourList = new List <TouristBooking>();
int rec_cnt = ds.Tables[0].Rows.Count;
for (int i = 0; i < rec_cnt; i++)
{
DataRow row = ds.Tables[0].Rows[i];
int tourist_id = int.Parse(row["tourist_id"].ToString());
string name = row["name"].ToString();
int tour_id = int.Parse(row["tour_id"].ToString());
string tourtitle = row["tourtitle"].ToString();
string timing = row["timing"].ToString();
string status = row["status"].ToString();
int tourguide_id = int.Parse(row["tourguide_id"].ToString());
TouristBooking obj = new TouristBooking(tourist_id, name, tour_id, tourtitle, timing, status, tourguide_id);
personalTourList.Add(obj);
}
return(personalTourList);
}
