private Sector CreateSectorFromReader(SqlDataReader reader) { Spoor s = spoorrepo.GetSpoor(Convert.ToInt16(reader["spoorid"])); try { Tram t = tramrepo.GetTram(Convert.ToInt16(reader["tramid"])); return(new Sector(Convert.ToInt32(reader["id"]), t, s, Convert.ToBoolean(reader["blokkade"]), Convert.ToBoolean(reader["beschikbaarheid"]), Convert.ToInt16(reader["rownumber"]) )); } catch { return(new Sector(Convert.ToInt32(reader["id"]), s, Convert.ToBoolean(reader["blokkade"]), Convert.ToBoolean(reader["beschikbaarheid"]), Convert.ToInt16(reader["rownumber"]) )); } }
private void button1_Click(object sender, EventArgs e) { Tram tram1 = lbGroteDienst.SelectedItem as Tram; Tram tram2 = lbKleineDienst.SelectedItem as Tram; string status = comboBox1.Text; int i = 0; switch (status) { case "Defect": i = 1; break; case "Dienst": i = 3; break; case "Remise": i = 4; break; } if (i != 0) { if (tram2 != null && i != 0) { tramRepo.Update(tram2.id, i); } } if (tram1 != null && i != 0) { tramRepo.Update(tram1.id, i); } }
private void btnInvoerTramNr_Click(object sender, EventArgs e) { Tram inrijdtram = cbTram.SelectedItem as Tram; Spoor inrijdspoor = cbSpoor.SelectedItem as Spoor; Sector inrijdsector = cbSector.SelectedItem as Sector; if (inrijdsector != null && inrijdspoor != null && inrijdtram != null) { if (sectorRepo.CheckTram(inrijdtram) == false) { sectorRepo.TramInrijden(inrijdtram, inrijdspoor, inrijdsector); UpdateForm(); Simulatie(); } else { MessageBox.Show("deze tram moet eerst uitgereden worden"); } } else { MessageBox.Show("Vul alle gegevens in"); } }
public bool CheckTram(Tram tram) { List <Sector> returnSectoren = new List <Sector>(); using (SqlConnection connection = Database.Connection) { string query = "select * from sector where tramid = @tramid"; using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.AddWithValue("tramid", tram.id); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { returnSectoren.Add(CreateSectorFromReader(reader)); } } } } if (returnSectoren.Count > 0) { return(true); } else { return(false); } }
public Activiteit(DateTime beginDatum, DateTime eindDatum, int activiteitiD, Medewerker m, Tram t) { this.medewerker = m; this.Tram = t; this.BeginDatum = beginDatum; this.EindDatum = eindDatum; this.ActiviteitiD = activiteitiD; }
public Sector(int id, Tram tram, Spoor spoor, bool blokkade, bool beschikbaar, int rownumber) { this.rowNumber = rownumber; this.id = id; this.tram = tram; this.spoor = spoor; this.Blokkade = blokkade; this.Beschikbaar = beschikbaar; }
public void GetTram() { Tram t = tramrepo.GetTramWithRFID(tbRFID.Text); if (t != null) { lbTramnr.Text = t.id.ToString(); } this.VrijindrijdSpoor = spoorRepo.ZoekinrijdSpoor(); this.VrijeSectoren = sectorRepo.ZoekVrijSector(VrijindrijdSpoor[0]); lbSector.Text = VrijeSectoren[0].id.ToString(); lbNaarSpoor.Text = VrijindrijdSpoor[0].id.ToString(); }
private void btnTramUitrijden_Click(object sender, EventArgs e) { Tram uitrijdtram = cbTram.SelectedItem as Tram; if (uitrijdtram != null) { sectorRepo.TramUitrijden(sectorRepo.GetSector(cbTram.SelectedItem as Tram)); UpdateForm(); Simulatie(); } else { MessageBox.Show("selecteer een tram"); } }
private Activiteit CreateActiviteitFromReader(SqlDataReader reader) { MedewerkerRepository m = new MedewerkerRepository(new SqlMedewerkerContext()); Medewerker medewerker = m.GetGebruiker(Convert.ToInt32(reader["medewerkerid"])); TramRepository t = new TramRepository(new SqlTramContext()); Tram tram = t.GetTram(Convert.ToInt32(reader["tramid"])); return(new Activiteit( Convert.ToInt32(reader["id"]), Convert.ToDateTime(reader["begintijd"]), Convert.ToDateTime(reader["eindtijd"]), Convert.ToInt32(reader["activiteitid"]), medewerker, tram )); }
public void TramInrijden(Tram tram, Spoor spoor, Sector sector) { using (SqlConnection connection = Database.Connection) { string query = "UPDATE sector SET spoorid= @spoorid,tramid =@tramid WHERE id = @sectorid"; using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.AddWithValue("sectorid", sector.id); command.Parameters.AddWithValue("spoorid", spoor.id); command.Parameters.AddWithValue("tramid", tram.id); Convert.ToInt32(command.ExecuteNonQuery()); } } }
public Tram GetTram(int id) { Tram ReturnTram = new Tram(); using (SqlConnection connection = Database.Connection) { string query = "Select * FROM tram Where id = @id"; using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.AddWithValue("id", id); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ReturnTram = (CreateTramFromReader(reader)); } } } } return(ReturnTram); }
public Sector GetSector(Tram tram) { Sector ReturnSector = new Sector(); using (SqlConnection connection = Database.Connection) { string query = "Select * FROM Sector Where tramid = @id"; using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.AddWithValue("id", tram.id); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ReturnSector = (CreateSectorFromReader(reader)); } } } } return(ReturnSector); }
public Tram Insert(Tram tram) { return(tramContext.Insert(tram)); }
public Tram Insert(Tram tram) { throw new NotImplementedException(); }