public void saveChanges() { using (var db = new PlanningContext()) { device_history data = null; if (!this._isCreateMode) { var id = Convert.ToInt32(this.device_history_id.Text); data = db.device_history.Where(d => d.device_history_id == id).FirstOrDefault(); if (data == null) { this._mainInterface.statusText = $"ERROR: ID '{this.device_history_id.Text}' does not exist."; return; } } else { data = new device_history(); } data.device_history_id = Convert.ToInt32(this.device_history_id.Text); data.datetime = (DateTime)this.datetime.SelectedDate; data.is_active = (bool)this.is_active.IsChecked; data.comment = /**/ (this.comment.Text); 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); })(); data.device_history_action = new Func <device_history_action>(() => { foreach (var v in db.device_history_action) { if (v.device_history_action1 == (this.device_history_action.item as device_history_action).device_history_action1) { return(v); } } return(null); })(); data.supplier = new Func <supplier>(() => { foreach (var v in db.suppliers) { if (v.supplier_id == (this.supplier.item as supplier).supplier_id) { return(v); } } return(null); })(); if (this._isCreateMode) { db.device_history.Add(data); } db.SaveChanges(); } }
public async Task <ActionResult <device_history> > Postdevice_history(device_history device_history) { _context.device_histories.Add(device_history); await _context.SaveChangesAsync(); return(new OkObjectResult(new { Success = true, Message = "Ok", Data = CreatedAtAction("Getdevice_history", new { id = device_history.device_history_id }, device_history) })); }
public void deleteItem(object item) { if (item == null) { return; } device_history data = item as device_history; if (data == null) { return; } using (var db = new PlanningContext()) { db.device_history.Remove(db.device_history.Where(d => d.device_history_id == data.device_history_id).First()); db.SaveChanges(); } }
public async Task <IActionResult> Putdevice_history(int id, device_history device_history) { if (id != device_history.device_history_id) { return(new OkObjectResult(new { Success = false, Message = "Ok", Data = BadRequest() })); } _context.Entry(device_history).State = EntityState.Modified; try { return(new OkObjectResult(new { Success = true, Message = "Ok", Data = _context.SaveChangesAsync() })); } catch (DbUpdateConcurrencyException) { if (!device_historyExists(id)) { return(new OkObjectResult(new { Success = false, Message = "Ok", Data = NotFound() })); } else { throw; } } }