/// <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; }