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);
}
}
