public IEnumerable <Sgtin> Get(int naklItemId)
{
const string commandText = @"Select value From chz_scanned_sgtins
Where chz_nakl_item_id=@chz_nakl_item_id";
var parameter = new NaklItemIdParameter()
{
Id = naklItemId
};
var transaction = Transact <Sgtin> .Create(ConnectionString, commandText, parameter : parameter);
return(transaction.ExecuteReader());
}
public int GetNaklAcceptTypeId(int naklItemId)
{
const string commandText = @"Select chz_nakls__list_of_accept_type_id
From chz_nakl_items Inner Join chz_nakls On chz_nakl_items.chz_nakl_id=chz_nakls.chz_nakl_id
Where chz_nakl_items.chz_nakl_item_id = @chz_nakl_item_id";
var parameter = new NaklItemIdParameter()
{
Id = naklItemId
};
var transaction = Transact <object> .Create(ConnectionString, commandText, parameter : parameter);
return(transaction.ExecuteScalar <int>());
}
public IEnumerable <SgtinResult> GetStinResult(int naklItemId)
{
const string commandText = @"Select chz_sgtins.sgtin As provider_sgtin, chz_scanned_sgtins.value As recesiver_sgtin
From chz_sgtins FULL OUTER JOIN chz_scanned_sgtins On chz_sgtins.sgtin=chz_scanned_sgtins.value
Where chz_sgtins.chz_nakl_item_id = @chz_nakl_item_id Or chz_scanned_sgtins.chz_nakl_item_id = @chz_nakl_item_id";
var parameter = new NaklItemIdParameter()
{
Id = naklItemId
};
var transaction = Transact <SgtinResult> .Create(ConnectionString, commandText, parameter : parameter);
return(transaction.ExecuteReader());
}