public ActionResult Edit(tblMeasurement model) { if (ModelState.IsValid) { tblMeasurement tb = db.tblMeasurements.Where(m => m.MeasurementId == model.MeasurementId).FirstOrDefault(); tb.MemberId = model.MemberId; tb.Weight = model.Weight; tb.Chest = model.Chest; tb.Weist = model.Weist; tb.Hip = model.Hip; tb.Thigh = model.Thigh; tb.Bicep = model.Bicep; tb.Forearm = model.Forearm; tb.MeasurementDate = model.MeasurementDate; db.SaveChanges(); List <MemberViewModel> lstmemvm = new List <MemberViewModel>(); var users = db.tblUsers.ToList(); foreach (var item in users) { tblMembership tbm = db.tblMemberships.Where(m => m.UserId == item.UserId).FirstOrDefault(); if (tbm != null) { lstmemvm.Add(new MemberViewModel() { MemberId = tbm.MembershipId, Fullname = item.Fullname }); } } ViewBag.Fullname = lstmemvm; ViewBag.Message = "Measurement Updated"; } return(View());; }
public ActionResult Edit(int id) { MeasurementViewModel tb = new MeasurementViewModel(); tblMeasurement model = db.tblMeasurements.Where(m => m.MeasurementId == id).FirstOrDefault(); tb.MeasurementId = model.MeasurementId; tb.MemberId = model.MemberId; tb.Weight = model.Weight; tb.Chest = model.Chest; tb.Weist = model.Weist; tb.Hip = model.Hip; tb.Thigh = model.Thigh; tb.Bicep = model.Bicep; tb.Forearm = model.Forearm; tb.MeasurementDate = model.MeasurementDate; List <MemberViewModel> lstmemvm = new List <MemberViewModel>(); var users = db.tblUsers.Where(u => u.Usertype == "User").ToList(); foreach (var item in users) { tblMembership tbm = db.tblMemberships.Where(m => m.UserId == item.UserId).FirstOrDefault(); if (tbm != null) { lstmemvm.Add(new MemberViewModel() { MemberId = tbm.MembershipId, Fullname = item.Fullname }); } } ViewBag.Fullname = lstmemvm; return(View(tb)); }