public TicketTypesVM() { TicketTypes = TicketType.GetTicketTypes(); SelectedType = new TicketType(); Enabled = true; ShowEdit = "Hidden"; ShowCancel = "Hidden"; ShowSave = "Visible"; }
private void DeleteTicketType(TicketTypesVM tickettypevm) { if (SelectedType == null) return; TicketType.DeleteTicketType(SelectedType); SelectedType = new TicketType(); Enabled = true; ShowEdit = "Hidden"; ShowCancel = "Hidden"; ShowSave = "Visible"; }
private void SelectionChanged(TicketTypesVM tickettypevm) { if (SelectedType == null) return; if (ShowCancel == "Visible") CancelUpdateTicketType(this); _oldType = SelectedType.Copy(); tickettypevm.ShowEdit = "Visible"; tickettypevm.ShowCancel = "Hidden"; tickettypevm.ShowSave = "Hidden"; Enabled = false; }
private void AddTicketType(TicketTypesVM tickettypevm) { SelectedType = new TicketType(); _oldType = null; tickettypevm.ShowEdit = "Hidden"; tickettypevm.ShowCancel = "Visible"; tickettypevm.ShowSave = "Visible"; tickettypevm.Enabled = true; }
public static void UpdateTicketType(TicketType type) { // If _TicketTypes is null, create the Observable Collection if (_TicketTypes == null) GetTicketTypes(); try { // Update db DbParameter param1 = Database.AddParameter("@id", type.ID); DbParameter param2 = Database.AddParameter("@name", type.Name); DbParameter param3 = Database.AddParameter("@price", type.Price); DbParameter param4 = Database.AddParameter("@quantity", type.AvailableTickets); DbParameter param5 = Database.AddParameter("@available", type.TicketsLeft); int affectedRows = Database.ModifyData("UPDATE tickettype SET Name = @name, Price = @price, AvailableTickets = @quantity, TicketsLeft = @available WHERE id = @id", param1, param2, param3, param4, param5); if (affectedRows == 0) return; // Update _TicketTypes _TicketTypes[GetIndexByID(type.ID)] = type; } // Fail catch (Exception ex) { Console.WriteLine(ex.Message); } }
public static ObservableCollection<TicketType> GetTicketTypes() { // If _TicketTypes is null, create the Observable Collection if (_TicketTypes == null) { try { // Create _Contactperson _TicketTypes = new ObservableCollection<TicketType>(); // Get data DbDataReader reader = Database.GetData("SELECT * FROM tickettype"); foreach (DbDataRecord record in reader) { // Create new TicketType TicketType type = new TicketType(); // Get ID if (DBNull.Value.Equals(record["ID"])) type.ID = -1; else type.ID = Convert.ToInt32(record["ID"]); // Get Name if (DBNull.Value.Equals(record["Name"])) type.Name = ""; else type.Name = record["Name"].ToString(); // Get Price if (DBNull.Value.Equals(record["Price"])) type.Price = -1; else type.Price = Convert.ToDouble(record["Price"].ToString()); // Get AvailableTickets if (DBNull.Value.Equals(record["AvailableTickets"])) type.AvailableTickets = -1; else type.AvailableTickets = Convert.ToInt32(record["AvailableTickets"].ToString()); // Get TicketsLeft if (DBNull.Value.Equals(record["TicketsLeft"])) type.TicketsLeft = -1; else type.TicketsLeft = Convert.ToInt32(record["TicketsLeft"].ToString()); // Add TicketType _TicketTypes.Add(type); } if (reader != null) reader.Close(); } // Fail catch (Exception ex) { Console.WriteLine(ex.Message); // Clear TicketTypes _TicketTypes.Clear(); _TicketTypes = null; } } // Return _TicketTypes return _TicketTypes; }
public static void DeleteTicketType(TicketType type) { // If _TicketTypes is null, create the Observable Collection if (_TicketTypes == null) GetTicketTypes(); try { // Add to db DbParameter param = Database.AddParameter("@id", type.ID); int affectedRows = Database.ModifyData("DELETE FROM tickettype WHERE id = @id", param); if (affectedRows == 0) return; // Update _TicketTypes _TicketTypes.RemoveAt(GetIndexByID(type.ID)); } // Fail catch (Exception ex) { Console.WriteLine(ex.Message); } }
public static int AddTicketType(TicketType type) { // If _TicketTypes is null, create the Observable Collection if (_TicketTypes == null) GetTicketTypes(); try { // Add to db DbParameter param1 = Database.AddParameter("@name", type.Name); DbParameter param2 = Database.AddParameter("@price", type.Price); DbParameter param3 = Database.AddParameter("@quantity", type.Price); DbDataReader reader = Database.GetData("INSERT INTO tickettype(Name, Price, AvailableTickets, TicketsLeft) VALUES(@name, @price, @quantity, @quantity); SELECT LAST_INSERT_ID() AS ID;", param1, param2, param3); foreach (DbDataRecord record in reader) { // Get ID if (DBNull.Value.Equals(record["ID"])) type.ID = -1; else type.ID = Convert.ToInt32(record["ID"]); } if (reader != null) reader.Close(); _TicketTypes.Add(type); return type.ID; } // Fail catch (Exception ex) { Console.WriteLine(ex.Message); } return -1; }