public List <Individual> Read_Generation_Record(int Generation_Number, int World_Number, int Session_Number) { //Copy method inputs to local variables int _Generation_Number = Generation_Number; int _World_Number = World_Number; int _Session_Number = Session_Number; List <Individual> _Generation_Read_Individuals = new List <Individual>(); Individual _temp = new Individual(); List <Evolution_History> _Generation_Read_List = new List <Evolution_History>(); //Create a list of the retrieved records from the database using (var context = new Machine_Learning_Entities()) { //First fetch a copy of the database _Generation_Read_List = context.Evolution_History.ToList(); //Apply filters to get desired records _Generation_Read_List = _Generation_Read_List.Where(b => b.Generation_Number == _Generation_Number && b.World_Number == _World_Number && b.Session_Number == _Session_Number) .OrderByDescending(x => x.Fitness).ThenByDescending(y => y.Elapsed_Time).ToList(); } //Parse that to the list of individuals foreach (var item in _Generation_Read_List) { _temp.DNA_Code = item.DNA; _temp.DNA = _temp.Write_DNA_String_To_DNA_Array(_temp.DNA_Code); _temp = _temp.WriteDNA_ToParameters(_temp.DNA); _temp.dTime = (decimal)item.Elapsed_Time; _temp.dFitnessScore = (decimal)item.Fitness; _temp.dWeightedFitnessValue = (decimal)item.Weighted_Fitness; _Generation_Read_Individuals.Add(_temp); } return(_Generation_Read_Individuals); }
public int Add_Individual_Record(Individual Individual_Recorded, int Generation_Number, int World_Number, int Session_Number) { //Copy method inputs to local variables int _Generation_Number = Generation_Number; int _World_Number = World_Number; int _Session_Number = Session_Number; Individual _Individual_Recorded = Individual_Recorded; //Create an instance of the entity model using (var context = new Machine_Learning_Entities()) { History_List.DNA = _Individual_Recorded.DNA_Code; History_List.Generation_Number = _Generation_Number; History_List.World_Number = _World_Number; History_List.Elapsed_Time = _Individual_Recorded.dTime; History_List.Fitness = _Individual_Recorded.dFitnessScore; History_List.Weighted_Fitness = _Individual_Recorded.dWeightedFitnessValue; History_List.Session_Number = _Session_Number; context.Evolution_History.Add(_History_List); context.SaveChanges(); } return(0); }
public List <int> Retrieve_Available_Sessions() { List <int> Session_Numbers = new List <int>(); List <Evolution_History> _Session_Read_List = new List <Evolution_History>(); //Create a list of the retrieved records from the database using (var context = new Machine_Learning_Entities()) { //First fetch a copy of the database _Session_Read_List = context.Evolution_History.ToList(); //Apply filters to get desired records var Session_Numbers_Linq = _Session_Read_List.OrderBy(x => x.Session_Number).Where(b => b.Session_Number >= 1).Select(u => u.Session_Number).Distinct().ToList(); foreach (var item in Session_Numbers_Linq) { Session_Numbers.Add((int)item); } } return(Session_Numbers); }