private CachedDataTable executeQuery(string query, CachedDataTable cdt)
{
//DataTable dt = new DataTable();
if (cdt.NeedsUpdate)
{
cdt.Table.Clear();
MySqlConnection conn = connectdb();
try
{
MySqlCommand cmd = new MySqlCommand(query, conn);
conn.Open();
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
cdt.Table.Load(rdr);
}
cdt.LastUpdated = DateTime.Now;
conn.Close();
return(cdt);
}
catch (Exception)
{
throw new Exception();
}
}
else
{
return(cdt);
}
}
public int getAvreageAge()
{
int currentYear = DateTime.Now.Year;
//DataTable dt;
string query = "select foedselsaar from medlemmer";
int ageSum = 0;
int avgAge;
try
{
birtYearsCdt = executeQuery(query, birtYearsCdt);
DataRowCollection birthYears = birtYearsCdt.Table.Rows;
foreach (DataRow item in birthYears)
{
int age = currentYear - Convert.ToInt32(item.ItemArray[0]);
ageSum += age;
}
avgAge = ageSum / birthYears.Count;
return(avgAge);
}
catch (Exception)
{
throw;
}
}
public int getNumberOfMajorStudents(Controllers.majors major)
{
string query = $"select count(*) from medlemmer where studie='{major.ToString()}'";
try
{
majorsCdt = executeQuery(query, majorsCdt);
DataRow row = majorsCdt.Table.Rows[0];
int numberOfMajorStudents = Convert.ToInt32(row.ItemArray[0]);
return(numberOfMajorStudents);
}
catch (Exception)
{
throw new Exception();
}
}
public int getNumberOfMembers()
{
//DataTable dt;
string query = "select count(*) from medlemmer";
try
{
membersCdt = executeQuery(query, membersCdt);
DataRow row = membersCdt.Table.Rows[0];
int numberOfMembers = Convert.ToInt32(row.ItemArray[0]);
return(numberOfMembers);
}
catch (Exception)
{
throw new Exception();
}
}
