/// /// <summary> /// Returns overall stats about crimes in Chicago. /// </summary> /// <returns>CrimeStats object</returns> /// public CrimeStats GetOverallCrimeStats() { CrimeStats cs; int minYear = (int)dataTier.ExecuteScalarQuery("SELECT MIN(Year) from Crimes;"); int maxYear = (int)dataTier.ExecuteScalarQuery("SELECT MAX(Year) from Crimes;"); int num = (int)dataTier.ExecuteScalarQuery("SELECT Count(*) from Crimes;"); cs = new CrimeStats(num, minYear, maxYear); return(cs); }
/// /// <summary> /// Returns overall stats about crimes in Chicago. /// </summary> /// <returns>CrimeStats object</returns> /// public CrimeStats GetOverallCrimeStats() { CrimeStats cs; Business bus = new Business("C:\\Users\\Jacky\\Downloads\\CrimeDB.mdf"); string sql = @" Select Min(Year) As MinYear, Max(Year) As MaxYear, Count(*) As Total From Crimes; "; DataSet result = dataTier.ExecuteNonScalarQuery(sql); DataRow row = result.Tables["TABLE"].Rows[0]; int minYear = System.Convert.ToInt32(row["MinYear"]); int maxYear = System.Convert.ToInt32(row["MaxYear"]); long total = System.Convert.ToInt64(row["Total"]); // // TODO! // cs = new CrimeStats(total, minYear, maxYear); return(cs); }