/// <summary> /// Creates a new event for the database /// </summary> /// <param name="Event">Event that has to be created</param> /// <returns>True if Database allows the changes false if not</returns> public static bool CreateEvent(Event Event) { bool Check = false; int ID = DatabaseGetHighestID.GetHighestID("Event"); if (DatabaseConnectie.OpenConnection()) { try { DatabaseConnectie.OpenConnection(); SqlCommand cmd = new SqlCommand(); cmd.Connection = DatabaseConnectie.connect; cmd.CommandText = "INSERT INTO Event (ID, Naam, Datum, Beschrijving, Locatie, Maxbezoekers, CampingID, AccountID) VALUES (@ID, @Name, @Date, @Description, @location, @MaxVisitors, @CampingID, @AccountID)"; cmd.Parameters.Add(new SqlParameter("ID", ID)); cmd.Parameters.Add(new SqlParameter("Name", Event.Name)); cmd.Parameters.Add(new SqlParameter("Date", Event.Date)); cmd.Parameters.Add(new SqlParameter("Description", Event.Description)); cmd.Parameters.Add(new SqlParameter("Location", Event.Location)); cmd.Parameters.Add(new SqlParameter("MaxVisitors", Event.MaxVisitors)); cmd.Parameters.Add(new SqlParameter("AccountID", Event.Account.ID)); if (Event.Camping == null) { cmd.Parameters.Add(new SqlParameter("CampingID", DBNull.Value)); } else { cmd.Parameters.Add(new SqlParameter("CampingID", Event.Camping.ID)); } cmd.ExecuteNonQuery(); DatabaseUpdateMaterial.UpdateMaterial(Event.MaterialList, ID); Check = true; } catch (SqlException e) { Console.WriteLine("Query Failed: " + e.StackTrace + e.Message.ToString()); Check = false; } finally { DatabaseConnectie.CloseConnection(); } } return(Check); }
/// <summary> /// Creates an account with RFID attached /// </summary> /// <param name="RFIDTag">Tag that has to be added to the account</param> /// <param name="Acccount">Account that has to be created</param> /// <returns>True if Database allows the changes false if not</returns> public static bool CreateAccountWithRFID(Account Account, string RFIDTag) { bool Check = false; int ID = DatabaseGetHighestID.GetHighestID("Account"); if (DatabaseConnectie.OpenConnection()) { try { DatabaseConnectie.OpenConnection(); SqlCommand cmd = new SqlCommand(); cmd.Connection = DatabaseConnectie.connect; cmd.CommandText = "INSERT INTO Account (ID, Gebruikersnaam, Wachtwoord, Functie, Naam, RFID) VALUES (@ID, @UserName, @Password, @Function, @Name, @RFID)"; cmd.Parameters.Add(new SqlParameter("Name", Account.Name)); cmd.Parameters.Add(new SqlParameter("UserName", Account.Username)); cmd.Parameters.Add(new SqlParameter("Password", Account.Password)); cmd.Parameters.Add(new SqlParameter("@ID", ID)); cmd.Parameters.Add(new SqlParameter("Function", Account.Function.ToString())); cmd.Parameters.Add(new SqlParameter("@RFID", RFIDTag)); cmd.ExecuteNonQuery(); Check = true; } catch (SqlException e) { Console.WriteLine("Query Failed: " + e.StackTrace + e.Message.ToString()); Check = false; } finally { DatabaseConnectie.CloseConnection(); } } return(Check); }
/// <summary> /// When a Event is being creater so does a timeline /// </summary> /// <returns>True if Database allows the changes false if not</returns> public static bool CreateTimeline() { bool Check = false; int ID = DatabaseGetHighestID.GetHighestID("Tijdlijn"); int EventID = GetLatestEventID(); if (DatabaseConnectie.OpenConnection()) { try { DatabaseConnectie.OpenConnection(); SqlCommand cmd = new SqlCommand(); cmd.Connection = DatabaseConnectie.connect; cmd.CommandText = "INSERT INTO Tijdlijn (ID, EventID) VALUES (@ID, @EventID)"; cmd.Parameters.Add(new SqlParameter("ID", ID)); cmd.Parameters.Add(new SqlParameter("EventID", EventID)); if (EventID > 0) { cmd.ExecuteNonQuery(); } Check = true; } catch (SqlException e) { Console.WriteLine("Query Failed: " + e.StackTrace + e.Message.ToString()); Check = false; } finally { DatabaseConnectie.CloseConnection(); } } return(Check); }
/// <summary> /// Creates a new column in the reservation table. /// </summary> /// <param name="Reservation">Reservation that need to be created</param> /// <returns>Returns true if the reservation is added and false if it failed.</returns> public static bool CreateReservation(Reservation Reservation) { bool Check = false; int ID = DatabaseGetHighestID.GetHighestID("Reservering"); if (DatabaseConnectie.OpenConnection()) { try { DatabaseConnectie.OpenConnection(); SqlCommand cmd = new SqlCommand(); cmd.Connection = DatabaseConnectie.connect; cmd.CommandText = "INSERT INTO Reservering (ID, PlaatsID, EventID, BetalingBedrag, BetalingStatus) VALUES (@ID, @PlaatsID, @EventID, @BetalingBedrag, @BetalingStatus)"; cmd.Parameters.Add(new SqlParameter("ID", Reservation.ID)); if (Reservation.Place != null) { cmd.Parameters.Add(new SqlParameter("PlaatsID", Reservation.Place.ID)); } else { cmd.Parameters.Add(new SqlParameter("PlaatsID", null)); } cmd.Parameters.Add(new SqlParameter("EventID", Reservation.Event.ID)); cmd.Parameters.Add(new SqlParameter("BetalingBedrag", Reservation.Payment.Amount)); //Converts the bool to a bit for the database. int paymentStatus; if (Reservation.Payment.Paid) { paymentStatus = 1; } else { paymentStatus = 0; } cmd.Parameters.Add(new SqlParameter("BetalingStatus", paymentStatus)); cmd.ExecuteNonQuery(); foreach (var account in Reservation.Accounts) { cmd.CommandText = "INSERT INTO Account_Reservering (AccountID, ReserveringID) VALUES (@AccountID, @ReserveringID)"; var para1 = cmd.Parameters.Add(new SqlParameter("AccountID", account.ID)); var para2 = cmd.Parameters.Add(new SqlParameter("ReserveringID", Reservation.ID)); cmd.ExecuteNonQuery(); cmd.Parameters.Remove(para1); cmd.Parameters.Remove(para2); } Check = true; } catch (SqlException e) { Console.WriteLine("Query Failed: " + e.StackTrace + e.Message.ToString()); Check = false; } finally { DatabaseConnectie.CloseConnection(); } } return(Check); }