public void UpdateCreateViewModel(Models.CreateViewModel cvm) { CDLContext db = new CDLContext(); Bridge bridge = new Bridge(); bridge = db.Bridge.Find(cvm.BridgeId); State st = new State(); st = db.State.Where(s => cvm.State == s.PostalCode).FirstOrDefault(); bridge.Address1 = cvm.Address1; bridge.City = cvm.City; bridge.State = st; bridge.PostalCode = cvm.PostalCode; bridge.LastUpdated = DateTime.UtcNow; bridge.Height = cvm.Height; bridge.Latitude = cvm.Latitude; bridge.Longitude = cvm.Longitude; if (bridge.Weights.Count >= 1) bridge.Weights.ElementAt(0).maxWeight = cvm.WeightStraight; if (bridge.Weights.Count >= 2) bridge.Weights.ElementAt(1).maxWeight = cvm.WeightSingle; if (bridge.Weights.Count >= 3) bridge.Weights.ElementAt(2).maxWeight = cvm.WeightDouble; db.SaveChanges(); }
public void SaveCreateViewModel(Models.CreateViewModel cvm) { CDLContext db = new CDLContext(); Bridge bridge = new Bridge(); List<Weight> weights = new List<Weight>(); Weight weight1 = new Weight(); Weight weight2 = new Weight(); Weight weight3 = new Weight(); State st = new State(); st = db.State.Where(s => cvm.State == s.PostalCode).FirstOrDefault(); bridge.Address1 = cvm.Address1; bridge.City = cvm.City; bridge.State = st; bridge.PostalCode = cvm.PostalCode; bridge.LastUpdated = DateTime.UtcNow; bridge.Height = cvm.Height; bridge.Latitude = cvm.Latitude; bridge.Longitude = cvm.Longitude; weight1.maxWeight = cvm.WeightStraight; weight1.TruckType = TruckType.Straight; weights.Add(weight1); weight2.maxWeight = cvm.WeightSingle; weight2.TruckType = TruckType.Single; weights.Add(weight2); weight3.maxWeight = cvm.WeightDouble; weight3.TruckType = TruckType.Double; weights.Add(weight3); bridge.Weights = weights; db.Bridge.Add(bridge); db.SaveChanges(); }