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;
}
