private async Task <List <Plan> > GetPlans(string employeeId)
{
var parameters = new { CrewId = employeeId };
string commandText = "SELECT TOP 100 [PK_Plan] as Id,[Month],[WeekNumber],[DayOfWeek] as Day FROM [HMS].[VW_PLAN] where PK_Plan = @CrewId";
//string sql = @"select top 1 Name,rank as Contact from HMS.VW_PERSONALDETAILS where personal_id=@PersonalId";
IEnumerable <Plan> result = await adapter.List <Plan>(commandText, parameters);
foreach (var plan in result)
{
plan.FlightDetails = await GetFlightDetails(plan.Id);
}
return(result.ToList());
}