public string Put(Reserveren res)
{
try
{
string query = @"update dbo.Reserveren set
Datum ='" + res.Datum + @"',
Tijd = '" + res.Tijd + @"',
GebruikerId = '" + res.GebruikerId + @"',
RuimteId ='" + res.RuimteId + @"'
where ReserverenId = " + res.ReserverenId + @"
";
DataTable table = new DataTable();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["MReserverenDB"].ConnectionString))
using (var cmd = new SqlCommand(query, con))
using (var da = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.Text;
da.Fill(table);
}
return("Resreveren is gewijzigd!!");
}
catch (Exception)
{
return("Reserveren wijzigen is mislukt!!");
}
}
public void Navigate(string page)
{
switch (page)
{
case "Parkings":
var parkings = new Parkings();
ApplicationHelper.NavigationService.Navigate(parkings);
break;
case "Parking":
var parking = new Parking();
ApplicationHelper.NavigationService.Navigate(parking);
break;
case "Home":
var home = new Home();
ApplicationHelper.NavigationService.Navigate(home);
break;
case "Reserveren":
var reserveren = new Reserveren();
ApplicationHelper.NavigationService.Navigate(reserveren);
break;
case "Statistiek":
var statistiek = new Statistiek();
ApplicationHelper.NavigationService.Navigate(statistiek);
break;
default:
break;
}
}
public string Post(Reserveren res)
{
try
{
string query = @"insert into dbo.Reserveren values
( '" + res.GebruikerId + @"',
'" + res.RuimteId + @"',
'" + res.Datum + @"',
'" + res.Tijd + @"')
";
DataTable table = new DataTable();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["MReserverenDB"].ConnectionString))
using (var cmd = new SqlCommand(query, con))
using (var da = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.Text;
da.Fill(table);
}
return("Reserveren is Gemaakt!!");
}
catch (Exception)
{
return("Reserveren mislukt!!");
}
}
