public void Button3_Click(object sender, EventArgs e) { AdminDataManager ADMgr = new AdminDataManager(); int itineraryID = -1; int attractionID = -1; int day = -1; string startTime = "None"; string endTime = "None"; bool doit = true; try { itineraryID = Int32.Parse(this.TextBox6.Text); attractionID = Int32.Parse(this.TextBox7.Text); day = Int32.Parse(this.TextBox8.Text); DateTime d1 = Convert.ToDateTime(this.TextBox9.Text); startTime = d1.ToString("HH:mm"); DateTime d2 = Convert.ToDateTime(this.TextBox10.Text); endTime = d2.ToString("HH:mm"); if (d1 > d2) { throw new System.ArgumentException("Times invalid.", "original"); } if (itineraryID <= 0 || attractionID <= 0 || day <= 0) { doit = false; } } catch (Exception) { doit = false; } if (doit) { ADMgr.createItineraryDoList(itineraryID, attractionID, day, startTime, endTime); DataTable dt = ADMgr.getItineraryDoList(); GridView3.DataSource = dt; GridView3.DataBind(); } else { this.TextBox15.Text = "Error Encountered. Please try again."; } }
public void Button6_Click(object sender, EventArgs e) { AdminDataManager ADMgr = new AdminDataManager(); int itineraryID = -1; int attractionID = -1; bool doit = true; int returnresult = -1; try { itineraryID = Int32.Parse(this.TextBox13.Text); attractionID = Int32.Parse(this.TextBox14.Text); if (itineraryID < 1 || attractionID < 1) { doit = false; } } catch (Exception) { doit = false; } if (doit) { returnresult = ADMgr.deleteItineraryDoList(itineraryID, attractionID); DataTable dt = ADMgr.getItineraryDoList(); GridView3.DataSource = dt; GridView3.DataBind(); if (returnresult < 1) { this.TextBox15.Text = "Failure to delete. Please try again."; } else { this.TextBox15.Text = "Deleted successfully."; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin"] == null) { Response.Redirect("index.aspx"); } AdminDataManager ADMgr = new AdminDataManager(); DataTable dt = ADMgr.getAttractions(); GridView1.DataSource = dt; GridView1.DataBind(); DataTable dt2 = ADMgr.getItinerary(); GridView2.DataSource = dt2; GridView2.DataBind(); DataTable dt3 = ADMgr.getItineraryDoList(); GridView3.DataSource = dt3; GridView3.DataBind(); }