/// <summary>
/// Constructs controller with database context.
/// </summary>
/// <param name="context">The database context</param>
public ChartDAC(AnthroCloudContext context)
{
_context = context;
_context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
_context.ChangeTracker.AutoDetectChangesEnabled = false;
_context.ChangeTracker.LazyLoadingEnabled = false;
}
/// <summary>
/// Gets a strongly typed typed list of WFH objects.
/// </summary>
/// <param name="sex">Filters by ISO/IEC 5218 standard (1 = male, 2 = female)</param>
/// <returns>Returns a strongly typed list of WFH objects.</returns>
public List <WeightForHeight> ListWeightForHeight(Sexes sex)
{
using var db = new AnthroCloudContext();
IQueryable <WeightForHeight> query = db.Set <WeightForHeight>();
query = query.Where(c => c.Sex == (byte)sex);
return(query.ToList());
}
/// <summary>
/// Gets a strongly typed typed list of LHFA objects.
/// </summary>
/// <param name="sex">Filters by ISO/IEC 5218 standard (1 = male, 2 = female)</param>
/// <returns>Returns a strongly typed list of LHFA objects.</returns>
public List <LengthHeightForAge> ListLengthHeightForAge(Sexes sex)
{
using var db = new AnthroCloudContext();
IQueryable <LengthHeightForAge> query = db.Set <LengthHeightForAge>();
query = query.Where(c => c.Sex == (byte)sex);
return(query.ToList());
}
public TestAnthroCloudContext()
{
if (VALUE.ToString() == "AnthroCloudDatabaseMsSql")
{
Context = ConfigureMsSql();
}
else if (VALUE.ToString() == "AnthroCloudDatabaseMySql")
{
Context = ConfigureMySql();
}
}
/// <summary>
/// Solely constructs controller with database context.
/// </summary>
/// <param name="ctx">The database context</param>
public ChartController(AnthroCloudContext context)
{
_context = context;
}
