private void UpdatepolyCalculationMethod(PolynomialCalMethodViewModel 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 poly = _context.TRACK_COMPART_WORN_LIMIT_KOMATSU.FirstOrDefault(t => t.track_compart_worn_limit_komatsu_auto == item.WornCalculationMethodTableAutoId);
if (poly == null)
{
InsertNewPolynomialCalMethod(item);
}
else
{
UpdateExsistingPolynomialCalculationMethod(item, poly);
}
}
else
{
InsertNewTRACKCOMPARTExtRecord(item);
InsertNewPolynomialCalMethod(item);
}
}
private void UpdateExsistingPolynomialCalculationMethod(PolynomialCalMethodViewModel item, TRACK_COMPART_WORN_LIMIT_KOMATSU poly)
{
poly.compartid_auto = item.CompartId;
poly.MeasurePointId = item.MeasurementPointId;
poly.track_tools_auto = item.ToolId;
//poly.track_compart_worn_limit_komatsu_auto = item.WornCalculationMethodTypeId;
poly.impact_intercept = item.Impact_Intercept == null ? 0 : item.Impact_Intercept;
poly.impact_secondorder = item.Impact_Secondorder == null ? 0 : item.Impact_Secondorder;
poly.impact_slope = item.Impact_Slope == null ? 0 : item.Impact_Slope;
poly.normal_intercept = item.Normal_Intercept == null ? 0 : item.Normal_Intercept;
poly.normal_secondorder = item.Normal_Secondorder == null ? 0 : item.Normal_Secondorder;
poly.normal_slope = item.Normal_Slope == null ? 0 : item.Normal_Slope;
poly.slope_impact = item.Slope_Impact == null ? 0 : item.Slope_Impact;
poly.slope_normal = item.Slope_Normal == null ? 0 : item.Slope_Normal;
_context.Entry(poly).State = EntityState.Modified;
}
private void InsertNewPolynomialCalMethod(PolynomialCalMethodViewModel item)
{
var newPoly = new TRACK_COMPART_WORN_LIMIT_KOMATSU
{
compartid_auto = item.CompartId,
MeasurePointId = item.MeasurementPointId,
track_tools_auto = item.ToolId,
track_compart_worn_limit_komatsu_auto = item.WornCalculationMethodTypeId,
impact_intercept = item.Impact_Intercept == null ? 0 : item.Impact_Intercept,
impact_secondorder = item.Impact_Secondorder == null ? 0 : item.Impact_Secondorder,
impact_slope = item.Impact_Slope == null ? 0 : item.Impact_Slope,
normal_intercept = item.Normal_Intercept == null ? 0 : item.Normal_Intercept,
normal_secondorder = item.Normal_Secondorder == null ? 0 : item.Normal_Secondorder,
normal_slope = item.Normal_Slope == null ? 0 : item.Normal_Slope,
slope_impact = item.Slope_Impact == null ? 0 : item.Slope_Impact,
slope_normal = item.Slope_Normal == null ? 0 : item.Slope_Normal,
};
_context.TRACK_COMPART_WORN_LIMIT_KOMATSU.Add(newPoly);
}
