private void dodajUSession(Anketa_vipdata.Anketa a) { Session["aID"] = a.anketaID; Session["naslov"] = a.naslovAnkete; Session["aktivnaOd"] = a.aktivnaOd; Session["aktivnaDo"] = a.aktivnaDo; }
private void anketaClick(object sender, EventArgs e) { listaAnketa.Visible = false; Button btn = (Button)sender; int recordNum; string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Korisnik\source\repos\Anketa-vipdata\Anketa-vipdata\App_Data\AnketaDB.mdf;Integrated Security=True;MultipleActiveResultSets=true;"; string query = "SELECT count(odgovorID) as brojOdgovora FROM Odgovori WHERE anketaID = " + int.Parse(btn.ID.Substring(btn.ID.IndexOf('_') + 1)); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); reader.Read(); recordNum = reader.GetInt32(0); reader.Close(); } Anketa_vipdata.Anketa anketa; if (recordNum > 0) { using (SqlConnection connection = new SqlConnection(connectionString)) { query = "SELECT naslovAnkete,anketaID,aktivnaDo,aktivnaOD FROM Anketa WHERE anketaID = " + int.Parse(btn.ID.Substring(btn.ID.IndexOf('_') + 1)); SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); reader.Read(); anketa = new Anketa_vipdata.Anketa(reader.GetString(0), reader.GetInt32(1), reader.GetDateTime(2), reader.GetDateTime(3)); query = "SELECT tekstOdgovora,brojGlasova FROM Odgovori WHERE anketaID = " + anketa.anketaID; command = new SqlCommand(query, connection); reader = command.ExecuteReader(); while (reader.Read()) { anketa.listaOdgovora.Add(new KeyValuePair <string, int>(reader.GetString(0), reader.GetInt32(1))); } reader.Close(); } Label naslovAnkete = new Label(); naslovAnkete.Text = "Anketa: " + anketa.naslovAnkete; naslovAnkete.Font.Size = 15; Label aktivnost = new Label(); aktivnost.Text = "Aktivna: " + anketa.aktivnaOd.ToLongDateString() + " - " + anketa.aktivnaDo.ToLongDateString(); naslovAnkete.ForeColor = Color.White; aktivnost.ForeColor = Color.White; pregledPojedinacneAnkete.Controls.Add(naslovAnkete); pregledPojedinacneAnkete.Controls.Add(new LiteralControl("<br /> <br />")); pregledPojedinacneAnkete.Controls.Add(aktivnost); pregledPojedinacneAnkete.Controls.Add(new LiteralControl("<br /> <br />")); Label ankete = new Label(); ankete.Text = "Ponuđeni odgovori:"; ankete.ForeColor = Color.White; pregledPojedinacneAnkete.Controls.Add(ankete); Button naPopis = new Button(); naPopis.Text = "Natrag na popis anketa"; naPopis.ID = "btn_napopis"; BulletedList bList = new BulletedList(); foreach (var i in anketa.listaOdgovora) { bList.Items.Add(new ListItem(i.Key + " --- " + "glasovi: " + i.Value)); } pregledPojedinacneAnkete.Controls.Add(bList); bList.ForeColor = Color.White; Label inform = new Label(); inform.ForeColor = Color.Red; inform.Text = "Ovu anketu nije moguće modificirati jer postoje odgovori na nju !"; pregledPojedinacneAnkete.Controls.Add(new LiteralControl("<br />")); pregledPojedinacneAnkete.Controls.Add(inform); pregledPojedinacneAnkete.Controls.Add(new LiteralControl("<br /> <br />")); pregledPojedinacneAnkete.Controls.Add(naPopis); pregledPojedinacneAnkete.Visible = true; } else { using (SqlConnection connection = new SqlConnection(connectionString)) { query = "SELECT naslovAnkete,anketaID,aktivnaDo,aktivnaOD FROM Anketa WHERE anketaID = " + int.Parse(btn.ID.Substring(btn.ID.IndexOf('_') + 1)); SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); reader.Read(); anketa = new Anketa_vipdata.Anketa(reader.GetString(0), reader.GetInt32(1), reader.GetDateTime(2), reader.GetDateTime(3)); } dodajUSession(anketa); PrikazEditabilneAnkete(); } }