public static void EditStage(Stage stage, String naam) { String sql = "UPDATE Stage Set Name=@naam WHERE ID=@ID"; DbParameter par1 = Database.AddParameter("@ID", stage.ID); DbParameter par2 = Database.AddParameter("@naam", naam); if (par2.Value == null) par2.Value = DBNull.Value; Database.ModifyData(sql, par1, par2); }
public static Stage getStage(String id) { Stage stage = new Stage(); String sSQL = "SELECT * FROM Stage 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()) { stage.Name = reader["Name"].ToString(); stage.ID = id; } return stage; }
public static void DeleteStage(Stage stage) { String sql = "DELETE FROM Stage WHERE ID = @Stage"; DbParameter par1 = Database.AddParameter("@Stage", stage._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<Stage> getAll() { ObservableCollection<Stage> lijst = new ObservableCollection<Stage>(); String sSQL = "SELECT * FROM Stage"; DbDataReader reader = Database.GetData(sSQL); while (reader.Read()) { Stage aNew = new Stage(); aNew.ID = reader["ID"].ToString(); aNew.Name = reader["Name"].ToString(); lijst.Add(aNew); } return lijst; }