public ActionResult GetMetalTypes([DataSourceRequest] DataSourceRequest request) { var baseValues = _metalRepository.GetMetalQualityBaseValues(); var coeficientValues = _metalRepository.GetAllMetalCoefficientsWeighting(); var metalTypes = _metalRepository.GetAllMetalTypes(); var models = new List <MetalTypeModel>(); foreach (var type in metalTypes) { var metalQualityBaseValue = type.MetalQualityBaseValues.FirstOrDefault(); var metalCoefficientWeighting = type.MetalCoefficientWeightings.FirstOrDefault(); var model = new MetalTypeModel { MetalTypeId = type.MetalId, MetalName = type.Name, ShearStrainRate = metalQualityBaseValue.ShearStrainRate, LoadingSpeed = metalQualityBaseValue.LoadingSpeed, LateralShearRate = metalQualityBaseValue.LateralShearRate, LongitudinalShearRate = metalQualityBaseValue.LongitudinalShearRate, SpallStrength = metalQualityBaseValue.SpallStrength, LateralShearRateC = metalCoefficientWeighting.LateralShearRate, LoadingSpeedC = metalCoefficientWeighting.LoadingSpeed, LongitudinalShearRateC = metalCoefficientWeighting.LongitudinalShearRate, SpallStrengthC = metalCoefficientWeighting.SpallStrength, ShearStrainRateC = metalCoefficientWeighting.SpallStrength }; models.Add(model); } return(Json(models.ToDataSourceResult(request))); }
public void EditMetalType(MetalTypeModel model) { using (ObjectContext context = new ObjectContext(_connectionString)) { var type = context.CreateObjectSet <Metal>().FirstOrDefault(x => x.MetalId == model.MetalTypeId); type.Name = model.MetalName; var baseValue = context.CreateObjectSet <MetalQualityBaseValue>().FirstOrDefault(x => x.MetalId == model.MetalTypeId); baseValue.LateralShearRate = model.LateralShearRate; baseValue.LoadingSpeed = model.LoadingSpeed; baseValue.LongitudinalShearRate = model.LongitudinalShearRate; baseValue.ShearStrainRate = model.ShearStrainRate; baseValue.SpallStrength = model.SpallStrength; var coeficient = context.CreateObjectSet <MetalCoefficientWeighting>().FirstOrDefault(x => x.MetalId == model.MetalTypeId); coeficient.LateralShearRate = model.LateralShearRateC; coeficient.LoadingSpeed = model.LoadingSpeedC; coeficient.LongitudinalShearRate = model.LongitudinalShearRateC; coeficient.ShearStrainRate = model.ShearStrainRateC; coeficient.SpallStrength = model.SpallStrengthC; context.SaveChanges(); } }
public void AddMetalType(MetalTypeModel model) { using (ObjectContext context = new ObjectContext(_connectionString)) { var type = new Metal { Name = model.MetalName }; var types = context.CreateObjectSet <Metal>(); types.AddObject(type); var baseValues = context.CreateObjectSet <MetalQualityBaseValue>(); var baseValue = new MetalQualityBaseValue { MetalId = type.MetalId, LateralShearRate = model.LateralShearRate, LoadingSpeed = model.LoadingSpeed, LongitudinalShearRate = model.LongitudinalShearRate, ShearStrainRate = model.ShearStrainRate, SpallStrength = model.SpallStrength }; baseValues.AddObject(baseValue); var coeficients = context.CreateObjectSet <MetalCoefficientWeighting>(); var coeficient = new MetalCoefficientWeighting { MetalId = type.MetalId, LateralShearRate = model.LateralShearRateC, LoadingSpeed = model.LoadingSpeedC, LongitudinalShearRate = model.LongitudinalShearRateC, ShearStrainRate = model.ShearStrainRateC, SpallStrength = model.SpallStrengthC }; coeficients.AddObject(coeficient); context.SaveChanges(); } }
public ActionResult EditMetalType(int id) { var type = _metalRepository.GetMetalType(id); var metalQualityBaseValue = type.MetalQualityBaseValues.FirstOrDefault(); var metalCoefficientWeighting = type.MetalCoefficientWeightings.FirstOrDefault(); var model = new MetalTypeModel { MetalTypeId = type.MetalId, MetalName = type.Name, ShearStrainRate = metalQualityBaseValue.ShearStrainRate, LoadingSpeed = metalQualityBaseValue.LoadingSpeed, LateralShearRate = metalQualityBaseValue.LateralShearRate, LongitudinalShearRate = metalQualityBaseValue.LongitudinalShearRate, SpallStrength = metalQualityBaseValue.SpallStrength, LateralShearRateC = metalCoefficientWeighting.LateralShearRate, LoadingSpeedC = metalCoefficientWeighting.LoadingSpeed, LongitudinalShearRateC = metalCoefficientWeighting.LongitudinalShearRate, SpallStrengthC = metalCoefficientWeighting.SpallStrength, ShearStrainRateC = metalCoefficientWeighting.SpallStrength }; return(View(model)); }
public ActionResult EditMetalType(MetalTypeModel model) { _metalRepository.EditMetalType(model); return(RedirectToAction("MetalTypes")); }