private void EditData() { Festival editFestival = new Festival(); editFestival.Name = Festival.Name; editFestival.StartDate = Festival.StartDate; editFestival.EndDate = Festival.EndDate; Boolean TeVroeg = false; Boolean TeLaat = false; foreach (LineUp lu in _lineups) { if (lu.Date < editFestival.StartDate) { TeVroeg = true; } if (lu.Date > editFestival.EndDate) { TeLaat = true; } } if (TeVroeg == true) { MessageBox.Show("De wijzigingen werden niet toegepast. Bepaalde Optredens vallen voor de startdatum."); } else { if (TeLaat == true) { MessageBox.Show("De wijzigingen werden niet toegepast. Bepaalde Optredens vallen na de einddatum."); } else { Festival.EditData(editFestival); } } LineUpPageVM.UpdateAll(); }
public static void EditData(Festival festival) { String sSQL = "UPDATE Festival SET Name = @Name, StartDate = @StartDate, EndDate = @EndDate"; DbParameter par1 = Database.AddParameter("@Name", festival._Name); DbParameter par2 = Database.AddParameter("@StartDate", festival._StartDate); DbParameter par3 = Database.AddParameter("@EndDate", festival._EndDate); Database.ModifyData(sSQL, 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 Festival GetData() { Festival festival = new Festival(); String sSQL = "SELECT * FROM Festival"; DbDataReader reader = Database.GetData(sSQL); while (reader.Read()) { festival._Name = reader["Name"].ToString(); festival._StartDate = Convert.ToDateTime(reader["StartDate"].ToString()); festival._EndDate = Convert.ToDateTime(reader["EndDate"].ToString()); } return festival; }