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