public void BuscarBanners() { BannerBLL bannerBLL = new BannerBLL(); AdRotator1.DataSource = bannerBLL.getAll(); AdRotator1.DataBind(); }
private void BindAds() { DataSet advertisement = new DataSet(); advertisement.ReadXml(Server.MapPath("~/XML Files/Advertisement.xml")); AdRotator1.DataSource = advertisement.Tables["Ad1"]; AdRotator1.DataBind(); AdRotator2.DataSource = advertisement.Tables["Ad2"]; AdRotator2.DataBind(); AdRotator3.DataSource = advertisement.Tables["Ad3"]; AdRotator3.DataBind(); AdRotator4.DataSource = advertisement.Tables["Ad4"]; AdRotator4.DataBind(); }
protected void Timer1_Tick(object sender, EventArgs e) { AdRotator1.DataSource = FetchAdsFromDB(); AdRotator1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { //Rebecca - If not logged in, or user is not a student, redirect to default page if (Session["user"] == null || (Convert.ToInt32(Session["typeID"]) != 5)) { Response.Redirect("../Default.aspx"); } else { //Otherwise assign session to username field string user = Session["user"].ToString(); //RMU - Getting enrolled value from DB (to display Registration Wizard) //Getting userID from URL int userID = Convert.ToInt32(Session["userID"]); //RMU - DB Connection: string connectionString = WebConfigurationManager.ConnectionStrings ["dbconnect"].ConnectionString; SqlConnection myConnection = new SqlConnection(connectionString); myConnection.Open(); string query = "SELECT * FROM SIS_STUDENT WHERE userID=@Id"; SqlCommand myCommand = new SqlCommand(query, myConnection); myCommand.Parameters.AddWithValue("@Id", userID); SqlDataReader rdr = myCommand.ExecuteReader(); while (rdr.Read()) { string enrolled = rdr["enrolled"].ToString(); enrolValue.Text = enrolled; } rdr.Close(); string datequery = "SELECT * FROM SIS_ACADEMICDATES WHERE dateID=4"; SqlCommand dateCommand = new SqlCommand(datequery, myConnection); SqlDataReader dateRdr = dateCommand.ExecuteReader(); while (dateRdr.Read()) { String date = dateRdr["startDate"].ToString(); StartDate.Text = date; } } //Student's enrol state (true/false) string enrol = enrolValue.Text; //Academic term start date: DateTime start = Convert.ToDateTime(StartDate.Text); string startD = start.ToString("dd/MM/yy"); //Calculating 2 weeks before start: DateTime beforeDeadline = start.AddDays(-14); string beforeD = beforeDeadline.ToString("dd/MM/yy"); //Calculating 2 weeks after: DateTime afterDeadline = start.AddDays(14); string afterD = afterDeadline.ToString("dd/MM/yy"); //Storing now date/time string nowTime = DateTime.Now.ToString("dd/MM/yy"); DateTime now = Convert.ToDateTime(nowTime); //If enrolled, banner disappears: if (enrol == "True" || enrol == "true") { Reg.Visible = false; deadline.Visible = false; } //If enrolled, banner remains: if (enrol == "False" || enrol == "false") { } //If right now, is before the 2 weeks before deadline, banner disappears: if (now < beforeDeadline) { Reg.Visible = false; } //If right now, is after the 2 weeks after deadline, banner disappears: if (now > afterDeadline && (enrol == "False" || enrol == "false")) { Reg.Visible = false; deadline.Text = "You have missed the enrolment deadline, please contact your Advisor of Studies"; } //If now is in range, banner remains if (now.Date >= beforeDeadline.Date && now.Date <= afterDeadline.Date) { } AdRotator1.DataSource = FetchAdsFromDB(); AdRotator1.DataBind(); }