public static Guid getIDByBarcode(string barcode) { using (SqlCommand cmd = new SqlCommand("sale_get_id_by_barcode", DBConnection.ActiveSqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@barcode", SqlDbType.Int).Value = Tools.getInt(barcode); return(new Guid(cmd.ExecuteScalar().ToString())); } }