public Task <IEnumerable <AssetDeviceDto> > Fetch(string assetUIDs)
{
TraceMessage("Started Fetching AssetDevice Details");
string query = string.Format(Queries.FetchAssetDeviceWithAssetUID, assetUIDs);
TraceMessage(query);
return(_transactions.GetAsync <AssetDeviceDto>(query));
}
public async Task <IEnumerable <Customer> > GetCustomerInfo(IEnumerable <Guid> customerUids)
{
return(await _transactions.GetAsync <Customer>(string.Format(
"SELECT HEX(CustomerUID) as CustomerUID, CustomerName from md_customer_Customer where CustomerUID IN ({0})",
string.Join(",", customerUids.Select(x => "UNHEX('" + x + "')")).Replace("-", string.Empty))));
}
