public bool UpdateVerbinding(Verbinding v)
{
int index = Verbindingen.FindIndex(x => x.Id == v.Id);
Verbindingen[index] = v;
return(true);
}
public bool UpdateVerbinding(Verbinding v)
{
string query = "update Verbinding set [actief] = @actief, @fields where Id = @id";
string fields = "";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("id", v.Id.ToString()),
new KeyValuePair <string, string>("actief", v.Actief ? "1" : "0")
};
if (v.Naam != null)
{
if (!string.IsNullOrWhiteSpace(fields))
{
fields += ",";
}
fields += "[naam] = @naam";
parameters.Add(new KeyValuePair <string, string>("naam", v.Naam));
}
query = query.Replace("@fields", fields);
ExecuteSql(query, parameters);
return(true);
}
public void DeleteVerbinding()
{
EmptyLists();
verbindingRepository = new VerbindingRepository(context);
Verbinding verbinding = new Verbinding(1, "Andernaam", 50, new Perron(1, "naam", true), new Perron(2, "naam", true), true);
Assert.True(verbindingRepository.DeleteVerbinding(verbinding.Id));
}
public void TestInitialize()
{
land = new Land("testland", 100, 0.01m, 0.01m);
land2 = new Land("testland2", 50, 0.001m, 0.001m);
maatregel = new Maatregel("test1", 1.1m, 1.1m, 2, 0.1m, 0.1m, 0.1m, "testcategorie", "testniveau");
maatregel2 = new Maatregel("test2", 1.1m, 1.1m, 3, 0.2m, 0.2m, 0.2m, "testcategorie", "testniveau");
maatregel3 = new Maatregel("test3", 1.1m, 1.1m, 4, 0.3m, 0.3m, 0.3m, "testcategorie", "testniveau");
maatregel4 = new Maatregel("test4", 1.1m, 1.1m, 5, 0.4m, 0.4m, 0.4m, "testcategorie", "testniveau");
verbinding = new Verbinding(land, land2, 20);
verbinding2 = new Verbinding(land2, land, 5);
}
public void CreateVerbinding()
{
EmptyLists();
verbindingRepository = new VerbindingRepository(context);
Verbinding verbinding = new Verbinding(3, "naam", 50, new Perron(1, "naam", true), new Perron(2, "naam", true), true);
verbindingRepository.CreateVerbinding(verbinding);
Assert.Equal(3, verbindingRepository.CreateVerbinding(verbinding));
}
public IActionResult Create(VerbindingDetailViewModel vm)
{
if (ModelState.IsValid)
{
VerbindingViewModelConverter verbindingViewModelConverter = new VerbindingViewModelConverter();
Verbinding p = verbindingViewModelConverter.ViewModelToVerbinding(vm);
decimal id = repo.CreateVerbinding(p);
return(RedirectToAction("Details", new { id }));
}
return(View());
}
public void GetVerbindingbyId()
{
EmptyLists();
verbindingRepository = new VerbindingRepository(context);
Verbinding verbinding = new Verbinding(1, "naam", 50, new Perron(1, "naam", true), new Perron(2, "naam", true), true);
Verbinding verbinding2 = verbindingRepository.GetVerbindingbyId(1);
Assert.Equal(verbinding.Id, verbinding2.Id);
Assert.Equal(verbinding.Naam, verbinding2.Naam);
Assert.Equal(verbinding.Lengte, verbinding2.Lengte);
}
public IActionResult Edit(VerbindingDetailViewModel vm)
{
try
{
Verbinding verbinding = converter.ViewModelToVerbinding(vm);
repo.UpdateVerbinding(verbinding);
return(RedirectToAction("Details", new { verbinding.Id }));
}
catch
{
return(View());
}
}
public VerbindingDetailViewModel VerbindingToViewModel(Verbinding v)
{
VerbindingDetailViewModel vm = new VerbindingDetailViewModel()
{
Id = v.Id,
BeginPerronId = v.BeginPerron.Id,
EindPerronId = v.EindPerron.Id,
Naam = v.Naam,
Lengte = v.Lengte,
Actief = v.Actief
};
return(vm);
}
public long CreateVerbinding(Verbinding v)
{
string sql = "INSERT INTO Verbinding (naam, lengte, beginPerronId, eindPerronId, actief) VALUES(@naam,@lengte,@beginPerronId,@eindPerronId@actief); SELECT SCOPE_IDENTITY()";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("naam", v.Naam.ToString()),
new KeyValuePair <string, string>("lengte", v.Lengte.ToString()),
new KeyValuePair <string, string>("beginPerronId", v.BeginPerron.Id.ToString()),
new KeyValuePair <string, string>("eindPerronId", v.EindPerron.Id.ToString()),
new KeyValuePair <string, string>("actief", v.Actief ? "1" : "0")
};
DataSet result = ExecuteSql(sql, parameters);
long newId = Convert.ToInt64(Math.Round(Convert.ToDecimal(result.Tables[0].Rows[0][0]), 0));
return(newId);
}
public Verbinding GetVerbindingbyId(long id)
{
string sql = "Select * from Verbinding where id=@id";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("id", id.ToString())
};
DataSet results = ExecuteSql(sql, parameters);
Verbinding v = null;
if (results != null && results.Tables[0].Rows.Count > 0)
{
v = DataSetParser.DataSetToVerbinding(results, 0);
}
return(v);
}
public void Initialisatie()
{
land = new Land("testland", 100, 0.01m, 0.01m);
land2 = new Land("testland2", 50, 0.001m, 0.001m);
maatregel = new Maatregel("test1", 1.1m, 1.1m, 2, 0.1m, 0.1m, 0.1m, "testcategorie", "testniveau");
maatregel2 = new Maatregel("test2", 1.1m, 1.1m, 3, 0.2m, 0.2m, 0.2m, "testcategorie", "testniveau");
maatregel3 = new Maatregel("test3", 1.1m, 1.1m, 4, 0.3m, 0.3m, 0.3m, "testcategorie", "testniveau");
maatregel4 = new Maatregel("test4", 1.1m, 1.1m, 5, 0.4m, 0.4m, 0.4m, "testcategorie", "testniveau");
verbinding = new Verbinding(land, land2, 20);
verbinding2 = new Verbinding(land2, land, 5);
maatregels = new List <Maatregel> {
maatregel, maatregel2, maatregel3, maatregel4
};
verbindingen = new List <Verbinding> {
verbinding, verbinding2
};
land.LandInitieren(maatregels, verbindingen);
}
public List <Verbinding> GetAllVerbindingen()
{
string sql = "Select * from dbo.verbinding";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();
DataSet results = ExecuteSql(sql, parameters);
List <Verbinding> verbindingen = new List <Verbinding>();
if (results != null)
{
for (int x = 0; x < results.Tables[0].Rows.Count; x++)
{
Verbinding v = DataSetParser.DataSetToVerbinding(results, x);
verbindingen.Add(v);
}
}
return(verbindingen);
}
public IActionResult Details(int id)
{
if (id < 1)
{
return(BadRequest("Id cannot be 0"));
}
Verbinding verbinding = repo.GetVerbindingbyId(id);
if (verbinding == null)
{
return(BadRequest("Verbinding could not be found"));
}
VerbindingDetailViewModel vm = converter.VerbindingToViewModel(verbinding);
return(View(vm));
}
public Verbinding ViewModelToVerbinding(VerbindingDetailViewModel vm)
{
Verbinding v = new Verbinding()
{
Id = vm.Id,
BeginPerron = new Perron()
{
Id = vm.BeginPerronId
},
EindPerron = new Perron()
{
Id = vm.EindPerronId
},
Naam = vm.Naam,
Lengte = vm.Lengte,
Actief = vm.Actief
};
return(v);
}
public long CreateVerbinding(Verbinding v)
{
Verbindingen.Add(v);
return(v.Id);
}
public long CreateVerbinding(Verbinding v)
{
throw new NotImplementedException();
}
public void UpdateVerbinding(Verbinding v)
{
throw new NotImplementedException();
}
public Verbinding GetVerbindingbyId(long id)
{
Verbinding verbinding = Verbindingen.FirstOrDefault(v => v.Id == id);
return(verbinding);
}
public long CreateVerbinding(Verbinding v)
{
return(Context.CreateVerbinding(v));
}
public bool UpdateVerbinding(Verbinding v)
{
return(Context.UpdateVerbinding(v));
}
