public int GetProductIdentification(string incompleteBarcode)
{
using (var pDb = new PetaPoco.Database(Connection, "System.Data.SqlClient"))
{
pDb.CommandTimeout = 5 * 60;
string completeBarcode = BarcodeHelper.AddCheckDigitToBarcode(incompleteBarcode);
int match = pDb.FirstOrDefault <int>("SELECT PRODUCTID FROM PRODUCTBARCODE WHERE BARCODE = @0", completeBarcode);
return(match);
}
}
private string CompleteBarcode(string s)
{
return(BarcodeHelper.AddCheckDigitToBarcode(s));
}
