public async Task <IActionResult> Edit(int id, [Bind("Id,Chest,Biceps,Waist,Hips,Thigh,Calf,Height,Weight,TimeStamp")] MeasurementRecord measurementRecord) { if (id != measurementRecord.Id || !_userService.IsCurrentUsersMeasurement(id, await _userManager.GetUserAsync(User))) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(measurementRecord); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MeasurementRecordExists(measurementRecord.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(measurementRecord)); }
public bool Edit(MeasurementRecord newInstance) { var db = new MaterialMeasurementEntities(); try { var currentInstance = db.MeasurementRecords.FirstOrDefault(m => m.ID == newInstance.ID); if (currentInstance == null) { return(false); } currentInstance.RecordDate = newInstance.RecordDate; currentInstance.ResultMaterialID = newInstance.ResultMaterialID; currentInstance.Weight = newInstance.Weight; currentInstance.WeightUnit = newInstance.WeightUnit; currentInstance.Description = newInstance.Description; currentInstance.ParcelCode = newInstance.ParcelCode; db.Entry(currentInstance).State = System.Data.Entity.EntityState.Modified; SaveChanges(db); } catch (Exception) { return(false); } return(true); }
public async Task <IActionResult> Create([Bind("Id,Chest,Biceps,Waist,Hips,Thigh,Calf,Height,Weight,TimeStamp")] MeasurementRecord measurementRecord) { if (ModelState.IsValid) { var user = await _userManager.GetUserAsync(User); measurementRecord.TimeStamp = DateTime.Now; measurementRecord.User = user; _context.MeasurementRecords.Add(measurementRecord); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(measurementRecord)); }
public bool Add(MeasurementRecord newInstance) { var db = new MaterialMeasurementEntities(); try { db.MeasurementRecords.Add(newInstance); SaveChanges(db); } catch (Exception) { return(false); } return(true); }
public async Task <IActionResult> RecordMeasurement(List <DataPointRecord> records, string urNumber, [FromQuery(Name = "categoryIdList")] List <int> categoryId) { try { await _context.Database.BeginTransactionAsync(); var recordedDate = DateTime.Now; foreach (int catId in categoryId) { var measurementRecord = new MeasurementRecord { DateTimeRecorded = recordedDate, MeasurementId = records.FirstOrDefault().MeasurementId, CategoryId = catId, Urnumber = urNumber }; _context.MeasurementRecord.Add(measurementRecord); await _context.SaveChangesAsync(); foreach (DataPointRecord record in records) { record.MeasurementRecordId = measurementRecord.MeasurementRecordId; _context.DataPointRecord.Add(record); } await _context.SaveChangesAsync(); } _context.Database.CommitTransaction(); } catch (Exception ex) { _context.Database.RollbackTransaction(); return(BadRequest(ex.Message)); } return(Ok()); }