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(); } }