public List <TypeTwo_ArticleTwo> TypeTwo_ArticleTwo()
{
var result = new List <TypeTwo_ArticleTwo>();
var response = (from taxi in FirebaseOperationDal.GetAll()
group taxi by taxi.tpep_pickup_datetime.Date
into g
select new
{
PUDatetime = g.Key,
total_amount_average = g.Sum(p => p.total_amount) / g.Select(p => p.passenger_count).Count()
}
).OrderBy(p => p.total_amount_average).ToList();
var response2 = response.Take(2).OrderBy(p => p.PUDatetime).ToList();
var response3 = (from a in response
where a.PUDatetime.Date >= response2[0].PUDatetime.Date &&
a.PUDatetime.Date <= response2[1].PUDatetime.Date
select new
{
a.PUDatetime, a.total_amount_average
}).ToList();
response3.ForEach(p =>
{
result.Add(new TypeTwo_ArticleTwo
{
PUDatetime = p.PUDatetime,
total_amount_average = p.total_amount_average
});
});
return(result);
}
public List <TypeTwo_ArticleThree> TypeTwo_ArticleThree(TypeTwo_ArticleThree_Input input)
{
var result = new List <TypeTwo_ArticleThree>();
var response = (from taxi in FirebaseOperationDal.GetAll()
where taxi.tpep_pickup_datetime.Date >= input.FirstDate.Date &&
taxi.tpep_pickup_datetime.Date <= input.SecondDate.Date
select new
{
PUDatetime = taxi.tpep_pickup_datetime,
DODatetime = taxi.tpep_dropoff_datetime,
taxi.trip_distance
}).OrderBy(p => p.trip_distance).Take(5).ToList();
response.ForEach(p =>
{
result.Add(new TypeTwo_ArticleThree
{
PUDatetime = p.PUDatetime,
DODatetime = p.DODatetime,
trip_distance = p.trip_distance
});
});
return(result);
}
public List <TypeThree_ArticleTwo> TypeThree_ArticleTwo(TypeThree_ArticleTwo_Input input)
{
var result = new List <TypeThree_ArticleTwo>();
var response = (from taxi in FirebaseOperationDal.GetAll()
where taxi.tpep_pickup_datetime.Date == input.FirstDate.Date &&
taxi.PULocationID == input.PULocationID
select new
{
taxi.PULocationID, taxi.DOLocationID
}).Take(5).ToList();
response.ForEach(p =>
{
var puLocation = _operationLocation.GetByLocationId(p.PULocationID);
var doLocation = _operationLocation.GetByLocationId(p.DOLocationID);
var puLocationCoordinate = _coordinateDal.GetCoordinate(puLocation);
var doLocationCoordinate = _coordinateDal.GetCoordinate(doLocation);
result.Add(new TypeThree_ArticleTwo
{
PULocation = string.Join(" - ", puLocation.Borough, puLocation.Zone),
PULocationCoordinate = puLocationCoordinate,
DOLocation = string.Join(" - ", doLocation.Borough, doLocation.Zone),
DOLocationCoordinate = doLocationCoordinate
});
});
return(result);
}
public List <TypeThree_ArticleOne> TypeThree_ArticleOne(TypeThree_ArticleOne_Input input)
{
var result = new List <TypeThree_ArticleOne>();
var response = (from taxi in FirebaseOperationDal.GetAll()
where taxi.tpep_pickup_datetime.Date == input.FirstDate.Date
select new
{
PUDatetime = taxi.tpep_pickup_datetime,
DODatetime = taxi.tpep_dropoff_datetime,
taxi.PULocationID,
taxi.DOLocationID,
taxi.trip_distance
}).OrderByDescending(p => p.trip_distance).Take(1).ToList();
response.ForEach(p =>
{
var puLocation = _operationLocation.GetByLocationId(p.PULocationID);
var doLocation = _operationLocation.GetByLocationId(p.DOLocationID);
var puLocationCoordinate = _coordinateDal.GetCoordinate(puLocation);
var doLocationCoordinate = _coordinateDal.GetCoordinate(doLocation);
result.Add(new TypeThree_ArticleOne
{
PUDatetime = p.PUDatetime,
DODatetime = p.DODatetime,
PULocation = string.Join(" - ", puLocation.Borough, puLocation.Zone),
DOLocationCoordinate = doLocationCoordinate,
PULocationCoordinate = puLocationCoordinate,
DOLocation = string.Join(" - ", doLocation.Borough, doLocation.Zone),
trip_distance = p.trip_distance
});
});
return(result);
}
public List <TypeThree_ArticleThree> TypeThree_ArticleThree()
{
var result = new List <TypeThree_ArticleThree>();
var response = (from taxi in FirebaseOperationDal.GetAll()
where taxi.passenger_count >= 3
select new
{
taxi.PULocationID,
taxi.DOLocationID,
taxi.trip_distance
}).OrderByDescending(p => p.trip_distance).ToList();
result.Add(new TypeThree_ArticleThree
{
longest_trip = new row
{
PULocationCoordinate =
_coordinateDal.GetCoordinate(_operationLocation.GetByLocationId(response.First().PULocationID)),
DOLocationCoordinate =
_coordinateDal.GetCoordinate(_operationLocation.GetByLocationId(response.First().DOLocationID)),
PULocation = string.Join(" - ",
_operationLocation.GetByLocationId(response.First().PULocationID).Borough,
_operationLocation.GetByLocationId(response.First().PULocationID).Zone),
DOLocation = string.Join(" - ",
_operationLocation.GetByLocationId(response.First().DOLocationID).Borough,
_operationLocation.GetByLocationId(response.First().DOLocationID).Zone),
trip_distance = response.First().trip_distance
},
shortest_trip = new row
{
PULocationCoordinate =
_coordinateDal.GetCoordinate(_operationLocation.GetByLocationId(response.Last().PULocationID)),
DOLocationCoordinate =
_coordinateDal.GetCoordinate(_operationLocation.GetByLocationId(response.Last().DOLocationID)),
PULocation = string.Join(" - ",
_operationLocation.GetByLocationId(response.Last().PULocationID).Borough,
_operationLocation.GetByLocationId(response.Last().PULocationID).Zone),
DOLocation = string.Join(" - ",
_operationLocation.GetByLocationId(response.Last().DOLocationID).Borough,
_operationLocation.GetByLocationId(response.Last().DOLocationID).Zone),
trip_distance = response.Last().trip_distance
}
});
return(result);
}
public List <TypeTwo_ArticleOne> TypeTwo_ArticleOne(TypeTwo_ArticleOne_Input input)
{
var result = new List <TypeTwo_ArticleOne>();
var response = new
{
taxi_count = (from taxi in FirebaseOperationDal.GetAll()
where taxi.tpep_pickup_datetime >= input.FirstDate &&
taxi.tpep_pickup_datetime <= input.SecondDate &&
taxi.PULocationID == input.PULocationID
select new { id = taxi.passenger_count }).Count()
};
result.Add(new TypeTwo_ArticleOne
{
taxi_count = response.taxi_count
});
return(result);
}
public List <TypeOne_ArticleThree> TypeOne_ArticleThree()
{
var result = new List <TypeOne_ArticleThree>();
var response = (from taxi in FirebaseOperationDal.GetAll()
select new
{
PUDatetime = taxi.tpep_pickup_datetime, taxi.trip_distance
}).OrderByDescending(p => p.trip_distance).Take(5).ToList();
response.ForEach(p =>
{
result.Add(new TypeOne_ArticleThree
{
PUDatetime = p.PUDatetime,
trip_distance = p.trip_distance
});
});
return(result);
}
public List <TypeOne_ArticleOne> TypeOne_ArticleOne()
{
var result = new List <TypeOne_ArticleOne>();
var response = (from taxi in FirebaseOperationDal.GetAll()
group taxi by taxi.tpep_pickup_datetime.Date
into g
select new
{
PUDatetime = g.Key,
passenger_count = g.Sum(p => p.passenger_count)
}).OrderByDescending(p => p.passenger_count).Take(5).ToList();
response.ForEach(p =>
{
result.Add(new TypeOne_ArticleOne
{
PUDatetime = p.PUDatetime,
passenger_count = p.passenger_count
});
});
return(result);
}
public List <TypeOne_ArticleTwo> TypeOne_ArticleTwo(TypeOne_ArticleTwo_Input input)
{
var result = new List <TypeOne_ArticleTwo>();
var response = (from taxi in FirebaseOperationDal.GetAll()
where taxi.trip_distance < input.distance
group taxi by taxi.tpep_pickup_datetime
into g
select new
{
PUDatetime = g.Key,
trip_distance = g.Sum(p => p.trip_distance)
}).OrderByDescending(p => p.trip_distance).Take(5).ToList();
response.ForEach(p =>
{
result.Add(new TypeOne_ArticleTwo
{
PUDatetime = p.PUDatetime,
trip_distance = p.trip_distance
});
});
return(result);
}