private void InsertNewInflectionCalMethod(InflectionCalMethodViewModel item)
{
var newcat = new TRACK_COMPART_WORN_LIMIT_CAT
{
compartid_auto = item.CompartId,
MeasurePointId = item.MeasurementPointId,
track_tools_auto = item.ToolId,
track_compart_worn_limit_cat_auto = item.WornCalculationMethodTypeId,
adjust_base = item.Adjust_base == null ? 0 : item.Adjust_base,
hi_inflectionPoint = item.Hi_InflectionPoint == null ? 0 : item.Hi_InflectionPoint,
hi_intercept1 = item.Hi_Intercept1 == null ? 0 : item.Hi_Intercept1,
hi_intercept2 = item.Hi_Intercept2 == null ? 0 : item.Hi_Intercept2,
hi_slope1 = item.Hi_Slope1 == null ? 0 : item.Hi_Slope1,
hi_slope2 = item.Hi_Slope2 == null ? 0 : item.Hi_Slope2,
mi_inflectionPoint = item.Mi_InflectionPoint == null ? 0 : item.Mi_InflectionPoint,
mi_intercept1 = item.Mi_Intercept1 == null ? 0 : item.Mi_Intercept1,
mi_intercept2 = item.Mi_Intercept2 == null ? 0 : item.Mi_Intercept2,
mi_slope1 = item.Mi_Slope1 == null ? 0 : item.Mi_Slope1,
mi_slope2 = item.Mi_Slope2 == null ? 0 : item.Mi_Slope2,
slope = item.Slope == null ? 0 : item.Slope,
};
_context.TRACK_COMPART_WORN_LIMIT_CAT.Add(newcat);
}
private void UpdateExsistingInflectionCalculationMethod(InflectionCalMethodViewModel item, TRACK_COMPART_WORN_LIMIT_CAT cat)
{
cat.adjust_base = item.Adjust_base == null ? 0 : item.Adjust_base;
cat.hi_inflectionPoint = item.Hi_InflectionPoint == null ? 0 : item.Hi_InflectionPoint;
cat.hi_intercept1 = item.Hi_Intercept1 == null ? 0 : item.Hi_Intercept1;
cat.hi_intercept2 = item.Hi_Intercept2 == null ? 0 : item.Hi_Intercept2;
cat.hi_slope1 = item.Hi_Slope1 == null ? 0 : item.Hi_Slope1;
cat.hi_slope2 = item.Hi_Slope2 == null ? 0 : item.Hi_Slope2;
cat.mi_inflectionPoint = item.Mi_InflectionPoint == null ? 0 : item.Mi_InflectionPoint;
cat.mi_intercept1 = item.Mi_Intercept1 == null ? 0 : item.Mi_Intercept1;
cat.mi_intercept2 = item.Mi_Intercept2 == null ? 0 : item.Mi_Intercept2;
cat.mi_slope1 = item.Mi_Slope1 == null ? 0 : item.Mi_Slope1;
cat.mi_slope2 = item.Mi_Slope2 == null ? 0 : item.Mi_Slope2;
_context.Entry(cat).State = EntityState.Modified;
}
private void UpdateCalculationInflectionMethod(InflectionCalMethodViewModel item)
{
var checker = CheckEXTRecordExsistence(item.CompartId, item.ToolId, item.MeasurementPointId.Value);
if (checker != null)
{
checker.track_compart_worn_calc_method_auto = item.WornCalculationMethodTypeId;
_context.Entry(checker).State = EntityState.Modified;
var stepped = _context.TRACK_COMPART_WORN_LIMIT_CAT.FirstOrDefault(t => t.track_compart_worn_limit_cat_auto == item.WornCalculationMethodTableAutoId);
if (stepped == null)
{
InsertNewInflectionCalMethod(item);
}
else
{
UpdateExsistingInflectionCalculationMethod(item, stepped);
}
}
else
{
InsertNewTRACKCOMPARTExtRecord(item);
InsertNewInflectionCalMethod(item);
}
}
