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