protected void Page_Load(object sender, EventArgs e) { //Är du Admin? bool admin = true; int index = ListBox1.SelectedIndex; bool harValt = false; if (ListBox1.SelectedIndex > -1) { harValt = true; } else { Button2.Visible = false; Button2.Enabled = false; Button1.Visible = false; Button1.Enabled = false; } if (!this.IsPostBack) { tva = true; } int x = 0; foreach (ListItem li in ListBox1.Items) { if (li.Selected == true) { tre = true; } x++; } int y = ListBox1.SelectedIndex; string query = "SELECT * FROM \"DilanMartin\".personalen;"; NpgsqlDataAdapter da = new NpgsqlDataAdapter(query, conn); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow row in dt.Rows) { personal p = new personal(); p.id = Convert.ToInt32(row["id"]); p.fornamn = row["fornamn"].ToString(); p.admin = (bool)row["admin"]; p.godkannd = (bool)row["godkanns"]; p.ny = (bool)row["ny"]; p.resultat = row["sernasteresultatet"].ToString(); p.senaste = (DateTime)row["senastetillfalle"]; p.etik = row["etik"].ToString(); p.ekonomi = row["ekonomi"].ToString(); p.prod = row["produkter"].ToString(); p.etikgod = (bool)row["etik_godkannd"]; p.ekonomigod = (bool)row["ekonomi_godkannd"]; p.prodgod = (bool)row["produkter_godkannd"]; string query2 = "SELECT pers_id, fraga_id, svar FROM \"DilanMartin\".provet where pers_id =" + p.id.ToString() + ";"; NpgsqlDataAdapter da2 = new NpgsqlDataAdapter(query2, conn); DataTable dt2 = new DataTable(); da2.Fill(dt2); foreach (DataRow row2 in dt2.Rows) { p.svaren.Add(Convert.ToInt32(row2["svar"])); } DateTime arSedan = DateTime.Now; TimeSpan ts = new TimeSpan(365, 0, 0, 0, 0); arSedan -= ts; if (p.senaste < arSedan) { p.skagora = true; } plista.Add(p); } ListBox1.DataSource = plista; ListBox1.DataBind(); if (harValt == true) { Label7.Visible = true; Label8.Visible = true; Label9.Visible = true; Label1.Visible = true; Label2.Visible = true; Label3.Visible = true; Label6.Visible = false; InfoLabels(index); } else { Label7.Visible = false; Label8.Visible = false; Label9.Visible = false; Label1.Visible = false; Label2.Visible = false; Label3.Visible = false; Label6.Visible = true; } if (tre == true) { vilkenAnvandarId(y); } if (y > -1) { if (plista[y].skagora == true) { //Ska göra provet nu men har gammalt prov Button2.Visible = true; Button2.Enabled = true; Button1.Visible = true; Button1.Enabled = true; } else { //En vecka sedan sist underkännd //Har gjort gammalt prov men har gjort det nyligen if (plista[y].godkannd == false) { if (harDetGattEnveckaSedanUnderkannd(y) == true) { Button2.Visible = true; Button2.Enabled = true; Button1.Visible = true; Button1.Enabled = true; } else { Button2.Visible = false; Button2.Enabled = false; //Det är bara "Admin" som ser hans gammla prov, //kan ta bort dessa två true så kan han inte se gammalt prov. //Vet inte hur jag vill ha det Button1.Visible = true; Button1.Enabled = true; } } else { Button1.Visible = true; Button1.Enabled = true; Button2.Visible = false; Button2.Enabled = false; } } if (plista[y].ny == true) { //Ny och inget gammalt prov prov Button1.Visible = false; Button1.Enabled = false; Button2.Visible = true; Button2.Enabled = true; Label9.Visible = false; Label3.Visible = false; Gridview2.Visible = false; } else { Gridview2.Visible = true; Label9.Visible = true; Label3.Visible = true; } } else { Button2.Visible = false; Button2.Enabled = false; Button1.Visible = false; Button1.Enabled = false; } //Om man är "inloggad" som admin eller inte if (admin == false) { Button1.Visible = false; Button1.Enabled = false; } }
private void LaddaPersonal() { string query = "SELECT * FROM \"DilanMartin\".personalen where id= " + hamtaPersonalID(); ; NpgsqlDataAdapter da = new NpgsqlDataAdapter(query, conn); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow row in dt.Rows) { personal p = new personal(); p.id = Convert.ToInt32(row["id"]); p.fornamn = row["fornamn"].ToString(); p.admin = (bool)row["admin"]; p.godkannd = (bool)row["godkanns"]; p.ny = (bool)row["ny"]; p.resultat = row["sernasteresultatet"].ToString(); p.senaste = (DateTime)row["senastetillfalle"]; p.etik = row["etik"].ToString(); p.ekonomi = row["ekonomi"].ToString(); p.prod = row["produkter"].ToString(); p.etikgod = (bool)row["etik_godkannd"]; p.ekonomigod = (bool)row["ekonomi_godkannd"]; p.prodgod = (bool)row["produkter_godkannd"]; plista.Add(p); } }