public IList <Location> ListSalvageLocation(SalvageCompany salvage) { IList <Location> listSalvageLocation = null; try { listSalvageLocation = this._workrepository.SalvageCompanyRepository.ListSalvageLocation(salvage); } catch (Exception ex) { throw ex; } return(listSalvageLocation); }
public IList <Location> ListSalvageLocation(SalvageCompany salvage) { try { var @param = new { id = salvage.Id }; var salvageDictionary = new Dictionary <int, Location>(); IList <Location> _salvageLocation = this.Conexao .Query <Location, LocationDetail, Location> ( @"SELECT L.IDLOCATION ID, L.STATE STATE, L.CITY CITY, L.EMAIL EMAIL, D.IDLOCATIONDETAIL IDLOCATIONDETAIL, D.IDLOCATIONDETAIL ID, D.STREET STREET, D.DISTRICT DISTRICT, D.ZIPCODE ZIPCODE, D.EMAIL EMAIL, D.FONE FONE, D.FAX FAX, D.MANAGER MANAGER, D.LATITUDE LATITUDE, D.LONGITUDE LONGITUDE FROM [SALVAGE] S INNER JOIN [LOCATION] L ON S.IDSALVAGE = L.IDSALVAGE INNER JOIN [LOCATIONDETAIL] D ON L.IDLOCATION = D.IDLOCATION WHERE S.IDSALVAGE = @ID ", (salvageLocation, salvageLocationDetail) => { Location orderSalvageLocation; if (!salvageDictionary.TryGetValue(salvageLocation.Id, out orderSalvageLocation)) { orderSalvageLocation = salvageLocation; orderSalvageLocation.Detail = new List <LocationDetail>(); salvageDictionary.Add(orderSalvageLocation.Id, orderSalvageLocation); } orderSalvageLocation.Detail.Add(salvageLocationDetail); return(orderSalvageLocation); }, splitOn: "IDLOCATIONDETAIL", param: param, transaction: this.Transacao ) .Distinct() .ToList(); return(_salvageLocation); } catch (Exception ex) { throw ex; } }