// get total riders
public Sum_Avg totalRiders(int stationID)
{
int pas = 0;
int days = 0;
// query for the number of riders
var query = from riders in m_CTA.Riderships
where riders.StationID == stationID
select riders;
// got total riders
foreach (var row in query)
{
pas = pas + row.DailyTotal;
}
// query for total days
var query2 = from riders in m_CTA.Riderships
where riders.StationID == stationID
group riders by riders.TheDate into grp
select new { key = grp.Key, count = grp.Count() };
// got total days
foreach (var row in query2)
{
days = days + row.count;
}
double average = pas / days;
Sum_Avg myResult = new Sum_Avg(pas, average);
return(myResult);
}
// get total riders
public Sum_Avg totalRiders(int stationID)
{
int pas = 0;
int days = 0;
// query for the number of riders
var query = from riders in m_CTA.Riderships
where riders.StationID == stationID
select riders;
// got total riders
foreach (var row in query)
{
pas = pas + row.DailyTotal;
}
// query for total days
var query2 = from riders in m_CTA.Riderships
where riders.StationID == stationID
group riders by riders.TheDate into grp
select new { key = grp.Key, count = grp.Count() };
// got total days
foreach (var row in query2)
{
days = days + row.count;
}
double average = pas / days;
Sum_Avg myResult = new Sum_Avg(pas,average);
return myResult;
}