public void Reset(int gtinId)
{
const string commandText = @"Delete From chz_scanned_sgtins
Where chz_gtin_id = @chz_gtin_id";
var parameter = new GtinIdParameter()
{
Id = gtinId
};
var transaction = Transact <SgtinModel> .Create(ConnectionString, commandText, parameter : parameter);
transaction.ExecuteNonQuery();
}
public IEnumerable <SgtinModel> Get(int gtinId)
{
const string commandText = @"Select chz_sgtin_id,sgtin
From chz_sgtins
Where chz_gtin_id=1";
var parameter = new GtinIdParameter()
{
Id = gtinId
};
var transaction = Transact <SgtinModel> .Create(ConnectionString, commandText, parameter : parameter);
return(transaction.ExecuteReader());
}
public bool MatchCheck(int gtin)
{
const string commandText = @"Select Count(*) As count,
(Select Count(*) From chz_sgtins Inner Join chz_scanned_sgtins On chz_sgtins.sgtin=chz_scanned_sgtins.sgtin) As match_count
From chz_sgtins
Where chz_sgtins.chz_gtin_id=@chz_gtin_id";
var parameter = new GtinIdParameter()
{
Id = gtin
};
var transaction = Transact <MatchCheckResult> .Create(ConnectionString, commandText, parameter : parameter);
var result = transaction.ExecuteReader().First();
return(result.Count == result.MatchCount);
}