public List <int> GetWagonNummer2deKlasse(Travelplan travelplan)
{
List <int> Wagonnummers = new List <int>();
string query = "SELECT Wagon.Nummer FROM Reisplan JOIN Trein ON Reisplan.ReisplanID = Trein.ReisplanID JOIN Wagon ON Trein.TreinID = Wagon.TreinID WHERE Klasse = '2' AND Beginstation=@Beginstation AND Eindstation=@Eindstation AND spoor=@Spoor";
{
connection.OpenConnection();
using (SqlCommand cmd = new SqlCommand(query, connection.con))
{
cmd.Parameters.AddWithValue("@Beginstation", travelplan.Startstation);
cmd.Parameters.AddWithValue("@Eindstation", travelplan.Endstation);
cmd.Parameters.AddWithValue("@Spoor", travelplan.Railstation);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Wagonnummers.Add((int)reader["Nummer"]);
}
}
}
connection.CloseConnection();
}
return(Wagonnummers);
}
public void TestNotValidGetTravelplans()
{
Travelplan travelplan = new Travelplan("Eind", "Begin");
List <Travelplan> Stations = travelplanRepro.GetTravelplans(travelplan);
Assert.AreNotEqual(1, Stations.Count);
}
public List <Travelplan> GetTravelplans(string beginStation, string eindStation)
{
DatabaseConnection connection = new DatabaseConnection();
List <Travelplan> travelplans = new List <Travelplan>();
string query = "SELECT * FROM dbo.Reisplan where Beginstation=@begin And Eindstation=@eind";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();
parameters.Add(new KeyValuePair <string, string>("begin", beginStation));
parameters.Add(new KeyValuePair <string, string>("eind", eindStation));
DataSet dataSet = connection.ExecuteSql(query, parameters);
try
{
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
Travelplan travelplan = DataTableToTravelplan(dataSet, i);
travelplans.Add(travelplan);
}
}
catch (Exception e)
{
throw e;
}
return(travelplans);
}
public List<Seat> GetAllSeat2deKlasse(Travelplan travelplan)
{
connection.OpenConnection();
List<Seat> Seats = new List<Seat>();
string query = "SELECT StoelID, Rij, IsReserved " +
"FROM dbo.StoelPositie JOIN Wagon " +
"ON StoelPositie.WagonID = Wagon.WagonID JOIN Trein " +
"ON Wagon.TreinID = Trein.TreinID JOIN Reisplan " +
"ON Trein.ReisplanID = Reisplan.ReisplanID " +
"WHERE Klasse = '2' " +
"AND Beginstation = @Beginstation " +
"AND Eindstation = @Eindstation " +
"AND Spoor = @Spoor";
{
using (SqlCommand cmd = new SqlCommand(query, connection.con))
{
cmd.Parameters.AddWithValue("@Beginstation", travelplan.Startstation);
cmd.Parameters.AddWithValue("@Eindstation", travelplan.Endstation);
cmd.Parameters.AddWithValue("@Spoor", travelplan.Railstation);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Seats.Add(new Seat((int)reader["StoelID"], reader["Rij"].ToString(), (bool)reader["IsReserved"]));
}
}
}
connection.CloseConnection();
}
return Seats;
}
public List <Travelplan> GetTravelplans(Travelplan reisplan)
{
Travelplan station = travelplan;
List <Travelplan> Stations = new List <Travelplan>();
if (station.Startstation == reisplan.Startstation && station.Endstation == reisplan.Endstation)
{
Stations.Add(station);
}
return(Stations);
}
public Travelplan ConvertToModel(TimesViewModel tvm)
{
Travelplan tp = new Travelplan();
{
tp.Time = tvm.Time;
tp.Railstation = tvm.Railstation;
tp.Trainnr = tvm.Trainnr;
}
return(tp);
}
public TimesViewModel ConvertToViewModel(Travelplan tp)
{
TimesViewModel tvm = new TimesViewModel();
{
tvm.Time = tp.Time;
tvm.Railstation = tp.Railstation;
tvm.Trainnr = tp.Trainnr;
}
return(tvm);
}
public List <Seat> GetAllSeat2deKlasse(Travelplan travelplan)
{
throw new NotImplementedException();
// Travelplan station = travelplan;
// List<Travelplan> Stations = new List<Travelplan>();
// if (station.Startstation == reisplan.Startstation && station.Endstation == reisplan.Endstation)
// {
// Stations.Add(station);
// }
// return Stations;
}
public IActionResult Times()
{
if (HttpContext.Session.GetString("Emailadres") == null)
{
return(RedirectToAction("Login", "Account"));
}
else
{
Travelplan travelplan = new Travelplan(HttpContext.Session.GetString("Beginstation"), HttpContext.Session.GetString("Eindstation"));
List <Travelplan> tvt = travelplanRepo.GetTravelplans(travelplan);
TimesViewModel timesViewModel = new TimesViewModel
{
Trt = tvt
};
return(View(timesViewModel));
}
}
public IActionResult SecondClass()
{
if (HttpContext.Session.GetString("Emailadres") == null)
{
return(RedirectToAction("Login", "Account"));
}
else
{
Travelplan travelplan = new Travelplan(HttpContext.Session.GetString("Beginstation"), HttpContext.Session.GetString("Eindstation"), (int)HttpContext.Session.GetInt32("Spoor"));
//int wagonnumber = (int)HttpContext.Session.GetInt32("Wagonnummer");
List <Seat> seats = seatRepo.GetAllSeat2deKlasse(travelplan /*, wagonnumber*/);
TrainViewModel seatView = new TrainViewModel()
{
Seats = seats
};
return(View(seatView));
}
}
public IActionResult FirstClass()
{
if (HttpContext.Session.GetString("Emailadres") == null)
{
return(RedirectToAction("Login", "Account"));
}
else
{
Travelplan travel = new Travelplan(HttpContext.Session.GetString("Beginstation"), HttpContext.Session.GetString("Eindstation"), (int)HttpContext.Session.GetInt32("Spoor"));
List <int> wagonnummers = wagonRepo.GetWagonNumber1steKlasse(travel);
List <Seat> seats = seatRepo.GetAllSeat1steKlasse(travel);
TrainViewModel wagonView = new TrainViewModel()
{
Wagonnumber = wagonnummers,
Seats = seats
};
return(View(wagonView));
}
}
public List <int> GetWagonNumber2deKlasse(Travelplan travelplan)
{
return(context.GetWagonNummer2deKlasse(travelplan));
}
public List <Seat> GetAllSeat2deKlasse(Travelplan travelplan)
{
return(context.GetAllSeat2deKlasse(travelplan));
}
public List <Seat> GetAllSeat1steKlasse(Travelplan travelplan /*, int Wagonnummer*/)
{
return(context.GetAllSeat1steKlasse(travelplan /*, Wagonnummer*/));
}
public List <Travelplan> GetTravelplans(Travelplan travelplan)
{
return(context.GetTravelplans(travelplan));
}
