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