public static void EditType(TicketType type) { String sql = "UPDATE TicketType Set Name=@Name, Price=@Price, AvailableTickets=@AvailableTickets WHERE ID=@ID"; DbParameter par1 = Database.AddParameter("@ID", type.ID); DbParameter par2 = Database.AddParameter("@Name", type.Name); DbParameter par3 = Database.AddParameter("@Price", type.Price); DbParameter par4 = Database.AddParameter("@AvailableTickets", type.AvailableTickets); if (par1.Value == null) par1.Value = DBNull.Value; Database.ModifyData(sql, par1, par2, par3, par4); }
public static void DeleteType(TicketType type) { String sql = "DELETE FROM TicketType WHERE ID = @ID"; DbParameter par1 = Database.AddParameter("@ID", type._ID); if (par1.Value == null) par1.Value = DBNull.Value; Database.ModifyData(sql, par1); }
public static TicketType getByID(String ID) { TicketType type = new TicketType(); String sSQL = "SELECT * FROM TicketType WHERE ID = @ID"; DbParameter par1 = Database.AddParameter("@ID", ID); if (par1.Value == null) par1.Value = DBNull.Value; DbDataReader reader = Database.GetData(sSQL, par1); while (reader.Read()) { type.ID = ID; type.Name = reader["Name"].ToString(); type.Price = Convert.ToDouble(reader["Price"].ToString()); type.AvailableTickets = Int32.Parse(reader["AvailableTickets"].ToString()); } return type; }
public static void NewType(TicketType type) { String sql = "INSERT INTO TicketType (Name, Price, AvailableTickets) VALUES(@Name, @Price, @AvailableTickets)"; DbParameter par1 = Database.AddParameter("@Name", type.Name); DbParameter par2 = Database.AddParameter("@Price", type.Price); DbParameter par3 = Database.AddParameter("@AvailableTickets", type.AvailableTickets); if (par1.Value == null) par1.Value = DBNull.Value; Database.ModifyData(sql, par1, par2, par3); }
//string IDataErrorInfo.Error //{ // get { return "Model not valid"; } //} //string IDataErrorInfo.this[string columnName] //{ // get // { // try // { // object value = this.GetType().GetProperty(columnName).GetValue(this); // Validator.ValidateProperty(value, new ValidationContext(this, null, null) // { // MemberName = columnName // }); // } // catch (ValidationException ex) // { // return ex.Message; // } // return String.Empty; // } //} #endregion public static ObservableCollection<TicketType> getAll() { ObservableCollection<TicketType> lijst = new ObservableCollection<TicketType>(); String sSQL = "SELECT * FROM TicketType"; DbDataReader reader = Database.GetData(sSQL); while (reader.Read()) { TicketType aNew = new TicketType(); aNew.ID = reader["ID"].ToString(); aNew.Name = reader["Name"].ToString(); aNew.Price = Convert.ToDouble(reader["Price"].ToString()); aNew.AvailableTickets = Int32.Parse(reader["AvailableTickets"].ToString()); lijst.Add(aNew); } return lijst; }