static void OldMain(string[] args)
{
Console.WriteLine("Calculating Stats...");
using (var context = new PValueDbContext())
{
var serviceProvider = new ServiceCollection()
.AddSingleton <IPValueService, PValueService>()
.BuildServiceProvider();
//----//
var pService = serviceProvider.GetService <IPValueService>();
var indList = pService.GetIndicatorList(context);
foreach (var item in indList)
{
//----//
var phys = context.Indicator_12
.Where(p => p.PayrollID == item.ID);
if (phys.Count() >= 5)
{
var stats = pService.CalculateStats(context, item);
#region Insert Stats
var statsTable = new StatsTable()
{
PayrollID = stats.PayrollID,
OppeCycleID = item.OppeCycleID,
OppeIndicatorID = item.OppeIndicatorID,
OppePhysicianSubGroupID = item.SubGroupID,
Count = stats.Count,
// NumeratorSum = stats.NumeratorSum,
// DenominatorSum = stats.DenominatorSum,
Mean = stats.Mean,
StandardDeviation = stats.StandardDeviation,
PeerCount = stats.PeerCount,
// PeerNumeratorSum = stats.PeerNumeratorSum,
// PeerDenominatorSum = stats.PeerDenominatorSum,
PeerMean = stats.PeerMean,
PeerStandardDeviation = stats.PeerStandardDeviation,
LevenesTest = stats.LevenesTest,
PValue_EqualVariances = stats.PValue_EqualVariances,
PValue_UnequalVariances = stats.PValue_UnequalVariances,
PValue = stats.PValue
};
context.StatsTable.Add(statsTable);
context.SaveChanges();
#endregion
}
// Console.WriteLine($"{stats.PayrollID} - Physician - {stats.Count} - {stats.Mean} - {stats.StandardDeviation} - {stats.LevenesTest} - {stats.PValue_EqualVariances}");
// Console.WriteLine($" - Peers - {stats.PeerCount} - {stats.PeerMean} - {stats.PeerStandardDeviation} - - {stats.PValue_UnequalVariances} ---> {stats.PValue}");
}
Console.WriteLine("Done!");
Console.WriteLine("Press Enter Key...");
Console.Read();
}
}
public bool AddOrUpdateStatsTable(Statistics stats, Physician phys)
{
var statsQ = _context.StatsTable
.Where(s => (s.PayrollID == stats.PayrollID) &&
(s.OppeCycleID == phys.OppeCycleID) &&
(s.OppeIndicatorID == phys.OppeIndicatorID) &&
(s.OppePhysicianSubGroupID == phys.SubGroupID));
var exists = statsQ.Count() > 0;
if (exists)
{
var statsDB = statsQ.SingleOrDefault();
statsDB.Count = stats.DenominatorSum;
statsDB.PayrollID = stats.PayrollID;
statsDB.Alpha = 0.05;
statsDB.Mean = stats.Mean;
statsDB.StandardDeviation = stats.StandardDeviation;
statsDB.PeerCount = stats.PeerDenominatorSum;
statsDB.Sum = stats.NumeratorSum;
statsDB.PeerSum = stats.PeerNumeratorSum;
statsDB.PeerMean = stats.PeerMean;
statsDB.PeerStandardDeviation = stats.PeerStandardDeviation;
statsDB.LevenesTest = stats.LevenesTest;
statsDB.PValue_EqualVariances = stats.PValue_EqualVariances;
statsDB.PValue_UnequalVariances = stats.PValue_UnequalVariances;
statsDB.PValue = stats.PValue;
statsDB.OppeCycleID = phys.OppeCycleID;
statsDB.OppeIndicatorID = phys.OppeIndicatorID;
statsDB.OppePhysicianSubGroupID = phys.SubGroupID;
_context.StatsTable.Update(statsDB);
}
else
{
var statsTable = new StatsTable
{
Count = stats.DenominatorSum,
PayrollID = stats.PayrollID,
Alpha = 0.05,
Mean = stats.Mean,
StandardDeviation = stats.StandardDeviation,
PeerCount = stats.PeerDenominatorSum,
Sum = stats.NumeratorSum,
PeerSum = stats.PeerNumeratorSum,
PeerMean = stats.PeerMean,
PeerStandardDeviation = stats.PeerStandardDeviation,
LevenesTest = stats.LevenesTest,
PValue_EqualVariances = stats.PValue_EqualVariances,
PValue_UnequalVariances = stats.PValue_UnequalVariances,
PValue = stats.PValue,
OppeCycleID = phys.OppeCycleID,
OppeIndicatorID = phys.OppeIndicatorID,
OppePhysicianSubGroupID = phys.SubGroupID
};
_context.StatsTable.Add(statsTable);
}
_context.SaveChanges();
return(exists);
}
