public static ICollection<TripModel> GetTripModelItems()
{
var ctx = new EFContext();
ICollection<Trip> TripData = new Collection<Trip>();
ICollection<Auto> AutoData = new Collection<Auto>();
ICollection<Employee> EmployeeData = new Collection<Employee>();
ICollection<TripModel> TripModelData = new Collection<TripModel>();
foreach (var itemTrip in ctx.Trips)
{
TripData.Add(itemTrip);
}
foreach (var itemAuto in ctx.Autoes)
{
AutoData.Add(itemAuto);
}
foreach (var itemEmployee in ctx.Employees)
{
EmployeeData.Add(itemEmployee);
}
foreach (var itemTripData in TripData)
{
TripModelData.Add(new TripModel(itemTripData, AutoData, EmployeeData));
}
return TripModelData;
}
public static ICollection<TripModel> GetTripModelItems(DateTime startdate, DateTime enddate)
{
var ctx = new EFContext();
ICollection<Trip> TripData = new Collection<Trip>();
ICollection<Auto> AutoData = new Collection<Auto>();
ICollection<Employee> EmployeeData = new Collection<Employee>();
ICollection<TripModel> TripModelData = new Collection<TripModel>();
foreach (var itemTrip in ctx.Trips)
{
TripData.Add(itemTrip);
}
foreach (var itemAuto in ctx.Autoes)
{
AutoData.Add(itemAuto);
}
foreach (var itemEmployee in ctx.Employees)
{
EmployeeData.Add(itemEmployee);
}
foreach (var itemTripData in TripData)
{
if (itemTripData.StartDate == startdate && itemTripData.EndDate == enddate)
TripModelData.Add(new TripModel(itemTripData, AutoData, EmployeeData));
}
return TripModelData;
}
