public void Insert(Polsbandje polsbandje, Reservering reservering, Account account)
{
try
{
using (SqlConnection connection = Connection.SQLconnection)
{
string query = "INSERT INTO polsbandje (barcode, actief) VALUES (@barcode, 0)";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@barcode", polsbandje.Barcode);
command.ExecuteNonQuery();
}
string queryReserveringPolsbandje = "INSERT INTO RESERVERING_POLSBANDJE (reservering_id, polsbandje_id, account_id, aanwezig) VALUES (@reserveringId, @polsbandjeId, @accountId, 0)";
using (SqlCommand command = new SqlCommand(queryReserveringPolsbandje, connection))
{
command.Parameters.AddWithValue("@reserveringId", reservering.Id);
command.Parameters.AddWithValue("@polsbandjeId", polsbandje.Id);
command.Parameters.AddWithValue("@accountId", account.Id);
command.ExecuteNonQuery();
}
}
}
catch (Exception)
{
}
}
public Polsbandje GetById(Polsbandje polsbandje)
{
try
{
using (SqlConnection connection = Connection.SQLconnection)
{
string query =
"SELECT POLSBANDJE.ID, POLSBANDJE.barcode, POLSBANDJE.actief, RESERVERING_POLSBANDJE.reservering_id, RESERVERING_POLSBANDJE.polsbandje_id, RESERVERING_POLSBANDJE.account_id, RESERVERING_POLSBANDJE.aanwezig FROM POLSBANDJE INNER JOIN RESERVERING_POLSBANDJE ON (POLSBANDJE.ID=RESERVERING_POLSBANDJE.polsbandje_id) WHERE RESERVERING_POLSBANDJE.account_id = @id";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@id", polsbandje.Id);
using (SqlDataReader reader = command.ExecuteReader())
{
//return ReaderToAccount(reader);
while (reader.Read())
{
return(ReaderToPolsbandje(reader));
}
return(null);
}
}
}
}
catch
{
return(null);
}
}
public void Delete(Polsbandje polsbandje)
{
try
{
using (SqlConnection connection = Connection.SQLconnection)
{
string query =
"DELETE FROM POLSBANDJE WHERE ID = @id";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@id", polsbandje.Id);
command.ExecuteNonQuery();
}
string queryReserveringPolsbandje =
"DELETE FROM RESERVERING_POLSBANDJE WHERE polsbandje_id = @id";
using (SqlCommand command = new SqlCommand(queryReserveringPolsbandje, connection))
{
command.Parameters.AddWithValue("@id", polsbandje.Id);
command.ExecuteNonQuery();
}
}
}
catch
{
}
}
public bool UpdatePolsbandje(Polsbandje polsbandje)
{
using (SqlConnection connection = Database.Connection)
{
string query = "UPDATE Polsbandje SET Barcode = @barcode, Actief = @actief WHERE Id = @id";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@id", polsbandje.Id);
command.Parameters.AddWithValue("@barcode", polsbandje.Barcode);
command.Parameters.AddWithValue("@actief", polsbandje.Actief);
command.ExecuteNonQuery();
try
{
if (Convert.ToInt32(command.ExecuteNonQuery()) > 0)
{
return(true);
}
}
catch (SqlException e)
{
}
}
}
return(false);
}
public Polsbandje GetEventByPolsbandjeId(int id)
{
using (SqlConnection connection = Database.Connection)
{
string query = "SELECT e.naam, e.datumstart, e.datumEinde, e.maxBezoekers, p.nummer, p.capaciteit" +
"FROM EVENT e " +
"INNER JOIN LOCATIE l ON l.ID = e.locatie_id" +
"INNER JOIN PLEK p ON p.locatie_id = l.ID " +
"INNER JOIN PLEK_RESERVERING pr ON pr.plek_id = p.ID" +
"INNER JOIN RESERVERING r ON pr.reservering_id = r.ID" +
"INNER JOIN RESERVERING_POLSBANDJE rp ON rp.reservering_id = r.ID" +
"INNER JOIN POLSBANDJE po ON rp.polsbandje_id = po.ID WHERE po.ID = @id";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
polsbandje = CreatePolsbandjeFromReader(reader);
}
}
}
}
return(polsbandje);
}
public ActionResult KoppelRFID(string RFID)
{
Session["RFID"] = RFID;
Account account = (Account)Session["account"];
Polsbandje polsbandje = polsbandjeRepository.GetByAccountId(account);
polsbandjeRepository.ConnectAccountWithRFID(RFID, polsbandje, account);
return(RedirectToAction("Index"));
}
// GET: Polsbandje/Details/5
public ActionResult Details(int id)
{
Polsbandje polsbandje = polsrepo.GetEventByPolsbandjeId(id);
if (polsbandje != null)
{
return(View(polsbandje));
}
else
{
return(HttpNotFound());
}
}
// GET: Polsbandje/Edit/5
public ActionResult Edit(int id)
{
Polsbandje polsbandje = polsrepo.GetPolsbandjeById(id);
if (polsbandje != null)
{
return(View(polsbandje));
}
else
{
return(HttpNotFound());
}
}
public ActionResult Create(FormCollection collection)
{
try
{
// TODO: Add insert logic here
Polsbandje polsbandje = new Polsbandje(collection["Barcode"], Convert.ToDecimal(collection["Actief"]));
polsrepo.InsertPolsbandje(polsbandje);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, FormCollection collection)
{
Polsbandje polsbandje = new Polsbandje(collection["Barcode"], Convert.ToDecimal(collection["Actief"]));
try
{
// TODO: Add update logic here
polsrepo.UpdatePolsbandje(polsbandje);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Index(string email, string activatiehash)
{
if (Session["event"] != null)
{
if (Session["adminLogin"] != null || Session["adminLogin"].ToString() == "true")
{
Event huidigEvent = (Event)Session["event"];
ModelToViewModel.EventToEventViewModel(huidigEvent);
Account account = accountRepository.GetCompleteAccountByEmailAndActivationhash(email, activatiehash);
if (account != null)
{
Polsbandje polsbandje = polsbandjeRepository.GetByAccountId(account);
Reservering reservering = reserveringRepository.GetById(polsbandje.ReserveringsId);
Session["account"] = account;
//Check if account made a reservation for current event
if (reservering.EvenementIDReservering.ID1 == huidigEvent.ID1)
{
Session["account"] = account;
AccountViewModel acwm = ModelToViewModel.ConvertAccounttoViewModel(account);
return(View(acwm));
}
else
{
return(View("Error"));
}
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
return(RedirectToAction("AdminLogin", "Account"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public void Insertpolsbandje(Polsbandje polsbandje)
{
try
{
using (SqlConnection connection = Connection.SQLconnection)
{
string query = "INSERT INTO polsbandje (barcode, actief) VALUES (@barcode, 0)";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@barcode", polsbandje.Barcode);
command.ExecuteNonQuery();
}
}
}
catch (Exception)
{
}
}
public void setPolsbandjeAfwezig(Polsbandje polsbandje)
{
try
{
using (SqlConnection connection = Connection.SQLconnection)
{
string query = "UPDATE RESERVERING_POLSBANDJE SET aanwezig = 0 WHERE polsbandje_id=@polsbandjeID";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@barcode", polsbandje.Barcode);
command.ExecuteNonQuery();
}
}
}
catch (Exception)
{
}
}
public Polsbandje GetPolsbandjeById(decimal id)
{
using (SqlConnection connection = Database.Connection)
{
string query = "SELECT * FROM Polsbandje WHERE ID=@id";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
polsbandje = CreatePolsbandjeFromReader(reader);
}
}
}
}
return(polsbandje);
}
public void ConnectAccountWithRFID(string RFID, Polsbandje polsbandje, Account account)
{
try
{
using (SqlConnection connection = Connection.SQLconnection)
{
string queryUpdatePolsbandje = "UPDATE POLSBANDJE SET barcode = @RFID, actief = 1 WHERE ID IN (SELECT polsbandje_id FROM RESERVERING_POLSBANDJE WHERE account_id=@accountId);";
using (SqlCommand command = new SqlCommand(queryUpdatePolsbandje, connection))
{
command.Parameters.AddWithValue("@RFID", RFID);
command.Parameters.AddWithValue("@accountId", account.Id);
command.ExecuteNonQuery();
}
}
}
catch (Exception)
{
}
}
public Polsbandje InsertPolsbandje(Polsbandje polsbandje)
{
using (SqlConnection connection = Database.Connection)
{
string query = "INSERT INTO Polsbandje (Barcode, Actief)" +
"VALUES (@barcode, @actief)";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@barcode", polsbandje.Barcode);
command.Parameters.AddWithValue("@actief", polsbandje.Actief);
try
{
command.ExecuteNonQuery();
}
catch (SqlException e)
{
}
return(polsbandje);
}
}
}
[HttpPost] //Actionresult scanning RFID
public ActionResult AanwezigAfwezig(string RFID)
{
Event huidigEvent = (Event)Session["event"];
ModelToViewModel.EventToEventViewModel(huidigEvent);
Account account = accountRepository.GetCompleteAccountsByRRFID(RFID);
if (account != null)
{
Polsbandje polsbandje = polsbandjeRepository.GetByAccountId(account);
Reservering reservering = reserveringRepository.GetById(polsbandje.ReserveringsId);
if (polsbandje.Aanwezig)
{
polsbandjeRepository.setPolsbandjeAfwezig(polsbandje);
Session["in-/uitcheck"] = "Status veranderd naar afwezig";
return(View());
}
else
{
//Check if account made a reservation for current event
if (reservering.EvenementIDReservering.ID1 == huidigEvent.ID1)
{
polsbandjeRepository.setPolsbandjeAanwezig(polsbandje);
AccountViewModel acwm = ModelToViewModel.ConvertAccounttoViewModel(account);
Session["in-/uitcheck"] = "Status veranderd naar aanwezig";
return(View(acwm));
}
else
{
return(View("Error"));
}
}
}
else
{
return(RedirectToAction("Index"));
}
}
public void Insertpolsbandje(Polsbandje polsbandje)
{
context.Insertpolsbandje(polsbandje);
}
public void Delete(Polsbandje polsbandje)
{
context.Delete(polsbandje);
}
public void setPolsbandjeAanwezig(Polsbandje polsbandje)
{
context.setPolsbandjeAanwezig(polsbandje);
}
public void ConnectAccountWithRFID(string RFID, Polsbandje polsbandje, Account account)
{
context.ConnectAccountWithRFID(RFID, polsbandje, account);
}
public void Insert(Polsbandje polsbandje, Reservering reservering, Account account)
{
context.Insert(polsbandje, reservering, account);
}
public Polsbandje GetById(Polsbandje polsbandje)
{
return(context.GetById(polsbandje));
}
public Polsbandje InsertPolsbandje(Polsbandje polsbandje)
{
return(context.InsertPolsbandje(polsbandje));
}
public bool UpdatePolsbandje(Polsbandje polsbandje)
{
return(context.UpdatePolsbandje(polsbandje));
}
