public async Task DeleteMonitoringPostMeasuredParameter(
MonitoringPostMeasuredParameters monitoringPostMeasuredParameters)
{
try
{
_context.MonitoringPostMeasuredParameters.Remove(monitoringPostMeasuredParameters);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
}
}
public async Task MonitoringPostMeasuredParameter(int MonitoringPostId,
int MeasuredParameterId,
decimal?Min,
decimal?Max,
decimal?MinMeasuredValue,
decimal?MaxMeasuredValue,
decimal?Coefficient)
{
MonitoringPostMeasuredParameters monitoringPostMeasuredParameters = new MonitoringPostMeasuredParameters
{
MonitoringPostId = MonitoringPostId,
MeasuredParameterId = MeasuredParameterId,
Min = Min,
Max = Max,
MinMeasuredValue = MinMeasuredValue,
MaxMeasuredValue = MaxMeasuredValue,
Coefficient = Coefficient
};
_context.MonitoringPostMeasuredParameters.Add(monitoringPostMeasuredParameters);
await _context.SaveChangesAsync();
}
public List <MonitoringPostMeasuredParameters> GetMonitoringPostMeasuredParameters(
int MonitoringPostId,
int DataProviderId,
int PollutionEnvironmentId)
{
List <MonitoringPostMeasuredParameters> monitoringPostMeasuredParameter = _context.MonitoringPostMeasuredParameters
.Where(m => m.MonitoringPostId == MonitoringPostId)
.Include(m => m.MeasuredParameter)
.Include(m => m.MonitoringPost)
.OrderBy(m => m.MonitoringPostId)
.ToList();
List <MeasuredParameter> measuredParameters = new List <MeasuredParameter>();
//Water
if (PollutionEnvironmentId == 3)
{
measuredParameters = _context.MeasuredParameter.Where(m => m.PollutionEnvironmentId == 3).ToList();
}
else
{
//Kazhydromet
if (DataProviderId == 1)
{
measuredParameters = _context.MeasuredParameter.Where(m => m.KazhydrometCode != null).ToList();
}
//Ecoservice, Urus
else if (DataProviderId == 3 || DataProviderId == 2)
{
measuredParameters = _context.MeasuredParameter.Where(m => m.OceanusCode != null).ToList();
}
else
{
measuredParameters = _context.MeasuredParameter.ToList();
}
}
measuredParameters = measuredParameters.OrderBy(m => m.Id).ToList();
List <MonitoringPostMeasuredParameters> monitoringPostMeasuredParameterWithNull = new List <MonitoringPostMeasuredParameters>();
bool check = false;
for (int i = 0; i < measuredParameters.Count; i++)
{
foreach (var id in monitoringPostMeasuredParameter)
{
if (measuredParameters[i].Id == id.MeasuredParameterId)
{
var item = new MonitoringPostMeasuredParameters
{
Id = measuredParameters[i].Id,
MonitoringPostId = id.MonitoringPostId,
MeasuredParameterId = id.MeasuredParameterId,
MeasuredParameter = measuredParameters[i],
Min = id.Min,
Max = id.Max,
MinMeasuredValue = id.MinMeasuredValue,
MaxMeasuredValue = id.MaxMeasuredValue,
Coefficient = id.Coefficient,
Sensor = true
};
monitoringPostMeasuredParameterWithNull.Add(item);
check = true;
}
}
if (!check)
{
var item = new MonitoringPostMeasuredParameters
{
Id = measuredParameters[i].Id,
MonitoringPostId = -1,
MeasuredParameterId = measuredParameters[i].Id,
MeasuredParameter = measuredParameters[i],
Min = null,
Max = null,
MinMeasuredValue = null,
MaxMeasuredValue = null,
Coefficient = null,
Sensor = false
};
monitoringPostMeasuredParameterWithNull.Add(item);
}
check = false;
}
return(monitoringPostMeasuredParameterWithNull);
}
