protected void Page_Load(object sender, EventArgs e)
{
if (Session["userName"] == null || !(Session["roleNumber"].ToString().Equals("1")))
{
Response.Redirect("NotAuthorizatedPage.aspx");
}
String myConnectionString;
myConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
MySqlConnection conn = new MySqlConnection(myConnectionString);
conn.Open();
string queryElection = "SELECT CONCAT(ELECTION_INFO, \", \", ELECTION_STARTING_DATE, \", \", ELECTION_ENDING_DATE) AS ELECTION FROM ELECTION WHERE ELECTION_STARTING_DATE > SYSDATE() OR ELECTION_INFO='#' ORDER BY ELECTION_INFO;";
MySqlCommand cmd = new MySqlCommand(queryElection, conn);
MySqlDataAdapter da = new MySqlDataAdapter {
SelectCommand = cmd
};
DataSet ds = new DataSet();
da.Fill(ds);
if (!IsPostBack)
{
DropDownListElection.DataTextField = ds.Tables[0].Columns["ELECTION"].ToString();
DropDownListElection.DataSource = ds.Tables[0];
DropDownListElection.DataBind();
DropDownListElection.SelectedItem.Text = "";
}
conn.Close();
}
private void checkElections()
{
String myConnectionString;
myConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
MySqlConnection conn = new MySqlConnection(myConnectionString);
conn.Open();
string queryElection = "SELECT CONCAT(ELECTION_INFO, \", \", ELECTION_STARTING_DATE, \", \", ELECTION_ENDING_DATE) AS ELECTION FROM ELECTION WHERE ELECTION_STARTING_DATE > SYSDATE() AND ELECTION_INFO!='#' ORDER BY ELECTION_INFO;";
MySqlCommand cmd = new MySqlCommand(queryElection, conn);
MySqlDataAdapter da = new MySqlDataAdapter {
SelectCommand = cmd
};
DataSet ds = new DataSet();
da.Fill(ds);
DropDownListElection.DataTextField = ds.Tables[0].Columns["ELECTION"].ToString();
DropDownListElection.DataSource = ds.Tables[0];
DropDownListElection.DataBind();
DropDownListElection.Items.Insert(0, new ListItem("Please select an election to verify your vote", ""));
DropDownListElection.SelectedIndex = 0;
conn.Close();
}
