Notes

public static string? CreateBaselineFromValues(int idImpianto, DateTime data, string utente, List<DataPoint> newBaseline)
{
try
{
using var context = new ModelContext(UvamDBInterface.DbContextOptions);
var existingBaseline = context.Baselines
.Where(eb => eb.IdImpianto == idImpianto && eb.Data == data)
.ToList();
var existingUser = GetOperationUVAMDBInterface.GetUserByName(context, utente);
if (existingUser == null)
{
return "Errore: Utente non trovato.";
}

java
Copy code
var checkUser = context.UtenteImpiantos
.Where(ui => ui.IdUtente == existingUser.Id && ui.IdImpianto == idImpianto)
.ToList();
if (checkUser.Count <= 0)
{
return "Errore: L'Utente non ha i permessi per accedere all'Impianto.";
}

if (existingBaseline.Count > 0)
{
// update existing baseline
existingBaseline[0].Data = data;
existingBaseline[0].IdUtente = existingUser.Id;
existingBaseline[0].IdProfilo = null;

var baselineValorisToRemove = context.BaselineValoris.Where(bv => bv.IdBaseline == existingBaseline[0].Id).ToList();
foreach (var valore in baselineValorisToRemove)
{
context.BaselineValoris.Remove(valore);
}
context.SaveChanges();

int minute = 0;
decimal lastValue = 0;
foreach (var baselineValue in newBaseline)
{
int minuteDiff = baselineValue.m - minute;
for (int i = 0; i < minuteDiff; i += 15)
{
var baselineValues = new BaselineValori
{
IdBaseline = existingBaseline[0].Id,
Minuto = (byte)minute,
Valore = lastValue
};
context.BaselineValoris.Add(baselineValues);
minute += 15;
}
lastValue = baselineValue.v!;
}

for (int i = minute; i <= 1490; i += 15)
{
var baselineValues = new BaselineValori
{
IdBaseline = existingBaseline[0].Id,
Minuto = (byte)i,
Valore = lastValue
};
context.BaselineValoris.Add(baselineValues);
}
context.SaveChanges();
return existingBaseline[0].Id.ToString();
}
else
{
// create new baseline
var baseline = new Baseline
{
IdImpianto = idImpianto,
Data = data,
DataInserimento = data,
IdUtente = existingUser.Id
};
context.Baselines.Add(baseline);
context.SaveChanges();

csharp
Copy code
// loop through the new baseline values
int minute = 0;
decimal previousValue = 0;
foreach (var baselineValue in newBaseline)
{
int currentMinute = baselineValue.m;

// fill the missing minutes with the previous value
while (minute < currentMinute)
{
var baselineValues = new BaselineValori
{
IdBaseline = baseline.Id,
Minuto = (byte)minute,
Valore = previousValue
};
context.BaselineValoris.Add(baselineValues);
minute += 15;
}

// add the current value
var currentValore = (decimal)baselineValue.v!;
var currentBaselineValues = new BaselineValori
{
IdBaseline = baseline.Id,
Minuto = (byte)currentMinute,
Valore = currentValore
};
context.BaselineValoris.Add(currentBaselineValues);
minute += 15;
previousValue = currentValore;
}

// fill the remaining minutes with the last value
while (minute <= 1490)
{
var baselineValues = new BaselineValori
{
IdBaseline = baseline.Id,
Minuto = (byte)minute,
Valore = previousValue
};
context.BaselineValoris.Add(baselineValues);
minute += 15;
}

context.SaveChanges();
return baseline.Id.ToString();
}