public bool UpdatePerron(Perron p)
{
string query = "update Perron set [actief] = @actief, @fields where Id = @id";
string fields = "";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("id", p.Id.ToString()),
new KeyValuePair <string, string>("actief", p.Actief? "1" : "0")
};
if (p.Naam != null)
{
if (!string.IsNullOrWhiteSpace(fields))
{
fields += ",";
}
fields += "[naam] = @naam";
parameters.Add(new KeyValuePair <string, string>("naam", p.Naam));
}
query = query.Replace("@fields", fields);
ExecuteSql(query, parameters);
return(true);
}
public bool UpdatePerron(Perron p)
{
int index = Perrons.FindIndex(x => x.Id == p.Id);
Perrons[index] = p;
return(true);
}
public void UpdateStation()
{
EmptyLists();
stationVerbindingRepository = new PerronRepository(context);
Perron perron = new Perron(1, "xx", true);
Assert.True(stationVerbindingRepository.UpdatePerron(perron));
}
public void DeletePerron()
{
EmptyLists();
stationVerbindingRepository = new PerronRepository(context);
Perron perron = new Perron(1, "naam", false);
Assert.True(stationVerbindingRepository.DeletePerron(perron.Id));
}
public IActionResult Create(PerronDetailViewModel vm)
{
if (ModelState.IsValid)
{
Perron p = converter.ViewModelToPerron(vm);
long id = repo.CreatePerron(p);
return(RedirectToAction("Details", new { id }));
}
return(View());
}
public void GetStationbyId()
{
EmptyLists();
stationVerbindingRepository = new PerronRepository(context);
Perron perron = new Perron(2, "naam", true);
Assert.Equal(perron.Id, stationVerbindingRepository.GetPerronbyId(2).Id);
Assert.Equal(perron.Naam, stationVerbindingRepository.GetPerronbyId(2).Naam);
Assert.Equal(perron.Actief, stationVerbindingRepository.GetPerronbyId(2).Actief);
}
public void CreateStation()
{
EmptyLists();
stationVerbindingRepository = new PerronRepository(context);
Perron perron = new Perron(4, "naam", false);
Assert.Equal(4, stationVerbindingRepository.CreatePerron(perron));
}
public PerronDetailViewModel PerronToViewModel(Perron p)
{
PerronDetailViewModel vm = new PerronDetailViewModel()
{
Id = p.Id,
StationId = p.StationId,
Naam = p.Naam,
Actief = p.Actief
};
return(vm);
}
public long CreatePerron(Perron p)
{
string sql = "INSERT INTO Perron (naam, stationId, actief) VALUES(@naam,@stationId,@actief); SELECT SCOPE_IDENTITY()";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("naam", p.Naam.ToString()),
new KeyValuePair <string, string>("stationId", p.StationId.ToString()),
new KeyValuePair <string, string>("actief", "1")
};
DataSet result = ExecuteSql(sql, parameters);
long newId = Convert.ToInt64(Math.Round(Convert.ToDecimal(result.Tables[0].Rows[0][0]), 0));
return(newId);
}
public Perron GetPerronbyId(long id)
{
string sql = "Select * from Perron 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);
Perron p = null;
if (results != null && results.Tables[0].Rows.Count > 0)
{
p = DataSetParser.DataSetToPerron(results, 0);
}
return(p);
}
public IActionResult Edit(PerronDetailViewModel vm)
{
try
{
Perron perron = converter.ViewModelToPerron(vm);
bool succes = repo.UpdatePerron(perron);
if (succes)
{
return(RedirectToAction("Details", new { perron.Id }));
}
return(View());
}
catch
{
return(View());
}
}
public List <Perron> GetAllPerrons()
{
string sql = "Select * from Perron ";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();
DataSet results = ExecuteSql(sql, parameters);
List <Perron> perrons = new List <Perron>();
if (results != null)
{
for (int x = 0; x < results.Tables[0].Rows.Count; x++)
{
Perron p = DataSetParser.DataSetToPerron(results, x);
perrons.Add(p);
}
}
return(perrons);
}
public IActionResult Details(int id)
{
if (id < 1)
{
return(BadRequest("Id cannot be 0"));
}
Perron perron = repo.GetPerronbyId(id);
if (perron == null)
{
return(BadRequest("Perron could not be found"));
}
PerronDetailViewModel vm = converter.PerronToViewModel(perron);
return(View(vm));
}
public List <Perron> GetAllPerronsbyStationId(long stationId)
{
string sql = "Select * from Perron where stationId = @stationId";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("stationId", stationId.ToString())
};
DataSet results = ExecuteSql(sql, parameters);
List <Perron> perrons = new List <Perron>();
if (results != null)
{
for (int x = 0; x < results.Tables[0].Rows.Count; x++)
{
Perron p = DataSetParser.DataSetToPerron(results, x);
perrons.Add(p);
}
}
return(perrons);
}
public Perron GetPerronbyId(long id)
{
Perron perron = Perrons.FirstOrDefault(s => s.Id == id);
return(perron);
}
public long CreatePerron(Perron p)
{
Perrons.Add(p);
return(p.Id);
}
public long CreatePerron(Perron p)
{
throw new NotImplementedException();
}
public bool UpdatePerron(Perron p)
{
return(Context.UpdatePerron(p));
}
public long CreatePerron(Perron p)
{
return(Context.CreatePerron(p));
}
public void UpdatePerron(Perron p)
{
throw new NotImplementedException();
}
