public bool UpdatePlek(Plek plek)
{
using (SqlConnection connection = Database.Connection)
{
string query = "UPDATE PLEK SET nummer = @num, capaciteit = @cap WHERE Id = @id";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@num", plek.Nummer);
command.Parameters.AddWithValue("@cap", plek.Capaciteit);
command.Parameters.AddWithValue("@id", plek.ID);
command.ExecuteNonQuery();
try
{
if (Convert.ToInt32(command.ExecuteNonQuery()) > 0)
{
return(true);
}
}
catch (SqlException e)
{
}
}
}
return(false);
}
// GET: Reservering/Details/5
public ActionResult Details(decimal id)
{
newReservering = reserveringrepo.GetReserveringById(id);
newPersoon = persoonrepo.getHoofdboekerByReserveringId((decimal)newReservering.PersonId);
plekken = plekrepo.GetPlekId(id);
newPlek = plekrepo.GetPlekById(plekken);
Plek plek = newPlek.First();
newLocatie = locatierepo.GetLocatieById(plek.LocatieId);
newEvent = eventrepo.GetEventById(newLocatie.Id);
List <Groepslid> groepsleden = groepslidrepo.getGroepsledenByReserveringId(Convert.ToInt32(id));
var viewmodel = new ReserveringViewModelELPRP()
{
events = newEvent,
locatie = newLocatie,
plekken = newPlek,
reservering = newReservering,
persoon = newPersoon,
groepsleden = groepsleden
};
return(View(viewmodel));
}
private Plek CreatePlekFromReader(SqlDataReader reader)
{
int id = Convert.ToInt32(reader["ID"]);
Plek plek = new Plek()
{
ID = id,
LocatieID = Convert.ToInt32(reader["LocatieID"]),
specificatie = GetSpecificatie(id)
};
return(plek);
}
public ActionResult EditPlekken(List <Plek> plekken)
{
foreach (Plek nieuwePlek in plekken)
{
Plek plek = plekrepo.GetPlekById(nieuwePlek.ID);
plek.ID = nieuwePlek.ID;
plek.LocatieId = nieuwePlek.LocatieId;
plek.Nummer = nieuwePlek.Nummer;
plek.Capaciteit = nieuwePlek.Capaciteit;
plekrepo.UpdatePlek(plek);
}
return(RedirectToAction("Index"));
}
//post AddLocatie with plekken
public ActionResult AddLocation(FormCollection collection)
{
Locatie locatie = new Locatie(collection["locatie.Naam"], collection["locatie.Straat"], collection["locatie.Nummer"], collection["locatie.Postcode"], collection["locatie.Plaats"]);
int plekAmount = Convert.ToInt32(collection["plekAmount"]);
locrepo.InsertLocatie(locatie);
int lastInsertedLocationId = locrepo.GetLocatieId();
for (int i = 1; i <= plekAmount; i++) //voor het ingegeven aantal plekken genereren
{
int x = 1; //huisnummers
Plek plek = new Plek(lastInsertedLocationId, Convert.ToString(x), 0);
plekrepo.InsertPlek(plek);
x++;
}
return(RedirectToAction("Locaties"));
}
public Plek InsertPlek(Plek plek)
{
using (SqlConnection connection = Database.Connection)
{
string query = "INSERT INTO PLEK (nummer, capaciteit)" +
"VALUES (@num, @cap)";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@num", plek.Nummer);
command.Parameters.AddWithValue("@cap", plek.Capaciteit);
try
{
command.ExecuteNonQuery();
}
catch (SqlException e)
{
}
return(plek);
}
}
}
public bool InsertReserveringPlek(Reservering reservering, Plek plek)
{
using (SqlConnection connection = Database.Connection)
{
string query = "INSERT INTO PLEK_RESERVERING (PlekID, ReserveringID) VALUES (@PlekID, @ReserveringID)";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@ReserveringID", reservering.ID);
command.Parameters.AddWithValue("@PlekID", plek.ID);
try
{
command.ExecuteNonQuery();
}
catch (SqlException)
{
throw;
}
}
}
return(true);
}
public bool UpdatePlek(Plek plek)
{
return(context.UpdatePlek(plek));
}
public Plek InsertPlek(Plek plek)
{
return(context.InsertPlek(plek));
}