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