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