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); }