public LineUpPageVM(){
_lineups = LineUp.getAll();
_podia = Stage.getAll();
_bands = Band.getAll();
_stages = Stage.getAll();
_newLineUp = new LineUp();
_newStage = "";
_festival = Festival.GetData();
_start = _festival.StartDate;
_end = _festival.EndDate;
_newLineUp.Date = _festival.StartDate;
_data = Start;
}
public static void EditLineUp(LineUp lineup, string SID, string BID)
{
String sql = "UPDATE LineUp Set Date=@Date, Vanaf=@Vanaf, Until=@Until, Stage=@Stage, Band=@Band WHERE ID=@ID";
DbParameter par1 = Database.AddParameter("@ID", lineup.ID);
DbParameter par2 = Database.AddParameter("@Date", lineup.Date);
DbParameter par3 = Database.AddParameter("@Vanaf", lineup.From);
DbParameter par4 = Database.AddParameter("@Until", lineup.Until);
DbParameter par5 = Database.AddParameter("@Stage", SID);
DbParameter par6 = Database.AddParameter("@Band", BID);
if (par1.Value == null) par1.Value = DBNull.Value;
if (par2.Value == null) par2.Value = DBNull.Value;
if (par3.Value == null) par3.Value = DBNull.Value;
if (par4.Value == null) par4.Value = DBNull.Value;
if (par5.Value == null) par5.Value = DBNull.Value;
if (par6.Value == null) par6.Value = DBNull.Value;
Database.ModifyData(sql, par1, par2, par3, par4, par5, par6);
}
public static void NewLineUp(LineUp lineup, string SID, string BID)
{
String sql = "INSERT INTO LineUp VALUES(@Date, @Vanaf, @Until, @Stage, @Band)";
DbParameter par1 = Database.AddParameter("@Date", lineup.Date);
DbParameter par2 = Database.AddParameter("@Vanaf", lineup.From);
DbParameter par3 = Database.AddParameter("@Until", lineup.Until);
DbParameter par4 = Database.AddParameter("@Stage", SID);
DbParameter par5 = Database.AddParameter("@Band", BID);
if (par1.Value == null) par1.Value = DBNull.Value;
if (par2.Value == null) par2.Value = DBNull.Value;
if (par3.Value == null) par3.Value = DBNull.Value;
if (par4.Value == null) par4.Value = DBNull.Value;
if (par5.Value == null) par5.Value = DBNull.Value;
Database.ModifyData(sql, par1, par2, par3, par4, par5);
}
public static void DeleteLineUp(LineUp lineup)
{
String sql = "DELETE FROM LineUp WHERE ID = @ID";
DbParameter par1 = Database.AddParameter("@ID", lineup._ID);
if (par1.Value == null) par1.Value = DBNull.Value;
Database.ModifyData(sql, par1);
}
//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<LineUp> getAll()
{
ObservableCollection<LineUp> lijst = new ObservableCollection<LineUp>();
String sSQL = "SELECT * FROM LineUp ORDER BY Date, Vanaf";
DbDataReader reader = Database.GetData(sSQL);
while (reader.Read())
{
LineUp aNew = new LineUp();
aNew.ID = reader["ID"].ToString();
aNew.Date = Convert.ToDateTime(reader["Date"].ToString());
aNew.From = reader["Vanaf"].ToString();
aNew.Until = reader["Until"].ToString();
string BandID = reader["Band"].ToString();
string StageID = reader["Stage"].ToString();
aNew.Band = Band.getBand(BandID);
aNew.Stage = Stage.getStage(StageID);
lijst.Add(aNew);
}
return lijst;
}
