public List <IDomainObject> GetReaderResult(SqlDataReader reader)
{
List <IDomainObject> list = new List <IDomainObject>();
while (reader.Read())
{
Engagement u = new Engagement
{
ID = reader.GetInt32(0),
DateFrom = reader.GetDateTime(1),
DateTo = reader.GetDateTime(2),
Salary = reader.GetInt32(3),
Workplace = new Workplace
{
ID = reader.GetInt32(4)
},
Sailor = new Sailor
{
ID = reader.GetInt32(5)
}
};
list.Add(u);
}
return(list);
}
public List <IDomainObject> GetReaderResultJoin(SqlDataReader reader)
{
List <IDomainObject> list = new List <IDomainObject>();
while (reader.Read())
{
Engagement e = new Engagement
{
Member = new Member
{
ID = reader.GetInt32(0),
Name = reader.GetString(4),
Surname = reader.GetString(5),
DateOfMembership = reader.GetDateTime(6),
NumberOfPoints = reader.GetInt32(7),
City = new City
{
ID = reader.GetInt32(8)
},
MembershipStatus = new MembershipStatus
{
ID = reader.GetInt32(9)
}
},
Activity = new Activity
{
ID = reader.GetInt32(1),
Name = reader.GetString(11),
NumberOfPoints = reader.GetInt32(12),
Description = reader.GetString(13),
City = new City
{
ID = reader.GetInt32(14)
},
Type = new TypeOfActivity
{
ID = reader.GetInt32(15)
}
},
StartDate = reader.GetDateTime(2),
};
list.Add(e);
}
return(list);
}
public List <IDomainObject> GetReaderResultJoin(SqlDataReader reader)
{
List <IDomainObject> list = new List <IDomainObject>();
while (reader.Read())
{
Engagement u = new Engagement
{
ID = reader.GetInt32(0),
DateFrom = reader.GetDateTime(1),
DateTo = reader.GetDateTime(2),
Salary = reader.GetInt32(3),
Workplace = new Workplace
{
ID = reader.GetInt32(4),
Company = new Company
{
ID = reader.GetInt32(7)
},
Name = reader.GetString(8),
NumberOfPlaces = reader.GetInt32(9)
},
Sailor = new Sailor
{
ID = reader.GetInt32(5),
Username = reader.GetString(11),
Password = reader.GetString(12),
Name = reader.GetString(13),
Surname = reader.GetString(14),
Email = reader.GetString(15),
NumberOfMaritimeLicence = reader.GetString(16),
Country = new Country
{
ID = reader.GetInt32(17)
},
SailorRank = new SailorRank
{
ID = reader.GetInt32(18)
}
}
};
list.Add(u);
}
return(list);
}
public List <IDomainObject> GetReaderResult(SqlDataReader reader)
{
List <IDomainObject> list = new List <IDomainObject>();
while (reader.Read())
{
Engagement e = new Engagement
{
Member = new Member
{
ID = reader.GetInt32(0),
},
Activity = new Activity
{
ID = reader.GetInt32(1),
},
StartDate = reader.GetDateTime(2),
};
list.Add(e);
}
return(list);
}
