public void saveChanges() { using (var db = new PlanningContext()) { action_level data = null; if (!this._isCreateMode) { var id = Convert.ToInt32(this.action_level_id.Text); data = db.action_level.Where(d => d.action_level_id == id).FirstOrDefault(); if (data == null) { this._mainInterface.statusText = $"ERROR: ID '{this.action_level_id.Text}' does not exist."; return; } } else { data = new action_level(); } data.action_level_id = Convert.ToInt32(this.action_level_id.Text); data.value = Convert.ToDouble(this.value.Text); data.is_active = (bool)this.is_active.IsChecked; data.comment = /**/ (this.comment.Text); data.action_type = new Func <action_type>(() => { foreach (var v in db.action_type) { if (v.action_type_id == (this.action_type.item as action_type).action_type_id) { return(v); } } return(null); })(); data.device = new Func <device>(() => { foreach (var v in db.devices) { if (v.device_id == (this.device.item as device).device_id) { return(v); } } return(null); })(); if (this._isCreateMode) { db.action_level.Add(data); } db.SaveChanges(); } }
public void deleteItem(object item) { if (item == null) { return; } action_level data = item as action_level; if (data == null) { return; } using (var db = new PlanningContext()) { db.action_level.Remove(db.action_level.Where(d => d.action_level_id == data.action_level_id).First()); db.SaveChanges(); } }