private void btnVeranderStatus_Click(object sender, EventArgs e) { string status = cbStatus.Text; int i = 0; switch (status) { case "Defect": i = 1; break; case "Vervuild": i = 2; break; case "Dienst": i = 3; break; case "Remise": i = 4; break; } Tram updateTram = lbTrams.SelectedItem as Tram; if (i != 0 && updateTram != null) { tramRepo.Update(updateTram.id, i); } UpdateForm(); }
private void dgvTramTG_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (dgvTramTG.SelectedCells.Count > 0) { int id_dau = (int)dgvTramTG.SelectedCells[0].OwningRow.Cells["Tram_ID_Tram"].Value; //int id = (int)dgvTramTG.SelectedCells[0].OwningRow.Cells["ID_TramTG"].Value; BUS_Tram bustram = new BUS_Tram(); BUS_Tram bustramcuoi = new BUS_Tram(); Tram tram = bustram.getTramByID(id_dau); cbbTenTram.SelectedItem = tram; lbDiaDiem.Text = tram.DiaDiem; int index = -1; int i = 0; foreach (Tram item in cbbTenTram.Items) { if (item.IDTram == tram.IDTram) { index = i; break; } i++; } cbbTenTram.SelectedIndex = index; } } catch { } }
public ActionResult Verplaats(int tram_id = 0, int nieuwe_sector = 0, int nieuw_spoor = 0) { if (tram_id > 0 && nieuwe_sector > 0 && nieuw_spoor > 0) { Tram tram = tramRepo.GetTramByID(tram_id); Sector sector = sectorRepo.GetSectorByID(nieuw_spoor, nieuwe_sector); if (tram != null && sector != null) { try { if (!tramRepo.ChangeTramSector(sector, tram)) { TempData["error"] = "Tram kan niet verplaatst worden!"; } } catch { TempData["error"] = "Tram kan niet verplaatst worden!"; } } } return(RedirectToAction("Index")); }
public void EditTram(Tram tram) { //line status driver model remise location departure var query = new SqlCommand("UPDATE Tram SET Line = @line, Status = @stat, DriverFk = @driver, ModelFk = @model, RemiseFk = @remis, Location = @loc, DepartureTime = @dep WHERE TramPk = @id"); query.Parameters.AddWithValue("@line", tram.Line); query.Parameters.AddWithValue("@stat", (int)tram.Status); if (tram.Driver != null) { query.Parameters.AddWithValue("@driver", UserContext.GetUserId(tram.Driver.Username)); } else { query.Parameters.AddWithValue("@driver", DBNull.Value); } query.Parameters.AddWithValue("@model", (int)tram.Model); query.Parameters.AddWithValue("@remis", 1); //TODO: Correct updaten. if (tram.DepartureTime == null) { query.Parameters.AddWithValue("@dep", DBNull.Value); } else { query.Parameters.AddWithValue("@dep", tram.DepartureTime); } query.Parameters.AddWithValue("@loc", (int)tram.Location); query.Parameters.AddWithValue("@id", tram.Number); Database.GetData(query); }
public ActionResult ChangeStatus(string status = "Remise", int tram_id = 0, int Prioriteit = 0) { Status s; if (tram_id > 0) { Tram t = new Tram(tram_id); try { s = (Status)Enum.Parse(typeof(Status), status); } catch (Exception e) { TempData["Text"] = "Je hebt geen geldige status opgegeven."; return(RedirectToAction("Index")); } if (tramRepo.ChangeStatusTram(s, t, Prioriteit)) { TempData["Text"] = "Het veranderen van de status is gelukt"; } else { TempData["Text"] = "Het veranderen van de status is Mislukt"; } } else { TempData["Text"] = "Het veranderen van de status is Mislukt"; } return(RedirectToAction("Index")); }
public void AddRemoveTram() { bool working = false; User user = new User(1, "Driver", "Driver", "*****@*****.**", "123", Role.Driver, "HeadClean"); Tram tram = new Tram(1, TramStatus.Idle, 5, user, TramModel.TwaalfG, TramLocation.In, DateTime.Now); logisticRepository.AddTram(tram); Assert.IsTrue(logisticRepository.GetAllTrams().Any()); foreach (Tram itemTram in logisticRepository.GetAllTrams()) { if (itemTram.Number == 1) { working = true; tram = itemTram; } } Assert.IsTrue(working); logisticRepository.RemoveTram(tram); working = false; foreach (Tram itemTram in logisticRepository.GetAllTrams()) { if (itemTram.Number == 1) { working = true; } } Assert.IsFalse(working); }
public void GetAllRepairsFromUser() { User user = logisticRepository.GetUser("Driver"); Tram tram = new Tram(1, TramStatus.Idle, 5, user, TramModel.TwaalfG, TramLocation.In, DateTime.Now); List <User> listUsers = new List <User>(); listUsers.Add(user); Repair repair = new Repair(1, DateTime.Parse("18-1-2016"), DateTime.Now, RepairType.Maintenance, "Big Planned Maintenance", "-", listUsers, 1); logisticRepository.AddTram(tram); repair = logisticRepository.AddRepair(repair); bool working = false; foreach (Repair itemRepair in logisticRepository.GetAllRepairsFromUser(user)) { if (itemRepair.Id == repair.Id) { working = true; } } Assert.IsTrue(working); logisticRepository.DeleteService(repair); logisticRepository.RemoveTram(tram); }
public void GetTramByDriver() { User user = new User(7, "Driver", "Driver", "*****@*****.**", "123", Role.Driver, "HeadClean"); Tram tram = logisticRepository.GetTramByDriver(user); Assert.AreEqual(tram.Number, 823); }
public bool Insert(Tram tram) { int listcount = Tramlist.Count; Tramlist.Add(tram); return(listcount + 1 == Tramlist.Count); }
protected void btnSchoonmaakToevoegen_Click(object sender, EventArgs e) { try { int tramnummer = Convert.ToInt32(ddlSchoonmaakToevoegenTramNummer.Text); String typeString = ddlSchoonmaakToevoegenSchoonmaakType.Text; TypeOnderhoud type = (TypeOnderhoud)Enum.Parse(typeof(TypeOnderhoud), typeString); int adid = 1; // todo; moet nog gemaakt worden BeheerController bc = new BeheerController(); Tram t = bc.GetTramByNummer(tramnummer); t.Vervuild = true; new DatabaseController().UpdateTram(t); Onderhoud ond = new Onderhoud(adid, t, DateTime.Now, DateTime.Now, type); oc.AddOnderhoud(ond); Response.Redirect(Request.RawUrl); } catch (Exception ex) { string script = "alert(\" " + ex.Message + "\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }
static void Main(string[] args) { Autobus a = new Autobus(); a.AmountOfFuel = 5; a.Capacity = 40; a.ID = 153; Autobus b = new Autobus { ID = 235, AmountOfFuel = 25, Capacity = 30 }; Autobus c = new Autobus { ID = 235, AmountOfFuel = 3, Capacity = 2 }; Tram t = new Tram { ID = 7, NumberOfWagon = 2 }; DispatchingOffice <Autobus> office = new DispatchingOffice <Autobus>(); office.AddVehicle(a); office.AddVehicle(b); office.AddVehicle(c); office.NotifyObservers(); Console.ReadKey(); }
/// <summary> /// Deze methode veranderd de tram van sector /// </summary> /// <param name="sector"></param> /// <param name="tram"></param> /// <returns>true als het gelukt is anders false</returns> public bool ChangeTramSector(Sector sector, Tram tram) { string query = "UPDATE SECTOR SET Tram_ID = null, Blokkade = 0 WHERE Tram_ID = @TramId"; string query2 = "UPDATE SECTOR SET Tram_ID = @TramId WHERE Nummer = @Sectornummer AND Spoor_Nummer = @Sectorspoor"; using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@TramId", tram.ID); cmd.ExecuteNonQuery(); } using (SqlCommand cmd = new SqlCommand(query2, conn)) { cmd.Parameters.AddWithValue("@Sectorspoor", sector.Spoor); cmd.Parameters.AddWithValue("@Sectornummer", sector.Nummer); cmd.Parameters.AddWithValue("@TramId", tram.ID); if (Convert.ToInt32(cmd.ExecuteNonQuery()) > 0) { return(true); } } } return(false); }
protected void btnTramstatusAanpassen_Click(object sender, EventArgs e) { try { int tramnummer = Convert.ToInt32(ddlTramstatusAanpassenTramnummer.Text); string status = ddlTramstatusAanpassenStatus.Text; Tram tram = bc.GetTramByNummer(tramnummer); if (status == "vervuild") { bc.TramStatusAanpassen(tram, true, tram.Defect); } else if (status == "defect") { bc.TramStatusAanpassen(tram, tram.Vervuild, true); } else if (status == "beschikbaar") { bc.TramStatusAanpassen(tram, false, false); } else { // geef status aan. } Response.Redirect(Request.RawUrl); } catch (Exception ex) { string script = "alert(\" " + ex.Message + "\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }
public IHttpActionResult PostNhaTram(NhaTram nhaTram) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Tram tram = db.Trams.Find(nhaTram.IDTram); NhaMang nhaMang = db.NhaMangs.Find(nhaTram.IDNhaMang); if (tram == null || nhaMang == null) { return(NotFound()); } int countNhaMang = db.NhaTrams.Where(u => u.IDTram == nhaTram.IDTram && u.IDNhaMang == nhaTram.IDNhaMang).Count(); if (countNhaMang > 0) { return(BadRequest()); } db.NhaTrams.Add(nhaTram); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = nhaTram.IDNhaTram }, nhaTram)); }
public override void Execute(State state, FastPriorityQueue <Event> eventQueue) { var station = state.stations[stationIndex]; station.Free(); // Enqueue current tram if (station.HasQueue()) { Tram newOccupant = station.OccupyFromQueue(); eventQueue.Enqueue(new TramArrival(newOccupant, stationIndex), state.time + Config.c.stationClearanceTime); } // Schedule arrival at next station int newStationIndex = stationIndex + 1 == state.stations.Count ? 0 : stationIndex + 1; int drivingTime = Sampling.drivingTime(Config.c.transferTimes[stationIndex].averageTime); Debug.WriteLine($"TramDeparture: tram {tram.id}: {station.name}, dir: {station.direction}, time: {state.time}"); // Make sure trams do not take over each other int arrivalTime = station.SignalNextArrival(state.time + drivingTime); if (state.stations[newStationIndex] is Endstation endstation) { eventQueue.Enqueue(new ExpectedArrivalEndstation(tram, endstation), arrivalTime); } else { eventQueue.Enqueue(new ExpectedTramArrival(tram, newStationIndex), arrivalTime); } }
/// <summary> /// Constructor /// </summary> /// <param name="number"></param> /// <param name="trackNumber"></param> /// <param name="status"></param> /// <param name="tram"></param> public Sector(int number, int trackNumber, SectorStatus status, Tram tram) { Number = number; Status = status; OccupyingTram = tram; TrackNumber = trackNumber; }
public IHttpActionResult PostTram(Tram tram) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Tram tmpTram1 = db.Trams.SingleOrDefault(u => u.KinhDo == tram.KinhDo && u.ViDo == tram.ViDo); if (tmpTram1 != null) { return(BadRequest()); } var tmpUser = db.UserBTSs.Find(tram.IDQuanLy); if (tmpUser == null) { return(NotFound()); } db.Trams.Add(tram); db.SaveChanges(); Tram tmpTram = db.Trams.SingleOrDefault(u => u.KinhDo == tram.KinhDo && u.ViDo == tram.ViDo); LichSuQuanLy lsql = new LichSuQuanLy { IDQuanLy = tmpUser.IDUser, IDTram = tmpTram.IDTram, ThoiGianLamViec = getDate() }; db.LichSuQuanLies.Add(lsql); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tram.IDTram }, tram)); }
private void btnReadText_Click(object sender, EventArgs e) { trams.Clear(); PictureBox ptb = new PictureBox(); ptb.Height = 1000; ptb.Width = 1000; drawArea = new Bitmap(ptb.Width, ptb.Height); ptb.Image = drawArea; g = Graphics.FromImage(drawArea); string[] lines = File.ReadAllLines(Application.StartupPath +@"\Inp.txt"); int n = lines.Count(); for(int i=0;i<n; i++) { string[] temp = lines[i].Split('\t'); Tram temp1 = new Tram(); temp1.MaTram = temp[0]; temp1.Longitude = Double.Parse(temp[1]); temp1.Latitude = Double.Parse(temp[2]); temp1.DoCao = Double.Parse(temp[3]); //g.FillEllipse(Brushes.Blue, AnhXaToaDoSangWinForm(temp1.Latitude),AnhXaToaDoSangWinForm(temp1.Longitude), 5, 5); trams.Add(temp1); } SapxepTram(); XacdinhVungLanCan(); VeVungLanCan(); pnlbitmap.Controls.Add(ptb); //LayTramBanDau(); MessageBox.Show("Đọc thành công"); }
public ArrivalEndstation(Tram tram, Endstation station, Platform platform, bool fromDepot = false) { this.tram = tram; this.station = station; this.platform = platform; this.fromDepot = fromDepot; }
/// <summary> /// Haal de sector op waar deze tram op staat. /// </summary> /// <param name="tram"></param> /// <returns></returns> public Sector GetAssignedSector(Tram tram) { var sector = _objectCreator.CreateSector(_tramContext.GetAssignedSector(tram)); sector?.SetTram(tram); return(sector); }
public ExpectedDepartureStartstation(Tram tram, Endstation station, Platform platform, int timeTableTime) { this.tram = tram; this.station = station; this.platform = platform; this.timeTableTime = timeTableTime; }
public bool ChangeStatusTram(Status status, Tram tram, int prioriteit) { bool gelukt = false; string _status = status.ToString(); try { if (status == Status.Defect) { gelukt = _tramRepo.ChangeReparatiePrioriteitTram(prioriteit, tram); tram.PrioriteitReparatie = prioriteit; } else if (status == Status.Schoonmaak) { gelukt = _tramRepo.ChangeSchoonmaakPrioriteitTram(prioriteit, tram); tram.PrioriteitSchoonmaak = prioriteit; } tram.Status = status; gelukt = _tramRepo.ChangeStatusTrams(_status, tram); } catch (Exception e) { throw e; } return(gelukt); }
public void AddTram(Tram tram) { var query = new SqlCommand("INSERT INTO Tram (TramPk,Line,Status,DriverFk,ModelFk,RemiseFk,Location,DepartureTime) VALUES(@id,@line,@status,@driver,@model,@remise,@location,@dep); SELECT SCOPE_IDENTITY();"); query.Parameters.AddWithValue("@id", tram.Number); query.Parameters.AddWithValue("@line", tram.Line); query.Parameters.AddWithValue("@status", (int)tram.Status); query.Parameters.AddWithValue("@model", (int)tram.Model); query.Parameters.AddWithValue("@location", (int)tram.Location); if (tram.DepartureTime == null) { query.Parameters.AddWithValue("@dep", DBNull.Value); } else { query.Parameters.AddWithValue("@dep", tram.DepartureTime); } if (tram.Driver != null) { query.Parameters.AddWithValue("@driver", UserContext.GetUserId(tram.Driver.Username)); } else { query.Parameters.AddWithValue("@driver", DBNull.Value); } query.Parameters.AddWithValue("@remise", 1); Database.GetData(query); }
public HomeController(ILogger <HomeController> logger, IMapper mapper, Tram tram, Sector sector, Depot depot, LoginRepository repository) { _mapper = mapper; _depotLogic = depot; _tramLogic = tram; _sectorLogic = sector; _repository = repository; }
public bool RemoveTram() { if (tram == null) return false; this.tram = null; this.Blocked = false; return true; }
public bool AddTram(Tram tram) { if (this.tram != null) return false; this.tram = tram; this.Blocked = true; return true; }
public void DefectTest() { Assert.AreEqual(1, Database.SetBroken(2001)); Tram tram = Database.GetAllTrams().First(t => t.Nummer == 2001); Assert.AreEqual(true, tram.Defect); }
public void SetUserToTram(Tram tram, User user) { if (tram == null) { return; } Database.GetData(new SqlCommand($"UPDATE Tram SET DriverFk = {user?.Id.ToString() ?? "null"} WHERE TramPk = {tram.Number}")); }
private double BanKinhPhu(Tram tram) { int Lp = P01 - Lc - Lf1 - Ld + G1 - Pi2 + G2 - Lf2; double d = Math.Pow(10, (Lp - 46.3 - 33.9 * Math.Log10(f) + 13.82 * Math.Log10(tram.DoCao) + HeSoHieuChinhDoCaoAnTenDiDong() - cm) / (44.9 - 6.55 * Math.Log10(tram.DoCao))); return d; }
public void InsertTram() { Tram tram = new Tram(50, 3345); work.Trams.Add(tram); //Assert.AreEqual(tram.Code, work.Trams.Get().); }
public void RemoveTram(Tram tram) { if (tram == null) { return; } DatabaseHandler.GetData(new SqlCommand($"DELETE FROM Tram WHERE TramPk = {tram.Number}")); }
public Maintenance(int id, DateTime date, string type, Tram tram, User user) { this.Id = id; this.Date = date; this.Type = type; this.Tram = tram; this.User = user; }
public TestController(ITramAccess ac, IMapper mapper, IDepotAccess dc, ISectorAccess sc, ITrackAccess tc) { _mapper = mapper; _tramLogic = new Tram(ac); _sectorLogic = new Sector(sc, ac); _trackLogic = new Track(tc, _sectorLogic); _depotLogic = new Depot(_trackLogic, _tramLogic, dc); }
/// <summary> /// Assigns the sector to the right track /// </summary> public void AssignSector(Tram tram) { if (tram.Vervuild) { foreach (int track in _cleaningTracks.Where(Database.IsRailAvailable)) { Database.CreateSector(track, tram.Id); return; } } else if (tram.Defect) { foreach (int track in _maintenanceTracks.Where(Database.IsRailAvailable)) { Database.CreateSector(track, tram.Id); return; } } // Combino heeft een speciaal spoor nodig. else if (tram.TramTypeId == 1) { if (Database.IsRailAvailable(33)) { Database.CreateSector(33, tram.Id); return; } } for (var i = 0; i < 1337; i++) { List<Spoor> sporen = Database.GetSelectedTracks(i) .Where(s => !_maintenanceTracks.Contains(s.Id)) .Where(s => !_cleaningTracks.Contains(s.Id)) .ToList(); if (sporen.Count != 0) { Spoor spoor = sporen.First(); Database.CreateSector(spoor.Id, tram.Id); break; } } }
/// <summary> /// Name: GetTram /// Retrieves the Tram with the same Id as the input from the database. /// Returns a null Tram if the tram was not found /// </summary> public Tram GetTram(int tramId) { string sql = "SELECT \"Nummer\" FROM \"TRAM\" WHERE \"ID\" = :id"; OracleCommand command = new OracleCommand(sql, conn); command.Parameters.Add(new OracleParameter("id", tramId)); Tram tram = null; int tramNr = -1; try { if (conn.State == ConnectionState.Closed) { conn.Open(); } OracleDataReader reader = command.ExecuteReader(); while (reader.Read()) { tramNr = Convert.ToInt32(reader["Nummer"]); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { conn.Close(); } if (tramNr != -1) { tram = new Tram(tramId, tramNr); } return tram; }
public Sector GetTramSector(Tram tram) { Sector sec; int tramid = tram.Id; int found = -1; int idx = -1; for(int i=0; i<Tracks.Count; i++) { found = Tracks[i].Sectors.FindIndex(p => p.tram.Id == tramid); if(found != -1) { idx = i; break; } } if (found == null) return null; else return Tracks[idx].Sectors[found]; }
public Sector FindPlacedTram(Tram tram) { int tramid = tram.Id; Sector seccout = null; for(int i=1; i<Tracks.Count; i++) { seccout= Tracks[i].Sectors.Find(p => p.tram != null && p.tram.Id == tramid); if (seccout != null) break; } return seccout; }
public Reservation(int id, Track track, Tram tram) { this.Id = id; this.Track = track; this.Tram = tram; }
public Repair(int id, DateTime date, string type, Tram tram, User user, DateTime estimate, string description) : base(id, date, type, tram, user) { this.Estimate = estimate; this.Description = description; }