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