private SteppedCalMethodViewModel ConvertITMEntityToViewModel(TRACK_COMPART_WORN_LIMIT_ITM itm, int WornCalculationMethodTypeId, int extId)
{
return(new SteppedCalMethodViewModel
{
WornCalculationMethodTypeId = WornCalculationMethodTypeId,
WornCalculationMethodTableAutoId = itm.track_compart_worn_limit_itm_auto,
CompartId = itm.compartid_auto,
MeasurementPointId = itm.MeasurePointId,
ToolId = itm.track_tools_auto,
CompartEXTId = extId,
StartDepthNew = itm.start_depth_new == null ? 0 : itm.start_depth_new,
StartDepth_10 = itm.wear_depth_10_percent == null ? 0 : itm.wear_depth_10_percent,
StartDepth_20 = itm.wear_depth_20_percent == null ? 0 : itm.wear_depth_20_percent,
StartDepth_30 = itm.wear_depth_30_percent == null ? 0 : itm.wear_depth_30_percent,
StartDepth_40 = itm.wear_depth_40_percent == null ? 0 : itm.wear_depth_40_percent,
StartDepth_50 = itm.wear_depth_50_percent == null ? 0 : itm.wear_depth_50_percent,
StartDepth_60 = itm.wear_depth_60_percent == null ? 0 : itm.wear_depth_60_percent,
StartDepth_70 = itm.wear_depth_70_percent == null ? 0 : itm.wear_depth_70_percent,
StartDepth_80 = itm.wear_depth_80_percent == null ? 0 : itm.wear_depth_80_percent,
StartDepth_90 = itm.wear_depth_90_percent == null ? 0 : itm.wear_depth_90_percent,
StartDepth_100 = itm.wear_depth_100_percent == null ? 0 : itm.wear_depth_100_percent,
StartDepth_110 = itm.wear_depth_110_percent == null ? 0 : itm.wear_depth_110_percent,
StartDepth_120 = itm.wear_depth_120_percent == null ? 0 : itm.wear_depth_120_percent,
});
}
private void InsertNewITM(SteppedCalMethodViewModel item)
{
var stepped = new TRACK_COMPART_WORN_LIMIT_ITM
{
compartid_auto = item.CompartId,
MeasurePointId = item.MeasurementPointId,
track_tools_auto = item.ToolId,
track_compart_worn_limit_itm_auto = item.WornCalculationMethodTypeId,
start_depth_new = item.StartDepthNew == null ? 0 : item.StartDepthNew,
wear_depth_10_percent = item.StartDepth_10 == null ? 0 : item.StartDepth_10,
wear_depth_20_percent = item.StartDepth_20 == null ? 0 : item.StartDepth_20,
wear_depth_30_percent = item.StartDepth_30 == null ? 0 : item.StartDepth_30,
wear_depth_40_percent = item.StartDepth_40 == null ? 0 : item.StartDepth_40,
wear_depth_50_percent = item.StartDepth_50 == null ? 0 : item.StartDepth_50,
wear_depth_60_percent = item.StartDepth_60 == null ? 0 : item.StartDepth_60,
wear_depth_70_percent = item.StartDepth_70 == null ? 0 : item.StartDepth_70,
wear_depth_80_percent = item.StartDepth_80 == null ? 0 : item.StartDepth_80,
wear_depth_90_percent = item.StartDepth_90 == null ? 0 : item.StartDepth_90,
wear_depth_100_percent = item.StartDepth_100 == null ? 0 : item.StartDepth_100,
wear_depth_110_percent = item.StartDepth_110 == null ? 0 : item.StartDepth_110,
wear_depth_120_percent = item.StartDepth_120 == null ? 0 : item.StartDepth_120,
};
_context.TRACK_COMPART_WORN_LIMIT_ITM.Add(stepped);
}
private void UpdateITM(SteppedCalMethodViewModel item, TRACK_COMPART_WORN_LIMIT_ITM stepped)
{
stepped.start_depth_new = item.StartDepthNew == null ? 0 : item.StartDepthNew;
stepped.wear_depth_10_percent = item.StartDepth_10 == null ? 0 : item.StartDepth_10;
stepped.wear_depth_20_percent = item.StartDepth_20 == null ? 0 : item.StartDepth_20;
stepped.wear_depth_30_percent = item.StartDepth_30 == null ? 0 : item.StartDepth_30;
stepped.wear_depth_40_percent = item.StartDepth_40 == null ? 0 : item.StartDepth_40;
stepped.wear_depth_50_percent = item.StartDepth_50 == null ? 0 : item.StartDepth_50;
stepped.wear_depth_60_percent = item.StartDepth_60 == null ? 0 : item.StartDepth_60;
stepped.wear_depth_70_percent = item.StartDepth_70 == null ? 0 : item.StartDepth_70;
stepped.wear_depth_80_percent = item.StartDepth_80 == null ? 0 : item.StartDepth_80;
stepped.wear_depth_90_percent = item.StartDepth_90 == null ? 0 : item.StartDepth_90;
stepped.wear_depth_100_percent = item.StartDepth_100 == null ? 0 : item.StartDepth_100;
stepped.wear_depth_110_percent = item.StartDepth_110 == null ? 0 : item.StartDepth_110;
stepped.wear_depth_120_percent = item.StartDepth_120 == null ? 0 : item.StartDepth_120;
stepped.track_tools_auto = item.ToolId;
stepped.MeasurePointId = item.MeasurementPointId;
_context.Entry(stepped).State = EntityState.Modified;
}
public static decimal ITMReadingMapper(TRACK_COMPART_WORN_LIMIT_ITM r, decimal reading)
{
if (r.start_depth_new > r.wear_depth_10_percent)
{
if (reading > r.start_depth_new)//todo test
{
return(linearFormula(r.start_depth_new * 2 - r.wear_depth_10_percent, -10, r.start_depth_new, 0, reading));
}
if (reading <= r.start_depth_new && reading > r.wear_depth_10_percent)
{
return(linearFormula(r.start_depth_new, 0, r.wear_depth_10_percent, 10, reading));
}
if (reading <= r.wear_depth_10_percent && reading > r.wear_depth_20_percent)
{
return(linearFormula(r.wear_depth_10_percent, 10, r.wear_depth_20_percent, 20, reading));
}
if (reading <= r.wear_depth_20_percent && reading > r.wear_depth_30_percent)
{
return(linearFormula(r.wear_depth_20_percent, 20, r.wear_depth_30_percent, 30, reading));
}
if (reading <= r.wear_depth_30_percent && reading > r.wear_depth_40_percent)
{
return(linearFormula(r.wear_depth_30_percent, 30, r.wear_depth_40_percent, 40, reading));
}
if (reading <= r.wear_depth_40_percent && reading > r.wear_depth_50_percent)
{
return(linearFormula(r.wear_depth_40_percent, 40, r.wear_depth_50_percent, 50, reading));
}
if (reading <= r.wear_depth_50_percent && reading > r.wear_depth_60_percent)
{
return(linearFormula(r.wear_depth_50_percent, 50, r.wear_depth_60_percent, 60, reading));
}
if (reading <= r.wear_depth_60_percent && reading > r.wear_depth_70_percent)
{
return(linearFormula(r.wear_depth_60_percent, 60, r.wear_depth_70_percent, 70, reading));
}
if (reading <= r.wear_depth_70_percent && reading > r.wear_depth_80_percent)
{
return(linearFormula(r.wear_depth_70_percent, 70, r.wear_depth_80_percent, 80, reading));
}
if (reading <= r.wear_depth_80_percent && reading > r.wear_depth_90_percent)
{
return(linearFormula(r.wear_depth_80_percent, 80, r.wear_depth_90_percent, 90, reading));
}
if (reading <= r.wear_depth_90_percent && reading > r.wear_depth_100_percent)
{
return(linearFormula(r.wear_depth_90_percent, 90, r.wear_depth_100_percent, 100, reading));
}
if (reading <= r.wear_depth_100_percent && reading > r.wear_depth_110_percent)
{
return(linearFormula(r.wear_depth_100_percent, 100, r.wear_depth_110_percent, 110, reading));
}
if (reading <= r.wear_depth_110_percent && reading > r.wear_depth_120_percent)
{
return(linearFormula(r.wear_depth_110_percent, 110, r.wear_depth_120_percent, 120, reading));
}
if (reading < r.wear_depth_120_percent)
{
return(linearFormula(r.wear_depth_120_percent, 120, r.wear_depth_120_percent * 2 - r.wear_depth_110_percent, 130, reading));
}
}
else
{
if (reading < r.start_depth_new)
{
return(linearFormula(r.start_depth_new - r.wear_depth_10_percent, -10, r.wear_depth_10_percent, 0, reading));
}
if (reading >= r.start_depth_new && reading < r.wear_depth_10_percent)
{
return(linearFormula(r.start_depth_new, 0, r.wear_depth_10_percent, 10, reading));
}
if (reading >= r.wear_depth_10_percent && reading < r.wear_depth_20_percent)
{
return(linearFormula(r.wear_depth_10_percent, 10, r.wear_depth_20_percent, 20, reading));
}
if (reading >= r.wear_depth_20_percent && reading < r.wear_depth_30_percent)
{
return(linearFormula(r.wear_depth_20_percent, 20, r.wear_depth_30_percent, 30, reading));
}
if (reading >= r.wear_depth_30_percent && reading < r.wear_depth_40_percent)
{
return(linearFormula(r.wear_depth_30_percent, 30, r.wear_depth_40_percent, 40, reading));
}
if (reading >= r.wear_depth_40_percent && reading < r.wear_depth_50_percent)
{
return(linearFormula(r.wear_depth_40_percent, 40, r.wear_depth_50_percent, 50, reading));
}
if (reading >= r.wear_depth_50_percent && reading < r.wear_depth_60_percent)
{
return(linearFormula(r.wear_depth_50_percent, 50, r.wear_depth_60_percent, 60, reading));
}
if (reading >= r.wear_depth_60_percent && reading < r.wear_depth_70_percent)
{
return(linearFormula(r.wear_depth_60_percent, 60, r.wear_depth_70_percent, 70, reading));
}
if (reading >= r.wear_depth_70_percent && reading < r.wear_depth_80_percent)
{
return(linearFormula(r.wear_depth_70_percent, 70, r.wear_depth_80_percent, 80, reading));
}
if (reading >= r.wear_depth_80_percent && reading < r.wear_depth_90_percent)
{
return(linearFormula(r.wear_depth_80_percent, 80, r.wear_depth_90_percent, 90, reading));
}
if (reading >= r.wear_depth_90_percent && reading < r.wear_depth_100_percent)
{
return(linearFormula(r.wear_depth_90_percent, 90, r.wear_depth_100_percent, 100, reading));
}
if (reading >= r.wear_depth_100_percent && reading < r.wear_depth_110_percent)
{
return(linearFormula(r.wear_depth_100_percent, 100, r.wear_depth_110_percent, 110, reading));
}
if (reading >= r.wear_depth_110_percent && reading < r.wear_depth_120_percent)
{
return(linearFormula(r.wear_depth_110_percent, 110, r.wear_depth_120_percent, 120, reading));
}
if (reading > r.wear_depth_120_percent)
{
return(linearFormula(r.wear_depth_120_percent, 120, r.wear_depth_120_percent * 2 - r.wear_depth_110_percent, 130, reading));
}
}
return((decimal) - 0.0005);
}
