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();
}
